private void CreateCarModels(IEnumerable <ExcelVehicleViewModel> data)
{
foreach (var row in data)
{
var type = CatalogUow.CarTypes.All().FirstOrDefault(it => it.Name == row.CarType);
var brand = CatalogUow.CarBrands.All().FirstOrDefault(it => it.Name == row.CarBrand);
var modelName = string.Format("{0} - {1}", row.CarModel, row.CarModelVersion);
var model = CatalogUow.CarModels.All().Include(it => it.CarModifications).FirstOrDefault(it => it.Name == modelName) ?? new CarModel()
{
CarBrand = brand,
CarType = type,
CarModifications = new List <CarModification>(),
Name = modelName
};
model.CarModifications.Add(new CarModification()
{
Model = model,
Engine = row.Engine,
EnginePower = GetIntValue(row.KW),
EngineHorsePower = GetIntValue(row.HP),
EngineType = row.EngineType,
EngineFuelType = GetFuelType(row.Fuel),
Year = GetIntValue(row.Year)
});
CatalogUow.CarModels.InsertOrUpdate(model);
CatalogUow.Commit();
}
}
CarModelViewModel ICarModelService.Create(CarModelViewModel carModel)
{
var entity = EntityMapper.Map(carModel);
CatalogUow.CarModels.InsertOrUpdate(entity);
CatalogUow.Commit();
var updated = ((ICarModelService)(this)).GetById(entity.Id);
return(EntityMapper.Map(updated));
}
CarBrandViewModel ICarBrandService.Create(CarBrandViewModel carBrand)
{
var brand = EntityMapper.Map(carBrand);
CatalogUow.CarBrands.InsertOrUpdate(brand);
CatalogUow.Commit();
var newBrand = CatalogUow.CarBrands.All().Include(it => it.Country).First(it => it.Id == brand.Id);
return(EntityMapper.Map(newBrand));
}
void ICountryService.UploadCsvList(Stream stream)
{
var countries = countryCsvReader.Read(stream);
foreach (var country in countries)
{
CatalogUow.Countries.InsertOrUpdate(country);
}
CatalogUow.Commit();
}
private void CreateCarTypesAndBrands(IEnumerable <ExcelVehicleViewModel> data)
{
var carBrands = data.GroupBy(it => it.CarType, it => it.CarBrand, (key, g) => new KeyValuePair <string, IEnumerable <string> >(key, g));
foreach (var carType in carBrands)
{
SaveCarType(carType.Key);
var brands = carType.Value.Distinct();
foreach (var brand in brands)
{
SaveCarBrand(brand);
}
}
CatalogUow.Commit();
}
void ICarModificationService.Create(CarModification carModification)
{
CatalogUow.CarModifications.InsertOrUpdate(carModification);
CatalogUow.Commit();
}
