public void InsertTemplate(String virtualPath, String docType, String description, String userName) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { File file = (from p in dockerEntities.Files where p.VirtualPath == virtualPath select p).First(); DCE_Templates template = new DCE_Templates(); template.FileID = file.ID; template.Name = file.Name; template.VirtualPath = file.VirtualPath; template.DateTimeUploaded = DateTime.Now; template.Description = description; template.UserID = (from a in dockerEntities.aspnet_Users where a.UserName == userName select a.UserId).First(); template.DocumentType = docType; try { dockerEntities.DCE_Templates.Add(template); dockerEntities.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { System.Diagnostics.Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { System.Diagnostics.Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } } }
public Boolean InsertFeatureAccessProfile(String featureName, String userName, String roleName) { using (DockerDBEntities dockerDBEntities = new DockerDBEntities()) { FeatureAccessProfile fap = (from p in dockerDBEntities.FeatureAccessProfiles where p.FeatureProfile.FeatureName == featureName && (p.aspnet_Users.UserName == userName || p.aspnet_Roles.RoleName == roleName) select p).FirstOrDefault(); if (fap == null) { fap = new FeatureAccessProfile(); fap.FeatureAccessProfileId = Guid.NewGuid(); fap.LastUpdateDate = DateTime.Now; fap.FeatureProfile = (from p in dockerDBEntities.FeatureProfiles where p.FeatureName == featureName select p).First(); if (!String.IsNullOrEmpty(userName)) { fap.aspnet_Users = (from p in dockerDBEntities.aspnet_Users where p.UserName == userName select p).First(); fap.UserId = fap.aspnet_Users.UserId; } if (!String.IsNullOrEmpty(roleName)) { fap.aspnet_Roles = (from p in dockerDBEntities.aspnet_Roles where p.RoleName == roleName select p).First(); fap.RoleId = fap.aspnet_Roles.RoleId; } fap.FeatureId = fap.FeatureProfile.FeatureId; dockerDBEntities.FeatureAccessProfiles.Add(fap); dockerDBEntities.SaveChanges(); return(true); } } return(false); }
public void RenameDocumentTypeByVirtualPath(String virtualPath, String newDocType) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { File file = (from p in dockerEntities.Files where p.VirtualPath == virtualPath select p).First(); file.DCE_Templates.DocumentType = newDocType; dockerEntities.SaveChanges(); } }
public void DeleteTagsByFileID(Guid fileID) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { File file = (from p in dockerEntities.Files where p.ID == fileID select p).First(); dockerEntities.TagsOnFiles.RemoveRange(file.TagsOnFiles); dockerEntities.SaveChanges(); } }
public void UpdateRankByKeywordNFileID(Guid fileID, String keyword, double newRankVal) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { DCE_Keywords dCE_Keywords = (from p in dockerEntities.DCE_Keywords where p.FileID == fileID && p.Keyword == keyword select p).First(); dCE_Keywords.Rank = (float)newRankVal; dockerEntities.SaveChanges(); } }
public void InsertUserLoginAuditTrail(Guid userID) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { UserLoginAuditTrail userLognAuditTrail = new UserLoginAuditTrail(); userLognAuditTrail.UserID = userID; userLognAuditTrail.UserName = (from p in dockerEntities.aspnet_Users where p.UserId == userID select p.UserName).First(); userLognAuditTrail.DateTimeLogged = DateTime.Now; dockerEntities.UserLoginAuditTrails.Add(userLognAuditTrail); dockerEntities.SaveChanges(); } }
public void InsertOCRContents(String fileName, String fileContents, String skipPages) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { DCE_Templates dCE_Templates = (from p in dockerEntities.DCE_Templates where p.Name == fileName select p).First(); dCE_Templates.DocumentOCRContent = fileContents; dCE_Templates.SkipPages = skipPages; dockerEntities.SaveChanges(); } }
public void InsertLockMembershipUserByUserName(string userName) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { aspnet_Users user = (from p in dockerEntities.aspnet_Users where p.UserName == userName select p).First(); user.aspnet_Membership.IsLockedOut = true; user.aspnet_Membership.LastLockoutDate = DateTime.Now; dockerEntities.SaveChanges(); } }
public ActionResult Index(string name) { var obj = new DockerTable() { Name = name }; db.DockerTables.Add(obj); db.SaveChanges(); ViewBag.Names = db.DockerTables.ToList(); return(View()); }
public Boolean DeleteFeatureAccessProfile(String featureName, String userName, String roleName) { using (DockerDBEntities dockerDBEntities = new DockerDBEntities()) { FeatureAccessProfile fap = (from p in dockerDBEntities.FeatureAccessProfiles where p.FeatureProfile.FeatureName == featureName && (p.aspnet_Users.UserName == userName || p.aspnet_Roles.RoleName == roleName) select p).First(); dockerDBEntities.FeatureAccessProfiles.Remove(fap); dockerDBEntities.SaveChanges(); } return(false); }
public void InsertFilesDownloadAuditTrails(Guid FileID, Guid UserID) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { FilesDownloadAuditTrail filesDownloadAuditTrail = new FilesDownloadAuditTrail(); filesDownloadAuditTrail.UserID = UserID; filesDownloadAuditTrail.UserName = (from p in dockerEntities.aspnet_Users where p.UserId == UserID select p.UserName).First(); filesDownloadAuditTrail.FileID = FileID; filesDownloadAuditTrail.FileName = (from p in dockerEntities.Files where p.ID == FileID select p.Name).First(); filesDownloadAuditTrail.DateTimeDownloaded = DateTime.Now; dockerEntities.FilesDownloadAuditTrails.Add(filesDownloadAuditTrail); dockerEntities.SaveChanges(); } }
public void InsertMembershipCommentByUserName(String userName, String Comment) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { aspnet_Users user = (from p in dockerEntities.aspnet_Users where p.UserName == userName select p).First(); if (user != null) { user.aspnet_Membership.Comment = Comment; } dockerEntities.SaveChanges(); } }
public void InsertRoleDescByRoleName(String roleName, String roleDesc) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { aspnet_Roles role = (from p in dockerEntities.aspnet_Roles where p.RoleName == roleName select p).First(); if (role != null) { role.Description = roleDesc; } dockerEntities.SaveChanges(); } }
public void InsertMobilePINByUserName(String userName, String mobilePin) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { aspnet_Users user = (from p in dockerEntities.aspnet_Users where p.UserName == userName select p).First(); if (user.aspnet_Membership != null) { user.aspnet_Membership.MobilePIN = mobilePin; } dockerEntities.SaveChanges(); } }
public void InsertMobileAliasByUserName(String userName, String mobileAlias) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { aspnet_Users user = (from p in dockerEntities.aspnet_Users where p.UserName == userName select p).First(); if (user != null) { user.MobileAlias = mobileAlias; } dockerEntities.SaveChanges(); } }
public void DeleteUploadedTemplateKeywords(Guid fileID) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { List <DCE_Keywords> listKeywords = (from p in dockerEntities.DCE_Keywords where p.FileID == fileID select p).ToList(); foreach (DCE_Keywords keyword in listKeywords) { dockerEntities.DCE_Keywords.Remove(keyword); } dockerEntities.SaveChanges(); } }
public void DeleteUploadedTemplates(String virtualPath) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { List <DCE_Templates> listDCE_Template = (from p in dockerEntities.DCE_Templates where p.VirtualPath == virtualPath select p).ToList(); foreach (DCE_Templates template in listDCE_Template) { dockerEntities.DCE_Templates.Remove(template); } dockerEntities.SaveChanges(); } }
public void RenameFile(String newname, String previousVirtualPath, String newVirtualPath) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { List <File> files = (from p in dockerEntities.Files where p.VirtualPath.StartsWith(previousVirtualPath) select p).ToList(); foreach (File file in files) { file.Name = newname; file.VirtualPath = (file.VirtualPath).Replace(previousVirtualPath, newVirtualPath); } dockerEntities.SaveChanges(); } }
public void InsertFileBeenOCR(Guid fileID, String docType) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { FileBeenOCR fileOCR = new FileBeenOCR(); fileOCR.FileID = fileID; fileOCR.DocumentType = docType; fileOCR.DateTimeRecognised = DateTime.Now; File dbFile = (from p in dockerEntities.Files where p.ID == fileID select p).First(); dbFile.FileBeenOCR = fileOCR; dockerEntities.SaveChanges(); } }
public bool DeleteKeyword(Guid fileID, Guid userID, String keyword) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { DCE_Keywords dCE_Keywords = (from p in dockerEntities.DCE_Keywords where p.FileID == fileID && p.Keyword == keyword select p).FirstOrDefault(); if (dCE_Keywords != null) { dockerEntities.DCE_Keywords.Remove(dCE_Keywords); dockerEntities.SaveChanges(); return(true); } return(false); } }
public bool RemoveRoleOwnership(String userName, String roleName) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { aspnet_Users user = (from p in dockerEntities.aspnet_Users where p.UserName == userName select p).First(); RoleProfile roleProfile = (user.RoleProfiles).Where(role => role.PropertyValuesString.ToLower() == roleName.ToLower()).FirstOrDefault(); if (roleProfile != null) { user.RoleProfiles.Remove(roleProfile); dockerEntities.SaveChanges(); return(true); } return(false); } }
public void RemoveRolesFilesAuthorizations(Guid roleID, Guid fileID) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { aspnet_Roles role = (from p in dockerEntities.aspnet_Roles where p.RoleId == roleID select p).First(); foreach (File file in role.Files.ToList()) { if (file.ID == fileID) { role.Files.Remove(file); break; } } dockerEntities.SaveChanges(); } }
public void InsertRolesFilesAuthorizations(Guid roleID, Guid fileID) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { File file = (from p in dockerEntities.Files where p.ID == fileID select p).First(); aspnet_Roles role = (from p in dockerEntities.aspnet_Roles where p.RoleId == roleID select p).First(); if (!file.aspnet_Roles.Contains(role)) { file.aspnet_Roles.Add(role); dockerEntities.SaveChanges(); } } }
public void InsertUsersFilesAuthorizations(Guid userID, Guid fileID) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { File file = (from p in dockerEntities.Files where p.ID == fileID select p).First(); aspnet_Users user = (from p in dockerEntities.aspnet_Users where p.UserId == userID select p).First(); if (!file.aspnet_Users.Contains(user)) { file.aspnet_Users.Add(user); dockerEntities.SaveChanges(); } } }
public void RemoveUsersFilesAuthorizations(Guid userID, Guid fileID) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { aspnet_Users user = (from p in dockerEntities.aspnet_Users where p.UserId == userID select p).First(); foreach (File file in user.Files.ToList()) { if (file.ID == fileID) { user.Files.Remove(file); break; } } dockerEntities.SaveChanges(); } }
public bool UpdateRole(RoleViewModel roleViewModel, String oldRoleName) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { var role = (from p in dockerEntities.aspnet_Roles where p.RoleName == oldRoleName select p).First(); if (role.RoleName == roleViewModel.OldRoleName) { role.RoleName = roleViewModel.NewRoleName; role.LoweredRoleName = roleViewModel.NewRoleName.ToLower(); role.Description = roleViewModel.Description; dockerEntities.SaveChanges(); return(true); } } return(false); }
public Boolean UpdateFeatureProfile(String oldFeatureName, String newFeatureName, String remarks) { using (DockerDBEntities dockerDBEntities = new DockerDBEntities()) { FeatureProfile fp = (from p in dockerDBEntities.FeatureProfiles where p.FeatureName == oldFeatureName select p).FirstOrDefault(); if (fp != null) { fp.FeatureName = newFeatureName; fp.FeatureRemarks = remarks; fp.LastUpdateDate = DateTime.Now; dockerDBEntities.SaveChanges(); return(true); } } return(false); }
public void RemoveRolesFilesAuthorizationsByRoleID(Guid roleID) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { aspnet_Roles role = (from p in dockerEntities.aspnet_Roles where p.RoleId == roleID select p).First(); foreach (File file in role.Files.ToList()) { role.Files.Remove(file); } foreach (FeatureAccessProfile fap in role.FeatureAccessProfiles.ToList()) { role.FeatureAccessProfiles.Remove(fap); } dockerEntities.SaveChanges(); } }
public void RemoveUsersFilesAuthorizationsByUserName(Guid userID) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { aspnet_Users user = (from p in dockerEntities.aspnet_Users where p.UserId == userID select p).First(); foreach (File file in user.Files.ToList()) { user.Files.Remove(file); } foreach (FeatureAccessProfile fap in user.FeatureAccessProfiles.ToList()) { user.FeatureAccessProfiles.Remove(fap); } dockerEntities.SaveChanges(); } }
public void InsertTagsByFileID(Guid fileID, IEnumerable <String> tags) { using (DockerDBEntities dockerEntities = new DockerDBEntities()) { File file = (from p in dockerEntities.Files where p.ID == fileID select p).First(); dockerEntities.TagsOnFiles.RemoveRange(file.TagsOnFiles); foreach (var webTag in tags) { file.TagsOnFiles.Add(new TagsOnFile { FileID = fileID, TagID = Guid.NewGuid(), TagName = webTag, LastModifiedDateTime = DateTime.Now }); } dockerEntities.SaveChanges(); } }