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.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));
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");
}
}
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);
}
}
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();
}
}
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 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")
{
}
}
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);
}
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";
}
}
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 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);
}
}
//public void setDropdownlist(DropDownList ddl,string value)
//{
// if (value == "")
// {
// ListItem Litem = new ListItem("--Select--","0");
// ddl.Items.Add(Litem);
// //ddl.DataBind();
// }
// else
// {
// ddl.SelectedIndex = ddl.Items.IndexOf(ddl.Items.FindByValue(value));
// }
//}
public void InsertAppTrail()
{
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString());
int pastUser = Convert.ToInt32(loanApp.GetPreviousUsersID(MySessionManager.AppID));
TimeSpan TimeDiff =(DateTime.Now - tblLoanApp[0].datMoveTime);
string moveTime = TimeDiff.Days + " days " + TimeDiff.Hours + " hours" + TimeDiff.Minutes + " minutes and " + TimeDiff.Seconds+" seconds";
int stage = Convert.ToInt32(loanApp.getApplicationStatus(MySessionManager.AppID));
try
{
LoanDSTableAdapters.ApplicationTrailTableAdapter AppTrail = new LoanDSTableAdapters.ApplicationTrailTableAdapter();
AppTrail.InsertAppTrail(MySessionManager.AppID,
pastUser,
MySessionManager.CurrentUser.UserID,
tblLoanApp[0].datMoveTime,
stage,
moveTime);
loanApp.SetNewUserAndTime(MySessionManager.CurrentUser.UserID, DateTime.Now, MySessionManager.AppID);
}
catch (Exception ex) { }
}
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";
}
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)
{
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");
}
}
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");
}
