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