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;
}
}
/// <summary>
/// saving all the stundet Profile Informations
/// </summary>
/// <param name="objReq"></param>
/// <returns></returns>
internal SearchResponseTutorsModel SaveStudentRequest(StudentRequestModelV2 objReq)
{
SearchResponseTutorsModel searchResponse = new SearchResponseTutorsModel();
List<TutorSearchResponseModel> tutorList = new List<TutorSearchResponseModel>();
try
{
using (var db = new WizzDataContext())
{
long userId = Convert.ToInt64(objReq.userId);
tblStudentRequest studentData = new tblStudentRequest();
Guid uniqueRequestId = Guid.NewGuid();
db.tblStudentRequests.Where(x => x.fkUserId == Convert.ToInt64(objReq.userId)).ToList().ForEach(c => c.isDelete = true);
db.SubmitChanges();
//if (previousStudentRequests.Count > 0)
//{
// db.tblStudentRequests.DeleteAllOnSubmit(previousStudentRequests);
// db.SubmitChanges();
//}
// studentData.fkSubjectId = Convert.ToInt32(objReq.subjectId);
List<tblStudentRequest> studentStudentList = new List<tblStudentRequest>();
foreach (var n in objReq.dayList)
{
tblStudentRequest scheduleData = new tblStudentRequest();
scheduleData.fkUserId = userId;
scheduleData.isDelete = false;
scheduleData.timeType = Convert.ToInt16(n.timeType);
scheduleData.dayType = Convert.ToInt16(n.dayType);
scheduleData.createdDate = DateTime.UtcNow;
scheduleData.lat = Convert.ToDouble(objReq.lat);
scheduleData.reschedleTimes = 0;
scheduleData.longi = Convert.ToDouble(objReq.longi);
if (String.IsNullOrEmpty(objReq.subjectId))
{
if (!String.IsNullOrEmpty(objReq.classId))
{
scheduleData.fkSubjectId = Convert.ToInt32(objReq.classId);
scheduleData.subjectType = 2;
}
else
{
scheduleData.fkSubjectId = Convert.ToInt32(objReq.courseId);
scheduleData.subjectType = 1;
}
}
else
{
scheduleData.fkSubjectId = Convert.ToInt32(objReq.subjectId);
scheduleData.subjectType = 3;
}
scheduleData.uniqueStudentRequestId = uniqueRequestId.ToString();
scheduleData.location = objReq.location;
switch (Convert.ToInt16(n.timeType))
{
case 1:
scheduleData.fromTime = "600";
scheduleData.toTime = "1200";
break;
case 2:
scheduleData.fromTime = "1200";
scheduleData.toTime = "1600";
break;
case 3:
scheduleData.fromTime = "1600";
scheduleData.toTime = "2200";
break;
default: break;
}
studentStudentList.Add(scheduleData);
}
db.tblStudentRequests.InsertAllOnSubmit(studentStudentList);
db.SubmitChanges();
// var userInfo = db.tblStudentRequests.Where(x => x.fkUserId == Convert.ToInt64(objReq.userId)).LastOrDefault();
tutorList = (from c in db.usp_P2GetTutorsList(Convert.ToInt32(objReq.userId),objReq.subjectId.ToString(), Convert.ToDecimal(objReq.lat), Convert.ToDecimal(objReq.longi), objReq.location, 0)
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();
searchResponse.tutorList = tutorList;
searchResponse.uniqueRequestId = uniqueRequestId.ToString();
return searchResponse;
}
}
catch (Exception e)
{
return searchResponse;
}
}
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;
}
}