public ActionResult Create(MASTER_BIDANG master_bidang) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_BIDANG"); var datenow = MixHelper.ConvertDateNow(); var fname = "BIDANG_ID,BIDANG_CODE,BIDANG_NAME,BIDANG_SHORT_NAME,BIDANG_CREATE_BY,BIDANG_CREATE_DATE,BIDANG_LOG_CODE,BIDANG_STATUS"; var fvalue = "'" + lastid + "', " + "'" + master_bidang.BIDANG_CODE + "', " + "'" + master_bidang.BIDANG_NAME + "', " + "'" + master_bidang.BIDANG_SHORT_NAME + "', " + "'" + UserId + "'," + datenow + "," + "'" + logcode + "'," + "1"; //return Json(new { query = "INSERT INTO MASTER_BIDANG (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("INSERT INTO MASTER_BIDANG (" + 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")); }
public ActionResult Edit(MASTER_BIDANG master_bidang) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_BIDANG"); var datenow = MixHelper.ConvertDateNow(); var status = "1"; var update = " BIDANG_CODE = '" + master_bidang.BIDANG_CODE + "'," + " BIDANG_NAME = '" + master_bidang.BIDANG_NAME + "'," + " BIDANG_SHORT_NAME = '" + master_bidang.BIDANG_SHORT_NAME + "'," + " BIDANG_UPDATE_BY = '" + UserId + "'," + " BIDANG_UPDATE_DATE = " + datenow + "," + " BIDANG_LOG_CODE = '" + logcode + "', " + " BIDANG_STATUS = '" + status + "'"; var clause = "where BIDANG_ID = " + master_bidang.BIDANG_ID; //return Json(new { query = "UPDATE MASTER_BIDANG SET " + update.Replace("''", "NULL") + " " + clause }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("UPDATE MASTER_BIDANG 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")); }