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));
}
