using System; |
using System.Collections; |
using System.Configuration; |
using System.Data; |
using System.Linq; |
using System.Web; |
using System.Web.Security; |
using System.Web.UI; |
using System.Web.UI.HtmlControls; |
using System.Web.UI.WebControls; |
using System.Web.UI.WebControls.WebParts; |
using System.Xml.Linq; |
using Telerik.Web.UI; |
using System.Web.Configuration; |
using System.Data.SqlClient; |
using System.Collections.Specialized; |
|
public partial class Sample : System.Web.UI.Page |
{ |
string connectionString = WebConfigurationManager.ConnectionStrings["SchedulerConnectionString"].ConnectionString; |
|
protected void Page_Load(object sender, EventArgs e) |
{ |
RadScheduler RadScheduler1 = (RadScheduler)PanelBar_Scheduler.FindItemByValue("WeekScheduler").FindControl("RadScheduler1"); |
RadScheduler1.ResourceTypes.Clear(); |
string selectSQL = "Select * from Appointments"; |
SqlDataSource EmployeeSource = new SqlDataSource(connectionString, selectSQL); |
SqlDataSource EmployeeSource1 = new SqlDataSource(connectionString, selectSQL); |
selectSQL = "Select * from Employee"; |
SqlDataSource Empl = new SqlDataSource(connectionString, selectSQL); |
Empl.ID = "Employees"; |
selectSQL = "Select * from Resource"; |
SqlDataSource rsrc = new SqlDataSource(connectionString, selectSQL); |
rsrc.ID = "Resources"; |
RadScheduler1.DataSourceID = null; |
ResourceType radschedemp = new ResourceType(); |
radschedemp.ForeignKeyField = "Emp_ID"; |
radschedemp.TextField = "EmpName"; |
radschedemp.Name = "Employee1"; |
radschedemp.DataSource = Empl; |
radschedemp.KeyField = "ID"; |
ResourceType radschedres = new ResourceType(); |
radschedres.ForeignKeyField = "Resource_ID"; |
radschedres.TextField = "ResourceName"; |
radschedres.Name = "Resource1"; |
radschedres.DataSource = rsrc; |
radschedres.KeyField = "ID"; |
RadScheduler1.ResourceTypes.Add(radschedemp); |
RadScheduler1.ResourceTypes.Add(radschedres); |
RadScheduler1.DataStartField = "StartDate"; |
RadScheduler1.DataSubjectField = "Subject"; |
RadScheduler1.DataKeyField = "ID"; |
RadScheduler1.DataEndField = "EndDate"; |
RadScheduler1.GroupBy = "Date,Employee1"; |
RadScheduler1.DataSource = EmployeeSource; |
RadScheduler1.DataBind(); |
} |
|
class InlineInsertTemplate : IBindableTemplate |
{ |
private TextBox _textBox; |
private TextBox _textBox1; |
|
public void InstantiateIn(Control container) |
{ |
_textBox = new TextBox(); |
//_textBox.TextMode = TextBoxMode.MultiLine; |
_textBox.Width = Unit.Percentage(10); |
_textBox.BorderStyle = BorderStyle.Groove; |
|
container.Controls.Add(_textBox); |
|
_textBox1 = new TextBox(); |
//_textBox1.TextMode = TextBoxMode.MultiLine; |
_textBox1.Width = Unit.Percentage(10); |
_textBox1.BorderStyle = BorderStyle.Groove; |
|
container.Controls.Add(_textBox1); |
|
LinkButton insertButton = new LinkButton(); |
insertButton.Text = "Insert"; |
insertButton.CommandName = "Insert"; |
|
container.Controls.Add(insertButton); |
|
LinkButton cancelButton = new LinkButton(); |
cancelButton.Text = "Cancel"; |
cancelButton.CommandName = "Cancel"; |
|
container.Controls.Add(cancelButton); |
|
|
} |
|
public IOrderedDictionary ExtractValues(Control container) |
{ |
IOrderedDictionary result = new OrderedDictionary(); |
|
result.Add("Subject", _textBox.Text); |
result.Add("EmpName", _textBox1.Text); |
|
return result; |
} |
} |
|
protected override void OnInit(EventArgs e) |
{ |
base.OnInit(e); |
RadScheduler RadScheduler1 = (RadScheduler)PanelBar_Scheduler.FindItemByValue("WeekScheduler").FindControl("RadScheduler1"); |
RadScheduler1.InlineInsertTemplate = new InlineInsertTemplate(); |
} |
|
|
|
protected void UpdateScheduler(object sender, Telerik.Web.UI.RadRotatorEventArgs e) |
{ |
RadScheduler RadScheduler1 = (RadScheduler)PanelBar_Scheduler.FindItemByValue("WeekScheduler").FindControl("RadScheduler1"); |
RadScheduler1.ResourceTypes.Clear(); |
if (e.Item.BorderStyle == BorderStyle.Groove) |
{ |
e.Item.BorderStyle = BorderStyle.None; |
e.Item.BorderColor = System.Drawing.Color.White; |
} |
else |
{ |
e.Item.BorderStyle = BorderStyle.Groove; |
e.Item.BorderColor = System.Drawing.Color.Red; |
} |
|
string selectSQL = "Select * from Appointments Where Emp_ID =" + ((e.Item.Index) + 1); |
SqlDataSource EmployeeSource = new SqlDataSource(connectionString, selectSQL); |
SqlDataSource EmployeeSource1 = new SqlDataSource(connectionString, selectSQL); |
selectSQL = "Select * from Employee Where ID = " + ((e.Item.Index) + 1); |
SqlDataSource Empl = new SqlDataSource(connectionString, selectSQL); |
Empl.ID = "Employees"; |
selectSQL = "Select * from Resource"; |
SqlDataSource rsrc = new SqlDataSource(connectionString, selectSQL); |
rsrc.ID = "Resources"; |
RadScheduler1.DataSourceID = null; |
ResourceType radschedemp = new ResourceType(); |
radschedemp.ForeignKeyField = "Emp_ID"; |
radschedemp.TextField = "EmpName"; |
radschedemp.Name = "Employee1"; |
radschedemp.DataSource = Empl; |
radschedemp.KeyField = "ID"; |
ResourceType radschedres = new ResourceType(); |
radschedres.ForeignKeyField = "Resource_ID"; |
radschedres.TextField = "ResourceName"; |
radschedres.Name = "Resource1"; |
radschedres.DataSource = rsrc; |
radschedres.KeyField = "ID"; |
RadScheduler1.ResourceTypes.Add(radschedemp); |
RadScheduler1.ResourceTypes.Add(radschedres); |
RadScheduler1.DataStartField = "StartDate"; |
RadScheduler1.DataSubjectField = "Subject"; |
RadScheduler1.DataKeyField = "ID"; |
RadScheduler1.DataEndField = "EndDate"; |
RadScheduler1.GroupBy = "Date,Employee1"; |
RadScheduler1.DataSource = EmployeeSource; |
RadScheduler1.DataBind(); |
} |
|
|
} |