/// <summary>
/// Delete file record by ID
/// </summary>
/// <param name="ID">Record ID</param>
public void Delete(int ID)
{
AcceptedFiles acceptedFiles = db.AcceptedFiles.Find(ID);
db.AcceptedFiles.Remove(acceptedFiles);
Save();
}
public JsonResult Upload()
{
using (TransactionScope Trans = new TransactionScope())
{
try
{
for (int i = 0; i < Request.Files.Count; i++)
{
string reference = Request.Files.AllKeys[i];
HttpPostedFileBase file = Request.Files[i]; //Uploaded file
//Use the following properties to get file's name, size and MIMEType
int fileSize = file.ContentLength;
string fileName = file.FileName;
string mimeType = file.ContentType;
System.IO.Stream fileContent = file.InputStream;
//To save file, use SaveAs method
if (System.IO.File.Exists(Server.MapPath("~/Content/Docs/acpd/") + reference + "_" + fileName))
{
return(Json("อัพโหลดไม่สำเร็จ - มีไฟล์นี้อยู่แล้ว"));
}
AcceptedFiles acpdFiles = new AcceptedFiles();
acpdFiles.SHPMNTNO = reference;
acpdFiles.FILEPATH = "Content/Docs/acpd" + reference + "_" + fileName;
acpdFiles.LOADED_DATE = DateTime.Now;
acpdFiles.LOADED_BY = User.Identity.Name;
objBs.acceptedFilesBs.Insert(acpdFiles);
file.SaveAs(Server.MapPath("~/Content/Docs/acpd/") + reference + "_" + fileName); //File will be saved in application root
}
Trans.Complete();
return(Json("อัพโหลดสำเร็จ " + Request.Files.Count + " ไฟล์"));
}
catch (Exception e)
{
return(Json("อัพโหลดไม่สำเร็จ :: Code " + e.ToString()));
}
}
}
//Update
public void Update(AcceptedFiles acceptedFiles)
{
objDb.Update(acceptedFiles);
}
//Insert
public void Insert(AcceptedFiles acceptedFiles)
{
objDb.Insert(acceptedFiles);
}
//Update
public void Update(AcceptedFiles acceptedFiles)
{
db.Entry(acceptedFiles).State = EntityState.Modified;
Save();
}
//Insert
public void Insert(AcceptedFiles acceptedFiles)
{
db.AcceptedFiles.Add(acceptedFiles);
Save();
}
