public Task NextTaskToShow() { using (IConnection connection = new ConnectionCollector().GetConnection()) { string query = string.Format("select id, name, date_remainder, source_id from task where (showed is null " + "or showed = 0 or SHOWED = '') and (IS_DELETED = 0 or IS_DELETED is null)" + " order by date_remainder, id", DBTypesConverter.ToFullDateStringByCultureInfoWithQuotes(DateTime.Now.AddSeconds(-15))); IDataReader reader = connection.ExecuteReader(query); while (reader.Read()) { int id = reader.GetInt32(0); string name = reader.GetString(1); DateTime date = Convert.ToDateTime(reader.GetString(2), Static.StaticData.Settings.CultureData.CultureInfo); string sourceId = reader.GetString(3); return(new Task(id, name, date, sourceId)); } return(null); } }
public List <Task> LoadTasksForShowing() { using (IConnection con = new ConnectionCollector().GetConnection()) { string query = string.Format("SELECT ID, NAME, DATE_REMAINDER, SOURCE_ID, SHOWED from task where DATE_REMAINDER <= {0}" + "and (SHOWED = 0 or SHOWED is null or SHOWED = '') and (IS_DELETED = 0 or IS_DELETED is null " + "or IS_DELETED = '')", DBTypesConverter.ToFullDateStringByCultureInfoWithQuotes(DateTime.Now)); IDataReader reader = con.ExecuteReader(query); List <Task> tasks = new List <Task>(); while (reader.Read()) { int id = reader.GetInt32(0); string name = reader.GetString(1); DateTime date = Convert.ToDateTime(reader.GetString(2), Static.StaticData.Settings.CultureData.CultureInfo); string sourceId = reader.GetString(3); tasks.Add(new Task(id, name, date, sourceId)); } return(tasks); } }