public void saveDisburse(int accid, decimal cash, decimal bank) { Decimal totalAmt = cash + bank; LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountDataTable tblLoanAcc = loanAcc.GetLoanAccount(accid); if (tblLoanAcc.Rows.Count > 0) { LoanDSTableAdapters.GetDisburseLoanTableAdapter disburse = new LoanDSTableAdapters.GetDisburseLoanTableAdapter(); disburse.InsertDisburseLoan(accid, tblLoanAcc[0].datAccountNumber.ToString(), tblLoanAcc[0].datClientFullName.ToString(), DateTime.Now, tblLoanAcc[0].datEndDate, tblLoanAcc[0].datInterestRate, cash, bank, totalAmt, tblLoanAcc[0].datFees, tblLoanAcc[0].datLoanType, tblLoanAcc[0].datPurpose, tblLoanAcc[0].datTeamID, tblLoanAcc[0].datCreditTeamID, MySessionManager.CurrentUser.UserID); } }
public void createAccount() { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); mainDS.ClientDataTable tblClient = client.GetClientProfile(MySessionManager.ClientID); decimal interestrate = Convert.ToDecimal(tblLoanApp[0].datInterestRate.ToString()); decimal IntAmt = (Convert.ToDecimal(lbltotalamt.InnerText) * (interestrate / 100)); interestamt = IntAmt; decimal AmtOut = Convert.ToDecimal(lbltotalamt.InnerText); decimal FinRptBalance_monthly = IntAmt + AmtOut; DateTime enddate = addMonth(DateTime.Now, Convert.ToInt32(tblLoanApp[0].datDuration.ToString())); if ((tblClient.Rows.Count > 0) || (tblLoanApp.Rows.Count > 0)) { int refreshedID = 0; if (tblLoanApp[0].IsdatRefreshedIDNull() == false) { refreshedID = tblLoanApp[0].datRefreshedID; } LoanAccountDSTableAdapters.GetLoanAccountTableAdapter account = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); account.InsertLoanAccount(createAccountNumber(MySessionManager.ClientID), Convert.ToDecimal(tblLoanApp[0].datFees.ToString()), MySessionManager.ClientID, MySessionManager.AppID, Convert.ToInt32(tblLoanApp[0].datTeamID.ToString()), DateTime.Now, enddate, Convert.ToInt32(tblLoanApp[0].datInterestRate), Convert.ToInt32(tblLoanApp[0].datDuration.ToString()), 0, IntAmt, AmtOut, FinRptBalance_monthly, MySessionManager.CurrentUser.UserID, FinRptBalance_monthly, DateTime.Now, DateTime.Now, Convert.ToInt32(tblLoanApp[0].datPurpose.ToString()), IntAmt, refreshedID, Convert.ToInt32(tblLoanApp[0].datCreditTeamID.ToString()), tblClient[0].datClientName.ToString(), Convert.ToInt32(tblLoanApp[0].datLoanType.ToString())); } LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountDataTable tblLoanAc = loanAc.GetLoanAccount1(MySessionManager.AppID, MySessionManager.ClientID); if (tblLoanAc.Rows.Count > 0) { MySessionManager.AccountID = tblLoanAc[0].datID; MySessionManager.AppBranchID = tblLoanApp[0].datTeamID; } }
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 Page_Load(object sender, EventArgs e) { mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter(); #region QueryStringBlock if (Request.QueryString["id"] != null) { string EncID = Request.QueryString["id"]; int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910")); MySessionManager.AccountID = DecID; // ShowMessageBox(" " + DecID + " "); LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountDataTable tblLoanAcc = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID)); if (tblLoanAcc.Rows.Count > 0) { lblClient.InnerText = tblLoanAcc[0].datClientFullName.ToString(); lblbranch.InnerText = util.displayValue("tbl_teams", tblLoanAcc[0].datTeamID.ToString()); lbldate.InnerText = tblLoanAcc[0].datStartDate.ToLongDateString(); lbltotalamt.InnerText = tblLoanAcc[0].datOutstandingAmount.ToString("C").Replace("$", ""); } } if (!(Request.QueryString["trdelete"] == null)) { try { string id = Request.QueryString["trdelete"]; tempHolder.DeleteTransactionDetails1(Convert.ToInt32(MySessionManager.AccountID), Convert.ToInt32(id)); Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "trdelete")); } catch { } } #endregion try { lblTotal.Text = tempHolder.GetTransTotalAmount(MySessionManager.AppID).ToString(); } catch (Exception ex) { lblTotal.Text = "0.00"; } }
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 btnFinalize_Click(object sender, EventArgs e) { 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.GetAccTransactions(Convert.ToInt32(MySessionManager.AccountID)); 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; amtDeductable = amtDeductable + tblTempHolder[i].datDebit; ops = 1; } else if (tblTempHolder[i].datCredit > 0) { datCreditAc = tblTempHolder[i].datAccountID; amt = tblTempHolder[i].datCredit; amtDeductable = amtDeductable - 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.AppID, MySessionManager.ClientID, tblTempHolder[i].datAccountID, Convert.ToInt32(MySessionManager.AccountID), tblTempHolder[i].datDescription, batch(), tblTempHolder[i].datPaymentMethod, MySessionManager.CurrentUser.BranchID, tblTempHolder[i].datCredit, tblTempHolder[i].datDebit, datCreditAc, datDebitAc, 0, MySessionManager.CurrentUser.UserID); } mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountDataTable tblLoaonAcc = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID)); LoanAccountDSTableAdapters.GetAllLoanRepaymentsTableAdapter repayment = new LoanAccountDSTableAdapters.GetAllLoanRepaymentsTableAdapter(); if (tblLoaonAcc.Rows.Count > 0) { repayment.InsertLoanRepayment(receiptNo(), DateTime.Now, tblLoaonAcc[0].datID, tblLoaonAcc[0].datAccountNumber.ToString(), client.GetClientNo(Convert.ToInt32(MySessionManager.AccountID)), tblLoaonAcc[0].datIssueDate, tblLoaonAcc[0].datInterestRate, MySessionManager.cash, MySessionManager.bank, (MySessionManager.cash + MySessionManager.bank), fees, tblLoaonAcc[0].datLoanType, tblLoaonAcc[0].datPurpose, tblLoaonAcc[0].datTeamID, MySessionManager.CurrentUser.UserID); } loanAcc.UpdateNewAmtOutstanding(amtDeductable, Convert.ToInt32(MySessionManager.AccountID)); decimal outstanding = Convert.ToDecimal(loanAcc.GetAmtOutstanding(Convert.ToInt32(MySessionManager.AccountID))); if (outstanding <= 0) { loanAcc.UpdateCloseAccount(Convert.ToInt32(MySessionManager.AccountID)); } tempHolder.DeleteTempTransByAccID(Convert.ToInt32(MySessionManager.AccountID)); }