public async Task <IActionResult> OnPostAssembleAsync(int id) { var lines = from i in _context.RecipeLines where i.AssemblyRecipeId == id select i; RecipeLines = await lines.ToListAsync(); foreach (var line in RecipeLines) { Item = await _context.Items.FirstOrDefaultAsync(m => m.ItemId == line.ItemId); Item.OnHandQty -= line.RequiredItemQty; Item.LastModifiedBy = "AlphaTech"; // change to user Item.LastModifiedDate = DateTime.Today; _context.Attach(Item).State = EntityState.Modified; await _context.SaveChangesAsync(); } Item = await _context.Items.FirstOrDefaultAsync(m => m.ItemId == itemId); Item.OnHandQty++; Item.LastModifiedBy = "AlphaTech"; // change to user Item.LastModifiedDate = DateTime.Today; _context.Attach(Item).State = EntityState.Modified; await _context.SaveChangesAsync(); return(RedirectToPage()); // return RedirectToPage("AssemblyRecipes/Details", new { id }); }
public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } Item.LastModifiedBy = User.Identity.Name; //change to user Item.LastModifiedDate = DateTime.Today; _context.Attach(Item).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ItemExists(Item.ItemId)) { return(NotFound()); } else { throw; } } return(RedirectToPage("/Inventory")); }
public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } _context.Attach(OrderItem).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OrderItemExists(OrderItem.OrderItemId)) { return(NotFound()); } else { throw; } } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } RecipeLine.LastModifiedBy = "AlphTech"; //change to user RecipeLine.LastModifiedDate = DateTime.Today; _context.Attach(RecipeLine).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RecipeLineExists(RecipeLine.RecipeLineId)) { return(NotFound()); } else { throw; } } return(RedirectToPage("/AssemblyRecipes/Details", new { id = RecipeLine.AssemblyRecipeId })); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Vendor = await _context.Vendors.FindAsync(id); Items = await _context.Items.ToListAsync(); Vendors = await _context.Vendors.ToListAsync(); //if user is trying to delete the last vendor just make it again if (Vendor.VendorName == "Vendor Deleted") { return(RedirectToPage("./Index")); } if (Vendors.Count <= 1) { Vendor defaultVendor = new Vendor(); defaultVendor.VendorName = "No Preferred Vendor"; defaultVendor.LastModifiedBy = "Please don't delete this"; defaultVendor.LastModifiedDate = DateTime.Today; Vendors.Insert(0, defaultVendor); _context.Attach(Vendors).State = EntityState.Modified; //await _context.SaveChangesAsync(); } foreach (var item in Items) { if (item.VendorId == Vendor.VendorId) { Vendor vendor = _context.Vendors.FirstOrDefault(v => v.VendorName == "Vendor Deleted"); if (vendor == null) { vendor = new Vendor(); vendor.VendorName = "Vendor Deleted"; vendor.LastModifiedBy = "AphlaTech db protection";//maybe change to user name vendor.LastModifiedDate = DateTime.Today; _context.Vendors.Add(vendor); await _context.SaveChangesAsync(); } item.PreferredVendor = vendor; item.VendorId = vendor.VendorId; item.LastModifiedBy = "db change"; //change to user item.LastModifiedDate = DateTime.Today; _context.Attach(item).State = EntityState.Modified; } } if (Vendor != null) { _context.Vendors.Remove(Vendor); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }