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