public double[,] loadpplanValues(int AppID) { LoanDSTableAdapters.PaymentPlanTableAdapter pplan = new LoanDSTableAdapters.PaymentPlanTableAdapter(); LoanDS.PaymentPlanDataTable tblpplan = pplan.GetPaymentPlan(AppID); double[,] pplanValue = new double[tblpplan.Rows.Count, 5]; try { if (tblpplan.Rows.Count > 0) { for (int i = 0; i < tblpplan.Rows.Count; i++) { pplanValue[i, 0] = Convert.ToDouble(tblpplan[i].datBalanceBF.ToString()); pplanValue[i, 1] = Convert.ToDouble(tblpplan[i].datInterest1.ToString()); pplanValue[i, 2] = Convert.ToDouble(tblpplan[i].datPrincipalComponent.ToString()); pplanValue[i, 3] = Convert.ToDouble(tblpplan[i].datMonthlyPayment.ToString()); pplanValue[i, 4] = Convert.ToDouble(tblpplan[i].datOutstanding.ToString()); } } else { } } catch (Exception ex) {} return(pplanValue); }
private void DeletePaymentPlan() { try { LoanDSTableAdapters.PaymentPlanTableAdapter plan = new LoanDSTableAdapters.PaymentPlanTableAdapter(); plan.Delete_PaymentPlan(MySessionManager.AppID); } catch { } }
public double[,] loadpplanValues(int AppID) { LoanDSTableAdapters.PaymentPlanTableAdapter pplan = new LoanDSTableAdapters.PaymentPlanTableAdapter(); LoanDS.PaymentPlanDataTable tblpplan = pplan.GetPaymentPlan(AppID); double[,] pplanValue = new double[tblpplan.Rows.Count, 5]; try { if (tblpplan.Rows.Count > 0) { for (int i = 0; i < tblpplan.Rows.Count; i++) { pplanValue[i,0] = Convert.ToDouble(tblpplan[i].datBalanceBF.ToString()); pplanValue[i, 1] = Convert.ToDouble(tblpplan[i].datInterest1.ToString()); pplanValue[i, 2] = Convert.ToDouble(tblpplan[i].datPrincipalComponent.ToString()); pplanValue[i, 3] = Convert.ToDouble(tblpplan[i].datMonthlyPayment.ToString()); pplanValue[i, 4] = Convert.ToDouble(tblpplan[i].datOutstanding.ToString()); } } else { } } catch(Exception ex) {} return pplanValue; }
private void DeletePaymentPlan() { try { LoanDSTableAdapters.PaymentPlanTableAdapter plan = new LoanDSTableAdapters.PaymentPlanTableAdapter(); plan.Delete_PaymentPlan (MySessionManager.AppID); } catch { } }
public void UpdatePaymentPlan(string AppID) { SqlCommand cmd = new SqlCommand(); SqlCommand cmd2; SqlConnection conn = new SqlConnection(Utility.connectionString); byte cmtype = 3; cmd.CommandText = "delete tblBLPaymentPlan where accountid=" + AppID + ""; cmd.Connection = conn; cmd.CommandType = CommandType.Text; SqlTransaction tran = null; try { conn.Open(); tran = conn.BeginTransaction(); cmd.Transaction = tran; cmd.ExecuteNonQuery(); int i = 0; foreach (HtmlTableRow row in this.TABLE1.Rows) { string labelstring = "lblMonth"; string newlbl = labelstring + i.ToString(); Control ctrl = null; if (i > 1) { if (row.Cells.Count > 0) ctrl = row.Cells[1].Controls[0]; } if (ctrl != null) { if (i > 1) { #region obsolete //datarow.AccountID = accountid; //datarow.MonthName = ((Label)row.Cells[0].Controls[0]).Text; //datarow.MonthIndex = Convert.ToByte(i - 1); //datarow.Repayment = Utility.ConvertToDouble(((TextBox)row.Cells[4].Controls[0]).Text).ToString(); //datarow.AmountOutstanding = Utility.ConvertToDouble(((TextBox)row.Cells[5].Controls[0]).Text).ToString(); //datarow.Ir = Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text); //datarow.BalanceBF = Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text); //datarow.Loan_Interest = Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text); //datarow.RType = cmtype; #endregion LoanDSTableAdapters.PaymentPlanTableAdapter plan = new LoanDSTableAdapters.PaymentPlanTableAdapter(); plan.InsertPaymentPlan(Convert.ToDateTime(((Label)row.Cells[0].Controls[0]).Text), Convert.ToDecimal(Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text)), Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text), Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text), Convert.ToDecimal ("0"), Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text), Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text), MySessionManager.AppID, Convert.ToInt32(((Label)row.Cells[0].Controls[0]).Text) ); } } i++; } } catch (Exception ex) { tran.Rollback(); } finally { conn.Close(); } }
public void AddPaymentPlan() { LoanDSTableAdapters.PaymentPlanTableAdapter plan = new LoanDSTableAdapters.PaymentPlanTableAdapter(); LoanDS.PaymentPlanDataTable tbl = new LoanDS.PaymentPlanDataTable(); LoanDS.PaymentPlanRow datarow; long AppID = MySessionManager.AppID; int i = 0; DeletePaymentPlan(); foreach (HtmlTableRow row in this.TABLE1.Rows) { string labelstring = "lblMonth"; string newlbl = labelstring + i.ToString(); Control ctrl = null; if (i > 1) { if (row.Cells.Count > 0) ctrl = row.Cells[1].Controls[0]; } if (ctrl != null) { if (i > 1) { datarow = tbl.NewPaymentPlanRow(); datarow.datApplicationID = MySessionManager .AppID; datarow.datMonth = Convert.ToDateTime(((Label)row.Cells[0].Controls[0]).Text); datarow.datMonthIndex = Convert.ToInt32(i - 1); datarow.datMonthlyPayment = Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text); datarow.datOutstanding = Utility.ConvertToDecimal(((TextBox)row.Cells[6].Controls[0]).Text); datarow.datInterest1 = Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text); datarow.datBalanceBF = Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text); datarow.datPrincipalComponent = Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text) - Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text); tbl.Rows.Add(datarow); plan.InsertPaymentPlan( Convert.ToDateTime(datarow.datMonth), Convert.ToDecimal(datarow.datBalanceBF), Convert.ToDecimal(datarow.datInterest1), Convert.ToDecimal(datarow.datMonthlyPayment), Convert.ToDecimal("0.0"), Convert.ToDecimal(datarow.datPrincipalComponent.ToString()), Convert.ToDecimal(datarow.datOutstanding.ToString()), MySessionManager.AppID, Convert.ToInt32(datarow.datMonthIndex.ToString())); } } i++; } }
public void UpdatePaymentPlan(string AppID) { SqlCommand cmd = new SqlCommand(); SqlCommand cmd2; SqlConnection conn = new SqlConnection(Utility.connectionString); byte cmtype = 3; cmd.CommandText = "delete tblBLPaymentPlan where accountid=" + AppID + ""; cmd.Connection = conn; cmd.CommandType = CommandType.Text; SqlTransaction tran = null; try { conn.Open(); tran = conn.BeginTransaction(); cmd.Transaction = tran; cmd.ExecuteNonQuery(); int i = 0; foreach (HtmlTableRow row in this.TABLE1.Rows) { string labelstring = "lblMonth"; string newlbl = labelstring + i.ToString(); Control ctrl = null; if (i > 1) { if (row.Cells.Count > 0) { ctrl = row.Cells[1].Controls[0]; } } if (ctrl != null) { if (i > 1) { #region obsolete //datarow.AccountID = accountid; //datarow.MonthName = ((Label)row.Cells[0].Controls[0]).Text; //datarow.MonthIndex = Convert.ToByte(i - 1); //datarow.Repayment = Utility.ConvertToDouble(((TextBox)row.Cells[4].Controls[0]).Text).ToString(); //datarow.AmountOutstanding = Utility.ConvertToDouble(((TextBox)row.Cells[5].Controls[0]).Text).ToString(); //datarow.Ir = Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text); //datarow.BalanceBF = Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text); //datarow.Loan_Interest = Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text); //datarow.RType = cmtype; #endregion LoanDSTableAdapters.PaymentPlanTableAdapter plan = new LoanDSTableAdapters.PaymentPlanTableAdapter(); plan.InsertPaymentPlan(Convert.ToDateTime(((Label)row.Cells[0].Controls[0]).Text), Convert.ToDecimal(Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text)), Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text), Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text), Convert.ToDecimal("0"), Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text), Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text), MySessionManager.AppID, Convert.ToInt32(((Label)row.Cells[0].Controls[0]).Text) ); } } i++; } } catch (Exception ex) { tran.Rollback(); } finally { conn.Close(); } }
public void AddPaymentPlan() { LoanDSTableAdapters.PaymentPlanTableAdapter plan = new LoanDSTableAdapters.PaymentPlanTableAdapter(); LoanDS.PaymentPlanDataTable tbl = new LoanDS.PaymentPlanDataTable(); LoanDS.PaymentPlanRow datarow; long AppID = MySessionManager.AppID; int i = 0; DeletePaymentPlan(); foreach (HtmlTableRow row in this.TABLE1.Rows) { string labelstring = "lblMonth"; string newlbl = labelstring + i.ToString(); Control ctrl = null; if (i > 1) { if (row.Cells.Count > 0) { ctrl = row.Cells[1].Controls[0]; } } if (ctrl != null) { if (i > 1) { datarow = tbl.NewPaymentPlanRow(); datarow.datApplicationID = MySessionManager.AppID; datarow.datMonth = Convert.ToDateTime(((Label)row.Cells[0].Controls[0]).Text); datarow.datMonthIndex = Convert.ToInt32(i - 1); datarow.datMonthlyPayment = Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text); datarow.datOutstanding = Utility.ConvertToDecimal(((TextBox)row.Cells[6].Controls[0]).Text); datarow.datInterest1 = Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text); datarow.datBalanceBF = Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text); datarow.datPrincipalComponent = Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text) - Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text); tbl.Rows.Add(datarow); plan.InsertPaymentPlan(Convert.ToDateTime(datarow.datMonth), Convert.ToDecimal(datarow.datBalanceBF), Convert.ToDecimal(datarow.datInterest1), Convert.ToDecimal(datarow.datMonthlyPayment), Convert.ToDecimal("0.0"), Convert.ToDecimal(datarow.datPrincipalComponent.ToString()), Convert.ToDecimal(datarow.datOutstanding.ToString()), MySessionManager.AppID, Convert.ToInt32(datarow.datMonthIndex.ToString())); } } i++; } }