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 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 IsUserInAccessProfile(Guid userId, Guid featureId)
{
using (DockerDBEntities dockerDBEntities = new DockerDBEntities()) {
aspnet_Users user = (from p in dockerDBEntities.aspnet_Users
where p.UserId == userId select p).First();
if (user.FeatureAccessProfiles != null)
{
foreach (FeatureAccessProfile ap in user.FeatureAccessProfiles)
{
if (ap.FeatureId == featureId)
{
return(true);
}
}
}
if (user.aspnet_Roles != null)
{
foreach (aspnet_Roles ar in user.aspnet_Roles)
{
foreach (FeatureAccessProfile ap in ar.FeatureAccessProfiles)
{
if (ap.FeatureId == featureId)
{
return(true);
}
}
}
}
}
return(false);
}
public List <FeatureAccessProfile> GetFeatureAccessProfiles()
{
using (DockerDBEntities dockerDBEntities = new DockerDBEntities()) {
List <FeatureAccessProfile> fap = (from p in dockerDBEntities.FeatureAccessProfiles select p).ToList();
return(fap);
}
}
public List <FeatureProfile> GetALLRegisteredFeatures()
{
using (DockerDBEntities dockerDBEntities = new DockerDBEntities()) {
List <FeatureProfile> fpList = (from p in dockerDBEntities.FeatureProfiles
orderby p.FeatureName select p).ToList();
return(fpList);
}
}
public int GetTotalRolesCount()
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
int count = (from p in dockerEntities.aspnet_Roles
select p).Count();
return(count);
}
}
public List <aspnet_Roles> GetRolesByUserName(String userName)
{
using (DockerDBEntities dockerDBEntities = new DockerDBEntities()) {
var query = (from p in dockerDBEntities.aspnet_Users
where p.UserName == userName select p).First();
return(query.aspnet_Roles.ToList());
}
}
public Guid GetRoleIDByRoleName(String roleName)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
var roleID = (from p in dockerEntities.aspnet_Roles
where p.RoleName == roleName select p.RoleId).First();
return(roleID);
}
}
public Guid GetUserIDByUserName(String userName)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
var query = (from p in dockerEntities.aspnet_Users
where p.UserName == userName select p).First();
return(query.UserId);
}
}
public String[] GetAllUsersFolderInArray(String rootPath)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
String[] usersPath = (from p in dockerEntities.aspnet_Users
select p.UserName).Select(user => rootPath + user).ToArray();
return(usersPath);
}
}
public List <DCE_Templates> getAllUploadedTemplates()
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
List <DCE_Templates> allUploadedTemplates = (from p in dockerEntities.DCE_Templates
select p).ToList();
return(allUploadedTemplates);
}
}
public List <OCRFileExtension> GetFileExtensionsAllowToOCR()
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
List <OCRFileExtension> extList = (from p in dockerEntities.OCRFileExtensions
select p).ToList();
return(extList);
}
}
public int GetTotalFilesAndFolders()
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
int count = (from p in dockerEntities.Files
select p).Count();
return(count);
}
}
public List <DCE_Templates> GetTemplatesFromDB()
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
List <DCE_Templates> templates = (from p in dockerEntities.DCE_Templates
select p).ToList();
return(templates);
}
}
public int GetTotalTemplatesCount()
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
int count = (from p in dockerEntities.DCE_Templates
select p).Count();
return(count);
}
}
public String GetRoleNameByRoleID(Guid roleID)
{
using (DockerDBEntities dockerDBEntities = new DockerDBEntities()) {
var roleName = (from p in dockerDBEntities.aspnet_Roles
where p.RoleId == roleID
select p.RoleName).First();
return(roleName);
}
}
public FileBeenOCR GetFileBeenOCR(Guid fileID)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
FileBeenOCR fileOCR = (from p in dockerEntities.FileBeenOCRs
where p.FileID == fileID
select p).FirstOrDefault();
return(fileOCR);
}
}
public String GetMobileAliasByUserName(String userName)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
var query = (from p in dockerEntities.aspnet_Users
where p.UserName == userName
select p).First();
return(query.MobileAlias);
}
}
public List <TagsOnFile> GetTagsByFileID(Guid fileID)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
List <TagsOnFile> tags = (from p in dockerEntities.TagsOnFiles
where p.FileID == fileID
select p).ToList();
return(tags);
}
}
public String GetFileName(Guid FileID)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
String name = (from p in dockerEntities.Files
where p.ID == FileID
select p.Name).First();
return(name);
}
}
public Guid GetFileIDByVirtualPath(String virtualPath)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
var query = (from p in dockerEntities.Files
where p.VirtualPath == virtualPath
select p).First();
return(query.ID);
}
}
public String GetUserNameByUserID(Guid userID)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
String userName = (from p in dockerEntities.aspnet_Users
where p.UserId == userID
select p.UserName).First();
return(userName);
}
}
public List <FilesDownloadAuditTrail> GetTotalFilesDownloadedAuditTrails()
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
dockerEntities.Configuration.LazyLoadingEnabled = false;
List <FilesDownloadAuditTrail> query = (from p in dockerEntities.FilesDownloadAuditTrails
select p).OrderByDescending(i => i.DateTimeDownloaded).ToList <FilesDownloadAuditTrail>();
return(query);
}
}
public Guid GetFeatureIDByFeatureName(String featureName)
{
using (DockerDBEntities dockerDBEntities = new DockerDBEntities()) {
Guid featureID = (from p in dockerDBEntities.FeatureProfiles
where p.FeatureName == featureName
select p.FeatureId).FirstOrDefault();
return(featureID);
}
}
public String GetRoleDescByRoleName(String roleName)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
var query = (from p in dockerEntities.aspnet_Roles
where p.RoleName == roleName
select p).First();
return(query.Description);
}
}
public bool GetIsAnonymousByUserName(String userName)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
var query = (from p in dockerEntities.aspnet_Users
where p.UserName == userName
select p).First();
return(query.IsAnonymous);
}
}
public static String GetOCRContent(Guid fileID)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
String ocrContent = (from p in dockerEntities.DCE_Templates
where p.FileID == fileID
select p.DocumentOCRContent).FirstOrDefault();
return(ocrContent);
}
}
public static String[] GetAllOCRContentsExcludeFileID(Guid fileID)
{
using (DockerDBEntities dockerEntities = new DockerDBEntities()) {
String[] ocrContents = (from p in dockerEntities.DCE_Templates
where p.FileID != fileID
select p.DocumentOCRContent).ToArray();
return(ocrContents);
}
}
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();
}
}
