protected void Page_Load(object sender, EventArgs e) { ///Querystring Block /// if (Request.QueryString.Count > 0) { InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter invAcc = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); string EncID = Request.QueryString["id"]; int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910")); MySessionManager.InvAccID = DecID; MySessionManager.ClientID = Convert.ToInt32(invAcc.GetClientID(MySessionManager.InvAppID)); if (Request.QueryString["action"] == "int") { Page.Title = "Interest Maturity"; } if (Request.QueryString["action"] == "inv") { Page.Title = "Investment Maturity"; } if (Request.QueryString["action"] == "rol") { Page.Title = "Roll Over"; } } setNotifications(); }
protected void Page_Load(object sender, EventArgs e) { int schID = 0; if (Request.QueryString["schID"] != null) { schID = Convert.ToInt32(Request.QueryString["schID"]); } try { InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter InvAcc_ = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); DateTime dt = DateTime.Parse(InvAcc_.GetValueDate(MySessionManager.InvAccID).ToString()); dt = util.addDaysElapsed(dt, schID); InvestmentAccountDSTableAdapters.GetHistoricAccountTableAdapter InvAcc = new InvestmentAccountDSTableAdapters.GetHistoricAccountTableAdapter(); InvestmentAccountDS.GetHistoricAccountDataTable tblInvAcc = InvAcc.GetHistoryByDate(MySessionManager.InvAccID, dt); if (tblInvAcc.Rows.Count > 0) { if (tblInvAcc[0].IsdatIDNull() == false) { datID.Value = tblInvAcc[0].datID.ToString(); } if (tblInvAcc[0].IsdatIntAccruedNull() == false) { lblaccruedInt.InnerText = tblInvAcc[0].datIntAccrued.ToString("c").Replace("$", ""); dataccint.Value = tblInvAcc[0].datIntAccrued.ToString(); } else { dataccint.Value = "0"; } if (tblInvAcc[0].IsdatInvestmentAmountNull() == false) { lblInvAmt.InnerText = tblInvAcc[0].datInvestmentAmount.ToString("c").Replace("$", ""); datprincipal.Value = tblInvAcc[0].datInvestmentAmount.ToString(); } else { datprincipal.Value = "0"; } if (tblInvAcc[0].IsdatValueDateNull() == false) { lblValueDate.InnerText = tblInvAcc[0].datValueDate.ToString("dd-MM-yyyy"); } if (tblInvAcc[0].IsdatInvestmentNameNull() == false) { lblInvName.InnerText = tblInvAcc[0].datInvestmentName.ToString(); } } } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { ///Querystring Block InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter invAcc = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); string EncID = Request.QueryString["id"]; int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910")); MySessionManager.InvAccID = DecID; MySessionManager.ClientID = Convert.ToInt32(invAcc.GetClientID(MySessionManager.InvAppID)); setNotifications(); }
protected void Page_Load(object sender, EventArgs e) { int schID = 0; decimal val = 0; if(Request.QueryString["schID"]!= null){ schID = Convert.ToInt32(Request.QueryString["schID"]);} try { InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter InvAcc_ = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); DateTime dt = DateTime.Parse(InvAcc_.GetValueDate(MySessionManager.InvAccID).ToString()); dt = util.addDaysElapsed(dt,schID); InvestmentAccountDSTableAdapters.GetHistoricAccountTableAdapter InvAcc = new InvestmentAccountDSTableAdapters.GetHistoricAccountTableAdapter(); InvestmentAccountDS.GetHistoricAccountDataTable tblInvAcc = InvAcc.GetHistoryByDate(MySessionManager.InvAccID,dt); if (tblInvAcc.Rows.Count > 0) { if (Request.QueryString["val"].Length > 0) { val = Convert.ToDecimal(Request.QueryString["val"]); } if (tblInvAcc[0].IsdatIDNull()==false) { datID.Value = tblInvAcc[0].datID.ToString(); } if (tblInvAcc[0].IsdatIntAccruedNull() == false) { lblaccruedInt.InnerText = tblInvAcc[0].datIntAccrued.ToString("c").Replace("$", ""); dataccint.Value = tblInvAcc[0].datIntAccrued.ToString(); } else { dataccint.Value = "0"; } if (tblInvAcc[0].IsdatInvestmentAmountNull() == false) { lblInvAmt.InnerText = tblInvAcc[0].datInvestmentAmount.ToString("c").Replace("$", ""); datprincipal.Value = tblInvAcc[0].datInvestmentAmount.ToString(); } if (tblInvAcc[0].IsdatPenaltyNull() == false) { datAmount.Value = tblInvAcc[0].datPenalty.ToString(); } else { datprincipal.Value = "0"; } if (tblInvAcc[0].IsdatValueDateNull() == false) {lblValueDate.InnerText = tblInvAcc[0].datValueDate.ToString("dd-MM-yyyy");} if (tblInvAcc[0].IsdatInvestmentNameNull() == false) { lblInvName.InnerText = tblInvAcc[0].datInvestmentName.ToString(); } } } catch (Exception ex) { } }
protected void btnOpenAccount_Click(object sender, EventArgs e) { if (ListofCreditAccounts.Items.Count > 0) { int accid = Convert.ToInt32(ListofCreditAccounts.SelectedValue); FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter vchTypes = new FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter(); FinancialDS.tbl_VoucherTypesDataTable vtypes = vchTypes.GetVoucherTypeByName(MySessionManager.VchTypeName); if (vtypes.Count > 0) { if (Convert.ToInt32(vtypes[0].datDebitAccountTypes) == 1) { InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter invAcc = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); InvestmentAccountDS.GetInvAccountDataTable invAccData = invAcc.GetInvAccount(accid); if (invAccData.Count > 0) { lblInvestmentName.InnerText = invAccData[0].datInvestmentName; lblapplicantName.InnerText = ListofCreditAccounts.SelectedItem.Text; lblInvestmentAmount.InnerText = Convert.ToString(invAccData[0].datInvestmentAmount); } } else if (Convert.ToInt32(vtypes[0].datDebitAccountTypes) == 2) { LoanAccountDSTableAdapters.GetLoanAccountTableAdapter lacc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountDataTable ltbl = lacc.GetLoanAccount(accid); if (ltbl.Count > 0) { lblInvestmentName.InnerText = ltbl[0].datClientFullName ; lblapplicantName.InnerText = ListofCreditAccounts.SelectedItem.Text; lblInvestmentAmount.InnerText = Convert.ToString(ltbl[0].datInitialAmount); } } } transactionsPanel.Visible = true; VchPanel.Visible = true; VchTypeSelPanel.Visible = false; MySessionManager.TempTranKey = System.Guid.NewGuid().ToString(); lblTotal.Text = ""; } }
protected void btnOpenAccount_Click(object sender, EventArgs e) { if (ListofCreditAccounts.Items.Count > 0) { int accid = Convert.ToInt32(ListofCreditAccounts.SelectedValue); FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter vchTypes = new FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter(); FinancialDS.tbl_VoucherTypesDataTable vtypes = vchTypes.GetVoucherTypeByName(MySessionManager.VchTypeName); if (vtypes.Count > 0) { if (Convert.ToInt32(vtypes[0].datCreditAccountTypes) == 1) { InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter invAcc = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); InvestmentAccountDS.GetInvAccountDataTable invAccData = invAcc.GetInvAccount(accid); if (invAccData.Count > 0) { lblInvestmentName.InnerText = invAccData[0].datInvestmentName; lblapplicantName.InnerText = ListofCreditAccounts.SelectedItem.Text; lblInvestmentAmount.InnerText = Convert.ToString(invAccData[0].datInvestmentAmount); } } else if (Convert.ToInt32(vtypes[0].datCreditAccountTypes) == 2) { LoanAccountDSTableAdapters.GetLoanAccountTableAdapter lacc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountDataTable ltbl = lacc.GetLoanAccount(accid); if (ltbl.Count > 0) { lblInvestmentName.InnerText = ltbl[0].datClientFullName; lblapplicantName.InnerText = ListofCreditAccounts.SelectedItem.Text; lblInvestmentAmount.InnerText = Convert.ToString(ltbl[0].datInitialAmount); } } } transactionsPanel.Visible = true; VchPanel.Visible = true; VchTypeSelPanel.Visible = false; MySessionManager.TempTranKey = System.Guid.NewGuid().ToString(); lblTotal.Text = ""; } }
protected void gvClients_RowDataBound(object sender, GridViewRowEventArgs e) { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); if (e.Row.RowType == DataControlRowType.DataRow) { int terms = 0; InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter InvAcc = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); InvestmentAccountDS.GetInvAccountDataTable tblInvAcc = InvAcc.GetInvAccount(Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex].Value)); string enpValue = MyEncryption.Encrypt(this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString(), "12345678910"); DateTime dt = DateTime.Parse(gvClients.DataKeys[e.Row.RowIndex]["datValueDate"].ToString()); e.Row.Cells[0].Text = client.GetClientsName(Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex]["datClientID"].ToString())).ToString(); e.Row.Cells[4].Text = util.displayValue("opt_investment_types", gvClients.DataKeys[e.Row.RowIndex]["datInvestmentType"].ToString()); terms = Convert.ToInt32(util.displayValue("opt_terms", gvClients.DataKeys[e.Row.RowIndex]["datFrequencyOfInterestPayment"].ToString())); int freq = Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex]["datFrequencyOfInterestPayment"].ToString()); Panel ItemBox = new Panel(); ItemBox.Attributes.Add("id", "div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString()); ItemBox.Attributes.Add("id", "div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString()); ItemBox.Attributes.Add("class", "ItemContainer"); ItemBox.Style.Add("display", "none"); string htmlContent = "<div class='col-md-9' style='padding-top:0'><label> Matured Interest(s) </label><br/>"; if (tblInvAcc[0].dat30 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=30&val=" + tblInvAcc[0].dat30.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 30).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat60 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=60&val=" + tblInvAcc[0].dat60.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 60).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat91 > 0 && freq == 2) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=91&val=" + tblInvAcc[0].dat91.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 90).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat121 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=121&val=" + tblInvAcc[0].dat121.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 121).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat151 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=151&val=" + tblInvAcc[0].dat151.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 151).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat182 > 0 && freq == 3) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=182&val=" + tblInvAcc[0].dat182.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 182).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat212 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=212&val=" + tblInvAcc[0].dat212.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 212).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat242 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/iinterestmaturity.aspx?id=" + enpValue + "&schID=242&val=" + tblInvAcc[0].dat242.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 242).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat273 > 0 && freq == 2) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=273&val=" + tblInvAcc[0].dat273.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 273).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat303 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=303&val=" + tblInvAcc[0].dat303.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 303).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat333 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=333&val=" + tblInvAcc[0].dat333.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 303).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat364 > 0 && freq == 4) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=364&val=" + tblInvAcc[0].dat364.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 364).ToString("dd/MM/yyyy") + " </a> <br/>"; } htmlContent += "</div>"; Literal ItemContent = new Literal(); ItemContent.Text = htmlContent; ItemBox.Controls.Add(ItemContent); HyperLink hyp = new HyperLink(); hyp.NavigateUrl = "javascript:showinfo('div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString() + "')"; hyp.Text = e.Row.Cells[0].Text; e.Row.Cells[0].Controls.Add(hyp); e.Row.Cells[0].Controls.Add(ItemBox); //HyperLink clientProfile = (HyperLink)e.Row.FindControl("hyperClientProfile"); //HyperLink Inv = (HyperLink)e.Row.FindControl("hyperInv"); } }
protected void btnFinalize_Click(object sender, EventArgs e) { try { ///End the application process. InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter(); InvApp.UpdateApplicationStatus(5, MySessionManager.InvAppID); ///Converts the application into an account InvestmentDS.GetInvestmentAppDataTable rowInvApp = InvApp.GetInvestmentApp(MySessionManager.InvAppID); if (rowInvApp.Rows.Count > 0) { InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter InvAcc = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); InvAcc.InsertInvAccount(rowInvApp[0].datInvestmentName, rowInvApp[0].datApplicationNumber, MySessionManager.ClientID, rowInvApp[0].datInvestmentType, rowInvApp[0].datTerms, rowInvApp[0].datInvestmentAmount, rowInvApp[0].datInterestRatePerAnnum, rowInvApp[0].datFrequencyOfInterestPayment, rowInvApp[0].datModeOfRepayment, rowInvApp[0].datAdvise, rowInvApp[0].datValueDate, rowInvApp[0].datInvestmentAmount, MySessionManager.CurrentUser.BranchID, 0, 0, 0, 0, 1, MySessionManager.InvAppID); ///Calculates the interest for the days elapsed before creation of the account int days = DateDiff(DateTime.Now, rowInvApp[0].datValueDate); int term = Convert.ToInt32(util.displayValue("opt_terms",rowInvApp[0].datTerms.ToString())); if (days > term) days = term; InvestmentAccountDSTableAdapters.GetInterestCalcTableAdapter InvAcc1 = new InvestmentAccountDSTableAdapters.GetInterestCalcTableAdapter(); if (days > 0) { decimal previousInt = calc_interest(MySessionManager.InvAppID, days); ///Insert a new record into the calculation table for the Daily chron-job InvAcc1.InsertInvCalc(MySessionManager.InvAppID.ToString(), MySessionManager.ClientID, rowInvApp[0].datApplicationNumber.ToString(), DateTime.Now.ToShortDateString(), rowInvApp[0].datInvestmentAmount, rowInvApp[0].datInterestRatePerAnnum, days, term, previousInt, previousInt); } else { // decimal previousInt = calc_interest(MySessionManager.InvAppID, days); ///Insert a new record into the calculation table for the Daily chron-job InvAcc1.InsertInvCalc(MySessionManager.InvAppID.ToString(), MySessionManager.ClientID, rowInvApp[0].datApplicationNumber.ToString(), DateTime.Now.ToShortDateString(), rowInvApp[0].datInvestmentAmount, rowInvApp[0].datInterestRatePerAnnum, 0, term, 0, 0); } } Response.Redirect("~/pages/invapplications.aspx"); } catch (Exception ex) { } }
protected void btnFinalize_Click(object sender, EventArgs e) { try { ///End the application process. InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter(); InvApp.UpdateApplicationStatus(5, MySessionManager.InvAppID); ///Converts the application into an account InvestmentDS.GetInvestmentAppDataTable rowInvApp = InvApp.GetInvestmentApp(MySessionManager.InvAppID); if (rowInvApp.Rows.Count > 0) { InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter InvAcc = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); InvAcc.InsertInvAccount(rowInvApp[0].datInvestmentName, rowInvApp[0].datApplicationNumber, MySessionManager.ClientID, rowInvApp[0].datInvestmentType, rowInvApp[0].datTerms, rowInvApp[0].datInvestmentAmount, rowInvApp[0].datInterestRatePerAnnum, rowInvApp[0].datFrequencyOfInterestPayment, rowInvApp[0].datModeOfRepayment, rowInvApp[0].datAdvise, rowInvApp[0].datValueDate, rowInvApp[0].datInvestmentAmount, MySessionManager.CurrentUser.BranchID, 0, 0, 0, 0, 1, MySessionManager.InvAppID); ///Calculates the interest for the days elapsed before creation of the account int days = DateDiff(DateTime.Now, rowInvApp[0].datValueDate); int term = Convert.ToInt32(util.displayValue("opt_terms", rowInvApp[0].datTerms.ToString())); if (days > term) { days = term; } InvestmentAccountDSTableAdapters.GetInterestCalcTableAdapter InvAcc1 = new InvestmentAccountDSTableAdapters.GetInterestCalcTableAdapter(); if (days > 0) { decimal previousInt = calc_interest(MySessionManager.InvAppID, days); ///Insert a new record into the calculation table for the Daily chron-job InvAcc1.InsertInvCalc(MySessionManager.InvAppID.ToString(), MySessionManager.ClientID, rowInvApp[0].datApplicationNumber.ToString(), DateTime.Now.ToShortDateString(), rowInvApp[0].datInvestmentAmount, rowInvApp[0].datInterestRatePerAnnum, days, term, previousInt, previousInt); } else { // decimal previousInt = calc_interest(MySessionManager.InvAppID, days); ///Insert a new record into the calculation table for the Daily chron-job InvAcc1.InsertInvCalc(MySessionManager.InvAppID.ToString(), MySessionManager.ClientID, rowInvApp[0].datApplicationNumber.ToString(), DateTime.Now.ToShortDateString(), rowInvApp[0].datInvestmentAmount, rowInvApp[0].datInterestRatePerAnnum, 0, term, 0, 0); } } Response.Redirect("~/pages/invapplications.aspx"); } catch (Exception ex) { } }
protected void gvClients_RowDataBound(object sender, GridViewRowEventArgs e) { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); if (e.Row.RowType == DataControlRowType.DataRow) { int terms=0; InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter InvAcc = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); InvestmentAccountDS.GetInvAccountDataTable tblInvAcc = InvAcc.GetInvAccount(Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex].Value)); string enpValue = MyEncryption.Encrypt(this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString(), "12345678910"); DateTime dt =DateTime.Parse(gvClients.DataKeys[e.Row.RowIndex]["datValueDate"].ToString()); e.Row.Cells[0].Text = client.GetClientsName(Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex]["datClientID"].ToString())).ToString(); e.Row.Cells[4].Text = util.displayValue("opt_investment_types", gvClients.DataKeys[e.Row.RowIndex]["datInvestmentType"].ToString()); terms = Convert.ToInt32(util.displayValue("opt_terms", gvClients.DataKeys[e.Row.RowIndex]["datFrequencyOfInterestPayment"].ToString())); int freq = Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex]["datFrequencyOfInterestPayment"].ToString()); Panel ItemBox = new Panel(); ItemBox.Attributes.Add("id", "div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString()); ItemBox.Attributes.Add("id", "div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString()); ItemBox.Attributes.Add("class", "ItemContainer"); ItemBox.Style.Add("display", "none"); string htmlContent = "<div class='col-md-9' style='padding-top:0'><label> Matured Interest(s) </label><br/>"; if (tblInvAcc[0].dat30 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=30&val=" + tblInvAcc[0].dat30.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 30).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat60 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=60&val=" + tblInvAcc[0].dat60.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 60).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat91 > 0 && freq == 2) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=91&val=" + tblInvAcc[0].dat91.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 90).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat121 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=121&val=" + tblInvAcc[0].dat121.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 121).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat151 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=151&val=" + tblInvAcc[0].dat151.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 151).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat182 > 0 && freq == 3) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=182&val=" + tblInvAcc[0].dat182.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 182).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat212 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=212&val=" + tblInvAcc[0].dat212.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 212).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat242 > 0 && freq ==1) { htmlContent += "<a href=../pages/invaccount/iinterestmaturity.aspx?id=" + enpValue + "&schID=242&val=" + tblInvAcc[0].dat242.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 242).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat273 > 0 && freq == 2) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=273&val=" + tblInvAcc[0].dat273.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 273).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat303 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=303&val=" + tblInvAcc[0].dat303.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 303).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat333 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=333&val=" + tblInvAcc[0].dat333.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 303).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat364 > 0 && freq == 4) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=364&val=" + tblInvAcc[0].dat364.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 364).ToString("dd/MM/yyyy") + " </a> <br/>"; } htmlContent += "</div>"; Literal ItemContent = new Literal(); ItemContent.Text = htmlContent; ItemBox.Controls.Add(ItemContent); HyperLink hyp = new HyperLink(); hyp.NavigateUrl = "javascript:showinfo('div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString() + "')"; hyp.Text = e.Row.Cells[0].Text; e.Row.Cells[0].Controls.Add(hyp); e.Row.Cells[0].Controls.Add(ItemBox); //HyperLink clientProfile = (HyperLink)e.Row.FindControl("hyperClientProfile"); //HyperLink Inv = (HyperLink)e.Row.FindControl("hyperInv"); } }