public ActionResult Edit(TRX_LPK tl, FormCollection formCollection, int[] LPK_DETAIL_SNI_SNI_ID, int[] LPK_SCOPE_SCOPE_ID)
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
int lastid = MixHelper.GetSequence("MASTER_BIDANG");
var datenow = MixHelper.ConvertDateNow();
DateTime date1 = Convert.ToDateTime(tl.LPK_PERIODE_AWAL);
var dateawal = "TO_DATE('" + date1.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss')";
DateTime date2 = Convert.ToDateTime(tl.LPK_PERIODE_AKHIR);
var dateakhir = "TO_DATE('" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss')";
var update =
"LPK_NAMA = '" + tl.LPK_NAMA + "'," +
"LPK_NOMOR = '" + tl.LPK_NOMOR + "'," +
"LPK_KATEGORI = 1," +
"LPK_JENIS = " + tl.LPK_JENIS + "," +
"LPK_ALAMAT = '" + tl.LPK_ALAMAT + "'," +
"LPK_TELEPON = '" + tl.LPK_TELEPON + "'," +
"LPK_FAX= '" + tl.LPK_FAX + "'," +
"LPK_KODE_POS = '" + tl.LPK_KODE_POS + "'," +
"LPK_WEBSITE = '" + tl.LPK_WEBSITE + "'," +
"LPK_PROVINSI = '" + tl.LPK_PROVINSI + "'," +
"LPK_KABUPATENKOTA = '" + tl.LPK_KABUPATENKOTA + "'," +
"LPK_EMAIL = '" + tl.LPK_EMAIL + "'," +
"LPK_CONTACT_PERSON = '" + tl.LPK_CONTACT_PERSON + "'," +
"LPK_PERIODE_AWAL = " + dateawal + "," +
"LPK_PERIODE_AKHIR = " + dateakhir + "," +
"LPK_KETERANGAN = '" + tl.LPK_KETERANGAN + "'," +
"LPK_UPDATE_BY = '" + UserId + "'," +
"LPK_UPDATE_DATE = " + datenow + "";
var clause = "where LPK_ID = " + tl.LPK_ID;
//return Json(new { query = "UPDATE TRX_LPK SET " + update.Replace("''", "NULL") + " " + clause }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("UPDATE TRX_LPK SET " + update.Replace("''", "NULL") + " " + clause);
var idk = db.Database.SqlQuery <int>("SELECT MAX(TL.LPK_ID) FROM TRX_LPK TL").SingleOrDefault();
if (LPK_DETAIL_SNI_SNI_ID != null)
{
string query_update = "UPDATE TRX_LPK_DETAIL_SNI SET LPK_DETAIL_SNI_STATUS = 0, LPK_DETAIL_SNI_UPDATE_BY =" + UserId + ", LPK_DETAIL_SNI_UPDATE_DATE=" + datenow + " WHERE LPK_DETAIL_SNI_LPK_ID = " + tl.LPK_ID;
db.Database.ExecuteSqlCommand(query_update);
foreach (var SNI_ID in LPK_DETAIL_SNI_SNI_ID)
{
int cek = db.Database.SqlQuery <int>("SELECT COUNT(1) AS JML FROM TRX_LPK_DETAIL_SNI WHERE LPK_DETAIL_SNI_LPK_ID = '" + tl.LPK_ID + "' AND LPK_DETAIL_SNI_SNI_ID = '" + SNI_ID + "'").SingleOrDefault();
if (cek == 0)
{
var logcodeS = MixHelper.GetLogCode();
int lastid_mki = MixHelper.GetSequence("TRX_LPK_DETAIL_SNI");
var fname1 = "LPK_DETAIL_SNI_ID,LPK_DETAIL_SNI_LPK_ID,LPK_DETAIL_SNI_SNI_ID,LPK_DETAIL_SNI_CREATE_BY,LPK_DETAIL_SNI_CREATE_DATE,LPK_DETAIL_SNI_STATUS,LPK_DETAIL_SNI_LOGCODE";
var fvalue1 = "'" + lastid_mki + "'," +
"'" + tl.LPK_ID + "'," +
"'" + SNI_ID + "'," +
"" + UserId + "," +
datenow + "," +
"1," +
logcodeS;
db.Database.ExecuteSqlCommand("INSERT INTO TRX_LPK_DETAIL_SNI (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
String objek1 = fvalue1.Replace("'", "-");
MixHelper.InsertLog(logcodeS, objek1, 1);
}
else
{
string query_updatea = "UPDATE TRX_LPK_DETAIL_SNI SET LPK_DETAIL_SNI_STATUS = 1, LPK_DETAIL_SNI_UPDATE_BY =" + UserId + ", LPK_DETAIL_SNI_UPDATE_DATE=" + datenow + " WHERE LPK_DETAIL_SNI_LPK_ID = " + tl.LPK_ID + " AND LPK_DETAIL_SNI_SNI_ID = '" + SNI_ID + "'";
//return Json(new { data = query_updatea }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand(query_updatea);
}
}
}
if (LPK_SCOPE_SCOPE_ID != null)
{
string query_update = "UPDATE TRX_LPK_SCOPE SET LPK_SCOPE_STATUS = 0, LPK_SCOPE_UPDATE_BY =" + UserId + ", LPK_SCOPE_UPDATE_DATE=" + datenow + " WHERE LPK_SCOPE_LPK_ID = " + tl.LPK_ID;
db.Database.ExecuteSqlCommand(query_update);
foreach (var SCOPE_ID in LPK_SCOPE_SCOPE_ID)
{
int cek = db.Database.SqlQuery <int>("SELECT COUNT(1) AS JML FROM TRX_LPK_SCOPE WHERE LPK_SCOPE_LPK_ID = '" + tl.LPK_ID + "' AND LPK_SCOPE_SCOPE_ID = '" + SCOPE_ID + "'").SingleOrDefault();
if (cek == 0)
{
var logcodeS = MixHelper.GetLogCode();
int lastid_mki = MixHelper.GetSequence("TRX_LPK_SCOPE");
var fname1 = "LPK_SCOPE_ID,LPK_SCOPE_LPK_ID,LPK_SCOPE_SCOPE_ID,LPK_SCOPE_CREATE_BY,LPK_SCOPE_CREATE_DATE,LPK_SCOPE_STATUS,LPK_SCOPE_LOGCODE";
var fvalue1 = "'" + lastid_mki + "'," +
"'" + tl.LPK_ID + "'," +
"'" + SCOPE_ID + "'," +
"" + UserId + "," +
datenow + "," +
"1," +
logcodeS;
//return Json(new { query = "INSERT INTO TRX_REGULASI_TEKNIS (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO TRX_LPK_SCOPE (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
String objek1 = fvalue1.Replace("'", "-");
MixHelper.InsertLog(logcodeS, objek1, 1);
}
else
{
string query_updatea = "UPDATE TRX_LPK_SCOPE SET LPK_SCOPE_STATUS = 1, LPK_SCOPE_UPDATE_BY =" + UserId + ", LPK_SCOPE_UPDATE_DATE=" + datenow + " WHERE LPK_SCOPE_LPK_ID = " + tl.LPK_ID + " AND LPK_SCOPE_SCOPE_ID = '" + SCOPE_ID + "'";
//return Json(new { data = query_updatea }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand(query_updatea);
}
}
}
//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 Edit(TRX_LPK tl, FormCollection formCollection, int[] LPK_DETAIL_SNI_SNI_ID, int[] LPK_SCOPE_SCOPE_ID)
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
int lastid = MixHelper.GetSequence("MASTER_BIDANG");
var datenow = MixHelper.ConvertDateNow();
var update = "";
var pathss = "/Upload/Dokumen/LAINNYA/LPK/";
DateTime date2 = Convert.ToDateTime(tl.LPK_PERIODE_AKHIR);
var dateakhir = "TO_DATE('" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss')";
string path = Server.MapPath("~/Upload/Dokumen/LAINNYA/LPK/");
HttpPostedFileBase file_att = Request.Files["LPK_FILE"];
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 = "LPK_" + tl.LPK_NOMOR.Replace(' ', '-') + "_" + lastid + fileExtension;
filePath = path + file_name_att;
file_att.SaveAs(filePath);
update =
"LPK_NAMA = '" + tl.LPK_NAMA + "'," +
"LPK_JENIS = " + tl.LPK_JENIS + "," +
"LPK_NOMOR = '" + tl.LPK_NOMOR + "'," +
"LPK_ALAMAT = '" + tl.LPK_ALAMAT + "'," +
"LPK_LAMPIRAN = '" + pathss + "" + file_name_att + "'," +
"LPK_TELEPON = '" + tl.LPK_TELEPON + "'," +
"LPK_EMAIL = '" + tl.LPK_EMAIL + "'," +
"LPK_WEBSITE = '" + tl.LPK_WEBSITE + "'," +
"LPK_CONTACT_PERSON = '" + tl.LPK_CONTACT_PERSON + "'," +
"LPK_PERIODE_AKHIR = " + dateakhir + "," +
"LPK_KETERANGAN = '" + tl.LPK_KETERANGAN + "'," +
"LPK_UPDATE_BY = '" + UserId + "'," +
"LPK_UPDATE_DATE = " + datenow + "";
}
else
{
update =
"LPK_NAMA = '" + tl.LPK_NAMA + "'," +
"LPK_JENIS = " + tl.LPK_JENIS + "," +
"LPK_NOMOR = '" + tl.LPK_NOMOR + "'," +
"LPK_ALAMAT = '" + tl.LPK_ALAMAT + "'," +
"LPK_TELEPON = '" + tl.LPK_TELEPON + "'," +
"LPK_EMAIL = '" + tl.LPK_EMAIL + "'," +
"LPK_WEBSITE = '" + tl.LPK_WEBSITE + "'," +
"LPK_CONTACT_PERSON = '" + tl.LPK_CONTACT_PERSON + "'," +
"LPK_PERIODE_AKHIR = " + dateakhir + "," +
"LPK_KETERANGAN = '" + tl.LPK_KETERANGAN + "'," +
"LPK_UPDATE_BY = '" + UserId + "'," +
"LPK_UPDATE_DATE = " + datenow + "";
}
var clause = "where LPK_ID = " + tl.LPK_ID;
//return Json(new { query = "UPDATE TRX_LPK SET " + update.Replace("''", "NULL") + " " + clause }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("UPDATE TRX_LPK SET " + update.Replace("''", "NULL") + " " + clause);
var idk = db.Database.SqlQuery <int>("SELECT MAX(TL.LPK_ID) FROM TRX_LPK TL").SingleOrDefault();
if (LPK_DETAIL_SNI_SNI_ID != null)
{
string query_update = "UPDATE TRX_LPK_DETAIL_SNI SET LPK_DETAIL_SNI_STATUS = 0, LPK_DETAIL_SNI_UPDATE_BY =" + UserId + ", LPK_DETAIL_SNI_UPDATE_DATE=" + datenow + " WHERE LPK_DETAIL_SNI_LPK_ID = " + tl.LPK_ID;
db.Database.ExecuteSqlCommand(query_update);
foreach (var SNI_ID in LPK_DETAIL_SNI_SNI_ID)
{
int cek = db.Database.SqlQuery <int>("SELECT COUNT(1) AS JML FROM TRX_LPK_DETAIL_SNI WHERE LPK_DETAIL_SNI_LPK_ID = '" + tl.LPK_ID + "' AND LPK_DETAIL_SNI_SNI_ID = '" + SNI_ID + "'").SingleOrDefault();
if (cek == 0)
{
var logcodeS = MixHelper.GetLogCode();
int lastid_mki = MixHelper.GetSequence("TRX_LPK_DETAIL_SNI");
var fname1 = "LPK_DETAIL_SNI_ID,LPK_DETAIL_SNI_LPK_ID,LPK_DETAIL_SNI_SNI_ID,LPK_DETAIL_SNI_CREATE_BY,LPK_DETAIL_SNI_CREATE_DATE,LPK_DETAIL_SNI_STATUS,LPK_DETAIL_SNI_LOGCODE";
var fvalue1 = "'" + lastid_mki + "'," +
"'" + tl.LPK_ID + "'," +
"'" + SNI_ID + "'," +
"" + UserId + "," +
datenow + "," +
"1," +
logcodeS;
db.Database.ExecuteSqlCommand("INSERT INTO TRX_LPK_DETAIL_SNI (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
String objek1 = fvalue1.Replace("'", "-");
MixHelper.InsertLog(logcodeS, objek1, 1);
}
else
{
string query_updatea = "UPDATE TRX_LPK_DETAIL_SNI SET LPK_DETAIL_SNI_STATUS = 1, LPK_DETAIL_SNI_UPDATE_BY =" + UserId + ", LPK_DETAIL_SNI_UPDATE_DATE=" + datenow + " WHERE LPK_DETAIL_SNI_LPK_ID = " + tl.LPK_ID + " AND LPK_DETAIL_SNI_SNI_ID = '" + SNI_ID + "'";
//return Json(new { data = query_updatea }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand(query_updatea);
}
}
}
if (LPK_SCOPE_SCOPE_ID != null)
{
string query_update = "UPDATE TRX_LPK_SCOPE SET LPK_SCOPE_STATUS = 0, LPK_SCOPE_UPDATE_BY =" + UserId + ", LPK_SCOPE_UPDATE_DATE=" + datenow + " WHERE LPK_SCOPE_LPK_ID = " + tl.LPK_ID;
db.Database.ExecuteSqlCommand(query_update);
foreach (var SCOPE_ID in LPK_SCOPE_SCOPE_ID)
{
int cek = db.Database.SqlQuery <int>("SELECT COUNT(1) AS JML FROM TRX_LPK_SCOPE WHERE LPK_SCOPE_LPK_ID = '" + tl.LPK_ID + "' AND LPK_SCOPE_SCOPE_ID = '" + SCOPE_ID + "'").SingleOrDefault();
if (cek == 0)
{
var logcodeS = MixHelper.GetLogCode();
int lastid_mki = MixHelper.GetSequence("TRX_LPK_SCOPE");
var fname1 = "LPK_SCOPE_ID,LPK_SCOPE_LPK_ID,LPK_SCOPE_SCOPE_ID,LPK_SCOPE_CREATE_BY,LPK_SCOPE_CREATE_DATE,LPK_SCOPE_STATUS,LPK_SCOPE_LOGCODE";
var fvalue1 = "'" + lastid_mki + "'," +
"'" + tl.LPK_ID + "'," +
"'" + SCOPE_ID + "'," +
"" + UserId + "," +
datenow + "," +
"1," +
logcodeS;
//return Json(new { query = "INSERT INTO TRX_REGULASI_TEKNIS (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO TRX_LPK_SCOPE (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
String objek1 = fvalue1.Replace("'", "-");
MixHelper.InsertLog(logcodeS, objek1, 1);
}
else
{
string query_updatea = "UPDATE TRX_LPK_SCOPE SET LPK_SCOPE_STATUS = 1, LPK_SCOPE_UPDATE_BY =" + UserId + ", LPK_SCOPE_UPDATE_DATE=" + datenow + " WHERE LPK_SCOPE_LPK_ID = " + tl.LPK_ID + " AND LPK_SCOPE_SCOPE_ID = '" + SCOPE_ID + "'";
//return Json(new { data = query_updatea }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand(query_updatea);
}
}
}
//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_LPK tl, FormCollection formCollection, int[] LPK_DETAIL_SNI_SNI_ID, int[] LPK_SCOPE_SCOPE_ID)
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
int lastid = MixHelper.GetSequence("TRX_LPK");
var datenow = MixHelper.ConvertDateNow();
DateTime date1 = Convert.ToDateTime(tl.LPK_PERIODE_AWAL);
var dateawal = "TO_DATE('" + date1.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss')";
DateTime date2 = Convert.ToDateTime(tl.LPK_PERIODE_AKHIR);
var dateakhir = "TO_DATE('" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss')";
var fname = "LPK_ID,LPK_NAMA,LPK_NOMOR,LPK_ALAMAT,LPK_TELEPON,LPK_FAX,LPK_KODE_POS,LPK_EMAIL,LPK_WEBSITE,LPK_CONTACT_PERSON,LPK_PERIODE_AWAL,LPK_PERIODE_AKHIR,LPK_KETERANGAN,LPK_KATEGORI,LPK_JENIS,LPK_CREATE_BY,LPK_CREATE_DATE,LPK_PROVINSI,LPK_KABUPATENKOTA,LPK_LOGCODE,LPK_STATUS";
var fvalue =
"'" + lastid + "'," +
"'" + tl.LPK_NAMA + "'," +
"'" + tl.LPK_NOMOR + "'," +
"'" + tl.LPK_ALAMAT + "'," +
"'" + tl.LPK_TELEPON + "'," +
"'" + tl.LPK_FAX + "'," +
"'" + tl.LPK_KODE_POS + "'," +
"'" + tl.LPK_EMAIL + "'," +
"'" + tl.LPK_WEBSITE + "'," +
"'" + tl.LPK_CONTACT_PERSON + "'," +
dateawal + "," +
dateakhir + "," +
"'" + tl.LPK_KETERANGAN + "'," +
"1," +
"" + tl.LPK_JENIS + "," +
"'" + UserId + "'," +
datenow + "," +
"'" + tl.LPK_PROVINSI + "'," +
"'" + tl.LPK_KABUPATENKOTA + "'," +
"'" + logcode + "'," +
"1";
//return Json(new { query = "INSERT INTO TRX_LPK (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO TRX_LPK (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")");
String objek = fvalue.Replace("'", "-");
MixHelper.InsertLog(logcode, objek, 1);
var idk = db.Database.SqlQuery <int>("SELECT MAX(TL.LPK_ID) FROM TRX_LPK TL").SingleOrDefault();
if (LPK_DETAIL_SNI_SNI_ID != null)
{
foreach (var SNI_ID in LPK_DETAIL_SNI_SNI_ID)
{
var logcodeS = MixHelper.GetLogCode();
int lastid_mki = MixHelper.GetSequence("TRX_LPK_DETAIL_SNI");
//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 = "LPK_DETAIL_SNI_ID,LPK_DETAIL_SNI_LPK_ID,LPK_DETAIL_SNI_SNI_ID,LPK_DETAIL_SNI_CREATE_BY,LPK_DETAIL_SNI_CREATE_DATE,LPK_DETAIL_SNI_STATUS,LPK_DETAIL_SNI_LOGCODE";
var fvalue1 = "'" + lastid_mki + "'," +
"'" + idk + "'," +
"'" + SNI_ID + "'," +
"" + UserId + "," +
datenow + "," +
"1," +
logcodeS;
//return Json(new { query = "INSERT INTO TRX_REGULASI_TEKNIS (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO TRX_LPK_DETAIL_SNI (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
String objek1 = fvalue1.Replace("'", "-");
MixHelper.InsertLog(logcodeS, objek1, 1);
}
}
if (LPK_SCOPE_SCOPE_ID != null)
{
foreach (var SCOPE_ID in LPK_SCOPE_SCOPE_ID)
{
var logcodeS = MixHelper.GetLogCode();
int lastid_mki = MixHelper.GetSequence("TRX_LPK_SCOPE");
var fname1 = "LPK_SCOPE_ID,LPK_SCOPE_LPK_ID,LPK_SCOPE_SCOPE_ID,LPK_SCOPE_CREATE_BY,LPK_SCOPE_CREATE_DATE,LPK_SCOPE_STATUS,LPK_SCOPE_LOGCODE";
var fvalue1 = "'" + lastid_mki + "'," +
"'" + idk + "'," +
"'" + SCOPE_ID + "'," +
"" + UserId + "," +
datenow + "," +
"1," +
logcodeS;
//return Json(new { query = "INSERT INTO TRX_REGULASI_TEKNIS (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO TRX_LPK_SCOPE (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
String objek1 = fvalue1.Replace("'", "-");
MixHelper.InsertLog(logcodeS, objek1, 1);
}
}
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Data Berhasil Disimpan";
return(RedirectToAction("Index"));
}
public ActionResult Create(TRX_LPK tl, FormCollection formCollection, int[] LPK_DETAIL_SNI_SNI_ID, int[] LPK_SCOPE_SCOPE_ID)
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
int lastid = MixHelper.GetSequence("MASTER_KOMITE_TEKNIS");
var datenow = MixHelper.ConvertDateNow();
int lastid_doc = MixHelper.GetSequence("TRX_DOCUMENTS");
string path = Server.MapPath("~/Upload/Dokumen/LAINNYA/LPK/");
HttpPostedFileBase file_att = Request.Files["LPK_FILE"];
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 = "LPK_" + tl.LPK_NOMOR.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.Remove('.').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 pathss = "/Upload/Dokumen/LAINNYA/LPK/";
DateTime date2 = Convert.ToDateTime(tl.LPK_PERIODE_AKHIR);
var dateakhir = "TO_DATE('" + date2.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss')";
var fname = "LPK_ID,LPK_JENIS,LPK_NAMA,LPK_NOMOR,LPK_ALAMAT,LPK_LAMPIRAN,LPK_TELEPON,LPK_FAX,LPK_KODE_POS,LPK_EMAIL,LPK_WEBSITE,LPK_CONTACT_PERSON,LPK_PERIODE_AKHIR,LPK_KETERANGAN,LPK_KATEGORI,LPK_CREATE_BY,LPK_CREATE_DATE,LPK_PROVINSI,LPK_KABUPATENKOTA,LPK_LOGCODE,LPK_STATUS";
var fvalue =
"'" + lastid + "'," +
"" + tl.LPK_JENIS + "," +
"'" + tl.LPK_NAMA + "'," +
"'" + tl.LPK_NOMOR + "'," +
"'" + tl.LPK_ALAMAT + "'," +
"'" + pathss + "" + file_name_att + "'," +
"'" + tl.LPK_TELEPON + "'," +
"'" + tl.LPK_FAX + "'," +
"'" + tl.LPK_KODE_POS + "'," +
"'" + tl.LPK_EMAIL + "'," +
"'" + tl.LPK_WEBSITE + "'," +
"'" + tl.LPK_CONTACT_PERSON + "'," +
"" + dateakhir + "," +
"'" + tl.LPK_KETERANGAN + "'," +
"2," +
"'" + UserId + "'," +
datenow + "," +
"'" + tl.LPK_PROVINSI + "'," +
"'" + tl.LPK_KABUPATENKOTA + "'," +
"'" + logcode + "'," +
"1";
//return Json(new { query = "INSERT INTO TRX_LPK (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO TRX_LPK (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")");
String objek = fvalue.Replace("'", "-");
MixHelper.InsertLog(logcode, objek, 1);
var idk = db.Database.SqlQuery <int>("SELECT MAX(TL.LPK_ID) FROM TRX_LPK TL").SingleOrDefault();
if (LPK_DETAIL_SNI_SNI_ID != null)
{
foreach (var SNI_ID in LPK_DETAIL_SNI_SNI_ID)
{
var logcodeS = MixHelper.GetLogCode();
int lastid_mki = MixHelper.GetSequence("TRX_LPK_DETAIL_SNI");
//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 = "LPK_DETAIL_SNI_ID,LPK_DETAIL_SNI_LPK_ID,LPK_DETAIL_SNI_SNI_ID,LPK_DETAIL_SNI_CREATE_BY,LPK_DETAIL_SNI_CREATE_DATE,LPK_DETAIL_SNI_STATUS,LPK_DETAIL_SNI_LOGCODE";
var fvalue1 = "'" + lastid_mki + "'," +
"'" + idk + "'," +
"'" + SNI_ID + "'," +
"" + UserId + "," +
datenow + "," +
"1," +
logcodeS;
//return Json(new { query = "INSERT INTO TRX_REGULASI_TEKNIS (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO TRX_LPK_DETAIL_SNI (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
String objek1 = fvalue1.Replace("'", "-");
MixHelper.InsertLog(logcodeS, objek1, 1);
}
}
if (LPK_SCOPE_SCOPE_ID != null)
{
foreach (var SCOPE_ID in LPK_SCOPE_SCOPE_ID)
{
var logcodeS = MixHelper.GetLogCode();
int lastid_mki = MixHelper.GetSequence("TRX_LPK_SCOPE");
//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 = "LPK_SCOPE_ID,LPK_SCOPE_LPK_ID,LPK_SCOPE_SCOPE_ID,LPK_SCOPE_CREATE_BY,LPK_SCOPE_CREATE_DATE,LPK_SCOPE_STATUS,LPK_SCOPE_LOGCODE";
var fvalue1 = "'" + lastid_mki + "'," +
"'" + idk + "'," +
"'" + SCOPE_ID + "'," +
"" + UserId + "," +
datenow + "," +
"1," +
logcodeS;
//return Json(new { query = "INSERT INTO TRX_REGULASI_TEKNIS (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO TRX_LPK_SCOPE (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
String objek1 = fvalue1.Replace("'", "-");
MixHelper.InsertLog(logcodeS, objek1, 1);
}
}
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Data Berhasil Disimpan";
return(RedirectToAction("Index"));
}
