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); }