public async Task <IActionResult> Edit(int id, [Bind("ImprestAccountsId,ImprestAccountsName,Balance,Equity,Manager,Department,Branch,Purpose")] BrhImprestAccounts brhImprestAccounts) { if (id != brhImprestAccounts.ImprestAccountsId) { return(NotFound()); } if (ModelState.IsValid) { try { var total = _context.BrhImprestRecord.Where(x => x.ImprestAccountsId == brhImprestAccounts.ImprestAccountsId && !x.IsMove).Sum(x => x.Amount); total += _context.BrhScalp.Where(x => x.ImprestAccountsId == brhImprestAccounts.ImprestAccountsId && !x.IsMove).Sum(x => x.TotalPrice); brhImprestAccounts.Equity = brhImprestAccounts.Balance - total; _context.Update(brhImprestAccounts); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BrhImprestAccountsExists(brhImprestAccounts.ImprestAccountsId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(PartialView("~/Areas/Finance/Views/FncImprestAccount/CreateEdit.cshtml", brhImprestAccounts)); }
public async Task <IActionResult> Create([Bind("ImprestAccountsId,ImprestAccountsName,Balance,Equity,Manager,Department,Branch,Purpose")] BrhImprestAccounts brhImprestAccounts) { if (ModelState.IsValid) { brhImprestAccounts.Equity = brhImprestAccounts.Balance; _context.Add(brhImprestAccounts); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(PartialView("~/Areas/Finance/Views/FncImprestAccount/CreateEdit.cshtml", brhImprestAccounts)); }
public async Task <ActionResult> Index() { AppIdentityUser _user = await _userManager.FindByNameAsync(User.Identity.Name); ViewData["BranchId"] = _user.BranchId; BrhImprestAccounts bias = _context.BrhImprestAccounts.SingleOrDefault(x => x.Branch == _user.Branch && x.Purpose == PurposeType.线上推广); if (bias != null) { ViewData["ImprestAccountsId"] = bias.ImprestAccountsId; } else { ViewData["ImprestAccountsId"] = 0000; } var list_channelType = _context.FncChannelType.ToList(); ViewData["ChannelType"] = new SelectList(list_channelType, "ChannelType", "ChannelType"); return(View(_user)); }