protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "alpha" || e.CommandName == "NoFilter") { String value = null; switch (e.CommandName) { case ("alpha"): { value = string.Format("{0}%", e.CommandArgument); break; } case ("NoFilter"): { value = "%"; break; } } ObjectDataSource1.SelectParameters["LastName"].DefaultValue = value; ObjectDataSource1.DataBind(); RadGrid1.Rebind(); } else if (e.CommandName == "QuickUpdate") { string UserName, Role; var oUser = new User(); foreach (GridDataItem item in RadGrid1.Items) { UserName = item.GetDataKeyValue("UserName").ToString(); Role = ((RadComboBox)item.FindControl("ddlRole")).SelectedValue; oUser.ChangeRole(UserName, Role); } } else if (e.CommandName == "DeleteSelected") { var oAddressBook1 = new AddressBook1(); var oUser = new User(); string errorList = "", UserName = ""; foreach (GridDataItem item in RadGrid1.SelectedItems) { try { var AddressBookID = item.GetDataKeyValue("AddressBookID").ToString(); UserName = item["UserName"].Text; oAddressBook1.AddressBook1Delete(AddressBookID); oUser.UserDelete(UserName); } catch (Exception ex) { lblError.Text = ex.Message; if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString()) { errorList += ", " + UserName; } } } if (!string.IsNullOrEmpty(errorList)) { e.Canceled = true; string strAlertMessage = "Tài khoản <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang có đơn hàng .<br /> Xin xóa đơn hàng hoặc sử dụng chức năng khoá tài khoản."; lblError.Text = strAlertMessage; } RadGrid1.Rebind(); } else if (e.CommandName == "PerformInsert" || e.CommandName == "Update") { try { var command = e.CommandName; var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item; var DistrictID = ((RadComboBox)row.FindControl("ddlDistrict")).SelectedValue; var ProvinceID = ((RadComboBox)row.FindControl("ddlProvince")).SelectedValue; var RoleName = ((RadComboBox)row.FindControl("ddlRole")).SelectedValue; var UserName = ((RadTextBox)row.FindControl("txtUserName")).Text; var IsPrimary = "True"; var CountryID = "1"; var oUser = new User(); if (e.CommandName == "PerformInsert") { var insertParams = ObjectDataSource1.InsertParameters; insertParams["CountryID"].DefaultValue = CountryID; insertParams["ProvinceID"].DefaultValue = ProvinceID; insertParams["DistrictID"].DefaultValue = DistrictID; insertParams["RoleName"].DefaultValue = RoleName; insertParams["IsPrimary"].DefaultValue = IsPrimary; oUser.ChangeRole(UserName, RoleName); } else { var updateParams = ObjectDataSource1.UpdateParameters; updateParams["CountryID"].DefaultValue = CountryID; updateParams["ProvinceID"].DefaultValue = ProvinceID; updateParams["DistrictID"].DefaultValue = DistrictID; updateParams["RoleName"].DefaultValue = RoleName; updateParams["IsPrimary"].DefaultValue = IsPrimary; oUser.ChangeRole(UserName, RoleName); } } catch (Exception ex) { lblError.Text = ex.Message; } } }