public async Task <IIncidentData> BuildAux(IIncidentData result)
{
var auxQueryStore = QueryStoreFactory.GetQueryStore();
#region KarveCode Generator for query multiple
// Code Generated that concatains multiple queries to be executed by QueryMultipleAsync.
auxQueryStore.AddParamCount(QueryType.QueryOffice, dto.OFICINA);
auxQueryStore.AddParamCount(QueryType.QuerySupplierSummary, dto.PROVEE);
auxQueryStore.AddParamCount(QueryType.QueryVehicleSummary, dto.VEHI);
auxQueryStore.AddParamCount(QueryType.ClientSummaryExtended, dto.CLIENTE);
auxQueryStore.AddParamCount(QueryType.IncidentType, dto.COINRE);
#endregion
var query = auxQueryStore.BuildQuery();
using (var connection = SqlExecutor.OpenNewDbConnection())
{
if (connection != null)
{
var multipleResult = await connection.QueryMultipleAsync(query).ConfigureAwait(false);
result.Valid = ParseResult(result, multipleResult);
}
}
return(result);
}
private bool ParseResult(IIncidentData request, SqlMapper.GridReader reader)
{
if ((request == null) || (reader == null))
{
return(false);
}
if (request.Value == null)
{
return(false);
}
try
{
request.IncidentOfficeDto = SelectionHelpers.WrappedSelectedDto <OFICINA, OfficeDto>(request.Value.OFICINA, _mapper, reader);
request.IncidentSupplierDto = SelectionHelpers.WrappedSelectedDto <PROVEE1, SupplierSummaryDto>(request.Value.PROVEE, _mapper, reader);
request.IncidentVehicleDto = SelectionHelpers.WrappedSelectedDto <VehicleSummaryDto, VehicleSummaryDto>(request.Value.VEHI, _mapper, reader);
request.IncidentClientDto = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(request.Value.CLIENTE, _mapper, reader);
request.IncidentTypeDto = SelectionHelpers.WrappedSelectedDto <COINRE, IncidentTypeDto>(request.Value.TIPO, _mapper, reader);
#pragma warning disable CS0168 // Variable is declared but never used
}
catch (System.Exception ex)
#pragma warning restore CS0168 // Variable is declared but never used
{
return(false);
}
return(true);
}
public HomeController(IIncidentData incidentData,
ILogger <HomeController> logger,
AdminAlert adminAlert)
{
_adminAlert = adminAlert;
_logger = logger;
_incidentData = incidentData;
}
public async Task <bool> SaveAsync(IIncidentData domainObject)
{
if (!domainObject.Valid)
{
return(false);
}
var savedReservation = await _dataSaver.SaveAsync(domainObject.Value).ConfigureAwait(false);
return(savedReservation);
}
public async Task <bool> DeleteAsync(IIncidentData domainObject)
{
if (!domainObject.Valid)
{
return(false);
}
var dto = domainObject.Value;
var result = await _dataDeleter.DeleteAsync(dto).ConfigureAwait(false);
return(result);
}
public IncidentController(IIncidentData incidents,
ILogger <IncidentController> logger)
{
_logger = logger;
_incidents = incidents;
}
private IIncidentData _incidentData; // Service om data op te halen
public IncidentController(IIncidentData incidentData)
{
_incidentData = incidentData;
}
