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