internal TutorOccupiedCalendarModel GetTutorOccupiedCalendar(Entity objReq) { using (var db = new WizzDataContext()) { TutorOccupiedCalendarModel responseList = new TutorOccupiedCalendarModel(); List<DayTimeModel> tutorCalendarObj = new List<DayTimeModel>(); List<DayTimeModel> bookedTutorCalendarObj = new List<DayTimeModel>(); var tutorData = db.tblTutorSchedules.Where(x => x.fkUserId == Convert.ToInt64(objReq.userId)).ToList(); var sessionData = db.tblSessions.Where(x => x.tutorId == Convert.ToInt64(objReq.userId) && x.isDelete == false && x.isComplete == false && x.isCancelled == false).ToList(); foreach (var n in tutorData) { DayTimeModel dayOBj = new DayTimeModel(); DayTimeModel bookedDayOBj = new DayTimeModel(); dayOBj.dayType = Convert.ToString(n.dayType); dayOBj.fromTime = ReverseTimeConversionMethod(n.fromTime); dayOBj.toTime = ReverseTimeConversionMethod(n.toTime); tutorCalendarObj.Add(dayOBj); var bookedData = sessionData.Where(c => c.tutorId == n.fkUserId && Convert.ToInt32(c.fromTime) >= Convert.ToInt32(n.fromTime) && Convert.ToInt32(c.toTime) <= Convert.ToInt32(n.toTime) && c.isDelete == false).FirstOrDefault(); if (bookedData != null) { bookedDayOBj.dayType = Convert.ToString(bookedData.dayType); bookedDayOBj.fromTime = ReverseTimeConversionMethod(bookedData.fromTime); bookedDayOBj.toTime = ReverseTimeConversionMethod(bookedData.toTime); bookedTutorCalendarObj.Add(bookedDayOBj); } } responseList.TutorEmptySlot = tutorCalendarObj; responseList.TutorBookedSlot = bookedTutorCalendarObj; var isTutorAvail = db.tblTutorProfiles.FirstOrDefault(x => x.fkUserId == Convert.ToInt64(objReq.userId)).isAvailable; responseList.isAvailable = Convert.ToString(isTutorAvail); return responseList; } }
internal UserResponse GetUserRequest(RequestEntity objReq) { UserResponse objResponse = new UserResponse(); using (var db = new WizzDataContext()) { if (objReq.isTutor.ToLower() == "true") { } else { var tutorData = db.tblTutorSchedules.Where(x => x.fkUserId == Convert.ToInt64(objReq.userId)).ToList(); TutorScheduleModel objTutor = new TutorScheduleModel(); objTutor.userId = objReq.userId; DayTimeModel dtmObj = new DayTimeModel(); foreach (var n in tutorData) { dtmObj = new DayTimeModel(); dtmObj.dayType = Convert.ToString(n.dayType); dtmObj.fromTime = ReverseTimeConversionMethod(n.fromTime); dtmObj.toTime = ReverseTimeConversionMethod(n.toTime); objTutor.scheduleList.Add(dtmObj); } objResponse.tutorObj = objTutor; } return objResponse; //throw new NotImplementedException(); } }
internal StudentOccupiedCalendarModel GetStudentOccupiedCalendar(Entity objReq) { using (var db = new WizzDataContext()) { StudentOccupiedCalendarModel responseList = new StudentOccupiedCalendarModel(); List<DayTimeModel> bookedStudentCalendarObj = new List<DayTimeModel>(); var studentData = db.tblSessions.Where(x => x.studentId == Convert.ToInt64(objReq.userId) && x.isDelete == false && x.isComplete == false).ToList(); // var sessionData = db.tblSessions.Where(x => x.studentId == Convert.ToInt64(objReq.userId)).ToList(); foreach (var n in studentData) { if (n.isDelete == true) continue; DayTimeModel bookedDayOBj = new DayTimeModel(); bookedDayOBj.dayType = Convert.ToString(n.dayType); bookedDayOBj.fromTime = ReverseTimeConversionMethod(n.fromTime); bookedDayOBj.toTime = ReverseTimeConversionMethod(n.toTime); bookedStudentCalendarObj.Add(bookedDayOBj); } // responseList.StudentSlot = studentCalendarObj; // responseList.StudentBookedSlot = bookedStudentCalendarObj; //DayTimeModel tryObj = new DayTimeModel(); //tryObj.dayType = Convert.ToString(1); //tryObj.fromTime = Convert.ToString(28); //tryObj.toTime = Convert.ToString(34); //bookedStudentCalendarObj.Add(tryObj); //DayTimeModel tryObj2 = new DayTimeModel(); //tryObj2.dayType = Convert.ToString(4); //tryObj2.fromTime = Convert.ToString(20); //tryObj2.toTime = Convert.ToString(24); //bookedStudentCalendarObj.Add(tryObj); //bookedStudentCalendarObj.Add(tryObj2); // responseList.StudentSlot = studentCalendarObj; responseList.StudentBookedSlot = bookedStudentCalendarObj; return responseList; } }