public ActionResult Edit(MASTER_ICS ics) { var UserId = Session["USER_ID"]; var logcode = ics.ICS_LOG_CODE; var datenow = MixHelper.ConvertDateNow(); var fupdate = "ICS_PARENT_CODE = '" + ics.ICS_PARENT_CODE + "'," + "ICS_CODE = '" + ics.ICS_CODE + "'," + "ICS_NAME = '" + ics.ICS_NAME + "'," + "ICS_NAME_IND = '" + ics.ICS_NAME_IND + "'," + //"ICS_YEAR = '" + ics.ICS_YEAR + "'," + "ICS_UPDATE_BY = '" + UserId + "'," + "ICS_UPDATE_DATE = " + datenow; db.Database.ExecuteSqlCommand("UPDATE MASTER_ICS SET " + fupdate + " WHERE ICS_ID = '" + ics.ICS_ID + "'"); String objek = fupdate.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil Disimpan"; return(RedirectToAction("Index")); }
public ActionResult Create(MASTER_ICS ics) { //return Content(ics.ICS_PARENT_CODE); var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_ICS"); var datenow = MixHelper.ConvertDateNow(); var fname = "ICS_ID," + "ICS_PARENT_CODE," + "ICS_CODE," + "ICS_NAME," + "ICS_NAME_IND," + //"ICS_YEAR," + "ICS_CREATE_BY," + "ICS_CREATE_DATE," + "ICS_STATUS," + "ICS_LOG_CODE"; var fvalue = "'" + lastid + "', " + "'" + ics.ICS_PARENT_CODE + "', " + "'" + ics.ICS_PARENT_CODE + "." + ics.ICS_CODE + "'," + "'" + ics.ICS_NAME + "'," + "'" + ics.ICS_NAME_IND + "'," + //"'" + ics.ICS_YEAR + "'," + "'" + UserId + "', " + datenow + "," + "1," + "'" + logcode + "'"; db.Database.ExecuteSqlCommand("INSERT INTO MASTER_ICS (" + 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")); }