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