public ActionResult Edit(MASTER_SCOPE dt_form) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); var datenow = MixHelper.ConvertDateNow(); var status = "1"; var update = " SCOPE_CODE = '" + dt_form.SCOPE_CODE + "'," + " SCOPE_NAME = '" + dt_form.SCOPE_NAME + "'," + " SCOPE_UPDATE_BY = '" + UserId + "'," + " SCOPE_UPDATE_DATE = " + datenow + "," + " SCOPE_STATUS = '" + status + "'"; var clause = "where SCOPE_ID = " + dt_form.SCOPE_ID; //return Json(new { query = "UPDATE MASTER_BIDANG SET " + update.Replace("''", "NULL") + " " + clause }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("UPDATE MASTER_SCOPE SET " + update.Replace("''", "NULL") + " " + clause); String objek = update.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil Disimpan"; return(RedirectToAction("Index")); }
public ActionResult Create(MASTER_SCOPE dt_form) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_SCOPE"); var datenow = MixHelper.ConvertDateNow(); var fname = "SCOPE_ID,SCOPE_CODE,SCOPE_NAME,SCOPE_CREATE_BY,SCOPE_CREATE_DATE,SCOPE_STATUS"; var fvalue = "'" + lastid + "', " + "'" + dt_form.SCOPE_CODE + "', " + "'" + dt_form.SCOPE_NAME + "', " + "'" + UserId + "'," + datenow + "," + "1"; db.Database.ExecuteSqlCommand("INSERT INTO MASTER_SCOPE (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")"); String objek = fvalue.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil Disimpan"; return(RedirectToAction("Index")); }