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();
}
}
}
