private void LoadDataByID(int iDsgID) { Designation oDsg = new Designation(iDsgID); DesignationDAL oDsgDAL = new DesignationDAL(); Result oResult = new Result(); oResult = oDsgDAL.LoadByID(oDsg); ClearTextValue(); if (oResult.Status) { oDsg = (Designation)oResult.Return; if (oDsg != null) { txtDesignationID.Text = oDsg.DesignationID.ToString(); txtDesignationName.Text = oDsg.Description.ToString(); ucUserDet.UserDetail = oDsg.UserDetails; hdDsgID.Value = iDsgID.ToString(); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_INFO); ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true); } } else { ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR); ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Delete"), true); } }
private void _Save() { msg = ""; DesignationModel dpt = new DesignationModel(); dpt.DesignationName = txtDesignationName.Text.Trim(); dpt.Description = txtDescription.Text.Trim(); if (ckbIsActive.Checked == true) { dpt.IsActive = true; } else { dpt.IsActive = false; } DesignationDAL objDal = new DesignationDAL(); if (btnSave.Text == "Save") { msg = objDal._insertUpdateDeleteDesignation(dpt, "Insert"); } else { dpt.DesignationId = Convert.ToInt32(HdnDesignationId.Value); msg = objDal._insertUpdateDeleteDesignation(dpt, "Update"); } if (msg != "") { _Refresh(); } }
// ok private void LoadList() { Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; if (oConfig != null) { Designation oDsg = new Designation(); DesignationDAL oDsgDAL = new DesignationDAL(); Result oResult = oDsgDAL.LoadUnapprovedList(oConfig.UserName, false); gvData.DataSource = null; gvData.DataBind(); if (oResult.Status) { DataTable dtTmpList = (DataTable)oResult.Return; if (dtTmpList.Rows.Count > 0) { dtTmpList.Columns.Remove("MakerID"); gvData.DataSource = dtTmpList; gvData.DataBind(); Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList; } } } else { ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR); ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Delete"), true); } }
// ok protected void btnDelete_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(hdDsgID.Value)) { DesignationDAL oDsgDAL = new DesignationDAL(); Result oResult = (Result)oDsgDAL.Detete(hdDsgID.Value); if (oResult.Status) { this.LoadList(); this.ClearTextValue(); ucMessage.OpenMessage(Constants.MSG_SUCCESS_DELETE, Constants.MSG_TYPE_SUCCESS); } else { if (oResult.Message.Equals(Constants.TABLE_MAIN)) { ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_ERROR); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR); } } } else { ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR); } }
private void _LoadGrid() { DesignationDAL Dept = new DesignationDAL(); DataTable dt = new DataTable(); dt = Dept._SelectAllDesignation(); gvDesignation.DataSource = dt; gvDesignation.DataBind(); Session["Ses_Designation"] = dt; }
private void _Delete() { msg = ""; DesignationModel dpt = new DesignationModel(); DesignationDAL objDal = new DesignationDAL(); dpt.DesignationId = Convert.ToInt32(HdnDesignationId.Value); msg = objDal._insertUpdateDeleteDesignation(dpt, "Delete"); if (msg != "") { _Refresh(); } }
public Boolean Delete(SqlInt32 DesignationID) { DesignationDAL dalDesignation = new DesignationDAL(); if (dalDesignation.Delete(DesignationID)) { return(true); } else { Message = dalDesignation.Message; return(false); } }
public Boolean Update(DesignationENT entDesignation) { DesignationDAL dalDesignation = new DesignationDAL(); if (dalDesignation.Update(entDesignation)) { return(true); } else { Message = dalDesignation.Message; return(false); } }
private void MoveAction(string sType) { DesignationDAL oDesgDAL = new DesignationDAL(); Result oResult = oDesgDAL.LoadMoveData(txtDesignationID.Text, sType); if (oResult.Status) { Designation oDesg = (Designation)oResult.Return; if (oDesg != null) { ClearTextValue(); txtDesignationID.Text = oDesg.DesignationID.ToString(); txtDesignationName.Text = oDesg.Description.ToString(); } ucUserDet.UserDetail = oDesg.UserDetails; hdDsgID.Value = oDesg.DesignationID.ToString(); } }
protected void btnSave_Click(object sender, EventArgs e) { Designation oDsg = new Designation(); DesignationDAL oDsgDAL = new DesignationDAL(); oDsg.DesignationID = Util.GetIntNumber(txtDesignationID.Text); oDsg.Description = txtDesignationName.Text; oDsg.UserDetails = ucUserDet.UserDetail;; Result oResult = (Result)oDsgDAL.Save(oDsg); if (oResult.Status) { this.LoadList(); ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR); } }
protected void btnReject_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(hdDsgID.Value)) { Designation oDsg = new Designation(Util.GetIntNumber(hdDsgID.Value)); DesignationDAL oDsgDAL = new DesignationDAL(); oDsg.UserDetails = ucUserDet.UserDetail; Result oResult = (Result)oDsgDAL.Reject(oDsg); if (oResult.Status) { ucMessage.OpenMessage(Constants.MSG_SUCCESS_REJECT, Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_ERROR); } } else { ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_ERROR); } }
public DesignationBLL() { this.db = new DataAccess(); this.designation = new DesignationDAL(); }
public DesignationENT SelectByPK(SqlInt32 DesignationID) { DesignationDAL dalDesignation = new DesignationDAL(); return(dalDesignation.SelectByPK(DesignationID)); }
public DataTable SelectWithoutHODForDropDownList() { DesignationDAL dalDesignation = new DesignationDAL(); return(dalDesignation.SelectWithoutHODForDropDownList()); }
public DataTable SelectAll() { DesignationDAL dalDesignation = new DesignationDAL(); return(dalDesignation.SelectAll()); }
protected void SearchAction() { string sType = Request.QueryString["pType"]; Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; gvData.DataSource = null; gvData.DataBind(); if (!string.IsNullOrEmpty(sType)) { Session[Constants.SES_SA_UNAPPROVE_DATA] = new DataTable(); if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_SA.USER).PadLeft(5, '0'))) { lgText.InnerHtml = "User Approval Queue List"; UserDAL oUserDAL = new UserDAL(); TemplateBuilder tbGvData = new TemplateBuilder(); tbGvData.AppendLiteralString("No 'User' record found"); gvData.EmptyDataTemplate = tbGvData; Result oResult = oUserDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID); DataTable dtTmpList = (DataTable)oResult.Return; if (dtTmpList != null) { if (dtTmpList.Rows.Count > 0) { gvData.DataSource = dtTmpList; gvData.DataBind(); Session[Constants.SES_SA_UNAPPROVE_DATA] = dtTmpList; } } } else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_SA.DEPARTMENT).PadLeft(5, '0'))) { lgText.InnerHtml = "Department Approval Queue List"; DepartmentDAL oDptDAL = new DepartmentDAL(); TemplateBuilder tbGvData = new TemplateBuilder(); tbGvData.AppendLiteralString("No 'Department' record found"); gvData.EmptyDataTemplate = tbGvData; Result oResult = oDptDAL.LoadUnapprovedList(null, true); DataTable dtTmpList = (DataTable)oResult.Return; if (dtTmpList != null) { gvData.DataSource = dtTmpList; gvData.DataBind(); Session[Constants.SES_SA_UNAPPROVE_DATA] = dtTmpList; } } else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_SA.DESIGNATION).PadLeft(5, '0'))) { lgText.InnerHtml = "Designation Approval Queue List"; DesignationDAL oDsgDAL = new DesignationDAL(); TemplateBuilder tbGvData = new TemplateBuilder(); tbGvData.AppendLiteralString("No 'Designation' record found"); gvData.EmptyDataTemplate = tbGvData; Result oResult = oDsgDAL.LoadUnapprovedList(null, true); DataTable dtTmpDsgList = (DataTable)oResult.Return; if (dtTmpDsgList != null) { gvData.DataSource = dtTmpDsgList; gvData.DataBind(); Session[Constants.SES_SA_UNAPPROVE_DATA] = dtTmpDsgList; } } else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_SA.SECURITY_POLICY).PadLeft(5, '0'))) { lgText.InnerHtml = "Security policy Approval Queue List"; SecurityPolicyDAL oSPDAL = new SecurityPolicyDAL(); TemplateBuilder tbGvData = new TemplateBuilder(); tbGvData.AppendLiteralString("No 'Security policy' record found"); gvData.EmptyDataTemplate = tbGvData; Result oResult = oSPDAL.LoadUnapprovedList(null, true); DataTable dtTmpSPList = (DataTable)oResult.Return; if (dtTmpSPList != null) { gvData.DataSource = dtTmpSPList; gvData.DataBind(); Session[Constants.SES_SA_UNAPPROVE_DATA] = dtTmpSPList; } } else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_SA.GROUP_PERMISSION).PadLeft(5, '0'))) { lgText.InnerHtml = "Group Permission Approval Queue List"; GroupDAL oGPDAL = new GroupDAL(); TemplateBuilder tbGvData = new TemplateBuilder(); tbGvData.AppendLiteralString("No 'Group Permission' record found"); gvData.EmptyDataTemplate = tbGvData; Result oResult = oGPDAL.LoadUnapprovedList(null, true); DataTable dtTmpSPList = (DataTable)oResult.Return; if (dtTmpSPList != null) { gvData.DataSource = dtTmpSPList; gvData.DataBind(); Session[Constants.SES_SA_UNAPPROVE_DATA] = dtTmpSPList; } } else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_SA.SCREEN_SETUP).PadLeft(5, '0'))) { lgText.InnerHtml = "Screen Setup Approval Queue List"; ScreenDAL sCRDAL = new ScreenDAL(); TemplateBuilder tbGvData = new TemplateBuilder(); tbGvData.AppendLiteralString("No 'Screen Setup' record found"); gvData.EmptyDataTemplate = tbGvData; Result oResult = sCRDAL.LoadUnapprovedList(null, true); DataTable dtTmpSPList = (DataTable)oResult.Return; if (dtTmpSPList != null) { gvData.DataSource = dtTmpSPList; gvData.DataBind(); Session[Constants.SES_SA_UNAPPROVE_DATA] = dtTmpSPList; } } } }