private void LoadModel()
{
_file = new FileInfo(Application.StartupPath + @"\\Vehicle.xlsx");
using (var package = new ExcelPackage(_file))
{
var workbook = package.Workbook;
using (var tx = NHibernateSessionManager.GetLocalSession().BeginTransaction())
{
var ws = workbook.Worksheets[@"Model"];
var brands = _vehicleBrandRepository.GetAll();
for (var i = 1; i < ws.Dimension.End.Row + 1; i++)
{
VehicleSize size;
Enum.TryParse(ws.Cells[i, 3].Value.ToString(), out size);
var newModel = new VehicleModel(
ws.Cells[i, 1].Value.ToString(),
ws.Cells[i, 2].Value.ToString(),
brands.FirstOrDefault(x => x.Code == ws.Cells[i, 3].Value.ToString()),
size,
VehicleType.CAR
);
_vehicleModelRepository.Insert(newModel);
}
tx.Commit();
}
}
}
public VehicleModel Save(string code, string name, VehicleBrand brand, VehicleSize size, VehicleType type)
{
VehicleModel newModel = null;
var session = NHibernateSessionManager.GetLocalSession();
session.DoTransactional(sess =>
{
newModel = _modelRepo.Insert(new VehicleModel(code, name, brand, size, type));
});
return(newModel);
}
public async Task <int> InsertVehicleModel(IVehicleModelDomainModel entity)
{
return(await _vehicleModelRepository.Insert(entity));
}