Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
        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);
        }