public bool RemoveDocument(Guid serialNumber) { try { using (var db = new MyEntities()) { document_table dbDocument = db.document_table.SingleOrDefault(d => d.SerialNumber == serialNumber); if (dbDocument == null) { return(false); } db.document_table.Remove(dbDocument); db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public AppDocument GetDocument(Guid serialNumber) { using (var db = new MyEntities()) { document_table dbDocument = db.document_table.SingleOrDefault(d => d.SerialNumber == serialNumber); if (dbDocument == null) { return(null); } string fileName = dbDocument.SerialNumber.ToString() + dbDocument.Extention; return(new AppDocument( title: dbDocument.Title, documentId: dbDocument.DocumentId, hostId: 0, serialNumber: dbDocument.SerialNumber, extention: dbDocument.Extention, fileName: fileName, contentType: dbDocument.ContentType, data: dbDocument.Data)); } }
public AppDocument AddDocument(HttpPostedFileBase file) { try { if (file == null) { throw new Exception("No documet Attached."); } if (file.ContentLength == 0) { throw new Exception("Empty Document Detected."); } Guid guid = Guid.NewGuid(); string[] splitName = file.FileName.Split('.'); if (splitName.Length < 2) { throw new ArgumentException("Invalid file name."); } string extention = "." + splitName.Last(); IEnumerable <string> shortsplit = splitName.Take(splitName.Length - 1); string title = String.Join(".", shortsplit); string newFileName = guid.ToString() + extention; string tempFilePath = BASEPATH + String.Format("Content\\Shared\\Temp\\{0}", newFileName); // Temporarily store files locally file.SaveAs(tempFilePath); byte[] fileBinary = System.IO.File.ReadAllBytes(tempFilePath); string contentType = file.ContentType; int id = 0; using (var db = new MyEntities()) { var doc = new document_table() { ContentType = contentType, Extention = extention, UploadDate = DateTime.Now, SerialNumber = guid, Title = title, FileName = newFileName, Data = fileBinary }; db.document_table.Add(doc); db.SaveChanges(); id = doc.DocumentId; } // clean up local directory File.Delete(tempFilePath); if (id == 0) { throw new Exception("Unable to add file."); } return(new AppDocument( title: title, documentId: id, fileName: newFileName, serialNumber: guid, extention: extention, contentType: contentType, data: fileBinary)); } catch (Exception) { throw; } }