protected void SearchAction()
{
gvData.DataSource = null;
gvData.DataBind();
Session[Constants.SES_DOCUMENT_INQUERY_DATA] = new DataTable();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
lgText.InnerHtml = "SP Issue Tracker Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Issue' record found");
gvData.EmptyDataTemplate = tbGvData;
string dtFromDate = Util.GetDateTimeByString(txtFromDate.Text).ToString("dd-MMM-yyyy");
string dtToDate = Util.GetDateTimeByString(txtToDate.Text).ToString("dd-MMM-yyyy");
Result oResult = oIssueDAL.LoadBBDocumentList(txtLetterRefNo.Text, ddlLetterType.SelectedValue, dtFromDate, dtToDate);
DataTable dtTmpGetData = (DataTable)oResult.Return;
if (dtTmpGetData != null)
{
gvData.DataSource = dtTmpGetData;
gvData.DataBind();
Session[Constants.SES_DOCUMENT_INQUERY_DATA] = dtTmpGetData;
}
else
{
dtTmpGetData = new DataTable();
gvData.DataSource = dtTmpGetData;
gvData.DataBind();
}
}
protected void SetView(DataTable dt)
{
if (dt == null || dt.Rows.Count == 0)
{
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No pending record found!");
gvAccRecon.EmptyDataTemplate = tbGvData;
gvAccRecon.DataBind();
}
else if (dt != null)
{
if (dt.Rows.Count > 0)
{
DataView dv = new DataView(dt);
//dv.RowFilter = "ActionFlag<>'DELETE'";
gvAccRecon.DataSource = dv;
gvAccRecon.DataBind();
int i = 0;
foreach (DataRow dr in dt.Rows)
{
string s = dr["ActionFlag"].ToString().Trim();
if (s == "DELETE")
{
((Button)gvAccRecon.Rows[i].FindControl("btnEdit")).Enabled = false;
((Button)gvAccRecon.Rows[i].FindControl("btnRemove")).Text = "Undo";
//((Button)gvAccRecon.Rows[i].FindControl("btnRemove")).Enabled = false;
}
i++;
}
//Set Values
object obj = new object();
if (dt.Select("DrCr='D'").Length > 0)
{
txtNoOfDrTrans.Text = dt.Select("DrCr='D' AND ActionFlag<>'DELETE'").Length.ToString();
obj = dt.Compute("SUM(Amount)", "DrCr='D' AND ActionFlag<>'DELETE'");
txtTotDrAmt.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0";
}
else
{
txtNoOfDrTrans.Text = "0";
txtTotDrAmt.Text = "0";
}
if (dt.Select("DrCr='C'").Length > 0)
{
txtNoOfCrTrans.Text = dt.Select("DrCr='C' AND ActionFlag<>'DELETE'").Length.ToString();
obj = dt.Compute("SUM(Amount)", "DrCr='C' AND ActionFlag<>'DELETE'");
txtTotCrAmt.Text = Convert.ToDecimal(obj != DBNull.Value ? obj : "0").ToString();
}
else
{
txtNoOfCrTrans.Text = "0";
txtTotCrAmt.Text = "0";
}
}
}
}
protected void SearchAction()
{
string sType = Request.QueryString["pType"];
gvData.DataSource = null;
gvData.DataBind();
if (!string.IsNullOrEmpty(sType))
{
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = new DataTable();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
#region Receive
if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.RECEIVE).PadLeft(5, '0')))
{
lgText.InnerHtml = "SP Receive Approval Queue List";
ReceiveDAL oReceiveDAL = new ReceiveDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Receive' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oReceiveDAL.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_CONFIG_UNAPPROVE_DATA] = dtTmpList;
}
}
}
#endregion Receive
#region Issue
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE).PadLeft(5, '0')))
{
lgText.InnerHtml = "SP Issue Approval Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Issue' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIssueDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpCurrencyList = (DataTable)oResult.Return;
if (dtTmpCurrencyList != null)
{
gvData.DataSource = dtTmpCurrencyList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpCurrencyList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE_UPDATE).PadLeft(5, '0')))
{
lgText.InnerHtml = "SP Issue Update Approval Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Issue Update' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIssueDAL.LoadTmpIssueUpdateDataTableList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIssueUpdateList = (DataTable)oResult.Return;
if (dtTmpIssueUpdateList != null)
{
gvData.DataSource = dtTmpIssueUpdateList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIssueUpdateList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE_OLD).PadLeft(5, '0')))
{
lgText.InnerHtml = "SP Old Customer Issue Approval Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Old Customer Issue' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIssueDAL.LoadUnapprovedOldCustomerIssueList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIssueUpdateList = (DataTable)oResult.Return;
if (dtTmpIssueUpdateList != null)
{
gvData.DataSource = dtTmpIssueUpdateList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIssueUpdateList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.SP_ISSUE_ONL).PadLeft(5, '0')))
{
lgText.InnerHtml = "SP Online Issue Approval Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'SP Online Issue' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIssueDAL.LoadUnapprovedOnlineIssueList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIssueUpdateList = (DataTable)oResult.Return;
if (dtTmpIssueUpdateList != null)
{
gvData.DataSource = dtTmpIssueUpdateList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIssueUpdateList;
}
}
#endregion Issue
#region interst payment
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.INTEREST_PAYMENT).PadLeft(5, '0')))
{
lgText.InnerHtml = "Interst Payment Approval Queue List";
InterestPaymentDAL oIntPayDAL = new InterestPaymentDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Interst Payment' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIntPayDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIntPayList = (DataTable)oResult.Return;
if (dtTmpIntPayList != null)
{
gvData.DataSource = dtTmpIntPayList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIntPayList;
}
}
#endregion interst payment
#region Encashment
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.ENCASHED).PadLeft(5, '0')))
{
lgText.InnerHtml = "Encashment Approval Queue List";
EncashmentDAL oEncashDAL = new EncashmentDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Encashment' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oEncashDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIntPayList = (DataTable)oResult.Return;
if (dtTmpIntPayList != null)
{
gvData.DataSource = dtTmpIntPayList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIntPayList;
}
}
#endregion Encashment
#region Stop Payment
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.STOP_PAYMENT_MARK).PadLeft(5, '0')))
{
lgText.InnerHtml = "Payment Mark Approval Queue List";
StopPaymentDAL oStopPayDAL = new StopPaymentDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Payment Mark' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oStopPayDAL.LoadUnapprovedPaymentMarkList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.STOP_PAYMENT_REMOVE_MARK).PadLeft(5, '0')))
{
lgText.InnerHtml = "Payment Remove Mark Approval Queue List";
StopPaymentDAL oStopPayDAL = new StopPaymentDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Payment Remove Marks' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oStopPayDAL.LoadUnapprovedPaymentRemoveMarkList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.DUPLICATE_ISSUE).PadLeft(5, '0')))
{
lgText.InnerHtml = "Duplicate Issues Approval Queue List";
DuplicateIssueDAL oDIDAL = new DuplicateIssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Duplicate Issues' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oDIDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
#endregion Stop Payment
#region Lien
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.LIEN_MARK).PadLeft(5, '0')))
{
lgText.InnerHtml = "Lien Mark Approval Queue List";
LienDAL oLienDAL = new LienDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Lien Mark' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oLienDAL.LoadUnapprovedLienMarkList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.LIEN_MARK_REMOVE).PadLeft(5, '0')))
{
lgText.InnerHtml = "Lien Mark Remove Approval Queue List";
LienDAL oLienDAL = new LienDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Lien Mark Remove' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oLienDAL.LoadUnapprovedLienRemoveMarkList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
#endregion Lien
#region Reinvestment
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.REINVESTMENT).PadLeft(5, '0')))
{
lgText.InnerHtml = "Reinvestment Approval Queue List";
ReinvestmentDAL oRiDAL = new ReinvestmentDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Reinvestment' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oRiDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
#endregion Reinvestment
#region ACE Register
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_TRANS.ACE_MANAGER).PadLeft(5, '0')))
{
lgText.InnerHtml = "ACE Registration Queue List";
IssueDAL oIssueDAL = new IssueDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIssueDAL.LoadUnapprovedACERegisterList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtList = (DataTable)oResult.Return;
if (dtList != null)
{
gvData.DataSource = dtList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtList;
}
}
#endregion ACE Register
//Make Filter By User
//Config oConfig = Session[Constants.SES_USER_CONFIG] as Config;
if (!string.IsNullOrEmpty(oConfig.FilterMakerID))
{
DDListUtil.Assign(ddlUserName, oConfig.FilterMakerID.Trim());
FilterData(oConfig.FilterMakerID.Trim());
}
}
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
AppRelativeVirtualPath = VirtualPathUtility.AppendTrailingSlash(Context.Request.Path);
Controls.Clear();
var html = new HtmlHtml();
var head = new HtmlHead();
#region HTML Head
head.Title = string.Format("Directory contents of {0}", Context.Request.Path);
var linkDataTablesCSS = new HtmlLink()
{
Href = "/static/datatables/css/jquery.dataTables.min.css"
};
linkDataTablesCSS.Attributes.Add("rel", "stylesheet");
linkDataTablesCSS.Attributes.Add("type", "text/css");
head.Controls.Add(linkDataTablesCSS);
var linkFontAwesomeCSS = new HtmlLink()
{
Href = "/static/font_awesome/css/all.min.css"
};
linkFontAwesomeCSS.Attributes.Add("rel", "stylesheet");
linkFontAwesomeCSS.Attributes.Add("type", "text/css");
head.Controls.Add(linkFontAwesomeCSS);
var styleInline = new HtmlStyle();
styleInline.InnerHtml = Properties.Resources.inlineStyleInHead;
head.Controls.Add(styleInline);
#endregion
var body = new HtmlBody();
#region HTML Body Content
var topDiv = new Panel();
topDiv.Style.Add("height", "80px");
topDiv.Controls.Add(new HtmlH2 {
InnerText = GetPath()
});
hlNavigateUp.Text = Properties.Resources.toParentDirectory;
topDiv.Controls.Add(hlNavigateUp);
body.Controls.Add(topDiv);
HtmlForm form = new HtmlForm();
var tbRptHead = new TemplateBuilder();
tbRptHead.AppendLiteralString("<table id=\"DirectoryListing\" style=\"width: 100%\"><thead><tr><th>Name</th><th>Created</th><th>Last Modified</th><th>Size</th></tr></thead><tbody>");
rptMain.ItemDataBound += RptMain_ItemDataBound;
var tbRptFoot = new TemplateBuilder();
tbRptFoot.AppendLiteralString("</tbody></table>");
rptMain.HeaderTemplate = tbRptHead;
rptMain.FooterTemplate = tbRptFoot;
form.Controls.Add(rptMain);
body.Controls.Add(form);
#endregion
#region HTML Body Foot Scripts
body.Controls.Add(new HtmlScript {
Src = "/static/jquery/jquery.js"
});
body.Controls.Add(new HtmlScript {
Src = "/static/datatables/js/jquery.dataTables.js"
});
body.Controls.Add(new HtmlScript {
InnerHtml = Properties.Resources.inlineScriptAtEnd
});
#endregion
html.Controls.Add(head);
html.Controls.Add(body);
Controls.Add(html);
}
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;
}
}
}
}
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
}
}
}
private void SearchAction()
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
string sType = Request.QueryString["pType"];
gvData.DataSource = null;
gvData.DataBind();
txtTotalDebitAmount.Text = "";
txtTotalCreditAmount.Text = "";
txtTotalNoofDebitTransaction.Text = "";
txtTotalNoofCreditTransaction.Text = "";
txtTotalBalance.Text = "";
if (!string.IsNullOrEmpty(sType) && oConfig != null)
{
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = new DataTable();
if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_JOURNAL_RECON.JOURNAL_RECON).PadLeft(5, '0')))
{
lgText.InnerHtml = "Accounting Journal Approval Queue List";
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Accounting Journal' record found");
gvData.EmptyDataTemplate = tbGvData;
JournalDAL oJournalDAL = new JournalDAL();
DateTime dtFromDate = Util.GetDateTimeByString(txtRecFromDate.Text);
DateTime dtToDate = Util.GetDateTimeByString(txtRecToDate.Text);
string sAccountNmbr = ddlAccNumbe.SelectedValue;
string sReferenceNmbr = ddlReferenceNum.SelectedValue;
Result oResult = oJournalDAL.LoadUnapprovedAccountingJournalList(sAccountNmbr, sReferenceNmbr, dtFromDate, dtToDate, oConfig.DivisionID, oConfig.BankCodeID);
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;
// detail section
object sumDrObj;
sumDrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'D' and IsReconciled=1 ");
sumDrObj = sumDrObj.ToString() == "" ? 0 : sumDrObj;
object sumCrObj;
sumCrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'C' and IsReconciled=1 ");
sumCrObj = sumCrObj.ToString() == "" ? 0 : sumCrObj;
object sumDrCountObj;
sumDrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'D' and IsReconciled=1 ");
object sumCrCountObj;
sumCrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'C' and IsReconciled=1 ");
txtTotalDebitAmount.Text = sumDrObj.ToString();
txtTotalCreditAmount.Text = sumCrObj.ToString();
txtTotalNoofDebitTransaction.Text = sumDrCountObj.ToString();
txtTotalNoofCreditTransaction.Text = sumCrCountObj.ToString();
txtTotalBalance.Text = Convert.ToString(Convert.ToDecimal(sumCrObj.ToString()) + Convert.ToDecimal(sumCrObj.ToString()));
}
}
}
}
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_JOURNAL_RECON.JOURNAL_MANUAL).PadLeft(5, '0')))
{
lgText.InnerHtml = "Menual Journal Approval Queue List";
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Menual Journal' record found");
gvData.EmptyDataTemplate = tbGvData;
//BranchDAL oBranchDAL = new BranchDAL();
JournalDAL oJournalDAL = new JournalDAL();
DateTime dtFromDate = Util.GetDateTimeByString(txtRecFromDate.Text);
DateTime dtToDate = Util.GetDateTimeByString(txtRecToDate.Text);
string sAccountNmbr = ddlAccNumbe.SelectedValue;
Result oResult = oJournalDAL.LoadUnapprovedManualAcctJournalList(sAccountNmbr, null, dtFromDate, dtToDate, oConfig.DivisionID, oConfig.BankCodeID);
if (oResult.Status)
{
DataTable dtTmpList = ((SBM_BLC1.Entity.JournalRecon.AccountReconciliation)oResult.Return).DtAccountRec;
if (dtTmpList != null)
{
if (dtTmpList.Rows.Count > 0)
{
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
// detail section
object sumDrObj;
sumDrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'D' and IsReconciled=0 ");
sumDrObj = sumDrObj.ToString() == "" ? 0 : sumDrObj;
object sumCrObj;
sumCrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'C' and IsReconciled=0 ");
sumCrObj = sumCrObj.ToString() == "" ? 0 : sumCrObj;
object sumDrCountObj;
sumDrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'D' and IsReconciled=0 ");
object sumCrCountObj;
sumCrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'C' and IsReconciled=0 ");
txtTotalDebitAmount.Text = sumDrObj.ToString();
txtTotalCreditAmount.Text = sumCrObj.ToString();
txtTotalNoofDebitTransaction.Text = sumDrCountObj.ToString();
txtTotalNoofCreditTransaction.Text = sumCrCountObj.ToString();
txtTotalBalance.Text = Convert.ToString(Convert.ToDecimal(sumCrObj.ToString()) + Convert.ToDecimal(sumCrObj.ToString()));
}
}
}
}
}
}
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_CONFIG_UNAPPROVE_DATA] = new DataTable();
#region Recon Sales Statement
if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_RECON.SALES_STATEMENT).PadLeft(5, '0')))
{
lgText.InnerHtml = "Reconciliantion Sales Statement Approval Queue List";
SaleStatementReconDAL oSaleStatmentReconDAL = new SaleStatementReconDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Reconciliantion Sale Statement' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSaleStatmentReconDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpCurrencyList = (DataTable)oResult.Return;
if (dtTmpCurrencyList != null)
{
gvData.DataSource = dtTmpCurrencyList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpCurrencyList;
}
}
#endregion Recon Sales Statement
#region Recon Commission Claim
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_RECON.COMMISSION).PadLeft(5, '0')))
{
lgText.InnerHtml = "Reconciliantion Commission Claim Approval Queue List";
CommClaimReconciliationDAL oCommClaimRecDAL = new CommClaimReconciliationDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Reconciliantion Commission Claim' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCommClaimRecDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpCurrencyList = (DataTable)oResult.Return;
if (dtTmpCurrencyList != null)
{
gvData.DataSource = dtTmpCurrencyList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpCurrencyList;
}
}
#endregion
#region Recon Interest Claim
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_RECON.INTEREST).PadLeft(5, '0')))
{
lgText.InnerHtml = "Reconciliantion Interest Claim Approval Queue List";
InterestReimbursementDAL oIntReimDAL = new InterestReimbursementDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Reconciliantion Interest Claim' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIntReimDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIssueUpdateList = (DataTable)oResult.Return;
if (dtTmpIssueUpdateList != null)
{
gvData.DataSource = dtTmpIssueUpdateList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIssueUpdateList;
}
}
#endregion
#region Recon Encashment Claim
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_RECON.ENCASHMENT).PadLeft(5, '0')))
{
lgText.InnerHtml = "Reconciliantion Encashment Claim Approval Queue List";
EncashmentReimbursementDAL oEncashReimDAL = new EncashmentReimbursementDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Reconciliantion Encashment Claim' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oEncashReimDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIssueUpdateList = (DataTable)oResult.Return;
if (dtTmpIssueUpdateList != null)
{
gvData.DataSource = dtTmpIssueUpdateList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIssueUpdateList;
}
}
#endregion
//Make Filter By User
if (!string.IsNullOrEmpty(oConfig.FilterMakerID))
{
DDListUtil.Assign(ddlUserName, oConfig.FilterMakerID.Trim());
FilterData(oConfig.FilterMakerID.Trim());
}
}
}