protected void btnFinalize_Click(object sender, EventArgs e)
{
try
{
InvestmentDSTableAdapters.GetInvScheduleTableAdapter InvSch= new InvestmentDSTableAdapters.GetInvScheduleTableAdapter();
InvSch.UpdateInvScheduleStatus(4, MySessionManager.InvAccID);
}
catch (Exception ex) { }
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
try
{
InvestmentDSTableAdapters.GetInvScheduleTableAdapter InvSch = new InvestmentDSTableAdapters.GetInvScheduleTableAdapter();
InvSch.UpdateInvScheduleStatus(4, MySessionManager.InvAccID);
}
catch (Exception ex) { }
}
private void CalculateIntPayment(int terms, int freq, Decimal amt, decimal per, DateTime firstpaymentdate)
{
decimal totalAmt = 0;
try
{
this.TABLE1.Rows.Clear();
this.TABLE1.Rows.Add(new HtmlTableRow());
HtmlTableRow row;
DateTime firstdt = firstpaymentdate;
string[,] data = amountcalculation(freq, terms, amt, per, firstdt);
Label lblMonth1 = new Label();
lblMonth1.Style["font-weight"] = "bold";
lblMonth1.Text = firstdt.ToString("dd") + " " + firstdt.ToString("MMM") + " " + firstdt.ToString("yy");
Label lbl;
TextBox txt1;
TextBox txt2;
TextBox txt3;
row = new HtmlTableRow();
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
Label lbl1 = new Label();
Label lbl2 = new Label();
Label lbl3 = new Label();
lbl1.Text = "Payment Date";
lbl2.Text = "Days";
lbl3.Text = "Interest";
lbl1.Font.Bold = true;
lbl2.Font.Bold = true;
lbl3.Font.Bold = true;
row.Cells[0].Controls.Add(lbl1);
row.Cells[1].Controls.Add(lbl2);
row.Cells[2].Controls.Add(lbl3);
row.Cells[0].Align = "center";
row.Cells[1].Align = "center";
row.Cells[2].Align = "center";
this.TABLE1.Rows.Add(row);
for (int i = 0; i < data.GetLength(0); i++)
{
row = new HtmlTableRow();
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
txt1 = new TextBox();
txt2 = new TextBox();
txt3 = new TextBox();
lbl = new Label();
lbl.ID = "lblPaymentDates" + i.ToString();
lbl.Text = Convert.ToDateTime(data[i, 0]).ToString("dd MMM yyyy");
lbl.Style["font-weight"] = "bold";
row.Cells[0].Controls.Add(lbl);
txt1.ID = "txtDays" + i.ToString();
txt1.CssClass = "BF" + i.ToString();
txt1.Style["font-weight"] = "bold";
txt1.Style["border"] = "none";
txt1.Style.Add("text-align", "center");
txt1.Style.Add("width", "100%");
txt1.Text = data[i, 1].ToString();
txt2.ID = "txtInterest" + i.ToString();
txt2.CssClass = "_IR" + i.ToString();
txt2.Style["font-weight"] = "bold";
txt2.Style["border"] = "none";
txt2.Style.Add("text-align", "right");
txt2.Style.Add("width", "100%");
txt2.Text = data[i, 2].ToString();
totalAmt = totalAmt + Convert.ToDecimal(data[i, 2]);
row.Cells[1].Controls.Add(txt1);
row.Cells[2].Controls.Add(txt2);
this.TABLE1.Rows.Add(row);
}
row = new HtmlTableRow();
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
TextBox txtA = new TextBox();
TextBox txtB = new TextBox();
txtA.Text = "Total";
txtA.ID = "txttotal";
txtA.CssClass = "BF";
txtA.Style["font-weight"] = "bold";
txtA.Style["border"] = "none";
txtA.Style.Add("text-align", "center");
txtA.Style.Add("width", "100%");
txtB.Text = totalAmt.ToString("C").Replace("$", "");
txtB.ID = "txtTotalAmt";
txtB.CssClass = "BF";
txtB.Style["font-weight"] = "bold";
txtB.Style["border"] = "none";
txtB.Style.Add("text-align", "right");
txtB.Style.Add("width", "100%");
row.Cells[1].Controls.Add(txtA);
row.Cells[2].Controls.Add(txtB);
this.TABLE1.Rows.Add(row);
if (editFlag == true)
{
//Record the values in the db
InvestmentDSTableAdapters.GetInvScheduleTableAdapter InvSch = new InvestmentDSTableAdapters.GetInvScheduleTableAdapter();
InvestmentDS.GetInvScheduleDataTable tblInvSch = InvSch.GetInvSchedule(MySessionManager.InvAppID);
if (tblInvSch.Rows.Count > 0)
{
InvSch.DeleteInvAccID(MySessionManager.InvAppID);
}
for (int i = 0; i < data.GetLength(0); i++)
{
InvSch.InsertPaymentSch(MySessionManager.InvAppID,
Convert.ToDateTime(data[i, 0]),
Convert.ToInt32(data[i, 1]),
Convert.ToDecimal(data[i, 2]),
0,
1
);
}
}
}
catch (Exception ex) { }
}
private void CalculateIntPayment(int terms, int freq, Decimal amt, decimal per, DateTime firstpaymentdate)
{
decimal totalAmt = 0;
try
{
this.TABLE1.Rows.Clear();
this.TABLE1.Rows.Add(new HtmlTableRow());
HtmlTableRow row;
DateTime firstdt = firstpaymentdate;
string[,] data = amountcalculation(freq, terms, amt, per, firstdt);
Label lblMonth1 = new Label();
lblMonth1.Style["font-weight"] = "bold";
lblMonth1.Text = firstdt.ToString("dd") + " " + firstdt.ToString("MMM") + " " + firstdt.ToString("yy");
Label lbl;
TextBox txt1;
TextBox txt2;
TextBox txt3;
row = new HtmlTableRow();
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
Label lbl1 = new Label();
Label lbl2 = new Label();
Label lbl3 = new Label();
lbl1.Text = "Payment Date";
lbl2.Text = "Days";
lbl3.Text = "Interest";
lbl1.Font.Bold = true;
lbl2.Font.Bold = true;
lbl3.Font.Bold = true;
row.Cells[0].Controls.Add(lbl1);
row.Cells[1].Controls.Add(lbl2);
row.Cells[2].Controls.Add(lbl3);
row.Cells[0].Align = "center";
row.Cells[1].Align = "center";
row.Cells[2].Align = "center";
this.TABLE1.Rows.Add(row);
for (int i = 0; i < data.GetLength(0); i++)
{
row = new HtmlTableRow();
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
txt1 = new TextBox();
txt2 = new TextBox();
txt3 = new TextBox();
lbl = new Label();
lbl.ID = "lblPaymentDates" + i.ToString();
lbl.Text = Convert.ToDateTime(data[i, 0]).ToString("dd MMM yyyy");
lbl.Style["font-weight"] = "bold";
row.Cells[0].Controls.Add(lbl);
txt1.ID = "txtDays" + i.ToString();
txt1.CssClass = "BF" + i.ToString();
txt1.Style["font-weight"] = "bold";
txt1.Style["border"] = "none";
txt1.Style.Add("text-align", "center");
txt1.Style.Add("width", "100%");
txt1.Text = data[i, 1].ToString();
txt2.ID = "txtInterest" + i.ToString();
txt2.CssClass = "_IR" + i.ToString();
txt2.Style["font-weight"] = "bold";
txt2.Style["border"] = "none";
txt2.Style.Add("text-align", "right");
txt2.Style.Add("width", "100%");
txt2.Text = data[i, 2].ToString();
totalAmt = totalAmt + Convert.ToDecimal(data[i, 2]);
row.Cells[1].Controls.Add(txt1);
row.Cells[2].Controls.Add(txt2);
this.TABLE1.Rows.Add(row);
}
row = new HtmlTableRow();
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
row.Cells.Add(new HtmlTableCell());
TextBox txtA = new TextBox();
TextBox txtB = new TextBox();
txtA.Text = "Total";
txtA.ID = "txttotal";
txtA.CssClass = "BF";
txtA.Style["font-weight"] = "bold";
txtA.Style["border"] = "none";
txtA.Style.Add("text-align", "center");
txtA.Style.Add("width", "100%");
txtB.Text = totalAmt.ToString("C").Replace("$", "");
txtB.ID = "txtTotalAmt";
txtB.CssClass = "BF";
txtB.Style["font-weight"] = "bold";
txtB.Style["border"] = "none";
txtB.Style.Add("text-align", "right");
txtB.Style.Add("width", "100%");
row.Cells[1].Controls.Add(txtA);
row.Cells[2].Controls.Add(txtB);
this.TABLE1.Rows.Add(row);
if (editFlag == true)
{
//Record the values in the db
InvestmentDSTableAdapters.GetInvScheduleTableAdapter InvSch = new InvestmentDSTableAdapters.GetInvScheduleTableAdapter();
InvestmentDS.GetInvScheduleDataTable tblInvSch = InvSch.GetInvSchedule(MySessionManager.InvAppID);
if (tblInvSch.Rows.Count > 0)
{
InvSch.DeleteInvAccID(MySessionManager.InvAppID);
}
for (int i = 0; i < data.GetLength(0); i++)
{
InvSch.InsertPaymentSch(MySessionManager.InvAppID,
Convert.ToDateTime(data[i, 0]),
Convert.ToInt32(data[i, 1]),
Convert.ToDecimal(data[i, 2]),
0,
1
);
}
}
}
catch (Exception ex) { }
}
