public bool ImportAreaExcel(ExcelWorksheet areaSheet) { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, new System.TimeSpan(0, 60, 0))) { try { var rowCount = areaSheet.Dimension.End.Row; for (int i = 2; i <= rowCount; i++) { string areaCode = areaSheet.Cells[i, 1].Value.ToString(); string areaName = areaSheet.Cells[i, 2].Value.ToString(); string areaDescription = areaSheet.Cells[i, 3].Value.ToString(); string LocationName = areaSheet.Cells[i, 4].Value.ToString(); Location location = _locationService.GetLocationByName(LocationName); Area area; if (_areaService.GetAreaByCode(areaCode) != null) { area = _areaService.GetAreaByCode(areaCode); area.AreaCode = areaCode; area.Name = areaName; area.LocationID = location.ID; area.Description = areaDescription; area.Active = true; _areaService.Update(area); _areaService.SaveChanges(); } else { area = new Area(); area.AreaCode = areaCode; area.Name = areaName; area.LocationID = location.ID; area.Description = areaDescription; area.Active = true; _areaService.Add(area); _areaService.SaveChanges(); } } scope.Complete(); return(true); } catch (Exception e) { return(false); } } }
public void AreaService_Add() { Area area = new Area { LocationID = 1, Name = "Area test", AreaCode = "UT_Area_service", Description = "tet add area", CreatedAt = DateTime.Now, UpdatedAt = DateTime.Now, Active = true }; _areaService.Add(area); _areaService.SaveChanges(); Assert.IsNotNull(_areaService.GetAreaByCode("UT_Area_service")); }