public ActionResult Upload(HttpPostedFileBase jsonFile)
{
using (Test_Baza_Context db = new Test_Baza_Context())
{
if (!jsonFile.FileName.EndsWith(".json"))
{
ViewBag.Error = "Invalid file type(Only JSON file allowed)";
}
else
{
jsonFile.SaveAs(Server.MapPath("~/Import_Json/" + Path.GetFileName(jsonFile.FileName)));
StreamReader streamReader = new StreamReader(Server.MapPath("~/Export_Json/" + Path.GetFileName(jsonFile.FileName)));
string data = streamReader.ReadToEnd();
List <Product> products = JsonConvert.DeserializeObject <List <Product> >(data);
products.ForEach(p =>
{
Product product = new Product()
{
Naziv = p.Naziv,
Opis = p.Opis,
Kategorija = p.Kategorija,
Proizvodjac = p.Proizvodjac,
Dobavljac = p.Dobavljac,
Cena = p.Cena
};
db.Products.Add(product);
db.SaveChanges();
});
ViewBag.Success = "File uploaded Successfully..";
}
}
return(RedirectToAction("Index", "Proizvod"));
}
public ActionResult GetData()
{
using (Test_Baza_Context db = new Test_Baza_Context())
{
List <Product> productList = db.Products.ToList();
return(Json(new { data = productList }, JsonRequestBehavior.AllowGet));
}
}
