public Response<SearchResponseTutorsModel> GetTutorsList(TutorSearchModel objReq)
        {
            Response<SearchResponseTutorsModel> response = new Response<SearchResponseTutorsModel>();
            List<SearchResponseTutorsModel> objResp = new List<SearchResponseTutorsModel>();


            try
            {
                if (ModelState.IsValid)
                {
                    objDbMethodV2 = new wizz.Dal.DbMethodsV2();
                    if (CheckRequestIsvalidornot(this.Request))
                    {
                        objResp.Add(objDbMethodV2.GetTutorsList(objReq));
                        if (objResp.Count > 0)
                            response.Create(true, "Tutor List", Messages.AppVersion, objResp);
                    }
                    else
                    {
                        response.Create(false, Messages.FormatMessage("Sorry no tutor found !!"), Messages.AppVersion, objResp);
                    }
                }
                else
                    response.Create(false, ModelState.Values.FirstOrDefault().Errors.FirstOrDefault().ErrorMessage, Messages.AppVersion, objResp);
            }
            catch (Exception ex)
            {
                object session = new JavaScriptSerializer().Serialize(objReq);
                LogManager.Error("Error occured while Processing Webservice request :{0}", ex, session, ex.Message);
                response.Create(false, Messages.FormatMessage(Messages.ErrorOccure), Messages.AppVersion, objResp);
            }
            return response;
        }
Example #2
0
        internal List<SearchResponseTutorsModel> GetTutorsList(TutorSearchModel objReq)
        {
            using (var db = new WizzDataContext())
            {
                List<SearchResponseTutorsModel> tutorList = new List<SearchResponseTutorsModel>();
                var userInfo = db.tblStudentRequests.Where(x => x.fkUserId == Convert.ToInt64(objReq.userId)).FirstOrDefault();

                tutorList = (from c in db.usp_P2GetTutorsList(userInfo.fkSubjectId.ToString(), Convert.ToDecimal(userInfo.lat), Convert.ToDecimal(userInfo.longi), userInfo.location, Convert.ToInt32(objReq.distance))
                             select new SearchResponseTutorsModel
                                                {
                                                    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
                                                }).ToList();
                return tutorList;
            }
        }
Example #3
0
        internal SearchResponseTutorsModel GetTutorsList(TutorSearchModel 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_P2GetTutorsList(Convert.ToInt32(objReq.userId),userInfo.fkSubjectId.ToString(), Convert.ToDecimal(userInfo.lat), Convert.ToDecimal(userInfo.longi), userInfo.location, Convert.ToInt32(objReq.distance))
                             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();

                //foreach (var n in objReq.filterList) {

                //    if (n.orderBy == "1")
                //    {
                //        //tutorList = (from t in tutorList

                //        //             select t).OrderByDescending(c => c.perHourFees);

                //            tutorList.Sort(x=>x.perHourFees);

                //    }
                //    else if(n.orderBy=="2") {


                //    }
                //}
                objResponse.tutorList = tutorList;
                return objResponse;
            }
        }