public ActionResult Search(string search)
{
var top10 = db.Tutors.Where(c=>c.IsCompletedProfile==true).OrderByDescending(c => c.Rating).Take(10).ToList();
var result = db.Tutors.Where(c => c.Username.Contains( search ) && c.IsCompletedProfile==true).ToList();
var tutorExpertise = db.TutorsExpertise.Where(c => c.category.CategoryName.Contains(search)).ToList();
SearchViewModel obj = new SearchViewModel();
foreach (var v in tutorExpertise)
{
obj.Results.Add(v.tutor);
}
foreach (var v in result)
{
obj.Results.Add(v);
}
obj.Top10 = top10;
return View(obj);
}
public ActionResult Search(string search)
{
var top10 = db.Tutors.Where(c=>c.IsCompletedProfile==true).OrderByDescending(c => c.Rating).Take(10).ToList();
var result = db.Tutors.Where(c => c.Username.Contains( search ) && c.IsCompletedProfile==true).ToList();
var tutorExpertise = db.TutorsExpertise.Where(c => c.category.CategoryName.Contains(search)).ToList();
var onlineUsers = db.online.Where(c => c.Status == true).ToList(); ;
SearchViewModel obj = new SearchViewModel();
if (!string.IsNullOrEmpty(search))
{
foreach (var v in tutorExpertise)
{
var isTutor = onlineUsers.Where(c => c.Username == v.tutor.Username).FirstOrDefault();
if (isTutor != null)
obj.OnlineResults.Add(true);
else
obj.OnlineResults.Add(false);
obj.Results.Add(v.tutor);
}
foreach (var v in result)
{
var isTutor = onlineUsers.Where(c => c.Username == v.Username).FirstOrDefault();
if (isTutor != null)
obj.OnlineResults.Add(true);
else
obj.OnlineResults.Add(false);
obj.Results.Add(v);
}
}
foreach(var v in top10)
{
var isTutor = onlineUsers.Where(c => c.Username == v.Username).FirstOrDefault();
if (isTutor != null)
obj.OnlineTop10.Add(true);
else
obj.OnlineTop10.Add(false);
}
obj.Top10 = top10;
return View(obj);
}