public ActionResult EditJajakPendapat(TRX_POLLING_DETAILS input, VIEW_PROPOSAL VP, string jawaban = "") { if (Session["Captcha"] == null || Session["Captcha"].ToString() != jawaban) { var MsgError = "Jawaban Captcha Salah / Kosong"; TempData["isError"] = 1; TempData["MessageError"] = MsgError; return(RedirectToAction("JajakPendapat/" + input.POLLING_DETAIL_POLLING_ID)); } else { var GetIP = db.Database.SqlQuery <SYS_CONFIG>("SELECT * FROM SYS_CONFIG WHERE CONFIG_ID = 12").FirstOrDefault(); var GetUser = db.Database.SqlQuery <SYS_CONFIG>("SELECT * FROM SYS_CONFIG WHERE CONFIG_ID = 13").FirstOrDefault(); var GetPassword = db.Database.SqlQuery <SYS_CONFIG>("SELECT * FROM SYS_CONFIG WHERE CONFIG_ID = 14").FirstOrDefault(); var GetPath = db.Database.SqlQuery <SYS_CONFIG>("SELECT * FROM SYS_CONFIG WHERE CONFIG_ID = 15").FirstOrDefault(); var TGL_SEKARANG = DateTime.Now.ToString("yyyyMMddHHmmss"); string path = ""; string filePathpdf = ""; string dir = ""; if (input.POLLING_DETAIL_FILE_PATH != "" && input.POLLING_DETAIL_FILE_PATH != null) { dir = input.POLLING_DETAIL_FILE_PATH; } else { dir = "/Upload/DokPolling/POLLING_" + VP.PROPOSAL_ID + "_" + TGL_SEKARANG + ".pdf"; } HttpPostedFileBase file4 = Request.Files["POLLING_FILE"]; if (file4.ContentLength > 0) { Directory.CreateDirectory(GetPath.CONFIG_VALUE + "/Upload/DokPolling"); path = GetPath.CONFIG_VALUE + "" + dir; 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() == ".pdf") { Aspose.Pdf.Document pdf = new Aspose.Pdf.Document(stremdokumen); //Aspose.Words.Document docx = new Aspose.Words.Document(stremdokumen); filePathpdf = path; pdf.Save(@"" + filePathpdf, Aspose.Pdf.SaveFormat.Pdf); } } using (OracleConnection con = new OracleConnection("Data Source=" + GetIP.CONFIG_VALUE + ";User ID=" + GetUser.CONFIG_VALUE + ";PASSWORD="******";")) { con.Open(); using (OracleCommand cmd = new OracleCommand()) { var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); var datenow = MixHelper.ConvertDateNow(); var updatequery = "UPDATE TRX_POLLING_DETAILS SET " + "POLLING_DETAIL_REASON = :parameter, " + "POLLING_DETAIL_UPDATE_BY = '" + UserId + "', " + "POLLING_DETAIL_FILE_PATH = '" + dir + "', " + "POLLING_DETAIL_UPDATE_DATE = " + datenow + " WHERE POLLING_DETAIL_ID = '" + input.POLLING_DETAIL_ID + "'"; //return Json(new{sas =updatequery },JsonRequestBehavior.AllowGet); //db.Database.ExecuteSqlCommand(updatequery); cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = updatequery; OracleParameter oracleParameterClob = new OracleParameter(); oracleParameterClob.OracleDbType = OracleDbType.Clob; //1 million long string oracleParameterClob.Value = input.POLLING_DETAIL_REASON; cmd.Parameters.Add(oracleParameterClob); cmd.ExecuteNonQuery(); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Terima kasih, pendapat anda berhasil di simpan."; } con.Close(); return(RedirectToAction("JajakPendapat/" + input.POLLING_DETAIL_POLLING_ID)); } } }
public ParNomor GenerateNomor(VIEW_PROPOSAL DataProposal = null) { string query = ""; string NomorQuery = ""; string Nomor = ""; string NomorThn = ""; string YearsNow = DateTime.Now.Year.ToString(); var DataLogbook = (from lb in db.MASTER_LOGBOOK select lb).SingleOrDefault(); string forbiddenNomor = DataLogbook.LOGBOOK_FORBIDDEN_NOMOR; string[] fNomor = forbiddenNomor.Split(','); string lastLogNomor = Convert.ToString(Convert.ToInt32(DataLogbook.LOGBOOK_NOMOR) + 1); if (DataProposal.PROPOSAL_JENIS_PERUMUSAN == 1 || DataProposal.PROPOSAL_JENIS_PERUMUSAN == 2) { if (DataProposal.PROPOSAL_JALUR == 2 && DataProposal.PROPOSAL_JENIS_ADOPSI == 1) { query = @"SELECT * FROM ( SELECT REGEXP_SUBSTR ( TP.PROPOSAL_ADOPSI_NOMOR_JUDUL, '[^:]+', 1, 1 ) AS nomor FROM TRX_PROPOSAL_ADOPSI TP WHERE TP.PROPOSAL_ADOPSI_PROPOSAL_ID = " + DataProposal.PROPOSAL_ID + @" AND TP.PROPOSAL_ADOPSI_NOMOR_JUDUL LIKE '%:%' ORDER BY TP.PROPOSAL_ADOPSI_ID ASC ) WHERE ROWNUM = 1" ; NomorQuery = db.Database.SqlQuery <string>("" + query + "").SingleOrDefault(); if (NomorQuery != null) { NomorThn = NomorQuery; Nomor = Convert.ToString(Convert.ToInt32(lastLogNomor) - 1); } else { foreach (string Res in fNomor) { if (Convert.ToInt32(Res) >= Convert.ToInt32(lastLogNomor)) { if (Convert.ToInt32(Res) != Convert.ToInt32(lastLogNomor)) { break; } else { lastLogNomor = Convert.ToString(Convert.ToInt32(lastLogNomor) + 1); } } } Nomor = lastLogNomor; NomorThn = lastLogNomor; } } else { foreach (string Res in fNomor) { if (Convert.ToInt32(Res) >= Convert.ToInt32(lastLogNomor)) { if (Convert.ToInt32(Res) != Convert.ToInt32(lastLogNomor)) { break; } else { lastLogNomor = Convert.ToString(Convert.ToInt32(lastLogNomor) + 1); } } } Nomor = lastLogNomor; NomorThn = lastLogNomor; //Nomor = Convert.ToString(DataProposal.PROPOSAL_ID); } var result = new ParNomor { nomor = Nomor, nomorThn = NomorThn + ":" + YearsNow }; return(result); //return Nomor + ":" + YearsNow; } else if (DataProposal.PROPOSAL_JENIS_PERUMUSAN == 5) { NomorThn = Convert.ToString(DataProposal.PROPOSAL_TERJEMAHAN_NOMOR); Nomor = Convert.ToString(Convert.ToInt32(lastLogNomor) - 1); var result = new ParNomor { nomor = Nomor, nomorThn = NomorThn }; return(result); //return Nomor; } else { foreach (string Res in fNomor) { if (Convert.ToInt32(Res) >= Convert.ToInt32(lastLogNomor)) { if (Convert.ToInt32(Res) != Convert.ToInt32(lastLogNomor)) { break; } else { lastLogNomor = Convert.ToString(Convert.ToInt32(lastLogNomor) + 1); } } } Nomor = lastLogNomor; NomorThn = lastLogNomor; var result = new ParNomor { nomor = Nomor, nomorThn = NomorThn + ":" + YearsNow }; return(result); //return Nomor + ":" + YearsNow; } }