public ActionResult Create(TRX_PROPOSAL tp, int[] PROPOSAL_ID)
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
var datenow = MixHelper.ConvertDateNow();
var date_now = DateTime.Now.ToString("dd_MM_yyyy_hh_mm");
//return Json(new { total_count = date }, JsonRequestBehavior.AllowGet);
if (PROPOSAL_ID.Count() > 0)
{
string path = Server.MapPath("~/Upload/Dokumen/PEMBATALAN/");
HttpPostedFileBase file_att = Request.Files["PROPOSAL_BATAL_ATTACHMENT"];
var file_name_att = "";
var filePath = "";
if (file_att != null)
{
string attach_batal = file_att.FileName;
if (attach_batal.Trim() != "")
{
attach_batal = Path.GetFileNameWithoutExtension(file_att.FileName);
string fileExtension = Path.GetExtension(file_att.FileName);
file_name_att = "Attachment_Batal_" + date_now + "" + fileExtension;
filePath = path + file_name_att;
file_att.SaveAs(filePath);
}
}
foreach (var PID in PROPOSAL_ID)
{
var update = " PROPOSAL_IS_BATAL = 1," +
" PROPOSAL_KET_BATAL = '" + tp.PROPOSAL_KET_BATAL + "'," +
" PROPOSAL_NO_SURAT_PEMBATALAN = '" + tp.PROPOSAL_NO_SURAT_PEMBATALAN + "'," +
" PROPOSAL_BATAL_ATTACHMENT = '" + file_name_att + "'," +
" PROPOSAL_UPDATE_DATE =" + datenow + "," +
" PROPOSAL_UPDATE_BY ='" + UserId + "'";
var clausess = "where PROPOSAL_ID = " + PID;
db.Database.ExecuteSqlCommand("UPDATE TRX_PROPOSAL SET " + update.Replace("''", "NULL") + " " + clausess);
//return Json(new { total_count = "UPDATE TRX_PROPOSAL SET " + update.Replace("''", "NULL") + " " + clausess }, JsonRequestBehavior.AllowGet);
}
}
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Proposal telah dibatalkan";
return(RedirectToAction("Index"));
}
public ActionResult Detil(TRX_SNI ts, TRX_PROPOSAL tp, int PROPOSAL_ID = 0, string DOC_INFO = "")
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
int lastid = MixHelper.GetSequence("TRX_DOCUMENTS");
var datenow = MixHelper.ConvertDateNow();
var update_sni = "UPDATE TRX_SNI SET SNI_IS_PUBLISH = 1, SNI_NOMOR = '" + ts.SNI_NOMOR + "', SNI_JUDUL = '" + ts.SNI_JUDUL + "', SNI_JUDUL_ENG = '" + ts.SNI_JUDUL_ENG + "' WHERE SNI_ID = " + ts.SNI_ID;
db.Database.ExecuteSqlCommand(update_sni);
var update_PROPOSAL = "UPDATE TRX_PROPOSAL SET PROPOSAL_ABSTRAK = '" + tp.PROPOSAL_ABSTRAK + "', PROPOSAL_ABSTRAK_ENG = '" + tp.PROPOSAL_ABSTRAK_ENG + "', PROPOSAL_RUANG_LINGKUP = '" + tp.PROPOSAL_RUANG_LINGKUP + "', PROPOSAL_RUANG_LINGKUP_ENG = '" + tp.PROPOSAL_RUANG_LINGKUP_ENG + "' WHERE PROPOSAL_ID = " + ts.SNI_PROPOSAL_ID;
db.Database.ExecuteSqlCommand(update_PROPOSAL);
var updates = "UPDATE TRX_SNI_SK SET IS_PUBLISH = 1 WHERE SNI_SK_ID = " + ts.SNI_SK_ID;
db.Database.ExecuteSqlCommand(updates);
var DataProposal = (from proposal in db.VIEW_PROPOSAL where proposal.PROPOSAL_ID == ts.SNI_PROPOSAL_ID select proposal).SingleOrDefault();
var PROPOSAL_PNPS_CODE_FIXER = DataProposal.PROPOSAL_PNPS_CODE;
var TGL_SEKARANG = DateTime.Now.ToString("yyyyMMddHHmmss");
HttpPostedFileBase file4 = Request.Files["file_sni"];
if (file4.ContentLength > 0)
{
var doc = (from b in db.TRX_DOCUMENTS where b.DOC_ID == ts.SNI_DOC_ID && b.DOC_FOLDER_ID == 8 && b.DOC_RELATED_TYPE == 100 select b).SingleOrDefault();
int LASTID_DOC = MixHelper.GetSequence("TRX_DOCUMENTS");
Directory.CreateDirectory(Server.MapPath("~/Upload/Dokumen/SNI"));
string path = Server.MapPath("~/Upload/Dokumen/SNI/");
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() == ".doc" || Extension.ToLower() == ".docx")
{
//Aspose.Pdf.Document pdf = new Aspose.Pdf.Document(stremdokumen);
Aspose.Words.Document docx = new Aspose.Words.Document(stremdokumen);
string filePathdoc = path + "SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish).docx";
string filePathpdf = path + "SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish).pdf";
string filePathxml = path + "SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish).xml";
docx.Save(@"" + filePathdoc, Aspose.Words.SaveFormat.Docx);
docx.Save(@"" + filePathpdf, Aspose.Words.SaveFormat.Pdf);
docx.Save(@"" + filePathxml);
string Total_Hal = "";
if (DOC_INFO == "" || DOC_INFO == " ")
{
Total_Hal = (docx.PageCount).ToString();
}
else
{
Total_Hal = DOC_INFO;
}
////string filePathpdf = path + "SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish).pdf";
//string filePathxml = path + "SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish).xml";
//pdf.Save(@"" + filePathpdf, Aspose.Pdf.SaveFormat.Pdf);
//pdf.Save(@"" + filePathxml);
var LOGCODE_TANGGAPAN_MTPS = MixHelper.GetLogCode();
var fupdate = "UPDATE TRX_DOCUMENTS SET DOC_FILE_NAME = 'SNI_" + PROPOSAL_PNPS_CODE_FIXER + "_" + TGL_SEKARANG + "(publish)'," +
"DOC_UPDATE_BY = " + UserId + "," +
"DOC_INFO = '" + Total_Hal + "'," +
"DOC_FILETYPE = 'DOCX'," +
"DOC_UPDATE_DATE = " + datenow + "" +
"WHERE DOC_RELATED_ID = " + ts.SNI_PROPOSAL_ID + " AND DOC_FOLDER_ID = 8 AND DOC_RELATED_TYPE = 100";
db.Database.ExecuteSqlCommand(fupdate);
}
}
String objek = update_sni.Replace("'", "-");
MixHelper.InsertLog(logcode, objek, 1);
String objeks = update_PROPOSAL.Replace("'", "-");
MixHelper.InsertLog(logcode, objeks, 1);
String objekss = updates.Replace("'", "-");
MixHelper.InsertLog(logcode, objekss, 1);
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Data SNI Berhasil di Publikasikan";
return(RedirectToAction("Index"));
}
