public string GetAllProducts() { List <movy> pro = new List <movy>(); using (movieoutletEntities contex = new movieoutletEntities()) { var productList = from m in contex.movies select m; movy pros = new movy(); pro = productList.ToList(); JavaScriptSerializer json = new JavaScriptSerializer(); return(json.Serialize(pro)); } }
public string Delete(int id) { movy itm = new movy(); using (movieoutletEntities contex = new movieoutletEntities()) { JavaScriptSerializer json = new JavaScriptSerializer(); var productList = from m in contex.movies where m.Id == id select m; itm = productList.First(); contex.movies.Remove(itm); contex.SaveChanges(); return(json.Serialize("Successful")); } }
public string Post(movy pro) { JavaScriptSerializer json = new JavaScriptSerializer(); movy itm = new movy(); itm.Id = pro.Id; itm.Name = pro.Name; itm.Category = pro.Category; itm.Price = pro.Price; itm.Description = pro.Description; using (movieoutletEntities contex = new movieoutletEntities()) { contex.movies.Add(itm); contex.SaveChanges(); return(json.Serialize("Successful")); } }
public IHttpActionResult GetCat(string category) { List <movy> pro = new List <movy>(); using (movieoutletEntities contex = new movieoutletEntities()) { var productList = from m in contex.movies where m.Category == category select m; movy pros = new movy(); pro = productList.ToList(); JavaScriptSerializer json = new JavaScriptSerializer(); if (pro == null) { return(NotFound()); } return(Ok(json.Serialize(pro))); } }
public IHttpActionResult GetProduct(int id) { List <movy> pro = new List <movy>(); using (movieoutletEntities contex = new movieoutletEntities()) { var movieList = from m in contex.movies select m; movy pros = new movy(); pro = movieList.ToList(); JavaScriptSerializer json = new JavaScriptSerializer(); var product = pro.FirstOrDefault((p) => p.Id == id); if (product == null) { return(NotFound()); } return(Ok(json.Serialize(product))); } }
public string Update(int id, movy pro) { movy itm = new movy(); using (movieoutletEntities contex = new movieoutletEntities()) { JavaScriptSerializer json = new JavaScriptSerializer(); var productList = from m in contex.movies where m.Id == id select m; itm = productList.First(); contex.movies.Remove(itm); contex.SaveChanges(); itm.Id = pro.Id; itm.Name = pro.Name; itm.Category = pro.Category; itm.Price = pro.Price; itm.Description = pro.Description; contex.movies.Add(itm); contex.SaveChanges(); return(json.Serialize("Successful")); } }