public async Task <IActionResult> UpdateExistingProduct(CreateNewProductViewModel vm) { var ProductToUpdate = ctx.Products.Where(x => x.ArticleNumber == vm.ArticleNumber).FirstOrDefault(); try { ProductToUpdate.Name = vm.Name; ProductToUpdate.ArticleNumber = vm.ArticleNumber; ProductToUpdate.DateUpdated = DateTime.Now; ProductToUpdate.Price = vm.Price; ProductToUpdate.EAN = vm.EAN; ProductToUpdate.Manufacturer = vm.Manufacturer; ProductToUpdate.ManufacturerSku = vm.ManufacturerSku; ProductToUpdate.Supplier = vm.Manufacturer; ProductToUpdate.Description = vm.Description; ProductToUpdate.CostPerItem = vm.CostPerItem; ProductToUpdate.StockBalance = vm.StockBalance; ProductToUpdate.ProductType = vm.ProductType; ctx.Products.Update(ProductToUpdate).State = EntityState.Modified; await ctx.SaveChangesAsync(); } catch (Exception e) { throw e; } return(Ok()); }
public ActionResult SaveProduct(CreateNewProductViewModel saveDto) { try { using (var dbContext = new TicketCodeTestDBContext()) { var efProduct = new Tproduct(); efProduct.Id = UniqueGenerator.UniId(); efProduct.Name = saveDto.productname; efProduct.Title = saveDto.title; efProduct.Class1 = saveDto.class1; efProduct.Class2 = saveDto.class2; efProduct.DeliveryArea = saveDto.deliveryarea; efProduct.SupplierId = saveDto.supplier; efProduct.Cost = saveDto.cost; efProduct.SalePrice = saveDto.saleprice; efProduct.AvailableStock = saveDto.avaliablestock; efProduct.Description = saveDto.description; dbContext.Tproduct.Add(efProduct); dbContext.SaveChanges(); } return(Json(new { success = true })); } catch (Exception ex) { return(Json(new { success = false, msg = ex.ToString() })); } }
public async Task <IActionResult> DeleteProduct(CreateNewProductViewModel vm) { var ProductToDelete = ctx.Products.Where(x => x.ArticleNumber == vm.ArticleNumber).FirstOrDefault(); try { ctx.Products.Remove(ProductToDelete); await ctx.SaveChangesAsync(); } catch (Exception e) { throw e; } return(Ok()); }
/// <summary> /// 新增编辑界面 /// </summary> /// <returns></returns> public ActionResult CreateNewPage(string productid) { var dmProduct = new CreateNewProductViewModel(); if (productid != null) { using (var dbContext = new TicketCodeTestDBContext()) { var efProduct = dbContext.Tproduct.Find(productid.ToString()); dmProduct.productname = efProduct.Name; dmProduct.class1 = efProduct.Class1; dmProduct.class2 = efProduct.Class2; } } return(View(dmProduct)); }
public async Task <IActionResult> CreateNewProduct(CreateNewProductViewModel vm) { var existingProductSku = ctx.Products.Where(x => x.ArticleNumber == vm.ArticleNumber).FirstOrDefault(); if (existingProductSku != null) { var ErrorMessage = "Det finns redan en produkt med detta artikelnumret, välj ett annat artikelnumer."; return(Ok(ErrorMessage)); } else { try { var NewProduct = new Product(); NewProduct.Name = vm.Name; NewProduct.ArticleNumber = vm.ArticleNumber; NewProduct.DateUpdated = DateTime.Now; NewProduct.DateCreated = DateTime.Now; NewProduct.Price = vm.Price; NewProduct.EAN = vm.EAN; NewProduct.Manufacturer = vm.Manufacturer; NewProduct.ManufacturerSku = vm.ManufacturerSku; NewProduct.Supplier = vm.Manufacturer; NewProduct.Description = vm.Description; NewProduct.CostPerItem = vm.CostPerItem; NewProduct.StockBalance = vm.StockBalance; NewProduct.ProductType = vm.ProductType; ctx.Products.Add(NewProduct); await ctx.SaveChangesAsync(); } catch (Exception e) { throw e; } return(Ok()); } }