public ActionResult Create(TRX_PROPOSAL tp, int[] PROPOSAL_ID) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); var datenow = MixHelper.ConvertDateNow(); var date_now = DateTime.Now.ToString("dd_MM_yyyy_hh_mm"); //return Json(new { total_count = date }, JsonRequestBehavior.AllowGet); if (PROPOSAL_ID.Count() > 0) { string path = Server.MapPath("~/Upload/Dokumen/PEMBATALAN/"); HttpPostedFileBase file_att = Request.Files["PROPOSAL_BATAL_ATTACHMENT"]; var file_name_att = ""; var filePath = ""; if (file_att != null) { string attach_batal = file_att.FileName; if (attach_batal.Trim() != "") { attach_batal = Path.GetFileNameWithoutExtension(file_att.FileName); string fileExtension = Path.GetExtension(file_att.FileName); file_name_att = "Attachment_Batal_" + date_now + "" + fileExtension; filePath = path + file_name_att; file_att.SaveAs(filePath); } } foreach (var PID in PROPOSAL_ID) { var update = " PROPOSAL_IS_BATAL = 1," + " PROPOSAL_KET_BATAL = '" + tp.PROPOSAL_KET_BATAL + "'," + " PROPOSAL_NO_SURAT_PEMBATALAN = '" + tp.PROPOSAL_NO_SURAT_PEMBATALAN + "'," + " PROPOSAL_BATAL_ATTACHMENT = '" + file_name_att + "'," + " PROPOSAL_UPDATE_DATE =" + datenow + "," + " PROPOSAL_UPDATE_BY ='" + UserId + "'"; var clausess = "where PROPOSAL_ID = " + PID; db.Database.ExecuteSqlCommand("UPDATE TRX_PROPOSAL SET " + update.Replace("''", "NULL") + " " + clausess); //return Json(new { total_count = "UPDATE TRX_PROPOSAL SET " + update.Replace("''", "NULL") + " " + clausess }, JsonRequestBehavior.AllowGet); } } TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Proposal telah dibatalkan"; 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")); }