public ActionResult VendorUpdate([DataSourceRequest] DataSourceRequest request, Vendor vendor) { if (ModelState.IsValid) { var entity = db.Vendor.Find(vendor.vendorID); if (entity != null) { entity.vendorID = vendor.vendorID; entity.vendorName = vendor.vendorName; try { db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); return(Json(new[] { vendor }.ToDataSourceResult(request, ModelState))); } catch (Exception e) { Console.WriteLine(e); throw; } } } return(Json(new[] { vendor }.ToDataSourceResult(request, ModelState))); }
public ActionResult Products_Update([DataSourceRequest] DataSourceRequest request, Product product) { if (ModelState.IsValid) { var category = db.Categories.Find(product.categoryID); var entity = db.Products.Find(product.productID); if (entity != null) { entity.productID = product.productID; entity.productDescription = product.productDescription; entity.EAN = product.EAN; entity.Category = category; entity.vendorID = product.vendorID; entity.adminToPublic = product.adminToPublic; try { db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); return(Json(new[] { product }.ToDataSourceResult(request, ModelState))); } catch (Exception e) { Console.WriteLine(e); throw; } } } return(Json(new[] { product }.ToDataSourceResult(request, ModelState))); }
public ActionResult CategoryUpdate([DataSourceRequest] DataSourceRequest request, Category category) { if (ModelState.IsValid) { var entity = db.Categories.Find(category.categoryID); if (entity != null) { entity.categoryID = category.categoryID; entity.categoryName = category.categoryName; try { db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); return(Json(new[] { category }.ToDataSourceResult(request, ModelState))); } catch (Exception e) { Console.WriteLine(e); throw; } } } return(Json(new[] { category }.ToDataSourceResult(request, ModelState))); }
public ActionResult VendorFileUpdate([DataSourceRequest] DataSourceRequest request, UserFileViewModel userFile) { if (ModelState.IsValid) { var sheetType = db.SheetTypes.Find(userFile.sheetTypeID); var sheetTypes = db.SheetTypes.ToList(); var entity = db.UserFiles.Find(userFile.Id); if (entity != null) { if (entity.oldFile == false && db.Products.Find(entity.productID).Equals(userFile.productID)) { entity.oldFile = true; } else { entity.fileID = userFile.Id; entity.fileName = userFile.Name; entity.productID = userFile.productID; entity.vendorID = userFile.vendorID; entity.SheetType = sheetType; entity.adminApproved = userFile.adminApproved; } try { // var existingProduct = db.Products.Find(product.productID); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); return(Json(new[] { userFile }.ToDataSourceResult(request, ModelState))); } catch (Exception e) { Console.WriteLine(e); throw; } } } return(Json(new[] { userFile }.ToDataSourceResult(request, ModelState))); }
public ActionResult Products_Create_Update([DataSourceRequest] DataSourceRequest request, ProductViewModel product) { if (ModelState.IsValid) { var category = db.Categories.Find(product.categoryID); var sheetTypes = db.SheetTypes.ToList(); if (product.productID != 0) { var entity = db.Products.Find(product.productID); if (entity != null) { entity.EAN = product.EAN; entity.productDescription = product.productDescription; entity.Category = category; entity.vendorID = product.vendorID; entity.countryID = product.CountryID; // entity.articleID = product.articleId; entity.adminToPublic = false; try { // var existingProduct = db.Products.Find(product.productID); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); return(Json(new[] { product }.ToDataSourceResult(request, ModelState))); } catch (Exception e) { Console.WriteLine(e); throw; } } } var newProduct = new Product { EAN = product.EAN, productDescription = product.productDescription, Category = category, SheetType = sheetTypes, vendorID = product.vendorID, countryID = product.CountryID, // articleID = product.articleId, adminToPublic = false }; try { db.Products.Add(newProduct); db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); throw; } } return(Json(new[] { product }.ToDataSourceResult(request, ModelState))); }