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