public ActionResult Create(MASTER_SCOPE dt_form) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_SCOPE"); var datenow = MixHelper.ConvertDateNow(); var fname = "SCOPE_ID,SCOPE_CODE,SCOPE_NAME,SCOPE_CREATE_BY,SCOPE_CREATE_DATE,SCOPE_STATUS"; var fvalue = "'" + lastid + "', " + "'" + dt_form.SCOPE_CODE + "', " + "'" + dt_form.SCOPE_NAME + "', " + "'" + UserId + "'," + datenow + "," + "1"; db.Database.ExecuteSqlCommand("INSERT INTO MASTER_SCOPE (" + 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 Create(MASTER_REFERENCES references) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_REFERENCES"); var datenow = MixHelper.ConvertDateNow(); var fname = "REF_ID, REF_TYPE, REF_CODE, REF_NAME, REF_CREATE_BY, REF_CREATE_DATE, REF_STATUS, REF_LOG_CODE"; var fvalue = "'" + lastid + "', " + "'2', " + "'" + references.REF_CODE + "', " + "'" + references.REF_NAME + "'," + "'" + UserId + "', " + datenow + "," + "'1'," + "'" + logcode + "'"; db.Database.ExecuteSqlCommand("INSERT INTO MASTER_REFERENCES (" + 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 Index(PORTAL_PROFILE pp) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); var datenow = MixHelper.ConvertDateNow(); var idk = db.Database.SqlQuery <int>("SELECT MAX(MK.PROFILE_ID) FROM PORTAL_PROFILE MK").SingleOrDefault(); var update = "PROFILE_TENTANG_KAMI = '" + pp.PROFILE_TENTANG_KAMI + "'," + "PROFILE_KONTAK_KAMI = '" + pp.PROFILE_KONTAK_KAMI + "'," + "PROFILE_UPDATE_DATE = " + datenow + "," + "PROFILE_UPDATE_BY = '" + UserId + "'"; var clause = "where PROFILE_ID = " + idk; //return Json(new { query = "UPDATE PORTAL_PROFILE SET " + update.Replace("''", "NULL") + " " + clause }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("UPDATE PORTAL_PROFILE 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")); }
public ActionResult Edit(MASTER_SCOPE dt_form) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); var datenow = MixHelper.ConvertDateNow(); var status = "1"; var update = " SCOPE_CODE = '" + dt_form.SCOPE_CODE + "'," + " SCOPE_NAME = '" + dt_form.SCOPE_NAME + "'," + " SCOPE_UPDATE_BY = '" + UserId + "'," + " SCOPE_UPDATE_DATE = " + datenow + "," + " SCOPE_STATUS = '" + status + "'"; var clause = "where SCOPE_ID = " + dt_form.SCOPE_ID; //return Json(new { query = "UPDATE MASTER_BIDANG SET " + update.Replace("''", "NULL") + " " + clause }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("UPDATE MASTER_SCOPE SET " + update.Replace("''", "NULL") + " " + clause); String objek = update.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil Disimpan"; return(RedirectToAction("Index")); }
public ActionResult Create(MASTER_BIBLIOGRAFI mb) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_BIBLIOGRAFI"); var datenow = MixHelper.ConvertDateNow(); var fname = "BIBLIOGRAFI_ID,BIBLIOGRAFI_JUDUL,BIBLIOGRAFI_CREATE_BY,BIBLIOGRAFI_CREATE_DATE,BIBLIOGRAFI_STATUS,BIBLIOGRAFI_LOGCODE"; var fvalue = "'" + lastid + "', " + "'" + mb.BIBLIOGRAFI_JUDUL + "', " + "'" + UserId + "'," + datenow + "," + "1," + "'" + logcode + "'"; //return Json(new { query = "INSERT INTO MASTER_BIDANG (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("INSERT INTO MASTER_BIBLIOGRAFI (" + 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_BIBLIOGRAFI mb) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_BIBLIOGRAFI"); var datenow = MixHelper.ConvertDateNow(); var status = "1"; var update = " BIBLIOGRAFI_JUDUL = '" + mb.BIBLIOGRAFI_JUDUL + "'," + " BIBLIOGRAFI_UPDATE_BY = " + UserId + "," + " BIBLIOGRAFI_UPDATE_DATE = " + datenow + "," + " BIBLIOGRAFI_LOGCODE = '" + logcode + "', " + " BIBLIOGRAFI_STATUS = " + status + ""; var clause = "where BIBLIOGRAFI_ID = " + mb.BIBLIOGRAFI_ID; //return Json(new { query = "UPDATE MASTER_BIDANG SET " + update.Replace("''", "NULL") + " " + clause }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("UPDATE MASTER_BIBLIOGRAFI 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")); }
public ActionResult Create(VIEW_NEWS news) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("PORTAL_NEWS"); var datenow = MixHelper.ConvertDateNow(); string path = Server.MapPath("~/Upload/Dokumen/LAINNYA/news/"); HttpPostedFileBase file_att = Request.Files["image"]; var file_name_att = ""; var filePath = ""; if (file_att != null) { string imagenews = file_att.FileName; if (imagenews.Trim() != "") { imagenews = Path.GetFileNameWithoutExtension(file_att.FileName); string fileExtension = Path.GetExtension(file_att.FileName); file_name_att = "IMAGE_NEWS_" + lastid + fileExtension; filePath = path + file_name_att; file_att.SaveAs(filePath); } } var link = "http://localhost:4878/Upload/Dokumen/LAINNYA/news/"; var PATS = "Upload/Dokumen/LAINNYA/news/"; var fname = "NEWS_ID, NEWS_TITLE,NEWS_CONTENTS,NEWS_SUMBER, NEWS_TAG, NEWS_PATH_IMAGE, NEWS_LINK_IMAGE, NEWS_BRIEF_NEWS, NEWS_CREATE_BY, NEWS_LOG_CODE, NEWS_CREATE_DATE,NEWS_STATUS"; var fvalue = "'" + lastid + "'," + "'" + news.NEWS_TITLE + "'," + "'" + news.NEWS_CONTENTS + "'," + "'" + news.NEWS_SUMBER + "'," + "'" + news.NEWS_TAG + "'," + "'" + PATS + file_name_att + "'," + "'" + link + file_name_att + "'," + "'" + news.NEWS_BRIEF_NEWS + "'," + "'" + UserId + "'," + "'" + logcode + "'," + datenow + "," + "1"; //return Json(new { query = "INSERT INTO MASTER_BIDANG (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("INSERT INTO PORTAL_NEWS (" + 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 Create(SYS_USER sys_users, SYS_USER_INTERN sys_users_intern) { var checkemail = db.SYS_USER.SqlQuery("SELECT * FROM SYS_USER WHERE USER_NAME = '" + sys_users.USER_NAME + "' and USER_STATUS = 1").Count(); if (checkemail > 0) { TempData["Notifikasi"] = 2; TempData["NotifikasiText"] = "Terjadi duplikasi data dengan Uername : " + sys_users.USER_NAME; return(RedirectToAction("Create")); } else { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int idintern = MixHelper.GetSequence("SYS_USER_INTERN"); int lastid = MixHelper.GetSequence("SYS_USER"); var datenow = MixHelper.ConvertDateNow(); var fname1 = "USER_INTERN_ID,USER_INTERN_FULLNAME,USER_INTERN_ADDRESS,USER_INTERN_EMAIL,USER_INTERN_PHONE,USER_INTERN_CREATE_BY,USER_INTERN_CREATE_DATE,USER_INTERN_STATUS,USER_INTERN_LOG_CODE "; var fvalue1 = "'" + idintern + "', " + "'" + sys_users_intern.USER_INTERN_FULLNAME + "', " + "'" + sys_users_intern.USER_INTERN_ADDRESS + "'," + "'" + sys_users_intern.USER_INTERN_EMAIL + "'," + "'" + sys_users_intern.USER_INTERN_PHONE + "'," + "'" + UserId + "', " + datenow + "," + "1," + "'" + logcode + "'"; db.Database.ExecuteSqlCommand("INSERT INTO SYS_USER_INTERN (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")"); var fname = "USER_ID,USER_NAME,USER_PASSWORD,USER_ACCESS_ID,USER_TYPE_ID,USER_REF_ID,USER_CREATE_BY,USER_CREATE_DATE,USER_LOG_CODE,USER_STATUS"; var fvalue = "'" + lastid + "', " + "'" + sys_users.USER_NAME + "', " + "'" + GenPassword(sys_users.USER_PASSWORD) + "', " + "'" + sys_users.USER_ACCESS_ID + "'," + "1," + "'" + idintern + "', " + "'" + UserId + "', " + datenow + "," + "'" + logcode + "'," + "1"; //return Json(new { query = "INSERT INTO SYS_USER (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("INSERT INTO SYS_USER (" + 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 Republish(int id) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("TRX_DOCUMENTS"); var datenow = MixHelper.ConvertDateNow(); var updates = "UPDATE TRX_SNI SET SNI_IS_PUBLISH = 0, SNI_UPDATE_BY = " + UserId + ", SNI_UPDATE_DATE = " + datenow + " WHERE SNI_ID = " + id; db.Database.ExecuteSqlCommand(updates); String objek = updates.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Berhasil, Data SNI menjadi tidak dipublikasi "; return(RedirectToAction("Index")); }
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(SYS_CONFIG config) { var UserId = Session["USER_ID"]; var datenow = MixHelper.ConvertDateNow(); var logcode = config.CONFIG_LOG_CODE; var fupdate = "CONFIG_NAME = '" + config.CONFIG_NAME + "'," + "CONFIG_VALUE = '" + config.CONFIG_VALUE + "'," + "CONFIG_UPDATE_BY = '" + UserId + "'," + "CONFIG_UPDATE_DATE = " + datenow; db.Database.ExecuteSqlCommand("UPDATE SYS_CONFIG SET " + fupdate + " WHERE CONFIG_ID = " + config.CONFIG_ID); String objek = fupdate.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil Disimpan"; return(RedirectToAction("Index")); }
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 publish(int id = 0) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("TRX_DOCUMENTS"); var datenow = MixHelper.ConvertDateNow(); var updates = "UPDATE TRX_SNI_SK SET IS_PUBLISH = 1 WHERE SNI_SK_ID = " + id; db.Database.ExecuteSqlCommand(updates); var update = "UPDATE TRX_SNI SET SNI_IS_PUBLISH = 1 WHERE SNI_SK_ID = " + id; db.Database.ExecuteSqlCommand(update); String objek = update.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data SNI Berhasil di Publikasikan"; 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")); }
public ActionResult Detil(TRX_SNI ts, TRX_PROPOSAL tp, int PROPOSAL_ID = 0, string DOC_INFO = "") { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("TRX_DOCUMENTS"); var datenow = MixHelper.ConvertDateNow(); var update_sni = "UPDATE TRX_SNI SET SNI_IS_PUBLISH = 1, SNI_NOMOR = '" + ts.SNI_NOMOR + "', SNI_JUDUL = '" + ts.SNI_JUDUL + "', SNI_JUDUL_ENG = '" + ts.SNI_JUDUL_ENG + "' WHERE SNI_ID = " + ts.SNI_ID; db.Database.ExecuteSqlCommand(update_sni); var update_PROPOSAL = "UPDATE TRX_PROPOSAL SET PROPOSAL_ABSTRAK = '" + tp.PROPOSAL_ABSTRAK + "', PROPOSAL_ABSTRAK_ENG = '" + tp.PROPOSAL_ABSTRAK_ENG + "', PROPOSAL_RUANG_LINGKUP = '" + tp.PROPOSAL_RUANG_LINGKUP + "', PROPOSAL_RUANG_LINGKUP_ENG = '" + tp.PROPOSAL_RUANG_LINGKUP_ENG + "' WHERE PROPOSAL_ID = " + ts.SNI_PROPOSAL_ID; db.Database.ExecuteSqlCommand(update_PROPOSAL); var updates = "UPDATE TRX_SNI_SK SET IS_PUBLISH = 1 WHERE SNI_SK_ID = " + ts.SNI_SK_ID; db.Database.ExecuteSqlCommand(updates); var DataProposal = (from proposal in db.VIEW_PROPOSAL where proposal.PROPOSAL_ID == ts.SNI_PROPOSAL_ID select proposal).SingleOrDefault(); var PROPOSAL_PNPS_CODE_FIXER = DataProposal.PROPOSAL_PNPS_CODE; var TGL_SEKARANG = DateTime.Now.ToString("yyyyMMddHHmmss"); HttpPostedFileBase file4 = Request.Files["file_sni"]; if (file4.ContentLength > 0) { var doc = (from b in db.TRX_DOCUMENTS where b.DOC_ID == ts.SNI_DOC_ID && b.DOC_FOLDER_ID == 8 && b.DOC_RELATED_TYPE == 100 select b).SingleOrDefault(); int LASTID_DOC = MixHelper.GetSequence("TRX_DOCUMENTS"); Directory.CreateDirectory(Server.MapPath("~/Upload/Dokumen/SNI")); string path = Server.MapPath("~/Upload/Dokumen/SNI/"); Stream stremdokumen = file4.InputStream; byte[] appData = new byte[file4.ContentLength + 1]; stremdokumen.Read(appData, 0, file4.ContentLength); string Extension = Path.GetExtension(file4.FileName); if (Extension.ToLower() == ".doc" || Extension.ToLower() == ".docx") { //Aspose.Pdf.Document pdf = new Aspose.Pdf.Document(stremdokumen); Aspose.Words.Document docx = new Aspose.Words.Document(stremdokumen); string filePathdoc = path + "SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish).docx"; string filePathpdf = path + "SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish).pdf"; string filePathxml = path + "SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish).xml"; docx.Save(@"" + filePathdoc, Aspose.Words.SaveFormat.Docx); docx.Save(@"" + filePathpdf, Aspose.Words.SaveFormat.Pdf); docx.Save(@"" + filePathxml); string Total_Hal = ""; if (DOC_INFO == "" || DOC_INFO == " ") { Total_Hal = (docx.PageCount).ToString(); } else { Total_Hal = DOC_INFO; } ////string filePathpdf = path + "SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish).pdf"; //string filePathxml = path + "SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish).xml"; //pdf.Save(@"" + filePathpdf, Aspose.Pdf.SaveFormat.Pdf); //pdf.Save(@"" + filePathxml); var LOGCODE_TANGGAPAN_MTPS = MixHelper.GetLogCode(); var fupdate = "UPDATE TRX_DOCUMENTS SET DOC_FILE_NAME = 'SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish)'," + "DOC_UPDATE_BY = " + UserId + "," + "DOC_INFO = '" + Total_Hal + "'," + "DOC_FILETYPE = 'DOCX'," + "DOC_UPDATE_DATE = " + datenow + "" + "WHERE DOC_RELATED_ID = " + ts.SNI_PROPOSAL_ID + " AND DOC_FOLDER_ID = 8 AND DOC_RELATED_TYPE = 100"; db.Database.ExecuteSqlCommand(fupdate); } } String objek = update_sni.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); String objeks = update_PROPOSAL.Replace("'", "-"); MixHelper.InsertLog(logcode, objeks, 1); String objekss = updates.Replace("'", "-"); MixHelper.InsertLog(logcode, objekss, 1); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data SNI Berhasil di Publikasikan"; 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")); }
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 Upload(PORTAL_SLIDER ps, FormCollection fc) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("PORTAL_SLIDER"); var datenow = MixHelper.ConvertDateNow(); string path = Server.MapPath("~/Upload/IMAGE_SLIDER/GAMBAR_BESAR/"); HttpPostedFileBase file_att = Request.Files["ImageBesar"]; var file_name_att = ""; var filePath = ""; var fileExtension = ""; if (file_att != null) { //// Create a bitmap of the content of the fileUpload control in memory //Bitmap originalBMP = new Bitmap(fc.); //// Calculate the new image dimensions //int origWidth = originalBMP.Width; //int origHeight = originalBMP.Height; //int sngRatio = origWidth / origHeight; //int newWidth = 100; //int newHeight = newWidth / sngRatio; string IMAGE_BESAR_PATH = file_att.FileName; if (IMAGE_BESAR_PATH.Trim() != "") { IMAGE_BESAR_PATH = Path.GetFileNameWithoutExtension(file_att.FileName); fileExtension = Path.GetExtension(file_att.FileName); file_name_att = "Image_Besar_" + lastid + fileExtension; filePath = path + file_name_att; //WebImage image = new WebImage(file_att.InputStream); //int width = 500; //int height = (int)Math.Round(((width * 1.0) / image.Width) * image.Height); //image.Resize(width, height, false, true); //img.Resize(500, 256); file_att.SaveAs(filePath); } } string path_ = Server.MapPath("~/Upload/IMAGE_SLIDER/GAMBAR_KECIL/"); HttpPostedFileBase file_att_ = Request.Files["ImageKecil"]; var file_name_att_ = ""; var filePath_ = ""; var fileExtension_ = ""; if (file_att_ != null) { string IMAGE_KECIL_PATH = file_att_.FileName; if (IMAGE_KECIL_PATH.Trim() != "") { IMAGE_KECIL_PATH = Path.GetFileNameWithoutExtension(file_att_.FileName); fileExtension_ = Path.GetExtension(file_att_.FileName); file_name_att_ = "Image_Kecil_" + lastid + fileExtension; filePath_ = path_ + file_name_att_; //WebImage image = new WebImage(file_att.InputStream); //int width = 420; //int height = 404; //image.Resize(width, height, false, false); //img.Resize(420, 404); file_att_.SaveAs(filePath_); //ResizeSettings resizeCropSettings = new ResizeSettings("width=420&height=404&format=jpeg&crop=auto"); //string fileName = Path.Combine(path_, System.Guid.NewGuid().ToString()); //fileName = ImageBuilder.Current.Build(filePath_, file_name_att_, resizeCropSettings, false, true); } } var link_ = "http://localhost:4878/Upload/IMAGE_SLIDER/GAMBAR_KECIL/"; var links = "http://localhost:4878/Upload/IMAGE_SLIDER/GAMBAR_BESAR/"; var link = "http://localhost:4878/"; var PATST = "Upload/IMAGE_SLIDER/GAMBAR_BESAR/"; var PATSTS = "Upload/IMAGE_SLIDER/GAMBAR_KECIL/"; var logcodeDOC = MixHelper.GetLogCode(); var FNAME_DOC = "SLIDER_ID,SLIDER_JUDUL,SLIDER_IMAGE_BIG_PATH,SLIDER_IMAGE_SMALL_PATH,SLIDER_IMAGE_LINK,SLIDER_IMAGE_BIG_LINK,SLIDER_IMAGE_SMALL_LINK,SLIDER_IMAGE_IS_USE,SLIDER_STATUS"; var FVALUE_DOC = "'" + lastid + "', " + "'" + ps.SLIDER_JUDUL + "', " + "'" + PATST + file_name_att + "', " + "'" + PATSTS + file_name_att_ + "', " + "'" + link + "', " + "'" + links + file_name_att + "', " + "'" + link_ + file_name_att_ + "', " + "1, " + "1"; db.Database.ExecuteSqlCommand("INSERT INTO PORTAL_SLIDER (" + FNAME_DOC + ") VALUES (" + FVALUE_DOC.Replace("''", "NULL") + ")"); String objekDOC = FVALUE_DOC.Replace("'", "-"); MixHelper.InsertLog(logcodeDOC, objekDOC, 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")); }
public ActionResult Approval(int PROPOSAL_ID = 0, string PROPOSAL_PNPS_CODEZZ = "", int PROPOSAL_KOMTEK_ID = 0, int[] PROPOSAL_ICS_REF_ICS_ID = null) { var DataProposal = (from proposal in db.VIEW_PROPOSAL where proposal.PROPOSAL_ID == PROPOSAL_ID select proposal).SingleOrDefault(); var PROPOSAL_PNPS_CODE = db.Database.SqlQuery <string>("SELECT CAST(TO_CHAR (SYSDATE, 'YYYY') || '.' || KOMTEK_CODE || '.' || ( SELECT CAST ( ( CASE WHEN LENGTH (COUNT(PROPOSAL_ID) + 1) = 1 THEN '0' || CAST ( COUNT (PROPOSAL_ID) + 1 AS VARCHAR2 (255) ) ELSE CAST ( COUNT (PROPOSAL_ID) + 1 AS VARCHAR2 (255) ) END ) AS VARCHAR2 (255) ) PNPSCODE FROM TRX_PROPOSAL WHERE PROPOSAL_KOMTEK_ID = KOMTEK_ID ) AS VARCHAR2(255)) AS PNPSCODE FROM MASTER_KOMITE_TEKNIS WHERE KOMTEK_ID = " + PROPOSAL_KOMTEK_ID).SingleOrDefault(); string test = "SELECT CAST(TO_CHAR (SYSDATE, 'YYYY') || '.' || KOMTEK_CODE || '.' || ( SELECT CAST ( ( CASE WHEN LENGTH (COUNT(PROPOSAL_ID) + 1) = 1 THEN '0' || CAST ( COUNT (PROPOSAL_ID) + 1 AS VARCHAR2 (255) ) ELSE CAST ( COUNT (PROPOSAL_ID) + 1 AS VARCHAR2 (255) ) END ) AS VARCHAR2 (255) ) PNPSCODE FROM TRX_PROPOSAL WHERE PROPOSAL_KOMTEK_ID = KOMTEK_ID ) AS VARCHAR2(255)) AS PNPSCODE FROM MASTER_KOMITE_TEKNIS WHERE KOMTEK_ID = " + PROPOSAL_KOMTEK_ID; var USER_ID = Convert.ToInt32(Session["USER_ID"]); var PROPOSAL_PNPS_CODE_FIXER = DataProposal.PROPOSAL_CODE; var DATENOW = MixHelper.ConvertDateNow(); db.Database.ExecuteSqlCommand("UPDATE TRX_PROPOSAL SET PROPOSAL_STATUS = 3, PROPOSAL_STATUS_PROSES = 1,PROPOSAL_KOMTEK_ID = " + PROPOSAL_KOMTEK_ID + ", PROPOSAL_IS_POLLING = 0, PROPOSAL_POLLING_ID = NULL, PROPOSAL_UPDATE_DATE = " + DATENOW + ", PROPOSAL_UPDATE_BY = " + USER_ID + " WHERE PROPOSAL_ID = " + PROPOSAL_ID); var PROPOSAL_LOG_CODE = db.Database.SqlQuery <string>("SELECT PROPOSAL_LOG_CODE FROM TRX_PROPOSAL WHERE PROPOSAL_ID = " + PROPOSAL_ID).SingleOrDefault(); String objek1 = "UPDATE TRX_PROPOSAL SET PROPOSAL_STATUS = 3,PROPOSAL_KOMTEK_ID = " + PROPOSAL_KOMTEK_ID + ", PROPOSAL_STATUS_PROSES = 1, PROPOSAL_IS_POLLING = 0, PROPOSAL_POLLING_ID = NULL, PROPOSAL_UPDATE_DATE = " + DATENOW + ", PROPOSAL_UPDATE_BY = " + USER_ID + " WHERE PROPOSAL_ID = " + PROPOSAL_ID; MixHelper.InsertLog(PROPOSAL_LOG_CODE, objek1.Replace("'", "-"), 2); int APPROVAL_ID = MixHelper.GetSequence("TRX_PROPOSAL_APPROVAL"); db.Database.ExecuteSqlCommand("UPDATE TRX_PROPOSAL_APPROVAL SET APPROVAL_STATUS = 0 WHERE APPROVAL_PROPOSAL_ID = " + PROPOSAL_ID); db.Database.ExecuteSqlCommand("INSERT INTO TRX_PROPOSAL_APPROVAL (APPROVAL_ID,APPROVAL_PROPOSAL_ID,APPROVAL_TYPE,APPROVAL_DATE,APPROVAL_BY,APPROVAL_STATUS,APPROVAL_STATUS_PROPOSAL,APPROVAL_STATUS_SESSION) VALUES (" + APPROVAL_ID + "," + PROPOSAL_ID + ",1," + DATENOW + "," + USER_ID + ",1,2,1)"); db.Database.ExecuteSqlCommand("UPDATE TRX_MONITORING SET MONITORING_TGL_APP_MTPS = " + DATENOW + ", MONITORING_HASIL_APP_MTPS = 1 WHERE MONITORING_PROPOSAL_ID = " + PROPOSAL_ID); int LASTID = MixHelper.GetSequence("TRX_DOCUMENTS"); var TGL_SEKARANG = DateTime.Now.ToString("yyyyMMddHHmmss"); var DataTanggapan = db.Database.SqlQuery <VIEW_POLLING_DETAIL>("SELECT * FROM VIEW_POLLING_DETAIL WHERE POLLING_DETAIL_POLLING_ID = " + DataProposal.PROPOSAL_POLLING_ID + " ORDER BY POLLING_DETAIL_INPUT_TYPE ASC,POLLING_DETAIL_CREATE_DATE DESC").ToList(); string path = Server.MapPath("~/Upload/Dokumen/RANCANGAN_SNI/MTPS/" + PROPOSAL_PNPS_CODE_FIXER + "/"); string dataFormat = Server.MapPath("~/Format/Laporan/"); Stream stream = System.IO.File.OpenRead(dataFormat + "FORMAT_TANGGAPAN_PUBLIKASI_MTPS.docx"); Aspose.Words.Document Tanggapan = new Aspose.Words.Document(stream); ReplaceHelper helper = new ReplaceHelper(Tanggapan); helper.Replace("JudulPNPS", DataProposal.PROPOSAL_JUDUL_PNPS); DateTime dt = Convert.ToDateTime(DataProposal.POLLING_START_DATE); helper.Replace("TanggalJP", dt.ToString("dd/MM/yyyy")); helper.Replace("RuangLingkupPNPS", DataProposal.PROPOSAL_RUANG_LINGKUP); Paragraph paragraph = new Paragraph(Tanggapan); DocumentBuilder builder = new DocumentBuilder(Tanggapan); Aspose.Words.Font font = builder.Font; font.Bold = false; font.Color = System.Drawing.Color.Black; font.Italic = false; font.Name = "Calibri"; font.Size = 11; builder.MoveToDocumentEnd(); var number = 0; string html = "<table width='100%' border='1' bordercolor='#111111' cellpadding='2' style='border-collapse: collapse' cellpadding='0' cellspacing='0'>" + "<tr>" + "<td width='5%' style='text-align:center'><b>No</b></td>" + "<td width='15%' style='text-align:center'><b>Nama</b></td>" + "<td width='15%' style='text-align:center'><b>Tipe tanggapan</b></td>" + "<td width='65%' style='text-align:center'><b>Tanggapan</b></td>" + "</tr>"; foreach (var i in DataTanggapan) { number++; html += "<tr>" + "<td>" + number + "</td>" + "<td>" + i.USER_PUBLIC_NAMA + "</td>" + "<td>" + i.POLLING_DETAIL_INPUT_TYPE_NAME + "</td>" + "<td>" + i.POLLING_DETAIL_REASON + "</td>" + "</tr>"; } html += "</table>"; builder.InsertHtml(html); Tanggapan.Save(@"" + path + "DAFTAR_TANGGAPAN_PUBLIKASI_USULAN_PNPS_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + ".docx", Aspose.Words.SaveFormat.Docx); Tanggapan.Save(@"" + path + "DAFTAR_TANGGAPAN_PUBLIKASI_USULAN_PNPS_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + ".pdf", Aspose.Words.SaveFormat.Pdf); Tanggapan.Save(@"" + path + "DAFTAR_TANGGAPAN_PUBLIKASI_USULAN_PNPS_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + ".xml"); var LOGCODE_TANGGAPAN_MTPS = MixHelper.GetLogCode(); var FNAME_TANGGAPAN_MTPS = "DOC_ID,DOC_FOLDER_ID,DOC_RELATED_TYPE,DOC_RELATED_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_TANGGAPAN_MTPS = "'" + LASTID + "', " + "'10', " + "'1', " + "'" + PROPOSAL_ID + "', " + "'" + "(" + PROPOSAL_PNPS_CODE_FIXER + ") Daftar Tanggapan Publikasi Usulan PNPS" + "', " + "'Daftar Tanggapan Hasil Publikasi Usulan PNPS dengan Judul PNPS : " + DataProposal.PROPOSAL_JUDUL_PNPS + "', " + "'" + "/Upload/Dokumen/RANCANGAN_SNI/MTPS/" + PROPOSAL_PNPS_CODE_FIXER + "/" + "', " + "'" + "DAFTAR_TANGGAPAN_PUBLIKASI_USULAN_PNPS_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "" + "', " + "'DOCX', " + "'0', " + "'" + USER_ID + "', " + DATENOW + "," + "'1', " + "'" + LOGCODE_TANGGAPAN_MTPS + "'"; db.Database.ExecuteSqlCommand("INSERT INTO TRX_DOCUMENTS (" + FNAME_TANGGAPAN_MTPS + ") VALUES (" + FVALUE_TANGGAPAN_MTPS.Replace("''", "NULL") + ")"); String objekTanggapan = FVALUE_TANGGAPAN_MTPS.Replace("'", "-"); MixHelper.InsertLog(LOGCODE_TANGGAPAN_MTPS, objekTanggapan, 1); db.Database.ExecuteSqlCommand("UPDATE TRX_POLLING SET POLLING_IS_KUORUM = 1,POLLING_UPDATE_DATE = " + DATENOW + ", POLLING_UPDATE_BY = '" + USER_ID + "' WHERE POLLING_ID = " + DataProposal.PROPOSAL_POLLING_ID); 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 CreateRatek(HttpPostedFileBase NOTULEN, int PROPOSAL_ID = 0, int PROPOSAL_KOMTEK_ID = 0, int APPROVAL_TYPE = 0, string NO_RATEK = "", string TGL_RATEK = "") { var USER_ID = Convert.ToInt32(Session["USER_ID"]); var DATENOW = MixHelper.ConvertDateNow(); var DataProposal = (from proposal in db.VIEW_PROPOSAL where proposal.PROPOSAL_ID == PROPOSAL_ID select proposal).SingleOrDefault(); var PROPOSAL_PNPS_CODE_FIXER = DataProposal.PROPOSAL_PNPS_CODE; Stream STREAM_NOTULEN = NOTULEN.InputStream; byte[] APPDATA_NOTULEN = new byte[NOTULEN.ContentLength + 1]; STREAM_NOTULEN.Read(APPDATA_NOTULEN, 0, NOTULEN.ContentLength); string Extension_NOTULEN = Path.GetExtension(NOTULEN.FileName); int APPROVAL_ID = MixHelper.GetSequence("TRX_PROPOSAL_APPROVAL"); var VERSION_RATEK = db.Database.SqlQuery <decimal>("SELECT CAST(NVL(MAX(T1.PROPOSAL_RAPAT_VERSION),0) AS NUMBER)+1 AS PROPOSAL_RAPAT_VERSION FROM TRX_PROPOSAL_RAPAT T1 WHERE T1.PROPOSAL_RAPAT_PROPOSAL_ID = " + PROPOSAL_ID + " AND T1.PROPOSAL_RAPAT_PROPOSAL_STATUS = 6").SingleOrDefault(); if (Extension_NOTULEN.ToLower() == ".docx" || Extension_NOTULEN.ToLower() == ".doc") { Directory.CreateDirectory(Server.MapPath("~/Upload/Dokumen/RANCANGAN_SNI/RSNI3/" + PROPOSAL_PNPS_CODE_FIXER)); string path = Server.MapPath("~/Upload/Dokumen/RANCANGAN_SNI/RSNI3/" + PROPOSAL_PNPS_CODE_FIXER + "/"); Aspose.Words.Document doc = new Aspose.Words.Document(STREAM_NOTULEN); string filePathdoc = path + "NOTULEN_TAS_Ver" + VERSION_RATEK + "_" + PROPOSAL_PNPS_CODE_FIXER + ".docx"; string filePathpdf = path + "NOTULEN_TAS_Ver" + VERSION_RATEK + "_" + PROPOSAL_PNPS_CODE_FIXER + ".pdf"; string filePathxml = path + "NOTULEN_TAS_Ver" + VERSION_RATEK + "_" + PROPOSAL_PNPS_CODE_FIXER + ".xml"; doc.Save(@"" + filePathdoc, Aspose.Words.SaveFormat.Docx); doc.Save(@"" + filePathpdf, Aspose.Words.SaveFormat.Pdf); doc.Save(@"" + filePathxml); int LASTID_NOTULEN = MixHelper.GetSequence("TRX_DOCUMENTS"); var LOGCODE_NOTULEN = MixHelper.GetLogCode(); var FNAME_NOTULEN = "DOC_ID,DOC_FOLDER_ID,DOC_RELATED_TYPE,DOC_RELATED_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_NOTULEN = "'" + LASTID_NOTULEN + "', " + "'14', " + "'10', " + "'" + PROPOSAL_ID + "', " + "'" + "(" + PROPOSAL_PNPS_CODE_FIXER + ") Notulen TAS Ver " + VERSION_RATEK + "', " + "'Notulen Tenaga Ahli Standarisasi Ver " + VERSION_RATEK + " " + PROPOSAL_PNPS_CODE_FIXER + "', " + "'" + "/Upload/Dokumen/RANCANGAN_SNI/RSNI3/" + PROPOSAL_PNPS_CODE_FIXER + "/" + "', " + "'" + "NOTULEN_TAS_Ver" + VERSION_RATEK + "_" + PROPOSAL_PNPS_CODE_FIXER + "" + "', " + "'" + Extension_NOTULEN.ToUpper().Replace(".", "") + "', " + "'0', " + "'" + USER_ID + "', " + DATENOW + "," + "'1', " + "'" + LOGCODE_NOTULEN + "'"; db.Database.ExecuteSqlCommand("INSERT INTO TRX_DOCUMENTS (" + FNAME_NOTULEN + ") VALUES (" + FVALUE_NOTULEN.Replace("''", "NULL") + ")"); String objekTanggapan = FVALUE_NOTULEN.Replace("'", "-"); MixHelper.InsertLog(LOGCODE_NOTULEN, objekTanggapan, 1); } else { Directory.CreateDirectory(Server.MapPath("~/Upload/Dokumen/RANCANGAN_SNI/RSNI3/" + PROPOSAL_PNPS_CODE_FIXER)); string path = Server.MapPath("~/Upload/Dokumen/RANCANGAN_SNI/RSNI3/" + PROPOSAL_PNPS_CODE_FIXER + "/"); NOTULEN.SaveAs(path + "BERITA_ACARA_Ver" + VERSION_RATEK + "_" + PROPOSAL_PNPS_CODE_FIXER + Extension_NOTULEN.ToUpper()); int LASTID_NOTULEN = MixHelper.GetSequence("TRX_DOCUMENTS"); var LOGCODE_NOTULEN = MixHelper.GetLogCode(); var FNAME_NOTULEN = "DOC_ID,DOC_FOLDER_ID,DOC_RELATED_TYPE,DOC_RELATED_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_NOTULEN = "'" + LASTID_NOTULEN + "', " + "'14', " + "'10', " + "'" + PROPOSAL_ID + "', " + "'" + "(" + PROPOSAL_PNPS_CODE_FIXER + ") Notulen TAS Ver " + VERSION_RATEK + "', " + "'Notulen Tenaga Ahli Standarisasi Ver " + VERSION_RATEK + " " + PROPOSAL_PNPS_CODE_FIXER + "', " + "'" + "/Upload/Dokumen/RANCANGAN_SNI/RSNI3/" + PROPOSAL_PNPS_CODE_FIXER + "/" + "', " + "'" + "NOTULEN_TAS_Ver" + VERSION_RATEK + "_" + PROPOSAL_PNPS_CODE_FIXER + "" + "', " + "'" + Extension_NOTULEN.ToUpper().Replace(".", "") + "', " + "'0', " + "'" + USER_ID + "', " + DATENOW + "," + "'1', " + "'" + LOGCODE_NOTULEN + "'"; db.Database.ExecuteSqlCommand("INSERT INTO TRX_DOCUMENTS (" + FNAME_NOTULEN + ") VALUES (" + FVALUE_NOTULEN.Replace("''", "NULL") + ")"); String objekTanggapan = FVALUE_NOTULEN.Replace("'", "-"); MixHelper.InsertLog(LOGCODE_NOTULEN, objekTanggapan, 1); } TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil Disimpan"; return(RedirectToAction("Index")); }
public ActionResult Approval(int PROPOSAL_ID = 0, int PROPOSAL_KOMTEK_ID = 0, int[] PROPOSAL_ICS_REF_ICS_ID = null) { var USER_ID = Session["USER_ID"]; var logcode = db.Database.SqlQuery <String>("SELECT PROPOSAL_LOG_CODE FROM TRX_PROPOSAL WHERE PROPOSAL_ID = " + PROPOSAL_ID).SingleOrDefault(); var TANGGAL_SKR = MixHelper.ConvertDateNow(); var year_now = DateTime.Now.Year; var LOGCODE_POLLING = MixHelper.GetLogCode(); int LASTID_POLLING = MixHelper.GetSequence("TRX_POLLING"); var LAST_POLLING_VERSION = db.Database.SqlQuery <int>("SELECT NVL(CAST(MAX(POLLING_VERSION) AS INT),1) FROM TRX_POLLING WHERE POLLING_TYPE = 2 AND POLLING_PROPOSAL_ID = " + PROPOSAL_ID).SingleOrDefault(); var POLLING_IS_EXIST = db.Database.SqlQuery <TRX_POLLING>("SELECT * FROM TRX_POLLING WHERE POLLING_VERSION = " + LAST_POLLING_VERSION + " AND POLLING_TYPE = 2 AND POLLING_PROPOSAL_ID = " + PROPOSAL_ID).SingleOrDefault(); var JML_HARI = db.Database.SqlQuery <SYS_CONFIG>("SELECT * FROM SYS_CONFIG WHERE CONFIG_ID = 8").SingleOrDefault(); if (POLLING_IS_EXIST == null) { var fname = "POLLING_ID,POLLING_PROPOSAL_ID,POLLING_TYPE,POLLING_START_DATE,POLLING_END_DATE,POLLING_VERSION,POLLING_CREATE_BY,POLLING_CREATE_DATE,POLLING_STATUS,POLLING_LOGCODE"; var fvalue = "'" + LASTID_POLLING + "', " + "'" + PROPOSAL_ID + "', " + "'" + 2 + "', " + "TO_DATE(SYSDATE), " + "TO_DATE(SYSDATE)+" + ((JML_HARI != null) ? JML_HARI.CONFIG_VALUE : "14") + ", " + "'" + LAST_POLLING_VERSION + "', " + "'" + USER_ID + "'," + TANGGAL_SKR + "," + "'1', " + "'" + LOGCODE_POLLING + "'"; db.Database.ExecuteSqlCommand("INSERT INTO TRX_POLLING (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")"); String objek2 = fvalue.Replace("'", "-"); MixHelper.InsertLog(logcode, objek2, 1); } var NEW_LASTID_POLLING = db.Database.SqlQuery <int>("SELECT POLLING_ID FROM TRX_POLLING WHERE POLLING_PROPOSAL_ID =" + PROPOSAL_ID + " AND POLLING_VERSION = " + LAST_POLLING_VERSION).SingleOrDefault(); var PROPOSAL_PNPS_CODE = db.Database.SqlQuery <string>("SELECT CAST(TO_CHAR (SYSDATE, 'YYYY') || '.' || KOMTEK_CODE || '.' || ( SELECT CAST ( ( CASE WHEN LENGTH (COUNT(PROPOSAL_ID) + 1) = 1 THEN '0' || CAST ( COUNT (PROPOSAL_ID) + 1 AS VARCHAR2 (255) ) ELSE CAST ( COUNT (PROPOSAL_ID) + 1 AS VARCHAR2 (255) ) END ) AS VARCHAR2 (255) ) PNPSCODE FROM TRX_PROPOSAL WHERE PROPOSAL_KOMTEK_ID = KOMTEK_ID ) AS VARCHAR2(255)) AS PNPSCODE FROM MASTER_KOMITE_TEKNIS WHERE KOMTEK_ID = " + PROPOSAL_KOMTEK_ID).SingleOrDefault(); db.Database.ExecuteSqlCommand("UPDATE TRX_PROPOSAL SET PROPOSAL_PNPS_CODE = (CASE WHEN PROPOSAL_TYPE = 2 THEN '" + PROPOSAL_PNPS_CODE + "' ELSE PROPOSAL_PNPS_CODE END), PROPOSAL_KOMTEK_ID = " + PROPOSAL_KOMTEK_ID + ", PROPOSAL_STATUS = 2, PROPOSAL_IS_POLLING = 1,PROPOSAL_POLLING_ID = " + NEW_LASTID_POLLING + ", PROPOSAL_UPDATE_DATE = " + TANGGAL_SKR + ", PROPOSAL_UPDATE_BY = " + USER_ID + " WHERE PROPOSAL_ID = " + PROPOSAL_ID); String objek = "PROPOSAL_KOMTEK_ID = " + PROPOSAL_KOMTEK_ID + ", PROPOSAL_STATUS = 2, PROPOSAL_IS_POLLING = 1, PROPOSAL_POLLING_ID = " + NEW_LASTID_POLLING + ", PROPOSAL_UPDATE_DATE = " + TANGGAL_SKR + ", PROPOSAL_UPDATE_BY = " + USER_ID; MixHelper.InsertLog(logcode, objek.Replace("'", "-"), 2); if (PROPOSAL_ICS_REF_ICS_ID != null) { foreach (var i in PROPOSAL_ICS_REF_ICS_ID) { int PROPOSAL_ICS_REF_ID = MixHelper.GetSequence("TRX_PROPOSAL_ICS_REF"); db.Database.ExecuteSqlCommand("INSERT INTO TRX_PROPOSAL_ICS_REF (PROPOSAL_ICS_REF_ID,PROPOSAL_ICS_REF_PROPOSAL_ID,PROPOSAL_ICS_REF_ICS_ID)VALUES(" + PROPOSAL_ICS_REF_ID + "," + PROPOSAL_ID + "," + i + ")"); } } int lastid = MixHelper.GetSequence("TRX_PROPOSAL_APPROVAL"); db.Database.ExecuteSqlCommand("UPDATE TRX_PROPOSAL_APPROVAL SET APPROVAL_STATUS = 0 WHERE APPROVAL_PROPOSAL_ID = " + PROPOSAL_ID); db.Database.ExecuteSqlCommand("INSERT INTO TRX_PROPOSAL_APPROVAL (APPROVAL_ID,APPROVAL_PROPOSAL_ID,APPROVAL_TYPE,APPROVAL_DATE,APPROVAL_BY,APPROVAL_STATUS,APPROVAL_STATUS_PROPOSAL,APPROVAL_STATUS_SESSION) VALUES (" + lastid + "," + PROPOSAL_ID + ",1," + TANGGAL_SKR + "," + USER_ID + ",1,1,1)"); db.Database.ExecuteSqlCommand("UPDATE TRX_MONITORING SET MONITORING_TGL_MTPS = " + TANGGAL_SKR + " WHERE MONITORING_PROPOSAL_ID = " + PROPOSAL_ID); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil Disimpan"; return(Json(new { result = true }, JsonRequestBehavior.AllowGet)); //return RedirectToAction("Index"); }
public ActionResult Edit(PORTAL_NEWS news) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); var datenow = MixHelper.ConvertDateNow(); var status = "1"; var link = "http://localhost:4878/Upload/Dokumen/LAINNYA/news/"; string path = Server.MapPath("~/Upload/Dokumen/LAINNYA/news/"); HttpPostedFileBase file_att = Request.Files["Image"]; var file_name_att = ""; var filePath = ""; var location = "Upload/Dokumen/LAINNYA/news/"; var update = ""; string lampirananggotapath = file_att.FileName; if (lampirananggotapath.Trim() != "") { lampirananggotapath = Path.GetFileNameWithoutExtension(file_att.FileName); string fileExtension = Path.GetExtension(file_att.FileName); file_name_att = "IMAGE_NEWS_" + news.NEWS_ID + fileExtension; filePath = path + file_name_att; file_att.SaveAs(filePath); update = " NEWS_TITLE = '" + news.NEWS_TITLE + "'," + " NEWS_CONTENTS = '" + news.NEWS_CONTENTS + "'," + " NEWS_SUMBER = '" + news.NEWS_SUMBER + "'," + " NEWS_BRIEF_NEWS = '" + news.NEWS_BRIEF_NEWS + "'," + " NEWS_TAG = '" + news.NEWS_TAG + "'," + " NEWS_PATH_IMAGE = '" + location + file_name_att + "'," + " NEWS_LINK_IMAGE = '" + link + file_name_att + "'," + " NEWS_UPDATE_BY = '" + UserId + "'," + " NEWS_UPDATE_DATE = " + datenow + "," + " NEWS_LOG_CODE = '" + logcode + "', " + " NEWS_STATUS = '" + status + "'"; } else { update = " NEWS_TITLE = '" + news.NEWS_TITLE + "'," + " NEWS_CONTENTS = '" + news.NEWS_CONTENTS + "'," + " NEWS_SUMBER = '" + news.NEWS_SUMBER + "'," + " NEWS_BRIEF_NEWS = '" + news.NEWS_BRIEF_NEWS + "'," + " NEWS_TAG = '" + news.NEWS_TAG + "'," + " NEWS_UPDATE_BY = '" + UserId + "'," + " NEWS_UPDATE_DATE = " + datenow + "," + " NEWS_LOG_CODE = '" + logcode + "', " + " NEWS_STATUS = '" + status + "'"; } var clause = "where NEWS_ID = " + news.NEWS_ID; //return Json(new { query = "UPDATE PORTAL_NEWS SET " + update.Replace("''", "NULL") + " " + clause }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("UPDATE PORTAL_NEWS 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")); }
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_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_MAINTENANCES mtn, TRX_MAINTENANCE_DETAILS mtd, string MAINTENANCE_KOMTEK2 = "") { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("TRX_MAINTENANCES"); var datenow = MixHelper.ConvertDateNow(); var id_sni = Convert.ToString(mtd.MAINTENANCE_DETAIL_SNI_ID); var komtek_id = ""; if (MAINTENANCE_KOMTEK2 != "-") { komtek_id = MAINTENANCE_KOMTEK2; } else if (MAINTENANCE_KOMTEK2 == "-") { komtek_id = mtn.MAINTENANCE_KOMTEK; } //return Content(komtek_id); string pathnya = Server.MapPath("~/Upload/Dokumen/FORM_KAJI_ULANG/"); HttpPostedFileBase file_paten = Request.Files["MAINTENANCE_DETAIL_KJ_ULG_NAME"]; var file_name_paten = ""; var filePath_paten = ""; var fileExtension_paten = ""; if (file_paten != null) { //Check whether Directory (Folder) exists. if (!Directory.Exists(pathnya)) { //If Directory (Folder) does not exists. Create it. Directory.CreateDirectory(pathnya); } string lampiranregulasipath = file_paten.FileName; if (lampiranregulasipath.Trim() != "") { lampiranregulasipath = Path.GetFileNameWithoutExtension(file_paten.FileName); fileExtension_paten = Path.GetExtension(file_paten.FileName); file_name_paten = "FORM_KAJI_ULANG_PEMELIHARAAN_IDM_" + lastid + fileExtension_paten; filePath_paten = pathnya + file_name_paten.Replace(" ", "_"); file_paten.SaveAs(filePath_paten); } } //if (Convert.ToInt32(form["count_rows"]) > 0) //{ DateTime MAINTENANCE_DATE_a = Convert.ToDateTime(mtn.MAINTENANCE_DATE); var MAINTENANCE_DATE = "TO_DATE('" + MAINTENANCE_DATE_a.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss')"; //KOMTEK_BIDANG_ID,KOMTEK_INSTANSI_ID, var fname = "MAINTENANCE_ID,MAINTENANCE_DOC_NUMBER,MAINTENANCE_KOMTEK,MAINTENANCE_CREATE_BY,MAINTENANCE_CREATE_DATE,MAINTENANCE_STATUS"; var fvalue = "'" + lastid + "', " + "'" + mtn.MAINTENANCE_DOC_NUMBER + "'," + "'" + komtek_id + "', " + "'" + UserId + "'," + datenow + "," + "1"; //return Json(new { query = "INSERT INTO MASTER_KOMITE_TEKNIS (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("INSERT INTO TRX_MAINTENANCES (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")"); String objek = fvalue.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); //for (var a = 0; a < Convert.ToInt32(form["count_rows"]); a++) //{ int lastid_detail = MixHelper.GetSequence("TRX_MAINTENANCE_DETAILS"); DateTime MAINTENANCE_DETAIL_REV_DATE_ = Convert.ToDateTime(mtd.MAINTENANCE_DETAIL_REV_DATE); var MAINTENANCE_DETAIL_REV_DATE = "TO_DATE('" + MAINTENANCE_DETAIL_REV_DATE_.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss')"; DateTime MAINTENANCE_DETAIL_REPORT_DATE_ = Convert.ToDateTime(mtd.MAINTENANCE_DETAIL_REPORT_DATE); var MAINTENANCE_DETAIL_REPORT_DATE = "TO_DATE('" + MAINTENANCE_DETAIL_REPORT_DATE_.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss')"; var fnameS = ""; var fvalueS = ""; if (mtd.MAINTENANCE_DETAIL_KJ_ULG_NAME != null) { fnameS = "MAINTENANCE_DETAIL_ID,MAINTENANCE_DETAIL_MTN_ID,MAINTENANCE_DETAIL_SNI_ID,MAINTENANCE_DETAIL_REV_DATE,MAINTENANCE_DETAIL_RESULT,MAINTENANCE_DETAIL_REPORT_DATE,MAINTENANCE_DETAIL_KJ_ULG_LOC,MAINTENANCE_DETAIL_KJ_ULG_NAME,MAINTENANCE_DETAIL_NO_SURAT"; fvalueS = "'" + lastid_detail + "', " + "'" + lastid + "', " + "'" + mtd.MAINTENANCE_DETAIL_SNI_ID + "', " + MAINTENANCE_DETAIL_REV_DATE + "," + "'" + mtd.MAINTENANCE_DETAIL_RESULT + "', " + MAINTENANCE_DETAIL_REPORT_DATE + "," + "'/Upload/Dokumen/FORM_KAJI_ULANG/'," + "'" + file_name_paten.Replace(" ", "_") + "'," + "'" + mtd.MAINTENANCE_DETAIL_NO_SURAT + "'"; } else { fnameS = "MAINTENANCE_DETAIL_ID,MAINTENANCE_DETAIL_MTN_ID,MAINTENANCE_DETAIL_SNI_ID,MAINTENANCE_DETAIL_REV_DATE,MAINTENANCE_DETAIL_RESULT,MAINTENANCE_DETAIL_REPORT_DATE,MAINTENANCE_DETAIL_NO_SURAT"; fvalueS = "'" + lastid_detail + "', " + "'" + lastid + "', " + "'" + mtd.MAINTENANCE_DETAIL_SNI_ID + "', " + MAINTENANCE_DETAIL_REV_DATE + "," + "'" + mtd.MAINTENANCE_DETAIL_RESULT + "', " + MAINTENANCE_DETAIL_REPORT_DATE + "," + "'" + mtd.MAINTENANCE_DETAIL_NO_SURAT + "'"; } //return Json(new { query = "INSERT INTO MASTER_KOMITE_TEKNIS (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("INSERT INTO TRX_MAINTENANCE_DETAILS (" + fnameS + ") VALUES (" + fvalueS.Replace("''", "NULL") + ")"); //update trx_sni db.Database.ExecuteSqlCommand("UPDATE TRX_SNI SET SNI_MAINTENANCE_STS = '1' WHERE SNI_ID = " + id_sni); //} TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil Disimpan"; //} //else //{ // TempData["Notifikasi"] = 2; // TempData["NotifikasiText"] = "Data Gagal Disimpan"; //} return(RedirectToAction("Index")); }
public ActionResult Detailusulanpublic(T_MASTER_KOMITE_TEKNIS tmkt) { VIEW_T_KOMTEK vtk = db.VIEW_T_KOMTEK.SingleOrDefault(t => t.T_KOMTEK_ID == tmkt.T_KOMTEK_ID); if (vtk == null) { return(HttpNotFound()); } string query_update_group = "UPDATE T_MASTER_KOMITE_TEKNIS SET T_KOMTEK_STATUS = 1 WHERE T_KOMTEK_ID = '" + tmkt.T_KOMTEK_ID + "'"; db.Database.ExecuteSqlCommand(query_update_group); var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("MASTER_KOMITE_TEKNIS"); var datenow = MixHelper.ConvertDateNow(); //int t_komtek_code = (db.Database.SqlQuery<int>("SELECT SUBSTR (MAX(MK.KOMTEK_CODE), 1, 2)+1 AS CODE_AWAL FROM MASTER_KOMITE_TEKNIS MK WHERE MK.KOMTEK_PARENT_CODE = '0'").SingleOrDefault()) + 1; DateTime dates = Convert.ToDateTime(tmkt.T_KOMTEK_TANGGAL_PEMBENTUKAN); var date = "TO_DATE('" + dates.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss')"; var fname = "KOMTEK_ID,KOMTEK_PARENT_CODE,KOMTEK_CODE,KOMTEK_BIDANG_ID,KOMTEK_INSTANSI_ID,KOMTEK_NAME,KOMTEK_SEKRETARIAT,KOMTEK_ADDRESS,KOMTEK_PHONE,KOMTEK_FAX,KOMTEK_EMAIL,KOMTEK_SK_PENETAPAN,KOMTEK_TANGGAL_PEMBENTUKAN,KOMTEK_DESCRIPTION,KOMTEK_CREATE_BY,KOMTEK_CREATE_DATE,KOMTEK_LOG_CODE,KOMTEK_TEMP_ID,KOMTEK_STATUS"; var fvalue = "'" + lastid + "', " + "'" + vtk.T_KOMTEK_PARENT_CODE + "', " + "'" + tmkt.T_KOMTEK_CODE + "', " + "'" + vtk.T_KOMTEK_BIDANG_ID + "', " + "'" + vtk.T_KOMTEK_INSTANSI_ID + "'," + "'" + vtk.T_KOMTEK_NAME + "'," + "'" + vtk.T_KOMTEK_SEKRETARIAT + "'," + "'" + vtk.T_KOMTEK_ADDRESS + "'," + "'" + vtk.T_KOMTEK_PHONE + "'," + "'" + vtk.T_KOMTEK_FAX + "'," + "'" + vtk.T_KOMTEK_EMAIL + "'," + "'" + tmkt.T_KOMTEK_SK_PENETAPAN + "'," + date + "," + "'" + vtk.T_KOMTEK_DESCRIPTION + "'," + "'" + UserId + "'," + datenow + "," + "'" + logcode + "'," + "'" + vtk.T_KOMTEK_ID + "'," + "1"; //return Json(new { query = "INSERT INTO MASTER_KOMITE_TEKNIS (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet); db.Database.ExecuteSqlCommand("INSERT INTO MASTER_KOMITE_TEKNIS (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")"); //var logId = AuditTrails.GetLogId(); String objek = fvalue.Replace("'", "-"); MixHelper.InsertLog(logcode, objek, 1); ViewData["komtek_ics"] = (from t in db.VIEW_T_KOMTEK_ICS where t.T_KOMTEK_ICS_KOMTEK_ID == vtk.T_KOMTEK_ID && t.T_KOMTEK_ICS_STATUS == 1 select t).ToList(); foreach (var a in ViewBag.komtek_ics) { int lastid_mki = MixHelper.GetSequence("MASTER_KOMTEK_ICS"); 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 + "," + a.T_KOMTEK_ICS_ICS_ID + "," + UserId + "," + datenow + ",1,'" + logcode + "')"; db.Database.ExecuteSqlCommand(query_update); } var linkend = ""; if (vtk.T_KOMTEK_PARENT_CODE == "0") { linkend = "../Komtek/CreateAnggota"; } else { linkend = "../Subkomtek/CreateAnggota"; } TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Data Berhasil di setujui"; return(RedirectToAction(linkend + "/" + lastid)); }