public ActionResult Edit(MASTER_INSTANSI master_instansi) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_INSTANSI"); var datenow = MixHelper.ConvertDateNow(); var status = "1"; var update = " INSTANSI_CODE = '" + master_instansi.INSTANSI_CODE + "'," + " INSTANSI_NAME = '" + master_instansi.INSTANSI_NAME + "'," + " INSTANSI_UPDATE_BY = '" + UserId + "'," + " INSTANSI_UPDATE_DATE = " + datenow + "," + " INSTANSI_LOG_CODE = '" + logcode + "', " + " INSTANSI_STATUS = '" + status + "'"; var clause = "where INSTANSI_ID = " + master_instansi.INSTANSI_ID; //return Json(new { query = "UPDATE MASTER_INSTANSI SET " + update.Replace("''", "NULL") + " " + clause }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("UPDATE MASTER_INSTANSI SET " + update.Replace("''", "NULL") + " " + clause); //var logId = AuditTrails.GetLogId(); String objek = update.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil Disimpan"; return(RedirectToAction("Index")); }
public ActionResult Create(MASTER_INSTANSI master_instansi) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_INSTANSI"); var datenow = MixHelper.ConvertDateNow(); var fname = "INSTANSI_ID,INSTANSI_CODE,INSTANSI_NAME,INSTANSI_CREATE_BY,INSTANSI_CREATE_DATE,INSTANSI_LOG_CODE,INSTANSI_STATUS"; var fvalue = "'" + lastid + "', " + "'" + master_instansi.INSTANSI_CODE + "', " + "'" + master_instansi.INSTANSI_NAME + "', " + "'" + UserId + "', " + datenow + "," + "'" + logcode + "'," + "1"; //return Json(new { query = "INSERT INTO MASTER_INSTANSI (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("INSERT INTO MASTER_INSTANSI (" + 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")); }