public async Task <List <AppUser> > Handle(Command request, CancellationToken cancellationToken)
{
var exists = await _context.SearchAllUsers.FirstOrDefaultAsync(s => s.UserId == request.UserId && s.Input == request.Input);
if (exists != null)
{
exists.DateTimeCreated = DateTime.Now;
}
else
{
var existsUser = await _context.Users.FirstOrDefaultAsync(u => u.Name == request.Input);
if (existsUser == null)
{
return(await _context.Users.Where(u => u.Name.StartsWith(request.Input))
.Select(u => new AppUser
{
Id = u.Id,
Name = u.Name,
Email = u.Email,
CountFollowers = u.CountFollowers,
CountFollowing = u.CountFollowing,
NumberOfActivities = u.Activities.Count(),
CoverImageExtension = u.CoverImageExtension
})
.ToListAsync());
}
var dbInput = new SearchAllUsers
{
Id = Guid.NewGuid(),
UserId = request.UserId,
Input = request.Input,
DateTimeCreated = DateTime.Now
};
_context.SearchAllUsers.Add(dbInput);
}
var succes = await _context.SaveChangesAsync() > 0;
if (succes)
{
return(await _context.Users.Where(u => u.Name.StartsWith(request.Input))
.Select(u => new AppUser
{
Id = u.Id,
Name = u.Name,
Email = u.Email,
CountFollowers = u.CountFollowers,
CountFollowing = u.CountFollowing,
CoverImageExtension = u.CoverImageExtension,
NumberOfActivities = u.Activities.Count()
})
.ToListAsync());
}
throw new Exception("Error saving input search all users to db");
}
public ActionResult SearchUsersPartial(string userId, string keyWord, int currentPage)
{
AppUser currentUser = userManager.Users.FirstOrDefault(u => u.Id == userId);
List <AppUser> users = new List <AppUser>();
foreach (AppUser user in userManager.Users.Where(u => u.CompanyName == currentUser.CompanyName))
{
if (SearchWordExists(user.FirstName, keyWord))
{
users.Add(user);
}
else if (SearchWordExists(user.LastName, keyWord))
{
users.Add(user);
}
else if (SearchWordExists(user.UserName, keyWord))
{
users.Add(user);
}
}
SearchAllUsers allUsers = new SearchAllUsers
{
AllUsers = users.AsQueryable()
.OrderBy(u => u.LastName)
.Skip((currentPage - 1) * MaxSearchPageUsers)
.Take(MaxSearchPageUsers),
UserPageInfo = new SearchUserPageInfo
{
CurrentPage = currentPage,
TotalUsers = users.AsQueryable().Count(),
UsersPerPage = MaxSearchPageUsers
}
};
return(PartialView("SearchUserPartial", allUsers));
}
public async Task <ViewResult> Search(string id, string KeyWord)
{
ViewData["Id"] = id;
AppUser currentUser = userManager.Users.FirstOrDefault(u => u.Id == id);
//users
List <AppUser> users = new List <AppUser>();
foreach (AppUser user in userManager.Users.Where(u => u.CompanyName == currentUser.CompanyName))
{
if (SearchWordExists(user.FirstName, KeyWord))
{
users.Add(user);
}
else if (SearchWordExists(user.LastName, KeyWord))
{
users.Add(user);
}
else if (SearchWordExists(user.UserName, KeyWord))
{
users.Add(user);
}
}
SearchAllUsers allUsers = new SearchAllUsers
{
AllUsers = users.AsQueryable().OrderBy(u => u.LastName)
.Take(MaxSearchPageUsers),
UserPageInfo = new SearchUserPageInfo
{
CurrentPage = 1,
TotalUsers = users.AsQueryable().Count(),
UsersPerPage = MaxSearchPageUsers
}
};
//courses for ALL USERS
//& presentations
List <SearchCourse> courses = new List <SearchCourse>();
List <SearchPresentation> presentations = new List <SearchPresentation>();
List <SearchRepresentation> representations = new List <SearchRepresentation>();
List <SearchVideo> videos = new List <SearchVideo>();
List <SearchFiles> files = new List <SearchFiles>();
foreach (Course course in repository.Courses.Where(c => c.Status == "Public" &&
(c.CreatedBy.CompanyName == currentUser.CompanyName ||
c.CreatedBy.CompanyName == null)))
{
if (SearchWordExists(course.Title, KeyWord))
{
SearchCourse searchCourse = new SearchCourse
{
Course = course,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == course.CreatedBy.Id)
};
courses.Add(searchCourse);
}
//course video
if (repository.Videos.Any(v => v.Id == course.VideoId))
{
Video courseVideo = repository.Videos.FirstOrDefault(v => v.Id == course.VideoId);
if (SearchWordExists(courseVideo.Title, KeyWord))
{
string info = $"<span class='text-muted'>For: <i class='{course.AwardIcon}'></i>" +
$"<strong>{course.Title}</strong></span>";
SearchVideo searchVideoC = new SearchVideo
{
Video = courseVideo,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == courseVideo.CreatedBy),
VideoForInfo = info
};
videos.Add(searchVideoC);
}
}
foreach (Presentation presentation in course.Presentations)
{
if (SearchWordExists(presentation.Title, KeyWord))
{
SearchPresentation searchPresentation = new SearchPresentation
{
Presentation = presentation,
Course = course,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == course.CreatedBy.Id)
};
presentations.Add(searchPresentation);
}
//presentation video
if (repository.Videos.Any(v => v.Id == presentation.VideoId))
{
Video presentationVideo = repository.Videos.FirstOrDefault(v => v.Id == presentation.VideoId);
if (SearchWordExists(presentationVideo.Title, KeyWord))
{
string info = $"<span class='text-muted'>For: <strong>{presentation.Title}</strong> <i class='{course.AwardIcon}'></i>" +
$"<strong>{course.Title}</strong></span>";
SearchVideo searchVideoP = new SearchVideo
{
Video = presentationVideo,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == presentationVideo.CreatedBy),
VideoForInfo = info
};
videos.Add(searchVideoP);
}
}
//presentation files
foreach (PresentationFiles file1 in repository.PresentationFiles
.Where(f => f.PresentationId == presentation.PresentationId))
{
if (SearchWordExists(file1.Title, KeyWord))
{
string info = $"<span class='text-muted'>For: <strong>{presentation.Title}</strong> <i class='{course.AwardIcon}'></i>" +
$"<strong>{course.Title}</strong></span>";
SearchFiles searchFile1 = new SearchFiles
{
File = file1,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == presentation.CreatedBy.Id),
FileForInfo = info
};
files.Add(searchFile1);
}
}
foreach (Representation representation in presentation.Representations)
{
if (SearchWordExists(representation.Title, KeyWord))
{
SearchRepresentation searchRepresentation = new SearchRepresentation
{
Representation = representation,
PresentationTitle = presentation.Title,
Course = course,
Video = repository.Videos.FirstOrDefault(v => v.Id == representation.VideoId),
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == representation.CreatedBy.Id)
};
representations.Add(searchRepresentation);
}
//representation video
if (repository.Videos.Any(v => v.Id == representation.VideoId))
{
Video representationVideo = repository.Videos.FirstOrDefault(v => v.Id == representation.VideoId);
if (SearchWordExists(representationVideo.Title, KeyWord))
{
if (repository.VideoShareds.Any(v => v.UserId == currentUser.Id &&
v.VideoId == representationVideo.Id) ||
await userManager.IsInRoleAsync(currentUser, "Admin") == true ||
await userManager.IsInRoleAsync(currentUser, "Manager") == true ||
representationVideo.CreatedBy == currentUser.Id)
{
string info = $"<span class='text-muted'>For: <strong>{representation.Title}</strong> <strong>{presentation.Title}</strong> <i class='{course.AwardIcon}'></i>" +
$"<strong>{course.Title}</strong></span>";
SearchVideo searchVideoR = new SearchVideo
{
Video = representationVideo,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == representationVideo.CreatedBy),
VideoForInfo = info
};
videos.Add(searchVideoR);
}
}
}
}
}
}
//courses where currentUser == course.CreatedBy && status == "Private"
//& presentations
foreach (Course course in repository.Courses.Where(c => c.Status == "Private" &&
(c.CreatedBy.CompanyName == currentUser.CompanyName ||
c.CreatedBy.CompanyName == null)))
{
if (course.CreatedBy != null)
{
if (course.CreatedBy.Id == currentUser.Id)
{
if (SearchWordExists(course.Title, KeyWord))
{
SearchCourse searchCourse = new SearchCourse
{
Course = course,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == course.CreatedBy.Id)
};
courses.Add(searchCourse);
}
//course video
if (repository.Videos.Any(v => v.Id == course.VideoId))
{
Video courseVideo = repository.Videos.FirstOrDefault(v => v.Id == course.VideoId);
if (SearchWordExists(courseVideo.Title, KeyWord))
{
string info = $"<span class='text-muted'>For: <i class='{course.AwardIcon}'></i>" +
$"<strong>{course.Title}</strong></span>";
SearchVideo searchVideoC = new SearchVideo
{
Video = courseVideo,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == courseVideo.CreatedBy),
VideoForInfo = info
};
videos.Add(searchVideoC);
}
}
foreach (Presentation presentation in course.Presentations)
{
if (SearchWordExists(presentation.Title, KeyWord))
{
SearchPresentation searchPresentation = new SearchPresentation
{
Presentation = presentation,
Course = course,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == course.CreatedBy.Id)
};
presentations.Add(searchPresentation);
}
//presentation video
if (repository.Videos.Any(v => v.Id == presentation.VideoId))
{
Video presentationVideo = repository.Videos.FirstOrDefault(v => v.Id == presentation.VideoId);
if (SearchWordExists(presentationVideo.Title, KeyWord))
{
string info = $"<span class='text-muted'>For: <strong>{presentation.Title}</strong> <i class='{course.AwardIcon}'></i>" +
$"<strong>{course.Title}</strong></span>";
SearchVideo searchVideoP = new SearchVideo
{
Video = presentationVideo,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == presentationVideo.CreatedBy),
VideoForInfo = info
};
videos.Add(searchVideoP);
}
}
//presentation files
foreach (PresentationFiles file2 in repository.PresentationFiles
.Where(f => f.PresentationId == presentation.PresentationId))
{
if (SearchWordExists(file2.Title, KeyWord))
{
string info = $"<span class='text-muted'>For: <strong>{presentation.Title}</strong> <i class='{course.AwardIcon}'></i>" +
$"<strong>{course.Title}</strong></span>";
SearchFiles searchFile2 = new SearchFiles
{
File = file2,
CreatedBy = userManager.Users.FirstOrDefault(u => u.Id == presentation.CreatedBy.Id),
FileForInfo = info
};
files.Add(searchFile2);
}
}
}
}
}
}
SearchAllCourses allCourses = new SearchAllCourses
{
AllCourses = courses.AsQueryable().OrderBy(c => c.Course.Title)
.Take(MaxSearchPageCourse),
CoursePageInfo = new SearchCoursePageInfo
{
CurrentPage = 1,
TotalCourses = courses.AsQueryable().Count(),
CoursesPerPage = MaxSearchPageCourse
}
};
SearchAllPresentation allPresentation = new SearchAllPresentation
{
AllPresentations = presentations.AsQueryable()
.OrderBy(p => p.Presentation.Title)
.Take(MaxSearchPagePresentation),
PresentationPageInfo = new SearchPresentationPageInfo
{
CurrentPage = 1,
TotalPresentations = presentations.AsQueryable().Count(),
PresentationsPerPage = MaxSearchPagePresentation
}
};
SearchAllRepresentation allRepresentation = new SearchAllRepresentation
{
AllRepresentation = representations.AsQueryable()
.OrderBy(r => r.Representation.Title)
.Take(MaxSearchPageRepresentation),
RepresentationPageInfo = new SearchRepresentationPageInfo
{
CurrentPage = 1,
TotalRepresentation = representations.AsQueryable().Count(),
RepresentationPerPage = MaxSearchPageRepresentation
}
};
SearchAllVideos allVideos = new SearchAllVideos
{
AllVideos = videos.AsQueryable()
.OrderBy(v => v.Video.Title)
.Take(MaxSearchPageVideo),
VideoPageInfo = new SearchVideoPageInfo
{
CurrentPage = 1,
TotalVideos = videos.Count(),
VideosPerPage = MaxSearchPageVideo
}
};
SearchAllFiles allFiles = new SearchAllFiles
{
AllFiles = files.AsQueryable()
.OrderBy(f => f.File.Title)
.Take(MaxSearchPageFile),
FilePageInfo = new SearchFilesPageInfo
{
CurrentPage = 1,
TotalFiles = files.Count(),
FilesPerPage = MaxSearchPageFile
}
};
return(View("Search", new SearchViewModel
{
KeyWord = KeyWord,
Users = allUsers,
Courses = allCourses,
Presentations = allPresentation,
Representations = allRepresentation,
Videos = allVideos,
Files = allFiles
}));
}