public ActionResult CreateOrUpdate(ProductViewModel viewModel)
{
if (ModelState.IsValid)
{
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("en-GB");
Product product;
using (var Model = new RWModel())
{
product = Model.Product.Find(viewModel.Id) ?? new Product();
product.Id = viewModel.Id;
product.Code = viewModel.Code;
product.Model = viewModel.Model;
product.Name = viewModel.Product;
product.Price = viewModel.Price;
product.Size = viewModel.Size;
product.Colour = viewModel.Colour;
product.Description = viewModel.Description;
var category = viewModel.SubcategoryId != 0 ? Model.Category.Find(viewModel.SubcategoryId) : viewModel.CategoryId != 0 ? Model.Category.Find(viewModel.CategoryId) : null;
product.Category = category;
if (product.Id == 0)
{
Model.Product.Add(product);
}
Model.SaveChanges();
}
return(Redirect("/Product/Index"));
}
return(Redirect("/Product/CreateOrUpdate/" + viewModel.Id));
}
public JsonResult DeleteProduct(long Id)
{
using (var Model = new RWModel())
{
var product = Model.Product.Find(Id);
Model.Product.Remove(product);
Model.SaveChanges();
return(Json(new { ok = true }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Upload(HttpPostedFileBase upload)
{
using (var Model = new RWModel())
{
if (ModelState.IsValid)
{
if (upload != null && upload.ContentLength > 0)
{
// ExcelDataReader works with the binary Excel file, so it needs a FileStream
// to get started. This is how we avoid dependencies on ACE or Interop:
Stream stream = upload.InputStream;
// We return the interface, so that
IExcelDataReader reader = null;
if (upload.FileName.EndsWith(".xls"))
{
reader = ExcelReaderFactory.CreateBinaryReader(stream);
}
else if (upload.FileName.EndsWith(".xlsx"))
{
reader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
else
{
ModelState.AddModelError("File", "This file format is not supported");
return(View());
}
reader.IsFirstRowAsColumnNames = true;
DataSet result = reader.AsDataSet();
reader.Close();
foreach (DataRow row in result.Tables[0].Rows)
{
var categoryName = row[(int)ProductImportEnum.Category].ToString();
var category = Model.Category.FirstOrDefault(x => x.Name == categoryName) ?? new Category()
{
Name = categoryName
};
if (category.Id == 0)
{
Model.Category.Add(category);
Model.SaveChanges();
}
var subcategoryName = row[(int)ProductImportEnum.Subcategory].ToString();
var subcategory = Model.Category.FirstOrDefault(x => x.Name == subcategoryName) ?? new Category()
{
Name = subcategoryName, Parent = category
};
if (subcategory.Id == 0)
{
Model.Category.Add(subcategory);
Model.SaveChanges();
}
var productCode = row[(int)ProductImportEnum.Code].ToString();
var product = Model.Product.FirstOrDefault(x => x.Code == productCode) ?? new Product();
product.Name = row[(int)ProductImportEnum.Name].ToString();
product.Description = row[(int)ProductImportEnum.Description].ToString();
product.Code = productCode;
product.Colour = row[(int)ProductImportEnum.Colour].ToString();
product.Model = row[(int)ProductImportEnum.Model].ToString();
product.Price = Convert.ToDecimal(row[(int)ProductImportEnum.Price].ToString());
product.Size = row[(int)ProductImportEnum.Size].ToString();
product.Category = subcategory;
if (product.Id == 0)
{
Model.Product.Add(product);
Model.SaveChanges();
}
}
return(View(result.Tables[0]));
}
else
{
ModelState.AddModelError("File", "Please Upload Your file");
}
}
}
return(View());
}