protected void btnSave_Click(object sender, EventArgs e)
{
try
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
string clientname = client.GetClientsName(MySessionManager.ClientID).ToString();
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvApp.UpdateInvestmentApp(txtName.Value,
clientname,
GetApplicationNo(),
0,
Convert.ToInt32(ddlTerms.SelectedValue),
Convert.ToDecimal(txtInvestmentAmt.Value),
Convert.ToInt32(ddlType.SelectedValue),
Convert.ToDecimal(txtRatePerAnnum.Value),
Convert.ToInt32(ddlFrequencyInt.SelectedValue),
Convert.ToInt32(ddlModeOfInv.SelectedValue),
txtFunds.Value,
Convert.ToInt32(ddlVerifed.SelectedValue),
MySessionManager.InvAppID);
loadInvestmentDetails();
}
catch (Exception ex) { }
Response.Redirect(Request.RawUrl.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
//int DecID = Convert.ToInt32(EncID);
#region "QueryString Block"
string EncID = Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
MySessionManager.InvAppID = DecID;
MySessionManager.ClientID = Convert.ToInt32(invApp.GetClientID(MySessionManager.InvAppID));
#endregion
setNotifications();
if ((!(util.alert1() == "")) && (MySessionManager.skipAlert == 0))
{
this.pAlertmsg.InnerText = util.alert1();
// Define the name and type of the client scripts on the page.
String csname1 = "PopupScript";
String csname2 = "ButtonClickScript";
Type cstype = this.GetType();
// Get a ClientScriptManager reference from the Page class.
ClientScriptManager cs = Page.ClientScript;
// Check to see if the startup script is already registered.
if (!cs.IsStartupScriptRegistered(cstype, csname1))
{
String cstext1 = "alertMessage();";
cs.RegisterStartupScript(cstype, csname1, cstext1, true);
}
MySessionManager.skipAlert = 1;
}
showLoanAppInfo();
}
//
public void paymentschedule()
{
decimal amt = 0;
decimal per = 0;
DateTime dt = DateTime.Now;
int term = 0, freq = 0, type = 0;
try
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = invApp.GetInvestmentApp(MySessionManager.InvAppID);
if (tblInvApp.Rows.Count > 0)
{
if (tblInvApp[0].IsdatInvestmentTypeNull() == false) { type = tblInvApp[0].datInvestmentType; }
if (tblInvApp[0].IsdatInvestmentAmountNull() == false) { amt = tblInvApp[0].datInvestmentAmount; }
if (tblInvApp[0].IsdatInterestRatePerAnnumNull() == false) {; per = tblInvApp[0].datInterestRatePerAnnum; }
if (tblInvApp[0].IsdatTermsNull() == false) { term = tblInvApp[0].datTerms; }
if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false) { freq = Convert.ToInt32(tblInvApp[0].datFrequencyOfInterestPayment); }
if (tblInvApp[0].IsdatValueDateNull() == false) { dt = tblInvApp[0].datValueDate; }
term = converrtterm(term);
freq = convertfrequency(freq);
CalculateIntPayment(term, freq, amt, per, dt);
}
}
catch (Exception ex) { }
}
/// <summary>
/// This function displays information about current application being worked
/// </summary>
public void showLoanAppInfo()
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = invApp.GetInvestmentApp(MySessionManager.InvAppID);
if (tblInvApp.Rows.Count > 0)
{
try
{
this.lblapplicantName.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString();
this.lblClientNo.InnerText = client.GetClientNo(MySessionManager.ClientID).ToString();
if (tblInvApp[0].IsdatInvestmentAmountNull() == false) { this.lblInvestmentAmount.InnerText = tblInvApp[0].datInvestmentAmount.ToString("c").Replace("$", ""); }
if (tblInvApp[0].IsdatInvestmentNameNull() == false) { this.lblInvestmentName.InnerText = tblInvApp[0].datInvestmentName.ToString(); }
if (tblInvApp[0].IsdatTermsNull() == false) { this.lblTerm.InnerText = util.displayValue("opt_terms", tblInvApp[0].datTerms.ToString()) + " days"; }
if (tblInvApp[0].IsdatApplicationNumberNull() == false) { this.lblAppNo.InnerText = tblInvApp[0].datApplicationNumber.ToString(); }
if (tblInvApp[0].IsdatValueDateNull() == false) { this.lblValueDate.InnerText = tblInvApp[0].datValueDate.ToString("c").Replace("$", ""); }
if (tblInvApp[0].IsdatInvestmentTypeNull() == false) { this.lblInvtype.InnerText = util.displayValue("opt_investment_types", tblInvApp[0].datInvestmentType.ToString()); }
if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false) { this.lblAccInterest.InnerText = tblInvApp[0].datFrequencyOfInterestPayment.ToString(); }
}
catch (Exception ex)
{ }
}
}
protected void Page_Load(object sender, EventArgs e)
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
//int DecID = Convert.ToInt32(EncID);
#region "QueryString Block"
string EncID = Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
MySessionManager.InvAppID = DecID;
MySessionManager.ClientID = Convert.ToInt32(invApp.GetClientID(MySessionManager.InvAppID));
#endregion
setNotifications();
if ((!(util.alert1() == "")) && (MySessionManager.skipAlert == 0))
{
this.pAlertmsg.InnerText = util.alert1();
// Define the name and type of the client scripts on the page.
String csname1 = "PopupScript";
String csname2 = "ButtonClickScript";
Type cstype = this.GetType();
// Get a ClientScriptManager reference from the Page class.
ClientScriptManager cs = Page.ClientScript;
// Check to see if the startup script is already registered.
if (!cs.IsStartupScriptRegistered(cstype, csname1))
{
String cstext1 = "alertMessage();";
cs.RegisterStartupScript(cstype, csname1, cstext1, true);
}
MySessionManager.skipAlert = 1;
}
showLoanAppInfo();
}
public string GetApplicationNo()
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
int GetCount = Convert.ToInt32(InvApp.GetInvAppCount());
return((GetCount + 1).ToString());
}
public void loadInvestmentDetails()
{
decimal amt = 0;
decimal per = 0;
DateTime dt = DateTime.Now;
int term = 0, freq = 0, type = 0;
try
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = invApp.GetInvestmentApp(MySessionManager.InvAppID);
if (tblInvApp.Rows.Count > 0)
{
if (tblInvApp[0].IsdatInvestmentNameNull() == false)
{
txtName.Value = tblInvApp[0].datInvestmentName.ToString();
}
if (tblInvApp[0].IsdatInvestmentTypeNull() == false)
{
ddlType.SelectedValue = tblInvApp[0].datInvestmentType.ToString(); type = tblInvApp[0].datInvestmentType;
}
if (tblInvApp[0].IsdatInvestmentAmountNull() == false)
{
txtInvestmentAmt.Value = tblInvApp[0].datInvestmentAmount.ToString(); amt = tblInvApp[0].datInvestmentAmount;
}
if (tblInvApp[0].IsdatModeOfRepaymentNull() == false)
{
ddlModeOfInv.SelectedValue = tblInvApp[0].datModeOfRepayment.ToString();
}
if (tblInvApp[0].IsdatInterestRatePerAnnumNull() == false)
{
txtRatePerAnnum.Value = tblInvApp[0].datInterestRatePerAnnum.ToString(); per = tblInvApp[0].datInterestRatePerAnnum;
}
if (tblInvApp[0].IsdatTermsNull() == false)
{
ddlTerms.SelectedValue = tblInvApp[0].datTerms.ToString(); term = tblInvApp[0].datTerms;
}
if (tblInvApp[0].IsdatFundsNull() == false)
{
txtFunds.Value = tblInvApp[0].datFunds.ToString();
}
if (tblInvApp[0].IsdatVerifiedNull() == false)
{
ddlVerifed.SelectedValue = tblInvApp[0].datVerified.ToString();
}
if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false)
{
ddlFrequencyInt.SelectedValue = tblInvApp[0].datFrequencyOfInterestPayment.ToString(); freq = Convert.ToInt32(tblInvApp[0].datFrequencyOfInterestPayment);
}
this.editskip.Value = "2";
term = converrtterm(term);
freq = convertfrequency(freq);
CalculateIntPayment(term, freq, amt, per, dt);
}
}
catch (Exception ex) { }
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
try
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvApp.UpdateApplicationStatus(2, MySessionManager.InvAppID);
Response.Redirect("~/pages/invapplications.aspx");
}
catch (Exception ex) { }
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime dt = DateTime.Parse(txtValue.Text, ukCulture);
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvApp.UpdateSetValueDate(dt, MySessionManager.InvAppID);
}
catch (Exception ex) { }
}
public void setURLs()
{
this.btnIntestmentDetails.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=1&ops=load";
this.btnPersonalInfo.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=2&ops=load";
this.btnJointInfo.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=3&ops=load";
this.btnCoporateInfo.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=4&ops=load";
this.btnInitiatorsInfo.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=5&ops=load";
this.btnDirectors.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=6&ops=load";
this.btnBeneficiaries.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=7&ops=load";
this.btnnok.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=8&ops=load";
this.btnConPerson.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=9&ops=load";
this.btnbankers.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=10&ops=load";
this.btnsupportingdocs.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=11&ops=load";
this.btnAdvise.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=12&ops=load";
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
int type = Convert.ToInt32(InvApp.GetInvestmentType(MySessionManager.InvAppID));
if (type == 1)
{
this.btnJointInfo.Visible = false;
this.btnCoporateInfo.Visible = false;
this.btnDirectors.Visible = false;
this.btnBeneficiaries.Visible = false;
this.btnInitiatorsInfo.Visible = false;
}
else if (type == 2)
{
this.btnPersonalInfo.Visible = false;
this.btnDirectors.Visible = false;
this.btnBeneficiaries.Visible = false;
this.btnCoporateInfo.Visible = false;
this.btnInitiatorsInfo.Visible = false;
}
else if (type == 3)
{
this.btnPersonalInfo.Visible = false;
this.btnBeneficiaries.Visible = false;
this.btnJointInfo.Visible = false;
btnInitiatorsInfo.Visible = false;
this.btnnok.Visible = false;
}
else if (type == 4)
{
this.btnPersonalInfo.Visible = false;
this.btnCoporateInfo.Visible = false;
this.btnJointInfo.Visible = false;
this.btnDirectors.Visible = false;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime dt=DateTime.Parse(txtValue .Text, ukCulture);
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvApp.UpdateSetValueDate(dt,MySessionManager.InvAppID);
}
catch (Exception ex) { }
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
editFlag = true;
CultureInfo ukCulture = new CultureInfo("en-GB");
DateTime dt = DateTime.Parse(txtValue.Text, ukCulture);
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvApp.UpdateSetValueDate(dt, MySessionManager.InvAppID);
paymentschedule();
}
catch (Exception ex) { }
}
public void showLoanAppInfo()
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = invApp.GetInvestmentApp(MySessionManager.InvAppID);
if (tblInvApp.Rows.Count > 0)
{
try
{
this.lblapplicantName.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString();
this.lblClientNo.InnerText = client.GetClientNo(MySessionManager.ClientID).ToString();
if (tblInvApp[0].IsdatInvestmentAmountNull() == false)
{
this.lblInvestmentAmount.InnerText = tblInvApp[0].datInvestmentAmount.ToString("c").Replace("$", "");
}
if (tblInvApp[0].IsdatInvestmentNameNull() == false)
{
this.lblInvestmentName.InnerText = tblInvApp[0].datInvestmentName.ToString();
}
if (tblInvApp[0].IsdatTermsNull() == false)
{
this.lblTerm.InnerText = util.displayValue("opt_terms", tblInvApp[0].datTerms.ToString()) + " days";
}
if (tblInvApp[0].IsdatApplicationNumberNull() == false)
{
this.lblAppNo.InnerText = tblInvApp[0].datApplicationNumber.ToString();
}
if (tblInvApp[0].IsdatValueDateNull() == false)
{
this.lblValueDate.InnerText = tblInvApp[0].datValueDate.ToString("c").Replace("$", "");
}
if (tblInvApp[0].IsdatInvestmentTypeNull() == false)
{
this.lblInvtype.InnerText = util.displayValue("opt_investment_types", tblInvApp[0].datInvestmentType.ToString());
}
if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false)
{
this.lblAccInterest.InnerText = tblInvApp[0].datFrequencyOfInterestPayment.ToString();
}
if (tblInvApp[0].IsdatValueDateNull() == false)
{
this.lblValueDate.InnerText = tblInvApp[0].datValueDate.ToString("dd-MM-yyyy");
}
}
catch (Exception ex)
{ }
}
}
protected void Page_Load(object sender, EventArgs e)
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
//int DecID = Convert.ToInt32(EncID);
#region "QueryString Block"
string EncID = Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
MySessionManager.InvAppID = DecID;
MySessionManager.ClientID = Convert.ToInt32(invApp.GetClientID(MySessionManager.InvAppID));
#endregion
try
{
mainDSTableAdapters.NotificationCountTableAdapter tblCounter = new mainDSTableAdapters.NotificationCountTableAdapter();
mainDS.NotificationCountRow itemcount = tblCounter.NotificationCount(MySessionManager.CurrentUser.BranchID, MySessionManager.CurrentUser.UserID, MySessionManager.CurrentUser.TeamID)[0];
this.pendingRecInfo.InnerText = (Convert.ToInt32(itemcount.receipts.ToString())).ToString();
this.pendingDisInfo.InnerText = (Convert.ToInt32(itemcount.disbursementI.ToString()) + Convert.ToInt32(itemcount.disbursementII.ToString()) + Convert.ToInt32(itemcount.disbursementIII.ToString())).ToString();
}
catch (Exception ex)
{
}
if ((!(util.alert1() == "")) && (MySessionManager.skipAlert == 0))
{
this.pAlertmsg.InnerText = util.alert1();
// Define the name and type of the client scripts on the page.
String csname1 = "PopupScript";
String csname2 = "ButtonClickScript";
Type cstype = this.GetType();
// Get a ClientScriptManager reference from the Page class.
ClientScriptManager cs = Page.ClientScript;
// Check to see if the startup script is already registered.
if (!cs.IsStartupScriptRegistered(cstype, csname1))
{
String cstext1 = "alertMessage();";
cs.RegisterStartupScript(cstype, csname1, cstext1, true);
}
MySessionManager.skipAlert = 1;
}
showLoanAppInfo();
}
//
public void paymentschedule()
{
decimal amt = 0;
decimal per = 0;
DateTime dt = DateTime.Now;
int term = 0, freq = 0, type = 0;
try
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = invApp.GetInvestmentApp(MySessionManager.InvAppID);
if (tblInvApp.Rows.Count > 0)
{
if (tblInvApp[0].IsdatInvestmentTypeNull() == false)
{
type = tblInvApp[0].datInvestmentType;
}
if (tblInvApp[0].IsdatInvestmentAmountNull() == false)
{
amt = tblInvApp[0].datInvestmentAmount;
}
if (tblInvApp[0].IsdatInterestRatePerAnnumNull() == false)
{
; per = tblInvApp[0].datInterestRatePerAnnum;
}
if (tblInvApp[0].IsdatTermsNull() == false)
{
term = tblInvApp[0].datTerms;
}
if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false)
{
freq = Convert.ToInt32(tblInvApp[0].datFrequencyOfInterestPayment);
}
if (tblInvApp[0].IsdatValueDateNull() == false)
{
dt = tblInvApp[0].datValueDate;
}
term = converrtterm(term);
freq = convertfrequency(freq);
CalculateIntPayment(term, freq, amt, per, dt);
}
}
catch (Exception ex) { }
}
protected void btnApply_Click(object sender, EventArgs e)
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
string EncID = this.ckey.Value;
//Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
int cType = Convert.ToInt32(client.GetClientType(DecID));
if (ddlProducts.SelectedValue == "1")
{
int lType = 0;
if (cType == 1)
{
lType = 1;
}
else if (cType == 2)
{
lType = 2;
}
else if (cType == 3)
{
lType = 4;
}
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
string clientname = client.GetClientsName(DecID).ToString();
loanApp.InsertNewApplication(DecID,
clientname,
lType,
MySessionManager.CurrentUser.BranchID,
MySessionManager.CurrentUser.UserID);
ShowMessageBox("Loan Application for " + clientname + " submited successfully");
}
else if (ddlProducts.SelectedValue == "2")
{
string clientname = client.GetClientsName(DecID).ToString();
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invapp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
invapp.InsertInvestmentApplication(DecID,
clientname,
1,
MySessionManager.CurrentUser.BranchID);
ShowMessageBox("Investment Application for " + clientname + " submited successfully");
}
}
/// <summary>
/// Calculate the interest of an application for a certain number of days
/// It takes the ID of the investment application and the number of days
/// </summary>
/// <param name="id">The Investment Application ID </param>
/// <param name="days">The number of days</param>
/// <returns>The interest that have been calculated</returns>
public decimal calc_interest(int id, int days)
{
decimal interest = 0;
decimal intRate = 0;
decimal amt = 0;
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = InvApp.GetInvestmentApp(MySessionManager.InvAppID);
if (tblInvApp.Rows.Count > 0)
{
intRate = tblInvApp[0].datInterestRatePerAnnum;
amt = tblInvApp[0].datInvestmentAmount;
}
interest = ((amt * intRate) / 36500) * days;
return(interest);
}
protected void Page_Load(object sender, EventArgs e)
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
//int DecID = Convert.ToInt32(EncID);
#region "QueryString Block"
string EncID = Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
MySessionManager.InvAppID = DecID;
MySessionManager.ClientID = Convert.ToInt32(invApp.GetClientID(MySessionManager.InvAppID));
#endregion
try
{
mainDSTableAdapters.NotificationCountTableAdapter tblCounter = new mainDSTableAdapters.NotificationCountTableAdapter();
mainDS.NotificationCountRow itemcount = tblCounter.NotificationCount(MySessionManager.CurrentUser.BranchID, MySessionManager.CurrentUser.UserID, MySessionManager.CurrentUser.TeamID)[0];
this.pendingRecInfo.InnerText = (Convert.ToInt32(itemcount.receipts.ToString())).ToString();
this.pendingDisInfo.InnerText = (Convert.ToInt32(itemcount.disbursementI.ToString()) + Convert.ToInt32(itemcount.disbursementII.ToString()) + Convert.ToInt32(itemcount.disbursementIII.ToString())).ToString();
}
catch (Exception ex)
{
}
if ((!(util.alert1() == "")) && (MySessionManager.skipAlert == 0))
{
this.pAlertmsg.InnerText = util.alert1();
// Define the name and type of the client scripts on the page.
String csname1 = "PopupScript";
String csname2 = "ButtonClickScript";
Type cstype = this.GetType();
// Get a ClientScriptManager reference from the Page class.
ClientScriptManager cs = Page.ClientScript;
// Check to see if the startup script is already registered.
if (!cs.IsStartupScriptRegistered(cstype, csname1))
{
String cstext1 = "alertMessage();";
cs.RegisterStartupScript(cstype, csname1, cstext1, true);
}
MySessionManager.skipAlert = 1;
}
showLoanAppInfo();
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
editFlag = true;
CultureInfo ukCulture = new CultureInfo("en-GB");
DateTime dt = DateTime.Parse(txtValue.Text, ukCulture);
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvApp.UpdateSetValueDate(dt, MySessionManager.InvAppID);
paymentschedule();
}
catch (Exception ex) { }
}
/// <summary>
/// Loads the record of the selected application
/// </summary>
public void loadInvSummary()
{
try
{
mainDSTableAdapters.GetClientInfoTableAdapter client = new mainDSTableAdapters.GetClientInfoTableAdapter();
mainDS.GetClientInfoDataTable tblClient = client.GetClientInfo(MySessionManager.ClientID);
if(tblClient.Rows.Count>0)
{
if(tblClient[0].IsdatClientNameNull()==false ){lblClientName.InnerText = tblClient[0].datClientName.ToString();}
if(tblClient[0].IsdatClientNumberNull()==false ){lblClientNo.InnerText = tblClient[0].datClientNumber.ToString();}
if(tblClient[0].IsdatMobileNumber1Null()==false ){lblMobile1.InnerText = tblClient[0].datMobileNumber1.ToString();}
}
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = InvApp.GetInvestmentApp(MySessionManager.InvAppID);
if (tblInvApp.Rows.Count > 0)
{
if (tblInvApp[0].IsdatInvestmentNameNull() == false) { this.lblInvestmentName.InnerText = tblInvApp[0].datInvestmentName.ToString(); }
if (tblInvApp[0].IsdatInterestRatePerAnnumNull() == false) { this.lblRatePerAnnum.InnerText = tblInvApp[0].datInterestRatePerAnnum.ToString("c").Replace("$",""); }
if (tblInvApp[0].IsdatInvestmentTypeNull() == false) { this.lblType.InnerText =util.displayValue("opt_investment_types" ,tblInvApp[0].datInvestmentType.ToString()); }
if (tblInvApp[0].IsdatTermsNull() == false) { this.lblTerms.InnerText =util.displayValue("opt_terms" , tblInvApp[0].datTerms.ToString())+" days"; }
if (tblInvApp[0].IsdatInvestmentNameNull() == false) { this.lblInvestmentName.InnerText = tblInvApp[0].datInvestmentName.ToString(); }
if (tblInvApp[0].IsdatModeOfRepaymentNull() == false) { this.lblModeOfInv.InnerText = util.displayValue("opt_payment_modes", tblInvApp[0].datModeOfRepayment.ToString()); }
if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false) { this.lblFreqPayment.InnerText = util.displayValue("opt_frequencies_investments", tblInvApp[0].datFrequencyOfInterestPayment.ToString()); }
if (tblInvApp[0].IsdatInvestmentAmountNull() == false) { this.lblAmount.InnerText = tblInvApp[0].datInvestmentAmount.ToString("c").Replace("$",""); }
if (tblInvApp[0].IsdatValueDateNull() == false) { this.txtValue.Text = tblInvApp[0].datValueDate.ToString("dd-MM-yyyy"); }
}
}
catch (Exception ex) { }
}
protected void Page_Load(object sender, EventArgs e)
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = InvApp.GetInvestmentApp(MySessionManager.InvAppID);
mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter();
try
{ lblTotal.Text = tempHolder.GetTransTotalAmount(MySessionManager.AppID).ToString(); }
catch (Exception ex)
{
lblTotal.Text = "0.00";
}
if (tblInvApp.Rows.Count > 0)
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
lbltotalamt.InnerText = tblInvApp[0].datInvestmentAmount.ToString("c").Replace("$", "");
lbldate.InnerText = DateTime.Now.ToLongDateString();
lblClient.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString();
lblbranch.InnerText = util.displayValue("tbl_teams", InvApp.GetInvBranch(MySessionManager.InvAppID).ToString());
}
if (!(this.editskip.Value == "2"))
{
}
if (!(Request.QueryString["trdelete"] == null))
{
try
{
string id = Request.QueryString["trdelete"];
tempHolder.DeleteTransactionDetails(Convert.ToInt32(id), MySessionManager.AppID);
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "trdelete"));
}
catch
{ }
}
}
protected void Page_Load(object sender, EventArgs e)
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = InvApp.GetInvestmentApp(MySessionManager.InvAppID);
mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter();
try
{ lblTotal.Text = tempHolder.GetTransTotalAmount(MySessionManager.AppID).ToString(); }
catch (Exception ex)
{
lblTotal.Text = "0.00";
}
if (tblInvApp.Rows.Count > 0)
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
lbltotalamt.InnerText = tblInvApp[0].datInvestmentAmount.ToString("c").Replace("$", "");
lbldate.InnerText = DateTime.Now.ToLongDateString();
lblClient.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString();
lblbranch.InnerText = util.displayValue("tbl_teams", InvApp.GetInvBranch(MySessionManager.InvAppID).ToString());
}
if (!(this.editskip.Value == "2"))
{
}
if (!(Request.QueryString["trdelete"] == null))
{
try
{
string id = Request.QueryString["trdelete"];
tempHolder.DeleteTransactionDetails(Convert.ToInt32(id), MySessionManager.AppID);
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "trdelete"));
}
catch
{ }
}
}
protected void btnApply_Click(object sender, EventArgs e)
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
string EncID = this.ckey.Value;
//Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
int cType = Convert.ToInt32(client.GetClientType(DecID));
if (ddlProducts.SelectedValue == "1")
{
int lType=0;
if (cType == 1) { lType = 1; } else if (cType == 2) { lType = 2; } else if (cType == 3) { lType = 4; }
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
string clientname = client.GetClientsName(DecID).ToString();
loanApp.InsertNewApplication(DecID,
clientname,
lType,
MySessionManager.CurrentUser.BranchID,
MySessionManager.CurrentUser.UserID);
ShowMessageBox("Loan Application for " + clientname + " submited successfully");
}
else if(ddlProducts.SelectedValue=="2")
{
string clientname = client.GetClientsName(DecID).ToString();
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invapp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
invapp.InsertInvestmentApplication(DecID,
clientname,
1,
MySessionManager.CurrentUser.BranchID);
ShowMessageBox("Investment Application for " + clientname + " submited successfully");
}
}
public void loadTab(int id, string ops)
{
try
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
int InvType = Convert.ToInt32(InvApp.GetInvestmentType(MySessionManager.InvAppID));
if (InvType == 1)
{
for (int j = 0; j < indie.Length; j++)
{
if (indie[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(indie[m]);
MySessionManager.CurrentTab = indie[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(m);
MySessionManager.CurrentTab = indie[m].ToString();
}
}
}
}
}
else if (InvType == 2 )
{
for (int j = 0; j < joint.Length; j++)
{
if (joint[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(joint[m]);
MySessionManager.CurrentTab = joint[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(joint[m]);
MySessionManager.CurrentTab = joint[m].ToString();
}
}
}
}
}
else if( InvType == 3)
{
for (int j = 0; j < insti.Length; j++)
{
if (insti[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(insti[m]);
MySessionManager.CurrentTab = insti[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(insti[m]);
MySessionManager.CurrentTab = insti[m].ToString();
}
}
}
}
}
else if (InvType == 4)
{
for (int j = 0; j < intrust.Length; j++)
{
if (intrust[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(intrust[m]);
MySessionManager.CurrentTab = intrust[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(intrust[m]);
MySessionManager.CurrentTab = intrust[m].ToString();
}
}
}
}
}
}
catch (Exception ex) { }
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
try
{
MySessionManager.cash = 0;
MySessionManager.bank = 0;
decimal amtDeductable = 0;
decimal fees = 0;
decimal amt = 0;
int ops = 0;
mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter();
mTemp.GetTransactionDetailsDataTable tblTempHolder = tempHolder.GetInvTempTransactions(MySessionManager.InvAppID);
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.InvAppID,
MySessionManager.ClientID,
tblTempHolder[i].datAccountID,
MySessionManager.InvAppID,
tblTempHolder[i].datDescription,
batch(),
tblTempHolder[i].datPaymentMethod,
MySessionManager.AppBranchID,
tblTempHolder[i].datCredit,
tblTempHolder[i].datDebit,
datCreditAc,
datDebitAc,
0,
MySessionManager.CurrentUser.UserID);
}
}
catch(Exception ex) { }
//This block of code changes the status of the application
try
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvApp.UpdateApplicationStatus(3, MySessionManager.InvAppID);
Response.Redirect("~/pages/invapplications.aspx");
}
catch (Exception ex) { }
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
string clientname = client.GetClientsName(MySessionManager.ClientID).ToString();
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvApp.UpdateInvestmentApp(txtName.Value,
clientname,
GetApplicationNo(),
0,
Convert.ToInt32(ddlTerms.SelectedValue),
Convert.ToDecimal(txtInvestmentAmt.Value),
Convert.ToInt32(ddlType.SelectedValue),
Convert.ToDecimal(txtRatePerAnnum.Value),
Convert.ToInt32(ddlFrequencyInt.SelectedValue),
Convert.ToInt32(ddlModeOfInv.SelectedValue),
txtFunds.Value,
Convert.ToInt32(ddlVerifed.SelectedValue),
MySessionManager.InvAppID);
loadInvestmentDetails();
}
catch (Exception ex) { }
Response.Redirect(Request.RawUrl .ToString());
}
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) { }
}
public string GetApplicationNo()
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
int GetCount =Convert.ToInt32(InvApp.GetInvAppCount());
return (GetCount +1).ToString();
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
try
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvApp.UpdateApplicationStatus(2, MySessionManager.InvAppID);
Response.Redirect("~/pages/invapplications.aspx");
}
catch (Exception ex) { }
}
protected void Page_Load(object sender, EventArgs e)
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
#region "QueryString Block"
string EncID = Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
MySessionManager.InvAppID = DecID;
MySessionManager.ClientID = Convert.ToInt32(invApp.GetClientID(MySessionManager.InvAppID));
if (!(Request.QueryString["ops"] == null))
{
if (!(Request.QueryString["tab"] == null))
{
if (!(Request.QueryString["tab"] == ""))
{
currentTab = int.Parse(Request.QueryString["tab"]);
}
else
{
currentTab = Convert.ToInt32(MySessionManager.CurrentTab);
}
ops = Request.QueryString["ops"].ToString();
setTab(currentTab);
MySessionManager.CurrentTab = currentTab.ToString();
MySessionManager.OpsTab = "load";
string urlpath = util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab");
urlpath = util.RemoveQueryStringByKey(urlpath, "ops");
Response.Redirect(urlpath);
}
else
{
if (!(Request.QueryString["tab"] == ""))
{
currentTab = int.Parse(Request.QueryString["tab"]);
}
else
{
currentTab = 1;
}
ops = "load";
setTab(currentTab);
MySessionManager.CurrentTab = currentTab.ToString();
MySessionManager.OpsTab = "load";
util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab");
util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ops");
}
}
else
{
ops = MySessionManager.OpsTab.ToString();
//For handling the tabs
if (!(MySessionManager.CurrentTab == ""))
{
currentTab = int.Parse(MySessionManager.CurrentTab);
}
else
{
currentTab = 1;
}
MySessionManager.CurrentTab = currentTab.ToString();
setTab(currentTab);
}
#endregion
//For posting the alert that has been placed on the application
if ((!(util.alert1() == "")) && (MySessionManager.skipAlert == 0))
{
this.pAlertmsg.InnerText = util.alert1();
// Define the name and type of the client scripts on the page.
String csname1 = "PopupScript";
String csname2 = "ButtonClickScript";
Type cstype = this.GetType();
// Get a ClientScriptManager reference from the Page class.
ClientScriptManager cs = Page.ClientScript;
// Check to see if the startup script is already registered.
if (!cs.IsStartupScriptRegistered(cstype, csname1))
{
String cstext1 = "alertMessage();";
cs.RegisterStartupScript(cstype, csname1, cstext1, true);
}
MySessionManager.skipAlert = 1;
}
setURLs();
showLoanAppInfo();
setNotifications();
}
/// <summary>
/// Loads the record of the selected application
/// </summary>
public void loadInvSummary()
{
try
{
mainDSTableAdapters.GetClientInfoTableAdapter client = new mainDSTableAdapters.GetClientInfoTableAdapter();
mainDS.GetClientInfoDataTable tblClient = client.GetClientInfo(MySessionManager.ClientID);
if (tblClient.Rows.Count > 0)
{
if (tblClient[0].IsdatClientNameNull() == false)
{
lblClientName.InnerText = tblClient[0].datClientName.ToString();
}
if (tblClient[0].IsdatClientNumberNull() == false)
{
lblClientNo.InnerText = tblClient[0].datClientNumber.ToString();
}
if (tblClient[0].IsdatMobileNumber1Null() == false)
{
lblMobile1.InnerText = tblClient[0].datMobileNumber1.ToString();
}
}
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = InvApp.GetInvestmentApp(MySessionManager.InvAppID);
if (tblInvApp.Rows.Count > 0)
{
if (tblInvApp[0].IsdatInvestmentNameNull() == false)
{
this.lblInvestmentName.InnerText = tblInvApp[0].datInvestmentName.ToString();
}
if (tblInvApp[0].IsdatInterestRatePerAnnumNull() == false)
{
this.lblRatePerAnnum.InnerText = tblInvApp[0].datInterestRatePerAnnum.ToString("c").Replace("$", "");
}
if (tblInvApp[0].IsdatInvestmentTypeNull() == false)
{
this.lblType.InnerText = util.displayValue("opt_investment_types", tblInvApp[0].datInvestmentType.ToString());
}
if (tblInvApp[0].IsdatTermsNull() == false)
{
this.lblTerms.InnerText = util.displayValue("opt_terms", tblInvApp[0].datTerms.ToString()) + " days";
}
if (tblInvApp[0].IsdatInvestmentNameNull() == false)
{
this.lblInvestmentName.InnerText = tblInvApp[0].datInvestmentName.ToString();
}
if (tblInvApp[0].IsdatModeOfRepaymentNull() == false)
{
this.lblModeOfInv.InnerText = util.displayValue("opt_payment_modes", tblInvApp[0].datModeOfRepayment.ToString());
}
if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false)
{
this.lblFreqPayment.InnerText = util.displayValue("opt_frequencies_investments", tblInvApp[0].datFrequencyOfInterestPayment.ToString());
}
if (tblInvApp[0].IsdatInvestmentAmountNull() == false)
{
this.lblAmount.InnerText = tblInvApp[0].datInvestmentAmount.ToString("c").Replace("$", "");
}
if (tblInvApp[0].IsdatValueDateNull() == false)
{
this.txtValue.Text = tblInvApp[0].datValueDate.ToString("dd-MM-yyyy");
}
}
}
catch (Exception ex) { }
}
public void setURLs()
{
this.btnIntestmentDetails.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=1&ops=load";
this.btnPersonalInfo.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=2&ops=load";
this.btnJointInfo.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=3&ops=load";
this.btnCoporateInfo.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=4&ops=load";
this.btnInitiatorsInfo.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=5&ops=load";
this.btnDirectors.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=6&ops=load";
this.btnBeneficiaries.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=7&ops=load";
this.btnnok.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=8&ops=load";
this.btnConPerson.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=9&ops=load";
this.btnbankers.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=10&ops=load";
this.btnsupportingdocs.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=11&ops=load";
this.btnAdvise.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=12&ops=load";
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
int type =Convert.ToInt32(InvApp.GetInvestmentType(MySessionManager.InvAppID));
if(type==1)
{
this.btnJointInfo.Visible = false;
this.btnCoporateInfo.Visible = false;
this.btnDirectors.Visible = false;
this.btnBeneficiaries.Visible = false;
this.btnInitiatorsInfo.Visible = false;
}
else if (type == 2)
{
this.btnPersonalInfo.Visible = false;
this.btnDirectors.Visible = false;
this.btnBeneficiaries.Visible = false;
this.btnCoporateInfo.Visible = false;
this.btnInitiatorsInfo.Visible = false;
}
else if (type == 3)
{
this.btnPersonalInfo.Visible = false;
this.btnBeneficiaries.Visible = false;
this.btnJointInfo.Visible = false;
btnInitiatorsInfo.Visible = false;
this.btnnok.Visible = false;
}
else if (type == 4)
{
this.btnPersonalInfo.Visible = false;
this.btnCoporateInfo.Visible = false;
this.btnJointInfo.Visible = false;
this.btnDirectors.Visible = false;
}
}
public void loadTab(int id, string ops)
{
try
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
int InvType = Convert.ToInt32(InvApp.GetInvestmentType(MySessionManager.InvAppID));
if (InvType == 1)
{
for (int j = 0; j < indie.Length; j++)
{
if (indie[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(indie[m]);
MySessionManager.CurrentTab = indie[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(m);
MySessionManager.CurrentTab = indie[m].ToString();
}
}
}
}
}
else if (InvType == 2)
{
for (int j = 0; j < joint.Length; j++)
{
if (joint[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(joint[m]);
MySessionManager.CurrentTab = joint[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(joint[m]);
MySessionManager.CurrentTab = joint[m].ToString();
}
}
}
}
}
else if (InvType == 3)
{
for (int j = 0; j < insti.Length; j++)
{
if (insti[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(insti[m]);
MySessionManager.CurrentTab = insti[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(insti[m]);
MySessionManager.CurrentTab = insti[m].ToString();
}
}
}
}
}
else if (InvType == 4)
{
for (int j = 0; j < intrust.Length; j++)
{
if (intrust[j] == id)
{
if (ops == "Next")
{
int m = j + 1;
setTab(intrust[m]);
MySessionManager.CurrentTab = intrust[m].ToString();
}
else if (ops == "Previous")
{
if (j > 0)
{
int m = j - 1;
setTab(intrust[m]);
MySessionManager.CurrentTab = intrust[m].ToString();
}
}
}
}
}
}
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 btnFinalize_Click(object sender, EventArgs e)
{
try
{
MySessionManager.cash = 0;
MySessionManager.bank = 0;
decimal amtDeductable = 0;
decimal fees = 0;
decimal amt = 0;
int ops = 0;
mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter();
mTemp.GetTransactionDetailsDataTable tblTempHolder = tempHolder.GetInvTempTransactions(MySessionManager.InvAppID);
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.InvAppID,
MySessionManager.ClientID,
tblTempHolder[i].datAccountID,
MySessionManager.InvAppID,
tblTempHolder[i].datDescription,
batch(),
tblTempHolder[i].datPaymentMethod,
MySessionManager.AppBranchID,
tblTempHolder[i].datCredit,
tblTempHolder[i].datDebit,
datCreditAc,
datDebitAc,
0,
MySessionManager.CurrentUser.UserID);
}
}
catch (Exception ex) { }
//This block of code changes the status of the application
try
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvApp.UpdateApplicationStatus(3, MySessionManager.InvAppID);
Response.Redirect("~/pages/invapplications.aspx");
}
catch (Exception ex) { }
}
protected void Page_Load(object sender, EventArgs e)
{
#region "QueryString Block"
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
string EncID = Request.QueryString["id"];
int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910"));
MySessionManager.InvAppID = DecID;
MySessionManager.ClientID = Convert.ToInt32(invApp.GetClientID(MySessionManager.InvAppID));
if (!(Request.QueryString["ops"] == null))
{
if (!(Request.QueryString["tab"] == null))
{
if (!(Request.QueryString["tab"] == ""))
currentTab = int.Parse(Request.QueryString["tab"]);
else
currentTab = Convert.ToInt32(MySessionManager.CurrentTab);
ops = Request.QueryString["ops"].ToString();
setTab(currentTab);
MySessionManager.CurrentTab = currentTab.ToString();
MySessionManager.OpsTab = "load";
string urlpath = util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab");
urlpath = util.RemoveQueryStringByKey(urlpath, "ops");
Response.Redirect(urlpath);
}
else
{
if (!(Request.QueryString["tab"] == ""))
currentTab = int.Parse(Request.QueryString["tab"]);
else
currentTab = 1;
ops = "load";
setTab(currentTab);
MySessionManager.CurrentTab = currentTab.ToString();
MySessionManager.OpsTab = "load";
util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab");
util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ops");
}
}
else
{
ops = MySessionManager.OpsTab.ToString();
//For handling the tabs
if (!(MySessionManager.CurrentTab == ""))
currentTab = int.Parse(MySessionManager.CurrentTab);
else
currentTab = 1;
MySessionManager.CurrentTab = currentTab.ToString();
setTab(currentTab);
}
#endregion
//For posting the alert that has been placed on the application
if ((!(util.alert1() == "")) && (MySessionManager.skipAlert == 0))
{
this.pAlertmsg.InnerText = util.alert1();
// Define the name and type of the client scripts on the page.
String csname1 = "PopupScript";
String csname2 = "ButtonClickScript";
Type cstype = this.GetType();
// Get a ClientScriptManager reference from the Page class.
ClientScriptManager cs = Page.ClientScript;
// Check to see if the startup script is already registered.
if (!cs.IsStartupScriptRegistered(cstype, csname1))
{
String cstext1 = "alertMessage();";
cs.RegisterStartupScript(cstype, csname1, cstext1, true);
}
MySessionManager.skipAlert = 1;
}
setURLs();
setNotifications();
showLoanAppInfo();
}
/// <summary>
/// Calculate the interest of an application for a certain number of days
/// It takes the ID of the investment application and the number of days
/// </summary>
/// <param name="id">The Investment Application ID </param>
/// <param name="days">The number of days</param>
/// <returns>The interest that have been calculated</returns>
public decimal calc_interest(int id, int days)
{
decimal interest=0;
decimal intRate=0;
decimal amt=0;
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = InvApp.GetInvestmentApp(MySessionManager.InvAppID);
if (tblInvApp.Rows.Count > 0)
{
intRate = tblInvApp[0].datInterestRatePerAnnum;
amt = tblInvApp[0].datInvestmentAmount;
}
interest =((amt*intRate)/36500)*days;
return interest;
}
public void loadInvestmentDetails()
{
decimal amt=0;
decimal per=0;
DateTime dt =DateTime.Now;
int term=0,freq=0,type=0;
try
{
InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter();
InvestmentDS.GetInvestmentAppDataTable tblInvApp = invApp.GetInvestmentApp(MySessionManager.InvAppID);
if (tblInvApp.Rows.Count > 0)
{
if (tblInvApp[0].IsdatInvestmentNameNull() == false) { txtName.Value = tblInvApp[0].datInvestmentName.ToString(); }
if (tblInvApp[0].IsdatInvestmentTypeNull() == false) { ddlType.SelectedValue = tblInvApp[0].datInvestmentType.ToString(); type = tblInvApp[0].datInvestmentType; }
if (tblInvApp[0].IsdatInvestmentAmountNull() == false) { txtInvestmentAmt.Value = tblInvApp[0].datInvestmentAmount.ToString(); amt = tblInvApp[0].datInvestmentAmount; }
if (tblInvApp[0].IsdatModeOfRepaymentNull() == false) { ddlModeOfInv.SelectedValue = tblInvApp[0].datModeOfRepayment.ToString(); }
if (tblInvApp[0].IsdatInterestRatePerAnnumNull() == false) { txtRatePerAnnum.Value = tblInvApp[0].datInterestRatePerAnnum.ToString(); per = tblInvApp[0].datInterestRatePerAnnum; }
if (tblInvApp[0].IsdatTermsNull() == false) { ddlTerms.SelectedValue = tblInvApp[0].datTerms.ToString(); term =tblInvApp[0].datTerms; }
if (tblInvApp[0].IsdatFundsNull() == false) { txtFunds.Value = tblInvApp[0].datFunds.ToString(); }
if (tblInvApp[0].IsdatVerifiedNull() == false) { ddlVerifed.SelectedValue = tblInvApp[0].datVerified.ToString(); }
if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false) { ddlFrequencyInt.SelectedValue = tblInvApp[0].datFrequencyOfInterestPayment.ToString(); freq = Convert.ToInt32(tblInvApp[0].datFrequencyOfInterestPayment); }
this.editskip.Value = "2";
term = converrtterm(term);
freq = convertfrequency(freq);
CalculateIntPayment(term,freq,amt,per,dt);
}
}
catch (Exception ex) { }
}
