public void getDesignationName() { ApplicationResult objResult = new ApplicationResult(); Controls objControls = new Controls(); DesignationBL objDesignationBL = new DesignationBL(); objResult = objDesignationBL.Designation_SelectAll_ForDropDown(); if (objResult != null) { objControls.BindDropDown_ListBox(objResult.resultDT, ddlDesignation, "DesignationNameENG", "DesignationID"); if (objResult.resultDT.Rows.Count > 0) { } ddlDesignation.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1")); } }
public void BindDesignation() { ApplicationResult objResult = new ApplicationResult(); DesignationBL objDesignationbl = new DesignationBL(); objResult = objDesignationbl.Designation_SelectAll(); if (objResult.resultDT.Rows.Count > 0) { gvDesignation.DataSource = objResult.resultDT; gvDesignation.DataBind(); PanelVisibility(1); } else { PanelVisibility(2); } }
protected void gvDesignation_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); DesignationBL objDesignationBL = new DesignationBL(); if (e.CommandName.ToString() == "Edit1") { ViewState["Mode"] = "Edit"; ViewState["DesignationID"] = e.CommandArgument.ToString(); objResult = objDesignationBL.Designation_Select(Convert.ToInt32(ViewState["DesignationID"].ToString())); if (objResult != null) { DataTable dtResult = objResult.resultDT; if (dtResult.Rows.Count > 0) { txtDesignationNameENG.Text = dtResult.Rows[0][DesignationBO.DESIGNATION_DESIGNATIONNAMEENG].ToString(); txtDesignationNameGUJ.Text = dtResult.Rows[0][DesignationBO.DESIGNATION_DESIGNATIONNAMEGUJ].ToString(); txtDescription.Text = dtResult.Rows[0][DesignationBO.DESIGNATION_DESCRIPTION].ToString(); PanelVisibility(2); } } } else if (e.CommandName.ToString() == "Delete1") { objResult = objDesignationBL.Designation_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.USERID]), DateTime.UtcNow.AddHours(5.5).ToString()); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>"); PanelVisibility(1); BindDesignation(); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You cannot delete this record because it is in used.');</script>"); } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void GetDesignation(int dept) { List <Designationtbl> lstDesignation = new List <Designationtbl>(); Designationtbl dsgt = new Designationtbl(); DesignationBL objDesignationBL = new DesignationBL(); dsgt.IsActive = 1; dsgt.DepartmentId = dept; lstDesignation = objDesignationBL.GetDesignationByDepIsActive(dsgt).ToList(); DDLDesignation.Items.Clear(); DDLDesignation.Items.Add(new ListItem("--Select--", "0")); foreach (var cnt in lstDesignation) { ListItem li = new ListItem(); li.Text = cnt.DesignationName; li.Value = cnt.DesignationId.ToString(); DDLDesignation.Items.Add(li); } }
protected void GetEmployeeById(int EmpId) { Employeetbl Emp = new Employeetbl { EmpId = EmpId }; List <Employeetbl> lstEmp = new List <Employeetbl>(); lstEmp = objEmployeeBL.GetEmployeeById(Emp).ToList(); foreach (var el in lstEmp) { txtEID.Text = el.EmployeeId; txtEmail.Text = el.Email; txtDOB.Text = el.DateOfBirth; txtMobile.Text = el.MobileNo; txtUsername.Text = el.Username; TxtPassword.Text = el.Password; txtFname.Text = el.FirstName; txtLName.Text = el.LastName; DDLGender.SelectedValue = el.Gender; DDLMaritalStatus.SelectedValue = el.MaritalStatus; txtMobile.Text = el.MobileNo; txtAddress.Text = el.Address; txtDateOfJoin.Text = el.DateOfJoin; DDLRole.SelectedValue = el.RoleId; DDLDept.SelectedValue = el.DepartmentId.ToString(); DesignationBL objDesignationBL = new DesignationBL(); List <Designationtbl> lstdesg = new List <Designationtbl>(); GetDesignation(el.DepartmentId); DDLDesignation.SelectedValue = el.DesignationId.ToString(); DDLRManager.SelectedValue = el.ReportingManager; hdnEmpId.Value = el.EmpId.ToString(); hdnStatus.Value = el.IsActive.ToString(); } }
protected void btnSaveClass_OnClick(object sender, EventArgs e) { try { DesignationBO objDesignationBO = new DesignationBO(); DesignationBL objDesignationBL = new DesignationBL(); ApplicationResult objResult = new ApplicationResult(); DataTable dtResult = new DataTable(); int intDesignationID = 0; objDesignationBO.DesignationNameENG = txtDesignationNameENG.Text.Trim(); objDesignationBO.DesignationNameGUJ = txtDesignationNameGUJ.Text.Trim(); objDesignationBO.Description = txtDescription.Text.Trim(); objDesignationBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objDesignationBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); //Code For Validate Designation Name if (ViewState["Mode"].ToString() == "Save") { intDesignationID = -1; } else if (ViewState["Mode"].ToString() == "Edit") { intDesignationID = Convert.ToInt32(ViewState["DesignationID"].ToString()); } objResult = objDesignationBL.Designation_ValidateName(intDesignationID, objDesignationBO.DesignationNameENG); if (objResult != null) { dtResult = objResult.resultDT; if (dtResult.Rows.Count > 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Designation name already exist.');</script>"); } else { if (ViewState["Mode"].ToString() == "Save") { objDesignationBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objDesignationBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objResult = objDesignationBL.Designation_Insert(objDesignationBO); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>"); } } else if (ViewState["Mode"].ToString() == "Edit") { objDesignationBO.DesignationID = Convert.ToInt32(ViewState["DesignationID"].ToString()); objResult = objDesignationBL.Designation_Update(objDesignationBO); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>"); } } ClearAll(); BindDesignation(); PanelVisibility(1); } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }