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) { }