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"));
}
