public static List <Horarios> BuscarHorarios(string dias, string hora) { List <Horarios> List = new List <Horarios>(); using (SqlConnection conexion = DBcomun.ObetenerConexion()) { SqlCommand comando = new SqlCommand(string.Format("Select * from Horarios where Hora like '{0}%' and Dias like '{1}%'", hora, dias), conexion); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { Horarios pH = new Horarios(); pH.ID = reader.GetInt32(0); pH.Hora = reader.GetString(1); pH.Dias = reader.GetString(2); List.Add(pH); } conexion.Close(); } return(List); }
public static List <Horarios> TodosLosHorarios() { List <Horarios> List = new List <Horarios>(); using (SqlConnection conexion = DBcomun.ObetenerConexion()) { SqlCommand comando = new SqlCommand(string.Format("Select * from Horarios"), conexion); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { Horarios pH = new Horarios(); pH.ID = reader.GetInt32(0); pH.Hora = reader.GetString(1); pH.Dias = reader.GetString(2); List.Add(pH); } conexion.Close(); } return(List); }