public JsonResult DeleteEmp(int id) { saletran emp = dc.saletrans.Find(id); dc.saletrans.Remove(emp); dc.SaveChanges(); return(Json(emp, JsonRequestBehavior.AllowGet)); }
public JsonResult GetbyID(int ID) { saletran model = dc.saletrans.Where(x => x.stid == ID).SingleOrDefault(); string value = string.Empty; value = JsonConvert.SerializeObject(model, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(value, JsonRequestBehavior.AllowGet)); }
public string InsertEmp(saletran emp) { dc.Configuration.ProxyCreationEnabled = false; ViewData["drp"] = dc.custs.ToList(); ViewData["drp2"] = dc.products.ToList(); dc.saletrans.Add(emp); dc.SaveChanges(); return("Product added successfully..."); }
public JsonResult Update(ProductVM emp) { dc.Configuration.ProxyCreationEnabled = false; saletran p = dc.saletrans.Where(x => x.stid == emp.stid).FirstOrDefault(); p.rate = emp.rate; p.qty = emp.qty; p.total = emp.total; p.pid = emp.pid; p.cid = emp.cid; dc.SaveChanges(); return(Json(p, JsonRequestBehavior.AllowGet)); }