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