public IHttpActionResult GetALLdetails() { using (DatabasemodelEntities dc = new DatabasemodelEntities()) { var Poducut = dc.Products.OrderBy(a => a.productname).ToList(); // return Json(new { data = Product }, JsonRequestBehavior.AllowGet); return(Ok(Poducut)); } }
public IHttpActionResult Delete(int prodid) { using (DatabasemodelEntities dc = new DatabasemodelEntities()) { bool status = false; var v = dc.Products.Where(a => a.prodid == prodid).FirstOrDefault(); if (v != null) { dc.Products.Remove(v); dc.SaveChanges(); status = true; } } return(Ok("Ok")); }
//[HttpPost] add and update records public IHttpActionResult Save(Product Prod) { bool status = false; if (ModelState.IsValid) { using (DatabasemodelEntities dc = new DatabasemodelEntities()) { if (Prod.prodid > 0) { var v = dc.Products.Where(a => a.productname == Prod.productname).FirstOrDefault(); if (v != null) { v.productname = Prod.productname; v.proditeam = Prod.proditeam; v.Prodprice = Prod.Prodprice; } else { dc.Products.Add(Prod); dc.SaveChanges(); status = true; } } else { var errors = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();// return(Ok("error")); } } } return(Ok("ok")); }