public static User CheckIfUsernameExists(string username)
{
using (var database = new SuperAtletenEntities())
{
return database.Users.Where(b => b.Username == username).FirstOrDefault();
}
}
public static string GetUserRole(string username)
{
using (var database = new SuperAtletenEntities())
{
return database.Users.Where(b => b.Username == username).FirstOrDefault().Role;
}
}
public static User CheckIfEmailExists(string email)
{
using (var database = new SuperAtletenEntities())
{
return database.Users.Where(b => b.Email == email).FirstOrDefault();
}
}
public static List<Message> GetUnreadMessages(int currentUserID)
{
using (var database = new SuperAtletenEntities())
{
var list = database.Messages.Where(b => b.ReciverID == currentUserID & b.Status==null).OrderByDescending(x => x.Date).ToList();
return list;
}
}
public static void SendMessage(Message message)
{
using(var database = new SuperAtletenEntities())
{
database.Messages.Add(message);
database.SaveChanges();
}
}
public static List<ExerciseCategory> getStrengthCategories()
{
using (var database = new SuperAtletenEntities())
{
var Categories = database.ExerciseCategories.ToList();
return Categories;
}
}
public static List<StrengthE> getStrengthExerciseList()
{
using (var database = new SuperAtletenEntities())
{
var Exercises = database.StrengthEs.ToList();
return Exercises;
}
}
public static List<User> getAllUsers()
{
using (var database = new SuperAtletenEntities())
{
var users = database.Users.OrderBy(b=>b.Username).ToList();
return users;
}
}
public static void changeProfilePic(int userid, string imageName)
{
using (var database = new SuperAtletenEntities())
{
var user = database.Users.Where(b => b.Id == userid).FirstOrDefault();
user.Image = imageName;
database.SaveChanges();
}
}
public static void deleteMessage(int messageID)
{
using (var database = new SuperAtletenEntities())
{
var messageToRemove = database.Messages.FirstOrDefault(b => b.MessageID == messageID);
database.Messages.Remove(messageToRemove);
database.SaveChanges();
}
}
public static List<User> getSpecificUsers(string searchString)
{
using (var database = new SuperAtletenEntities())
{
var query = from user in database.Users where user.Username.StartsWith(searchString) select user;
var users = query.OrderBy(b=>b.Username).ToList();
return users;
}
}
public static string CheckIfFriends(int currentUserId, int FriendId)
{
using (var database = new SuperAtletenEntities())
{
var friends = database.Friends.FirstOrDefault(x => x.Friend1 == currentUserId & x.Friend2 == FriendId || x.Friend2 == currentUserId & x.Friend1 == FriendId);
if (friends == null) return "notfriends";
else return "friends";
}
}
public static void MarkTheMessageRead(int messageID)
{
using (var database = new SuperAtletenEntities())
{
var messageToUpdate = database.Messages.FirstOrDefault(b => b.MessageID == messageID);
messageToUpdate.Status=true;
database.SaveChanges();
}
}
public static string CheckIfFriendsRequest(int currentUserId, int FriendId)
{
using (var database = new SuperAtletenEntities())
{
var friendRequestToYou = database.Friend_Request.FirstOrDefault(x => x.ReciverID == currentUserId & x.SenderID == FriendId);
if (friendRequestToYou != null) return "friendrequest";
var friendRequestFromYou = database.Friend_Request.FirstOrDefault(x=> x.SenderID == currentUserId & x.ReciverID == FriendId);
if (friendRequestFromYou != null) return "myfriendrequest";
else return null;
}
}
public static void RegisterUser(User user)
{
using (var database = new SuperAtletenEntities())
{
database.Users.Create();
user.Role = "U";
user.Image = "empty.png";
user.About = "Ej fyllt i ännu";
database.Users.Add(user);
database.SaveChanges();
}
}
public static List<Trainingsession> getTrainingSessions(int userID)
{
using (var database = new SuperAtletenEntities())
{
var trainingsession = from trainingSession in database.Trainingsessions
join haveDone in database.HaveDone_trainingsession
on trainingSession.trainingSessionID equals haveDone.TrainingSessionID
where haveDone.UserID == userID
select trainingSession;
return trainingsession.OrderByDescending(b=>b.Date).ToList();
}
}
public static User isValidUserLogin(string email, string password)
{
var crypto = new SimpleCrypto.PBKDF2();
using (var database = new SuperAtletenEntities())
{
var user = database.Users.Where(b => b.Email == email).FirstOrDefault();
if (user != null)
{
if (user.Password == crypto.Compute(password, user.PasswordSalt))
{
return user;
}
}
}
return null;
}
public static void AddFriend(int currentUserId, int friendId)
{
var user = currentUserId;
var friend = friendId;
using (var database = new SuperAtletenEntities())
{
var newFriend = new Friend
{
Friend1 = user,
Friend2 = friend,
};
database.Friends.Add(newFriend);
database.SaveChanges();
}
}
public static void AddFriendRequest(int currentUserId, int friendId)
{
var user = currentUserId;
var friend = friendId;
using (var database = new SuperAtletenEntities())
{
var newFriendRequest = new Friend_Request
{
SenderID = user,
ReciverID = friend,
Status = null
};
database.Friend_Request.Add(newFriendRequest);
database.SaveChanges();
}
}
public static void addWorkoutExercises(int workoutID,List<TrainingIncludes_StrengthExercise> listOfExercises)
{
using(var database = new SuperAtletenEntities())
{
foreach(var exercise in listOfExercises)
{
var ex = database.TrainingIncludes_StrengthExercise.Create();
ex.TrainingSessionID = workoutID;
ex.Repetitions = exercise.Repetitions;
ex.Weight = exercise.Weight; ;
ex.StrengthExerciseID = exercise.StrengthExerciseID;
ex.BodyWeight = exercise.BodyWeight;
database.TrainingIncludes_StrengthExercise.Add(ex);
}
database.SaveChanges();
}
}
public static bool changePassword(int userid,string Newpassword,string passwordSalt,string Oldpassword)
{
using (var database = new SuperAtletenEntities())
{
var user = database.Users.Where(b => b.Id == userid).FirstOrDefault();
if (user != null)
{
var crypto = new SimpleCrypto.PBKDF2();
if(user.Password == crypto.Compute(Oldpassword, user.PasswordSalt))
{
user.Password = Newpassword;
user.PasswordSalt = passwordSalt;
database.SaveChanges();
return true;
}
}
}
return false;
}
public static int addWorkout(Trainingsession workout, int currentUserId)
{
using (var database = new SuperAtletenEntities())
{
database.Trainingsessions.Create();
database.Trainingsessions.Add(workout);
database.SaveChanges();
database.Entry(workout).GetDatabaseValues();
int traingsID = workout.trainingSessionID;
var HaveDone = database.HaveDone_trainingsession.Create();
HaveDone.UserID = currentUserId;
HaveDone.TrainingSessionID = traingsID;
HaveDone.Date = DateTime.Now;
database.HaveDone_trainingsession.Add(HaveDone);
database.SaveChanges();
return traingsID;
}
}
public static List<User> GetFriendsList(int userId)
{
using (var database = new SuperAtletenEntities())
{
var friendsList1 = from friends in database.Friends
join users in database.Users
on friends.Friend1 equals users.Id
where (friends.Friend1 != userId) & (friends.Friend2 == userId)
select users;
var friendsList = friendsList1.ToList();
var friendsList2 = from friends in database.Friends
join users in database.Users
on friends.Friend2 equals users.Id
where (friends.Friend1 == userId) & (friends.Friend2!=userId)
select users;
var friendsListPart2 = friendsList2.ToList();
friendsList.AddRange(friendsListPart2);
return friendsList;
}
}
public static void RemoveFriendRequest(int currentUserId, int friendId)
{
using (var database = new SuperAtletenEntities())
{
var friendRequest = database.Friend_Request
.FirstOrDefault(x => x.ReciverID == currentUserId && x.SenderID == friendId);
if (friendRequest == null) friendRequest = database.Friend_Request
.FirstOrDefault(x => x.ReciverID == friendId && x.SenderID == currentUserId);
database.Friend_Request.Remove(friendRequest);
database.SaveChanges();
}
}
public static void RemoveFriend(int currentUserId, int friendId)
{
using (var database = new SuperAtletenEntities())
{
var friend = database.Friends.FirstOrDefault(x => x.Friend1 == currentUserId && x.Friend2 == friendId
|| x.Friend2 == currentUserId && x.Friend1 == friendId);
database.Friends.Remove(friend);
database.SaveChanges();
}
}
public static List<User> getFriendsRequestsFromYou(int currentUserId)
{
using (var database = new SuperAtletenEntities())
{
var listOfYourFriendRequests = (from users in database.Users
join friendrequest in database.Friend_Request
on users.Id equals friendrequest.ReciverID
where friendrequest.SenderID == currentUserId
select users).ToList();
return listOfYourFriendRequests;
}
}
public static int SumOfFriendsRequestToYou(int currentUserid)
{
using (var database = new SuperAtletenEntities())
{
var countFriendsRequest = database.Friend_Request.Where(x => x.ReciverID == currentUserid).Count();
return countFriendsRequest;
}
}
