//POST: delete from database logic public ActionResult Delete(string transid) { var userobject = Session["id"]; if (userobject == null) { return(RedirectToAction("Index", "Login")); } else { transid = Request.QueryString["transid"]; int ids = Convert.ToInt32(transid); using (db) { mt_transaction transdt = db.mt_transaction.Where(x => x.TRANS_ID == ids).FirstOrDefault <mt_transaction>(); try { db.mt_transaction.Remove(transdt); 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)); } } } }
public ActionResult Insert(OemahJowoClass transDt) { var userobject = Session["id"]; if (userobject == null) { return(RedirectToAction("Index", "Login")); } else { transDt.TRANS_DATE = Convert.ToDateTime(transDt.TRANS_DATE.ToString("MM/dd/yyyy")); var editmode = Request.QueryString["editmode"]; var username = User.Identity.Name; transDt.ENTRY_DATE = DateTime.Now; transDt.ENTRY_USER = userobject.ToString(); transDt.UPDATE_DATE = DateTime.Now; transDt.UPDATE_USER = userobject.ToString(); var dtname = username; using (db) { try { mt_transaction transfield = new mt_transaction(); transfield.TRANS_DATE = transDt.TRANS_DATE; transfield.PROD_ID = transDt.PROD_ID; transfield.DESCRIPTION = transDt.DESCRIPTION; transfield.CUST_ID = transDt.CUST_ID; transfield.ITEM_AMT = transDt.ITEM_AMT; transfield.PRICE = transDt.PRICE; if (transDt.IS_ONLINE) { transfield.IS_GOJEK = "Y"; } else { transfield.IS_GOJEK = "N"; } transfield.UPDATE_DATE = transDt.UPDATE_DATE; transfield.UPDATE_USER = transDt.UPDATE_USER; transfield.ENTRY_DATE = transDt.ENTRY_DATE; transfield.ENTRY_USER = transDt.ENTRY_USER; db.mt_transaction.Add(transfield); 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)); } } } }