public ActionResult create(TRX_SK_PENETAPAN INPUT, string TANGGAL_SK = "")
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
int lastid = MixHelper.GetSequence("SK_P_PNPS");
var datenow = MixHelper.ConvertDateNow();
string pathnya = Server.MapPath("~/Upload/Dokumen/SK_PENETAPAN_PNPS/");
HttpPostedFileBase file_paten = Request.Files["FILES"];
var file_name_paten = "";
var filePath_paten = "";
var fileExtension_paten = "";
if (file_paten != null)
{
//Check whether Directory (Folder) exists.
if (!Directory.Exists(pathnya))
{
//If Directory (Folder) does not exists. Create it.
Directory.CreateDirectory(pathnya);
}
string lampiranregulasipath = file_paten.FileName;
if (lampiranregulasipath.Trim() != "")
{
lampiranregulasipath = Path.GetFileNameWithoutExtension(file_paten.FileName);
fileExtension_paten = Path.GetExtension(file_paten.FileName);
file_name_paten = "SK_PENETAPAN_PNPS_" + lastid + fileExtension_paten;
filePath_paten = pathnya + file_name_paten.Replace(" ", "_");
file_paten.SaveAs(filePath_paten);
}
}
var fname = "PENETAPAN_ID,PENETAPAN_NO_SK,TANGGAL_SK,JUDUL_SK,SK_LOCATION,FILES,CREATE_DATE,CREATE_BY";
var fvalueS = "" + lastid + "," +
"'" + INPUT.PENETAPAN_NO_SK + "'," +
"TO_DATE ('" + TANGGAL_SK + "','yyyy-mm-dd hh24:mi:ss')," +
"'" + INPUT.JUDUL_SK + "'," +
"'/Upload/Dokumen/SK_PENETAPAN_PNPS/'," +
"'" + file_name_paten.Replace(" ", "_") + "'," +
"" + datenow + "," +
"'" + UserId + "'";
db.Database.ExecuteSqlCommand("INSERT INTO TRX_SK_PENETAPAN (" + fname + ") VALUES (" + fvalueS.Replace("''", "NULL") + ")");
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Data Berhasil Disimpan";
return(RedirectToAction("Index"));
//var TT = ("INSERT INTO TRX_SK_PENETAPAN (" + fname + ") VALUES (" + fvalueS.Replace("''", "NULL") + ")");
//return Content(TT);
}
public ActionResult Edit(TRX_SK_PENETAPAN edit, string TANGGAL_SK = "")
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
var id = edit.PENETAPAN_ID;
var datenow = MixHelper.ConvertDateNow();
DateTime TANGGAL_SK_NEW = Convert.ToDateTime(edit.TANGGAL_SK);
string pathnya = Server.MapPath("~/Upload/Dokumen/SK_PENETAPAN_PNPS/");
HttpPostedFileBase file_paten = Request.Files["FILES"];
var file_name_paten = "";
var filePath_paten = "";
var fileExtension_paten = "";
if (file_paten != null)
{
//Check whether Directory (Folder) exists.
if (!Directory.Exists(pathnya))
{
//If Directory (Folder) does not exists. Create it.
Directory.CreateDirectory(pathnya);
}
string lampiranregulasipath = file_paten.FileName;
if (lampiranregulasipath.Trim() != "")
{
lampiranregulasipath = Path.GetFileNameWithoutExtension(file_paten.FileName);
fileExtension_paten = Path.GetExtension(file_paten.FileName);
file_name_paten = "SK_PENETAPAN_PNPS_" + id + fileExtension_paten;
filePath_paten = pathnya + file_name_paten.Replace(" ", "_");
file_paten.SaveAs(filePath_paten);
}
}
var update = "PENETAPAN_NO_SK = '" + edit.PENETAPAN_NO_SK + "'," +
"TANGGAL_SK = TO_DATE ('" + TANGGAL_SK + "','yyyy-mm-dd hh24:mi:ss')," +
"JUDUL_SK = '" + edit.JUDUL_SK + "'," +
"CREATE_DATE = " + datenow + "";
var clause = "where PENETAPAN_ID = " + edit.PENETAPAN_ID;
db.Database.ExecuteSqlCommand("UPDATE TRX_SK_PENETAPAN SET " + update.Replace("''", "NULL") + " " + clause);
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Data Berhasil Diubah";
return(RedirectToAction("Index"));
//var tt = ("UPDATE TRX_SK_PENETAPAN SET " + update.Replace("''", "NULL") + " " + clause);
//return Content(tt);
}
