internal List<SessionResponseStudentModel> GetSessionsForStudent(RequestEntity objReq)
{
using (var db = new WizzDataContext())
{
List<SessionResponseStudentModel> tutorList = new List<SessionResponseStudentModel>();
int userId = Convert.ToInt32(objReq.userId);
tblInviteFriend friendsData = new tblInviteFriend();
friendsData = db.tblInviteFriends.Where(x => x.fkFriendId == userId).FirstOrDefault();
if (friendsData != null)
{
objReq.userId = Convert.ToString(friendsData.fkUserId);
}
var sessionList = db.usp_GetSessions(Convert.ToInt32(objReq.userId)).ToList();
foreach (var c in sessionList)
{
SessionResponseStudentModel model = new SessionResponseStudentModel();
model.homeWork = c.homeWork;
model.homeWorkDueDate = c.homeWorkDueDate;
model.latitude = Convert.ToString(c.lat);
model.location = c.location;
model.longitude = Convert.ToString(c.longi);
model.profilePic = c.profilePic;
model.sessionEndTime = c.toTime;
model.sessionStartTime = c.fromTime;
model.fromTime = ReverseTimeConversionMethod(c.fromTime);
model.toTime = ReverseTimeConversionMethod(c.toTime);
model.dayType = Convert.ToString(c.dayType);
model.subjectName = c.subjectName.ToString();
model.tutorId = c.tutorId.ToString();
model.tutorName = c.tutorName;
model.sessionId = c.sessionId.ToString();
model.uniqueRequestId = c.uniqueRequestId;
var friendData = db.usp_GetFriendsOfUser(c.sessionId.ToString()).ToList();
if (friendData.Count > 0)
{
foreach (var d in friendData)
{
FriendsListModel mod = new FriendsListModel();
if (d.fkFriendId == Convert.ToInt32(objReq.userId) || d.isDelete == true)
{
continue;
}
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
{
model.friendsList.Add(mod);
}
}
}
tutorList.Add(model);
}
return tutorList;
}
}
internal SessionResponseStudentModel GetSessionInfoForStudent(UniqueRequestModel objReq)
{
using (var db = new WizzDataContext())
{
SessionResponseStudentModel sessObj = new SessionResponseStudentModel();
List<SessionResponseStudentModel> tutorList = new List<SessionResponseStudentModel>();
int userId = Convert.ToInt32(objReq.userId);
tblInviteFriend friendsData = new tblInviteFriend();
friendsData = db.tblInviteFriends.Where(x => x.fkFriendId == userId).FirstOrDefault();
if (friendsData != null)
{
objReq.userId = Convert.ToString(friendsData.fkUserId);
}
var sessionList = db.usp_GetSessions(Convert.ToInt32(objReq.userId)).ToList();
foreach (var c in sessionList)
{
SessionResponseStudentModel model = new SessionResponseStudentModel();
if (db.tblInviteFriends.Any(x => x.fkUserId == Convert.ToInt32(objReq.userId) && x.isDelete == true))
continue;
model.homeWork = c.homeWork;
model.homeWorkDueDate = c.homeWorkDueDate;
model.latitude = Convert.ToString(c.lat);
model.location = c.location;
model.longitude = Convert.ToString(c.longi);
model.profilePic = c.profilePic;
//model.sessionEndTime = c.;
model.sessionStartTime = c.sessionStartTime;
model.fromTime = ReverseTimeConversionMethod(c.fromTime);
model.toTime = ReverseTimeConversionMethod(c.toTime);
model.dayType = Convert.ToString(c.dayType);
model.subjectName = c.subjectName.ToString();
model.tutorId = c.tutorId.ToString();
model.tutorName = c.tutorName;
model.sessionId = c.uniqueRequestId;
var friendData = db.usp_GetFriendsOfUser(c.uniqueRequestId).ToList();
foreach (var d in friendData)
{
FriendsListModel mod = new FriendsListModel();
if (d.fkFriendId == Convert.ToInt32(objReq.userId) || d.isDelete == false)
continue;
// pkId=Convert.ToString(d.fId),
mod.friendId = Convert.ToString(d.fkFriendId);
mod.friendName = d.frienName == "" ? d.userName : d.frienName;
mod.amount = "";
// friendphoneNumber = d.friendPhone == "" ? d.phoneNum : d.friendPhone,
mod.isConfirm = Convert.ToString(d.isConfirm);
mod.profilePic = string.IsNullOrWhiteSpace(d.profilePic) ? "" : d.profilePic.IndexOf("http") >= 0 ? d.profilePic : Constants.imagepath + d.profilePic;
model.friendsList.Add(mod);
}
//model.friendsList = (from d in db.usp_GetFriendsOfUser(c.uniqueRequestId)
// select new
// {
// }).ToList();
tutorList.Add(model);
}
sessObj = tutorList.Where(x => x.sessionId == objReq.uniqueRequestId).FirstOrDefault();
return sessObj;
}
}
internal int InviteFriends(InviteFriendsModel objReq)
{
try
{
var response = 0;
using (var db = new WizzDataContext())
{
List<tblInviteFriend> userList = new List<tblInviteFriend>();
tblInviteFriend myObj = new tblInviteFriend();
List<tblInviteFriend> friendList = new List<tblInviteFriend>();
friendList = db.tblInviteFriends.Where(x => x.uniqueRequestId == objReq.sessionId).ToList();
if (friendList.Count > 0)
{
db.tblInviteFriends.DeleteAllOnSubmit(friendList);
db.SubmitChanges();
}
myObj.fkUserId = Convert.ToInt32(objReq.userId);
myObj.isConfirm = true;
myObj.userName = "";
myObj.phoneNum = "";
myObj.isDelete = false;
myObj.uniqueRequestId = objReq.sessionId;
myObj.fkFriendId = Convert.ToInt32(objReq.userId);
userList.Add(myObj);
foreach (var i in objReq.Friends)
{
tblInviteFriend userObj = new tblInviteFriend();
var isExist = db.tblUsers.FirstOrDefault(e => e.phoneNum.Contains(i.phoneNumber));
if (isExist != null)
{
userObj.userName = "";
userObj.phoneNum = "";
userObj.uniqueRequestId = objReq.sessionId;
userObj.isConfirm = true;
userObj.fkUserId = Convert.ToInt32(objReq.userId);
userObj.fkFriendId = Convert.ToInt32(isExist.pkUserId);
userObj.createdDate = DateTime.UtcNow;
userObj.isDelete = false;
userObj.updatedDate = DateTime.UtcNow;
response = 1;
}
else
{
userObj.userName = i.userName;
userObj.phoneNum = i.phoneNumber;
userObj.uniqueRequestId = objReq.sessionId;
userObj.isConfirm = false;
userObj.fkUserId = Convert.ToInt32(objReq.userId);
userObj.fkFriendId = 0;
userObj.createdDate = DateTime.UtcNow;
userObj.isDelete = false;
userObj.updatedDate = DateTime.UtcNow;
response = 2;
}
userList.Add(userObj);
// db.tblInviteFriends.InsertOnSubmit(obj);
}
db.tblInviteFriends.InsertAllOnSubmit(userList);
db.SubmitChanges();
}
return response;
}
catch (Exception ex)
{
return -1;
}
}
