private void PreFillVendingMachines()
{
VendingMachineTableRecord vmRecord1 = new VendingMachineTableRecord()
{
Id = 1,
BalanceText = Balance.TwentyDollar.Encode(),
Frequency = 60,
GrandBalance = Balance.TwentyDollar.ToString(),
LastMaintDate = DateTime.Now,
Manufacturer = "GE",
Model = "VM-x-1",
StartDate = DateTime.Now,
State = VendingMachineStateEnum.Operational.DisplayName,
};
VendingMachineTableRecord vmRecord2 = new VendingMachineTableRecord()
{
Id = 2,
BalanceText = Balance.TenDollar.Encode(),
Frequency = 45,
GrandBalance = Balance.TenDollar.ToString(),
LastMaintDate = DateTime.Today,
Manufacturer = "BH",
Model = "VM-x-2",
StartDate = DateTime.Today,
State = VendingMachineStateEnum.Defect.DisplayName,
};
VendingMachineTableRecord vmRecord3 = new VendingMachineTableRecord()
{
Id = 3,
BalanceText = Balance.FiveDollar.Encode(),
Frequency = 50,
GrandBalance = Balance.FiveDollar.ToString(),
LastMaintDate = DateTime.Today,
Manufacturer = "Siemens",
Model = "VM-x-3",
StartDate = DateTime.Today,
State = VendingMachineStateEnum.Operational.DisplayName,
};
VendingMachineTableRecord vmRecord4 = new VendingMachineTableRecord()
{
Id = 10,
BalanceText = Balance.Cent.Encode(),
Frequency = 90,
GrandBalance = Balance.Cent.ToString(),
LastMaintDate = DateTime.Today,
Manufacturer = "HMI",
Model = "VM-x-100",
StartDate = DateTime.Today,
State = VendingMachineStateEnum.OnMaintenance.DisplayName,
};
VendingMachineRepository vmRepo = new VendingMachineRepository();
//vmRepo.AddModel(vmRecord1);
//vmRepo.AddModel(vmRecord2);
//vmRepo.AddModel(vmRecord3);
//vmRepo.AddModel(vmRecord4, true);
}
public VendingMachineModel FindById(int id)
{
VendingMachineModel vm = new VendingMachineModel();
VendingMachineTableRecord vmRecord = sqlUnitOfWork.FindById <VendingMachineTableRecord>(DataBaseServices.VendingMachineTableName, "Id", id);
new VendingMachineDataMapper().MapFromTable(ref vm, vmRecord);
LocationTableRecord locationRecord = sqlUnitOfWork.FindById <LocationTableRecord>(DataBaseServices.VendingMachineTableName, "VendingMachineId", vm.Id);
new LocationDataMapper().MapFromTable(ref vm, locationRecord);
IEnumerable <CellTableRecord> cells = sqlUnitOfWork.FindAll <CellTableRecord>(DataBaseServices.CellTableName, "VendingMachineId", vm.Id);
foreach (CellTableRecord cell in cells)
{
CellModel cellModel = new CellModel();
new CellDataMapper().MapFromTable(ref cellModel, cell);
vm.Cells.Add(cellModel);
}
return(vm);
}
