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