public User getUserByLogin(string usrLogin)
{
using (var ctx = new ABStoreContext())
{
return(ctx.Users.Include(x => x.UserLibrary).First(x => x.Login == usrLogin));
}
}
public List <LibraryItem> getUserLibrary(string usrLogin)
{
using (var ctx = new ABStoreContext())
{
return(ctx.Users.First(x => x.Login == usrLogin).UserLibrary);
}
}
public List <Game> getAllGames()
{
using (var ctx = new ABStoreContext())
{
return(ctx.Games.ToList());
}
}
public User getUsrDetails(int usrId)
{
using (var ctx = new ABStoreContext())
{
return(ctx.Users.Include(x => x.UserLibrary).First(x => x.Id == usrId));
}
}
//#region IUserRepo Members
public List <User> getAllUsers()
{
using (var ctx = new ABStoreContext())
{
return(ctx.Users.Include(x => x.UserLibrary).ToList());
}
}
public Game FindById(int gameId)
{
using (var ctx = new ABStoreContext())
{
return(ctx.Games.First(x => x.Id == gameId));
}
}
public Game FindByFullName(string fullName)
{
using (var ctx = new ABStoreContext())
{
return(ctx.Games.First(x => x.Name == fullName));
}
}
public void DeleteGame(Game game)
{
using (var ctx = new ABStoreContext())
{
ctx.Games.Remove(game);
ctx.SaveChanges();
}
}
public void CreateGame(Game game)
{
using (var ctx = new ABStoreContext())
{
ctx.Games.Add(game);
ctx.SaveChanges();
}
}
public void RegisterUser(User user)
{
using (var ctx = new ABStoreContext())
{
ctx.Users.Add(user);
ctx.Entry(user).State = EntityState.Added;
ctx.SaveChanges();
}
}
public void UpdateGame(Game game)
{
using (var ctx = new ABStoreContext())
{
ctx.Games.Attach(game);
ctx.Entry(game).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public void DeleteUser(int userId)
{
using (var ctx = new ABStoreContext())
{
User usr = ctx.Users.Include(x => x.UserLibrary).First(x => x.Id == userId);
ctx.Users.Remove(usr);
ctx.SaveChanges();
}
}
public void UpdateUser(User user)
{
using (var ctx = new ABStoreContext())
{
ctx.Users.Attach(user);
ctx.Entry(user).State = EntityState.Modified;
foreach (var libItem in user.UserLibrary)
{
if (libItem.Id == 0)
{
ctx.Entry(libItem).State = EntityState.Added;
}
}
ctx.SaveChanges();
}
}
