protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.AllKeys.Contains("ReportType"))
{
DataTable ExportDT = CRBusinessLogicLayer.NPA_DETAILS_REPORT(Convert.ToInt32(Request.QueryString["EXID"]), Request.QueryString["BankID"], Request.QueryString["Branch"], Convert.ToInt32(Request.QueryString["CityID"]), Request.QueryString["FDATE"], Request.QueryString["TDATE"]);
if (ExportDT.Rows.Count > 0)
{
CRBusinessLogicLayer.GENERATEREPORT(ExportDT, "NPA DETAILS", Convert.ToInt32(Request.QueryString["ReportType"]));
}
else
{
Response.Redirect("~/DailyTransactions/NPADetails1.aspx?Error='No data to display'", false);
}
}
if (Request.QueryString.AllKeys.Contains("NPAID"))
{
CRBusinessLogicLayer.NPA_DETAILS_RECOVERY_REPORT(Request.QueryString["NPAID"]);
}
if (Request.QueryString.AllKeys.Contains("docurl"))
{
string name = Request.QueryString["docurl"];
var dt = (DataTable)Session["DtDocbytes"];
DataTable dtssss = (from m in dt.AsEnumerable() where m.Field <Int32>("ID") == Convert.ToInt32(name) select m).CopyToDataTable();
DownloadDOCFile(((byte[])dtssss.Rows[0]["UFILE_BYTES"]), dtssss.Rows[0]["UFILE_NAME"].ToString(), dtssss.Rows[0]["UFILE_TYPE"].ToString());
Response.End();
}
LoginRequired = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.AllKeys.Contains("ReportType"))
{
DataTable ExportDT = CRBusinessLogicLayer.RECOVERY_BILL_DETAILS(Convert.ToInt32(Request.QueryString["EXECUTIVE"]), Request.QueryString["BANK"], Request.QueryString["BRANCH"], Convert.ToInt32(Request.QueryString["NPAID"]), Request.QueryString["FDATE"], Request.QueryString["TDATE"]);
if (ExportDT.Rows.Count > 0)
{
CRBusinessLogicLayer.GENERATEREPORT(ExportDT, "RECOVERY BILL DETAILS", Convert.ToInt32(Request.QueryString["ReportType"]));
}
else
{
Response.Redirect("~/DailyTransactions/RecoveryBillDetails.aspx?Error='No data to display'", false);
}
}
else if (Request.QueryString.AllKeys.Contains("RecoveryBillID"))
{
try
{
var BillDt = CRBusinessLogicLayer.RECOVERY_BILL_SN(HttpContext.Current.Server.UrlDecode(Request.QueryString["RecoveryBillID"]));
if (BillDt.Rows.Count > 0)
{
CRBusinessLogicLayer.RECOVERY_BILL_PAYMENT_LETTER(BillDt, "ST001", "AAACK8658H");
}
else
{
Response.Redirect("~/DailyTransactions/RecoveryBillDetails.aspx?Error='Please enter valid serial number.'", true);
}
}
catch (Exception)
{
// ignored
}
}
LoginRequired = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.AllKeys.Contains("ReportType"))
{
CRBusinessLogicLayer.GENERATEREPORT(CRBusinessLogicLayer.LOAN_ACCOUNT_DETAILS().Tables[0], "LOAN ACCOUNT DETAILS", Convert.ToInt32(Request.QueryString["ReportType"]));
}
LoginRequired = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.AllKeys.Contains("ReportType"))
{
CRBusinessLogicLayer.GENERATEREPORT(CRBusinessLogicLayer.TARGET_GET_REPORT(), "TARGET DETAILS", Convert.ToInt32(Request.QueryString["ReportType"]));
}
LoginRequired = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.AllKeys.Contains("ReportType"))
{
DataTable ExportDT = CRBusinessLogicLayer.BANK_VISIT_DETAILS(Convert.ToInt32(Request.QueryString["EXID"]), Convert.ToInt32(Request.QueryString["BankID"]), Request.QueryString["FDATE"].ToString(), Request.QueryString["TDATE"].ToString());
if (ExportDT.Rows.Count > 0)
{
CRBusinessLogicLayer.GENERATEREPORT(ExportDT, "BANK VISIT DETAILS", Convert.ToInt32(Request.QueryString["ReportType"]));
}
else
{
Response.Redirect("~/DailyTransactions/BankVisitDetails.aspx", false);
}
}
LoginRequired = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.AllKeys.Contains("ReportType"))
{
DataTable ExportDT = CRBusinessLogicLayer.EXECUTIVE_REPORT(Convert.ToInt32(Request.QueryString["EXID"]), Request.QueryString["Bank"], Request.QueryString["Branch"], Convert.ToInt32(Request.QueryString["NPAID"])).Tables[0];
if (ExportDT.Rows.Count > 0)
{
CRBusinessLogicLayer.GENERATEREPORT(ExportDT, "Executive Report", Convert.ToInt32(Request.QueryString["ReportType"]));
}
else
{
Response.Redirect("~/Reports/ExecutiveReport.aspx?Error='No data to display'", false);
}
}
LoginRequired = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.AllKeys.Contains("ReportType"))
{
DataTable ExportDT = CRBusinessLogicLayer.EXECUTIVE_VISIT_DETAILS(Convert.ToInt32(Request.QueryString["EXID"]), Request.QueryString["FDATE"], Request.QueryString["TDATE"], Request.QueryString["BANK"], Request.QueryString["BRANCH"], Convert.ToInt32(Request.QueryString["CITYID"]));
if (ExportDT.Rows.Count > 0)
{
CRBusinessLogicLayer.GENERATEREPORT(ExportDT, "RECORDS OF VISIT", Convert.ToInt32(Request.QueryString["ReportType"]));
}
else
{
Response.Redirect("~/DailyTransactions/ExecutiveWiseVisitDetails.aspx?Error='No data to display'", false);
}
}
LoginRequired = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.AllKeys.Contains("ReportType"))
{
DataTable ExportDT = CRBusinessLogicLayer.RECOVERY_STATEMENT_REPORT(null, Request.QueryString["BANK"], Request.QueryString["BRANCH"], Convert.ToInt32(Request.QueryString["NPAID"]), Convert.ToInt32(Request.QueryString["STATUS"]), Request.QueryString["FDATE"], Request.QueryString["TDATE"]);
if (ExportDT.Rows.Count > 0)
{
CRBusinessLogicLayer.GENERATEREPORT(ExportDT, "RECOVERY STATEMENT", Convert.ToInt32(Request.QueryString["ReportType"]));
}
else
{
Response.Redirect("~/DailyTransactions/RecoveryStatement.aspx?Error='No data to display'", false);
}
}
LoginRequired = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.AllKeys.Contains("DTemp"))
{
if (Convert.ToInt32(Request.QueryString["DTemp"]) == 1)
{
DownloadTemplate();
}
else
{
DownloadSampleTemplate();
}
}
if (Request.QueryString.AllKeys.Contains("City"))
{
var ExportDT = CRBusinessLogicLayer.EXCEL_UPLOAD_DATA_XML_CHECK((DataTable)HttpContext.Current.Session["EXCELUPLOAD"], Convert.ToInt32(Request.QueryString["City"])).Tables[2];
if (ExportDT.Rows.Count > 0)
{
CRBusinessLogicLayer.GENERATEREPORT(ExportDT, "UPLOAD EXCEL", 1);
}
}
LoginRequired = true;
}