public static List <Code.Schedule.Event> toSchedules(this MySqlDataReader reader) { if (reader.HasRows) { List <Code.Schedule.Event> events = new List <Code.Schedule.Event>(); while (reader.Read()) { if (!reader.IsDBNull(0)) { Code.Schedule.Event e = new Code.Schedule.Event(); e.Id = reader.GetInt32(Define.schedule_id); try { e.Content = reader.GetString(Define.schedule_comment); } catch (Exception) { } try { e.playlist_id = reader.GetInt32(Define.schedule_playlist); } catch (Exception) { } e.parent_id = reader.GetInt32(Define.schedule_parent); e.device_id = reader.GetInt32(Define.schedule_device); e.user_id = reader.GetInt32(Define.schedule_user); e.status = reader.GetBoolean(Define.schedule_status); e.Begin = reader.GetDateTime(Define.schedule_time_begin); e.End = reader.GetDateTime(Define.schedule_time_end); e.loop = reader.GetBoolean(Define.schedule_loop); events.Add(e); } } return(events); } return(null); }
public static Code.Schedule.Event toSchedule(this MySqlDataReader reader) { if (reader.HasRows) { Code.Schedule.Event e = null; while (reader.Read()) { if (!reader.IsDBNull(0)) { e = new Code.Schedule.Event(); e.Id = reader.GetInt32(Define.schedule_id); try { e.Content = reader.GetString(Define.schedule_comment); } catch (Exception) { } try { e.playlist_id = reader.GetInt32(Define.schedule_playlist); } catch (Exception) { } e.parent_id = reader.GetInt32(Define.schedule_parent); e.device_id = reader.GetInt32(Define.schedule_device); e.user_id = reader.GetInt32(Define.schedule_user); e.status = reader.GetBoolean(Define.schedule_status); e.Begin = reader.GetDateTime(Define.schedule_time_begin); e.End = reader.GetDateTime(Define.schedule_time_end); e.loop = reader.GetBoolean(Define.schedule_loop); } } return e; } return null; }