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