public static List <Subtask> FetchAllSubtasks(SqlDataReader reader)
{
List <Subtask> Subtasks = new List <Subtask>();
while (reader.Read())
{
Subtask E = new Subtask();
E.ID = (int)reader["id"];
E.Name = reader["name"].ToString();
E.Description = reader["description"].ToString();
E.Status = (bool)reader["status"];
E.CreatedBy = Employee.FetchEmployeeByID((int)reader["created_by"]);
E.DateCreated = DateTime.Parse(reader["date_created"].ToString());
E.Deadline = DateTime.Parse(reader["deadline"].ToString());
E.LaboursRequired = (int)reader["labours_required"];
Subtasks.Add(E);
}
reader.Close();
reader.Dispose();
return(Subtasks);
}
public static Subtask FetchSubtaskByID(int ID)
{
List <SqlParameter> Param = new List <SqlParameter>();
Param.Add(new SqlParameter("@id", ID));
Subtask subtask = new Subtask();
using (SqlDataReader reader = (new Database()).ExecProcedureWithResult("usp_get_subtask_by_id", Param))
{
while (reader.Read())
{
subtask.ID = (int)reader["id"];
subtask.Name = reader["name"].ToString();
subtask.Description = reader["description"].ToString();
subtask.Status = (bool)reader["status"];
subtask.LaboursRequired = (int)reader["labours_required"];
subtask.CreatedBy = Employee.FetchEmployeeByID((int)reader["created_by"]);
subtask.AssignedTo = Employee.FetchEmployeeByID((int)reader["assigned_to"]);
subtask.DateCreated = DateTime.Parse(reader["date_created"].ToString());
subtask.Deadline = DateTime.Parse(reader["deadline"].ToString());
subtask.Assets = (reader["assets"].ToString() != "0,") ? Subtask.FetchAssetsArray(reader["assets"].ToString()) : new List <Asset>();
}
}
return(subtask);
}