public IEnumerable <Friend> GetFriends(int userId) { using (var context = new UberFamilyContext()) { return(context.Friend.Where(x => x.FirstFriend == userId || x.SecondFriend == userId).ToList()); } }
public User GetUserById(int userId) { using (var context = new UberFamilyContext()) { return(context.User.FirstOrDefault(x => x.Id == userId)); } }
public IEnumerable <ChatMessage> GetMessages(int requestId) { using (var context = new UberFamilyContext()) { return(context.ChatMessage.Where(x => x.RequestId == requestId).ToList()); } }
public IEnumerable <Request> GetRequests() { using (var context = new UberFamilyContext()) { return(context.Request.ToList()); } }
public Request GetRequestById(int requestId) { using (var context = new UberFamilyContext()) { return(context.Request.FirstOrDefault(x => x.Id == requestId)); } }
public Friend GetFriendById(int friendshipId) { using (var context = new UberFamilyContext()) { return(context.Friend.FirstOrDefault(x => x.Id == friendshipId)); } }
public IEnumerable <User> GetUsers() { using (var context = new UberFamilyContext()) { return(context.User.ToList()); } }
public IEnumerable <User> GetApprovedFriends(bool approved, int userId) { using (var context = new UberFamilyContext()) { var user = context.User.FirstOrDefault(x => x.Id == userId); var friendList = _friendService.GetFriends(userId); if (approved) { friendList = _friendService.GetFriends(userId).Where(x => x.Approved == 1).ToList(); } var userList = new List <User>(); foreach (var item in friendList) { if (item.FirstFriend != userId && userList.FirstOrDefault(x => x.Id == item.FirstFriend) == null) { userList.Add(context.User.First(x => x.Id == item.FirstFriend)); } if (item.SecondFriend != userId && userList.FirstOrDefault(x => x.Id == item.SecondFriend) == null) { userList.Add(context.User.First(x => x.Id == item.SecondFriend)); } } return(userList.Select(x => new User { Id = x.Id, Username = x.Username, Port = x.Port, IpAddress = x.IpAddress }).ToList()); } }
public User GetUser(string username, string password) { using (var context = new UberFamilyContext()) { return(context.User.FirstOrDefault(x => x.Username == username && x.Password == password)); } }
public IEnumerable <Request> GetOpenRequests() { using (var context = new UberFamilyContext()) { return(context.Request.Where(x => x.Open == 1).ToList()); } }
public async void DeleteRequest(int requestId) { using (var context = new UberFamilyContext()) { context.Request.Remove(context.Request.FirstOrDefault(x => x.Id == requestId)); await context.SaveChangesAsync(); } }
public async void DeleteUser(int userId) { using (var context = new UberFamilyContext()) { context.User.Remove(context.User.FirstOrDefault(x => x.Id == userId)); await context.SaveChangesAsync(); } }
public async void AddUser(User user) { using (var context = new UberFamilyContext()) { context.User.Add(user); await context.SaveChangesAsync(); } }
public async void AddMessage(ChatMessage message) { using (var context = new UberFamilyContext()) { context.ChatMessage.Add(message); await context.SaveChangesAsync(); } }
public async void RemoveFriend(int friendId) { using (var context = new UberFamilyContext()) { context.Friend.Remove(context.Friend.FirstOrDefault(x => x.Id == friendId)); await context.SaveChangesAsync(); } }
public Friend AddFriend(Friend friend) { using (var context = new UberFamilyContext()) { var friendItem = context.Friend.Add(friend); context.SaveChanges(); return(friendItem.Entity); } }
public async void UpdateFriend(Friend friend) { using (var context = new UberFamilyContext()) { var friendItem = context.Friend.FirstOrDefault(x => x.Id == friend.Id); friendItem.FirstFriend = friend.FirstFriend; friendItem.SecondFriend = friend.SecondFriend; await context.SaveChangesAsync(); } }
public Request CreateRequest(Request request) { using (var context = new UberFamilyContext()) { var requestObj = context.Request.Add(request); context.SaveChanges(); return(requestObj.Entity); } }
public async void UpdateRequest(Request request) { using (var context = new UberFamilyContext()) { var requestItem = context.Request.FirstOrDefault(x => x.Id == request.Id); requestItem.Open = request.Open; requestItem.Requester = request.Requester; requestItem.Adress = request.Adress; requestItem.Driver = request.Driver; await context.SaveChangesAsync(); } }
public void UpdateConnectivity(string ipAdress, string port, int userId) { using (var context = new UberFamilyContext()) { var userDb = context.User.FirstOrDefault(x => x.Id == userId); if (userDb != null) { userDb.Port = port; userDb.IpAddress = ipAdress; context.SaveChanges(); } } }
public void UpdateUser(User user) { using (var context = new UberFamilyContext()) { var userDb = context.User.FirstOrDefault(x => x.Id == user.Id); if (userDb != null) { userDb.IsDriver = user.IsDriver; userDb.Password = user.Password; userDb.Fullname = user.Fullname; context.SaveChanges(); } } }