public static void AddUserLocationPurpose(User_Location_Purpose ulp) { using (FriendlyDBEntities context = new FriendlyDBEntities()) { context.User_Location_Purpose.Add(ulp); context.SaveChanges(); } }
public static void AddNewUser(User user) { using (FriendlyDBEntities context = new FriendlyDBEntities()) { context.Users.Add(user); context.SaveChanges(); } }
public static void UpdateUser(User u) { using (FriendlyDBEntities context = new FriendlyDBEntities()) { User updateUser = context.Users.SingleOrDefault(b => b.Username == u.Username); context.Entry(updateUser).CurrentValues.SetValues(u); context.SaveChanges(); } }
public static void SaveProfilePicture(string username, byte[] picture) { using (FriendlyDBEntities context = new FriendlyDBEntities()) { User user = context.Users.FirstOrDefault(u => u.Username == username); user.Picture = picture; context.SaveChanges(); } }
public static void DeleteUserLocationPurpose(User_Location_Purpose ulp) { using (FriendlyDBEntities context = new FriendlyDBEntities()) { context.User_Location_Purpose.Attach(ulp); context.User_Location_Purpose.Remove(ulp); context.SaveChanges(); } }
public static void AddMatch(User currentuser, string match) { using (FriendlyDBEntities context = new FriendlyDBEntities()) { Match m = new Match(); m.MatchUsername = match; m.User = context.Users.FirstOrDefault(u => u.Username == currentuser.Username); context.Match.Add(m); context.SaveChanges(); } }
public static void AddMessage(string sender, string receiver, string message) { using (FriendlyDBEntities context = new FriendlyDBEntities()) { Message m = new Message(); m.Sender = sender; m.Reciever = receiver; m.Content = message; context.Messages.Add(m); context.SaveChanges(); } }