public IActionResult Create(ThirdPartyChequeViewModel model) { ThirdPartyCheque thirdPartyCheque = _mapper.Map <ThirdPartyCheque>(model); ThirdPartyChequeActionLog actionLog = model.ActionLog; actionLog.ThirdPartyCheque = thirdPartyCheque; _context.ThirdPartyChequeActionLogs.Add(actionLog); var flag = _context.SaveChanges(); if (thirdPartyCheque.Status == 1) // if cheque is in hand { var single = _context.BalanceSheets.Single(x => x.BalanceSheetId == 1); single.InHandCheque += thirdPartyCheque.Amount; flag = _context.SaveChanges(); } if (thirdPartyCheque.Status == 5) // if cheque is banked { var single = _context.BalanceSheets.Single(x => x.BalanceSheetId == 1); single.InHold += thirdPartyCheque.Amount; flag = _context.SaveChanges(); } return(Ok(flag > 0)); }
public IActionResult ThirdPartyChequeDetailView(string breadCumValue, long thirdPartyChequeId) { if (HttpContext.Session.GetString("loggedIn") == null || HttpContext.Session.GetString("loggedIn") == "false") { return(RedirectToAction("Index", "Login")); } ViewBag.breadCumValue = breadCumValue; ViewBag.IsUpdate = thirdPartyChequeId > 0 ? "true" : "false"; ThirdPartyChequeViewModel thirdPartyChequeViewModel = new ThirdPartyChequeViewModel(); if (thirdPartyChequeId > 0) { thirdPartyChequeViewModel = _mapper .Map <ThirdPartyChequeViewModel>(_context.ThirdPartyCheques.SingleOrDefault(x => x.ThirdPartyChequeId == thirdPartyChequeId)); } thirdPartyChequeViewModel.ChequeStatusesVm = _mapper.Map <List <ChequeStatusViewModel> >(_context.ChequeStatuses.Where(x => x.StatusType.Contains("CH")).ToList()); thirdPartyChequeViewModel.BankList = _context.ThirdPartyCheques.Select(x => x.Bank).Distinct().ToList(); thirdPartyChequeViewModel.BranchList = _context.ThirdPartyCheques.Select(x => x.Branch).Distinct().ToList(); thirdPartyChequeViewModel.CustomerList = _context.Customers.Where(s => s.CurrentStatus == 1).Select(x => new Customer() { CustomerId = x.CustomerId, CustomerName = x.CustomerName }).ToList(); thirdPartyChequeViewModel.SupplierList = _context.Suppliers.Where(s => s.CurrentStatus == 1).Select(x => new Supplier() { SupplierId = x.SupplierId, SupplierName = x.SupplierName }).ToList(); return(View(thirdPartyChequeViewModel)); }
public IActionResult Update(ThirdPartyChequeViewModel model) { ThirdPartyCheque thirdPartyCheque = _mapper.Map <ThirdPartyCheque>(model); _context.ThirdPartyCheques.Update(thirdPartyCheque); // _context.SaveChanges(); ThirdPartyChequeActionLog actionLog = model.ActionLog; actionLog.ThirdPartyChequeId = model.ThirdPartyChequeId; _context.ThirdPartyChequeActionLogs.Add(actionLog); var flag = _context.SaveChanges(); if (thirdPartyCheque.Status == 5) // if cheque is banked { var single = _context.BalanceSheets.Single(x => x.BalanceSheetId == 1); single.InHold += thirdPartyCheque.Amount; flag = _context.SaveChanges(); } if (thirdPartyCheque.Status == 6) // if cheque is passed { var single = _context.BalanceSheets.Single(x => x.BalanceSheetId == 1); single.InHold -= thirdPartyCheque.Amount; single.BankBalance += thirdPartyCheque.Amount; flag = _context.SaveChanges(); } if (thirdPartyCheque.Status == 2) // if cheque is returned { var single = _context.BalanceSheets.Single(x => x.BalanceSheetId == 1); single.InHold -= thirdPartyCheque.Amount; flag = _context.SaveChanges(); } return(Ok(flag > 0)); }