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) { }
}
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) { }
}
