public List <RepaymentView> ReadRepayment(TellerMobileDeposit tellerDeposit) { List <RepaymentView> repayments = new List <RepaymentView>(); var loanproductNames = loanProductsMgr.GetLoanCodes(db, false).ToList(); var investnames = investMgr.InvestmentsCodes(db).ToList(); String ledger = tellerDeposit.ProductCode; if (ledger.Substring(0, 1) == "0") { ledger = "SAVINGS"; } else { ledger = ledger.Substring(0, 1).In("A", "L") ? "LOANS" : "INVESTMENTS"; } string productName = tellerDeposit.ProductCode; switch (ledger) { case "LOANS": if (loanproductNames.FirstOrDefault(x => x.LoanCode == tellerDeposit.ProductCode) != null) { productName = ValueConverters.ConvertNullToEmptyString( loanproductNames.FirstOrDefault(x => x.LoanCode == tellerDeposit.ProductCode).LoanName.ToString()); } break; case "INVESTMENTS": if (investnames.FirstOrDefault(x => x.InvestmentCode == tellerDeposit.ProductCode) != null) { productName = ValueConverters.ConvertNullToEmptyString( investnames.FirstOrDefault(x => x.InvestmentCode == tellerDeposit.ProductCode).InvestmentName.ToString()); } break; default: break; } repayments.Add(new RepaymentView { CustomerNo = tellerDeposit.CustomerNo, ProductCode = tellerDeposit.ProductCode, ProductName = productName, Amount = ValueConverters.ConvertDecimaltoDouble(tellerDeposit.TrxAmount), Ledger = ledger, Section = 1 }); return(repayments); }
public List <CustomerBalances> GetCustomerBalances(string customerNo, DateTime endDate, List <CustomerBalances> custBalances) { custBalances = custBalances ?? new List <CustomerBalances>(); custBalances.Clear(); try { string sqlstatement = " CustomerBalances '" + ValueConverters.format_sql_string(customerNo) + "','" + ValueConverters.FormatSqlDate(endDate, true) + "'"; DbDataReader reader = DbConnector.GetSqlReader(sqlstatement); double balance, interest, insurance, penalty, appraisal; while (reader.Read()) { balance = ValueConverters.StringtoDouble(reader["Balance"].ToString()); interest = ValueConverters.StringtoDouble(reader["IntBalance"].ToString()); insurance = ValueConverters.StringtoDouble(reader["InsBalance"].ToString()); penalty = ValueConverters.StringtoDouble(reader["PenBalance"].ToString()); appraisal = ValueConverters.StringtoDouble(reader["AppBalance"].ToString()); custBalances.Add(new CustomerBalances { CustomerNo = ValueConverters.ConvertNullToEmptyString(reader["CustomerNo"].ToString()), AccountNo = ValueConverters.ConvertNullToEmptyString(reader["AccountNo"].ToString()), CustomerName = ValueConverters.ConvertNullToEmptyString(reader["CustomerName"].ToString()), Category = ValueConverters.ConvertNullToEmptyString(reader["Category"].ToString()), Ttype = ValueConverters.ConvertNullToEmptyString(reader["ttype"].ToString()), ProductName = ValueConverters.ConvertNullToEmptyString(reader["ProductName"].ToString()), Balance = balance, IntBalance = interest, InsBalance = insurance, PenBalance = penalty, AppBalance = appraisal, TotalBalance = ValueConverters.Round05(balance + interest + insurance + penalty + appraisal), OtherCharges = insurance + penalty + appraisal }); } reader.Close(); } catch (Exception ex) { Utility.WriteErrorLog(ref ex); } return(custBalances); }
private void GetAccountClosureHistory(CustomerAccountsView customerAccountsDetails) { customerAccountsDetails.ClosedAccountDetails = new List <PostingJournalsHeaderViewModel>(); var closeDetails = mainDb.tbl_PostingJournals .Where(x => (x.PostingDocid == "ACRS" || x.PostingDocid == "ACLS") && x.AccountNo == customerAccountsDetails.AccountNo) .ToList(); if (closeDetails != null) { foreach (var item in closeDetails) { PostingJournalsHeaderViewModel lineItem = new PostingJournalsHeaderViewModel(); lineItem.PostingDescription = ValueConverters.ConvertNullToEmptyString(item.PostingDescription); lineItem.PostDate = ValueConverters.ConvertNullToDatetime(item.PostDate); lineItem.PostedBy = ValueConverters.ConvertNullToEmptyString(item.PostedBy); lineItem.CreateDate = ValueConverters.ConvertNullToDatetime(item.CreateDate); lineItem.CreatedBy = ValueConverters.ConvertNullToEmptyString(item.CreatedBy); lineItem.PaymentMethodName = item.PostingDocid == "ACLS" ? "Closure" : "Rejoin"; var opennedBy = mainDb.tbl_users.FirstOrDefault(x => x.LoginCode == lineItem.PostedBy); if (opennedBy != null) { lineItem.PostedByName = ValueConverters.ConvertNullToEmptyString(opennedBy.LoginName); } opennedBy = mainDb.tbl_users.FirstOrDefault(x => x.LoginCode == lineItem.CreatedBy); if (opennedBy != null) { lineItem.CreatedByName = ValueConverters.ConvertNullToEmptyString(opennedBy.LoginName); } customerAccountsDetails.ClosedAccountDetails.Add(lineItem); } } }
public CustomerAccountsView GetAccountByAccountNumber(string accountNumber, bool closureDetails = false) { customerAccounts = new List <CustomerAccountsView>(); var account = mainDb.tbl_CustomerAccounts.Where(x => x.AccountNo == accountNumber).ToList(); if (account != null && account.Count != 0) { GetAccountDetails(account.FirstOrDefault().CustomerNo, account, false); } var customerAccountsDetails = (from accounts in account select new CustomerAccountsView { AccountNo = accounts.AccountNo, OpenedBy = accounts.OpenedBy, AccountComments = accounts.AccountComments, AccountRemarks = accounts.AccountRemarks, AccountType = accounts.AccountType, Locked = accounts.Locked, OpenedDate = accounts.OpenedDate, AuthorisedBy = accounts.AuthorisedBy, AuthorisedDate = accounts.AuthorisedDate, DateClosed = accounts.DateClosed, ClosedBy = accounts.ClosedBy, CustomerNo = accounts.CustomerNo, ReasonClosed = string.Empty }).FirstOrDefault(); if (customerAccountsDetails != null && customerAccountsDetails.AuthorisedBy != null) { var opennedBy = mainDb.tbl_users.FirstOrDefault(x => x.LoginCode == customerAccountsDetails.AuthorisedBy); if (opennedBy != null) { customerAccountsDetails.AuthorisedBy = ValueConverters.ConvertNullToEmptyString(opennedBy.LoginName); } } if (customerAccountsDetails != null && customerAccountsDetails.OpenedBy != null) { var opennedBy = mainDb.tbl_users.FirstOrDefault(x => x.LoginCode == customerAccountsDetails.OpenedBy); if (opennedBy != null) { customerAccountsDetails.OpenedBy = ValueConverters.ConvertNullToEmptyString(opennedBy.LoginName); } } if (customerAccountsDetails != null) { var accountTypeDetails = accounttypes.FirstOrDefault(x => x.code == customerAccountsDetails.AccountType); if (accountTypeDetails == null) { accountTypeDetails = new tbl_accounttypes(); } customerAccountsDetails.AccountTypeSettings = accountTypeDetails; customerAccountsDetails.GlMemSav = accountTypeDetails.glmemsav; customerAccountsDetails.MinimumBalance = accountTypeDetails.minimum_bal; if (closureDetails) { GetAccountClosureHistory(customerAccountsDetails); var lastTr = customerAccountsDetails.ClosedAccountDetails.OrderByDescending(x => x.CreateDate).FirstOrDefault(); if (lastTr != null) { customerAccountsDetails.ReasonClosed = ValueConverters.ConvertNullToEmptyString(lastTr.PostingDescription); } } } customerAccountsDetails = customerAccountsDetails == null ? new CustomerAccountsView() : customerAccountsDetails; return(customerAccountsDetails); // return customerAccounts.FirstOrDefault(); }