public static User GetUser(string username)
{
using (FriendlyDBEntities context = new FriendlyDBEntities())
{
return(context.Users.FirstOrDefault(user => user.Username.Equals(username, StringComparison.Ordinal)));
}
}
public static List <FieldOfProfession> GetFieldOfProfessions()
{
using (FriendlyDBEntities context = new FriendlyDBEntities())
{
List <FieldOfProfession> industries = context.FieldOfProfessions.ToList();
return(industries);
}
}
public static List <Message> GetAllMessages(string sender, string reciever)
{
using (FriendlyDBEntities context = new FriendlyDBEntities())
{
List <Message> messages = context.Messages.Where(s => s.Sender == sender || s.Sender == reciever).Where(r => r.Reciever == reciever || r.Reciever == sender).ToList();
return(messages);
}
}
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 List <Location> GetLocations()
{
using (FriendlyDBEntities context = new FriendlyDBEntities())
{
List <Location> locations = context.Locations.ToList();
return(locations);
}
}
public static List <Match> GetMatches(User currentuser)
{
using (FriendlyDBEntities context = new FriendlyDBEntities())
{
List <Match> matches = context.Match.Where(m => m.Username == currentuser.Username).ToList();
return(matches);
}
}
public static List <Purpose> GetPurposes()
{
using (FriendlyDBEntities context = new FriendlyDBEntities())
{
List <Purpose> purposes = context.Purposes.ToList();
return(purposes);
}
}
public static List <User_Location_Purpose> GetUserOwnLocations(string username)
{
using (FriendlyDBEntities context = new FriendlyDBEntities())
{
List <User_Location_Purpose> locations = context.User_Location_Purpose.Where(l => l.Username == username).ToList();
return(locations);
}
}
public static List <User_Location_Purpose> GetUsersByCity(string city, User currentuser)
{
using (FriendlyDBEntities context = new FriendlyDBEntities())
{
List <User_Location_Purpose> cities = context.User_Location_Purpose.Where(l => l.City == city).Where(l => l.Username != currentuser.Username).ToList();
return(cities);
}
}
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();
}
}
public static int GetAge(string username)
{
using (FriendlyDBEntities context = new FriendlyDBEntities())
{
int age = 0;
DateTime dateOfBirth = Convert.ToDateTime(context.Users.Where(u => u.Username == username).Select(u => u.Birthdate).FirstOrDefault());
age = DateTime.Now.Year - dateOfBirth.Year;
if (DateTime.Now.DayOfYear < dateOfBirth.DayOfYear)
{
age = age - 1;
}
return(age);
}
}
public static User CheckUsernameAndPassword(string username, string password)
{
using (FriendlyDBEntities context = new FriendlyDBEntities())
{
bool userExists = context.Users.Any(user => user.Username.Equals(username, StringComparison.Ordinal));
if (!userExists)
{
throw new InvalidUserOrPasswordException("Couldn't find user with username: "******"The entered password doesn't match username: " + username);
}
}