public void completeRefreshment()
{
int OldAppID = 0;
LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter();
LoanAccountDS.GetLoanAccountDataTable tblLoanAcc = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID));
LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter loanAccRefRecord = new LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter();
LoanAccountDS.GetAccountRefreshmentRecordDataTable tblLoanAccRefRecord = loanAccRefRecord.GetAccountRefreshmentRecord(Convert.ToInt32(MySessionManager.AccountID));
OldAccount = tblLoanAccRefRecord[0].datOldAppID;
if (tblLoanAcc.Rows.Count > 0)
{
createAccount(tblLoanAcc[0].datOutstandingAmount);
}
LoanDSTableAdapters.FinancialTransactionsTableAdapter FinTrans = new LoanDSTableAdapters.FinancialTransactionsTableAdapter();
FinTrans.InsertFinancialTransaction(OldAppID,
MySessionManager.ClientID,
1,
tblLoanAcc[0].datID,
"Account Refreshed",
"closed",
0,
tblLoanAcc[0].datTeamID,
tblLoanAcc[0].datOutstandingAmount,
0,
0,
0,
0,
MySessionManager.CurrentUser.UserID
);
LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter loanAcRef = new LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter();
loanAcRef.UpdateSetAccountClosed(Convert.ToInt32(MySessionManager.AccountID));
loanAccRefRecord.UpdateNewAccountID(Convert.ToInt32(MySessionManager.AccountID), tblLoanAcc[0].datID);
}
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];
int LoanType = tblLoanAcc.datLoanType;
setLoanTypeTabs(tblLoanAcc.datLoanType);
showLoanAppInfo();
try
{
LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter LoanAcRef = new LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter();
LoanAccountDS.GetAccountRefreshmentRecordDataTable tblAccountRef = LoanAcRef.GetAccountRefreshmentRecord(Convert.ToInt32(MySessionManager.AccountID));
if (!(tblAccountRef.Rows.Count > 0))
{
MySessionManager.AppID = tblLoanAcc.datApplicationID;
MySessionManager.ClientID = tblLoanAcc.datClientID;
}
else
{
MySessionManager.AppID = tblAccountRef[0].datNewAppID;
MySessionManager.ClientID = tblLoanAcc.datClientID;
}
}
catch (Exception ex) { }
setUrls();
#region QueryString
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 = 25;
}
else
{
currentTab = 25;
}
setTab(currentTab);
}
#endregion
}
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) { }
}
