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();
}
}
