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;
}
}
}
}
