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