public List <Platform> GetPlatforms()
{
using (var db = new Gam3Sp0tContext())
{
return(db.Platforms.ToList());
}
}
public List <Game> GetGames()
{
using (var db = new Gam3Sp0tContext())
{
return(db.Games.ToList());
}
}
public List <Developer> GetDevelopers()
{
using (var db = new Gam3Sp0tContext())
{
return(db.Developers.ToList());
}
}
public List <User> RetrieveAll()
{
using (var db = new Gam3Sp0tContext())
{
return(db.Users.ToList());
}
}
public User Login(string username, string password)
{
using (var db = new Gam3Sp0tContext())
{
SelectedUser = db.Users.Where(u => u.Username == username).FirstOrDefault();
if (SelectedUser is not null)
{
if (SelectedUser.Password == password)
{
//sets logged in
LoggedIn = SelectedUser;
return(LoggedIn);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
}
public void DeletePlatform()
{
using (var db = new Gam3Sp0tContext())
{
var selectedPlat = db.Platforms.Where(p => p.PlatformId == SelectedPlat.PlatformId);
db.Platforms.RemoveRange(selectedPlat);
db.SaveChanges();
}
}
public void DeleteDeveloper()
{
using (var db = new Gam3Sp0tContext())
{
var selectedDeveloper = db.Developers.Where(d => d.DeveloperId == SelectedDev.DeveloperId);
db.Developers.RemoveRange(selectedDeveloper);
db.SaveChanges();
}
}
//DELETE
public void DeleteGame()
{
using (var db = new Gam3Sp0tContext())
{
var deleteGame = db.Games.Find(SelectedGame.GameId);
db.Games.RemoveRange(deleteGame);
db.SaveChanges();
}
}
public void CreatePlatform(string platform, string brand)
{
using (var db = new Gam3Sp0tContext())
{
Platform plat = new Platform {
PlatformName = platform, Brand = brand
};
db.Platforms.Add(plat);
db.SaveChanges();
}
}
//CREATE
public void CreateDeveloper(string companyName)
{
using (var db = new Gam3Sp0tContext())
{
Developer dev = new Developer {
CompanyName = companyName
};
db.Developers.Add(dev);
db.SaveChanges();
}
}
public void WhenANewCustomerIsAdded_TheNumberOfCustemersIncreasesBy1()
{
using (var db = new Gam3Sp0tContext())
{
var numberOfUsersBefore = db.Users.Count();
_operations.CreateUser("FRY", "Phillip", "Fry", "testPass", false);
var numberOfUsersAfter = db.Users.Count();
Assert.AreEqual(numberOfUsersBefore + 1, numberOfUsersAfter);
}
}
public void WhenACustomersDetailsAreChanged_TheDatabaseIsUpdated()
{
using (var db = new Gam3Sp0tContext())
{
_operations.CreateUser("FRY", "Phillip", "Fry", "testPass", false);
_operations.Update("FRY", "Bender", "Fry");
var updatedCustomer = db.Users.Where(u => u.Username == "Fry").FirstOrDefault();
Assert.AreEqual("Bender", updatedCustomer.FirstName);
}
}
//UPDATE
public void UpdateGame(string title, DateTime release)
{
using (var db = new Gam3Sp0tContext())
{
var customer = db.Games.Where(g => g.GameTitle == SelectedGame.GameTitle).FirstOrDefault();
customer.GameTitle = title;
customer.ReleaseDate = release;
db.SaveChanges();
}
gameFill.Clear();
BindGames();
}
public void Update(string userName, string firstName, string lastName)
{
using (var db = new Gam3Sp0tContext())
{
SelectedUser = db.Users.Where(u => u.Username == userName).FirstOrDefault();
SelectedUser.Username = userName;
SelectedUser.FirstName = firstName;
SelectedUser.LastName = lastName;
// write changes to database
db.SaveChanges();
}
}
public void CreateReview(int gameID, int userID, string title, string content, int rating)
{
Review newRev = new Review {
GameId = gameID, UserId = userID, Title = title, Content = content, Rating = rating
};
using (var db = new Gam3Sp0tContext())
{
db.Reviews.Add(newRev);
db.SaveChanges();
}
}
public void CreateUser(string username, string firstName, string lastName, string password, bool isAdmin)
{
var newUser = new User()
{
Username = username, FirstName = firstName, LastName = lastName, Password = password, IsAdmin = isAdmin
};
using (var db = new Gam3Sp0tContext())
{
db.Users.Add(newUser);
db.SaveChanges();
}
}
public void TearDown()
{
using (var db = new Gam3Sp0tContext())
{
var selectedUser =
from c in db.Users
where c.Username == "FRY"
select c;
db.Users.RemoveRange(selectedUser);
db.SaveChanges();
}
}
//READ
public void BindGames()
{
using (var db = new Gam3Sp0tContext())
{
// FILL GAME SELECTION WITH INFORMATION OF GAMES IN THE DATABASE
var query1 =
from g in db.Games
select g;
foreach (var game in query1)
{
gameFill.Add(game);
}
}
}
public void Setup()
{
_operations = new UserCRUD();
// remove test entry in DB if present
using (var db = new Gam3Sp0tContext())
{
var testUser =
from u in db.Users
where u.Username == "FRY"
select u;
db.Users.RemoveRange(testUser);
db.SaveChanges();
}
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
string title = txtTitle.Text;
DateTime?release = datePicker.SelectedDate;
if ((title != "") && release.HasValue)
{
using (var db = new Gam3Sp0tContext())
{
var newGa = new Game()
{
GameTitle = title,
ReleaseDate = release
};
db.Add(newGa);
db.SaveChanges();
}
_operation.BindGames();
BtnCancel_Click(sender, e);
}
}
