public async Task UpdateSecondSheetRecordAsync(SheetRecordDataModel sheetItem)
{
SecondSheetItem entityFromDb = await _context.SecondSheetItems.Where(x => !x.DtDelete.HasValue).AsNoTracking()
.FirstOrDefaultAsync(i => i.ID == sheetItem.ID);
if (entityFromDb is null || entityFromDb.DtDelete.HasValue)
{
throw new Exception("Запись не найдена.");
}
SecondSheetItem entity = _mapper.Map <SecondSheetItem>(sheetItem);
entity.DtAdd = entityFromDb.DtAdd;
entity.DtEdit = DateTime.UtcNow;
try
{
_context.Entry(entity).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <SheetRecordDataModel> GetSecondSheetRecordAsync(int id)
{
SecondSheetItem entity = await _context.SecondSheetItems.Where(i => !i.DtDelete.HasValue).AsNoTracking()
.FirstOrDefaultAsync(x => x.ID == id);
if (entity is null)
{
return(null);
}
return(_mapper.Map <SheetRecordDataModel>(entity));
}
private async Task AddSecondSheetItemsAsync(List <SheetRecordDataModel> itemList)
{
List <SecondSheetItem> entityList = itemList.Select(i =>
{
SecondSheetItem entity = _mapper.Map <SecondSheetItem>(i);
entity.ID = 0;
return(entity);
}).ToList();
try
{
_context.SecondSheetItems.AddRange(entityList);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private async Task DeleteSecondSheetItemAsync(int id)
{
SecondSheetItem entity = await _context.SecondSheetItems.Where(x => !x.DtDelete.HasValue)
.FirstOrDefaultAsync(i => i.ID == id);
if (entity is null || entity.DtDelete.HasValue)
{
throw new Exception("Запись не найдена.");
}
try
{
_context.SecondSheetItems.Remove(entity);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
