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; } }