public List <Task> GetTasks()
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM tasks WHERE category_id = @CategoryId;", conn);
SqlParameter categoryIdParameter = new SqlParameter();
categoryIdParameter.ParameterName = "@CategoryId";
categoryIdParameter.Value = this.GetId();
cmd.Parameters.Add(categoryIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
List <Task> tasks = new List <Task> {
};
while (rdr.Read())
{
int taskId = rdr.GetInt32(0);
string taskDescription = rdr.GetString(1);
int taskCategoryId = rdr.GetInt32(2);
string taskDueDate = rdr.GetString(3);
Task newTask = new Task(taskDescription, taskCategoryId, taskDueDate, taskId);
tasks.Add(newTask);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return(tasks);
}
