public Document GetDocumentbyId(int userId, int documentId) { try { using (DocumentShareEntities db = new DocumentShareEntities()) { return(db.Documents.Where(o => o.DocumentId == documentId).FirstOrDefault()); } } catch (Exception e) { LogError(e); return(null); } }
internal void LogError(Exception e, String notes = "") { try { using (DocumentShareEntities db = new DocumentShareEntities()) { ErrorLog err = new ErrorLog(); err.Message = String.Format("{0} {1}", e.Message, e.InnerException == null ? String.Empty : "(" + e.InnerException.Message + ")").Substring(0, 500); err.Notes = notes; db.ErrorLogs.Add(err); } } catch (Exception e) { //hmmm... } }
public List <Document> GetAllDocuments(int userId) { try { using (DocumentShareEntities db = new DocumentShareEntities()) { List <Document> docs; docs = (from doc in db.Documents join udc in db.UserDocuments on doc.DocumentId equals udc.DocumentId where udc.UserId == userId select doc).ToList(); return(docs); } } catch (Exception e) { LogError(e); return(null); } }
public bool SendDocumentToUser(int fromUserId, int toUserId, int documentId) { try { using (DocumentShareEntities db = new DocumentShareEntities()) { User user = db.Users.Where(o => o.Id == fromUserId).FirstOrDefault(); if (user == null) { throw new Exception("User was not found"); } Document doc = db.Documents.Where(o => o.DocumentId == documentId).FirstOrDefault(); if (doc == null) { throw new Exception("Document was not found"); } UserDocument userDoc = new UserDocument(); userDoc.DocumentId = documentId; userDoc.UserId = toUserId; db.UserDocuments.Add(userDoc); db.SaveChanges(); return(true); } } catch (Exception e) { LogError(e); return(false); } }