/// <summary> /// Busca un horario dependiendo del dia seleccionado /// </summary> /// <param name="timeZone">dia a buscar</param> /// <returns>el horario completo dado un dia</returns> public TimeZones searchTimeZone(String timeZone) { TimeZones timeZoneSelected = new TimeZones(); String query = "SELECT * FROM timezones WHERE day=@day"; TimeZones zone; try { con = dbConnect.getConnection(); if (con != null) { con.Open(); using (MySqlCommand cmd = new MySqlCommand(query, con)) { cmd.Parameters.Add(new MySqlParameter("@day", timeZone)); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { timeZoneSelected = new TimeZones(int.Parse(reader.GetString(0)), Convert.ToDateTime(reader.GetString(1)).ToString("yyyy/MM/dd"), reader.GetString(2)); } } else { timeZoneSelected = null; } reader.Close(); } } } catch (MySqlException error1) { Console.WriteLine("Error MySql en el login d'UserDAO: " + error1.Message); } catch (Exception error2) { Console.WriteLine("Error general en el login - UserDAO: " + error2.Message); } return(timeZoneSelected); }
/// <summary> /// Carga todos los horarios de la tabla horarios /// </summary> /// <returns>lista con todos los horarios</returns> public List <TimeZones> loadAllTimeZones() { List <TimeZones> listWithTimeZones = new List <TimeZones>(); String query = "SELECT * FROM timezones"; TimeZones zone; try { con = dbConnect.getConnection(); if (con != null) { con.Open(); using (MySqlCommand cmd = new MySqlCommand(query, con)) { MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { zone = new TimeZones(int.Parse(reader.GetString(0)), Convert.ToDateTime(reader.GetString(1)).ToString("yyyy/MM/dd"), reader.GetString(2)); listWithTimeZones.Add(zone); } } else { listWithTimeZones = null; } reader.Close(); } } } catch (MySqlException error1) { Console.WriteLine("Error MySql en el login d'UserDAO: " + error1.Message); } catch (Exception error2) { Console.WriteLine("Error general en el login - UserDAO: " + error2.Message); } return(listWithTimeZones); }