protected void RadDataForm1_ItemCreated(object sender, Telerik.Web.UI.RadDataFormItemEventArgs e)
{
if (e.Item is RadDataFormDataItem && !(e.Item.IsInEditMode))
{
RadDataFormDataItem item = e.Item as RadDataFormDataItem;
RadComboBox RadItemDpdBrch1 = (RadComboBox)item.FindControl("RadItemDpdBrch1");
qry = "Execute PROC_GET_BRANCH";
Cn = new SqlConnection(constsql);
myda = new SqlDataAdapter(qry, Cn);
ds = new DataSet();
myda.Fill(ds);
RadItemDpdBrch1.DataSource = ds.Tables[0];
RadItemDpdBrch1.DataTextField = ds.Tables[0].Columns["BranchName"].ColumnName.ToString();
RadItemDpdBrch1.DataValueField = ds.Tables[0].Columns["BRANCHID"].ColumnName.ToString();
RadItemDpdBrch1.DataBind();
RadDataFormDataItem items = e.Item as RadDataFormDataItem;
RadComboBox RadItemDpdDpt1 = (RadComboBox)items.FindControl("RadItemDpdDpt1");
qry2 = "SELECT DepartmentID,DepartmentName FROM Department";
myda2 = new SqlDataAdapter(qry2, Cn);
ds2 = new DataSet();
myda2.Fill(ds2);
RadItemDpdDpt1.DataSource = ds2.Tables[0];
RadItemDpdDpt1.DataTextField = ds2.Tables[0].Columns["DepartmentName"].ColumnName.ToString();
RadItemDpdDpt1.DataValueField = ds2.Tables[0].Columns["DepartmentID"].ColumnName.ToString();
RadItemDpdDpt1.DataBind();
}
else if (e.Item.IsInEditMode || (e.Item is RadDataFormEditableItem))
{
// edit template control
RadDataFormEditableItem item = e.Item as RadDataFormEditableItem;
RadComboBox RadItemDpdBrch2 = (RadComboBox)item.FindControl("RadItemDpdBrch2");
qry = "Execute PROC_GET_BRANCH";
Cn = new SqlConnection(constsql);
myda = new SqlDataAdapter(qry, Cn);
ds = new DataSet();
myda.Fill(ds);
RadItemDpdBrch2.DataSource = ds.Tables[0];
RadItemDpdBrch2.DataTextField = ds.Tables[0].Columns["BranchName"].ColumnName.ToString();
RadItemDpdBrch2.DataValueField = ds.Tables[0].Columns["BRANCHID"].ColumnName.ToString();
RadItemDpdBrch2.DataBind();
RadDataFormDataItem items = e.Item as RadDataFormDataItem;
RadComboBox RadItemDpdDpt2 = (RadComboBox)items.FindControl("RadItemDpdDpt2");
qry2 = "SELECT DepartmentID,DepartmentName FROM Department";
myda2 = new SqlDataAdapter(qry2, Cn);
ds2 = new DataSet();
myda2.Fill(ds2);
RadItemDpdDpt2.DataSource = ds2.Tables[0];
RadItemDpdDpt2.DataTextField = ds2.Tables[0].Columns["DepartmentName"].ColumnName.ToString();
RadItemDpdDpt2.DataValueField = ds2.Tables[0].Columns["DepartmentID"].ColumnName.ToString();
RadItemDpdDpt2.DataBind();
}
}
protected void RadDataForm1_ItemInserting(object sender, Telerik.Web.UI.RadDataFormCommandEventArgs e)
{
RadDataFormEditableItem insertedItem = e.DataFormItem as RadDataFormEditableItem;
Hashtable newValues = new Hashtable();
insertedItem.ExtractValues(newValues);
try
{
RadComboBox RadItemDpdDpt3 = (RadComboBox)insertedItem.FindControl("RadItemDpdDpt3");
RadComboBox RadItemDpdBrch3 = (RadComboBox)insertedItem.FindControl("RadItemDpdBrch3");
CheckBox IsActionOwnerChk2s = (CheckBox)insertedItem.FindControl("IsActionOwnerChk2");
string email = newValues["EMAIL"].ToString();
string lastname = PropCase(newValues["LastName"].ToString());
string username = newValues["USER_NAME"].ToString();
string FirstName = PropCase(newValues["FirstName"].ToString());
int deptid = Convert.ToInt32(RadItemDpdDpt3.SelectedValue);
int brchid = Convert.ToInt32(RadItemDpdBrch3.SelectedValue);
bool IsActionOwnerChk2 = IsActionOwnerChk2s.Checked;
if (IsActionOwnerChk2 == true)
{
IsActionOwnerChkss = "Yes";
}
else
{
IsActionOwnerChkss = "No";
}
qry = "INSERT INTO USERS(DEPARTMENTID,BRANCHID,USER_NAME,EMAIL,LASTNAME,FIRSTNAME,IsActionOwner)VALUES(" + Convert.ToInt32(RadItemDpdDpt3.SelectedValue) + ", " + Convert.ToInt32(RadItemDpdBrch3.SelectedValue) + ",'" + newValues["USER_NAME"].ToString() + "','" + newValues["EMAIL"].ToString() + "','" + PropCase(newValues["LastName"].ToString()) + "','" + PropCase(newValues["FirstName"].ToString()) + "','" + IsActionOwnerChkss + "')";
con.SqlDs(qry, 1);
}
catch (Exception ex)
{
con.insertError(ex.Message);
e.Canceled = true;
}
LoadDataForRadGrid1();
RadGrid1.DataBind();
}
protected void RadDataForm1_ItemUpdating(object sender, Telerik.Web.UI.RadDataFormCommandEventArgs e)
{
RadDataFormEditableItem editedItem = e.DataFormItem as RadDataFormEditableItem;
Hashtable newValues = new Hashtable();
editedItem.ExtractValues(newValues);
DataTable productsTable = SourceDataTable;
DataRow[] changedRows = productsTable.Select("USER_NAME = '" + editedItem.GetDataKeyValue("USER_NAME") + "'");
if (changedRows.Length != 1)
{
e.Canceled = true;
return;
}
try
{
RadComboBox RadItemDpdDpt2 = (RadComboBox)editedItem.FindControl("RadItemDpdDpt2");
RadComboBox RadItemDpdBrch2 = (RadComboBox)editedItem.FindControl("RadItemDpdBrch2");
CheckBox ResetPassCheckBox = (CheckBox)editedItem.FindControl("ResetPassCheckBox1");
CheckBox IsActionOwnerChk = (CheckBox)editedItem.FindControl("IsActionOwnerChk1");
string email = newValues["EMAIL"].ToString();
string lastname = newValues["LastName"].ToString();
string username = newValues["USER_NAME"].ToString();
string FirstName = newValues["FirstName"].ToString();
int id = Convert.ToInt32(newValues["USERID"]);
int deptid = Convert.ToInt32(RadItemDpdDpt2.SelectedValue);
int brchid = Convert.ToInt32(RadItemDpdBrch2.SelectedValue);
bool chkedpass = ResetPassCheckBox.Checked;
bool IsActionOwnerChks = IsActionOwnerChk.Checked;
if (IsActionOwnerChks == true)
{
IsActionOwnerChkss = "Yes";
}
else
{
IsActionOwnerChkss = "No";
}
if (chkedpass == true)
{
passwords = Users.Users.Encrypt("123456", true);
foreach (DictionaryEntry entry in newValues)
{
qrys = "UPDATE USERS SET IsActionOwner='" + IsActionOwnerChkss + "',PASSWORD='******', DEPARTMENTID=" + Convert.ToInt32(RadItemDpdDpt2.SelectedValue) + ", BRANCHID=" + Convert.ToInt32(RadItemDpdBrch2.SelectedValue) + ", USER_NAME= '" + newValues["USER_NAME"].ToString() + "',EMAIL= '" + newValues["EMAIL"].ToString() + "',LASTNAME= '" + PropCase(newValues["LastName"].ToString()) + "',FIRSTNAME= '" + PropCase(newValues["FirstName"].ToString()) + "' WHERE USERID=" + Convert.ToInt32(newValues["USERID"]) + "";
con.SqlDs(qrys, 1);
}
}
else
{
foreach (DictionaryEntry entry in newValues)
{
qrys = "UPDATE USERS SET IsActionOwner='" + IsActionOwnerChkss + "',DEPARTMENTID=" + Convert.ToInt32(RadItemDpdDpt2.SelectedValue) + ", BRANCHID=" + Convert.ToInt32(RadItemDpdBrch2.SelectedValue) + ", USER_NAME= '" + newValues["USER_NAME"].ToString() + "',EMAIL= '" + newValues["EMAIL"].ToString() + "',LASTNAME= '" + PropCase(newValues["LastName"].ToString()) + "',FIRSTNAME= '" + PropCase(newValues["FirstName"].ToString()) + "' WHERE USERID=" + Convert.ToInt32(newValues["USERID"]) + "";
con.SqlDs(qrys, 1);
}
}
}
catch (Exception ex)
{
con.insertError(ex.Message);
changedRows[0].CancelEdit();
e.Canceled = true;
}
LoadDataForRadGrid1();
RadGrid1.DataBind();
}