public async Task UpdateFirstSheetRecordAsync(SheetRecordDataModel sheetItem)
{
FirstSheetItem entityFromDb = await _context.FirstSheetItems.Where(x => !x.DtDelete.HasValue).AsNoTracking()
.FirstOrDefaultAsync(i => i.ID == sheetItem.ID);
if (entityFromDb is null || entityFromDb.DtDelete.HasValue)
{
throw new Exception("Запись не найдена.");
}
FirstSheetItem entity = _mapper.Map <FirstSheetItem>(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> GetFirstSheetRecordAsync(int id)
{
FirstSheetItem entity = await _context.FirstSheetItems.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 AddFirstSheetItemsAsync(List <SheetRecordDataModel> itemList)
{
List <FirstSheetItem> entityList = itemList.Select(i =>
{
FirstSheetItem entity = _mapper.Map <FirstSheetItem>(i);
entity.ID = 0;
return(entity);
}).ToList();
try
{
_context.FirstSheetItems.AddRange(entityList);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private async Task DeleteFirstSheetItemAsync(int id)
{
FirstSheetItem entity = await _context.FirstSheetItems.Where(x => !x.DtDelete.HasValue)
.FirstOrDefaultAsync(i => i.ID == id);
if (entity is null || entity.DtDelete.HasValue)
{
throw new Exception("Запись не найдена.");
}
entity.DtDelete = DateTime.UtcNow;
try
{
_context.Entry(entity).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
