public ActionResult Create(MASTER_SNI_STYLE mss) { var USER_ID = Convert.ToInt32(Session["USER_ID"]); var LOGCODE = MixHelper.GetLogCode(); int LASTID = MixHelper.GetSequence("MASTER_SNI_STYLE"); var DATENOW = MixHelper.ConvertDateNow(); var sort_max = db.Database.SqlQuery <Int32>("SELECT NVL(MAX(SNI_STYLE_SORT), 0) AS SNI_STYLE_SORT FROM MASTER_SNI_STYLE").SingleOrDefault(); var sort = Convert.ToInt32(sort_max) + 1; var fname = "SNI_STYLE_ID,SNI_STYLE_NAME,SNI_STYLE_VALUE,SNI_STYLE_SORT,SNI_STYLE_CREATE_BY,SNI_STYLE_CREATE_DATE,SNI_STYLE_STATUS"; var fvalue = "" + LASTID + ", " + "'" + mss.SNI_STYLE_NAME + "', " + "'" + mss.SNI_STYLE_VALUE + "', " + "'" + sort + "', " + "'" + USER_ID + "', " + DATENOW + "," + "1"; db.Database.ExecuteSqlCommand("INSERT INTO MASTER_SNI_STYLE (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")"); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data SNI Berhasil di Publikasikan"; return(RedirectToAction("Index")); }
public ActionResult Edit(MASTER_SNI_STYLE mss) { var USER_ID = Convert.ToInt32(Session["USER_ID"]); var LOGCODE = MixHelper.GetLogCode(); int LASTID = MixHelper.GetSequence("MASTER_SNI_STYLE"); var DATENOW = MixHelper.ConvertDateNow(); if (mss.SNI_STYLE_ID > 0) { var uPDATE = "UPDATE MASTER_SNI_STYLE SET SNI_STYLE_NAME = '" + mss.SNI_STYLE_NAME + "', SNI_STYLE_VALUE = '" + mss.SNI_STYLE_VALUE + "', SNI_STYLE_UPDATE_BY = " + LASTID + ", SNI_STYLE_UPDATE_DATE = " + DATENOW + " WHERE SNI_STYLE_ID = " + mss.SNI_STYLE_ID; db.Database.ExecuteSqlCommand(uPDATE); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data SNI Style Berhasil di Publikasikan"; } else { TempData["Notifikasi"] = 2; TempData["NotifikasiText"] = "Data SNI Style gagal di Publikasikan"; } return(RedirectToAction("Index")); }