protected void Page_Load(object sender, EventArgs e)
{
try
{
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountRow tblLoanAccRow = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0];
lblBranch.InnerText = util.displayValue("tbl_teams", tblLoanAccRow.datTeamID.ToString());
lblCreditTeam.InnerText = util.displayValue("sys_credit_teams", tblLoanAccRow.datCreditTeamID.ToString());
}
catch (Exception ex) { }
}
protected void Page_Load(object sender, EventArgs e)
{
try {
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountRow tblLoanAccRow = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0];
lblClientFullname.InnerText = tblLoanAccRow.datClientFullName.ToString();
loanAmtOutstanding.InnerText = tblLoanAccRow.datOutstandingAmount.ToString("c").Replace("$", "");
lblDuration.InnerText = tblLoanAccRow.datDuration.ToString() + " month(s)";
lblExpiryDate.InnerText = tblLoanAccRow.datEndDate.ToString("D");
lblInterestRate.InnerText = tblLoanAccRow.datInterestRate.ToString("c").Replace("$", "") + "%";
lblLoanAmount.InnerText = tblLoanAccRow.datInitialAmount.ToString("c").Replace("$", "");
lblLoanDate.InnerText = tblLoanAccRow.datStartDate.ToString("D");
lblCategory.InnerText = util.displayValue("opt_categories", tblLoanAccRow.datCategory.ToString());
}
catch (Exception ex) { }
}
public void showAccountInfomartion()
{
try {
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountRow tblLoanAcc = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0];
mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter();
lblAccNo.InnerText = " " + tblLoanAcc.datAccountNumber.ToString();
lblClienttName.InnerText = " " + tblLoanAcc.datClientFullName.ToString();
lblEmail.InnerText = " " + tblLoanAcc.datIssueDate.ToString("d MMMM yyyy");
lblloantype.InnerText = " " + util.displayValue("opt_loan_types", tblLoanAcc.datLoanType.ToString());
lblAmtOutstanding.InnerText = " " + tblLoanAcc.datOutstandingAmount.ToString("c").Replace("$", "");
lblloanAmount.InnerText = " " + tblLoanAcc.datInitialAmount.ToString("c").Replace("$", "");
lblClientNo.InnerText = " " + client.GetClientNo(tblLoanAcc.datClientID);
lblDuration.InnerText = " " + tblLoanAcc.datDuration.ToString() + " month(s)";
lblIntRate.InnerText = " " + tblLoanAcc.datInterestRate.ToString("c").Replace("$", "") + "%";
}
catch (Exception ex) { }
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter LoanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountRow tblLoanAcc = LoanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0];
txtIntRate.Text = tblLoanAcc.datInterestRate.ToString();
txtLoanAmount.Text = tblLoanAcc.datOutstandingAmount.ToString();
if (tblLoanAcc.datLoanType > 0)
{
ddlLoanType.SelectedValue = tblLoanAcc.datLoanType.ToString();
}
if (tblLoanAcc.datInterestRateType > 0)
{
ddlInterestRateType.SelectedValue = tblLoanAcc.datInterestRateType.ToString();
}
}
catch (Exception ex) { }
}
protected void btnFreezeAccount_Click(object sender, EventArgs e)
{
try {
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountRow tblLoanAccRow = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0];
LoanAccountDSTableAdapters.FrozenAccountsTableAdapter loanFreeze = new LoanAccountDSTableAdapters.FrozenAccountsTableAdapter();
loanFreeze.InsertFrozenAccount(Convert.ToInt32(MySessionManager.AccountID),
tblLoanAccRow.datAccountNumber,
tblLoanAccRow.datTeamID,
tblLoanAccRow.datPurpose,
tblLoanAccRow.datOutstandingAmount,
tblLoanAccRow.datCategory,
DateTime.Now,
tblLoanAccRow.datCreditTeamID,
tblLoanAccRow.datClientFullName,
tblLoanAccRow.datAgingDate,
tblLoanAccRow.datLoanType);
loanAcc.UpdateSetFrozenAccount(Convert.ToInt32(MySessionManager.AccountID));
ShowMessageBox("Account No.:" + tblLoanAccRow.datAccountNumber + "- " + tblLoanAccRow.datClientFullName + " has been frozen");
}
catch (Exception ex) { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (MySessionManager.CurrentUser == null)
{
Response.Redirect("~/login.aspx");
}
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter LoanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountRow tblLoanAcc = LoanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0];
MySessionManager.AppID = tblLoanAcc.datApplicationID;
MySessionManager.ClientID = tblLoanAcc.datClientID;
int LoanType = tblLoanAcc.datLoanType;
setLoanTypeTabs(tblLoanAcc.datLoanType);
setUrls();
showLoanAppInfo();
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
if (LoanType == 2 || LoanType == 3)
{
currentTab = 2;
}
else
{
currentTab = 0;
}
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
if (LoanType == 2 || LoanType == 3)
{
currentTab = 2;
}
else
{
currentTab = 0;
}
setTab(currentTab);
}
}
public void createNewApp()
{
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter LoanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountRow tblLoanAcc = LoanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0];
string AppID;
string AppNewID = "";
try
{
LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter RefreshAccount = new LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter();
LoanAccountDS.GetAccountRefreshmentRecordDataTable tblRefreshAccount = RefreshAccount.GetAccountRefreshmentRecord(Convert.ToInt32(MySessionManager.AccountID));
if (tblRefreshAccount.Rows.Count > 0)
{
MySessionManager.AppID = tblRefreshAccount[0].datNewAppID;
}
else
{
int?getAppID = null;
AppID = tblLoanAcc.datApplicationID.ToString();
LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter();
LoanAccountDSTableAdapters.AccountRefreshmentTableAdapter LoanAccRefreshment = new LoanAccountDSTableAdapters.AccountRefreshmentTableAdapter();
string appNo = loanApp.GetLoanApplicationNo(Convert.ToInt32(AppID)).ToString() + "-00";
LoanAccRefreshment.InsertNewRefreshApp(MySessionManager.ClientID,
tblLoanAcc.datClientFullName.ToString(),
Convert.ToInt32(ddlLoanType.SelectedValue),
appNo,
Convert.ToDecimal(txtLoanAmount.Text),
Convert.ToDecimal(txtLoanAmount.Text),
Convert.ToDecimal(txtLoanAmount.Text),
Convert.ToInt32(txtDuration.Text),
1,
Convert.ToDecimal(txtIntRate.Text),
DateTime.Now,
Convert.ToDateTime(txtFirstPaymentDate.Text),
0,
Convert.ToInt32(ddlInterestRateType.SelectedValue),
Convert.ToInt32(AppID),
Convert.ToInt32(ddlCT.SelectedValue),
Convert.ToInt32(tblLoanAcc.datTeamID),
ref getAppID);
AppNewID = getAppID.ToString();
LoanAccRefreshment.InsertCopyAssets(AppID, AppNewID);
LoanAccRefreshment.InsertCopyAuditors(AppID, AppNewID);
LoanAccRefreshment.InsertCopyBankers(AppID, AppNewID);
LoanAccRefreshment.InsertCopyChecklist(AppID, AppNewID);
LoanAccRefreshment.InsertCopyCollaterals(AppID, AppNewID);
LoanAccRefreshment.InsertCopyComments(AppID, AppNewID);
LoanAccRefreshment.InsertCopyCorporateInfo(AppID, AppNewID);
LoanAccRefreshment.InsertCopyCreditInformation(AppID, AppNewID);
LoanAccRefreshment.InsertCopyEnterprises(AppID, AppNewID);
LoanAccRefreshment.InsertCopyFees(AppID, AppNewID);
LoanAccRefreshment.InsertCopyFinancials(AppID, AppNewID);
LoanAccRefreshment.InsertCopyGuarantor(AppID, AppNewID);
LoanAccRefreshment.InsertCopyIncomeExpense(AppID, AppNewID);
LoanAccRefreshment.InsertCopyIntiator(AppID, AppNewID);
LoanAccRefreshment.InsertCopyLegalReports(AppID, AppNewID);
LoanAccRefreshment.InsertCopyNextOfKin(AppID, AppNewID);
LoanAccRefreshment.InsertCopyNoOfEmployees(AppID, AppNewID);
LoanAccRefreshment.InsertCopyOwnership(AppID, AppNewID);
LoanAccRefreshment.InsertCopyPaymentPlan(AppID, AppNewID);
LoanAccRefreshment.InsertCopyPDC(AppID, AppNewID);
LoanAccRefreshment.InsertCopyPreApprovalReports(AppID, AppNewID);
LoanAccRefreshment.InsertCopyReligion(AppID, AppNewID);
LoanAccRefreshment.InsertCopyReports(AppID, AppNewID);
LoanAccRefreshment.InsertCopyRiskReport(AppID, AppNewID);
LoanAccRefreshment.InsertCopySpouse(AppID, AppNewID);
LoanAccRefreshment.InsertCopySupportingDocuments(AppID, AppNewID);
LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter loanAcRef = new LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter();
loanAcRef.InsertAccountRefreshment(Convert.ToInt32(MySessionManager.AccountID),
Convert.ToInt32(AppID));
loanAcRef.UpdateNewAppID(Convert.ToInt32(AppNewID),
Convert.ToInt32(MySessionManager.AccountID));
MySessionManager.AppID = Convert.ToInt32(AppNewID);
}
}
catch (Exception ex) { }
}