/*================================================================================ * 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) { }