//POST: delete from database logic public ActionResult Delete(string costid) { var userobject = Session["id"]; if (userobject == null) { return(RedirectToAction("Index", "Login")); } else { costid = Request.QueryString["costid"]; int ids = Convert.ToInt32(costid); using (db) { mg_shoplist costdt = db.mg_shoplist.Where(x => x.ID == ids).FirstOrDefault <mg_shoplist>(); try { db.mg_shoplist.Remove(costdt); 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(mg_shoplist2 costDt) { var userobject = Session["id"]; if (userobject == null) { return(RedirectToAction("Index", "Login")); } else { //var dates = Convert.ToDateTime(costDt.TRANS_DATE_STR).ToString("MM/dd/yyyy"); costDt.TRANS_DATE = Convert.ToDateTime(costDt.TRANS_DATE_STR); var editmode = Request.QueryString["editmode"]; var username = User.Identity.Name; var dtname = username; mg_shoplist form = new mg_shoplist(); form.AMOUNT = costDt.AMOUNT; form.TRANS_DATE = costDt.TRANS_DATE; form.NOTES = costDt.NOTES; form.ENTRY_DATE = DateTime.Now; form.ENTRY_USER = userobject.ToString(); form.UPDATE_DATE = DateTime.Now; form.UPDATE_USER = userobject.ToString(); using (db) { try { db.mg_shoplist.Add(form); 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)); } } } }