/// <summary>
/// Delete file record by ID
/// </summary>
/// <param name="ID">Record ID</param>
public void Delete(int ID)
{
DocReturnFiles DocReturnFiles = db.DocReturnFiles.Find(ID);
db.DocReturnFiles.Remove(DocReturnFiles);
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/docrtn/") + reference + "_" + fileName))
{
return(Json("อัพโหลดไม่สำเร็จ - มีไฟล์นี้อยู่แล้ว"));
}
DocReturnFiles drtnFiles = new DocReturnFiles();
drtnFiles.DELVNO = reference;
drtnFiles.FILEPATH = "Content/Docs/docrtn/" + reference + "_" + fileName;
drtnFiles.LOADED_DATE = DateTime.Now;
drtnFiles.LOADED_BY = User.Identity.Name;
objBs.docReturnFilesBs.Insert(drtnFiles);
file.SaveAs(Server.MapPath("~/Content/Docs/docrtn/") + 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(DocReturnFiles DocReturnFiles)
{
objDb.Update(DocReturnFiles);
}
//Insert
public void Insert(DocReturnFiles DocReturnFiles)
{
objDb.Insert(DocReturnFiles);
}
//Update
public void Update(DocReturnFiles DocReturnFiles)
{
objDb.Update(DocReturnFiles);
}
//Insert
public void Insert(DocReturnFiles DocReturnFiles)
{
objDb.Insert(DocReturnFiles);
}
//Update
public void Update(DocReturnFiles DocReturnFiles)
{
db.Entry(DocReturnFiles).State = EntityState.Modified;
Save();
}
//Insert
public void Insert(DocReturnFiles DocReturnFiles)
{
db.DocReturnFiles.Add(DocReturnFiles);
Save();
}
