public IActionResult BankDepositDetailView(string breadCumValue, long bankDepositId) { if (HttpContext.Session.GetString("loggedIn") == null || HttpContext.Session.GetString("loggedIn") == "false") { return(RedirectToAction("Index", "Login")); } ViewBag.breadCumValue = breadCumValue; ViewBag.IsUpdate = bankDepositId > 0 ? "true" : "false"; BankDepositViewModel bankDepositViewModel = new BankDepositViewModel(); if (bankDepositId > 0) { bankDepositViewModel = (from a in _context.BankDeposits where a.BankDepositId == bankDepositId select new BankDepositViewModel() { BankDepositId = a.BankDepositId, Cash = a.Cash, InHandCash = a.InHandCash, Date = a.Date, CreatedBy = a.CreatedBy, ThirdPartyChequesId = a.BankDepositThirdPartyCheques.Select(x => x.ThirdPartyChequeId).ToList() }).Single(); bankDepositViewModel.ChequeTotal = _context.ThirdPartyCheques .Where(x => bankDepositViewModel.ThirdPartyChequesId.Contains(x.ThirdPartyChequeId)).Sum(s => s.Amount); } bankDepositViewModel.ThirdPartyChequesList = _context.ThirdPartyCheques.Select(x => new ThirdPartyCheque() { ThirdPartyChequeId = x.ThirdPartyChequeId, ChequeCode = x.ChequeCode, Amount = x.Amount }).ToList(); return(View(bankDepositViewModel)); }
public ActionResult BankDeposit() { BankDepositViewModel model = new BankDepositViewModel(); model.BankAccountLedgerHeads = db.BankAccountLedgerHeads.Where(a => a.Editable == true && a.Status == true && a.LedgerTypes == LedgerType.Credit).ToList(); return(View(model)); }
public IActionResult Create(BankDepositViewModel model) { BankDeposit bankDeposit = _mapper.Map <BankDeposit>(model); bankDeposit.CreatedDate = DateTime.Now; bankDeposit.Status = 1; var bankDepositThirdPartyCheques = new List <BankDepositThirdPartyCheque>(); model.ThirdPartyChequesId.ForEach(item => { bankDepositThirdPartyCheques.Add(new BankDepositThirdPartyCheque() { ThirdPartyChequeId = item }); }); bankDeposit.BankDepositThirdPartyCheques = bankDepositThirdPartyCheques; _context.BankDeposits.Add(bankDeposit); var balanceSheets = _context.BalanceSheets.SingleOrDefault(c => c.BalanceSheetId == 1); if (balanceSheets == null) { return(Ok()); } balanceSheets.InHandCash -= bankDeposit.InHandCash; balanceSheets.BankBalance += bankDeposit.Cash + bankDeposit.InHandCash; balanceSheets.InHold += model.ChequeTotal; var thirdPartyCheques = _context.ThirdPartyCheques.Where(x => model.ThirdPartyChequesId.Contains(x.ThirdPartyChequeId)).ToList(); thirdPartyCheques.ForEach(x => x.Status = 5); _context.ThirdPartyCheques.UpdateRange(thirdPartyCheques); var flag = _context.SaveChanges(); List <ThirdPartyChequeActionLog> actionLog = new List <ThirdPartyChequeActionLog>(); thirdPartyCheques.ForEach(y => { actionLog.Add(new ThirdPartyChequeActionLog { UserId = model.CreatedBy, ChequeStatusId = 5, ThirdPartyChequeId = y.ThirdPartyChequeId, ReferenceId = bankDeposit.BankDepositId }); }); _context.ThirdPartyChequeActionLogs.AddRange(actionLog); _context.SaveChanges(); return(Ok(flag > 0)); }
public static BankDepositListViewModel GetBankDepositByUser(string username) { Entities entities = new Entities(); var bankDeposits = entities.Assets.Where(x => x.Username.Equals(username) && x.AssetType == (int)Constants.Constants.ASSET_TYPE.BANK_DEPOSIT && !x.DisabledDate.HasValue).OrderBy(x => x.AssetName).ToList(); BankDepositListViewModel result = new BankDepositListViewModel(); foreach (var bankDeposit in bankDeposits) { BankDepositViewModel viewModel = new BankDepositViewModel { Id = bankDeposit.Id, Name = bankDeposit.AssetName, Value = bankDeposit.Value, StartDate = bankDeposit.StartDate.Value, EndDate = bankDeposit.EndDate.Value, Income = bankDeposit.InterestRatePerX.Value == (int)Constants.Constants.INTEREST_RATE_PER.MONTH ? bankDeposit.Value * bankDeposit.InterestRate.Value / 100 : bankDeposit.Value * bankDeposit.InterestRate.Value / 1200, InterestRate = bankDeposit.InterestRate.Value / 100, InterestRatePerX = Helper.GetInterestTypePerX(bankDeposit.InterestRatePerX.Value), InterestObtainWay = Helper.GetObtainWay(bankDeposit.ObtainedBy.Value), PaymentPeriod = Helper.CalculateTimePeriod(bankDeposit.StartDate.Value, bankDeposit.EndDate.Value), Note = bankDeposit.Note }; viewModel.AnnualIncome = viewModel.Income * 12; result.BankDeposits.Add(viewModel); } result.TotalValue = result.BankDeposits.Sum(x => x.Value); result.TotalIncome = result.BankDeposits.Sum(x => x.Income); result.TotalAnnualIncome = result.BankDeposits.Sum(x => x.AnnualIncome); result.TotalInterestRate = result.TotalValue > 0 ? result.TotalAnnualIncome / result.TotalValue : 0; result.IsInitialized = UserQueries.IsCompleteInitialized(username); return(result); }
public BankDepositApproval() { InitializeComponent(); _viewModel = (BankDepositViewModel)LayoutRoot.DataContext; DataContext = _viewModel; }
public ActionResult BankDeposit(BankDepositViewModel model) { if (!ModelState.IsValid) { return(RedirectToAction("BankDeposit", "Banks")); } if (model == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { try { bool status = false; int TransactionMethod = (int)model.TransactionMethod; #region Bank Deposit - Payment Method * Cash if (TransactionMethod == 1) { BankDepositCashVoucher Obj = new BankDepositCashVoucher(); Obj.Amount = model.Amount; Obj.BankAccountId = model.BankAccountId; Obj.BankLedgerHeadId = model.BankAccountLedgerHeadId; Obj.Notes = model.Notes; Obj.UserID = User.Identity.GetUserId(); Obj.LedgerDate = model.LedgerDate; status = new BankDA().InsertBankDepositCashVoucher(Obj); } #endregion #region Bank Deposit - Payment Method * Cheque else if (TransactionMethod == 2) { BankDepositChequeVoucher Obj = new BankDepositChequeVoucher(); Obj.Amount = model.Amount; Obj.BankAccountId = model.BankAccountId; Obj.BankOfChequeId = (int)model.BankOfChequeId; Obj.ChequeNo = model.ChequeNo; Obj.AccountNo = model.AccountNo; Obj.SortCode = model.SortCode; Obj.Notes = model.Notes; Obj.UserID = User.Identity.GetUserId(); Obj.LedgerDate = model.LedgerDate; Obj.ChequeStauts = (int)ChequeStatus.Floating; status = new BankDA().InsertBankDepositChequeVoucher(Obj); } #endregion #region Bank Deposit - Payment Method * Credit Card else if (TransactionMethod == 3) { BankDepositCreditCardVoucher Obj = new BankDepositCreditCardVoucher(); Obj.Amount = model.Amount; Obj.BankAccountId = model.BankAccountId; Obj.BankDate = model.BankDate; Obj.CardHolder = model.CardHolderName; Obj.CardNo = model.CreditCardNo; Obj.ExtraAmount = model.ExtraAmount; Obj.LedgerDate = model.LedgerDate; Obj.LedgerHeadId = model.BankAccountLedgerHeadId; Obj.Notes = model.Notes; Obj.UserID = User.Identity.GetUserId(); status = new BankDA().InsertBankDepositCreditCardVoucher(Obj); } #endregion #region Bank Deposit - Payment Method * Debit Card else if (TransactionMethod == 4) { BankDepositDebitCardVoucher Obj = new BankDepositDebitCardVoucher(); Obj.Amount = model.Amount; Obj.BankAccountId = model.BankAccountId; Obj.BankDate = model.BankDate; Obj.CardHolder = model.CardHolderName; Obj.CardNo = model.CreditCardNo; Obj.ExtraAmount = model.ExtraAmount; Obj.LedgerDate = model.LedgerDate; Obj.LedgerHeadId = model.BankAccountLedgerHeadId; Obj.Notes = model.Notes; Obj.UserID = User.Identity.GetUserId(); status = new BankDA().InsertBankDepositDebitCardVoucher(Obj); } #endregion #region Bank Deposit - Payment Method * Direct Deposit else if (TransactionMethod == 5) { BankDepositDirectDepositVoucher Obj = new BankDepositDirectDepositVoucher(); Obj.Amount = model.Amount; Obj.BankAccountId = model.BankAccountId; Obj.BankLedgerHeadId = model.BankAccountLedgerHeadId; Obj.Notes = model.Notes; Obj.UserID = User.Identity.GetUserId(); Obj.LedgerDate = model.LedgerDate; status = new BankDA().InsertBankDepositDirectDepositVoucher(Obj); } #endregion return(RedirectToAction("BankLedger", "Banks", new { @id = model.BankAccountId, @BankName = model.BankNames })); } catch (Exception ex) { return(RedirectToAction("BankDeposit", "Banks")); } } }