public ActionResult Upload(HttpPostedFileBase jsonFile)
{
using (WirelessMediaDBModel db = new WirelessMediaDBModel())
{
if (!jsonFile.FileName.EndsWith(".json"))
{
ViewBag.Error = "Invalid file type";
}
else
{
jsonFile.SaveAs(Server.MapPath("~/JSON/" + Path.GetFileName(jsonFile.FileName)));
StreamReader streamReader = new StreamReader(Server.MapPath("~/JSON/" + Path.GetFileName(jsonFile.FileName)));
string data = streamReader.ReadToEnd();
List <Product> products = JsonConvert.DeserializeObject <List <Product> >(data);
products.ForEach(p => {
Product product = new Product()
{
Name = p.Name,
Description = p.Description,
Category = p.Category,
Manufacturer = p.Manufacturer,
Supplier = p.Supplier,
Price = p.Price,
};
db.Products.Add(product);
db.SaveChanges();
});
ViewBag.Success = "Success";
}
}
return(View("Index"));
}
public ActionResult Index()
{
List <Product> ProductList = new List <Product>();
using (WirelessMediaDBModel db = new WirelessMediaDBModel())
{
ProductList = db.Products.ToList();
}
return(View(ProductList));
}
