internal tblUser LoadUser(int userId)
{
try
{
using (var conn = new BetweenUsEntities())
{
return(conn.tblUsers.FirstOrDefault(x => x.UserID == userId));
}
}
catch (Exception)
{
return(null);
}
}
public bool IsUniqueUsername(string username)
{
try
{
using (var conn = new BetweenUsEntities())
{
return(!conn.tblUsers.Any(x => x.Username == username));
}
}
catch (Exception)
{
return(false);
}
}
internal bool TryAddNewUser(tblUser user)
{
try
{
using (var conn = new BetweenUsEntities())
{
conn.tblUsers.Add(user);
conn.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
internal List <tblPost> LoadPosts()
{
try
{
using (var conn = new BetweenUsEntities())
{
if (conn.tblPosts.Any())
{
return(conn.tblPosts.Include(x => x.tblUser).ToList());
}
return(new List <tblPost>());
}
}
catch (Exception)
{
return(new List <tblPost>());
}
}
internal int GetUserDataId(string userName)
{
try
{
using (var conn = new BetweenUsEntities())
{
var user = conn.tblUsers.FirstOrDefault(x => x.Username == userName);
if (user != null)
{
return(user.UserID);
}
return(0);
}
}
catch (Exception)
{
return(0);
}
}
internal bool AddNewFriend(int user1id, int user2id)
{
try
{
using (var conn = new BetweenUsEntities())
{
conn.tblFriends.Add(new tblFriend()
{
UserID = user1id, UserID2 = user2id
});
conn.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
internal List <tblFriendRequest> LoadUserRequests(int userId)
{
try
{
using (var conn = new BetweenUsEntities())
{
if (conn.tblFriendRequests.Any())
{
return(conn.tblFriendRequests
.Where(x => x.tblUser1.UserID == userId ||
x.tblUser.UserID == userId).ToList());
}
return(new List <tblFriendRequest>());
}
}
catch (Exception)
{
return(new List <tblFriendRequest>());
}
}
internal List <tblUser> LoadUsers(int userId)
{
try
{
using (var conn = new BetweenUsEntities())
{
if (conn.tblUsers.Any())
{
return(conn.tblUsers
.Where(x => x.UserID != userId)
.ToList());
}
return(new List <tblUser>());
}
}
catch (Exception)
{
return(new List <tblUser>());
}
}
internal bool IsCorrectUser(string userName, string password)
{
try
{
using (var conn = new BetweenUsEntities())
{
var user = conn.tblUsers.FirstOrDefault(x => x.Username == userName);
if (user != null)
{
var passwordFromDb = conn.tblUsers.First(x => x.Username == userName).Password;
return(SecurePasswordHasher.Verify(password, passwordFromDb));
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
internal List <tblFriendRequest> LoadRequestsForUser(int userId)
{
try
{
using (var conn = new BetweenUsEntities())
{
if (conn.tblFriendRequests.Any())
{
return(conn.tblFriendRequests
.Include(y => y.tblUser)
.Where(x => x.UserID2 == userId)
.ToList());
}
return(new List <tblFriendRequest>());
}
}
catch (Exception)
{
return(new List <tblFriendRequest>());
}
}
internal bool RemoveFriendRequest(int friendRequestID)
{
try
{
using (var conn = new BetweenUsEntities())
{
var requestToRemove = conn.tblFriendRequests
.FirstOrDefault(x => x.FriendRequestID == friendRequestID);
if (requestToRemove != null)
{
conn.tblFriendRequests.Remove(requestToRemove);
conn.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
