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