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));
}
