// [ValidateAntiForgeryToken]
public IActionResult Create([FromBody()] SarhaVM sVM)
{
if (ModelState.IsValid)
{
Sarha s = new Sarha()
{
BoatID = sVM.BoatID,
NumberOfFishermen = sVM.NoFisherMen,
NumberOfBoxes = sVM.NoBoxes,
DateOfSarha = TimeNow()
};
_context.Sarhas.Add(s);
_context.SaveChanges();
var latestSarha = _context.Sarhas.Max(x => x.SarhaID);
var pricesCookie = Request.Cookies["MyItems"];
if (pricesCookie != null)
{
decimal[] result = pricesCookie.Split(",".ToCharArray()).Select(c => Convert.ToDecimal(c)).ToArray();
for (int i = 0; i < _context.Debts.ToList().Count(); i++)
{
if (result[i] != 0)
{
Debts_Sarha d_s = new Debts_Sarha()
{
SarhaID = s.SarhaID,
DebtID = _context.Debts.ToList().ElementAt(i).DebtID,
Price = result[i],
PersonID = 1,
Date = TimeNow()
};
_context.Debts_Sarhas.Add(d_s);
Person pp = _context.People.Find(1);
pp.credit -= result[i];
_context.SaveChanges();
}
}
var boat = _context.Boats.Find(sVM.BoatID);
boat.DebtsOfHalek += result.Sum();
_context.SaveChanges();
Response.Cookies.Delete("MyItems");
}
return(Json(new { message = "success", id = sVM.BoatID }));
}
ViewBag.Boats = new SelectList(_context.Boats, "BoatID", "BoatName", sVM.BoatID);
SarhaViewModel sarhaViewModel = new SarhaViewModel();
sarhaViewModel.Sarha = new Sarha()
{
BoatID = sVM.BoatID,
NumberOfFishermen = sVM.NoFisherMen,
NumberOfBoxes = sVM.NoBoxes,
DateOfSarha = sVM.DateOfSarha
};
return(View(sarhaViewModel));
}
public async Task <IActionResult> Edit(int id, SarhaViewModel sarhaViewModel)
{
if (id != sarhaViewModel.Sarha.SarhaID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(sarhaViewModel.Sarha);
var deptPriceCookie = Request.Cookies["MyItems"];
decimal[] result = deptPriceCookie.Split(",".ToCharArray()).Select(c => Convert.ToDecimal(c)).ToArray();
var dept_sarha = _context.Debts_Sarhas.Where(x => x.SarhaID == id);
int i = 0;
foreach (var item in dept_sarha)
{
var oldPrice = item.Price;
Person p = _context.People.Find(item.PersonID);
item.Price = result[i];
if (oldPrice > result[i])
{
p.credit += oldPrice - result[i];
}
else
{
p.credit -= result[i] - oldPrice;
}
i++;
}
Response.Cookies.Delete("MyItems");
var boat = _context.Boats.Find(sarhaViewModel.Sarha.BoatID);
boat.DebtsOfHalek += result.Sum();
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SarhaExists(sarhaViewModel.Sarha.SarhaID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["BoatID"] = new SelectList(_context.Boats, "BoatID", "BoatLeader", sarhaViewModel.Sarha.BoatID);
return(View(sarhaViewModel));
}
// GET: Sarhas/Create
public IActionResult Create()
{
ViewBag.Boats = new SelectList(_context.Boats.Where(c => c.IsActive == true), "BoatID", "BoatName");
//ViewBag.People = new SelectList(_context.People.OrderByDescending(x => x.PersonID).Take(2).ToList(), "PersonID", "Name");
ViewBag.People = new SelectList(_context.People.ToList(), "PersonID", "Name");
//ViewBag.halek = _context.Debts.ToList();
SarhaViewModel sarhaViewModel = new SarhaViewModel();
sarhaViewModel.Debts = _context.Debts.ToList();
return(View(sarhaViewModel));
}
// GET: Sarhas/Edit/5
public async Task <IActionResult> Edit(int?id)
{
var user = await _userManager.GetUserAsync(User);
var roles = await _userManager.GetRolesAsync(user);
int PID = 1;
if (roles.Contains("partner"))
{
PID = 2;
}
if (id == null)
{
return(NotFound());
}
var sarha = _context.Sarhas.Find(id);
var dept_sarha = _context.Debts_Sarhas.Where(x => x.SarhaID == id && x.PersonID == PID).Include(x => x.Debt).Include(x => x.Person);
var ds = dept_sarha.Select(c => c.DebtID);
// ViewBag.OtherDebts = _context.Debts.Where(d => !ds.Contains(d.DebtID)).ToList();
if (sarha == null)
{
return(NotFound());
}
SarhaViewModel sarhaViewModel = new SarhaViewModel()
{
Sarha = sarha,
Debts_Sarhas = dept_sarha,
OtherDebts = _context.Debts.Where(d => !ds.Contains(d.DebtID)).ToList(),
Debts = _context.Debts.ToList()
};
ViewBag.Boats = new SelectList(_context.Boats, "BoatID", "BoatName", sarha.BoatID);
var boat = _context.Boats.Find(sarha.BoatID);
var Halek = _context.Debts_Sarhas.Where(x => x.SarhaID == id).Sum(x => x.Price);
boat.DebtsOfHalek -= Halek;
_context.SaveChanges();
return(View(sarhaViewModel));
}
