internal SearchResponseTutorsModel GetTutorBySearchCode(SearchTutorByCodeModel objReq)
{
using (var db = new WizzDataContext())
{
SearchResponseTutorsModel objResponse = new SearchResponseTutorsModel();
List<TutorSearchResponseModel> tutorList = new List<TutorSearchResponseModel>();
// var userInfo = db.tblStudentRequests.Where(x => x.uniqueStudentRequestId == objReq.uniqueRequestId).FirstOrDefault();
tutorList = (from c in db.usp_P2GetTutorBySearchCode(objReq.tutorCode)
select new TutorSearchResponseModel
{
aboutTutor = c.About,
tutorName = c.userName,
tutorProfilePic = c.profilePic,
tutorLocation = c.location,
tutorId = Convert.ToString(c.fkUserId),
passingYear = Convert.ToString(c.passingYear),
tutorRating = Convert.ToString(c.avgRatingTutor),
tutorSubjects = db.usp_P2GetSubjectsForTutor(c.fkUserId).Select(x => x.subjectName).ToList(),
perHourFees = c.feesPerHour,
reviews =
(from r in db.tblTutorRatings.Where(x => x.fkTutorId == c.fkUserId)
select new TutorReviewModel
{
rating = Convert.ToString((r.helpful + r.knowledgable + r.punctual) / 3),
studentName = r.userName,
reviewText = r.review,
}).ToList()
}).ToList();
objResponse.tutorList = tutorList;
return objResponse;
}
}
