private void BindAssignRoleList_ByUserID(int UserId, int CompanyId) { UserMasterDal ObjUserMasterDal = new UserMasterDal(); lstAssignRole.Items.Clear(); lstAssignRole.ClearSelection(); lstAssignRole.DataTextField = "ROLE_NAME"; lstAssignRole.DataValueField = "ROLE_ID"; lstAssignRole.DataSource = ObjUserMasterDal.GetAssignedRoleList_ByUserID(UserId, CompanyId); lstAssignRole.DataBind(); }
private void BindEmployeeCombo(RadComboBox sender) { objUserMasterDAL = new UserMasterDal(); sender.Items.Clear(); sender.ClearSelection(); sender.DataTextField = "EMP_NAME"; sender.DataValueField = "EMP_ID"; sender.DataSource = objUserMasterDAL.GetEmployeeKeyValue(); sender.DataBind(); sender.Items.Insert(0, new RadComboBoxItem("", "0")); sender.SelectedValue = "0"; }
private void BindAssignCompanyList_ByUserID(int UserId) { UserMasterDal ObjUserMasterDal = new UserMasterDal(); lstAssignCompanyName.Items.Clear(); lstAssignCompanyName.ClearSelection(); lstAssignCompanyName.DataTextField = "COMPANY_NAME"; lstAssignCompanyName.DataValueField = "COMPANY_ID"; lstAssignCompanyName.DataSource = ObjUserMasterDal.GetAssignedCompanyList_ByUserID(UserId); lstAssignCompanyName.DataBind(); }
/// <summary> /// Bind customer grid /// </summary> private void BindGrid() { objUserMasterDAL = new UserMasterDal(); DataSet dsCustomer = objUserMasterDAL.GetUser(); radgrdUser.DataSource = dsCustomer; radgrdUser.DataBind(); ViewState[vsUser] = dsCustomer; }
private void BindSecurityQuestionCombo(RadComboBox sender) { objUserMasterDAL = new UserMasterDal(); sender.Items.Clear(); sender.ClearSelection(); sender.DataTextField = "SECURITY_QUESTION_DESC"; sender.DataValueField = "SECURITY_QUESTION_ID"; sender.DataSource = objUserMasterDAL.GetSecurityQuestion(); sender.DataBind(); sender.Items.Insert(0, new RadComboBoxItem("--Select--", "0")); sender.SelectedValue = "0"; }
/// <summary> /// Action bar's save button event which saves grid data by xml. /// </summary> /// <param name="sender">The object which raised the event</param> /// <param name="e">The event listener object</param> protected void acbUser_SaveClick(object sender, EventArgs e) { int result = 0; objUserMasterDAL = new UserMasterDal(); switch (ucControlBox.SaveButton.CommandName) { case "Save": objUserMasterBdto = new UserMasterBDto(); objUserMasterBdto.UserId = objAuthorizationBDto.UserProfile.UserId; objUserMasterBdto.UserName = txtUserName.Text; objUserMasterBdto.Password = txtPassword.Text; objUserMasterBdto.EmpID = int.Parse(ddlEmployeeName.SelectedValue); objUserMasterBdto.SecurityQusId = int.Parse(ddlSecurityQus.SelectedValue); objUserMasterBdto.SecurityQusAns = txtSecurityQusAns.Text; objUserMasterBdto.FromDate = Convert.ToDateTime(rdpFromDate.SelectedDate); objUserMasterBdto.ToDate = Convert.ToDateTime(rdpToDate.SelectedDate); result = objUserMasterDAL.InsertUser(objUserMasterBdto); GlobalUserId = result; GlobalEmpId = int.Parse(ddlEmployeeName.SelectedValue); if (result == -2) { Master.DisplayMessage("Username already exists. Record is not saved."); Master.MessageCssClass = "errorMessage"; } else if (result >= 1) { Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString()); Master.MessageCssClass = "successMessage"; BindGrid(); radTabStripe.FindTabByText("User Access").Enabled = true; FillCompanyLists(GlobalUserId, GlobalEmpId); BindRoleList(); } else { Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString()); Master.MessageCssClass = "errorMessage"; } break; case "Update": objUserMasterBdto = new UserMasterBDto(); objUserMasterDAL = new UserMasterDal(); //UpdateUser(); if (ViewState[PageConstants.vsItemIndexes] != null) { htItemIndex = (Hashtable)(ViewState[PageConstants.vsItemIndexes]); } if (htItemIndex != null) { GridDataItem item = radgrdUser.Items[int.Parse(htItemIndex[0].ToString())]; //Label lblGrdUserId = (Label)radgrdUser.Items[Convert.ToInt32(htItemIndex[0])].FindControl("lblGrdUserID"); objUserMasterBdto.m_UserId = int.Parse(item["USER_ID"].Text); objUserMasterBdto.UserId = objAuthorizationBDto.UserProfile.UserId; objUserMasterBdto.UserName = txtUserName.Text; objUserMasterBdto.Password = txtPassword.Text; objUserMasterBdto.EmpID = int.Parse(ddlEmployeeName.SelectedValue); objUserMasterBdto.SecurityQusId = int.Parse(ddlSecurityQus.SelectedValue); objUserMasterBdto.SecurityQusAns = txtSecurityQusAns.Text; objUserMasterBdto.FromDate = Convert.ToDateTime(rdpFromDate.SelectedDate); objUserMasterBdto.ToDate = Convert.ToDateTime(rdpToDate.SelectedDate); GlobalEmpId = int.Parse(ddlEmployeeName.SelectedValue); result = objUserMasterDAL.UpdateUser(objUserMasterBdto); if (result == 1) { acbUser.DefaultMode = true; Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Update].ToString()); Master.MessageCssClass = "successMessage"; if (ViewState[PageConstants.vsItemIndexes] != null) htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes]; for (int i = 0; i < htItemIndex.Count; i++) radgrdUser.Items[Convert.ToInt32(htItemIndex[i])].Edit = false; //bisEdit = true; ViewState[PageConstants.vsItemIndexes] = null; BindGrid(); radgrdUser.Rebind(); acbUser.Visible = true; pnlAddMode.Visible = false; pnlGrid.Visible = true; } else { Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Update].ToString()); Master.MessageCssClass = "errorMessage"; acbUser.Visible = true; pnlAddMode.Visible = false; } } break; case "Search": { //UserMasterBDto objUserMasterBDto = new UserMasterBDto(); //objUserMasterBDto.UserName = txtUserName.Text; //objUserMasterBDto.EmpID = int.Parse(ddlEmployeeName.SelectedValue); //objUserMasterBDto.SecurityQusId = int.Parse(ddlSecurityQus.SelectedValue); //objUserMasterBDto.SecurityQusAns = txtSecurityQusAns.Text; //objUserMasterBDto.FromDate = Convert.ToDateTime(rdpFromDate.SelectedDate); //objUserMasterBDto.ToDate = Convert.ToDateTime(rdpToDate.SelectedDate); //DataSet dsUser = objUserMasterDAL.GetUser(objUserMasterBDto); //if (dsUser != null && dsUser.Tables[0].Rows.Count > 0) //{ // radgrdUser.DataSource = dsUser; // radgrdUser.DataBind(); // ViewState[vsUser] = dsUser; // acbUser.Visible = true; // pnlAddMode.Visible = false; // pnlGrid.Visible = true; //} //else //{ // Master.DisplayMessage(ConfigurationSettings.AppSettings["NoRecord"].ToString()); // Master.MessageCssClass = "errorMessage"; //} break; } } }
/// <summary> /// Action bar's Search button event which search records from database. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void acbUser_SearchClick(object sender, EventArgs e) { #region OpenSearchInNewForm //acbUser.Visible = false; //pnlGrid.Visible = false; //ucControlBox.SaveButton.CommandName = "Search"; //ucControlBox.SaveButton.Text = "Search"; //ValidationGroupSearch(); //txtPassword.Enabled = false; //txtRetypePassword.Enabled = false; //pnlAddMode.Visible = true; //radMultiPage.SelectedIndex = 0; //radTabStripe.FindTabByText("User Access").Enabled = false; //radTabStripe.FindTabByText("User Info").Selected = true; //Reset(); //BindEmployeeCombo(ddlEmployeeName); //BindSecurityQuestionCombo(ddlSecurityQus); #endregion //// UserMasterBDto objUserMasterBDto = new UserMasterBDto(); UserMasterDal objUserMasterDal = new UserMasterDal(); objUserMasterBDto.UserName = acbUser.SearchTextBox.Text.Trim(); DataSet dsUser = objUserMasterDal.GetUserSearch(objUserMasterBDto); if (dsUser != null && dsUser.Tables[0].Rows.Count > 0) { radgrdUser.DataSource = dsUser; radgrdUser.DataBind(); ViewState[vsUser] = dsUser; } else { Master.DisplayMessage(ConfigurationSettings.AppSettings["NoRecord"].ToString()); Master.MessageCssClass = "errorMessage"; } }
/// <summary> /// Action bar's delete button event which delete records physically from database. /// </summary> /// <param name="sender">The object which raised the event</param> /// <param name="e">The event listener object</param> protected void acbUser_DeleteClick(object sender, EventArgs e) { StringBuilder UserId = new StringBuilder(); int result = 0; if (ViewState[PageConstants.vsItemIndexes] != null) htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes]; if (htItemIndex != null) { foreach (int i in htItemIndex.Values) { GridDataItem item = radgrdUser.Items[i]; UserId.Append(int.Parse(item["USER_ID"].Text) + ","); } } objUserMasterDAL = new UserMasterDal(); String Id = UserId.ToString().TrimEnd(','); result = objUserMasterDAL.DeleteUser(Id); if (result == 1) { Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Delete].ToString()); Master.MessageCssClass = "successMessage"; ViewState[PageConstants.vsItemIndexes] = null; BindGrid(); } else if (result == 547) { Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Delete].ToString()); Master.MessageCssClass = "errorMessage"; } }
public void UnAssignRole(int UserId, int CompanyId, int RoleId) { objUserMasterDAL = new UserMasterDal(); //int CreatedBy = objAuthorizationBDto.UserProfile.UserId; int result = objUserMasterDAL.UnAssignRole(UserId, CompanyId, RoleId); if (result >= 1) { Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString()); Master.MessageCssClass = "successMessage"; } else { Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString()); Master.MessageCssClass = "errorMessage"; } }
public void AssignCompany(string lst, int userid) { objUserMasterDAL = new UserMasterDal(); int CreatedBy = objAuthorizationBDto.UserProfile.UserId; int result = objUserMasterDAL.InsertAssignCompany(lst, userid, CreatedBy); if (result >= 1) { Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString()); Master.MessageCssClass = "successMessage"; } else { Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString()); Master.MessageCssClass = "errorMessage"; } }