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