public static void SendMessage(Message message) { using(var database = new SuperAtletenEntities()) { database.Messages.Add(message); database.SaveChanges(); } }
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 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 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 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 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 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 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 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(); } }