public async Task <int> ValidateAssignedVehicles(DNIProperties dni)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@dni", dni.DNI, DbType.String, ParameterDirection.Input, 10);
var result = await _dbConnection.QueryFirstAsync <int>("dbo.ISSP_ValidateAssignedVehicles", parameters, commandType : CommandType.StoredProcedure);
return(result);
}
public async Task <bool> ValidateDNI(DNIProperties dni)
{
var result = await _dbConnection.QueryFirstAsync <ResponseProperties>("dbo.ISSP_ValidateDNI", dni, commandType : CommandType.StoredProcedure);
return(result.code.Equals((int)TypeCode.Success) ? true : false);
}
public async Task <IEnumerable <InfractionDetails> > GetInfractionsByDriverAsync(DNIProperties dni)
{
var result = await _dbConnection.QueryAsync <DNIProperties, DriverProperties, CarProperties, TypeInfraction, DateTime, InfractionDetails>("dbo.ISSP_GetInfractionsByDriver",
map : (dp, d, c, ti, dt) =>
{
InfractionDetails ide = new InfractionDetails();
ide.dNI = dp;
ide.driverDetails = d;
ide.carDetails = c;
ide.infractionDetails = ti;
ide.dateInfraction = dt;
return(ide);
}, splitOn : "name,idCar,IdTypeInfraction,dateInfraction", param : dni, commandType : CommandType.StoredProcedure);
return(result);
}
public async Task <IEnumerable <CarProperties> > GetCarsByDNIAsync(DNIProperties dNIProperties)
{
var result = await _dbConnection.QueryAsync <CarProperties>("dbo.ISSP_GetCarsByDNI", dNIProperties, commandType : CommandType.StoredProcedure);
return(result);
}
public async Task <ActionResult <IEnumerable <InfractionDetails> > > GetInfractionsByDriverAsync(DNIProperties dni)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
return(Ok(await _infraction.GetInfractionsByDriverAsync(dni)));
}
catch (Exception ex)
{
throw ex;
}
}
