public DataTable setReservas(ReservasDto dto)
{
using (con = new SqlConnection(dbContext.ObtenerCadenaDbConexSQL(_config["config:urlConex"])))
{
try
{
tblResult = new DataTable();
con.Open();
if (con.State == ConnectionState.Open)
{
SqlDataAdapter cmd = new SqlDataAdapter(STORE_PROCEDURES.SET_RESERVAS, con);
cmd.SelectCommand.CommandType = CommandType.StoredProcedure;
cmd.SelectCommand.Parameters.Add("@destino", SqlDbType.VarChar).Value = dto.ubicacion;
cmd.SelectCommand.Parameters.Add("@fechaIda", SqlDbType.Date).Value = dto.llegada;
cmd.SelectCommand.Parameters.Add("@fechaRegreso", SqlDbType.Date).Value = dto.salida;
cmd.SelectCommand.Parameters.Add("@pasajeros", SqlDbType.Int).Value = dto.pasajeros;
cmd.SelectCommand.Parameters.Add("@finalizado", SqlDbType.Bit).Value = false;
cmd.Fill(tblResult);
cmd.Dispose();
}
}
catch (SqlException ex)
{
con.Close();
throw new InvalidOperationException("TAG: " + ex.Message + ex.ErrorCode + ex.Data, ex.InnerException);
}
catch (Exception)
{
throw new Exception();
}
con.Close();
return(tblResult);
}
}
public ResultDto setReservas(ReservasDto dto) => _repository.setReservas(dto).AsResult();
public ResultDto setReservas([FromBody] ReservasDto dto)
{
return(_service.setReservas(dto));
}
