| public static ToDateTime ( long time ) : System.DateTime | ||
| time | long | |
| return | System.DateTime | |
IEnumerable <ITaskCore> TaskListTaskCollectionRepo.GetAll(
ITaskListCore container)
{
var command =
"SELECT ID, Name, DueDate, CompletionDate, Priority, State " +
"FROM Tasks WHERE Category=@id;";
using (var cmd = new SqliteCommand(database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddIdParameter(container);
using (var dataReader = cmd.ExecuteReader()) {
while (dataReader.Read())
{
var id = dataReader.GetInt32(0).ToString();
var name = dataReader.GetString(1);
var state = (TaskState)dataReader.GetInt32(5);
var completionDate =
Database.ToDateTime(dataReader.GetInt64(3));
ITaskCore task;
if (state == TaskState.Active)
{
task = backend.Factory.CreateTask(id, name);
}
else if (state == TaskState.Completed)
{
task = backend.Factory.CreateCompletedTask(
id, name, completionDate);
}
else
{
task = backend.Factory.CreateDiscardedTask(
id, name);
}
task.Priority = (TaskPriority)dataReader.GetInt32(4);
task.DueDate =
Database.ToDateTime(dataReader.GetInt64(2));
yield return(task);
}
}
}
}
public DateTime GetDateTime(string command)
{
long longValue;
DateTime dtValue;
try{
longValue = GetSingleLong(command);
if (longValue == 0)
{
dtValue = DateTime.MinValue;
}
else
{
dtValue = Database.ToDateTime(longValue);
}
} catch (Exception e) {
Logger.Debug("Exception Thrown {0}", e);
dtValue = DateTime.MinValue;
}
return(dtValue);
}