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()); } AssemblyRecipe = await _context.AssemblyRecipes .Include(a => a.Item).FirstOrDefaultAsync(m => m.AssemblyRecipeId == RecipeId); var lines = from i in _context.RecipeLines where i.AssemblyRecipeId == RecipeId select i; RecipeLines = await lines.ToListAsync(); IList <RecipeLine> recipeLines = lines.ToList(); //I need to make sure Im also passing the item that is trying to be added to the //assembly into notCircular recipeLines.Insert(0, RecipeLine); //need to make sure its not adding itself if (notCircular(recipeLines))//.ItemId != RecipeLine.ItemId) { //need to increase count when adding items that are //already a part of the assembly recipe //instead of adding a new line foreach (var line in RecipeLines) { if (RecipeLine.ItemId == line.ItemId) { line.RequiredItemQty += RecipeLine.RequiredItemQty; _context.RecipeLines.Update(line); await _context.SaveChangesAsync(); return(RedirectToPage("/AssemblyRecipes/Details", new { id = RecipeId })); } } RecipeLine.AssemblyRecipeId = RecipeId; RecipeLine.LastModifiedBy = "AlphaTech";//set to logged in user RecipeLine.LastModifiedDate = DateTime.Today; Item = await _context.Items.FirstOrDefaultAsync(m => m.ItemId == RecipeLine.ItemId); RecipeLine.Item = Item; _context.RecipeLines.Add(RecipeLine); await _context.SaveChangesAsync(); return(RedirectToPage("/AssemblyRecipes/Details", new { id = RecipeLine.AssemblyRecipeId })); } return(RedirectToPage("/AssemblyRecipes/Details", new { id = RecipeId })); }
public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } OrderItem.LastModifiedDate = DateTime.Today; OrderItem.LastModifiedBy = "AlphaTech Team"; _context.OrderItems.Add(OrderItem); await _context.SaveChangesAsync(); return(RedirectToPage("./Index")); }
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() { if (!ModelState.IsValid) { return(Page()); } Item = await _context.Items.FirstOrDefaultAsync(m => m.ItemId == AssemblyRecipe.ItemId); Item.IsAssembled = true; //Item.LastModifiedBy = "AlphaTech"; //change to user Item.LastModifiedBy = User.Identity.Name; Item.LastModifiedDate = DateTime.Today; _context.AssemblyRecipes.Add(AssemblyRecipe); await _context.SaveChangesAsync(); Item.AssemblyRecipeId = AssemblyRecipe.AssemblyRecipeId;//this isnt set until after the context is saved await _context.SaveChangesAsync(); return(RedirectToPage("./Details", new { id = Item.AssemblyRecipeId })); }
public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } _context.Assemblies.Add(Assembly); await _context.SaveChangesAsync(); return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Item = await _context.Items.FindAsync(id); //get all recipe lines that contain this item var lines = from i in _context.RecipeLines where i.ItemId == Item.ItemId select i; RecipeLines = await lines.ToListAsync(); if (Item != null) { //if its an assemble item then delete its recipe first if (Item.IsAssembled) { AssemblyRecipe = await _context.AssemblyRecipes.FindAsync(Item.AssemblyRecipeId); _context.AssemblyRecipes.Remove(AssemblyRecipe); await _context.SaveChangesAsync(); } //delete all recipe lines that contained this item foreach (var line in RecipeLines) { _context.RecipeLines.Remove(line); await _context.SaveChangesAsync(); } //delete the item _context.Items.Remove(Item); await _context.SaveChangesAsync(); } return(RedirectToPage("/Inventory")); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } OrderItem = await _context.OrderItems.FindAsync(id); if (OrderItem != null) { _context.OrderItems.Remove(OrderItem); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Assembly = await _context.Assemblies.FindAsync(id); if (Assembly != null) { _context.Assemblies.Remove(Assembly); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } RecipeLine = await _context.RecipeLines.FindAsync(id); if (RecipeLine != null) { _context.RecipeLines.Remove(RecipeLine); await _context.SaveChangesAsync(); } return(RedirectToPage("/AssemblyRecipes/Details", new { id = RecipeLine.AssemblyRecipeId })); }
public async Task<IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return Page(); } //stop from adding the same item twice Item temp = _context.Items.FirstOrDefault(i => i.ItemName == Item.ItemName); if (temp != null) { return Page(); } //Item.LastModifiedBy = "AlphaTech";//TODO: change this to the logged in user Item.LastModifiedBy = User.Identity.Name; Item.LastModifiedDate = DateTime.Today; _context.Items.Add(Item); await _context.SaveChangesAsync(); return RedirectToPage("/Inventory"); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } AssemblyRecipe = await _context.AssemblyRecipes.FindAsync(id); Item = await _context.Items.FirstOrDefaultAsync(m => m.ItemId == AssemblyRecipe.ItemId); if (AssemblyRecipe != null) { Item.AssemblyRecipeId = null; Item.IsAssembled = false; Item.LastModifiedBy = "AlphaTech"; //change to user Item.LastModifiedDate = DateTime.Today; _context.AssemblyRecipes.Remove(AssemblyRecipe); await _context.SaveChangesAsync(); } return(RedirectToPage("/Items/Details", new { id = Item.ItemId })); }
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")); }