public LibraryAsset AddDocLibraryAsset(LibraryAsset libraryAsset)
{
using (var uow = new UnitOfWork())
{
if (libraryAsset.LibraryAssetFiles.IsCollectionValid())
{
uow.GetRepository<LibraryAsset>().Items
.SelectMany(x => x.LibraryAssetFiles)
.Each(s => uow.GetRepository<LibraryAssetFile>().Items.ToList().Add(s));
}
uow.GetRepository<LibraryAsset>().Insert(libraryAsset);
uow.SaveChanges();
return libraryAsset;
}
}
public User AddUser(User user)
{
using (var uow = new UnitOfWork())
{
if (user.UserLogins.IsCollectionValid())
{
var saltKey = EncryptionExtensions.CreateSaltKey();
foreach (var userLogin in user.UserLogins)
{
userLogin.saltkey = saltKey;
var encryptedPassword = EncryptionExtensions.CreatePasswordHash(userLogin.Password,
userLogin.saltkey);
userLogin.Password = encryptedPassword;
var encryptedSecurityAnswer = EncryptionExtensions.CreatePasswordHash(userLogin.SecurityAnswer, userLogin.saltkey);
userLogin.SecurityAnswer = encryptedSecurityAnswer;
}
foreach (var userHistory in user.UserLogins.Select(x => x.UserHistories.FirstOrDefault()))
{
userHistory.saltkey = saltKey;
var encryptCaptcha = EncryptionExtensions.Encrypt(userHistory.Captcha);
var encryptedPasswordCap = EncryptionExtensions.CreatePasswordCapHash(user.UserLogins.First().Password, userHistory.saltkey, encryptCaptcha);
userHistory.PasswordCap = encryptedPasswordCap;
userHistory.Captcha = encryptCaptcha;
userHistory.CreatedDate = DateTime.Now;
}
}
if (user.UserLogins.IsCollectionValid())
{
user.UserLogins.SelectMany(x => x.UserHistories).Each(s => uow.GetRepository<UserHistory>().Items.ToList().Add(s));
}
uow.GetRepository<User>().Insert(user);
uow.SaveChanges();
var usrHstry = user.UserLogins.Select(x => x.UserHistories.FirstOrDefault()).FirstOrDefault();
UpdateUserLogin(usrHstry);
return user;
}
}
public User UpdateUserProfile(User user)
{
if (user.Id != 0 && user.IsNotNull())
{
using (var uow = new UnitOfWork())
{
var userLogin = user.UserLogins.FirstOrDefault();
var userLoginFrmDb = uow.GetRepository<UserLogin>().Items.FirstOrDefault(x => x.Id == userLogin.Id);
if (userLoginFrmDb.IsNotNull())
{
userLoginFrmDb.UserName = userLogin.UserName;
userLoginFrmDb.SecurityQuestionId = userLogin.SecurityQuestionId;
uow.GetRepository<UserLogin>().Update(userLoginFrmDb);
var userFromDb = uow.GetRepository<User>().Items.FirstOrDefault(x => x.Id == user.Id);
var assignedUser = AssignUserToDbUser(user, userFromDb);
uow.GetRepository<User>().Update(assignedUser);
uow.SaveChanges();
}
}
}
return new User();
}
public void AddDepartmentInOrg(List<DepartmentInOrganization> deptInOrg)
{
using (var uow = new UnitOfWork())
{
foreach (var departmentInOrg in deptInOrg)
{
var checkDeptExists = uow.GetRepository<DepartmentInOrganization>().Items.FirstOrDefault(x => x.DepartmentId == departmentInOrg.DepartmentId);
if (checkDeptExists.IsNull())
{
uow.GetRepository<DepartmentInOrganization>().Insert(departmentInOrg);
}
}
uow.SaveChanges();
}
}
private void UpdateOrgInUser(Organization organization)
{
using (var uow = new UnitOfWork())
{
var userFromDb = uow.GetRepository<User>().Items.FirstOrDefault(x => x.Id == organization.CreatedBy);
userFromDb.OrganizationId = organization.Id;
userFromDb.UpdatedBy = organization.CreatedBy;
userFromDb.UpdatedDate = DateTime.Now;
userFromDb.IsOrgSuperAdmin = true;
userFromDb.AdminApprove = true;
uow.GetRepository<User>().Update(userFromDb);
uow.SaveChanges();
}
}
public void UpdateUserByAdmin(long id, bool isActive)
{
using (var uow = new UnitOfWork())
{
var user = uow.GetRepository<User>().Items.FirstOrDefault(x => x.Id == id);
user.AdminApprove = isActive;
uow.GetRepository<User>().Update(user);
uow.SaveChanges();
}
}
public Role AddRole(Role role)
{
using (var uow = new UnitOfWork())
{
uow.GetRepository<Role>().Insert(role);
uow.SaveChanges();
return role;
}
}
public Organization AddOrganization(Organization organization)
{
using (var uow = new UnitOfWork())
{
if (organization.LibraryFolders != null)
{
var libFolders = CreateDefaultFolder(organization.LibraryFolders);
organization.LibraryFolders = libFolders;
organization.LibraryFolders.SelectMany(x => x.LibraryAssets)
.Each(la => uow.GetRepository<LibraryAsset>().Items.ToList().Add(la));
organization.LibraryFolders.SelectMany(x => x.LibraryAssets)
.SelectMany(lf => lf.LibraryAssetFiles)
.Each(laf => uow.GetRepository<LibraryAssetFile>().Items.ToList().Add(laf));
}
uow.GetRepository<Organization>().Insert(organization);
uow.SaveChanges();
UpdateOrgInUser(organization);
CreateFoldersOnDisk(organization);
return organization;
}
}
public void AddModule(Module module)
{
using (var uow = new UnitOfWork())
{
uow.GetRepository<Module>().Items.SelectMany(x => x.ModuleInDepartments).Each(s => uow.GetRepository<ModuleInDepartment>().Items.ToList().Add(s));
uow.GetRepository<Module>().Insert(module);
uow.SaveChanges();
}
}
public UserHistory AddUserHistory(UserHistory userHistory)
{
using (var uow = new UnitOfWork())
{
var userHstryFmDb = uow.GetRepository<UserHistory>().Items.FirstOrDefault(x => x.Captcha == userHistory.Captcha && x.IpAddress == userHistory.IpAddress);
if (userHstryFmDb == null)
{
var userHstry = new UserHistory()
{
IpAddress = userHistory.IpAddress,
CreatedDate = DateTime.Now,
Captcha = userHistory.Captcha,
saltkey = userHistory.saltkey,
UserloginId = userHistory.UserloginId,
PasswordCap = userHistory.PasswordCap
};
uow.GetRepository<UserHistory>().Insert(userHstry);
uow.SaveChanges();
UpdateUserLogin(userHstry);
}
return userHistory;
}
}
public void DeleteLibraryAsset(LibraryAsset libAsset)
{
using (var uow = new UnitOfWork())
{
var libAssetFile = uow.GetRepository<LibraryAssetFile>().Items.FirstOrDefault(x => x.LibraryAssetId == libAsset.Id);
uow.GetRepository<LibraryAssetFile>().Delete(libAssetFile);
uow.GetRepository<LibraryAsset>().Delete(libAsset);
uow.SaveChanges();
}
}
public string ChangePassword(UserLogin userLogin)
{
using (var uow = new UnitOfWork())
{
var userLoginFrmDb = uow.GetRepository<UserLogin>().Items.FirstOrDefault(x => x.Id == userLogin.Id);
var encryptedPassword = EncryptionExtensions.CreatePasswordHash(userLogin.Password,
userLogin.saltkey);
if (userLoginFrmDb.Password.Equals(encryptedPassword))
return "Current Password and New Password should not be the same.";
userLoginFrmDb.Password = userLogin.Password = encryptedPassword;
var userHstryFrmDb = uow.GetRepository<UserHistory>().Items.Where(x => x.UserloginId == userLogin.Id);
foreach (var item in userHstryFrmDb)
{
var encryptedPasswordCap = EncryptionExtensions.CreatePasswordCapHash(userLogin.Password, item.saltkey, item.Captcha);
item.PasswordCap = encryptedPasswordCap;
uow.GetRepository<UserHistory>().Update(item);
}
userLoginFrmDb.PasswordCap = userHstryFrmDb.FirstOrDefault().PasswordCap;
uow.GetRepository<UserLogin>().Update(userLoginFrmDb);
uow.SaveChanges();
return "Successfully Saved.";
}
}
public bool AddUserRoleDepartment(long id, long roleId, long departmentId)
{
using (var uow = new UnitOfWork())
{
var userRoleDeptFrmDb = uow.GetRepository<UserRoleDepartment>().Items
.Where(x => x.UserId == id && x.RoleId == roleId && x.DepartmentId == departmentId).ToList();
if (!userRoleDeptFrmDb.IsCollectionValid())
{
var userRoleDeptEntity = new UserRoleDepartment()
{
DepartmentId = departmentId,
RoleId = roleId,
UserId = id
};
uow.GetRepository<UserRoleDepartment>().Insert(userRoleDeptEntity);
uow.SaveChanges();
return true;
}
return false;
}
}
public void AddUserInRole(List<UserInRole> userInRoles)
{
using (var uow = new UnitOfWork())
{
foreach (var usr in userInRoles)
{
var userInRole = uow.GetRepository<UserInRole>().Items.Where(x => x.RoleId == usr.RoleId && x.UserId == usr.UserId).ToList();
if (!userInRole.IsCollectionValid())
uow.GetRepository<UserInRole>().Insert(usr);
}
uow.SaveChanges();
}
}
public void AddRoleInPermission(RoleInPermission roleInPermission)
{
using (var uow = new UnitOfWork())
{
uow.GetRepository<RoleInPermission>().Insert(roleInPermission);
uow.SaveChanges();
}
}
public void AddPermission(PermissionSet permissionSet)
{
using (var uow = new UnitOfWork())
{
if (permissionSet.PermissionInSets.IsCollectionValid())
{
foreach (var permissionInSet in permissionSet.PermissionInSets)
{
uow.GetRepository<PermissionInSet>().Items.ToList().Add(permissionInSet);
}
}
uow.GetRepository<PermissionSet>().Insert(permissionSet);
uow.SaveChanges();
}
}
public void AddModuleInDepartment(List<ModuleInDepartment> moduleInDepartment)
{
using (var uow = new UnitOfWork())
{
if (moduleInDepartment.IsCollectionValid())
{
moduleInDepartment.Each(x =>
{
var moduleInDept = uow.GetRepository<ModuleInDepartment>().Items.Where(y => y.ModuleId == x.ModuleId).ToList();
if (!moduleInDept.IsCollectionValid())
uow.GetRepository<ModuleInDepartment>().Insert(x);
});
uow.SaveChanges();
}
}
}
public void UpdateUserLogin(UserHistory userHistory)
{
using (var uow = new UnitOfWork())
{
if (userHistory != null)
{
var userLogin = uow.GetRepository<UserLogin>().Items.FirstOrDefault(x => x.Id == userHistory.UserloginId);
userLogin.PasswordCap = userHistory.PasswordCap;
userLogin.Captcha = userHistory.Captcha;
uow.GetRepository<UserLogin>().Update(userLogin);
uow.SaveChanges();
}
}
}
public void AddDepartment(Department department)
{
using (var uow = new UnitOfWork())
{
uow.GetRepository<Department>().Items.SelectMany(x => x.DepartmentInOrganizations).Each(s => uow.GetRepository<DepartmentInOrganization>().Items.ToList().Add(s));
uow.GetRepository<Department>().Insert(department);
uow.SaveChanges();
}
}