/*================================================================================
* GET DIA CALENDARIO
*================================================================================*/
public static DiaCalendarioBase GetDiaCalendario(int idConductor, DateTime fecha)
{
DiaCalendarioBase resultado = null;
using (OleDbConnection conexion = new OleDbConnection(App.Global.CadenaConexion))
{
string comandoSQL = "SELECT * FROM DiasCalendario WHERE IdCalendario IN (SELECT Id " +
"FROM Calendarios " +
"WHERE IdConductor = ?) " +
"AND DiaFecha = ?;";
// Elementos para la consulta de calendarios y días de calendario.
OleDbCommand comando = new OleDbCommand(comandoSQL, conexion);
comando.Parameters.AddWithValue("@IdConductor", idConductor);
comando.Parameters.AddWithValue("@Validez", fecha.ToString("yyyy-MM-dd"));
OleDbDataReader lector = null;
try {
conexion.Open();
lector = comando.ExecuteReader();
if (lector.Read())
{
resultado = new DiaCalendarioBase(lector);
}
} catch (OleDbException ex) {
Utils.VerError("BdDiasCalendarios.GetDiaCalendario", ex);
} finally {
lector.Close();
}
}
return(resultado);
}
public DiaPijama(DiaCalendarioBase dia) : base(dia)
{
}
