public RoleModel GetById(int id)
{
using (_repository = _getRepository())
{
return _repository.Get(id);
}
}
public StatusModel Get(int id)
{
using (_repository = _getRepository())
{
return _repository.Get(id);
}
}
public IEnumerable<UserModel> GetAll()
{
using (_repository = _getRepository())
{
return _repository.Get(item => item.webpages_Roles).ToArray();
}
}
public CategoryModel Get(int id)
{
using (_repository = _getRepository())
{
return _repository.Get(id);
}
}
public PriorityModel Get(int id)
{
using (_repository = _getRepository())
{
return _repository.Get(id);
}
}
public UserModel GetByUserName(string userName)
{
using (_repository = _getRepository())
{
return _repository.Get(item => item.UserName.Equals(userName), item => item.webpages_Roles).First();
}
}
public UserModel GetById(int id)
{
using (_repository = _getRepository())
{
return _repository.Get(item => item.UserId == id, item => item.webpages_Roles).First();
}
}
public ProjectModel GetProjectByProjectName(string projectName)
{
using (_repository = _getRepository())
{
return _repository.Get(item => item.Name.Equals(projectName)).First();
}
}
public Models.UserProfile GetUserProfileByUserName(string name)
{
using (_userProfileRepository = _userProfileRepositoryInitializer())
{
return Mapper.Map<UserProfile, Models.UserProfile>(_userProfileRepository.Get(u => u.UserName.Equals(name)).SingleOrDefault());
}
}
public IEnumerable<PriorityModel> GetAll()
{
using (_repository = _getRepository())
{
return _repository.Get().ToArray();
}
}
public TaskModel GetTaskByTaskName(string taskName)
{
using (_repository = _getRepository())
{
return _repository.Get(item => item.Name.Equals(taskName)).First();
}
}
public void Update(ProjectModel project)
{
using (_repository = _getRepository())
{
ProjectModel toUpdate = _repository.Get(item => item.Id == project.Id).First();
toUpdate.Name = project.Name;
_repository.Update(toUpdate);
_repository.Save();
}
}
public void SetSalt(int userId, string salt)
{
using (_repository = _getRepository())
{
MembershipModel membership = _repository.Get(userId);
membership.PasswordSalt = salt;
_repository.Update(membership);
_repository.Save();
}
}
private string GetOfflineToken(ObjectId userId)
{
var entity = _entitiesRepository.Get(userId);
if (entity == null)
{
return(null);
}
return(entity.PlatformOfflineToken);
}
public void InitializeCategories()
{
using (_repository = _getRepository())
{
if (!_repository.Get().Any())
{
_repository.Insert(new CategoryModel { Name = "Easy" });
_repository.Insert(new CategoryModel { Name = "Difficult" });
_repository.Save();
}
}
}
public void InitializeRoles()
{
using (_repository = _getRepository())
{
if (!_repository.Get().Any())
{
_repository.Insert(new RoleModel { RoleName = "admin" });
_repository.Insert(new RoleModel { RoleName = "user" });
_repository.Save();
}
}
}
public Models.webpages_Membership GetMembershipByUserName(string userName)
{
using (_userProfileRepository = _userProfileRepositoryInitializer())
{
IQueryable<UserProfile> foundUserProfilesByName = _userProfileRepository.Get(u => u.UserName.Equals(userName));
int userId = foundUserProfilesByName.Any() ? foundUserProfilesByName.Single().UserId : 0;
using (_membershipRepository = _membershipRepositoryInitializer())
{
return Mapper.Map<webpages_Membership, Models.webpages_Membership>(_membershipRepository.Get(userId));
}
}
}
public string GetPasswordSaltByUserName(string userName)
{
using (_userProfileRepository = _userProfileRepositoryInitializer())
{
IQueryable<UserProfile> foundUserProfilesByName = _userProfileRepository.Get(u => u.UserName.Equals(userName));
int userId = foundUserProfilesByName.Any() ? foundUserProfilesByName.Single().UserId : 0;
using (_membershipRepository = _membershipRepositoryInitializer())
{
return _membershipRepository.Get(userId).PasswordSalt;
}
}
}
public void Update(SlotModel slot)
{
using (_repository = _getRepository())
{
SlotModel toUpdate = _repository.Get(item => item.Id == slot.Id).First();
toUpdate.Name = slot.Name;
toUpdate.StartDate = slot.StartDate;
toUpdate.FinishDate = slot.FinishDate;
toUpdate.TaskId = slot.TaskId;
_repository.Update(toUpdate);
_repository.Save();
}
}
public void UpdateCreated(UserModel user)
{
using (_repository = _getRepository())
{
UserModel toUpdate = _repository.Get(item => item.UserName.Equals(user.UserName)).First();
int roleId = user.webpages_Roles.First().RoleId;
toUpdate.webpages_Roles = new []
{
_repository.GetAnother<Model.RoleModel>(item => item.RoleId == roleId).First()
};
_repository.Update(toUpdate);
_repository.Save();
}
}
public void InitializeTypes()
{
using (_repository = _getRepository())
{
if (!_repository.Get().Any())
{
_repository.Insert(new TypeModel { Name = "Epic" });
_repository.Insert(new TypeModel { Name = "Task" });
_repository.Insert(new TypeModel { Name = "Bug" });
_repository.Insert(new TypeModel { Name = "Exception" });
_repository.Save();
}
}
}
public void InitializePriorities()
{
using (_repository = _getRepository())
{
if (!_repository.Get().Any())
{
_repository.Insert(new PriorityModel { Name = "Low" });
_repository.Insert(new PriorityModel { Name = "Medium" });
_repository.Insert(new PriorityModel { Name = "High" });
_repository.Insert(new PriorityModel { Name = "Very high" });
_repository.Save();
}
}
}
public void Update(UserModel user)
{
using (_repository = _getRepository())
{
UserModel toUpdate = _repository.Get(item => item.UserId == user.UserId, item => item.webpages_Roles).First();
toUpdate.UserName = user.UserName;
int roleId = user.webpages_Roles.First().RoleId;
toUpdate.webpages_Roles.Clear();
toUpdate.webpages_Roles.Add(
_repository.GetAnother<Model.RoleModel>(item => item.RoleId == roleId).First()
);
_repository.Update(toUpdate);
_repository.Save();
}
}
public void InitializeStatuses()
{
using (_repository = _getRepository())
{
if (!_repository.Get().Any())
{
_repository.Insert(new StatusModel { Name = "Active" });
_repository.Insert(new StatusModel { Name = "Completed" });
_repository.Insert(new StatusModel { Name = "Suspended" });
_repository.Insert(new StatusModel { Name = "New" });
_repository.Insert(new StatusModel { Name = "Reactivated" });
_repository.Save();
}
}
}
public void UpdateEntityOfflineToken(ObjectId id)
{
// TODO : Extract to other places, we might want to use it
var entity = _entitiesRepository.Get(id);
if (!string.IsNullOrWhiteSpace(entity.PlatformOfflineToken))
{
return;
}
var offlineToken = _authService.GetOfflineToken(entity.OriginalId);
entity.PlatformOfflineToken = offlineToken;
_entitiesRepository.Update(entity);
}
public void Update(TaskModel task)
{
using (_repository = _getRepository())
{
TaskModel toUpdate = _repository.Get(item => item.Id == task.Id).First();
toUpdate.Name = task.Name;
toUpdate.Description = task.Description;
toUpdate.TimeEstimate = task.TimeEstimate;
toUpdate.StartDate = task.StartDate;
toUpdate.FinishDate = task.FinishDate;
toUpdate.Filepath = task.Filepath;
toUpdate.Version = task.Version;
toUpdate.ProjectId = task.ProjectId;
toUpdate.AssignedPersonId = task.AssignedPersonId;
toUpdate.AssigningPersonId = task.AssigningPersonId;
toUpdate.CategoryId = task.CategoryId;
toUpdate.StatusId = task.StatusId;
toUpdate.PriorityId = task.PriorityId;
toUpdate.TypeId = task.TypeId;
_repository.Update(toUpdate);
_repository.Save();
}
}
public UpdateEntityValidator(IEntitiesRepository <ObjectIdentifier> entitiesRepository)
{
this.RuleFor(e => e.Id)
.NotEmpty()
.Must((command, id) =>
{
if (!ObjectIdentifier.TryParse(id, out ObjectIdentifier entityId))
{
return(false);
}
var entity = entitiesRepository.Get(entityId);
return(entity != null);
})
.WithMessage("Entity with such id doesn't exist");
this.RuleFor(e => e.Name)
.NotEmpty()
.Must(name => entitiesRepository.Find(new FindEntityByName(name)) == null)
.WithMessage("Entity with such name already exists");
this.RuleFor(e => e.Description).NotEmpty();
}
public IActionResult Get(int id)
{
var data = _repository.Get(id);
return(Helper.CheckResult(data));
}