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