//POST: delete from database logic public ActionResult Delete(string prodid) { var userobject = Session["id"]; if (userobject == null) { return(RedirectToAction("Index", "Login")); } else { prodid = Request.QueryString["prodid"]; int ids = Convert.ToInt32(prodid); using (db) { mt_prod prodDt = db.mt_prod.Where(x => x.PROD_ID == ids).FirstOrDefault <mt_prod>(); try { db.mt_prod.Remove(prodDt); db.SaveChanges(); return(Json(new { success = true, message = "Deleted successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { success = false, message = e.InnerException.Message }, JsonRequestBehavior.AllowGet)); } } } }
//POST: Insert to database logic public ActionResult Insert(prodClass prodDt) { var userobject = Session["id"]; if (userobject == null) { return(RedirectToAction("Index", "Login")); } else { mt_prod dt = new mt_prod(); var editmode = Request.QueryString["editmode"]; var username = User.Identity.Name; prodDt.ENTRY_DATE = DateTime.Now; prodDt.ENTRY_USER = userobject.ToString(); prodDt.UPDATE_DATE = DateTime.Now; prodDt.UPDATE_USER = userobject.ToString(); var dtname = username; using (db) { try { dt.PROD_NAME = prodDt.PROD_NAME; dt.prod_cat_id = prodDt.prod_cat_id; dt.DESCRIPTION = prodDt.DESCRIPTION; if (prodDt.DESCRIPTION == null) { dt.DESCRIPTION = ""; } dt.PRICE = prodDt.PRICE; dt.ENTRY_DATE = prodDt.ENTRY_DATE; dt.ENTRY_USER = prodDt.ENTRY_USER; dt.UPDATE_DATE = prodDt.UPDATE_DATE; dt.UPDATE_USER = prodDt.UPDATE_USER; db.mt_prod.Add(dt); db.SaveChanges(); return(Json(new { success = true, message = "Saved successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { success = false, message = e.InnerException.Message }, JsonRequestBehavior.AllowGet)); } } } }