public ActionResult TambahSNI(TRX_REGULASI_TEKNIS trt, FormCollection formCollection)
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
int lastid = MixHelper.GetSequence("TRX_REGULASI_TEKNIS_DETAIL");
var datenow = MixHelper.ConvertDateNow();
var sni_id = formCollection["RETEK_DETAIL_SNI_ID"];
if (sni_id != null)
{ //int n = 0;
string[] vals = sni_id.Split(',');
for (int n = 0; n < vals.Length; n++)
{
int lastid_mki = MixHelper.GetSequence("TRX_REGULASI_TEKNIS_DETAIL");
var jml = db.Database.SqlQuery <int>("SELECT COUNT(*) FROM TRX_REGULASI_TEKNIS_DETAIL MK WHERE RETEK_DETAIL_RETEK_ID = " + trt.RETEK_ID + "AND RETEK_DETAIL_SNI_ID = " + vals[n]);
if (Convert.ToInt32(jml) == 0)
{
//string query_update = "INSERT INTO MASTER_KOMTEK_ICS (KOMTEK_ICS_ID, KOMTEK_ICS_KOMTEK_ID, KOMTEK_ICS_ICS_ID, KOMTEK_ICS_CREATE_BY, KOMTEK_ICS_CREATE_DATE, KOMTEK_ICS_STATUS, KOMTEK_ICS_LOG_CODE) VALUES (" + lastid_mki + "," + lastid + "," + vals[n] + "," + UserId + "," + datenow + ",1,'" + logcode + "')";
//db.Database.ExecuteSqlCommand(query_update);
//return Json(new { query = query_update, id = komtek_ics_id });
var fname1 = "RETEK_DETAIL_ID,RETEK_DETAIL_RETEK_ID,RETEK_DETAIL_SNI_ID,RETEK_DETAIL_CREATE_BY,RETEK_DETAIL_CREATE_DATE,RETEK_DETAIL_STATUS";
var fvalue1 = "'" + lastid_mki + "'," +
"'" + trt.RETEK_ID + "'," +
"'" + vals[n] + "'," +
"" + UserId + "," +
datenow + "," +
"1";
//return Json(new { query = "INSERT INTO TRX_REGULASI_TEKNIS (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO TRX_REGULASI_TEKNIS_DETAIL (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
String objek1 = fvalue1.Replace("'", "-");
MixHelper.InsertLog(logcode, objek1, 1);
}
}
}
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Data Berhasil Disimpan";
return(RedirectToAction("Index"));
}
public ActionResult Edit(TRX_REGULASI_TEKNIS trt, FormCollection formCollection)
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
int lastid = MixHelper.GetSequence("TRX_REGULASI_TEKNIS");
var datenow = MixHelper.ConvertDateNow();
int lastid_doc = MixHelper.GetSequence("TRX_DOCUMENTS");
var status = "1";
var update = "";
string path = Server.MapPath("~/Upload/Dokumen/SK_REGULASI/");
HttpPostedFileBase file_att = Request.Files["file_regtek"];
var file_name_att = "";
var filePath = "";
var fileExtension = "";
string lampiranregulasipath = file_att.FileName;
if (lampiranregulasipath.Trim() != "")
{
lampiranregulasipath = Path.GetFileNameWithoutExtension(file_att.FileName);
fileExtension = Path.GetExtension(file_att.FileName);
file_name_att = "RegulasiTeknis_" + trt.RETEK_NO_SK.Replace('/', '-') + "_" + lastid + fileExtension;
filePath = path + file_name_att;
file_att.SaveAs(filePath);
var logcodeDOC1 = MixHelper.GetLogCode();
var id = trt.RETEK_ID;
var qupdate = "UPDATE TRX_DOCUMENTS SET DOC_STATUS = 0 WHERE DOC_ID = " + id;
db.Database.ExecuteSqlCommand(qupdate);
String objekDOC1 = qupdate.Replace("'", "-");
MixHelper.InsertLog(logcodeDOC1, objekDOC1, 1);
var logcodeDOC = MixHelper.GetLogCode();
var FNAME_DOC = "DOC_ID,DOC_FOLDER_ID,DOC_NAME,DOC_DESCRIPTION,DOC_FILE_PATH,DOC_FILE_NAME,DOC_FILETYPE,DOC_EDITABLE,DOC_CREATE_BY,DOC_CREATE_DATE,DOC_STATUS,DOC_LOG_CODE";
var FVALUE_DOC = lastid_doc + ", " +
"'4', " +
"'" + trt.RETEK_NO_SK.ToUpper() + "', " +
"'Regulasi Teknis dengan Nomor " + trt.RETEK_NO_SK.ToUpper() + "', " +
"'" + "/Upload/Dokumen/SK_REGULASI/', " +
"'" + "RegulasiTeknis_" + trt.RETEK_NO_SK.Replace('/', '-') + "_" + lastid + "', " +
"'" + fileExtension.Replace(".", "").ToUpper() + "', " +
"'0', " +
"'" + UserId + "', " +
datenow + "," +
"'1', " +
"'" + logcodeDOC + "'";
db.Database.ExecuteSqlCommand("INSERT INTO TRX_DOCUMENTS (" + FNAME_DOC + ") VALUES (" + FVALUE_DOC.Replace("''", "NULL") + ")");
String objekDOC = FVALUE_DOC.Replace("'", "-");
MixHelper.InsertLog(logcodeDOC, objekDOC, 1);
update =
"RETEK_NO_SK = '" + trt.RETEK_NO_SK + "'," +
"RETEK_TENTANG = '" + trt.RETEK_TENTANG + "'," +
"RETEK_REGULATOR = '" + trt.RETEK_REGULATOR + "'," +
"RETEK_KETERANGAN = '" + trt.RETEK_KETERANGAN + "'," +
"RETEK_FILE = '" + trt.RETEK_FILE + "'," +
"RETEK_UPDATE_BY = " + UserId + "," +
"RETEK_UPDATE_DATE = " + datenow + "," +
"RETEK_STATUS = '" + status + "'";
}
else
{
update =
"RETEK_NO_SK = '" + trt.RETEK_NO_SK + "'," +
"RETEK_TENTANG = '" + trt.RETEK_TENTANG + "'," +
"RETEK_REGULATOR = '" + trt.RETEK_REGULATOR + "'," +
"RETEK_KETERANGAN = '" + trt.RETEK_KETERANGAN + "'," +
"RETEK_UPDATE_BY = " + UserId + "," +
"RETEK_UPDATE_DATE = " + datenow + "," +
"RETEK_STATUS = '" + status + "'";
}
var clause = "where RETEK_ID = " + trt.RETEK_ID;
//return Json(new { query = "UPDATE TRX_REGULASI_TEKNIS SET " + update.Replace("''", "NULL") + " " + clause }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("UPDATE TRX_REGULASI_TEKNIS SET " + update.Replace("''", "NULL") + " " + clause);
var idk = db.Database.SqlQuery <int>("SELECT MAX(MK.RETEK_ID) FROM TRX_REGULASI_TEKNIS MK").SingleOrDefault();
var sni_id = formCollection["RETEK_DETAIL_SNI_ID"];
if (sni_id != null)
{ //int n = 0;
var sni_list = (from t in db.VIEW_REGTEK_DETAIL where t.RETEK_DETAIL_ID == trt.RETEK_ID select t).ToList();
string[] vals = sni_id.Split(',');
string query_update = "UPDATE TRX_REGULASI_TEKNIS_DETAIL SET RETEK_DETAIL_STATUS = 0, RETEK_DETAIL_UPDATE_BY =" + UserId + ", RETEK_DETAIL_UPDATE_DATE=" + datenow + " WHERE RETEK_DETAIL_RETEK_ID = " + trt.RETEK_ID;
db.Database.ExecuteSqlCommand(query_update);
for (int n = 0; n < vals.Length; n++)
{
//int lastid_mki = MixHelper.GetSequence("TRX_REGULASI_TEKNIS_DETAIL");
int cek = db.Database.SqlQuery <int>("SELECT COUNT(1) AS JML FROM TRX_REGULASI_TEKNIS_DETAIL WHERE RETEK_DETAIL_RETEK_ID = '" + trt.RETEK_ID + "' AND RETEK_DETAIL_SNI_ID = '" + vals[n] + "'").SingleOrDefault();
if (cek == 0)
{
int lastid_mki = MixHelper.GetSequence("TRX_REGULASI_TEKNIS_DETAIL");
string query_insert = "INSERT INTO TRX_REGULASI_TEKNIS_DETAIL (RETEK_DETAIL_ID,RETEK_DETAIL_RETEK_ID,RETEK_DETAIL_SNI_ID,RETEK_DETAIL_UPDATE_BY,RETEK_DETAIL_UPDATE_DATE,RETEK_DETAIL_STATUS) VALUES (" + lastid_mki + "," + trt.RETEK_ID + "," + vals[n] + "," + UserId + "," + datenow + ",1)";
db.Database.ExecuteSqlCommand(query_insert);
}
else
{
string query_updatea = "UPDATE TRX_REGULASI_TEKNIS_DETAIL SET RETEK_DETAIL_STATUS = 1, RETEK_DETAIL_UPDATE_BY =" + UserId + ", RETEK_DETAIL_UPDATE_DATE=" + datenow + " WHERE RETEK_DETAIL_RETEK_ID = " + trt.RETEK_ID + " AND RETEK_DETAIL_SNI_ID = '" + vals[n] + "'";
//return Json(new { data = query_updatea }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand(query_updatea);
}
}
}
else
{
string query_updates = "UPDATE TRX_REGULASI_TEKNIS_DETAIL SET RETEK_DETAIL_STATUS = 0, RETEK_DETAIL_UPDATE_BY =" + UserId + ", RETEK_DETAIL_UPDATE_DATE=" + datenow + " WHERE RETEK_DETAIL_RETEK_ID = " + trt.RETEK_ID;
db.Database.ExecuteSqlCommand(query_updates);
}
//var logId = AuditTrails.GetLogId();
String objek = update.Replace("'", "-");
MixHelper.InsertLog(logcode, objek, 1);
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Data Berhasil Disimpan";
return(RedirectToAction("Index"));
}
public ActionResult Create(TRX_REGULASI_TEKNIS trt, FormCollection formCollection)
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
int lastid = MixHelper.GetSequence("TRX_REGULASI_TEKNIS");
int lastid_detail = MixHelper.GetSequence("TRX_REGULASI_TEKNIS_DETAIL");
int lastid_doc = MixHelper.GetSequence("TRX_DOCUMENTS");
var datenow = MixHelper.ConvertDateNow();
string path = Server.MapPath("~/Upload/Dokumen/SK_REGULASI/");
HttpPostedFileBase file_att = Request.Files["file_regtek"];
var file_name_att = "";
var filePath = "";
var fileExtension = "";
if (file_att != null)
{
string lampiranregulasipath = file_att.FileName;
if (lampiranregulasipath.Trim() != "")
{
lampiranregulasipath = Path.GetFileNameWithoutExtension(file_att.FileName);
fileExtension = Path.GetExtension(file_att.FileName);
file_name_att = "RegulasiTeknis_" + trt.RETEK_NO_SK.Replace('/', '-') + "_" + lastid + fileExtension;
filePath = path + file_name_att;
file_att.SaveAs(filePath);
}
}
var logcodeDOC = MixHelper.GetLogCode();
var FNAME_DOC = "DOC_ID,DOC_FOLDER_ID,DOC_NAME,DOC_DESCRIPTION,DOC_FILE_PATH,DOC_FILE_NAME,DOC_FILETYPE,DOC_EDITABLE,DOC_CREATE_BY,DOC_CREATE_DATE,DOC_STATUS,DOC_LOG_CODE";
var FVALUE_DOC = lastid_doc + ", " +
"'4', " +
"'" + trt.RETEK_NO_SK.ToUpper() + "', " +
"'Regulasi Teknis dengan Nomor " + trt.RETEK_NO_SK.ToUpper() + "', " +
"'" + "/Upload/Dokumen/SK_REGULASI/', " +
"'" + "RegulasiTeknis_" + trt.RETEK_NO_SK.Replace('/', '-') + "_" + lastid + "', " +
"'" + fileExtension.Replace(".", "").ToUpper() + "', " +
"'0', " +
"'" + UserId + "', " +
datenow + "," +
"'1', " +
"'" + logcodeDOC + "'";
db.Database.ExecuteSqlCommand("INSERT INTO TRX_DOCUMENTS (" + FNAME_DOC + ") VALUES (" + FVALUE_DOC.Replace("''", "NULL") + ")");
String objekDOC = FVALUE_DOC.Replace("'", "-");
MixHelper.InsertLog(logcodeDOC, objekDOC, 1);
var fname = "RETEK_ID,RETEK_NO_SK,RETEK_TENTANG,RETEK_REGULATOR,RETEK_KETERANGAN,RETEK_FILE,RETEK_CREATE_BY,RETEK_CREATE_DATE,RETEK_STATUS";
var fvalue = "'" + lastid + "'," +
"'" + trt.RETEK_NO_SK + "'," +
"'" + trt.RETEK_TENTANG + "'," +
"'" + trt.RETEK_REGULATOR + "'," +
"'" + trt.RETEK_KETERANGAN + "'," +
"" + lastid_doc + "," +
"" + UserId + "," +
datenow + "," +
"1";
db.Database.ExecuteSqlCommand("INSERT INTO TRX_REGULASI_TEKNIS (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")");
String objek = fvalue.Replace("'", "-");
MixHelper.InsertLog(logcode, objek, 1);
var idk = db.Database.SqlQuery <int>("SELECT MAX(MK.RETEK_ID) FROM TRX_REGULASI_TEKNIS MK").SingleOrDefault();
var sni_id = formCollection["RETEK_DETAIL_SNI_ID"];
if (sni_id != null)
{ //int n = 0;
string[] vals = sni_id.Split(',');
for (int n = 0; n < vals.Length; n++)
{
int lastid_mki = MixHelper.GetSequence("TRX_REGULASI_TEKNIS_DETAIL");
//string query_update = "INSERT INTO MASTER_KOMTEK_ICS (KOMTEK_ICS_ID, KOMTEK_ICS_KOMTEK_ID, KOMTEK_ICS_ICS_ID, KOMTEK_ICS_CREATE_BY, KOMTEK_ICS_CREATE_DATE, KOMTEK_ICS_STATUS, KOMTEK_ICS_LOG_CODE) VALUES (" + lastid_mki + "," + lastid + "," + vals[n] + "," + UserId + "," + datenow + ",1,'" + logcode + "')";
//db.Database.ExecuteSqlCommand(query_update);
//return Json(new { query = query_update, id = komtek_ics_id });
var fname1 = "RETEK_DETAIL_ID,RETEK_DETAIL_RETEK_ID,RETEK_DETAIL_SNI_ID,RETEK_DETAIL_CREATE_BY,RETEK_DETAIL_CREATE_DATE,RETEK_DETAIL_STATUS";
var fvalue1 = "'" + lastid_mki + "'," +
"'" + idk + "'," +
"'" + vals[n] + "'," +
"" + UserId + "," +
datenow + "," +
"1";
//return Json(new { query = "INSERT INTO TRX_REGULASI_TEKNIS (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO TRX_REGULASI_TEKNIS_DETAIL (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
String objek1 = fvalue1.Replace("'", "-");
MixHelper.InsertLog(logcode, objek1, 1);
}
}
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Data Berhasil Disimpan";
return(RedirectToAction("Index"));
}
