Пример #1
0
 /// <summary>
 /// Gets the id of a document by the directoryPath and filename
 /// </summary>
 /// <param name="directoryPath">The path of the directory</param>
 /// <param name="filename">The name of the file</param>
 /// <returns>The id of the document</returns>
 public int GetDocumentIdByPath(String directoryPath, String filename)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var document = from d in context.Documents
                        where d.path == directoryPath && d.name == filename
                        select d;
         return(document.First <Document>().id);
     }
 }
Пример #2
0
 /// <summary>
 /// States whether or not a document has any revisions
 /// </summary>
 /// <param name="documentId">The id of the document</param>
 /// <returns>False if the document has no revisions, otherwise true</returns>
 public bool DocumentHasRevision(int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documentRevisions = from dr in context.Documentrevisions
                                 where dr.documentId == documentId
                                 select dr;
         return(documentRevisions.Count <Documentrevision>() != 0);
     }
 }
Пример #3
0
 /// <summary>
 /// Gets a documentrevision by its id
 /// </summary>
 /// <param name="documentRevisionId">The id of the document revision</param>
 /// <returns>The documentrevision with the given id</returns>
 public Documentrevision GetDocumentRevisionById(int documentRevisionId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documentrevision = from dr in context.Documentrevisions
                                where dr.id == documentRevisionId
                                select dr;
         return(documentrevision.First <Documentrevision>());
     }
 }
Пример #4
0
 /// <summary>
 /// Gets a document id by the id of the creator and the title of the document
 /// </summary>
 /// <param name="userId">the id of the user</param>
 /// <param name="title">the title of the document</param>
 /// <returns>The id of the document with the given creator and title</returns>
 public int GetDocumentId(int userId, string title)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var document = from d in context.Documents
                        where d.creatorId == userId && d.name == title
                        select d;
         return(document.First <Document>().id);
     }
 }
Пример #5
0
 /// <summary>
 /// Moves a document from one folder to another
 /// </summary>
 /// <param name="userId">The id of the user whos moving the document</param>
 /// <param name="documentId">The id of the document the user is moving</param>
 /// <param name="newFolderId">The id of the folder the user is moving the document to</param>
 public void MoveDocumentWeb(int userId, int documentId, int newFolderId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var userdocument = from ud in context.Userdocuments
                            where ud.userId == userId && ud.documentId == documentId
                            select ud;
         userdocument.First <Userdocument>().folderId = newFolderId;
         context.SaveChanges();
     }
 }
Пример #6
0
 /// <summary>
 /// Gets the latest documents revisions from a document.
 /// </summary>
 /// <param name="documentId">The id of the document</param>
 /// <returns>The latest document revision</returns>
 public List <Documentrevision> GetLatestDocumentRevisions(int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documentRevisions = from dr in context.Documentrevisions
                                 where dr.documentId == documentId
                                 orderby dr.creationTime descending
                                 select dr;
         List <Documentrevision> returnList = documentRevisions.ToList <Documentrevision>();
         return(returnList);
     }
 }
Пример #7
0
 /// <summary>
 /// Adds a folder to the database.
 /// </summary>
 /// <param name="name">The name of the folder</param>
 /// <param name="parentFolderId">The id of the parent folder. Null if it's a root folder.</param>
 public int AddFolder(String name, int parentFolderId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         Folder folder = new Folder();
         folder.name           = name;
         folder.parentFolderId = parentFolderId;
         context.Folders.AddObject(folder);
         context.SaveChanges();
         return(folder.id);
     }
 }
Пример #8
0
 /// <summary>
 /// Adds a userdocument in the givens users root folder
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <param name="documentId">The id of the document</param>
 public void AddUserDocumentInRoot(int userId, int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         User         user         = GetUserById(userId);
         Userdocument userdocument = new Userdocument();
         userdocument.documentId = documentId;
         userdocument.folderId   = user.rootFolderId;
         userdocument.userId     = userId;
         context.Userdocuments.AddObject(userdocument);
         context.SaveChanges();
     }
 }
Пример #9
0
 /// <summary>
 /// Adds a documentrevision to an already existing document
 /// </summary>
 /// <param name="editorId">The id of the user who made the revision</param>
 /// <param name="documentId">The id of the original document</param>
 /// <param name="content">The xaml + metadata content of the file</param>
 public void AddDocumentRevision(DateTime creationTime, int editorId, int documentId, String filepath)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         Documentrevision documentRevision = new Documentrevision();
         documentRevision.creationTime = creationTime;
         documentRevision.editorId     = editorId;
         documentRevision.documentId   = documentId;
         documentRevision.path         = filepath;
         context.Documentrevisions.AddObject(documentRevision);
         context.SaveChanges();
     }
 }
Пример #10
0
 /// <summary>
 /// Adds a documentrevision to an already existing document
 /// </summary>
 /// <param name="editorId">The id of the user who made the revision</param>
 /// <param name="documentId">The id of the original document</param>
 /// <param name="content">The xaml + metadata content of the file</param>
 public void AddDocumentRevision(DateTime creationTime, int editorId, int documentId, String filepath)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         Documentrevision documentRevision = new Documentrevision();
         documentRevision.creationTime = creationTime;
         documentRevision.editorId = editorId;
         documentRevision.documentId = documentId;
         documentRevision.path = filepath;
         context.Documentrevisions.AddObject(documentRevision);
         context.SaveChanges();
     }
 }
Пример #11
0
 /// <summary>
 /// Check if a folder exists
 /// </summary>
 /// <param name="parentFolderId">The id of the parentfolder</param>
 /// <param name="name">The name of the folder</param>
 /// <returns>The id of the folder if it exists, else -1</returns>
 public int FolderExists(int parentFolderId, string name)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var folder = from f in context.Folders
                      where f.parentFolderId == parentFolderId && f.name == name
                      select f;
         if (folder.Count <Folder>() > 0)
         {
             return(folder.First <Folder>().id);
         }
         return(-1);
     }
 }
Пример #12
0
        /// <summary>
        /// Alters a userdocument, effectively moving the document from one folder to another
        /// </summary>
        /// <param name="userId">The id of the user</param>
        /// <param name="documentId">The id of the document</param>
        /// <param name="filepath">the path to the document</param>
        public void AlterUserDocument(int userId, int documentId, String filepath)
        {
            int folderId = GetFolderIdByDirectoryPath(userId, filepath);

            using (PieFactoryEntities context = new PieFactoryEntities())
            {
                var userdocuments = from ud in context.Userdocuments
                                    where ud.userId == userId && ud.documentId == documentId
                                    select ud;
                Userdocument userdocument = userdocuments.First <Userdocument>();
                userdocument.folderId = folderId;
                context.SaveChanges();
            }
        }
Пример #13
0
 /// <summary>
 /// Add a document to the database
 /// </summary>
 /// <param name="name">The name of the document</param>
 /// <param name="userId">The id of the user who created the document</param>
 /// <param name="filepath">The path to the file</param>
 /// <returns>The id of the created document</returns>
 public int AddDocument(String name, int userId, String directoryPath)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         Document document = new Document();
         document.name         = name;
         document.creatorId    = userId;
         document.creationTime = DateTime.UtcNow;
         document.path         = directoryPath;
         context.Documents.AddObject(document);
         context.SaveChanges();
         return(document.id);
     }
 }
Пример #14
0
 /// <summary>
 /// Add a document to the database
 /// </summary>
 /// <param name="name">The name of the document</param>
 /// <param name="userId">The id of the user who created the document</param>
 /// <param name="filepath">The path to the file</param>
 /// <returns>The id of the created document</returns>
 public int AddDocument(String name, int userId, String directoryPath)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         Document document = new Document();
         document.name = name;
         document.creatorId = userId;
         document.creationTime = DateTime.UtcNow;
         document.path = directoryPath;
         context.Documents.AddObject(document);
         context.SaveChanges();
         return document.id;
     }
 }
Пример #15
0
        /// <summary>
        /// Adds a reference from a user to a document to the database.
        /// </summary>
        /// <param name="userId">The id of the user</param>
        /// <param name="documentId">The id of the document</param>
        /// <param name="directoryPath">The path of the directory in which the document lies</param>
        public void AddUserDocument(int userId, int documentId, String directoryPath)
        {
            int folderId = GetFolderIdByDirectoryPath(userId, directoryPath);

            using (PieFactoryEntities context = new PieFactoryEntities())
            {
                Userdocument userDocument = new Userdocument();
                userDocument.documentId = documentId;
                userDocument.userId     = userId;
                userDocument.folderId   = folderId;
                context.Userdocuments.AddObject(userDocument);
                context.SaveChanges();
            }
        }
Пример #16
0
 /// <summary>
 /// Delete a users reference to a document
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <param name="documentId">The id of the document</param>
 public void DeleteDocumentReference(int userId, int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var userDocuments = from dr in context.Userdocuments
                             where dr.documentId == documentId & dr.userId == userId
                             select dr;
         if (userDocuments.Count <Userdocument>() > 0)
         {
             Userdocument userDocument = userDocuments.First <Userdocument>();
             context.Userdocuments.DeleteObject(userDocument);
             context.SaveChanges();
         }
     }
 }
Пример #17
0
 /// <summary>
 /// Gets the latest revision of a specific document submitted by a specific user.
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <param name="documentId">The id of the document</param>
 /// <returns>The revision of the specified document</returns>
 public Documentrevision GetUsersLatestDocumentRevision(int userId, int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documentrevisions = from dr in context.Documentrevisions
                                 where dr.editorId == userId && dr.documentId == documentId
                                 orderby dr.creationTime descending
                                 select dr;
         if (documentrevisions.Count <Documentrevision>() > 0)
         {
             return(documentrevisions.ToList <Documentrevision>()[0]);
         }
         return(null);
     }
 }
Пример #18
0
        /// <summary>
        /// Retrieve user from database using email and sha1 encrypted password
        /// </summary>
        /// <param name="email">user email</param>
        /// <param name="pass">corresponding password encrypted using sha1</param>
        /// <returns>return null if user does not exist and the corresponding User object if the user exists</returns>
        public User GetUserByEmailAndPass(String email, String pass)
        {
            using (PieFactoryEntities context = new PieFactoryEntities())
            {
                var user = from u in context.Users
                           where u.email == email && u.password == pass
                           select u;

                if (user.Count <User>() > 0)
                {
                    return(user.First <User>());
                }
                return(null);
            }
        }
Пример #19
0
 /// <summary>
 /// Get a user from the database
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <returns>The user with the given id. Null if no user has that id</returns>
 public User GetUserById(int userId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var users = from u in context.Users
                     where u.id == userId
                     select u;
         User user = null;
         if (users.Count <User>() > 0)
         {
             user = users.First <User>();
         }
         return(user);
     }
 }
Пример #20
0
 /// <summary>
 /// Get a user from the database
 /// </summary>
 /// <param name="userId">The email of the user</param>
 /// <returns>The user with the given id. Null if no user has that id</returns>
 public User GetUserByEmail(String email)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var users = from u in context.Users
                     where u.email == email
                     select u;
         User user = null;
         if (users.Count <User>() > 0)
         {
             user = users.First <User>();
         }
         return(user);
     }
 }
Пример #21
0
 /// <summary>
 /// Get a userdocument from the database
 /// </summary>
 /// <param name="userId">The userId of the userdocument</param>
 /// <param name="documentId">The documentId of the userdocument</param>
 /// <returns>The Userdocument with the given userId and documentId. Null if none exists</returns>
 public Userdocument GetUserdocument(int userId, int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var userdocuments = from ud in context.Userdocuments
                             where ud.userId == userId && ud.documentId == documentId
                             select ud;
         Userdocument userdocument = null;
         if (userdocuments.Count <Userdocument>() > 0)
         {
             userdocument = userdocuments.First <Userdocument>();
         }
         return(userdocument);
     }
 }
Пример #22
0
 /// <summary>
 /// Get a document from the database
 /// </summary>
 /// <param name="documentId">The id of the document</param>
 /// <returns>The document with the given id. Null if no document has that id</returns>
 public Document GetDocumentById(int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documents = from d in context.Documents
                         where d.id == documentId
                         select d;
         Document document = null;
         if (documents.Count <Document>() > 0)
         {
             document = documents.First <Document>();
         }
         return(document);
     }
 }
Пример #23
0
 /// <summary>
 /// Get a folder from the database
 /// </summary>
 /// <param name="folderId">The id of the folder</param>
 /// <returns>The folder with the given id. Null if no folder has that id</returns>
 public Folder GetFolder(int folderId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var folders = from f in context.Folders
                       where f.id == folderId
                       select f;
         Folder folder = null;
         if (folders.Count <Folder>() > 0)
         {
             folder = folders.First <Folder>();
         }
         return(folder);
     }
 }
Пример #24
0
 /// <summary>
 /// Gets the folders with a specific parent id.
 /// </summary>
 /// <param name="parentId">The parent id of the folders</param>
 /// <returns>The folders with the parentId</returns>
 public List <Folder> GetFoldersByRootId(int parentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var folders = from f in context.Folders
                       where f.parentFolderId == parentId
                       select f;
         List <Folder> folderList = new List <Folder>();
         foreach (Folder f in folders)
         {
             folderList.Add(f);
         }
         return(folderList);
     }
 }
Пример #25
0
 /// <summary>
 /// Delete a folder from the database
 /// </summary>
 /// <param name="folderId">The id of the folder to delete</param>
 public void DeleteFolder(int folderId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var folders = from f in context.Folders
                       where f.id == folderId
                       select f;
         if (folders.Count <Folder>() > 0)
         {
             Folder folder = folders.First <Folder>();
             context.Folders.DeleteObject(folder);
             context.SaveChanges();
         }
     }
 }
Пример #26
0
 /// <summary>
 /// Delete a document from the database
 /// </summary>
 /// <param name="documentId">The id of the document to delete</param>
 public void DeleteDocument(int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documents = from d in context.Documents
                         where d.id == documentId
                         select d;
         if (documents.Count <Document>() > 0)
         {
             Document document = documents.First <Document>();
             context.Documents.DeleteObject(document);
             context.SaveChanges();
         }
     }
 }
Пример #27
0
 /// <summary>
 /// Adds a user to the database.
 /// </summary>
 /// <param name="email">The email of the user</param>
 /// <param name="password">The encrypted password of the user</param>
 /// <returns>The id of the added user. -1 if a user with the given email already exists</returns>
 public int AddUser(String email, String password)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         User user = new User();
         user.email    = email;
         user.password = password;
         //Add a root folder named "root"
         Folder folder = new Folder();
         folder.name = "root";
         user.Folder = folder;
         context.Users.AddObject(user);
         context.SaveChanges();
         return(user.id);
     }
 }
Пример #28
0
        /// <summary>
        /// Gets all document revisions from a single document.
        /// </summary>
        /// <param name="documentId">The id of the document</param>
        /// <returns>A list of all document revisions from the original document</returns>
        public List <Documentrevision> GetDocumentRevisions(int documentId)
        {
            using (PieFactoryEntities context = new PieFactoryEntities())
            {
                var documentRevisions = from dr in context.Documentrevisions
                                        where dr.documentId == documentId
                                        select dr;

                List <Documentrevision> documentRevisionList = new List <Documentrevision>();
                foreach (Documentrevision dr in documentRevisions)
                {
                    documentRevisionList.Add(dr);
                }
                return(documentRevisionList);
            }
        }
Пример #29
0
 /// <summary>
 /// Get all userdocuments of a specific user
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <returns>All userdocuments this user is subscribed to</returns>
 public List <Userdocument> GetAllUserDocumentsByUserId(int userId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var userdocs = from ud in context.Userdocuments
                        where ud.userId == userId
                        select ud;
         if (userdocs.Count <Userdocument>() > 0)
         {
             return(userdocs.ToList());
         }
         else
         {
             //No documents found
             return(null);
         }
     }
 }
Пример #30
0
        /// <summary>
        /// Removes all data from the database.
        /// </summary>
        public void DeleteAllData()
        {
            using (PieFactoryEntities context = new PieFactoryEntities())
            {
                //Delete all folders
                var folders = context.Folders;
                foreach (Folder f in folders)
                {
                    context.Folders.DeleteObject(f);
                }

                //Delete all users
                var users = context.Users;
                foreach (User u in users)
                {
                    context.Users.DeleteObject(u);
                }

                //Delete all documents
                var documents = context.Documents;
                foreach (Document d in documents)
                {
                    context.Documents.DeleteObject(d);
                }

                //Delete all documentRevision
                var documentRevisions = context.Documentrevisions;
                foreach (Documentrevision d in documentRevisions)
                {
                    context.Documentrevisions.DeleteObject(d);
                }

                //Delete all userDocuments
                var userdocuments = context.Userdocuments;
                foreach (Userdocument ud in userdocuments)
                {
                    context.Userdocuments.DeleteObject(ud);
                }
                context.SaveChanges();
            }
        }
Пример #31
0
 /// <summary>
 /// Gets the latest documents revisions from a document.
 /// </summary>
 /// <param name="documentId">The id of the document</param>
 /// <returns>The latest document revision</returns>
 public List<Documentrevision> GetLatestDocumentRevisions(int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documentRevisions = from dr in context.Documentrevisions
                                 where dr.documentId == documentId
                                 orderby dr.creationTime descending
                                 select dr;
         List<Documentrevision> returnList = documentRevisions.ToList<Documentrevision>();
         return returnList;
     }
 }
Пример #32
0
 /// <summary>
 /// Gets a document id by the id of the creator and the title of the document
 /// </summary>
 /// <param name="userId">the id of the user</param>
 /// <param name="title">the title of the document</param>
 /// <returns>The id of the document with the given creator and title</returns>
 public int GetDocumentId(int userId, string title)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var document = from d in context.Documents
                        where d.creatorId == userId && d.name == title
                        select d;
         return document.First<Document>().id;
     }
 }
Пример #33
0
 /// <summary>
 /// Get a document from the database
 /// </summary>
 /// <param name="documentId">The id of the document</param>
 /// <returns>The document with the given id. Null if no document has that id</returns>
 public Document GetDocumentById(int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documents = from d in context.Documents
                         where d.id == documentId
                         select d;
         Document document = null;
         if (documents.Count<Document>() > 0)
         {
             document = documents.First<Document>();
         }
         return document;
     }
 }
Пример #34
0
 /// <summary>
 /// Adds a reference from a user to a document to the database.
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <param name="documentId">The id of the document</param>
 /// <param name="directoryPath">The path of the directory in which the document lies</param>
 public void AddUserDocument(int userId, int documentId, String directoryPath)
 {
     int folderId = GetFolderIdByDirectoryPath(userId, directoryPath);
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         Userdocument userDocument = new Userdocument();
         userDocument.documentId = documentId;
         userDocument.userId = userId;
         userDocument.folderId = folderId;
         context.Userdocuments.AddObject(userDocument);
         context.SaveChanges();
     }
 }
Пример #35
0
 /// <summary>
 /// Gets the id of a document by the directoryPath and filename
 /// </summary>
 /// <param name="directoryPath">The path of the directory</param>
 /// <param name="filename">The name of the file</param>
 /// <returns>The id of the document</returns>
 public int GetDocumentIdByPath(String directoryPath, String filename)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var document = from d in context.Documents
                        where d.path == directoryPath && d.name == filename
                        select d;
         return document.First<Document>().id;
     }
 }
Пример #36
0
        /// <summary>
        /// Removes all data from the database.
        /// </summary>
        public void DeleteAllData()
        {
            using (PieFactoryEntities context = new PieFactoryEntities())
            {
                //Delete all folders
                var folders = context.Folders;
                foreach (Folder f in folders)
                {
                    context.Folders.DeleteObject(f);
                }

                //Delete all users
                var users = context.Users;
                foreach (User u in users)
                {
                    context.Users.DeleteObject(u);
                }

                //Delete all documents
                var documents = context.Documents;
                foreach (Document d in documents)
                {
                    context.Documents.DeleteObject(d);
                }

                //Delete all documentRevision
                var documentRevisions = context.Documentrevisions;
                foreach (Documentrevision d in documentRevisions)
                {
                    context.Documentrevisions.DeleteObject(d);
                }

                //Delete all userDocuments
                var userdocuments = context.Userdocuments;
                foreach (Userdocument ud in userdocuments)
                {
                    context.Userdocuments.DeleteObject(ud);
                }
                context.SaveChanges();
            }
        }
Пример #37
0
 /// <summary>
 /// Adds a userdocument in the givens users root folder
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <param name="documentId">The id of the document</param>
 public void AddUserDocumentInRoot(int userId, int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         User user = GetUserById(userId);
         Userdocument userdocument = new Userdocument();
         userdocument.documentId = documentId;
         userdocument.folderId = user.rootFolderId;
         userdocument.userId = userId;
         context.Userdocuments.AddObject(userdocument);
         context.SaveChanges();
     }
 }
Пример #38
0
 /// <summary>
 /// States whether or not a document has any revisions
 /// </summary>
 /// <param name="documentId">The id of the document</param>
 /// <returns>False if the document has no revisions, otherwise true</returns>
 public bool DocumentHasRevision(int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documentRevisions = from dr in context.Documentrevisions
                                 where dr.documentId == documentId
                                 select dr;
         return documentRevisions.Count<Documentrevision>() != 0;
     }
 }
Пример #39
0
 /// <summary>
 /// Delete a users reference to a document
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <param name="documentId">The id of the document</param>
 public void DeleteDocumentReference(int userId, int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var userDocuments = from dr in context.Userdocuments
                             where dr.documentId == documentId & dr.userId == userId
                             select dr;
         if (userDocuments.Count<Userdocument>() > 0)
         {
             Userdocument userDocument = userDocuments.First<Userdocument>();
             context.Userdocuments.DeleteObject(userDocument);
             context.SaveChanges();
         }
     }
 }
Пример #40
0
 /// <summary>
 /// Moves a document from one folder to another
 /// </summary>
 /// <param name="userId">The id of the user whos moving the document</param>
 /// <param name="documentId">The id of the document the user is moving</param>
 /// <param name="newFolderId">The id of the folder the user is moving the document to</param>
 public void MoveDocumentWeb(int userId, int documentId, int newFolderId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var userdocument = from ud in context.Userdocuments
                            where ud.userId == userId && ud.documentId == documentId
                            select ud;
         userdocument.First<Userdocument>().folderId = newFolderId;
         context.SaveChanges();
     }
 }
Пример #41
0
 /// <summary>
 /// Get all userdocuments of a specific user
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <returns>All userdocuments this user is subscribed to</returns>
 public List<Userdocument> GetAllUserDocumentsByUserId(int userId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var userdocs = from ud in context.Userdocuments
                        where ud.userId == userId
                        select ud;
         if (userdocs.Count<Userdocument>() > 0)
         {
             return userdocs.ToList();
         }
         else
         {
             //No documents found
             return null;
         }
     }
 }
Пример #42
0
 /// <summary>
 /// Get a user from the database
 /// </summary>
 /// <param name="userId">The email of the user</param>
 /// <returns>The user with the given id. Null if no user has that id</returns>
 public User GetUserByEmail(String email)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var users = from u in context.Users
                     where u.email == email
                     select u;
         User user = null;
         if (users.Count<User>() > 0)
         {
             user = users.First<User>();
         }
         return user;
     }
 }
Пример #43
0
        /// <summary>
        /// Retrieve user from database using email and sha1 encrypted password
        /// </summary>
        /// <param name="email">user email</param>
        /// <param name="pass">corresponding password encrypted using sha1</param>
        /// <returns>return null if user does not exist and the corresponding User object if the user exists</returns>
        public User GetUserByEmailAndPass(String email, String pass)
        {
            using (PieFactoryEntities context = new PieFactoryEntities())
            {
                var user = from u in context.Users
                           where u.email == email && u.password == pass
                           select u;

                if (user.Count<User>() > 0)
                {
                    return user.First<User>();
                }
                return null;
            }
        }
Пример #44
0
 /// <summary>
 /// Get a user from the database
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <returns>The user with the given id. Null if no user has that id</returns>
 public User GetUserById(int userId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var users = from u in context.Users
                     where u.id == userId
                     select u;
         User user = null;
         if (users.Count<User>() > 0)
         {
             user = users.First<User>();
         }
         return user;
     }
 }
Пример #45
0
 /// <summary>
 /// Get a userdocument from the database
 /// </summary>
 /// <param name="userId">The userId of the userdocument</param>
 /// <param name="documentId">The documentId of the userdocument</param>
 /// <returns>The Userdocument with the given userId and documentId. Null if none exists</returns>
 public Userdocument GetUserdocument(int userId, int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var userdocuments = from ud in context.Userdocuments
                             where ud.userId == userId && ud.documentId == documentId
                             select ud;
         Userdocument userdocument = null;
         if (userdocuments.Count<Userdocument>() > 0)
         {
             userdocument = userdocuments.First<Userdocument>();
         }
         return userdocument;
     }
 }
Пример #46
0
 /// <summary>
 /// Gets the latest revision of a specific document submitted by a specific user.
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <param name="documentId">The id of the document</param>
 /// <returns>The revision of the specified document</returns>
 public Documentrevision GetUsersLatestDocumentRevision(int userId, int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documentrevisions = from dr in context.Documentrevisions
                                 where dr.editorId == userId && dr.documentId == documentId
                                 orderby dr.creationTime descending
                                 select dr;
         if (documentrevisions.Count<Documentrevision>() > 0)
         {
             return documentrevisions.ToList<Documentrevision>()[0];
         }
         return null;
     }
 }
Пример #47
0
 /// <summary>
 /// Check if a folder exists
 /// </summary>
 /// <param name="parentFolderId">The id of the parentfolder</param>
 /// <param name="name">The name of the folder</param>
 /// <returns>The id of the folder if it exists, else -1</returns>
 public int FolderExists(int parentFolderId, string name)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var folder = from f in context.Folders
                      where f.parentFolderId == parentFolderId && f.name == name
                      select f;
         if (folder.Count<Folder>() > 0)
         {
             return folder.First<Folder>().id;
         }
         return -1;
     }
 }
Пример #48
0
 /// <summary>
 /// Gets the folders with a specific parent id.
 /// </summary>
 /// <param name="parentId">The parent id of the folders</param>
 /// <returns>The folders with the parentId</returns>
 public List<Folder> GetFoldersByRootId(int parentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var folders = from f in context.Folders
                       where f.parentFolderId == parentId
                       select f;
         List<Folder> folderList = new List<Folder>();
         foreach (Folder f in folders)
         {
             folderList.Add(f);
         }
         return folderList;
     }
 }
Пример #49
0
 /// <summary>
 /// Delete a folder from the database
 /// </summary>
 /// <param name="folderId">The id of the folder to delete</param>
 public void DeleteFolder(int folderId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var folders = from f in context.Folders
                       where f.id == folderId
                       select f;
         if (folders.Count<Folder>() > 0)
         {
             Folder folder = folders.First<Folder>();
             context.Folders.DeleteObject(folder);
             context.SaveChanges();
         }
     }
 }
Пример #50
0
 /// <summary>
 /// Get a folder from the database
 /// </summary>
 /// <param name="folderId">The id of the folder</param>
 /// <returns>The folder with the given id. Null if no folder has that id</returns>
 public Folder GetFolder(int folderId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var folders = from f in context.Folders
                       where f.id == folderId
                       select f;
         Folder folder = null;
         if (folders.Count<Folder>() > 0)
         {
             folder = folders.First<Folder>();
         }
         return folder;
     }
 }
Пример #51
0
 /// <summary>
 /// Delete a document from the database
 /// </summary>
 /// <param name="documentId">The id of the document to delete</param>
 public void DeleteDocument(int documentId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documents = from d in context.Documents
                         where d.id == documentId
                         select d;
         if (documents.Count<Document>() > 0)
         {
             Document document = documents.First<Document>();
             context.Documents.DeleteObject(document);
             context.SaveChanges();
         }
     }
 }
Пример #52
0
        /// <summary>
        /// Gets all document revisions from a single document.
        /// </summary>
        /// <param name="documentId">The id of the document</param>
        /// <returns>A list of all document revisions from the original document</returns>
        public List<Documentrevision> GetDocumentRevisions(int documentId)
        {
            using (PieFactoryEntities context = new PieFactoryEntities())
            {
                var documentRevisions = from dr in context.Documentrevisions
                                        where dr.documentId == documentId
                                        select dr;

                List<Documentrevision> documentRevisionList = new List<Documentrevision>();
                foreach (Documentrevision dr in documentRevisions)
                {
                    documentRevisionList.Add(dr);
                }
                return documentRevisionList;
            }
        }
Пример #53
0
 /// <summary>
 /// Alters a userdocument, effectively moving the document from one folder to another
 /// </summary>
 /// <param name="userId">The id of the user</param>
 /// <param name="documentId">The id of the document</param>
 /// <param name="filepath">the path to the document</param>
 public void AlterUserDocument(int userId, int documentId, String filepath)
 {
     int folderId = GetFolderIdByDirectoryPath(userId, filepath);
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var userdocuments = from ud in context.Userdocuments
                             where ud.userId == userId && ud.documentId == documentId
                             select ud;
         Userdocument userdocument = userdocuments.First<Userdocument>();
         userdocument.folderId = folderId;
         context.SaveChanges();
     }
 }
Пример #54
0
 /// <summary>
 /// Gets a documentrevision by its id
 /// </summary>
 /// <param name="documentRevisionId">The id of the document revision</param>
 /// <returns>The documentrevision with the given id</returns>
 public Documentrevision GetDocumentRevisionById(int documentRevisionId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         var documentrevision = from dr in context.Documentrevisions
                                where dr.id == documentRevisionId
                                select dr;
         return documentrevision.First<Documentrevision>();
     }
 }
Пример #55
0
 /// <summary>
 /// Adds a user to the database.
 /// </summary>
 /// <param name="email">The email of the user</param>
 /// <param name="password">The encrypted password of the user</param>
 /// <returns>The id of the added user. -1 if a user with the given email already exists</returns>
 public int AddUser(String email, String password)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         User user = new User();
         user.email = email;
         user.password = password;
         //Add a root folder named "root"
         Folder folder = new Folder();
         folder.name = "root";
         user.Folder = folder;
         context.Users.AddObject(user);
         context.SaveChanges();
         return user.id;
     }
 }
Пример #56
0
 /// <summary>
 /// Adds a folder to the database.
 /// </summary>
 /// <param name="name">The name of the folder</param>
 /// <param name="parentFolderId">The id of the parent folder. Null if it's a root folder.</param>
 public int AddFolder(String name, int parentFolderId)
 {
     using (PieFactoryEntities context = new PieFactoryEntities())
     {
         Folder folder = new Folder();
         folder.name = name;
         folder.parentFolderId = parentFolderId;
         context.Folders.AddObject(folder);
         context.SaveChanges();
         return folder.id;
     }
 }