protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request.QueryString["id"] != null)
{
int id=Convert.ToInt32(Request.QueryString["id"]);
string val = Request.QueryString["action"];
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
if (val=="reinstate")
{
LoanDS.LoanApplicationsRow rLoanApp = loanApp.GetLoanApplication(id.ToString())[0];
if (rLoanApp.IsdatReinstateIDNull() == false)
{
int reinstateid = rLoanApp.datReinstateID;
loanApp.UpdateAppReinstate(reinstateid, id);
}
}
else if( val=="delete")
{
loanApp.UpdateAppReinstate(null, id);
}
}
}catch(Exception ex){}
}
public void setNotifications()
{
mainDSTableAdapters.NotificationCountTableAdapter tblCounter = new mainDSTableAdapters.NotificationCountTableAdapter();
mainDS.NotificationCountRow itemcount = tblCounter.NotificationCount(MySessionManager.CurrentUser.BranchID, MySessionManager.CurrentUser.UserID, MySessionManager.CurrentUser.TeamID)[0];
this.initassinfo.InnerText = itemcount.intialassessment.ToString();
this.preapprovedinfo.InnerText = itemcount.preapproval.ToString();
this.Approvedinfo.InnerText = itemcount.approvedloans.ToString();
this.Apprinfo.InnerText = (Convert.ToInt32(itemcount.approvalI.ToString()) + Convert.ToInt32(itemcount.approvalII.ToString()) + Convert.ToInt32(itemcount.approvalIII.ToString()) + Convert.ToInt32(itemcount.approvalIV.ToString()) + Convert.ToInt32(itemcount.approvalV.ToString())).ToString();
this.Appraisalinfo.InnerText = itemcount.appraisal.ToString();
this.legalinfo.InnerText = itemcount.legal.ToString();
this.riskinfo.InnerText = itemcount.risk.ToString();
//this.reviewinfo.InnerText = itemcount.cmreview.ToString();
this.disbinfo.InnerText = (Convert.ToInt32(itemcount.disbursementI.ToString()) + Convert.ToInt32(itemcount.disbursementII.ToString())).ToString();
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int status = Convert.ToInt32(loanApp.getApplicationStatus(MySessionManager.AppID));
if (status == 13)
{
this.disbinfo.InnerText = itemcount.disbursementI.ToString();
}
else if (status == 14)
{
this.disbinfo.InnerText = itemcount.disbursementII.ToString();
}
else if (status == 15)
{
this.disbinfo.InnerText = itemcount.disbursementIII.ToString();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
string stage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString());
string role = util.displayValue("opt_levels", MySessionManager.CurrentUser.RoleID.ToString());
string appStage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString());
LoanDSTableAdapters.CommentsTableAdapter comments = new LoanDSTableAdapters.CommentsTableAdapter();
LoanDS.CommentsDataTable tblComments = comments.GetSpecificComments(MySessionManager.AppID, MySessionManager.ClientID, appStage);
if (!(tblComments.Rows.Count > 0))
{
comments.InsertComment(role,
stage,
txtDescription.Value.Trim(),
MySessionManager.ClientID,
MySessionManager.AppID,
MySessionManager.CurrentUser.UserID);
this.editskip.Value = "1";
}
else
{
int id = Convert.ToInt32(tblComments[0].datID.ToString());
comments.UpdateComment(txtDescription.Value.Trim(),
id);
this.editskip.Value = "1";
}
}
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID));
if (cmbAction.Text == "Forward Application")
{
try
{
int ctID = Convert.ToInt32(ddlCreditTeam.SelectedValue);
util.UpdateApplicationStatus("Forward Application", AppStage);
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.AssignCreditTeam(ctID, MySessionManager.AppID);
Response.Redirect("~/pages/loanapplications.aspx", true);
}
catch (Exception ex) { }
}
else if (cmbAction.Text == "Send Back For Review")
{
util.UpdateApplicationStatus("Send Back For Review", AppStage);
Response.Redirect("~/pages/loanapplications.aspx", true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
string stage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString());
string role = util.displayValue("opt_levels", MySessionManager.CurrentUser.RoleID.ToString());
string appStage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString());
LoanDSTableAdapters.CommentsTableAdapter comments = new LoanDSTableAdapters.CommentsTableAdapter();
LoanDS.CommentsDataTable tblComments = comments.GetSpecificComments(MySessionManager.AppID, MySessionManager.ClientID, appStage);
if (!(tblComments.Rows.Count > 0))
{
comments.InsertComment(role,
stage,
txtDescription.Value.Trim(),
MySessionManager.ClientID,
MySessionManager.AppID,
MySessionManager.CurrentUser.UserID);
this.editskip.Value = "1";
}
else
{
int id = Convert.ToInt32(tblComments[0].datID.ToString());
comments.UpdateComment(txtDescription.Value.Trim(),
id);
this.editskip.Value = "1";
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
LoanDSTableAdapters.LoanFeesTableAdapter fee = new LoanDSTableAdapters.LoanFeesTableAdapter();
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
decimal amt = Convert.ToDecimal(txtAmt.Value.Trim());
int pmode = Convert.ToInt32(ddlPaymentMode.Text);
if (!(type == "update"))
{
fee.InsertLoanFee(MySessionManager.ClientID,
MySessionManager.AppID,
Convert.ToInt32(ddlFee.Text),
pmode,
Convert.ToDecimal(txtPercentage.Value),
amt);
}
else if (type == "update")
{
fee.UpdateLoanFees(Convert.ToInt32(ddlFee.Text),
Convert.ToInt32(ddlPaymentMode.Text),
Convert.ToDecimal(txtPercentage.Value),
amt,
id);
}
updateLoanAmount("add", amt, pmode, 0);
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "fedit"));
}
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID));
Utility utilClass = new Utility();
if (cmbAction.Text == "Forward Application")
{
ShowMessageBox("Are u sure on forwarding the application");
utilClass.UpdateApplicationStatus("Forward Application To Approval", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
else if (cmbAction.Text == "Forward To Risk")
{
utilClass.UpdateApplicationStatus("Forward To Risk", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
else if (cmbAction.Text == "Forward To Legal")
{
utilClass.UpdateApplicationStatus("Forward To Legal", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
else if (cmbAction.Text == "Send Back For Review")
{
utilClass.UpdateApplicationStatus("Send Back For Review", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
}
public void setUrls()
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int status = Convert.ToInt32(loanApp.getApplicationStatus(MySessionManager.AppID));
if (status == 13)
{
this.btnTransEntry.Visible = false;
this.btnEditPV.Visible = false;
this.btnPreparePV.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=2&ops=load";
}
else if (status == 14)
{
this.btnPreparePV.Visible = false;
this.btnTransEntry.Visible = false;
this.btnEditPV.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=6&ops=load";
}
else if (status == 15)
{
this.btnPreparePV.Visible = false;
this.btnEditPV.Visible = false;
this.btnTransEntry.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=5&ops=load";
this.divSubmit.Visible = false;
}
this.btnApplicationDetails.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=1&ops=load";
this.btnPVReport.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=3&ops=load";
this.btnSupDocs.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=4&ops=load";
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
LoanDSTableAdapters.LoanFeesTableAdapter fee = new LoanDSTableAdapters.LoanFeesTableAdapter();
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
decimal amt = Convert.ToDecimal(txtAmt.Value.Trim());
int pmode = Convert.ToInt32(ddlPaymentMode.Text);
if (!(type == "update"))
{
fee.InsertLoanFee(MySessionManager.ClientID,
MySessionManager.AppID,
Convert.ToInt32(ddlFee.Text),
pmode,
Convert.ToDecimal(txtPercentage.Value),
amt);
}
else if (type == "update")
{
fee.UpdateLoanFees(Convert.ToInt32(ddlFee.Text),
Convert.ToInt32(ddlPaymentMode.Text),
Convert.ToDecimal(txtPercentage.Value),
amt,
id);
}
updateLoanAmount("add", amt, pmode, 0);
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "fedit"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
string val = Request.QueryString["action"];
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
if (val == "reinstate")
{
LoanDS.LoanApplicationsRow rLoanApp = loanApp.GetLoanApplication(id.ToString())[0];
if (rLoanApp.IsdatReinstateIDNull() == false)
{
int reinstateid = rLoanApp.datReinstateID;
loanApp.UpdateAppReinstate(reinstateid, id);
}
}
else if (val == "delete")
{
loanApp.UpdateAppReinstate(null, id);
}
}
}catch (Exception ex) {}
}
public void createAccount()
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
mainDS.ClientDataTable tblClient = client.GetClientProfile(MySessionManager.ClientID);
decimal interestrate = Convert.ToDecimal(tblLoanApp[0].datInterestRate.ToString());
decimal IntAmt = (Convert.ToDecimal(lbltotalamt.InnerText) * (interestrate / 100));
interestamt = IntAmt;
decimal AmtOut = Convert.ToDecimal(lbltotalamt.InnerText);
decimal FinRptBalance_monthly = IntAmt + AmtOut;
DateTime enddate = addMonth(DateTime.Now, Convert.ToInt32(tblLoanApp[0].datDuration.ToString()));
if ((tblClient.Rows.Count > 0) || (tblLoanApp.Rows.Count > 0))
{
int refreshedID = 0;
if (tblLoanApp[0].IsdatRefreshedIDNull() == false)
{
refreshedID = tblLoanApp[0].datRefreshedID;
}
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter account = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
account.InsertLoanAccount(createAccountNumber(MySessionManager.ClientID),
Convert.ToDecimal(tblLoanApp[0].datFees.ToString()),
MySessionManager.ClientID,
MySessionManager.AppID,
Convert.ToInt32(tblLoanApp[0].datTeamID.ToString()),
DateTime.Now,
enddate,
Convert.ToInt32(tblLoanApp[0].datInterestRate),
Convert.ToInt32(tblLoanApp[0].datDuration.ToString()),
0,
IntAmt,
AmtOut,
FinRptBalance_monthly,
MySessionManager.CurrentUser.UserID,
FinRptBalance_monthly,
DateTime.Now,
DateTime.Now,
Convert.ToInt32(tblLoanApp[0].datPurpose.ToString()),
IntAmt,
refreshedID,
Convert.ToInt32(tblLoanApp[0].datCreditTeamID.ToString()),
tblClient[0].datClientName.ToString(),
Convert.ToInt32(tblLoanApp[0].datLoanType.ToString()));
}
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountDataTable tblLoanAc = loanAc.GetLoanAccount1(MySessionManager.AppID, MySessionManager.ClientID);
if (tblLoanAc.Rows.Count > 0)
{
MySessionManager.AccountID = tblLoanAc[0].datID;
MySessionManager.AppBranchID = tblLoanApp[0].datTeamID;
}
}
public void loadLoanDetails(int AppID)
{
try{
// DateTime myDateTime = DateTime.Parse(txtFirstPaymentDate.Text, usCulture.DateTimeFormat).To;
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable loanAppDetails = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
if (loanAppDetails.Rows.Count > 0)
{
txtLoanAmount.Value = loanAppDetails[0].datLoanAmount.ToString();
txtDuration.Value = loanAppDetails[0].datDuration.ToString();
txtFirstPaymentDate.Text = DateTime.Parse(loanAppDetails[0].datFirstPaymentDate.ToString()).ToString("dd-MM-yyyy");
txtNoYrs.Value = loanAppDetails[0].datNumberOfYears.ToString();
txtInterestrate.Value = loanAppDetails[0].datInterestRate.ToString();
if (loanAppDetails[0].IsdatLoanTypeNull() == false)
{
ddlLoanType.SelectedValue = loanAppDetails[0].datLoanType.ToString();
}
if (loanAppDetails[0].IsdatInterestRateNull() == false)
{
ddlInterestRate.SelectedValue = loanAppDetails[0].datInterestRateType.ToString();
}
if (loanAppDetails[0].IsdatPurposeNull() == false)
{
ddlloanpurpose.SelectedValue = loanAppDetails[0].datPurpose.ToString();
}
if (loanAppDetails[0].IsdatTypeOfBusinessNull() == false)
{
ddlTypeOfBusiness.SelectedValue = loanAppDetails[0].datTypeOfBusiness.ToString();
}
if (loanAppDetails[0].IsdatAveMonthlyIncomeNull() == false)
{
txtAveMonthlyIncome.Value = loanAppDetails[0].datAveMonthlyIncome.ToString();
}
if (loanAppDetails[0].IsdatNatureOfBusinessNull() == false)
{
txtNatureOfBusiness.Value = loanAppDetails[0].datNatureOfBusiness.ToString();
}
string ApNo = loanAppDetails[0].datApplicationNumber.ToString();
if (ApNo == "")
{
this.appCode.Value = (100000 + (Convert.ToInt32(loanAppDetails[0].datID.ToString()))).ToString();
}
else
{
this.appCode.Value = loanAppDetails[0].datApplicationNumber.ToString();
}
this.editskip.Value = "2";
}
else
{
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void btnSaveAlert_Click(object sender, EventArgs e)
{
string EncID = appID.Value.Trim();
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.saveAlert(alertmsg.Value,
DecID);
}
public void loadLoanDetails(int AppID)
{
try
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable loanAppDetails = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
if (loanAppDetails.Rows.Count > 0)
{
string ApNo;
try { ApNo = loanAppDetails[0].datApplicationNumber.ToString(); }
catch (Exception ex) { ApNo = ""; }
if (ApNo == "")
{
this.appCode.Value = (100000 + (Convert.ToInt32(loanAppDetails[0].datID.ToString()))).ToString();
}
else
{
this.appCode.Value = loanAppDetails[0].datApplicationNumber.ToString();
}
this.editskip.Value = "2";
if (loanAppDetails[0].IsdatLoanAmountNull() == false) { txtLoanAmount.Value = loanAppDetails[0].datLoanAmount.ToString(); }
if (loanAppDetails[0].IsdatDurationNull() == false) { txtDuration.Value = loanAppDetails[0].datDuration.ToString();}
if (loanAppDetails[0].IsdatFirstPaymentDateNull() == false) { txtFirstPaymentDate.Text = DateTime.Parse(loanAppDetails[0].datFirstPaymentDate.ToString()).ToString("dd-MM-yyyy");}
if (loanAppDetails[0].IsdatInterestRateNull() == false) { txtInterestrate.Value = loanAppDetails[0].datInterestRate.ToString(); }
try
{
ddlLoanType.ClearSelection();
ddlTypeOfBusiness.ClearSelection();
ddlloanpurpose.ClearSelection();
ddlInterestRate.ClearSelection();
if (loanAppDetails[0].IsdatLoanTypeNull()==false) { ddlLoanType.SelectedValue = loanAppDetails[0].datLoanType.ToString(); }
if (loanAppDetails[0].IsdatInterestRateTypeNull()==false) { ddlInterestRate.SelectedValue = loanAppDetails[0].datInterestRateType.ToString(); }
if (loanAppDetails[0].IsdatPurposeNull()==false) { ddlloanpurpose.SelectedValue = loanAppDetails[0].datPurpose.ToString(); }
if (loanAppDetails[0].IsdatTypeOfBusinessNull()==false) { ddlTypeOfBusiness.SelectedValue = loanAppDetails[0].datTypeOfBusiness.ToString(); }
}
catch (Exception ex) { }
txtAveMonthlyIncome.Value = loanAppDetails[0].datAveMonthlyIncome.ToString();
}
else
{ }
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void RemoveAlert()
{
string msg = this.pAlertmsg.InnerText;
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.saveAlert("",
MySessionManager.AppID);
LoanDSTableAdapters.AlertLogsTableAdapter alertLog = new LoanDSTableAdapters.AlertLogsTableAdapter();
// LoanDS.AlertLogsDataTable tblAlertLog = alertLog.
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
this.ObjectDataSource2.SelectParameters["ClientID"].DefaultValue = loanApp.getClientID(MySessionManager.AppID).ToString();
this.rvPreagreement.DataBind();
this.rvPreagreement.LocalReport.Refresh();
}
catch (Exception ex) { }
}
protected void Page_Load(object sender, EventArgs e)
{
Utility util = new Utility();
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(Convert.ToString(MySessionManager.AppID));
if (tblLoanApp.Rows.Count > 0)
{
if (!(this.editskip.Value == "2"))
{
if (tblLoanApp[0].IsdatDurationNull() == false)
{
txtperiod.Text = tblLoanApp[0].datDuration.ToString();
}
if (tblLoanApp[0].IsdatInterestRateNull() == false)
{
txtinterestrate.Text = tblLoanApp[0].datInterestRate.ToString();
}
if (tblLoanApp[0].IsdatInterestRateTypeNull() == false)
{
txtinterestrateType.Text = util.displayValue("opt_interest_rate_types", tblLoanApp[0].datInterestRateType.ToString());
}
if (tblLoanApp[0].IsdatFirstPaymentDateNull() == false)
{
txtfirstpaymentdate.Text = tblLoanApp[0].datFirstPaymentDate.ToString("dd-MM-yyyy");
}
txtFrequency.Text = util.displayValue("opt_frequencies", tblLoanApp[0].datFrequency.ToString());
if (tblLoanApp[0].IsdatLoanAmountNull() == false)
{
txtprincipal.Text = tblLoanApp[0].datLoanAmount.ToString();
}
this.editskip.Value = "2";
int mnths = Convert.ToInt32(tblLoanApp[0].datDuration.ToString());
double per = Convert.ToDouble(tblLoanApp[0].datInterestRate.ToString());
double amt = Convert.ToDouble(tblLoanApp[0].datLoanAmount.ToString());
try
{
GenerateMonths(mnths, DateTime.Parse(txtfirstpaymentdate.Text));
}
catch (Exception ex) { }
}
else
{
int mnths = Convert.ToInt32(txtperiod.Text);
double per = Convert.ToDouble(txtinterestrate.Text);
double amt = Convert.ToDouble(txtprincipal.Text);
try
{
GenerateMonths(mnths, DateTime.Parse(txtfirstpaymentdate.Text));
}
catch (Exception ex) { }
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
this.ObjectDataSource2.SelectParameters["ClientID"].DefaultValue = loanApp.getClientID(MySessionManager.AppID).ToString();
this.rvPreagreement.DataBind();
this.rvPreagreement.LocalReport.Refresh();
}
catch (Exception ex) { }
}
public bool setReview(int appid)
{
bool review = false;
try
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
review = Convert.ToBoolean(loanApp.GetReviewStatus(appid));
}
catch (Exception ex) { }
return(review);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
txtmonthly.Value = loanApp.GetAvMonthlyIncome(MySessionManager.AppID).ToString();
}
catch (Exception ex) { }
if (!(this.editskip.Value == "2"))
{
loadEmploymentDetails();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
txtmonthly.Value = loanApp.GetAvMonthlyIncome(MySessionManager.AppID).ToString();
}
catch (Exception ex) { }
if (!(this.editskip.Value == "2"))
{
loadEmploymentDetails();
}
}
public void UpdateIndividualClient()
{
//Get Clients profile information
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
mainDS.ClientRow tblClient = client.GetClientProfile(MySessionManager.ClientID)[0];
string Fullname = tblClient.datFirstName.ToString() + " " + tblClient.datMiddleName.ToString() + " " + tblClient.datSurname.ToString();
//Delete all initiators tied up the application
LoanDSTableAdapters.IntiatorTableAdapter initiator = new LoanDSTableAdapters.IntiatorTableAdapter();
initiator.DeleteInitiator(MySessionManager.AppID, MySessionManager.ClientID);
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.UpdateClientName(Fullname, MySessionManager.ClientID);
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID));
Utility utilClass = new Utility();
if (cmbAction.Text == "Forward Application")
{
utilClass.UpdateApplicationStatus("Forward Application", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
else if (cmbAction.Text == "Decline Application")
{
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// pass the DateTimeFormat information to DateTime.Parse
DateTime myDateTime = DateTime.Parse(txtFirstPaymentDate.Text, ukCulture.DateTimeFormat);
try
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
string clientname = client.GetClientsName(MySessionManager.ClientID).ToString();
int noyrs = 0;
if (!int.TryParse(txtNoYrs.Value, out noyrs))
txtNoYrs.Value = "0";
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.Update_IntialInterview(MySessionManager.AppID,
0,
Convert.ToInt32(ddlLoanType.Text),
txtNatureOfBusiness.Value,
ddlTypeOfBusiness.Text,
noyrs,
Convert.ToDecimal(txtAveMonthlyIncome.Value),
appCode.Value.Trim(),
Convert.ToDecimal(txtLoanAmount.Value.Trim()),
Convert.ToDecimal(txtLoanAmount.Value.Trim()),
Convert.ToDecimal(txtLoanAmount.Value.Trim()),
clientname,
Convert.ToInt32(txtDuration.Value.Trim()),
Convert.ToInt32(ddlloanpurpose.Text),
Convert.ToDecimal(txtInterestrate.Value.Trim()),
myDateTime,
Convert.ToInt32(ddlFrequency.Text),
Convert.ToInt32(ddlInterestRate.Text),
"");
this.editskip.Value = "1";
//loadLoanDetails(MySessionManager.AppID);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
}
}
protected void btnApply_Click(object sender, EventArgs e)
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
string EncID = this.ckey.Value;
//Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
int cType = Convert.ToInt32(client.GetClientType(DecID));
if (ddlProducts.SelectedValue == "1")
{
int lType = 0;
if (cType == 1)
{
lType = 1;
}
else if (cType == 2)
{
lType = 2;
}
else if (cType == 3)
{
lType = 4;
}
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
string clientname = client.GetClientsName(DecID).ToString();
loanApp.InsertNewApplication(DecID,
clientname,
lType,
MySessionManager.CurrentUser.BranchID,
MySessionManager.CurrentUser.UserID);
ShowMessageBox("Loan Application for " + clientname + " submited successfully");
}
else if (ddlProducts.SelectedValue == "2")
{
string clientname = client.GetClientsName(DecID).ToString();
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invapp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
invapp.InsertInvestmentApplication(DecID,
clientname,
1,
MySessionManager.CurrentUser.BranchID);
ShowMessageBox("Investment Application for " + clientname + " submited successfully");
}
}
protected void Page_Load(object sender, EventArgs e)
{
ListItem LItem = new ListItem("--Select--", "0");
ddlPaymetMode.Items.Insert(0, LItem);
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
txtBranch.InnerText = util.displayValue("tbl_teams", loanApp.GetLoanAppBranch(MySessionManager.AppID, MySessionManager.ClientID).ToString());
if (tblLoanApp.Rows.Count > 0)
{
this.lblTotalAmt.InnerText = tblLoanApp[0].datDisburseAmount.ToString("c").Replace("$","");
this.txtDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
}
if (!(this.editskip1.Value == "2"))
{
txtVoucherNo.Value = getPVNo();
loadfv();
txtTotalAmount.Text = sumAmount().ToString();
txtAmtWords.Value = NTE.changeNumericToWords(Convert.ToDouble(sumAmount())) + "Ghana Cedis ";
}
if (!(Request.QueryString["pvedit"] == null))
{
type = "update";
id = Convert.ToInt32(Request.QueryString["pvedit"]);
if (!(this.editskip.Value == "2"))
{
//txtVoucherNo.Value = getPVNo();
loadpv(id);
}
}
else if (!(Request.QueryString["pvdelete"] == null))
{
try
{
string id = Request.QueryString["pvdelete"];
util.deleteItem("tbl_payment_vouchers", id);
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "pvdelete"));
}
catch
{ }
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// pass the DateTimeFormat information to DateTime.Parse
DateTime myDateTime = DateTime.Parse(txtFirstPaymentDate.Text, ukCulture.DateTimeFormat);
try
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
string clientname = client.GetClientsName(MySessionManager.ClientID).ToString();
int noyrs = 0;
if (!int.TryParse(txtNoYrs.Value, out noyrs))
{
txtNoYrs.Value = "0";
}
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.Update_IntialInterview(MySessionManager.AppID,
0,
Convert.ToInt32(ddlLoanType.Text),
txtNatureOfBusiness.Value,
ddlTypeOfBusiness.Text,
noyrs,
Convert.ToDecimal(txtAveMonthlyIncome.Value),
appCode.Value.Trim(),
Convert.ToDecimal(txtLoanAmount.Value.Trim()),
Convert.ToDecimal(txtLoanAmount.Value.Trim()),
Convert.ToDecimal(txtLoanAmount.Value.Trim()),
clientname,
Convert.ToInt32(txtDuration.Value.Trim()),
Convert.ToInt32(ddlloanpurpose.Text),
Convert.ToDecimal(txtInterestrate.Value.Trim()),
myDateTime,
Convert.ToInt32(ddlFrequency.Text),
Convert.ToInt32(ddlInterestRate.Text),
"");
this.editskip.Value = "1";
//loadLoanDetails(MySessionManager.AppID);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ListItem LItem = new ListItem("--Select--", "0");
ddlPaymetMode.Items.Insert(0, LItem);
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
txtBranch.InnerText = util.displayValue("tbl_teams", loanApp.GetLoanAppBranch(MySessionManager.AppID, MySessionManager.ClientID).ToString());
if (tblLoanApp.Rows.Count > 0)
{
this.lblTotalAmt.InnerText = tblLoanApp[0].datDisburseAmount.ToString("c").Replace("$", "");
this.txtDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
}
if (!(this.editskip1.Value == "2"))
{
txtVoucherNo.Value = getPVNo();
loadfv();
txtTotalAmount.Text = sumAmount().ToString();
txtAmtWords.Value = NTE.changeNumericToWords(Convert.ToDouble(sumAmount())) + "Ghana Cedis ";
}
if (!(Request.QueryString["pvedit"] == null))
{
type = "update";
id = Convert.ToInt32(Request.QueryString["pvedit"]);
if (!(this.editskip.Value == "2"))
{
//txtVoucherNo.Value = getPVNo();
loadpv(id);
}
}
else if (!(Request.QueryString["pvdelete"] == null))
{
try
{
string id = Request.QueryString["pvdelete"];
util.deleteItem("tbl_payment_vouchers", id);
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "pvdelete"));
}
catch
{ }
}
}
public string setUrls(int AppID)
{
Utility util = new Utility();
string url = "";
LoanDSTableAdapters.LoanApplicationsTableAdapter loanapp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int status = Convert.ToInt32(loanapp.getApplicationStatus(AppID).ToString());
if (status == 2)
{
url = "~/pages/loanapplication/initialassesment.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910");
}
else if (status == 3)
{
url = "~/pages/loanapplication/preapproved.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910");
}
else if (status == 4)
{
url = "~/pages/loanapplication/appraisals.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910");
}
else if (status == 5)
{
url = "~/pages/loanapplication/risk.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910");
}
else if (status == 6)
{
url = "~/pages/loanapplication/legal.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910");
}
else if (status > 6 || status < 12)
{
url = "~/pages/loanapplication/approvals.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910");
}
else if (status == 12)
{
url = "~/pages/loanapplication/approvedloans.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910");
}
else if (status > 12 || status < 16)
{
url = "~/pages/loanapplication/disbursement.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910");
}
return(url);
}
protected void Page_Load(object sender, EventArgs e)
{
Utility util = new Utility();
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(Convert.ToString(MySessionManager.AppID));
if (tblLoanApp.Rows.Count > 0)
{
if (!(this.editskip.Value == "2"))
{
if (tblLoanApp[0].IsdatDurationNull()==false){ txtperiod.Text = tblLoanApp[0].datDuration.ToString(); }
if (tblLoanApp[0].IsdatInterestRateNull()==false){txtinterestrate.Text = tblLoanApp[0].datInterestRate.ToString();}
if (tblLoanApp[0].IsdatInterestRateTypeNull() == false) { txtinterestrateType.Text = util.displayValue("opt_interest_rate_types", tblLoanApp[0].datInterestRateType.ToString()); }
if (tblLoanApp[0].IsdatFirstPaymentDateNull() == false) { txtfirstpaymentdate.Text = tblLoanApp[0].datFirstPaymentDate.ToString("dd-MM-yyyy"); }
txtFrequency.Text = util.displayValue("opt_frequencies", tblLoanApp[0].datFrequency.ToString());
if (tblLoanApp[0].IsdatLoanAmountNull() == false) { txtprincipal.Text = tblLoanApp[0].datLoanAmount.ToString(); }
this.editskip.Value = "2";
int mnths = Convert.ToInt32(tblLoanApp[0].datDuration.ToString());
double per = Convert.ToDouble(tblLoanApp[0].datInterestRate.ToString());
double amt = Convert.ToDouble(tblLoanApp[0].datLoanAmount.ToString());
try
{
GenerateMonths(mnths, DateTime.Parse(txtfirstpaymentdate.Text));
}
catch (Exception ex) { }
}
else
{
int mnths = Convert.ToInt32(txtperiod.Text);
double per = Convert.ToDouble(txtinterestrate.Text);
double amt = Convert.ToDouble(txtprincipal.Text);
try
{
GenerateMonths(mnths, DateTime.Parse(txtfirstpaymentdate.Text));
}
catch (Exception ex) { }
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
lblbranch.InnerText = util.displayValue("tbl_teams", loanApp.GetLoanAppBranch(MySessionManager.AppID, MySessionManager.ClientID).ToString());
mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter();
try
{ lblTotal.Text = tempHolder.GetTransTotalAmount(MySessionManager.AppID).ToString(); }
catch (Exception ex)
{
lblTotal.Text = "0.00";
}
if (tblLoanApp.Rows.Count > 0)
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
lbltotalamt.InnerText = tblLoanApp[0].datLoanAmount.ToString("c").Replace("$", "");
lbldate.InnerText = DateTime.Now.ToLongDateString();
lblClient.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString();
}
if (!(this.editskip.Value =="2"))
{
}
if (!(Request.QueryString["trdelete"] == null))
{
try
{
string id = Request.QueryString["trdelete"];
tempHolder.DeleteTransactionDetails(Convert.ToInt32(id), MySessionManager.AppID);
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "trdelete"));
}
catch
{ }
}
}
public void showLoanAppInfo()
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
if (tblLoanApp.Rows.Count > 0)
{
try
{
this.lblapplicantName.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString();
this.lblInterestRate.InnerText = tblLoanApp[0].datInterestRate.ToString("c").Replace("$", "") + "%";
this.lblDuration.InnerText = tblLoanApp[0].datDuration.ToString() + " month(s)";
this.lblAppNo.InnerText = tblLoanApp[0].datApplicationNumber.ToString();
this.loanAmount.InnerText = tblLoanApp[0].datLoanAmount.ToString("c").Replace("$", "");
this.lblloantype.InnerText = util.displayValue("opt_loan_types", tblLoanApp[0].datLoanType.ToString());
this.lblClientNo.InnerText = client.GetClientNo(MySessionManager.ClientID).ToString();
}
catch (Exception ex)
{ }
}
}
public void setApprovalLimit(int level)
{
double values = 0.0;
double loanAmt = 0.0;
mainDSTableAdapters.GetApprovalLevelTableAdapter dslevel = new mainDSTableAdapters.GetApprovalLevelTableAdapter();
values = Convert.ToDouble(dslevel.GetApprovalLimit(level));
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanAmt = Convert.ToDouble(loanApp.GetLoanAmount(MySessionManager.AppID, MySessionManager.ClientID));
if (values < loanAmt)
{
cmbAction.Items[1].Enabled = false;
}
else
{
cmbAction.Items[1].Enabled = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
ListItem LItem = new ListItem("--Select--", "0");
ddlFee.Items.Insert(0, LItem);
ddlPaymentMode.Items.Insert(0, LItem);
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
if (tblLoanApp.Rows.Count > 0)
{
txtUpdatedLoanAmt.Text = tblLoanApp[0].datLoanAmount.ToString("c").Replace("$", "");
txtUpddateDisburseAmt.Text = tblLoanApp[0].datDisburseAmount.ToString("c").Replace("$", "");
}
txtLoanAmt.Value = Convert.ToString(loanApp.GetLoanAmount(MySessionManager.AppID, MySessionManager.ClientID)).ToString();
if (!(Request.QueryString["fedit"] == null))
{
type = "update";
id = Convert.ToInt32(Request.QueryString["fedit"]);
if (!(this.editskip.Value == "2"))
{
loadfee(id);
}
}
else if (!(Request.QueryString["fdelete"] == null))
{
try
{
string id = Request.QueryString["fdelete"];
updateLoanAmount("delete", 0, 0, Convert.ToInt32(id));
util.deleteItem("tbl_fees", id);
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "fdelete"));
}
catch
{ }
}
}
public void loadComments()
{
LoanDSTableAdapters.CommentsTableAdapter comments = new LoanDSTableAdapters.CommentsTableAdapter();
LoanDS.CommentsDataTable tblComments = comments.GetComments(MySessionManager.AppID, MySessionManager.ClientID);
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
if (tblComments.Rows.Count > 0)
{
string appStage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString());
string stage = "";
foreach (LoanDS.CommentsRow r in tblComments)
{
stage = r.datStage;
if (stage == appStage)
{
id = r.datID;
txtDescription.Value = r.datDescription.ToString();
}
}
this.editskip.Value = "2";
}
}
public void loadComments()
{
LoanDSTableAdapters.CommentsTableAdapter comments = new LoanDSTableAdapters.CommentsTableAdapter();
LoanDS.CommentsDataTable tblComments = comments.GetComments(MySessionManager.AppID, MySessionManager.ClientID);
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
if (tblComments.Rows.Count > 0)
{
string appStage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString());
string stage="";
foreach(LoanDS.CommentsRow r in tblComments)
{
stage = r.datStage;
if (stage == appStage)
{
id = r.datID;
txtDescription.Value =r.datDescription.ToString();
}
}
this.editskip.Value = "2";
}
}
protected void Page_Load(object sender, EventArgs e)
{
ListItem LItem = new ListItem("--Select--", "0");
ddlFee.Items.Insert(0, LItem);
ddlPaymentMode.Items.Insert(0, LItem);
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
if (tblLoanApp.Rows.Count > 0)
{
txtUpdatedLoanAmt.Text = tblLoanApp[0].datLoanAmount.ToString("c").Replace("$", "");
txtUpddateDisburseAmt.Text = tblLoanApp[0].datDisburseAmount.ToString("c").Replace("$", "");
}
txtLoanAmt.Value = Convert.ToString(loanApp.GetLoanAmount(MySessionManager.AppID, MySessionManager.ClientID)).ToString();
if (!(Request.QueryString["fedit"] == null))
{
type = "update";
id = Convert.ToInt32(Request.QueryString["fedit"]);
if (!(this.editskip.Value == "2"))
{
loadfee(id);
}
}
else if (!(Request.QueryString["fdelete"] == null))
{
try
{
string id = Request.QueryString["fdelete"];
updateLoanAmount("delete", 0, 0, Convert.ToInt32(id));
util.deleteItem("tbl_fees", id);
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "fdelete"));
}
catch
{ }
}
}
public void UpdateCompanyClientName(string ClientName)
{
//Copy the Initiator Details From the Clients Table
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
mainDS.ClientRow tblClient = client.GetClientProfile(MySessionManager.ClientID)[0];
string Fullname = tblClient.datFirstName.ToString() + tblClient.datMiddleName.ToString() + tblClient.datSurname.ToString();
LoanDSTableAdapters.IntiatorTableAdapter initiator = new LoanDSTableAdapters.IntiatorTableAdapter();
initiator.InsertInitiator(MySessionManager.AppID,
MySessionManager.ClientID,
Fullname,
null,
tblClient.datMobileNumber1.ToString(),
tblClient.datHomeTelephoneNumber.ToString(),
tblClient.datEmailAddress.ToString(),
tblClient.datFaxNumber.ToString(),
tblClient.datCurrentResidentialAddress.ToString());
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.UpdateClientName(ClientName, MySessionManager.ClientID);
}
protected void Page_Load(object sender, EventArgs e)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
lblbranch.InnerText = util.displayValue("tbl_teams", loanApp.GetLoanAppBranch(MySessionManager.AppID, MySessionManager.ClientID).ToString());
mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter();
try
{ lblTotal.Text = tempHolder.GetTransTotalAmount(MySessionManager.AppID).ToString(); }
catch (Exception ex)
{
lblTotal.Text = "0.00";
}
if (tblLoanApp.Rows.Count > 0)
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
lbltotalamt.InnerText = tblLoanApp[0].datLoanAmount.ToString("c").Replace("$", "");
lbldate.InnerText = DateTime.Now.ToLongDateString();
lblClient.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString();
}
if (!(this.editskip.Value == "2"))
{
}
if (!(Request.QueryString["trdelete"] == null))
{
try
{
string id = Request.QueryString["trdelete"];
tempHolder.DeleteTransactionDetails(Convert.ToInt32(id), MySessionManager.AppID);
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "trdelete"));
}
catch
{ }
}
}
protected void btnApply_Click(object sender, EventArgs e)
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
string EncID = this.ckey.Value;
//Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
int cType = Convert.ToInt32(client.GetClientType(DecID));
if (ddlProducts.SelectedValue == "1")
{
int lType=0;
if (cType == 1) { lType = 1; } else if (cType == 2) { lType = 2; } else if (cType == 3) { lType = 4; }
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
string clientname = client.GetClientsName(DecID).ToString();
loanApp.InsertNewApplication(DecID,
clientname,
lType,
MySessionManager.CurrentUser.BranchID,
MySessionManager.CurrentUser.UserID);
ShowMessageBox("Loan Application for " + clientname + " submited successfully");
}
else if(ddlProducts.SelectedValue=="2")
{
string clientname = client.GetClientsName(DecID).ToString();
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invapp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
invapp.InsertInvestmentApplication(DecID,
clientname,
1,
MySessionManager.CurrentUser.BranchID);
ShowMessageBox("Investment Application for " + clientname + " submited successfully");
}
}
protected void RemoveAlert()
{
string msg = this.pAlertmsg.InnerText;
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.saveAlert("",
MySessionManager.AppID);
LoanDSTableAdapters.AlertLogsTableAdapter alertLog = new LoanDSTableAdapters.AlertLogsTableAdapter();
// LoanDS.AlertLogsDataTable tblAlertLog = alertLog.
}
public bool setReview(int appid)
{
bool review=false;
try
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
review = Convert.ToBoolean(loanApp.GetReviewStatus(appid));
}
catch (Exception ex) { }
return review;
}
protected void btnSaveAlert_Click(object sender, EventArgs e)
{
string EncID = appID.Value.Trim();
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.saveAlert(alertmsg.Value,
DecID);
}
public void createAccount(decimal AmtOut1)
{
//LoanAccountDS.
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
mainDS.ClientDataTable tblClient = client.GetClientProfile(MySessionManager.ClientID);
decimal interestrate = Convert.ToDecimal(tblLoanApp[0].datInterestRate.ToString());
decimal IntAmt = (Convert.ToDecimal(AmtOut1) * (interestrate / 100));
interestamt = IntAmt;
decimal AmtOut = Convert.ToDecimal(AmtOut1);
decimal FinRptBalance_monthly = IntAmt + AmtOut;
DateTime enddate = addMonth(DateTime.Now, Convert.ToInt32(tblLoanApp[0].datDuration.ToString()));
if ((tblClient.Rows.Count > 0) || (tblLoanApp.Rows.Count > 0))
{
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter account = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
account.InsertLoanAccount(createAccountNumber(MySessionManager.ClientID),
Convert.ToDecimal(tblLoanApp[0].datFees.ToString()),
MySessionManager.ClientID,
MySessionManager.AppID,
Convert.ToInt32(tblLoanApp[0].datTeamID.ToString()),
DateTime.Now,
enddate,
Convert.ToInt32(tblLoanApp[0].datInterestRate),
Convert.ToInt32(tblLoanApp[0].datDuration.ToString()),
0,
IntAmt,
AmtOut,
FinRptBalance_monthly,
MySessionManager.CurrentUser.UserID,
FinRptBalance_monthly,
DateTime.Now,
DateTime.Now,
Convert.ToInt32(tblLoanApp[0].datPurpose.ToString()),
IntAmt,
Convert.ToInt32(tblLoanApp[0].datRefreshedID.ToString()),
Convert.ToInt32(tblLoanApp[0].datCreditTeamID.ToString()),
tblClient[0].datClientName.ToString(),
Convert.ToInt32(tblLoanApp[0].datLoanType.ToString()));
}
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountDataTable tblLoanAc = loanAc.GetLoanAccount1(MySessionManager.AppID, MySessionManager.ClientID);
if (tblLoanAc.Rows.Count > 0)
{
MySessionManager.AccountID = tblLoanAc[0].datID;
MySessionManager.AppBranchID = tblLoanApp[0].datTeamID;
}
}
protected void Page_Load(object sender, EventArgs e)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
setNotifications();
if (!(this.IsPostBack))
{
setUrls();
}
#region QueryStringBlock
if (Request.QueryString["id"] == null)
{
}
else
{
string EncID = Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
MySessionManager.AppID = DecID;
//int DecID = Convert.ToInt32(EncID);
MySessionManager.ClientID = Convert.ToInt32(loanApp.getClientID(MySessionManager.AppID));
}
LoanType = Convert.ToInt32(loanApp.GetLoanType(MySessionManager.AppID, MySessionManager.ClientID));
setLoanTypeTabs(LoanType);
showLoanAppInfo();
if (!(Request.QueryString["ops"] == null))
{
if (!(Request.QueryString["tab"] == null))
{
if (!(Request.QueryString["tab"] == ""))
currentTab = int.Parse(Request.QueryString["tab"]);
else
currentTab = Convert.ToInt32(MySessionManager.CurrentTab);
ops = Request.QueryString["ops"].ToString();
setTab(currentTab);
MySessionManager.CurrentTab = currentTab.ToString();
MySessionManager.OpsTab = "load";
string urlpath = util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab");
urlpath = util.RemoveQueryStringByKey(urlpath, "ops");
Response.Redirect(urlpath);
}
else
{
if (!(Request.QueryString["tab"] == ""))
currentTab = int.Parse(Request.QueryString["tab"]);
else
if (LoanType == 2 || LoanType == 3)
currentTab = 2;
else
currentTab = 0;
ops = "load";
setTab(currentTab);
MySessionManager.CurrentTab = currentTab.ToString();
MySessionManager.OpsTab = "load";
util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab");
util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ops");
}
}
else
{
ops = MySessionManager.OpsTab.ToString();
//For handling the tabs
if (!(MySessionManager.CurrentTab == ""))
currentTab = int.Parse(MySessionManager.CurrentTab);
else
if (LoanType == 2 || LoanType == 3)
{
currentTab = 2;
MySessionManager.CurrentTab = currentTab.ToString();
}
else
{
currentTab = 0;
MySessionManager.CurrentTab = currentTab.ToString();
}
setTab(currentTab);
}
#endregion
if ((!(util.alert() == "")) && (MySessionManager.skipAlert == 0))
{
this.pAlertmsg.InnerText = util.alert();
// Define the name and type of the client scripts on the page.
String csname1 = "PopupScript";
String csname2 = "ButtonClickScript";
Type cstype = this.GetType();
// Get a ClientScriptManager reference from the Page class.
ClientScriptManager cs = Page.ClientScript;
// Check to see if the startup script is already registered.
if (!cs.IsStartupScriptRegistered(cstype, csname1))
{
String cstext1 = "alertMessage();";
cs.RegisterStartupScript(cstype, csname1, cstext1, true);
}
MySessionManager.skipAlert = 1;
}
}
public void showLoanAppInfo()
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
if (tblLoanApp.Rows.Count > 0)
{
try
{
this.lblapplicantName.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString();
this.lblInterestRate.InnerText = tblLoanApp[0].datInterestRate.ToString("c").Replace("$", "") + "%";
this.lblDuration.InnerText = tblLoanApp[0].datDuration.ToString() + " month(s)";
this.lblAppNo.InnerText = tblLoanApp[0].datApplicationNumber.ToString();
this.loanAmount.InnerText = tblLoanApp[0].datLoanAmount.ToString("c").Replace("$", "");
this.lblloantype.InnerText = util.displayValue("opt_loan_types", tblLoanApp[0].datLoanType.ToString());
this.lblClientNo.InnerText = client.GetClientNo(MySessionManager.ClientID).ToString();
}
catch (Exception ex)
{ }
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (MySessionManager.AppID > 0)
{
this.itemLoanApp.Visible = true;
this.ItemLoanAccount.Visible = false;
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
MySessionManager.ClientID = Convert.ToInt32(loanApp.getClientID(MySessionManager.AppID));
try
{
mainDSTableAdapters.GetApplicationInfoTableAdapter appinfo = new mainDSTableAdapters.GetApplicationInfoTableAdapter();
mainDS.GetApplicationInfoDataTable tblAppInfo = appinfo.GetApplicationInfo(MySessionManager.AppID);
if (tblAppInfo.Rows.Count > 0)
{
this.btnEditApp.HRef = setUrls(MySessionManager.AppID);
this.btnViewAppTracker.HRef = "~/pages/applicationtracker.aspx?id=" + MyEncryption.Encrypt(MySessionManager.AppID.ToString(), "12345678910");
if(tblAppInfo[0].IsdatLoanAmountNull()==false){this.lnAmt.InnerText = tblAppInfo[0].datLoanAmount.ToString("c").Replace("$", "");}
if (tblAppInfo[0].IsdatLoanTypeNull() == false) { this.lnType.InnerText = tblAppInfo[0].datLoanType.ToString(); }
if (tblAppInfo[0].IsdatApplicationStatusNull() == false) { this.lnAppStatus.InnerText = tblAppInfo[0].datApplicationStatus.ToString(); }
if (tblAppInfo[0].IsdatDurationNull() == false) { this.lnDuration.InnerText = tblAppInfo[0].datDuration.ToString() + " month(s)"; }
if (tblAppInfo[0].IsdatBranchNull() == false) { this.lnAppBranch.InnerText = tblAppInfo[0].datBranch.ToString(); }
if (tblAppInfo[0].IsdatApplicationDateNull() == false) { this.lnAppDate.InnerText = tblAppInfo[0].datApplicationDate.ToLongDateString(); }
}
}
catch (Exception ex) { }
}
else if(MySessionManager.AccountID > 0)
{
this.ItemLoanAccount.Visible = true;
this.itemLoanApp.Visible = false;
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
MySessionManager.ClientID = Convert.ToInt32(loanAcc.GetClientIDFromAcc(Convert.ToInt32(MySessionManager.AccountID)));
try
{
mainDSTableAdapters.GetLoanAccountInfoTableAdapter accinfo = new mainDSTableAdapters.GetLoanAccountInfoTableAdapter();
mainDS.GetLoanAccountInfoDataTable tblAccInfo = accinfo.GetLoanAccountInfo(Convert.ToInt32(MySessionManager.AccountID));
if (tblAccInfo.Rows.Count > 0)
{
if (tblAccInfo[0].IsdatOutstandingAmountNull() == false) { this.lnOutstanding.InnerText = tblAccInfo[0].datOutstandingAmount.ToString("c").Replace("$", ""); }
if (tblAccInfo[0].IsdatStartDateNull() == false) { this.lnStartDate.InnerText = tblAccInfo[0].datStartDate.ToLongDateString(); }
if (tblAccInfo[0].IsdatEndDateNull() == false) { this.lnEndDate.InnerText = tblAccInfo[0].datEndDate.ToLongDateString(); }
if (tblAccInfo[0].IsdatBranchNull() == false) { this.lnAccBranch.InnerText = tblAccInfo[0].datBranch.ToString(); }
this.btnTransactions.HRef = "~/pages/transactions.aspx?id" + MyEncryption.Encrypt(MySessionManager.AccountID.ToString(), "12345678910") + "&action=entry";
this.btnViewStatement.HRef = "~/pages/loanaccount/loanaccountdetails.aspx?id" + MyEncryption.Encrypt(MySessionManager.AccountID.ToString(), "12345678910") + "&action=2";
this.btnMonitorAccount.HRef = "~/pages/loanaccount/loanaccountdetails.aspx?id" + MyEncryption.Encrypt(MySessionManager.AccountID.ToString(), "12345678910") + "&action=1";
}
}
catch (Exception ex) { }
}
try
{
mainDSTableAdapters.GetClientInfoTableAdapter clientInfo = new mainDSTableAdapters.GetClientInfoTableAdapter();
mainDS.GetClientInfoDataTable tblClientInfo = clientInfo.GetClientInfo(MySessionManager.ClientID);
if (tblClientInfo.Rows.Count > 0)
{
if (tblClientInfo[0].IsdatClientNameNull() == false) { clientname.InnerText = tblClientInfo[0].datClientName.ToString(); }
if (tblClientInfo[0].IsdatClientNumberNull() == false) {clientNo.InnerText = tblClientInfo[0].datClientNumber.ToString();}
if (tblClientInfo[0].IsdatMobileNumber1Null() == false) { clMobile.InnerText = tblClientInfo[0].datMobileNumber1.ToString(); }
}
}
catch (Exception ex) { }
}
public string setUrls(int AppID)
{
Utility util = new Utility();
string url = "";
LoanDSTableAdapters.LoanApplicationsTableAdapter loanapp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int status = Convert.ToInt32(loanapp.getApplicationStatus(AppID).ToString());
if (status ==2){ url = "~/pages/loanapplication/initialassesment.aspx?id="+MyEncryption.Encrypt(AppID.ToString(),"12345678910");}
else if (status ==3) { url = "~/pages/loanapplication/preapproved.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); }
else if (status ==4) { url = "~/pages/loanapplication/appraisals.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); }
else if (status == 5) { url = "~/pages/loanapplication/risk.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); }
else if (status ==6) { url = "~/pages/loanapplication/legal.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); }
else if (status > 6 || status < 12)
{ url = "~/pages/loanapplication/approvals.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); }
else if (status == 12) { url = "~/pages/loanapplication/approvedloans.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); }
else if (status > 12 || status < 16)
{ url = "~/pages/loanapplication/disbursement.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); }
return url;
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
MySessionManager.cash = 0;
MySessionManager.bank = 0;
decimal amtDeductable = 0;
decimal fees = 0;
decimal amt = 0;
int ops = 0;
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int status = Convert.ToInt32(loanApp.getApplicationStatus(MySessionManager.AppID));
util.UpdateApplicationStatus("Forward Application", status);
createAccount();
mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter();
mTemp.GetTransactionDetailsDataTable tblTempHolder = tempHolder.GetTempTransactions(MySessionManager.AppID);
LoanDSTableAdapters.FinancialTransactionsTableAdapter fintrans = new LoanDSTableAdapters.FinancialTransactionsTableAdapter();
int rows = tblTempHolder.Rows.Count;
for (int i = 0; i < rows; i++)
{
int?datDebitAc = null;
int?datCreditAc = null;
if (tblTempHolder[i].datDebit > 0)
{
datDebitAc = tblTempHolder[i].datAccountID;
amt = tblTempHolder[i].datDebit;
ops = 1;
}
else if (tblTempHolder[i].datCredit > 0)
{
datCreditAc = tblTempHolder[i].datAccountID;
amt = tblTempHolder[i].datCredit;
ops = 2;
}
//
if (tblTempHolder[i].datPaymentMethod == 1)
{
getAmtForPaymentMode(amt, "cash", ops);
}
else if (tblTempHolder[i].datPaymentMethod == 2)
{
getAmtForPaymentMode(amt, "bank", ops);
}
fintrans.InsertFinancialTransaction(MySessionManager.AppID,
MySessionManager.ClientID,
tblTempHolder[i].datAccountID,
Convert.ToInt32(MySessionManager.AccountID),
tblTempHolder[i].datDescription,
batch(),
tblTempHolder[i].datPaymentMethod,
MySessionManager.AppBranchID,
tblTempHolder[i].datCredit,
tblTempHolder[i].datDebit,
datCreditAc,
datDebitAc,
0,
MySessionManager.CurrentUser.UserID);
}
saveDisburse(Convert.ToInt32(MySessionManager.AccountID), MySessionManager.cash, MySessionManager.bank);
saveCreditTransaction(Convert.ToInt32(MySessionManager.AccountID), batch(), interestamt, "1", 1);
saveDebitTransaction(Convert.ToInt32(MySessionManager.AccountID), batch(), interestamt, "1", 0);
interest_payment_dates(MySessionManager.AppID, Convert.ToInt32(MySessionManager.AccountID), DateTime.Now, 12);
Response.Redirect("~/pages/loanapplications.aspx");
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID));
if (cmbAction.Text == "Forward Application")
{
try
{
int ctID = Convert.ToInt32(ddlCreditTeam.SelectedValue);
util.UpdateApplicationStatus("Forward Application", AppStage);
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.AssignCreditTeam(ctID, MySessionManager.AppID);
Response.Redirect("~/pages/loanapplications.aspx", true);
}
catch (Exception ex) { }
}
else if (cmbAction.Text == "Send Back For Review")
{
util.UpdateApplicationStatus("Send Back For Review", AppStage);
Response.Redirect("~/pages/loanapplications.aspx", true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
// this.dtCompare.Visible = true;
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime myDateTime = DateTime.Parse(txtFirstPaymentDate.Text, ukCulture.DateTimeFormat);
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
string clientname = client.GetClientsName(MySessionManager.ClientID).ToString();
int noyrs = 0;
if (!int.TryParse(txtNoYrs.Value, out noyrs))
{
txtNoYrs.Value = "0";
}
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.Update_IntialInterview(MySessionManager.AppID,
0,
Convert.ToInt32(ddlLoanType.Text),
txtNatureOfBusiness.Value,
ddlTypeOfBusiness.Text,
noyrs,
Convert.ToDecimal(txtAveMonthlyIncome.Value),
appCode.Value.Trim(),
Convert.ToDecimal(txtLoanAmount.Value.Trim()),
Convert.ToDecimal(txtLoanAmount.Value.Trim()),
Convert.ToDecimal(txtLoanAmount.Value.Trim()),
clientname,
Convert.ToInt32(txtDuration.Value.Trim()),
Convert.ToInt32(ddlloanpurpose.Text),
Convert.ToDecimal(txtInterestrate.Value.Trim()),
myDateTime,
Convert.ToInt32("0"),
Convert.ToInt32(ddlInterestRate.Text),
"");
this.editskip.Value = "2";
//loadLoanDetails(MySessionManager.AppID);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
#region Obsolete
//try
//{
// mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
// string clientname = client.GetClientName(MySessionManager.ClientID)[0].datClientName.ToString();
//int noofyrs = 0;
//DateTime dt = DateTime.Parse(txtFirstPaymentDate.Text);
//if (!(txtNoYrs.Value==""))
//{
// noofyrs = Convert.ToInt32(txtNoYrs.Value.Trim());
//}
//LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
//loanApp.Update_IntialInterview(MySessionManager.AppID,
// 0,
// Convert.ToInt32(ddlLoanType.Text),
// txtNatureOfBusiness.Value.Trim(),
// ddlTypeOfBusiness.Text,
// Convert.ToInt32 (noofyrs),
// Convert.ToDecimal(txtAveMonthlyIncome.Value.Trim()),
// GenerateAppNumber(),
// Convert.ToDecimal(txtLoanAmount.Value.Trim()),
// 0,
// 0,
// clientname,
// Convert.ToInt32(txtDuration.Value.Trim()),
// Convert.ToInt32(ddlloanpurpose.Text),
// Convert.ToDecimal(txtInterestrate.Value.Trim()),
// dt,
// Convert.ToInt32(ddlFrequency.Text),
// Convert.ToInt32(ddlInterestRate.Text),
// "");
//}
//catch
//{
//}
#endregion
}
else
{
// this.vIntialAssesment.ErrorMessage =
}
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID));
Utility utilClass = new Utility();
if (cmbAction.Text == "Forward To Credit Team")
{
utilClass.UpdateApplicationStatus("Forward To Credit Team", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
else if (cmbAction.Text == "Send Back For Review")
{
utilClass.UpdateApplicationStatus("Send Back For Review", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID));
Utility utilClass = new Utility();
if (cmbAction.Text == "Forward Application")
{
ShowMessageBox("Are u sure on forwarding the application");
utilClass.UpdateApplicationStatus("Forward Application To Approval", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
else if (cmbAction.Text == "Forward To Risk")
{
utilClass.UpdateApplicationStatus("Forward To Risk", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
else if (cmbAction.Text == "Forward To Legal")
{
utilClass.UpdateApplicationStatus("Forward To Legal", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
else if (cmbAction.Text == "Send Back For Review")
{
utilClass.UpdateApplicationStatus("Send Back For Review", AppStage);
Response.Redirect("~/pages/loanapplications.aspx");
}
}
public void UpdateCompanyClientName(string ClientName)
{
//Copy the Initiator Details From the Clients Table
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
mainDS.ClientRow tblClient = client.GetClientProfile(MySessionManager.ClientID)[0];
string Fullname = tblClient.datFirstName.ToString()+ tblClient.datMiddleName.ToString()+ tblClient.datSurname.ToString();
LoanDSTableAdapters.IntiatorTableAdapter initiator = new LoanDSTableAdapters.IntiatorTableAdapter();
initiator.InsertInitiator (MySessionManager.AppID,
MySessionManager.ClientID,
Fullname,
null,
tblClient.datMobileNumber1.ToString(),
tblClient.datHomeTelephoneNumber.ToString(),
tblClient.datEmailAddress.ToString(),
tblClient.datFaxNumber.ToString(),
tblClient.datCurrentResidentialAddress.ToString());
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.UpdateClientName(ClientName, MySessionManager.ClientID);
}
public void loadTab(int id,string ops)
{
try
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanType = Convert.ToInt32(loanApp.GetLoanType(MySessionManager.AppID, MySessionManager.ClientID));
if (LoanType == 1)
{
for (int j = 0; j < indie.Length; j++)
{
if (indie[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(indie[m]);
MySessionManager.CurrentTab = indie[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(m);
MySessionManager.CurrentTab = indie[m].ToString();
}
}
}
}
}
else if (LoanType == 2 || LoanType == 3)
{
for (int j = 0; j < cor.Length; j++)
{
if (cor[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(cor[m]);
MySessionManager.CurrentTab = cor[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(cor[m]);
MySessionManager.CurrentTab = cor[m].ToString();
}
}
}
}
}
else if (LoanType == 4)
{
for (int j = 0; j < ent.Length; j++)
{
if (ent[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(ent[m]);
MySessionManager.CurrentTab = ent[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(ent[m]);
MySessionManager.CurrentTab = ent[m].ToString();
}
}
}
}
}
}
catch (Exception ex) { }
}
protected void Page_Load(object sender, EventArgs e)
{
setUrls();
if (MySessionManager.CurrentUser == null)
{
Response.Redirect("~/logout.aspx");
}
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
try
{
mainDSTableAdapters.NotificationCountTableAdapter tblCounter = new mainDSTableAdapters.NotificationCountTableAdapter();
mainDS.NotificationCountRow itemcount = tblCounter.NotificationCount(MySessionManager.CurrentUser.BranchID, MySessionManager.CurrentUser.UserID, MySessionManager.CurrentUser.TeamID)[0];
this.pendingRecInfo.InnerText = (Convert.ToInt32(itemcount.receipts.ToString())).ToString();
this.pendingDisInfo.InnerText = (Convert.ToInt32(itemcount.disbursementI.ToString()) + Convert.ToInt32(itemcount.disbursementII.ToString()) + Convert.ToInt32(itemcount.disbursementIII.ToString())).ToString();
}
catch (Exception ex)
{
}
setPanelsOff();
showLoanAppInfo();
#region QueryStringSection
if (Request.QueryString["id"] == null)
{
}
else
{
string EncID = Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
MySessionManager.AppID = DecID;
MySessionManager.ClientID = Convert.ToInt32(loanApp.getClientID(MySessionManager.AppID));
}
if (!(Request.QueryString["ops"] == null))
{
if (!(Request.QueryString["tab"] == null))
{
if (!(Request.QueryString["tab"] == ""))
currentTab = int.Parse(Request.QueryString["tab"]);
else
currentTab = Convert.ToInt32(MySessionManager.CurrentTab);
ops = Request.QueryString["ops"].ToString();
setPanels(currentTab);
MySessionManager.CurrentTab = currentTab.ToString();
MySessionManager.OpsTab = "load";
string urlpath = util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab");
urlpath = util.RemoveQueryStringByKey(urlpath, "ops");
Response.Redirect(urlpath);
}
else
{
if (!(Request.QueryString["tab"] == ""))
currentTab = int.Parse(Request.QueryString["tab"]);
else
currentTab = 0;
ops = "load";
setPanels(currentTab);
MySessionManager.CurrentTab = currentTab.ToString();
MySessionManager.OpsTab = "load";
util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab");
util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ops");
}
}
else
{
ops = MySessionManager.OpsTab.ToString();
//For handling the tabs
if (!(MySessionManager.CurrentTab == ""))
currentTab = int.Parse(MySessionManager.CurrentTab);
else
currentTab = 0;
setPanels(currentTab);
}
#endregion
if ((!(util.alert() == "")) && (MySessionManager.skipAlert == 0))
{
this.pAlertmsg.InnerText = util.alert();
// Define the name and type of the client scripts on the page.
String csname1 = "PopupScript";
String csname2 = "ButtonClickScript";
Type cstype = this.GetType();
// Get a ClientScriptManager reference from the Page class.
ClientScriptManager cs = Page.ClientScript;
// Check to see if the startup script is already registered.
if (!cs.IsStartupScriptRegistered(cstype, csname1))
{
String cstext1 = "alertMessage();";
cs.RegisterStartupScript(cstype, csname1, cstext1, true);
}
MySessionManager.skipAlert = 1;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (MySessionManager.CurrentUser == null)
{
Response.Redirect("~/logout.aspx");
}
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
setNotifications();
showLoanAppInfo();
setUrls();
if (Request.QueryString["id"] == null)
{
}
else
{
string EncID = Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
MySessionManager.AppID = DecID;
MySessionManager.ClientID = Convert.ToInt32(loanApp.getClientID(MySessionManager.AppID));
showLoanAppInfo();
}
if (!(Request.QueryString["ops"] == null))
{
if (!(Request.QueryString["tab"] == null))
{
if (!(Request.QueryString["tab"] == ""))
{
currentTab = int.Parse(Request.QueryString["tab"]);
}
else
{
currentTab = Convert.ToInt32(MySessionManager.CurrentTab);
}
ops = Request.QueryString["ops"].ToString();
setTab();
MySessionManager.CurrentTab = currentTab.ToString();
MySessionManager.OpsTab = "load";
string urlpath = util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab");
urlpath = util.RemoveQueryStringByKey(urlpath, "ops");
Response.Redirect(urlpath);
}
else
{
if (!(Request.QueryString["tab"] == ""))
{
currentTab = int.Parse(Request.QueryString["tab"]);
}
else
{
currentTab = 0;
}
ops = "load";
setTab();
MySessionManager.CurrentTab = currentTab.ToString();
MySessionManager.OpsTab = "load";
util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab");
util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ops");
}
}
else
{
ops = MySessionManager.OpsTab.ToString();
//For handling the tabs
if (!(MySessionManager.CurrentTab == ""))
{
currentTab = int.Parse(MySessionManager.CurrentTab);
}
else
{
currentTab = 0;
}
setTab();
}
if ((!(util.alert() == "")) && (MySessionManager.skipAlert == 0))
{
this.pAlertmsg.InnerText = util.alert();
// Define the name and type of the client scripts on the page.
String csname1 = "PopupScript";
String csname2 = "ButtonClickScript";
Type cstype = this.GetType();
// Get a ClientScriptManager reference from the Page class.
ClientScriptManager cs = Page.ClientScript;
// Check to see if the startup script is already registered.
if (!cs.IsStartupScriptRegistered(cstype, csname1))
{
String cstext1 = "alertMessage();";
cs.RegisterStartupScript(cstype, csname1, cstext1, true);
}
MySessionManager.skipAlert = 1;
}
}
public void createNewApp()
{
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter LoanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountRow tblLoanAcc = LoanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0];
string AppID;
string AppNewID = "";
try
{
LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter RefreshAccount = new LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter();
LoanAccountDS.GetAccountRefreshmentRecordDataTable tblRefreshAccount = RefreshAccount.GetAccountRefreshmentRecord(Convert.ToInt32(MySessionManager.AccountID));
if (tblRefreshAccount.Rows.Count>0)
{
MySessionManager.AppID = tblRefreshAccount[0].datNewAppID;
}
else
{
int? getAppID = null;
AppID = tblLoanAcc.datApplicationID.ToString();
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanAccountDSTableAdapters.AccountRefreshmentTableAdapter LoanAccRefreshment = new LoanAccountDSTableAdapters.AccountRefreshmentTableAdapter();
string appNo = loanApp.GetLoanApplicationNo(Convert.ToInt32(AppID)).ToString() + "-00";
LoanAccRefreshment.InsertNewRefreshApp(MySessionManager.ClientID,
tblLoanAcc.datClientFullName.ToString(),
Convert.ToInt32(ddlLoanType.SelectedValue),
appNo,
Convert.ToDecimal(txtLoanAmount.Text),
Convert.ToDecimal(txtLoanAmount.Text),
Convert.ToDecimal(txtLoanAmount.Text),
Convert.ToInt32(txtDuration.Text),
1,
Convert.ToDecimal(txtIntRate.Text),
DateTime.Now,
Convert.ToDateTime(txtFirstPaymentDate.Text),
0,
Convert.ToInt32(ddlInterestRateType.SelectedValue),
Convert.ToInt32(AppID),
Convert.ToInt32(ddlCT.SelectedValue),
Convert.ToInt32(tblLoanAcc.datTeamID),
ref getAppID);
AppNewID = getAppID.ToString();
LoanAccRefreshment.InsertCopyAssets(AppID, AppNewID);
LoanAccRefreshment.InsertCopyAuditors(AppID, AppNewID);
LoanAccRefreshment.InsertCopyBankers(AppID, AppNewID);
LoanAccRefreshment.InsertCopyChecklist(AppID, AppNewID);
LoanAccRefreshment.InsertCopyCollaterals(AppID, AppNewID);
LoanAccRefreshment.InsertCopyComments(AppID, AppNewID);
LoanAccRefreshment.InsertCopyCorporateInfo(AppID, AppNewID);
LoanAccRefreshment.InsertCopyCreditInformation(AppID, AppNewID);
LoanAccRefreshment.InsertCopyEnterprises(AppID, AppNewID);
LoanAccRefreshment.InsertCopyFees(AppID, AppNewID);
LoanAccRefreshment.InsertCopyFinancials(AppID, AppNewID);
LoanAccRefreshment.InsertCopyGuarantor(AppID, AppNewID);
LoanAccRefreshment.InsertCopyIncomeExpense(AppID, AppNewID);
LoanAccRefreshment.InsertCopyIntiator(AppID, AppNewID);
LoanAccRefreshment.InsertCopyLegalReports(AppID, AppNewID);
LoanAccRefreshment.InsertCopyNextOfKin(AppID, AppNewID);
LoanAccRefreshment.InsertCopyNoOfEmployees(AppID, AppNewID);
LoanAccRefreshment.InsertCopyOwnership(AppID, AppNewID);
LoanAccRefreshment.InsertCopyPaymentPlan(AppID, AppNewID);
LoanAccRefreshment.InsertCopyPDC(AppID, AppNewID);
LoanAccRefreshment.InsertCopyPreApprovalReports(AppID, AppNewID);
LoanAccRefreshment.InsertCopyReligion(AppID, AppNewID);
LoanAccRefreshment.InsertCopyReports(AppID, AppNewID);
LoanAccRefreshment.InsertCopyRiskReport(AppID, AppNewID);
LoanAccRefreshment.InsertCopySpouse(AppID, AppNewID);
LoanAccRefreshment.InsertCopySupportingDocuments(AppID, AppNewID);
LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter loanAcRef = new LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter();
loanAcRef.InsertAccountRefreshment(Convert.ToInt32(MySessionManager.AccountID),
Convert.ToInt32(AppID));
loanAcRef.UpdateNewAppID(Convert.ToInt32(AppNewID),
Convert.ToInt32(MySessionManager.AccountID));
MySessionManager.AppID = Convert.ToInt32(AppNewID);
}
}
catch (Exception ex) { }
}
public void UpdateIndividualClient()
{
//Get Clients profile information
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
mainDS.ClientRow tblClient = client.GetClientProfile(MySessionManager.ClientID)[0];
string Fullname = tblClient.datFirstName.ToString()+" "+tblClient.datMiddleName.ToString()+" "+ tblClient.datSurname.ToString();
//Delete all initiators tied up the application
LoanDSTableAdapters.IntiatorTableAdapter initiator = new LoanDSTableAdapters.IntiatorTableAdapter();
initiator.DeleteInitiator(MySessionManager.AppID, MySessionManager.ClientID);
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
loanApp.UpdateClientName(Fullname, MySessionManager.ClientID);
}
public void setUrls()
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
int status = Convert.ToInt32(loanApp.getApplicationStatus(MySessionManager.AppID));
if (status == 13)
{
this.btnTransEntry.Visible = false;
this.btnEditPV.Visible = false;
this.btnPreparePV.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=2&ops=load";
}
else if (status == 14)
{
this.btnPreparePV.Visible = false;
this.btnTransEntry.Visible = false;
this.btnEditPV.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=6&ops=load";
}
else if (status == 15)
{
this.btnPreparePV.Visible = false;
this.btnEditPV.Visible = false;
this.btnTransEntry.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=5&ops=load";
this.divSubmit.Visible = false;
}
this.btnApplicationDetails.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri+"&tab=1&ops=load";
this.btnPVReport.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=3&ops=load";
this.btnSupDocs.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=4&ops=load";
}
