private void InitialiseDropDownlist(List <dynamic> temp)
{
#region From XML
CountriesDropDownlist.DataSource = (temp).ToList();
CountriesDropDownlist.DataTextField = "Text";
CountriesDropDownlist.DataValueField = "Value";
CountriesDropDownlist.DataBind();
#endregion
#region From SQL
DataAccessServiceClient cl = new DataAccessServiceClient();
EmployeeDataContract edc = cl.GetEmployeeData(0);
DropDownListSql.DataTextField = "Name";
DropDownListSql.DataValueField = "Id";
DropDownListSql.DataSource = edc.Employees.ToList();
DropDownListSql.DataBind();
#endregion
}
/// <summary>
/// Event Hhandler for Insert Command
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem gei = e.Item as GridEditableItem;
Dictionary <string, string> newValues = new Dictionary <string, string>();
e.Item.OwnerTableView.ExtractValuesFromItem(newValues, gei);
edc = GetAppropriateDataObject();
edc.Employees.Add(new BusinessEntities.Employee()
{
Id = edc.Employees.Max(p => p.Id) + 1,
Job = newValues["Job"].ToString(),
ManagerName = newValues["ManagerName"].ToString(),
Name = newValues["Name"].ToString(),
Salary = double.Parse(newValues["Salary"].ToString())
});
Session["data"] = edc;
}
/// <summary>
/// Event handler for Delete Command
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RadGrid1_DeleteCommand(object sender, GridCommandEventArgs e)
{
GridDataItem gdi = e.Item as GridDataItem;
int Id = (int)gdi.GetDataKeyValue("Id");
edc = GetAppropriateDataObject();
EmployeeDataContract temp = new EmployeeDataContract();
temp.Employees = new List <Employee>();
foreach (Employee item in edc.Employees)
{
if (item.Id == Id)
{
continue;
}
temp.Employees.Add(item);
}
edc = temp;
Session["data"] = edc;
}
protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem gei = e.Item as GridEditableItem;
string Id = (gei["IdUnique"].FindControl("IdLabel") as Label).Text;
string Name = (gei["NameUnique"].FindControl("NameTextBox") as TextBox).Text;
string Job = (gei["JobUnique"].FindControl("JobTextBox") as TextBox).Text;
string Salary = (gei["SalaryUnique"].FindControl("SalaryTextBox") as TextBox).Text;
//string Manager = (gei["ManagerNameUnique"].FindControl("ManagerTextBox") as TextBox).Text;
string Manager = (gei["ManagerNameUnique"].
FindControl("ManagerRadComboBox") as RadComboBox).SelectedValue;
EmployeeDataContract edc = GetAppropriateDataObject();
edc.Employees = (edc.Employees.Select(item =>
{
Employee emp = item;
if (item.Id.ToString() == Id)
{
if (item.ManagerName != Manager)
{
emp.ManagerName = Manager;
}
if (item.Job != Job)
{
emp.Job = Job;
}
if (item.Name != Name)
{
emp.Name = Name;
}
if (item.Salary.ToString() != Salary)
{
emp.Salary = double.Parse(Salary);
}
}
return(emp);
})).ToList <Employee>();
Session["data"] = edc;
}
protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem gei = e.Item as GridEditableItem;
string _Id = (gei["IdUnique"].FindControl("IdTextBox") as TextBox).Text;
string _Name = (gei["NameUnique"].FindControl("NameTextBox") as TextBox).Text;
string _Job = (gei["JobUnique"].FindControl("JobTextBox") as TextBox).Text;
string _Salary = (gei["SalaryUnique"].FindControl("SalaryTextBox") as TextBox).Text;
string _Manager = (gei["ManagerNameUnique"].
FindControl("ManagerRadComboBox") as RadComboBox).SelectedValue;
EmployeeDataContract edc = GetAppropriateDataObject();
edc.Employees.Add(new Employee()
{
Id = int.Parse(_Id == "" ? "0" : _Id),
Name = _Name ?? "",
Job = _Job ?? "",
Salary = double.Parse(_Salary == "" ? "0" : _Salary),
ManagerName = _Manager ?? ""
});
Session["data"] = edc;
}
protected void RadGrid1_NeedDataSource1(object sender, GridNeedDataSourceEventArgs e)
{
edc = GetAppropriateDataObject();
Session["data"] = edc;
((RadGrid)sender).DataSource = edc.Employees;
}
