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