protected void btn_BalanceOnClick(Object sender, EventArgs e)
{
errorDiv1.Visible = false;
lbl_error.Text = "";
try
{
createTables();
bankReport();
remitReport();
detailReport();
getAdjustments();
summaryReport();
SetNoRecsMsg();
//data build tables
VWA_Results.SavePrintBalFiles(_category, ddlYrmo.SelectedItem.Text, tbSum1, tbSum2, tbFinal);
VWA_ExportDAL.insertReconDt(ddlYrmo.SelectedItem.Text);
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskR(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "VWA", "Balancing", "Balancing", ddlYrmo.SelectedItem.Text);
resultdiv.Visible = true;
}
catch (Exception ex)
{
lbl_error.Text = ex.Message;
}
}
void SetNoRecsMsg(string yrmo)
{
if (VWA_ExportDAL.HasRecords(yrmo, "RemitDisp"))
{
lbl_discp.Visible = false;
}
else
{
lbl_discp.Visible = true;
}
if (VWA_ExportDAL.HasRecords(yrmo, "RemitInput"))
{
lbl_input.Visible = false;
}
else
{
lbl_input.Visible = true;
}
}
void SetNoRecsMsg(string yrmo)
{
if (VWA_ExportDAL.HasRecords(yrmo, "TranMis"))
{
lbl_miss.Visible = false;
}
else
{
lbl_miss.Visible = true;
}
if (VWA_ExportDAL.HasRecords(yrmo, "TranClient"))
{
lbl_client.Visible = false;
}
else
{
lbl_client.Visible = true;
}
if (VWA_ExportDAL.HasRecords(yrmo, "TranGrp"))
{
lbl_grp.Visible = false;
}
else
{
lbl_grp.Visible = true;
}
if (VWA_ExportDAL.HasRecords(yrmo, "TranStat"))
{
lbl_cnt.Visible = false;
}
else
{
lbl_cnt.Visible = true;
}
if (VWA_ExportDAL.HasRecords(yrmo, "TranACCTG"))
{
lbl_fin.Visible = false;
}
else
{
lbl_fin.Visible = true;
}
if (VWA_ExportDAL.HasRecords(tbx_agedDays.Text.ToString(), "TranAging"))
{
lbl_age.Visible = false;
}
else
{
lbl_age.Visible = true;
}
if (VWA_ExportDAL.HasRecords(yrmo, "TranStatCtr"))
{
lbl_statCtr.Visible = false;
}
else
{
lbl_statCtr.Visible = true;
}
}