public static void Update(User newUser)
{
try
{
using (var db = new MyDbContext())
{
User dbUser = db.User.Single(i => i.Id == newUser.Id);
dbUser.Area = newUser.Area;
dbUser.BirthDate = newUser.BirthDate;
dbUser.FirstName = newUser.FirstName;
dbUser.Gender = newUser.Gender;
dbUser.LastName = newUser.LastName;
dbUser.PhoneNumber = newUser.PhoneNumber;
dbUser.State = newUser.State;
dbUser.StreetAddress = newUser.StreetAddress;
dbUser.Password = newUser.Password;
db.SaveChanges();
}
}
catch (Exception e)
{
throw new DomainException("Could not update user", e);
}
}
public static Sport GetOrCreate(string name)
{
try
{
validateName(name);
Sport sport;
using (var db = new MyDbContext())
{
sport = db.Sport.Where(p => p.Name == name).FirstOrDefault();
if (sport == null)
{
sport = new Sport();
sport.Name = name;
db.Sport.Add(sport);
db.SaveChanges();
}
return sport;
}
}
catch (Exception e)
{
throw new DomainException("Could not find or create sport", e);
}
}
public static List<Sport> GetAll()
{
try
{
using (var db = new MyDbContext())
{
return (from s in db.Sport select s).ToList();
}
}
catch (Exception e)
{
throw new DomainException("Could not get all sports", e);
}
}
public static List<Location> getAll()
{
try
{
using (var db = new MyDbContext())
{
return db.Location.ToList();
}
}
catch (Exception e)
{
throw new DomainException("Could not get all locations", e);
}
}
public static void Add(JoinedUser joinedUser)
{
try
{
using (var db = new MyDbContext())
{
db.JoinedUser.Add(joinedUser);
db.SaveChanges();
}
}
catch (Exception e)
{
throw new DomainException("Could not add joined user", e);
}
}
public static void Register(User user)
{
try
{
using (var db = new MyDbContext())
{
db.User.Add(user);
db.SaveChanges();
}
}
catch (Exception e)
{
throw new DomainException("Could not create user", e);
}
}
public static void Create(Suggestion suggestion)
{
try
{
using (var db = new MyDbContext())
{
db.JoinedUser.Add(suggestion.JoinedUsers[0]);
db.Suggestion.Add(suggestion);
db.SaveChanges();
}
}
catch (Exception e)
{
throw new DomainException("Could not create suggestion", e);
}
}
public static List<JoinedUser> Get(int suggestionId)
{
if (suggestionId < 0)
throw new DomainException("Invalid suggestion id");
try
{
using (var db = new MyDbContext())
{
return (from j in db.JoinedUser.Include("User") where j.SuggestionId == suggestionId select j).ToList();
}
}
catch (Exception e)
{
throw new DomainException("Could not get joined users for suggestion", e);
}
}
public static User Get(int userId)
{
try
{
if (userId < 0)
throw new DomainException("Invalid user id");
using (var db = new MyDbContext())
{
return db.User.Find(userId);
}
}
catch (Exception e)
{
throw new DomainException("Could not fetch user", e);
}
}
public static List<Suggestion> GetAll()
{
try
{
using (var db = new MyDbContext())
{
return (from s in db.Suggestion
.Include("Sport")
.Include("JoinedUsers")
.Include("Creator")
.Include("Location")
where s.IsClosed == false
select s).ToList();
}
}
catch (Exception e)
{
throw new DomainException("Could not get all suggestions", e);
}
}
public static User Get(string userEmail)
{
try
{
if (userEmail == null || userEmail.Equals(""))
throw new DomainException("Invalid email address");
var user = new User();
using (var db = new MyDbContext())
{
var dbUser = db.User.Where(u => u.Email == userEmail).First();
user = (User)dbUser;
}
return user;
}
catch (Exception e)
{
throw new DomainException("Could not fetch user", e);
}
}
public static List<Suggestion> GetByCreator(int creatorId)
{
try
{
validateId(creatorId);
using (var db = new MyDbContext())
{
return (from s in db.Suggestion
.Include("Sport")
.Include("JoinedUsers")
.Include("Creator")
.Include("Location")
where s.CreatorId == creatorId
select s).ToList();
}
}
catch (Exception e)
{
throw new DomainException("Could not get suggestions by creator", e);
}
}
public static Suggestion Get(int id)
{
try
{
validateId(id);
using (var db = new MyDbContext())
{
return (from s in db.Suggestion
.Include("Sport")
.Include("JoinedUsers")
.Include("Creator")
.Include("Location")
where s.Id == id
select s).First();
}
}
catch (Exception e)
{
throw new DomainException("Could not fetch suggestion", e);
}
}
public static List<Suggestion> GetByJoinedUser(int userId)
{
try
{
validateId(userId);
using (var db = new MyDbContext())
{
var query = from s in db.Suggestion
from ju in db.JoinedUser
where ju.UserId == userId
&& s.Id == ju.SuggestionId
select new
{
s,
sport = s.Sport,
ju = s.JoinedUsers
};
var suggestions = query.AsEnumerable().Select(m => m.s);
return suggestions.ToList();
}
}
catch (Exception e)
{
throw new DomainException("Could not get suggestions by joined user", e);
}
}
public static void Update(Suggestion updatedSuggestion)
{
try
{
using (var db = new MyDbContext())
{
var suggestion = db.Suggestion.Single((i => i.Id == updatedSuggestion.Id));
updatedSuggestion.CreatorId = suggestion.CreatorId;
db.Entry(suggestion).CurrentValues.SetValues(updatedSuggestion);
db.SaveChanges();
}
}
catch (Exception e)
{
throw new DomainException("Could not update suggestion", e);
}
}