/// <summary>
/// Справочник DeviceFaults
/// </summary>
private static async Task <ReportResponse> GetDeviceFaultsTable(ReportRequest input, ILogger logger)
{
var sqlR = new DeviceFaultRepository(logger);
var result = new ReportResponse {
Rows = new List <Row>()
};
var data = await sqlR.GetAll();
result.Columns = new List <Column>
{
new Column("col0", "Название", "string", disableEdit: false),
new Column("col1", "Описание", "string", disableEdit: false),
};
foreach (var item in data)
{
var row = new Row
{
Id = new RowId(item.Id, 1),
HasItems = false.ToString(),
ParentId = null,
//Имя
Col0 = item.Name,
//Описание
Col1 = item.Description,
};
result.Rows.Add(row);
}
return(result);
}
public async Task Delete(int id)
{
await CheckPermission();
using (var rep = new DeviceFaultRepository(_logger))
{
await rep.Delete(id);
}
}
public async Task <JsonResult> GetAllDeviceFaults()
{
CheckApiKey();
using (var sqlR = new DeviceFaultRepository(_logger))
{
var result = await sqlR.GetAllForSync();
return(Json(result));
}
}
public async Task <JsonResult> GetAll()
{
await CheckPermission();
using (var rep = new DeviceFaultRepository(_logger))
{
var result = await rep.GetAll();
return(Json(result));
}
}
public async Task <JsonResult> AddOrUpdate([FromBody] DeviceFault input)
{
await CheckPermission();
using (var rep = new DeviceFaultRepository(_logger))
{
if (input.Id == 0)
{
return(Json(await rep.Add(input)));
}
return(Json(await rep.Update(input)));
}
}
/// <summary>
/// КРУД DeviceFaults
/// </summary>
public async Task <DictionaryCrudResponse> DeviceFaultsCrud(DictionaryCrudRequest input)
{
var data = input.DeviceFault;
if (data == null && input.IdToDelete == null)
{
throw new ValidationException(Error.ParserError);
}
var sqlR = new DeviceFaultRepository(_logger);
if (input?.IdToDelete != null)
{
await sqlR.Delete((int)input.IdToDelete);
return(new DictionaryCrudResponse {
IsDeleted = true, DeviceFault = data
});
}
var all = await sqlR.GetAll();
if (all.Any(x => x.Name.Equals(input.DeviceFault.Name)))
{
throw new ValidationException(Error.AlreadyAddWithThisName);
}
if (data?.Id == 0)
{
var item = await sqlR.Add(data);
return(new DictionaryCrudResponse {
IsAdd = true, DeviceFault = item
});
}
else
{
var item = await sqlR.Update(data);
return(new DictionaryCrudResponse {
IsUpdated = true, DeviceFault = item
});
}
}
