private bool IsValidUser(string userName, string password)
{
UserRepository repo = new UserRepository();
int count = repo.GetAll().Where(p => p.Username == userName && p.Password == password).Count();
if (count == 1) { return true; }
return false;
}
/// <summary>
/// Checks if a user with the same username already exists
/// in the database.
/// </summary>
/// <param name="username">The user to validate.</param>
/// <returns></returns>
public bool UserExists(String username)
{
UserRepository repo = new UserRepository();
User userMatch = repo.GetAll().Where(p => p.Username == username).SingleOrDefault();
if (userMatch != null)
return true;
return false;
}
protected virtual void EnsureRoles()
{
UserRepository repo = new UserRepository();
ProjectRoleRepository projRoleRepo = new ProjectRoleRepository();
User user = repo.GetAll().Where(p => p.Username == _identity.Name).Single();
IList<Role> userRoles = new List<Role>();
IList<ProjectRole> projRoles = projRoleRepo.GetAll().Where(p => p.User.Id == user.Id).ToList();
foreach (ProjectRole projRole in projRoles)
{
if (!userRoles.Contains(projRole.Role))
userRoles.Add(projRole.Role);
}
_roles = new string[userRoles.Count()];
for (int i = 0; i < _roles.Length; i++)
{
_roles[i] = userRoles[i].RoleName;
}
}
public IList<Bug> SearchAllProjectBugsAttributes(Project project, string searchText)
{
searchText = searchText.Trim();
// if (searchText == null || searchText == "")
// return GetBugsByProject(project);
IList<int> associatedUserIds = new UserRepository().GetAll().FullTextSearch(searchText, true).Select(p => p.Id).ToList();
IList<int> fullTextSearch = new BugRepository() .GetAll().FullTextSearch(searchText, true).Select(p => p.Id).ToList();
if (associatedUserIds.Count == 0 && fullTextSearch.Count == 0)
return new List<Bug>();
int id = 0;
DateTime date = DateTime.MinValue;
try { id = Int32.Parse(searchText); }
catch (Exception e) { Console.WriteLine(e.Message); }
try { date = DateTime.Parse(searchText); }
catch (Exception e) { Console.WriteLine(e.Message); }
return new BugRepository().GetAll()
.Where(p => associatedUserIds.Contains(p.AssignedUser.Id) ||
associatedUserIds.Contains(p.CreatedBy.Id) ||
p.Id == id ||
(p.DateFound.Year == date.Year && p.DateFound.Month == date.Month && p.DateFound.Day == date.Day) ||
(p.LastModified.Year == date.Year && p.LastModified.Month == date.Month && p.LastModified.Day == date.Day) ||
fullTextSearch.Contains(p.Id)).Where(p => p.Project.Id == project.Id).ToList();
}
public User GetMyUser()
{
UserRepository repo = new UserRepository();
return (User)repo.GetAll().Where(p => p.Username == CustomPrincipal.Current.Identity.Name).SingleOrDefault();
}