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