public static void ClearData(RushHourContext context)
{
ExecuteDeleteSQL(context, "CustomerAddresses");
ExecuteDeleteSQL(context, "Customers");
ExecuteDeleteSQL(context, "Drivers");
ExecuteDeleteSQL(context, "Deliveries");
}
public CustomerTests()
{
_db = new RushHourContext();
_repo = new CustomerRepo();
CleanDatabase();
}
public static void SeedData(RushHourContext context)
{
try
{
if (!context.Customers.Any())
{
context.Customers.AddRange(SampleData.GetCustomers());
context.SaveChanges();
}
if (!context.Addresses.Any())
{
context.Addresses.AddRange(SampleData.GetCustomerAddresses());
context.SaveChanges();
}
if (!context.Drivers.Any())
{
context.Drivers.AddRange(SampleData.GetDrivers());
context.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public static void ResetIdentity(RushHourContext context)
{
var tables = new[] { "Drivers", "CustomerAddresses", "Customers",
"Deliveries" };
foreach (var itm in tables)
{
var sql = $"DBCC CHECKIDENT (\"{itm}\", RESEED, -1);";
context.Database.ExecuteSqlCommand(sql);
}
}
public void ShouldDeleteDriverWithTimestampWithRepo()
{
var driver = new Driver {
FirstName = "Johnny", MiddleName = "Carlos", LastName = "Lopez"
};
_repo.Add(driver, false);
_repo.SaveChanges();
var context = new RushHourContext();
var driverToDelete = new Driver {
Id = driver.Id, TimeStamp = driver.TimeStamp
};
context.Entry(driverToDelete).State = EntityState.Deleted;
var affected = context.SaveChanges();
Assert.AreEqual(1, affected);
}
public void ShouldDeleteDriverWithTimestampWithRepo()
{
var cust = new Customer {
Name = "Best Brakes"
};
_repo.Add(cust, false);
_repo.SaveChanges();
var context = new RushHourContext();
var custToDelete = new Customer {
Id = cust.Id, TimeStamp = cust.TimeStamp
};
context.Entry(custToDelete).State = EntityState.Deleted;
var affected = context.SaveChanges();
Assert.AreEqual(1, affected);
}
public void ShouldUpdateCustomerWithRepo()
{
var cust = new Customer {
Name = "Best Brakes"
};
_repo.Add(cust, false);
_repo.SaveChanges();
var modified = cust.DateModified;
cust.Name = "Best";
Assert.AreEqual(EntityState.Modified, _repo.Context.Entry(cust).State);
_repo.SaveChanges();
Assert.AreEqual(EntityState.Unchanged, _repo.Context.Entry(cust).State);
using (var context = new RushHourContext())
{
Assert.AreEqual("Best", context.Customers.First().Name);
Assert.AreNotEqual(modified, context.Customers.First().DateModified);
}
}
public void ShouldUpdateDriverWithRepo()
{
var driver = new Driver {
FirstName = "Johnny", MiddleName = "Carlos", LastName = "Lopez"
};
_repo.Add(driver, false);
_repo.SaveChanges();
var modified = driver.DateModified;
driver.FirstName = "Juan";
Assert.AreEqual(EntityState.Modified, _repo.Context.Entry(driver).State);
_repo.SaveChanges();
Assert.AreEqual(EntityState.Unchanged, _repo.Context.Entry(driver).State);
using (var context = new RushHourContext())
{
Assert.AreEqual("Juan", context.Drivers.First().FirstName);
Assert.AreNotEqual(modified, context.Drivers.First().DateModified);
}
}
public FreightTests()
{
_db = new RushHourContext();
CleanDatabase();
}
public BaseRepository(RushHourContext context)
{
this.context = context;
}
public DeliveryTests()
{
_db = new RushHourContext();
_repo = new DeliveryRepo();
CleanDatabase();
}
public UnitOfWork()
{
this.context = new RushHourContext();
}
public UsersRepository(RushHourContext context) : base(context)
{
}
public BaseRepository(RushHourContext db)
{
this.db = db;
_table = db.Set <T>();
}
public BaseRepository()
{
this.db = new RushHourContext();
_table = db.Set <T>();
}
public RepoBase()
{
Db = new RushHourContext();
Table = Db.Set <T>();
}
public static void InitializeData(RushHourContext context)
{
ClearData(context);
ResetIdentity(context);
SeedData(context);
}
public DriverTests()
{
_db = new RushHourContext();
_repo = new DriverRepo();
CleanDatabase();
}
public static void ExecuteDeleteSQL(RushHourContext context, string tableName)
{
var sql = $"Delete from {tableName}";
context.Database.ExecuteSqlCommand(sql);
}
public AppointmentRepository(RushHourContext context) : base(context)
{
}
public ActivitiesRepository(RushHourContext context) : base(context)
{
}
