public async Task AddFaultToEquipment(FaultEquipment faultEquipment)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var sql = Sql.SqlQueryCach["Equipment.AddFaultToEquipment"];
await conn.ExecuteAsync(sql,
new { faultId = faultEquipment.FaultId, equipmentId = faultEquipment.EquipmentId });
}
}
public async Task <JsonResult> RemoveFaultFromEquipment([FromBody] FaultEquipment faultEquipment)
{
await CheckPermission();
var mr = new EquipmentRepository(_logger);
await mr.RemoveFaultFromEquipment(faultEquipment);
return(Json(new { message = "Delete OK" }));
}
public async Task RemoveFaultFromEquipment(FaultEquipment faultEquipment)
{
//Начинаем блядь КВН
using (var transaction = new TransactionScope(asyncFlowOption: TransactionScopeAsyncFlowOption.Enabled))
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var sql = Sql.SqlQueryCach["Equipment.RemoveFaultFromEquipment"];
await conn.ExecuteAsync(sql,
new { faultId = faultEquipment.FaultId, equipmentId = faultEquipment.EquipmentId });
}
transaction.Complete();
}
}
public async Task <JsonResult> AddFaultToEquipment([FromBody] FaultEquipment faultEquipment)
{
await CheckPermission();
try
{
var mr = new EquipmentRepository(_logger);
await mr.AddFaultToEquipment(faultEquipment);
return(Json(new { message = "Add OK" }));
}
catch (Exception e)
{
return(Json(e));
}
}