public static ManufacturersRepository GetManufacturersRepository(IUnitOfWork unitOfWork)
{
var repository = new ManufacturersRepository();
repository.UnitOfWork = unitOfWork;
return(repository);
}
public static void TestFixtureSetup(TestContext context)
{
con = new NpgsqlConnection(cs);
con.Open();
regionsRepository = new RegionsRepository(con);
countriesRepository = new CountriesRepository(con);
manufacturersRepository = new ManufacturersRepository(con);
manufacturerValidation = new ManufacturerValidation(con);
carsRepository = new CarsRepository(con);
regionsRepository.Save(Region1);
regionsRepository.Save(Region2);
regionsRepository.Save(Region3);
regionsRepository.Flush();
countriesRepository.Save(Country1);
countriesRepository.Save(Country2);
countriesRepository.Save(Country3);
countriesRepository.Flush();
manufacturersRepository.Save(Manufacturer1);
manufacturersRepository.Save(Manufacturer2);
manufacturersRepository.Save(Manufacturer3);
manufacturersRepository.Flush();
carsRepository.SaveAndFlush(Car2);
}
public static void TestFixtureSetup(TestContext context)
{
con = new NpgsqlConnection(cs);
con.Open();
regionsRepository = new RegionsRepository(con);
countriesRepository = new CountriesRepository(con);
manufacturersRepository = new ManufacturersRepository(con);
manufacturersService = new ManufacturersService(con);
regionsRepository.Save(Region1);
regionsRepository.Save(Region2);
regionsRepository.Save(Region3);
regionsRepository.Flush();
countriesRepository.Save(Country1);
countriesRepository.Save(Country2);
countriesRepository.Save(Country3);
countriesRepository.Save(Country4);
countriesRepository.Save(Country5);
countriesRepository.Flush();
manufacturersRepository.Save(Manufacturer1);
manufacturersRepository.Save(Manufacturer2);
manufacturersRepository.Save(Manufacturer3);
manufacturersRepository.Save(Manufacturer4);
manufacturersRepository.Save(Manufacturer5);
manufacturersRepository.Save(Manufacturer6);
manufacturersRepository.Save(Manufacturer7);
manufacturersRepository.Save(Manufacturer8);
manufacturersRepository.Save(Manufacturer9);
manufacturersRepository.Flush();
}
public static void TestFixtureSetup(TestContext context)
{
con = new NpgsqlConnection(cs);
con.Open();
regionsRepository = new RegionsRepository(con);
countriesRepository = new CountriesRepository(con);
manufacturersRepository = new ManufacturersRepository(con);
carsRepository = new CarsRepository(con);
carValidation = new CarValidation(con);
ownerCarsRepository = new OwnerCarsRepository(con);
ownersRepository = new OwnersRepository(con);
regionsRepository.Save(Region1);
regionsRepository.Save(Region2);
regionsRepository.Save(Region3);
regionsRepository.Flush();
countriesRepository.Save(Country1);
countriesRepository.Save(Country2);
countriesRepository.Save(Country3);
countriesRepository.Save(Country4);
countriesRepository.Save(Country5);
countriesRepository.Flush();
manufacturersRepository.Save(Manufacturer1);
manufacturersRepository.Save(Manufacturer2);
manufacturersRepository.Save(Manufacturer3);
manufacturersRepository.Save(Manufacturer4);
manufacturersRepository.Save(Manufacturer5);
manufacturersRepository.Save(Manufacturer6);
manufacturersRepository.Save(Manufacturer7);
manufacturersRepository.Save(Manufacturer8);
manufacturersRepository.Save(Manufacturer9);
manufacturersRepository.Flush();
carsRepository.Save(Car1);
carsRepository.Save(Car2);
carsRepository.Save(Car3);
carsRepository.Save(Car4);
carsRepository.Save(Car5);
carsRepository.Save(Car6);
carsRepository.Save(Car7);
carsRepository.Save(Car8);
carsRepository.Save(Car9);
carsRepository.Save(Car10);
carsRepository.Save(Car11);
carsRepository.Save(Car12);
carsRepository.Save(Car13);
carsRepository.Save(Car14);
carsRepository.Save(Car15);
carsRepository.Flush();
ownersRepository.SaveAndFlush(Owner2);
ownerCarsRepository.SaveAndFlush(OwnerCar2);
}
public void Setup()
{
var builder = new DbContextOptionsBuilder <FactoryDbContext>();
builder.UseInMemoryDatabase(Guid.NewGuid().ToString());
var options = builder.Options;
_db = new FactoryDbContext(options);
_manufacturersRepository = new ManufacturersRepository(_db);
}
public Task <ExecuteResultEntity <ICollection <Manufacturers> > > GetManufacturersWithBusinessItemAsync(Guid MaterialCategoriesId, string BusinessItem)
{
try
{
ManufacturersRepository repo = RepositoryHelper.GetManufacturersRepository();
database = repo.UnitOfWork;
var matchedresult = (from q in repo.All()
from s in q.ManufacturersBussinessItems
where s.MaterialCategoriesId == MaterialCategoriesId &&
s.Name.Contains(BusinessItem)
select q).Distinct().ToList();
return(Task.FromResult(ExecuteResultEntity <ICollection <Manufacturers> > .CreateResultEntity(
new Collection <Manufacturers>(matchedresult))));
}
catch (Exception ex)
{
return(Task.FromResult(ExecuteResultEntity <ICollection <Manufacturers> > .CreateErrorResultEntity(ex)));
}
}
public AssetsLookupService(InventoryCategoryRepository inventoryCategoryRepository,
ManufacturersRepository manufacturersRepository)
{
this.inventoryCategoryRepository = inventoryCategoryRepository;
this.manufacturersRepository = manufacturersRepository;
}
public ManufacturersService(ManufacturersRepository repo)
{
_repo = repo;
}
/// <summary>Initializes a new instance of the <see cref="CountryValidation"/> class.</summary>
/// <param name="npgsqlConnection">The NPGSQL connection.</param>
public CountryValidation(NpgsqlConnection npgsqlConnection) : base(npgsqlConnection)
{
countriesRespository = new CountriesRepository(npgsqlConnection);
regionsRepository = new RegionsRepository(npgsqlConnection);
manufacturersRepository = new ManufacturersRepository(npgsqlConnection);
}
/// <summary>
/// 取得廠商代碼流水號
/// </summary>
/// <param name="Code"></param>
/// <returns></returns>
private string GetNextProjectSerialNumber()
{
string Code = string.Empty;
ManufacturersRepository repo = RepositoryHelper.GetManufacturersRepository(database);
var lastitem = repo.All()
.OrderByDescending(s => s.Code)
.FirstOrDefault();
if (lastitem != null)
{
int numif = 0;
if (int.TryParse(lastitem.Code, out numif))
{
if (numif <= 99)
{
Code = string.Format("{0:00}", (numif + 1));
return(Code);
}
}
Dictionary <int, string> dict = new Dictionary <int, string>();
dict.Add(0, "0");
dict.Add(1, "1");
dict.Add(2, "2");
dict.Add(3, "3");
dict.Add(4, "4");
dict.Add(5, "5");
dict.Add(6, "6");
dict.Add(7, "7");
dict.Add(8, "8");
dict.Add(9, "9");
dict.Add(10, "A");
dict.Add(11, "B");
dict.Add(12, "C");
dict.Add(13, "D");
dict.Add(14, "E");
dict.Add(15, "F");
dict.Add(16, "G");
dict.Add(17, "H");
dict.Add(18, "I");
dict.Add(19, "J");
dict.Add(20, "K");
dict.Add(21, "L");
dict.Add(22, "M");
dict.Add(23, "N");
dict.Add(24, "O");
dict.Add(25, "P");
dict.Add(26, "Q");
dict.Add(27, "R");
dict.Add(28, "S");
dict.Add(29, "T");
dict.Add(30, "U");
dict.Add(31, "V");
dict.Add(32, "W");
dict.Add(33, "X");
dict.Add(34, "Y");
dict.Add(35, "Z");
string hignchar = lastitem.Code.Substring(0, 1);
string lowchar = lastitem.Code.Substring(1, 1);
int lowint = dict.Where(w => w.Value == lowchar).Select(s => s.Key).Single();
int highint = dict.Where(w => w.Value == hignchar).Select(s => s.Key).Single();
if (lowint == 35)
{
lowint = 0;
highint += 1;
}
else
{
lowint += 1;
}
Code = dict[highint] + dict[lowint];
}
else
{
Code = "01";
}
return(string.Format("{0:00}", Code));
}
public MainWindowController()
{
ProjectRepository = RepositoryHelper.GetProjectsRepository(database);
ManufacturerRepository = RepositoryHelper.GetManufacturersRepository(database);
}
/// <summary>Initializes a new instance of the <see cref="CarValidation"/> class.</summary>
/// <param name="npgsqlConnection">The NPGSQL connection.</param>
public CarValidation(NpgsqlConnection npgsqlConnection) : base(npgsqlConnection)
{
carsRepository = new CarsRepository(npgsqlConnection);
manufacturersRepository = new ManufacturersRepository(npgsqlConnection);
ownerCarsRepository = new OwnerCarsRepository(npgsqlConnection);
}
