public async Task <IActionResult> Main(string itemid, int?id)
{
MyUser user = _context.MyUser.Where(p => p.Email == HttpContext.User.Identity.Name).ToList().FirstOrDefault();
int userID = user.UserId;
AdjustmentVoucher AV;
if (id == 0)
{
AV = new AdjustmentVoucher
{
UserId = userID,
Status = "Pending"
};
_context.Add(AV);
await _context.SaveChangesAsync();
id = AV.AdjustId;
}
else
{
AV = _context.AdjustmentVoucher.Find(id);
}
AVDetails checkAVD = _context.Avdetails.Where(d => d.AdjustId == AV.AdjustId & d.ItemId == itemid).SingleOrDefault();
AVDetails avd;
if (checkAVD == null)
{
avd = new AVDetails();
avd.AdjustId = AV.AdjustId;
avd.ItemId = itemid;
_context.Add(avd);
await _context.SaveChangesAsync();
}
return(Redirect("~/AVDetails/ViewAv/" + id));
}
public async Task <IActionResult> DeleteItem(int?detailsId)
{
if (detailsId == null)
{
return(RedirectToAction(nameof(ViewAV)));
}
AVDetails avDetail = await _context.Avdetails.SingleOrDefaultAsync(i => i.AVDid == detailsId);
int avid = avDetail.AdjustId;
_context.Avdetails.Remove(avDetail);
await _context.SaveChangesAsync();
var newlist = from m in _context.Avdetails.Where(m => m.AdjustId == avid) select m;
List <Models.AVDetails> avdlist = await newlist.ToListAsync();
return(Redirect("~/AVDetails/ViewAv/" + avid));
}
public async Task <IActionResult> ViewAV(List <AVDetails> avDetails)
{
MyUser user = _context.MyUser.Where(p => p.Email == HttpContext.User.Identity.Name).ToList().FirstOrDefault();
int userID = user.UserId;
int avdCount = avDetails.Count();
for (int i = 0; i < avdCount; i++)
{
AVDetails existing = _context.Avdetails.Find(avDetails[i].AVDid);
existing.Qtychanged = avDetails[i].Qtychanged;
existing.Operations = avDetails[i].Operations;
existing.Remarks = avDetails[i].Remarks;
_context.Update(existing);
await _context.SaveChangesAsync();
}
return(RedirectToAction("Index", "Adjustmentvouchers"));
}
public async Task <IActionResult> DeleteItem(int?VoucherId)
{
if (VoucherId == null)
{
return(RedirectToAction(nameof(Index)));
}
AdjustmentVoucher voucher = await _context.AdjustmentVoucher.SingleOrDefaultAsync(i => i.AdjustId == VoucherId);
List <AVDetails> voucherDetailsList = _context.Avdetails.Where(x => x.AdjustId == VoucherId).ToList();
foreach (AVDetails item in voucherDetailsList)
{
AVDetails current = _context.Avdetails.Find(item.AVDid);
_context.Avdetails.Remove(current);
await _context.SaveChangesAsync();
}
_context.AdjustmentVoucher.Remove(voucher);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
