//public SalesManager Sale { get; set; }
public UnitOfWork()
{
Brands = new BrandRepo();
Phones = new PhoneRepo();
PhoneCases = new PhoneCaseRepo();
// Sale = new SalesManager();
}
public UnitOfWork()
{
BrandRepo = new BrandRepo();
PhoneRepo = new PhoneRepo();
PhoneCaseRepo = new PhoneCaseRepo();
SalesManager = new SalesManager();
}
public async Task FindByNameReturnsNullIfNothing()
{
using (var conn = OpenConnection()) {
var b = new Brand("Name");
await conn.ExecuteAsync("insert into brands (id, name) values (@Id, @Name);", b);
var repo = new BrandRepo(Database);
var found = await repo.FindByName("cat");
Assert.IsNull(found);
}
}
public async Task FindByNameFinds()
{
using (var conn = OpenConnection()) {
var b = new Brand("Name23");
await conn.ExecuteAsync("insert into brands (id, name) values (@Id, @Name);", b);
var repo = new BrandRepo(Database);
var found = (await repo.FindByName(b.Name)) !;
Assert.AreEqual(b.Id, found.Id);
Assert.AreEqual(b.Name, found.Name);
}
}
public async Task DeleteRemovesBrand()
{
using (var conn = OpenConnection()) {
var b = new Brand("Name");
await conn.ExecuteAsync("insert into brands (id, name) values (@Id, @Name);", b);
var repo = new BrandRepo(Database);
await repo.Delete(b);
var count = await conn.QueryFirstAsync <int>("Select count(*) from brands where id = @Id;", b);
Assert.AreEqual(0, count);
}
}
public List <SelectListItem> BrandSelectList()
{
var BrandList = new BrandRepo().GetAll();
var Brands = new List <SelectListItem>();
BrandList.ForEach(x =>
Brands.Add(new SelectListItem
{
Text = x.BrandName,
Value = x.ID.ToString()
})
);
return(Brands);
}
public async Task UpdateUpdatesName()
{
using (var conn = OpenConnection()) {
var b = new Brand("Name");
await conn.ExecuteAsync("insert into brands (id, name) values (@Id, @Name);", b);
var repo = new BrandRepo(Database);
b.Name = "Name2";
await repo.Update(b);
var newName = await conn.QueryFirstAsync <string>("Select name from brands where id = @Id;", b);
Assert.AreEqual("Name2", b.Name);
}
}
public async Task AddSavesBrandToDatabase()
{
var brandRepo = new BrandRepo(DatabaseManager.Database);
var b = new Brand("Name");
await brandRepo.Add(b);
using (var conn = OpenConnection()) {
var raw = await conn.QueryFirstOrDefaultAsync(
@"select * from brands where id = @Id;", b
);
Assert.AreEqual(b.Id, raw.id);
Assert.AreEqual(b.Name, raw.name);
}
}
public static async Task InsertTestData(TestContext context)
{
// Ensure actually empty
using (var conn = OpenConnection()) {
await conn.ExecuteAsync("delete from pad_series;");
await conn.ExecuteAsync("delete from brands;");
}
// Insert brands
var brandRepo = new BrandRepo(Database);
var b1 = new Brand("Brand1");
var b2 = new Brand("Brand2");
var b3 = new Brand("Brand3");
await brandRepo.Add(b1);
await brandRepo.Add(b2);
await brandRepo.Add(b3);
// Insert pad series
var ps1 = new PadSeries("Beta", b1.Id, new(new[] { PolisherType.DualAction }));
ps1.Sizes.Add(new PadSize(new Measurement(1, "in")));
ps1.Pads.Add(new Pad("Pad", PadCategory.Cutting, PadMaterial.Foam, PadTexture.Dimpled, PadColor.Red, false));
ps1.Pads[0].Options.Add(new PadOption(ps1.Sizes[0].Id));
var ps2 = new PadSeries("Zoo", b1.Id, new(new[] { PolisherType.DualAction }));
ps2.Sizes.Add(new PadSize(new Measurement(1, "in")));
ps2.Pads.Add(new Pad("Pad2", PadCategory.Cutting, PadMaterial.Foam, PadTexture.Dimpled, PadColor.Red, false));
ps2.Pads[0].Options.Add(new PadOption(ps2.Sizes[0].Id));
var padSeriesRepo = new PadSeriesRepo(Database);
await padSeriesRepo.Add(ps1);
await padSeriesRepo.Add(ps2);
}
public UnitOfWork()
{
Brands = new BrandRepo();
Phones = new PhoneRepo();
PhoneCases = new PhoneCaseRepo();
}
public static List <string> ReturnBrandsList(int CategoryId)
{
List <string> list = BrandRepo.GetBrands(CategoryId).ToList();
return(list);
}
