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);
}
}
