internal List<SessionResponseTutorModel> GetSessionsForTutor(RequestEntity objReq) { using (var db = new WizzDataContext()) { List<SessionResponseTutorModel> studentList = new List<SessionResponseTutorModel>(); var ListData = db.usp_GetSessionsForTutor(Convert.ToInt32(objReq.userId)).ToList(); Int32 tutorId = Convert.ToInt32(objReq.userId); foreach (var c in ListData) { SessionResponseTutorModel obj = new SessionResponseTutorModel(); obj.homeWork = c.homeWork; obj.homeWorkDueDate = c.homeWorkDueDate; obj.latitude = Convert.ToString(c.lat); obj.location = c.location; obj.longitude = Convert.ToString(c.longi); obj.profilePic = c.profilePic; obj.sessionEndTime = c.toTime; obj.sessionStartTime = c.fromTime; obj.fromTime = ReverseTimeConversionMethod(c.fromTime); obj.toTime = ReverseTimeConversionMethod(c.toTime); obj.dayType = Convert.ToString(c.dayType); obj.subjectName = c.subjectName.ToString(); obj.studentId = c.studentId.ToString(); obj.studentName = c.studentName; obj.uniqueRequestId = c.uniqueRequestId; obj.sessionId = c.sessionId.ToString(); //var frien // obj.friendsList = (from d in db.usp_GetFriendsOfUser(c.uniqueRequestId) // select new FriendsListModel // { // friendId = Convert.ToString(d.fkFriendId), // friendName = d.frienName == "" ? d.userName : d.frienName, // amount = "", // isConfirm = Convert.ToString(d.isConfirm), // profilePic = string.IsNullOrWhiteSpace(d.profilePic) ? "" : d.profilePic.IndexOf("http") >= 0 ? d.profilePic : Constants.imagepath + d.profilePic // }).ToList(); var friendData = db.usp_GetFriendsOfUser(c.sessionId.ToString()).ToList(); foreach (var d in friendData) { if (d.fkFriendId == Convert.ToInt32(objReq.userId) || d.isDelete == true) { continue; } FriendsListModel mod = new FriendsListModel(); mod.friendId = Convert.ToString(d.fkFriendId); mod.friendName = d.frienName == "" ? d.userName : d.frienName; mod.amount = ""; mod.isConfirm = Convert.ToString(d.isConfirm); mod.profilePic = string.IsNullOrWhiteSpace(d.profilePic) ? "" : d.profilePic.IndexOf("http") >= 0 ? d.profilePic : Constants.imagepath + d.profilePic; if (mod.friendId == null) { } else { obj.friendsList.Add(mod); } } obj.sessionCost = CalculateSessionCost(fromTime: obj.fromTime, friendsCount: obj.friendsList.Count, db: db, toTime: obj.toTime, tutorId: tutorId); studentList.Add(obj); } return studentList; } }