private void LoadBrand()
{
_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[@"Brand"];
for (var i = 1; i < ws.Dimension.End.Row + 1; i++)
{
var newBrand = new VehicleBrand(
ws.Cells[i, 1].Value.ToString(),
ws.Cells[i, 2].Value.ToString()
);
_vehicleBrandRepository.Insert(newBrand);
}
tx.Commit();
}
}
}
public VehicleBrand Save(string code, string name)
{
VehicleBrand brand = null;
ISession session = NHibernateSessionManager.GetLocalSession();
session.DoTransactional(sess =>
{
brand = _brandRepo.Insert(
new VehicleBrand(code, name));
});
return(brand);
}
