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