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