public static List <Task> GetAllTasks()
{
DAL.ConnectDb();
List <Task> data = new List <Task> ();
string query = "SELECT * FROM " + TableName;
SQLiteCommand command = new SQLiteCommand(query, DAL.Conn);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.HasRows)
{
while (reader.Read())
{
Task t = new Task();
t.Id = reader.GetInt32(0);
t.Owner = UserDAL.GetUserById(reader.GetInt32(1));
t.Title = reader.GetString(2);
t.Description = reader.GetString(3);
t.Status = (TaskStatus)reader.GetInt32(4);
t.StartDate = DateTime.Parse(reader.GetString(5));
t.EndDate = DateTime.Parse(reader.GetString(6));
t.IsPrivate = reader.GetBoolean(7);
t.Partners = PartnerDAL.GetAllPartners(t);
data.Add(t);
}
reader.NextResult();
}
return(data);
}
public static Task GetTaskById(int id)
{
DAL.ConnectDb();
Task t = new Task();
string query = "SELECT * FROM " + TableName + " WHERE Id = @TaskId";
SQLiteCommand command = new SQLiteCommand(query, DAL.Conn);
command.Parameters.AddWithValue("@TaskId", id);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
t.Id = Int32.Parse(reader["Id"].ToString());
t.Owner = UserDAL.GetUserById(Int32.Parse(reader["OwnerId"].ToString()));
t.Title = reader["Title"].ToString();
t.Description = reader["Description"].ToString();
t.Status = (TaskStatus)Int32.Parse(reader["Status"].ToString());
t.StartDate = DateTime.Parse(reader["StartDate"].ToString());
t.EndDate = DateTime.Parse(reader["EndDate"].ToString());
t.IsPrivate = Boolean.Parse(reader["IsPrivate"].ToString() == "1" ? "true" : "false");
t.Partners = PartnerDAL.GetAllPartners(t);
}
return(t);
}
