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;
        }
    }
Exemple #3
0
    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";
        }
    }
Exemple #5
0
    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));
    }