public ActionResult cekdata(TRX_POLLING_DETAILS form) { int status = 0; int row_id = 0; var UserId = Session["USER_ID"]; row_id = db.Database.SqlQuery <int>("SELECT POLLING_DETAIL_ID FROM TRX_POLLING_DETAILS WHERE POLLING_DETAIL_POLLING_ID = " + form.POLLING_DETAIL_POLLING_ID + " AND POLLING_DETAIL_PASAL = '" + form.POLLING_DETAIL_PASAL + "' AND POLLING_DETAIL_OPTION = " + form.POLLING_DETAIL_OPTION + " AND POLLING_DETAIL_CREATE_BY =" + UserId).SingleOrDefault(); status = db.Database.SqlQuery <int>("SELECT COUNT(POLLING_DETAIL_ID) AS JML_POLL FROM TRX_POLLING_DETAILS WHERE POLLING_DETAIL_POLLING_ID = " + form.POLLING_DETAIL_POLLING_ID + " AND POLLING_DETAIL_PASAL = '" + form.POLLING_DETAIL_PASAL + "' AND POLLING_DETAIL_OPTION = " + form.POLLING_DETAIL_OPTION + " AND POLLING_DETAIL_CREATE_BY =" + UserId).SingleOrDefault(); return(Json(new { status = status, row_id = row_id, query = "SELECT COUNT(POLLING_DETAIL_ID) AS JML_POLL FROM TRX_POLLING_DETAILS WHERE POLLING_DETAIL_POLLING_ID = " + form.POLLING_DETAIL_POLLING_ID + " AND POLLING_DETAIL_PASAL = '" + form.POLLING_DETAIL_PASAL + "' AND POLLING_DETAIL_OPTION = " + form.POLLING_DETAIL_OPTION + " AND POLLING_DETAIL_CREATE_BY =" + UserId }, JsonRequestBehavior.AllowGet)); }
public ActionResult Comment(TRX_POLLING_DETAILS input, VIEW_POLLING VP, FormCollection form) { 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 = ""; HttpPostedFileBase file4 = Request.Files["POLLING_FILE"]; if (file4.ContentLength > 0) { Directory.CreateDirectory(GetPath.CONFIG_VALUE + "/Upload/DokPolling"); path = GetPath.CONFIG_VALUE + "/Upload/DokPolling/"; 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 + "POLLING_" + VP.PROPOSAL_ID + "_" + TGL_SEKARANG + ".pdf"; 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 pathnya = "/Upload/DokPolling/POLLING_" + VP.PROPOSAL_ID + "_" + TGL_SEKARANG + ".pdf"; var UserId = Session["USER_ID"]; var logcode = MixHelper.GetLogCode(); int lastid = MixHelper.GetSequence("TRX_POLLING_DETAILS"); var datenow = MixHelper.ConvertDateNow(); var year_now = DateTime.Now.Year; var fname = "POLLING_DETAIL_ID,POLLING_DETAIL_POLLING_ID,POLLING_DETAIL_REASON,POLLING_DETAIL_CREATE_BY,POLLING_DETAIL_CREATE_DATE,POLLING_DETAIL_STATUS,POLLING_DETAIL_FILE_PATH,POLLING_DETAIL_INPUT_TYPE"; cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = " INSERT INTO TRX_POLLING_DETAILS (" + fname + ") VALUES ('" + lastid + "','" + input.POLLING_DETAIL_POLLING_ID + "',:parameter," + UserId + "," + datenow + ",1,'" + pathnya + "',1) "; OracleParameter oracleParameterClob = new OracleParameter(); oracleParameterClob.OracleDbType = OracleDbType.Clob; //1 million long string oracleParameterClob.Value = input.POLLING_DETAIL_REASON; cmd.Parameters.Add(oracleParameterClob); cmd.ExecuteNonQuery(); db.Database.ExecuteSqlCommand("UPDATE TRX_POLLING TP SET TP.POLLING_JML_PARTISIPAN = (TP.POLLING_JML_PARTISIPAN + 1) WHERE TP.POLLING_ID =" + input.POLLING_DETAIL_POLLING_ID); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Terima kasih, pendapat anda berhasil di simpan."; } con.Close(); var proposal_id = Convert.ToInt32(form["PROPOSAL_ID"]); return(RedirectToAction("Comment/" + proposal_id)); } }
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 ActionResult JajakPendapat(TRX_POLLING_DETAILS input, VIEW_POLLING 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 = ""; var pathnya = ""; HttpPostedFileBase file4 = Request.Files["POLLING_FILE"]; if (file4.ContentLength > 0) { Directory.CreateDirectory(GetPath.CONFIG_VALUE + "/Upload/DokPolling"); path = GetPath.CONFIG_VALUE + "/Upload/DokPolling/"; 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 + "POLLING_" + VP.PROPOSAL_ID + "_" + TGL_SEKARANG + ".pdf"; pdf.Save(@"" + filePathpdf, Aspose.Pdf.SaveFormat.Pdf); } pathnya = "/Upload/DokPolling/POLLING_" + VP.PROPOSAL_ID + "_" + TGL_SEKARANG + ".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(); int lastid = MixHelper.GetSequence("TRX_POLLING_DETAILS"); var datenow = MixHelper.ConvertDateNow(); var fname = "POLLING_DETAIL_ID,POLLING_DETAIL_POLLING_ID,POLLING_DETAIL_OPTION,POLLING_DETAIL_REASON,POLLING_DETAIL_PASAL,POLLING_DETAIL_CREATE_BY,POLLING_DETAIL_CREATE_DATE,POLLING_DETAIL_STATUS,POLLING_DETAIL_FILE_PATH,POLLING_DETAIL_INPUT_TYPE"; var fvalue = "'" + lastid + "', " + "'" + input.POLLING_DETAIL_POLLING_ID + "', " + "'" + input.POLLING_DETAIL_OPTION + "', " + ":parameter , " + "'" + input.POLLING_DETAIL_PASAL + "', " + "'" + UserId + "', " + datenow + ", " + "1," + "'" + pathnya + "'," + "2"; cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; //return Json(new { query = "INSERT INTO TRX_POLLING_DETAILS (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet); cmd.CommandText = "INSERT INTO TRX_POLLING_DETAILS (" + fname + ") VALUES ('" + lastid + "','" + input.POLLING_DETAIL_POLLING_ID + "','" + input.POLLING_DETAIL_OPTION + "',:parameter,'" + input.POLLING_DETAIL_PASAL + "','" + UserId + "'," + datenow + ",1,'" + pathnya + "',2)"; OracleParameter oracleParameterClob = new OracleParameter(); oracleParameterClob.OracleDbType = OracleDbType.Clob; //1 million long string oracleParameterClob.Value = input.POLLING_DETAIL_REASON; cmd.Parameters.Add(oracleParameterClob); cmd.ExecuteNonQuery(); var polling = (from poll in db.TRX_POLLING where poll.POLLING_ID == input.POLLING_DETAIL_POLLING_ID select poll).SingleOrDefault(); //var setuju = polling.POLLING_SETUJU; //var setuju_new = setuju + 1; //var tdk_setuju = polling.POLLING_TDK_SETUJU; //var tdk_setuju_new = tdk_setuju + 1; var jml_partisipan = polling.POLLING_JML_PARTISIPAN + 1; //var persen_setuju_new = setuju_new / jml_partisipan * 100; //var persen_tdk_setuju = tdk_setuju_new / jml_partisipan * 100; var update = ""; update = "POLLING_JML_PARTISIPAN = " + jml_partisipan + "'"; var where_clause = " WHERE POLLING_ID =" + input.POLLING_DETAIL_POLLING_ID; db.Database.ExecuteSqlCommand("UPDATE TRX_POLLING SET POLLING_JML_PARTISIPAN = " + jml_partisipan + " WHERE POLLING_ID = " + input.POLLING_DETAIL_POLLING_ID); //String objek = fvalue.Replace("'", "-"); //MixHelper.InsertLog(logcode, objek, 1); TempData["Notifikasi"] = 1; TempData["NotifikasiText"] = "Terima kasih, pendapat anda berhasil di simpan."; } con.Close(); return(RedirectToAction("JajakPendapat/" + input.POLLING_DETAIL_POLLING_ID)); } } }