public void READNewRiderAdded_CorrectDetails()
{
using (var db = new TT_ProjectContext())
{
var numberBefore = db.RiderAccounts.ToList().Count();
_crudManager.CreateRiderAccount("*****@*****.**", "Password", "Steph", "Foxton", Convert.ToDateTime("25/04/1996"), "Manx", "No racing experience");
var numberAfter = db.RiderAccounts.ToList().Count();
Assert.AreEqual(numberBefore + 1, numberAfter);
var createdRider =
from c in db.RiderAccounts
where c.Email == "*****@*****.**"
select c;
foreach (var c in createdRider)
{
Assert.AreEqual("Password", c.Passwrd);
Assert.AreEqual("Steph", c.FirstName);
Assert.AreEqual("Foxton", c.LastName);
Assert.AreEqual(Convert.ToDateTime("25/04/1996").ToShortDateString(), c.DateOfBirth);
Assert.AreEqual("Manx", c.Nationality);
Assert.AreEqual("No racing experience", c.Experience);
}
}
}
public List <Bike> RetrieveAllBikes()
{
using (var db = new TT_ProjectContext())
{
return(db.Bikes.ToList());
}
}
public void ChoosingSelectedStaff(string email)
{
using (var db = new TT_ProjectContext())
{
SelectedStaff = db.StaffAccounts.Where(e => e.Email.Trim() == email.Trim()).FirstOrDefault();
}
}
public List <StaffAccount> RetrieveAllStaff()
{
using (var db = new TT_ProjectContext())
{
return(db.StaffAccounts.ToList());
}
}
public void TearDown()
{
using (var db = new TT_ProjectContext())
{
var selectedRider =
from ra in db.RiderAccounts
where ra.Email == "*****@*****.**" || ra.Email == "*****@*****.**" || ra.Email == "*****@*****.**"
select ra;
db.RiderAccounts.RemoveRange(selectedRider);
db.SaveChanges();
var selectedStaff =
from sa in db.StaffAccounts
where sa.Email == "*****@*****.**"
select sa;
db.StaffAccounts.RemoveRange(selectedStaff);
db.SaveChanges();
var selectedBike =
from b in db.Bikes
where b.BikeMake == "Zero"
select b;
db.Bikes.RemoveRange(selectedBike);
db.SaveChanges();
var selectedEntry =
from e in db.Entries
where e.RaceId == 5
select e;
db.Entries.RemoveRange(selectedEntry);
db.SaveChanges();
}
}
public void UPDATERiderDetails_DatabaseIsUpdated()
{
using (var db = new TT_ProjectContext())
{
var newRider = new RiderAccount()
{
Email = "*****@*****.**",
Passwrd = "password",
FirstName = "Breesha",
LastName = "Foxton",
DateOfBirth = Convert.ToDateTime("24/06/1998").ToShortDateString(),
Nationality = "Manx",
Experience = "no rider experience"
};
db.RiderAccounts.Add(newRider);
db.SaveChanges();
}
_crudManager.UpdateRider("*****@*****.**", "Bree", "FoxtoN", Convert.ToDateTime("25/06/1998"), "French", "2020 Winner Senior");
using (var db = new TT_ProjectContext())
{
var SelectedRider = db.RiderAccounts.Where(c => c.Email == "*****@*****.**").FirstOrDefault();
Assert.AreEqual("Bree", SelectedRider.FirstName);
Assert.AreEqual("FoxtoN", SelectedRider.LastName);
Assert.AreEqual(Convert.ToDateTime("25/06/1998").ToShortDateString(), SelectedRider.DateOfBirth);
Assert.AreEqual("French", SelectedRider.Nationality);
Assert.AreEqual("2020 Winner Senior", SelectedRider.Experience);
}
}
public List <Entry> RetrieveAllEntryDetails(string email)
{
using (var db = new TT_ProjectContext())
{
return((from e in db.Entries
join ra in db.RiderAccounts on e.RiderId equals ra.RiderId
where ra.Email == email
select e).ToList());
}
}
public List <Bike> RetrieveAllBikesDetails(string email)
{
using (var db = new TT_ProjectContext())
{
return((from b in db.Bikes
join ra in db.RiderAccounts on b.RiderId equals ra.RiderId
where ra.Email == email
select b).ToList());
}
}
public void CREATEStaff_NumberIncreasesBy1()
{
using (var db = new TT_ProjectContext())
{
var numberBefore = db.StaffAccounts.ToList().Count();
_crudManager.CreateStaffAccount("*****@*****.**", "Password", "Steph", "Foxton");
var numberAfter = db.StaffAccounts.ToList().Count();
Assert.AreEqual(numberBefore + 1, numberAfter);
}
}
public void CREATERaceEntry_EntriesIncreaseBy1()
{
using (var db = new TT_ProjectContext())
{
var numberBefore = db.Entries.ToList().Count();
_crudManager.CreateRaceEntry(1, 5);
var numberAfter = db.Entries.ToList().Count();
Assert.AreEqual(numberBefore + 1, numberAfter);
}
}
public void CREATEBike_NumberIncreasesBy1()
{
using (var db = new TT_ProjectContext())
{
var numberBefore = db.Bikes.ToList().Count();
_crudManager.CreateBike(1, "Zero", "McGuiness");
var numberAfter = db.Bikes.ToList().Count();
Assert.AreEqual(numberBefore + 1, numberAfter);
}
}
public void CREATERider_NumberIncreasesBy1()
{
using (var db = new TT_ProjectContext())
{
var numberBefore = db.RiderAccounts.ToList().Count();
_crudManager.CreateRiderAccount("*****@*****.**", "Password", "Steph", "Foxton", Convert.ToDateTime("25/04/1996"), "Manx", "No racing experience");
var numberAfter = db.RiderAccounts.ToList().Count();
Assert.AreEqual(numberBefore + 1, numberAfter);
}
}
public void UpdateStaff(string email, string firstname, string lastname)
{
using (var db = new TT_ProjectContext())
{
SelectedStaff = db.StaffAccounts.Where(c => c.Email == email).FirstOrDefault();
SelectedStaff.FirstName = firstname;
SelectedStaff.LastName = lastname;
db.SaveChanges();
}
}
public Dictionary <string, string> RetrieveAllEmailsPasswords()
{
using (var db = new TT_ProjectContext())
{
Dictionary <string, string> emailPass = new Dictionary <string, string>();
foreach (var item in db.RiderAccounts)
{
emailPass.Add(item.Email, item.Passwrd);
}
return(emailPass);
}
}
public List <string> RetrieveAllEmailsSTAFF()
{
using (var db = new TT_ProjectContext())
{
List <string> emailListSTAFF = new List <string>();
foreach (var item in db.StaffAccounts)
{
emailListSTAFF.Add(item.Email);
}
return(emailListSTAFF);
}
}
public List <string> RetrieveAllEmails()
{
using (var db = new TT_ProjectContext())
{
List <string> emailList = new List <string>();
foreach (var item in db.RiderAccounts)
{
emailList.Add(item.Email);
}
return(emailList);
}
}
public void DeleteEntry(int entryid)
{
using (var db = new TT_ProjectContext())
{
var selectedEntry =
from e in db.Entries
where e.EntryId == entryid
select e;
db.Entries.RemoveRange(selectedEntry);
db.SaveChanges();
}
}
public void CreateRaceEntry(int riderid, int raceid)
{
using (var db = new TT_ProjectContext())
{
var newEntry = new Entry
{
RiderId = riderid,
RaceId = raceid
};
db.Entries.Add(newEntry);
db.SaveChanges();
}
}
public void DeleteBike(int bikeid)
{
using (var db = new TT_ProjectContext())
{
var selectedBike =
from b in db.Bikes
where b.BikeId == bikeid
select b;
db.Bikes.RemoveRange(selectedBike);
db.SaveChanges();
}
}
public void CreateBike(int riderid, string make, string sponsor)
{
using (var db = new TT_ProjectContext())
{
var newBike = new Bike
{
RiderId = riderid,
BikeMake = make.Trim(),
BikeSponsor = sponsor.Trim()
};
db.Bikes.Add(newBike);
db.SaveChanges();
}
}
public void CreateStaffAccount(string email, string password, string firstname, string lastname)
{
using (var db = new TT_ProjectContext())
{
var newStaffAccount = new StaffAccount
{
Email = email.Trim(),
Passwrd = password.Trim(),
FirstName = firstname.Trim(),
LastName = lastname.Trim()
};
db.StaffAccounts.Add(newStaffAccount);
db.SaveChanges();
}
}
public void SetUp()
{
var options = new DbContextOptionsBuilder <TT_ProjectContext>()
.UseInMemoryDatabase(databaseName: "Example_DB")
.Options;
var context = new TT_ProjectContext(options);
_sut = new RiderAccountService(context);
_sut.CreateRiderAccount(new RiderAccount {
RiderId = 1, Email = "*****@*****.**", Passwrd = "william", FirstName = "William", LastName = "Foxton", DateOfBirth = "28/12/1996", Nationality = "Manx", Experience = "None"
});
_sut.CreateRiderAccount(new RiderAccount {
RiderId = 2, Email = "*****@*****.**", Passwrd = "nish", FirstName = "Nishant", LastName = "Mandal", DateOfBirth = "28/12/1996", Nationality = "English", Experience = "None"
});
}
public void DELETERaceEntry_NumberDecreasesBy1()
{
using (var db = new TT_ProjectContext())
{
var newEntry = new Entry
{
RiderId = 1,
RaceId = 1
};
db.Entries.Add(newEntry);
db.SaveChanges();
var numberBefore = db.Entries.ToList().Count();
//SQL Query to find entryid
_crudManager.DeleteEntry(2048);
var numberAfter = db.Entries.ToList().Count();
Assert.AreEqual(numberBefore, numberAfter + 1);
}
}
public void DELETEBike_NumberDecreasesBy1()
{
using (var db = new TT_ProjectContext())
{
var newBike = new Bike
{
RiderId = 1,
BikeMake = "Electric",
BikeSponsor = "Norton"
};
db.Bikes.Add(newBike);
db.SaveChanges();
var numberBefore = db.Bikes.ToList().Count();
//SQL Query to find bikeid
_crudManager.DeleteBike(1047);
var numberAfter = db.Bikes.ToList().Count();
Assert.AreEqual(numberBefore, numberAfter + 1);
}
}
static void Main(string[] args)
{
using (var db = new TT_ProjectContext())
{
}
}
public void Setup()
{
using (var db = new TT_ProjectContext())
{
}
}
