private async Task <int> GetCommoditySetIdAsync(int currentRow)
{
var commoditySetNameVal = _currentWorkSheet.Cells[currentRow, variableXlsDescription.CommoditySetCol].Value;
if (commoditySetNameVal == null)
{
return(0);
}
var commoditySetName = commoditySetNameVal.ToString();
var commoditySet = await _excelImportDataService.CommoditySetRepository.GetCommoditySetByName(commoditySetName);
if (commoditySet == null)
{
commoditySet = new CommoditySet {
Name = commoditySetName
};
_excelImportDataService.CommoditySetRepository.Add(commoditySet);
await _excelImportDataService.UnitOfWork.CompleteAsync();
}
return(commoditySet.Id);
}
public void Remove(CommoditySet CommoditySet)
{
context.Remove(CommoditySet);
}
public void Add(CommoditySet CommoditySet)
{
context.CommoditySet.Add(CommoditySet);
}
