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;
}
public static void BANK_VISIT_INSERT_UPDATE(string BankVisitID, string ExecutiveName, string BankName, string PurposeOfVisit, string Active, string Date)
{
try
{
CRBusinessLogicLayer.BANK_VISIT_INSERT_UPDATE(BankVisitID, ExecutiveName, BankName, PurposeOfVisit, Active, Date);
}
catch (Exception)
{
}
}
public static void INSERTANDUPDATEFARMERDETAILS(string FarmerID, string Name, string Location, string ContactNo, string PanNo, string BankAccountNo, string Active)
{
try
{
CRBusinessLogicLayer.FARMER_DETAILS_INSERT_UPDATE(FarmerID == "" ? 0 : Convert.ToInt32(FarmerID), Name, Location, ContactNo, PanNo, BankAccountNo, Active);
}
catch (Exception ex)
{
logfile.ErrorFormat(ex.Message);
}
}
public static string EXECUTIVE_DROPDOEN_GET(int?City)
{
try
{
return(CRBusinessLogicLayer.DASHBOARD_EXECUTIVE_DROPDOEN_GET(City).GetXml());
}
catch (Exception)
{
}
return(null);
}
public static string BANK_DROPDOWN_GET(int?City)
{
try
{
return(CRBusinessLogicLayer.DASH_BOARD_BANK_DROPDOWN_GET(City).GetXml());
}
catch (Exception)
{
}
return(null);
}
public static void EXECUTEWISEDETAILS_INSERT_UPDATE(string EWVID, string ExecutiveName, string NPADetails, string Date, string LoanAmount, string AmountRecovered, string BalanceAmount, string Comments, string NextDateForVisit, string Active, string BankRangeType)//string PlaceVisited,
{
try
{
CRBusinessLogicLayer.EXECUTEWISEDETAILS_INSERT_UPDATE(EWVID, ExecutiveName, NPADetails, Date, LoanAmount, AmountRecovered, BalanceAmount, Comments, NextDateForVisit, Active, BankRangeType);//, PlaceVisited
}
catch (Exception)
{
// ignored
}
}
public static void RECOVERY_STATEMENT_INSERT_UPDATE(string RecoveryStatementID, string BankName, string NPADetails, string BillAmountRecovered, string Date, string Amountlesspaid, string TDS, string Active)
{
try
{
CRBusinessLogicLayer.RECOVERY_STATEMENT_INSERT_UPDATE(RecoveryStatementID, BankName, NPADetails, BillAmountRecovered, Date, Amountlesspaid, TDS, Active);
}
catch (Exception)
{
// ignored
}
}
public static string AddNewCity(string CityID, string AddCityName)
{
try
{
return(CRBusinessLogicLayer.AddCity(CityID, AddCityName));
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static string BANKVISIT_GET_BY_BANKVISITID(string BankVisitID)
{
try
{
return(CRBusinessLogicLayer.BANKVISIT_GET_BY_BANKVISITID(Convert.ToInt32(BankVisitID)).GetXml());
}
catch (Exception)
{
}
return(null);
}
public static string EXECUTIVE_DROPDOEN_GET()
{
try
{
return(CRBusinessLogicLayer.EXECUTIVE_DROPDOEN_GET().GetXml());
}
catch (Exception)
{
}
return(null);
}
public static void INSERTANDUPDATELOANACCOUNTDETAILS(string LoanAccountID, string LoanAccountDetails, string PurposeOfLoan, string Description, string Active)
{
try
{
CRBusinessLogicLayer.LOAN_ACCOUNT_DETAILS_INSERT_UPDATE(LoanAccountID, LoanAccountDetails, PurposeOfLoan, Description, Active);
}
catch (Exception)
{
// ignored
}
}
public static string GET_BANK_VISIT_RELATED_DATA(int?EXID, int?BankID, string FDATE, string TDATE)
{
try
{
return(CRBusinessLogicLayer.GET_BANK_VISIT_RELATED_DATA(EXID, BankID, FDATE, TDATE).GetXml());
}
catch (Exception)
{
}
return(null);
}
public static string CITY_GET()
{
try
{
return(CRBusinessLogicLayer.CITY_GET().GetXml());
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static string BRANCH_DROPDOWN_GET(string BANK)
{
try
{
return(CRBusinessLogicLayer.BRANCH_DROPDOWN_GET(BANK).GetXml());
}
catch (Exception)
{
}
return(null);
}
public static void RECOVERYBILLDETAILS_INSERT_UPDATE(string RecoveryBillID, string ExecutiveName, string NPADetails, string RecoveredAmount, string BalanceAmount, string RecoveredDate, string RecoveredAmountCommission, string ServiceTax, string TotalCommission, string BoardCharges, string TransportCharges, string ValuationCharges, string Surveyorcharges, string PropertyIdentificationcharges, string InvestigationCharges, string MiscellaneousCharges, string Active, string BankRangeType)
{
try
{
CRBusinessLogicLayer.RECOVERYBILLDETAILS_INSERT_UPDATE(RecoveryBillID, ExecutiveName, NPADetails, RecoveredAmount, BalanceAmount, RecoveredDate, RecoveredAmountCommission, ServiceTax, TotalCommission, BoardCharges, TransportCharges, ValuationCharges, Surveyorcharges, PropertyIdentificationcharges, InvestigationCharges, MiscellaneousCharges, Active, BankRangeType);
}
catch (Exception)
{
// ignored
}
}
public static string TARGET_GET_EDIT(int TargetID)
{
try
{
return(CRBusinessLogicLayer.TARGET_GET_EDIT(TargetID).GetXml());
}
catch (Exception)
{
// ignored
}
return(null);
}
public static string UserChangePassword(string UserName, string NewPassword)
{
try
{
CRBusinessLogicLayer.UpdatePassword(UserName, NewPassword);
return("Successfully Saved New Password");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static string EXECUTIVE_REPORT_GET_BY_BANKID(int?EXID, string BANK, string BRANCH)
{
try
{
return(CRBusinessLogicLayer.EXECUTIVE_REPORT_BY_BANK_BRANCH(EXID, BANK, BRANCH).GetXml());
}
catch (Exception)
{
// ignored
}
return(null);
}
public static string EXECUTIVE_REPORT_GET(int?EXID, string Bank, string Branch, int?NPAID)
{
try
{
return(JsonConvert.SerializeObject(CRBusinessLogicLayer.EXECUTIVE_REPORT(EXID, Bank, Branch, NPAID).Tables[0]));
}
catch (Exception)
{
// ignored
}
return(null);
}
public static string DROP_DOWN_BRANCH_FOR_REPORT(string BANK)
{
try
{
return(CRBusinessLogicLayer.BRANCH_DROPDOWN_GET(BANK).GetXml());
}
catch (Exception)
{
// ignored
}
return(null);
}
public static string DELETE_LOANACCOUNT(string LoanAccountID)
{
try
{
return(CRBusinessLogicLayer.DELETE_LOAN_ACCOUNT_RELATED_DATA(Convert.ToInt32(LoanAccountID)));
}
catch (Exception)
{
// ignored
}
return(null);
}
public static string LOAN_ACCOUNT_GET_EDIT(string LoanAccountID)
{
try
{
return(CRBusinessLogicLayer.GET_LOAN_ACCOUNT_RELATED_DATA(Convert.ToInt32(LoanAccountID)).GetXml());
}
catch (Exception)
{
// ignored
}
return(null);
}
public static string GET_LOAN_ACCOUNT_RELATED_DATA()
{
try
{
return(CRBusinessLogicLayer.GET_LOAN_ACCOUNT_RELATED_DATA(null).GetXml());
}
catch (Exception)
{
// ignored
}
return(null);
}
public static string DELETENPADetails(string NPAID)
{
try
{
return(CRBusinessLogicLayer.DELETENPADetails(Convert.ToInt32(NPAID)).GetXml());
}
catch (Exception)
{
// ignored
}
return(null);
}
public static string NPADETAILS_PURPOSEOFLOAN_GET(int Type)
{
try
{
return(CRBusinessLogicLayer.NPADETAILS_PURPOSEOFLOAN_GET(Convert.ToBoolean(Type)).GetXml());
}
catch (Exception)
{
// ignored
}
return(null);
}
public static string NPADETAILS_INSERT_UPDATE(string NPADetailsID, string ACNo, string ExecutiveID, string BankName, string BorrowerName, string BorrowerAddress, string PHNumber, string CoAppicant, string Guaranty, string GuarantyAddress, string GuarantyPHNumber, string DateOfSanction, string TypeOfLoan, string Purposeofloan, string SecurityDetails, string OutstandingBalance, string DemandNoticeIssued, string Active, string NPADate, string City, string Location, string SymbolicPosition, string Date, string CMMOrderApplied, string AdvocateName, string ADVTContactNo, string PhysicalPosition, string PhyPoDate, string IdtofProperty)
{
try
{
return(CRBusinessLogicLayer.NPADETAILS_INSERT_UPDATE(NPADetailsID, ACNo, ExecutiveID, BankName, BorrowerName, BorrowerAddress, PHNumber, CoAppicant, Guaranty, GuarantyAddress, GuarantyPHNumber, DateOfSanction, TypeOfLoan, Purposeofloan, SecurityDetails, OutstandingBalance, DemandNoticeIssued, Active, NPADate, City, Location, SymbolicPosition, Date, CMMOrderApplied, AdvocateName, ADVTContactNo, PhysicalPosition, PhyPoDate, IdtofProperty, "", "", null).ToString());
}
catch (Exception)
{
// ignored
}
return(null);
}
public static string BANK_DROPDOWN_FOR_REPORT()
{
try
{
return(CRBusinessLogicLayer.BANK_DROPDOWN_FOR_REPORT().GetXml());
}
catch (Exception)
{
// ignored
}
return(null);
}
