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"); }