protected void ddlSpType_SelectedIndexChanged(object sender, EventArgs e)
{
string sSPTypeID = ddlSpType.SelectedValue;
TotalClear();
if (!string.IsNullOrEmpty(sSPTypeID))
{
ddlSpType.Text = sSPTypeID;
LoadCurrencyBySPType(ddlSpType.SelectedValue);
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
Result oResult = oSPTypeDAL.GetCurrencyBySPTypeID(ddlSpType.SelectedValue);
if (oResult.Status)
{
SPType oSPType = oResult.Return as SPType;
ViewState[_BASE_CURRENCY] = oSPType.Currency.CurrencyID;
}
if (ddlSpType.SelectedValue.Equals(Constants.SP_TYPE_DIB) ||
ddlSpType.SelectedValue.Equals(Constants.SP_TYPE_DPB))
{
txtCovRateToBC.Enabled = true;
txtCovRateToBC.Text = "1.0000";
}
else
{
txtCovRateToBC.Text = "1.0000";
txtCovRateToBC.Enabled = false;
}
}
//txtReimConvRate.Text = string.Empty;
txtReimConvRate.Enabled = true;
txtBBReferenceNo.Focus();
}
private void LoadSPType()
{
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
Result oResult = (Result)oSPTypeDAL.GetDDLDenomList(ddlSPType.SelectedValue);
if (oResult.Status)
{
ddlDenomination.Items.Clear();
DataTable dtGetDenomID = (DataTable)oResult.Return;
if (dtGetDenomID.Rows.Count > 0)
{
DDListUtil.Assign(ddlDenomination, dtGetDenomID, true);
txtSeries.Text = string.Empty;
txtFrom.Text = string.Empty;
txtTo.Text = string.Empty;
txtQuantity.Text = string.Empty;
txtDnmAmount.Text = string.Empty;
txtDrawerNumber.Text = string.Empty;
txtCabinetNumber.Text = string.Empty;
gvReceiveDetail.DataSource = null;
gvReceiveDetail.DataBind();
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
SPType oSPType = new SPType();
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
Result oResult = oSPTypeDAL.SearchList(txtSPTypeID.Text, txtDescription.Text, txtDenom.Text, txtReOrderLevel.Text);
DataTable dtTmpList = null;
ScriptManager.RegisterStartupScript(this.upSuccess, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_ucSearchSPType_lblProgress') ", true);
if (oResult.Status)
{
dtTmpList = (DataTable)oResult.Return;
if (dtTmpList.Rows.Count > 0)
{
gvSearchList.DataSource = dtTmpList;
gvSearchList.DataBind();
}
else
{
gvSearchList.DataSource = null;
gvSearchList.DataBind();
}
}
Session[Constants.SES_CONFIG_APPROVE_DATA] = dtTmpList;
}
private void ReloadList(SPTypeDAL oSPTypeDAL, string sSPTpyeID)
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
spTypeList = new SPTypeList();
Result oRslSPTypeList = oSPTypeDAL.LoadList(oConfig.UserName);
spTypeList = (SPTypeList)oRslSPTypeList.Return;
Session[Constants.SES_SPTYPELIST] = spTypeList;
LoadSPDataList(spTypeList);
LoadDenomDataListBySPTypeID(sSPTpyeID, spTypeList);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdDataType.Value))
{
SPType oSPType = (SPType)Session[Constants.SES_SPTYPE];
if (oSPType == null)
{
oSPType = new SPType();
}
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
oSPType.SPTypeID = Request[txtSpTypeId.UniqueID].Trim().ToUpper();
oSPType.TypeDesc = txtDescription.Text.Trim().ToUpper();
if (!string.IsNullOrEmpty(ddlCurrency.SelectedValue))
{
oSPType.Currency.CurrencyID = ddlCurrency.SelectedValue;
}
oSPType.UserDetails = ucUserDet.UserDetail;
oSPType.UserDetails.MakeDate = DateTime.Now;
ucUserDet.ResetData();
Result oResult = (Result)oSPTypeDAL.Save(oSPType);
if (oResult.Status)
{
ReloadList(oSPTypeDAL, oSPType.SPTypeID);
ClearTextValue();
ResetDenom();
hdDenomID.Value = string.Empty;
hdSPTypeID.Value = string.Empty;
ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_APPROVED_SAVE_DATA, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
ClearTextValue();
ResetDenom();
hdDenomID.Value = string.Empty;
hdSPTypeID.Value = string.Empty;
}
}
protected void SetDenominationBySPTypeID(SPTypeDAL oSPTypeDAL)
{
if (oSPTypeDAL == null)
{
oSPTypeDAL = new SPTypeDAL();
}
Result oResult = (Result)oSPTypeDAL.GetDDLDenomList(ddlSPType.SelectedValue);
if (oResult.Status)
{
ddlDenomination.Items.Clear();
DataTable dtGetDenomID = (DataTable)oResult.Return;
DDListUtil.Assign(ddlDenomination, dtGetDenomID);
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
SPType oSPType = new SPType(hdSPTypeID.Value);
oSPType.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oSPTypeDAL.Approve(oSPType);
if (oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
public void SPLoadAction(string sSPTypeID)
{
if (!string.IsNullOrEmpty(sSPTypeID))
{
SPTypeDAL oSpTypeDal = new SPTypeDAL();
Result oResult = oSpTypeDal.LoadByID(sSPTypeID);
if (oResult.Status)
{
SPType oSpType = (SPType)oResult.Return;
if (oSpType != null)
{
hdDataType.Value = oResult.Message;
SetSPType(oSpType);
Session[Constants.SES_SPTYPE] = oSpType;
}
}
}
}
protected void ddlDenomination_SelectedIndexChanged(object sender, EventArgs e)
{
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
if (!string.IsNullOrEmpty(ddlDenomination.SelectedValue))
{
Result oResult = (Result)oSPTypeDAL.GetSeriesName(ddlSPType.SelectedValue, ddlDenomination.SelectedValue);
if (oResult.Status)
{
DataTable dtSeries = (DataTable)oResult.Return;
if (dtSeries.Rows.Count > 0)
{
txtSeries.Text = Convert.ToString(dtSeries.Rows[0]["SPSeries"]);
hdDigitsInSlNo.Value = Convert.ToString(dtSeries.Rows[0]["DigitsInSlNo"]);
}
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (hdDataType.Value != "M")
{
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
if (hdSPTypeID.Value != "")
{
Result oResult = (Result)oSPTypeDAL.Detete(hdSPTypeID.Value);
if (oResult.Status)
{
ReloadList(oSPTypeDAL, string.Empty);
ClearTextValue();
ResetDenom();
hdDenomID.Value = string.Empty;
hdSPTypeID.Value = string.Empty;
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);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
ClearTextValue();
}
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlSPType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
DDListUtil.LoadDDLFromXML(ddlScriptFormat, "ScriptFormatMapping", "ReportType", "SP", true);
gvList.PageSize = (int)Constants.PAGING_UNAPPROVED;
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
SetDenominationBySPTypeID(oSPTypeDAL);
string sPTypeID = Request.QueryString[OBJ_SPTYPE_ID];
string sDenomID = Request.QueryString[OBJ_DENOM_ID];
string sPageID = Request.QueryString[OBJ_PAGE_ID];
if (!string.IsNullOrEmpty(sPTypeID))
{
sPTypeID = oCrypManager.GetDecryptedString(sPTypeID, Constants.CRYPT_PASSWORD_STRING);
}
if (!string.IsNullOrEmpty(sDenomID))
{
sDenomID = oCrypManager.GetDecryptedString(sDenomID, Constants.CRYPT_PASSWORD_STRING);
}
if (!string.IsNullOrEmpty(sPageID))
{
sPageID = oCrypManager.GetDecryptedString(sPageID, Constants.CRYPT_PASSWORD_STRING);
}
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (!string.IsNullOrEmpty(sPTypeID) && !string.IsNullOrEmpty(sDenomID) && !string.IsNullOrEmpty(sPageID))
{
string sOperationType = sPageID.Substring(4, 1);
if (Constants.OPERATION_TYPE_APPROVAL.Equals(sOperationType))
{
LoadDataByID(sPTypeID, sDenomID);
// general Control
Util.ControlEnabled(ddlSPType, false);
Util.ControlEnabled(ddlDenomination, false);
Util.ControlEnabled(ddlScriptFormat, false);
// user Detail
Util.ControlEnabled(ucUserDet.FindControl("txtCheckerComments"), true);
// button
Util.ControlEnabled(btnReject, true);
Util.ControlEnabled(btnApprove, true);
Util.ControlEnabled(btnBack, true);
Util.ControlEnabled(btnReset, false);
Util.ControlEnabled(btnSave, false);
Util.ControlEnabled(btnDelete, false);
Util.ControlEnabled(btnSearch, false);
#region User-Detail.
UserDetails oUserDetails = ucUserDet.UserDetail;
oUserDetails.CheckerID = oConfig.UserName;
oUserDetails.CheckDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
#endregion User-Detail.
fsList.Visible = false;
}
}
else
{
// button
Util.ControlEnabled(btnReject, false);
Util.ControlEnabled(btnApprove, false);
Util.ControlEnabled(btnBack, false);
Util.ControlEnabled(btnReset, true);
Util.ControlEnabled(btnSave, true);
Util.ControlEnabled(btnDelete, true);
Util.ControlEnabled(btnSearch, true);
Util.ControlEnabled(ucUserDet.FindControl("txtCheckerComments"), false);
#region User-Detail.
UserDetails oUserDetails = new UserDetails();
oUserDetails.MakerID = oConfig.UserName;
oUserDetails.MakeDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
#endregion User-Detail.
fsList.Visible = true;
LoadList();
}
}
private void InitializeData()
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
gvList.PageSize = (int)Constants.PAGING_UNAPPROVED;
if (Session[Constants.SES_SPTYPELIST] == null)
{
Session.Add(Constants.SES_SPTYPELIST, new SPTypeList());
}
else
{
Session[Constants.SES_SPTYPELIST] = new SPTypeList();
}
if (Session[Constants.SES_SPTYPE] == null)
{
Session.Add(Constants.SES_SPTYPE, new SPType());
}
else
{
Session[Constants.SES_SPTYPE] = new SPType();
}
SPTypeDAL spTypeDal = new SPTypeDAL();
spTypeList = new SPTypeList();
Result oRslSPTypeList = spTypeDal.LoadList(oConfig.UserName);
spTypeList = (SPTypeList)oRslSPTypeList.Return;
Session[Constants.SES_SPTYPELIST] = spTypeList;
gvDenom.DataSource = null;
gvDenom.DataBind();
hdDataType.Value = "";
// Dropdown load
DDListUtil.LoadDDLFromDB(ddlCurrency, "CurrencyID", "CurrencyCode", "SPMS_Currency", true);
string sPTypeID = Request.QueryString[OBJ_SPTYPE_ID];
string sPageID = Request.QueryString[OBJ_PAGE_ID];
if (!string.IsNullOrEmpty(sPTypeID))
{
sPTypeID = oCrypManager.GetDecryptedString(sPTypeID, Constants.CRYPT_PASSWORD_STRING).Trim();
}
if (!string.IsNullOrEmpty(sPageID))
{
sPageID = oCrypManager.GetDecryptedString(sPageID, Constants.CRYPT_PASSWORD_STRING).Trim();
}
if (!string.IsNullOrEmpty(sPTypeID) && !string.IsNullOrEmpty(sPageID))
{
string sOperationType = sPageID.Substring(4, 1);
if (Constants.OPERATION_TYPE_APPROVAL.Equals(sOperationType))
{
if (spTypeList.ListOfSPType.Count > 0)
{
LoadDenomDataListBySPTypeID(sPTypeID.Trim(), spTypeList);
LoadSPDetailData(sPTypeID.Trim(), spTypeList);
}
// general Control
Util.ControlEnabled(txtSpTypeId, false);
Util.ControlEnabled(txtDescription, false);
Util.ControlEnabled(ddlCurrency, false);
Util.ControlEnabled(txtDenomination, false);
Util.ControlEnabled(txtReOrderLevel, false);
Util.ControlEnabled(txtSeries, false);
Util.ControlEnabled(txtNoOfDigitInSeries, false);
// user Detail
Util.ControlEnabled(ucUserDet.FindControl("txtCheckerComments"), true);
// button
Util.ControlEnabled(btnReject, true);
Util.ControlEnabled(btnApprove, true);
Util.ControlEnabled(btnBack, true);
Util.ControlEnabled(btnReset, false);
Util.ControlEnabled(btnSave, false);
Util.ControlEnabled(btnDelete, false);
Util.ControlEnabled(btnLoad, false);
Util.ControlEnabled(btnSaveDenom, false);
Util.ControlEnabled(btnDenomReset, false);
#region User-Detail.
UserDetails oUserDetails = ucUserDet.UserDetail;
oUserDetails.CheckerID = oConfig.UserName;
oUserDetails.CheckDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
#endregion User-Detail.
fsList.Visible = false;
fsDenom.Visible = true;
}
}
else
{
// button
Util.ControlEnabled(btnReject, false);
Util.ControlEnabled(btnApprove, false);
Util.ControlEnabled(btnBack, false);
Util.ControlEnabled(btnReset, true);
Util.ControlEnabled(btnSave, true);
Util.ControlEnabled(btnDelete, true);
Util.ControlEnabled(btnLoad, true);
Util.ControlEnabled(btnSaveDenom, true);
Util.ControlEnabled(btnDenomReset, true);
Util.ControlEnabled(ucUserDet.FindControl("txtCheckerComments"), false);
#region User-Detail.
UserDetails oUserDetails = new UserDetails();
oUserDetails.MakerID = oConfig.UserName;
oUserDetails.MakeDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
#endregion User-Detail.
fsList.Visible = true;
fsDenom.Visible = true;
LoadSPDataList(spTypeList);
}
}
protected void btnSaveDenom_Click(object sender, EventArgs e)
{
SPType oSPType = (SPType)Session[Constants.SES_SPTYPE];
Result oResult = new Result();
bool isExist = false;
// need to check first for adding can be possible or not...
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
if (oSPType.ListOfDenomination.Denomination.Count > 0)
{
Denomination oDenomSerRemove = oSPType.ListOfDenomination.Denomination.Where(d => d.Series.Equals(txtSeries.Text)).SingleOrDefault();
Denomination oDenomRemove = oSPType.ListOfDenomination.Denomination.Where(d => d.DenominationID.Equals(Convert.ToInt32(txtDenomination.Text))).SingleOrDefault();
if (oDenomSerRemove != null && oDenomRemove == null)
{
isExist = true;
}
}
if (!isExist)
{
oResult = oSPTypeDAL.IsExistSeriesName(txtSeries.Text);
if (oResult.Status)
{
isExist = (bool)oResult.Return;
}
}
if (!isExist)
{
if (oSPType != null)
{
if (oSPType.ListOfDenomination.Denomination.Count > 0)
{
Denomination oDenomRemove = oSPType.ListOfDenomination.Denomination.Where(d => d.DenominationID.Equals(Convert.ToInt32(txtDenomination.Text))).SingleOrDefault();
if (oDenomRemove != null)
{
oSPType.ListOfDenomination.Denomination.Remove(oDenomRemove);
}
}
}
else
{
oSPType = new SPType();
}
Denomination oDenomination = new Denomination();
oDenomination.DenominationID = Util.GetIntNumber(txtDenomination.Text);
oDenomination.NoOfDigitsInSeries = Util.GetIntNumber(txtNoOfDigitInSeries.Text);
oDenomination.ReOrderLevel = Util.GetIntNumber(txtReOrderLevel.Text);
oDenomination.Series = txtSeries.Text.Trim().ToUpper();
oDenomination.SPType.SPTypeID = hdSPTypeID.Value.Trim();
oDenomination.UserDetail = ucUserDet.UserDetail;
oSPType.ListOfDenomination.Denomination.Add(oDenomination);
Session[Constants.SES_SPTYPE] = oSPType;
ReloadDenomTmpListFromSession();
ResetDenom();
}
else
{
ucMessage.OpenMessage("This Series " + txtSeries.Text + " all ready exist for other Denotation !", Constants.MSG_TYPE_ERROR);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
public void SearchAction()
{
string sType = Request.QueryString["pType"];
gvData.DataSource = null;
gvData.DataBind();
if (!string.IsNullOrEmpty(sType))
{
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = new DataTable();
if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BRANCH).PadLeft(5, '0')))
{
#region BRANCH
lgText.InnerHtml = "Branch Approval Queue List";
BranchDAL oBranchDAL = new BranchDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Branch' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oBranchDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Branch ID";
this.gvData.HeaderRow.Cells[2].Text = "Branch Name";
this.gvData.HeaderRow.Cells[3].Text = "BB Code";
this.gvData.HeaderRow.Cells[4].Text = "Address";
this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
this.gvData.HeaderRow.Cells[6].Text = "Make Date";
}
}
}
#endregion BRANCH
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BD_BANKADDRESS).PadLeft(5, '0')))
{
#region Bangladesh Bank Address
lgText.InnerHtml = "Bangladesh Bank Address Approval Queue List";
BBAddressDAL oBBAddressDAL = new BBAddressDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Bangladesh Bank Address' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oBBAddressDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "SP Type";
this.gvData.HeaderRow.Cells[2].Text = "Sales Statemet Address";
this.gvData.HeaderRow.Cells[3].Text = "Commission Claim Address";
this.gvData.HeaderRow.Cells[4].Text = "Interest Claim Address";
this.gvData.HeaderRow.Cells[5].Text = "Encashment Claim Address";
this.gvData.HeaderRow.Cells[6].Text = "Reinvestment Address";
this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
this.gvData.HeaderRow.Cells[8].Text = "Make Date";
}
}
}
#endregion Bangladesh Bank Address
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CURRENCY).PadLeft(5, '0')))
{
#region Currency
lgText.InnerHtml = "Currency Approval Queue List";
CurrencyDAL oCurrencyDAL = new CurrencyDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Currency' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCurrencyDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
this.gvData.HeaderRow.Cells[2].Text = "Currency Code";
this.gvData.HeaderRow.Cells[3].Text = "Currency Symbol";
this.gvData.HeaderRow.Cells[4].Text = "Currency Description";
this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
this.gvData.HeaderRow.Cells[6].Text = "Make Date";
}
}
}
#endregion Currency
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CURRENCY_WISE_ACCOUNT_MAPPING).PadLeft(5, '0')))
{
#region Currency Wise Account Mapping
lgText.InnerHtml = "Currency Wise Account Mapping Approval Queue List";
CurrencyWiseAccountMappingDAL oCurrencyWiseAccountMappingDAL = new CurrencyWiseAccountMappingDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Currency Wise Account Mapping ' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCurrencyWiseAccountMappingDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
// for adding seperator....
alAddSeperatorIndex = new ArrayList();
alAddSeperatorIndex.Add(3);
alAddSeperatorIndex.Add(4);
alAddSeperatorIndex.Add(5);
alAddSeperatorIndex.Add(6);
alAddSeperatorIndex.Add(7);
dtTmpList.Columns.Remove("SuspenseAccName");
dtTmpList.Columns.Remove("ForeignExchangeAccName");
dtTmpList.Columns.Remove("BranchFxAccName");
dtTmpList.Columns.Remove("BranchExFxAccName");
dtTmpList.Columns.Remove("BangladesgBankAccName");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
this.gvData.HeaderRow.Cells[2].Text = "Currency Code";
this.gvData.HeaderRow.Cells[3].Text = "Suspense Acc";
this.gvData.HeaderRow.Cells[4].Text = "Foreign Exchange Acc";
this.gvData.HeaderRow.Cells[5].Text = "Branch Fx Acc";
this.gvData.HeaderRow.Cells[6].Text = "Branch Ex Fx Acc";
this.gvData.HeaderRow.Cells[7].Text = "Bangladesg Bank Acc";
this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
this.gvData.HeaderRow.Cells[9].Text = "Make Date";
}
}
}
#endregion Currency Wise Account Mapping
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_DETAIL).PadLeft(5, '0')))
{
#region Customer Detail
lgText.InnerHtml = "Customer Detail Approval Queue List";
CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Customer Detail' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCustomerDetailsDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Customer ID";
this.gvData.HeaderRow.Cells[2].Text = "Customer Name";
this.gvData.HeaderRow.Cells[3].Text = "Date of Birth";
this.gvData.HeaderRow.Cells[4].Text = "Address";
this.gvData.HeaderRow.Cells[5].Text = "Phone";
this.gvData.HeaderRow.Cells[6].Text = "Email";
this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
this.gvData.HeaderRow.Cells[8].Text = "Make Date";
}
}
}
#endregion Customer Detail
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_TYPE).PadLeft(5, '0')))
{
#region Customer Type
lgText.InnerHtml = "Customer Type Approval Queue List";
CustomerTypeDAL oCustomerTypeDAL = new CustomerTypeDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Customer Type' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCustomerTypeDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Customer Type ID";
this.gvData.HeaderRow.Cells[2].Text = "Customer Type Description";
this.gvData.HeaderRow.Cells[3].Text = "Max Members";
this.gvData.HeaderRow.Cells[4].Text = "Is Organization";
this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
this.gvData.HeaderRow.Cells[6].Text = "Make Date";
}
}
}
#endregion Customer Type
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_TYPE_WISE_SP_LIMIT).PadLeft(5, '0')))
{
#region Customer Type wise SP Type Maping
lgText.InnerHtml = "Customer Type wise SP Type Maping Approval Queue List";
CustomerTypeWiseSPLimitDAL oCustomerTypeWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Customer Type wise Sp Type Maping' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCustomerTypeWiseSPLimitDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Customer Type ID";
this.gvData.HeaderRow.Cells[2].Text = "Customer Type";
this.gvData.HeaderRow.Cells[3].Text = "SP Type";
this.gvData.HeaderRow.Cells[4].Text = "Minimum Limit";
this.gvData.HeaderRow.Cells[5].Text = "Maximum Limit";
this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
this.gvData.HeaderRow.Cells[7].Text = "Make Date";
}
}
}
#endregion Customer Type wise SP Type Maping
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.DIVISION).PadLeft(5, '0')))
{
#region Area Approval
lgText.InnerHtml = "Area Approval Queue List";
DivisionDAL oDivisionDAL = new DivisionDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Area' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oDivisionDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
dtTmpList.Columns.Remove("BranchID");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Area ID";
this.gvData.HeaderRow.Cells[2].Text = "BB Code";
this.gvData.HeaderRow.Cells[3].Text = "Area Name";
this.gvData.HeaderRow.Cells[4].Text = "Address";
this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
this.gvData.HeaderRow.Cells[6].Text = "Make Date";
}
}
}
#endregion Area Approval
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_CERTIFICATE).PadLeft(5, '0')))
{
#region Script Mapping Certificate
lgText.InnerHtml = "Script Mapping Certificate Approval Queue List";
ScripMappingDAL oScripMappingDAL = new ScripMappingDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Script Mapping Certificate' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oScripMappingDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
dtTmpList = DDListUtil.MapTableWithXML(dtTmpList, "ScriptFormatMapping", "ReportType", "SP", 2);
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "SP Type";
this.gvData.HeaderRow.Cells[2].Text = "Denomination";
this.gvData.HeaderRow.Cells[3].Text = "Script Format";
this.gvData.HeaderRow.Cells[4].Text = "Maker ID";
this.gvData.HeaderRow.Cells[5].Text = "Maker Date";
}
}
}
#endregion Script Mapping Certificate
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_POLICY).PadLeft(5, '0')))
{
#region SP Policy
lgText.InnerHtml = "SP Policy Approval Queue List";
SPPolicyDAL oSPPolicyDAL = new SPPolicyDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'SP Policy' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSPPolicyDAL.LoadUnapprovedList(null, true);
if (oResult != null)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
dtTmpList.Columns.Remove("CheckerID");
dtTmpList.Columns.Remove("CheckDate");
dtTmpList.Columns.Remove("CheckerComment");
dtTmpList.Columns.Remove("PolicyEffectDate");
dtTmpList.Columns.Remove("IsSPDurationInMonth");
dtTmpList.Columns.Remove("SPInterestType");
dtTmpList.Columns.Remove("InterestTypeAfterIntPayment");
dtTmpList.Columns.Remove("PreMaturityInterestType");
dtTmpList.Columns.Remove("PreMatIntTypeAfterIntPayment");
dtTmpList.Columns.Remove("IsNomineePerScripRequired");
dtTmpList.Columns.Remove("IsBondHolderRequired");
dtTmpList.Columns.Remove("IsFoeignAddressRequired");
dtTmpList.Columns.Remove("SupportedSex");
dtTmpList.Columns.Remove("PartiallyEncashable");
dtTmpList.Columns.Remove("ReinvestmentSuported");
dtTmpList.Columns.Remove("InterestReinvestable");
dtTmpList.Columns.Remove("PartiallyEncashedReinvestable");
dtTmpList.Columns.Remove("MaxNoOfReinvestment");
dtTmpList.Columns.Remove("NonOrgCommission");
dtTmpList.Columns.Remove("NonOrgCommissionType");
dtTmpList.Columns.Remove("OrgCommission");
dtTmpList.Columns.Remove("OrgCommissionType");
dtTmpList.Columns.Remove("Levi");
dtTmpList.Columns.Remove("LeviType");
dtTmpList.Columns.Remove("IncomeTax");
dtTmpList.Columns.Remove("IncomeTaxType");
dtTmpList.Columns.Remove("IncomeTaxApplyAmount");
dtTmpList.Columns.Remove("IncomeTaxYearlyYN");
dtTmpList.Columns.Remove("IsOrganizationLeviTax");
dtTmpList.Columns.Remove("InterestRemuneration");
dtTmpList.Columns.Remove("InterestRemunerationType");
dtTmpList.Columns.Remove("Remuneration");
dtTmpList.Columns.Remove("RemunerationType");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Policy ID";
this.gvData.HeaderRow.Cells[2].Text = "SP Type";
this.gvData.HeaderRow.Cells[3].Text = "SP Duration";
this.gvData.HeaderRow.Cells[4].Text = "No Of Coupons";
this.gvData.HeaderRow.Cells[5].Text = "Minimum Age";
this.gvData.HeaderRow.Cells[6].Text = "Maximum Age";
this.gvData.HeaderRow.Cells[7].Text = "Is Approved";
this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
this.gvData.HeaderRow.Cells[9].Text = "Make Date";
}
}
}
#endregion SP Policy
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_REPORT).PadLeft(5, '0')))
{
#region Report Mapping
lgText.InnerHtml = "Report Mapping Approval Queue List";
SPReportMappingDAL oSPReportMappingDAL = new SPReportMappingDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Report Mapping' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSPReportMappingDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
DataTable dtMappedData = null;
dtMappedData = DDListUtil.MapTableWithXML(dtTmpList, "ReportFormatMapping", "ReportType", "SS", 1);
dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "CC", 2);
dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "IC", 3);
dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "EC", 4);
gvData.DataSource = dtMappedData;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtMappedData;
this.gvData.HeaderRow.Cells[1].Text = "SP Type";
this.gvData.HeaderRow.Cells[2].Text = "Sales Statemet";
this.gvData.HeaderRow.Cells[3].Text = "Commission Claim";
this.gvData.HeaderRow.Cells[4].Text = "Interest Claim ";
this.gvData.HeaderRow.Cells[5].Text = "Encashment Claim";
this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
this.gvData.HeaderRow.Cells[7].Text = "Maker Date";
}
}
}
#endregion Report Mapping
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_TYPE).PadLeft(5, '0')))
{
#region Sanchaya Patra Type
lgText.InnerHtml = "Sanchaya Patra Type Approval Queue List";
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Sanchaya Patra Type' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSPTypeDAL.LoadTmpDataTableList();
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "SP Type";
this.gvData.HeaderRow.Cells[2].Text = "Type Description";
this.gvData.HeaderRow.Cells[3].Text = "Currency Code";
this.gvData.HeaderRow.Cells[4].Text = "Maker ID";
this.gvData.HeaderRow.Cells[5].Text = "Make Date";
}
}
}
#endregion Sanchaya Patra Type
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_WISEA_CCOUNT).PadLeft(5, '0')))
{
#region Sanchaya Patra wise Account Mapping
lgText.InnerHtml = "Sanchaya Patra wise Account Mapping Approval Queue List";
SPTypeWiseAccountMappingDAL oSPTypeWiseAccountMappingDAL = new SPTypeWiseAccountMappingDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Sanchaya Patra wise Account Mapping' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSPTypeWiseAccountMappingDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
// for adding seperator....
alAddSeperatorIndex = new ArrayList();
alAddSeperatorIndex.Add(2);
alAddSeperatorIndex.Add(3);
alAddSeperatorIndex.Add(4);
alAddSeperatorIndex.Add(5);
alAddSeperatorIndex.Add(6);
alAddSeperatorIndex.Add(7);
dtTmpList.Columns.Remove("StockInHandAccName");
dtTmpList.Columns.Remove("LiabilityOnStockAccName");
dtTmpList.Columns.Remove("HoldingAccName");
dtTmpList.Columns.Remove("AccruedInterestAccName");
dtTmpList.Columns.Remove("AdvAgainstInterestAccName");
dtTmpList.Columns.Remove("AdvAgainstPrincipalAccName");
dtTmpList.Columns.Remove("CheckerID");
dtTmpList.Columns.Remove("CheckDate");
dtTmpList.Columns.Remove("CheckerComment");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "SPType ID";
this.gvData.HeaderRow.Cells[2].Text = "Stock In Hand Acc";
this.gvData.HeaderRow.Cells[3].Text = "Liability On Stock Acc";
this.gvData.HeaderRow.Cells[4].Text = "Holding Acc";
this.gvData.HeaderRow.Cells[5].Text = "Accrued Interest Acc";
this.gvData.HeaderRow.Cells[6].Text = "AdvAgainst Interest Acc";
this.gvData.HeaderRow.Cells[7].Text = "Adv Against Principal Acc";
this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
this.gvData.HeaderRow.Cells[9].Text = "Make Date";
}
}
}
#endregion Sanchaya Patra wise Account Mapping
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SYSTEM_CONFIG).PadLeft(5, '0')))
{
#region System Configuration
lgText.InnerHtml = "System Configuration Approval Queue List";
SystemConfigurationDAL oSCDAL = new SystemConfigurationDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'System Configuration' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSCDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
dtTmpList.Columns.Remove("Dr_Code");
dtTmpList.Columns.Remove("Cr_Code");
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Customer Data File";
this.gvData.HeaderRow.Cells[2].Text = "Originator ID";
this.gvData.HeaderRow.Cells[3].Text = "Row Type Header";
this.gvData.HeaderRow.Cells[4].Text = "Row Type Footer";
this.gvData.HeaderRow.Cells[5].Text = "Dr Transaction Code";
this.gvData.HeaderRow.Cells[6].Text = "Cr Transaction Code";
this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
this.gvData.HeaderRow.Cells[8].Text = "Make Date";
}
}
}
#endregion System Configuration
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.COMMON_MAPPING).PadLeft(5, '0')))
{
#region Common Mapping
lgText.InnerHtml = "Common Mapping Approval Queue List";
CommonMappingDAL oCmAL = new CommonMappingDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Common Mapping' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCmAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
alAddSeperatorIndex = new ArrayList();
alAddSeperatorIndex.Add(3);
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
}
}
}
#endregion Common Mapping
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BANK).PadLeft(5, '0')))
{
#region Common Mapping
lgText.InnerHtml = "Bank Setup Approval Queue List";
BankDAL oBankDAL = new BankDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Bank Setup' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oBankDAL.LoadUnapprovedList(null, true);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
this.gvData.HeaderRow.Cells[1].Text = "Bank ID";
this.gvData.HeaderRow.Cells[2].Text = "BB Code";
this.gvData.HeaderRow.Cells[3].Text = "Bank Name";
this.gvData.HeaderRow.Cells[4].Text = "Branch ID";
this.gvData.HeaderRow.Cells[5].Text = "Address";
this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
this.gvData.HeaderRow.Cells[7].Text = "Make Date";
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
}
}
}
#endregion Common Mapping
}
}
}
