public List <WorkLog> List()
{
List <WorkLog> workLogs = new List <WorkLog>();
MySqlDataReader dataReader = mySQLConnector.GetData("SELECT * FROM work_log", null);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
int id = dataReader.IsDBNull(0) ? 0 : dataReader.GetInt16("id");
int user_id = dataReader.IsDBNull(1) ? 0 : dataReader.GetInt16("user_id");
int task_id = dataReader.IsDBNull(2) ? 0 : dataReader.GetInt16("task_id");
double work = dataReader.IsDBNull(3) ? 0.0 : dataReader.GetDouble("work");
DateTime created_at = (DateTime)dataReader.GetMySqlDateTime("created_at");
WorkLog workLog = new WorkLog(id, new UserDAO().Read(user_id), task_id, work, created_at);
workLogs.Add(workLog);
}
}
mySQLConnector.CloseConnections(dataReader);
return(workLogs);
}
public List <Section> List()
{
List <Section> sections = new List <Section>();
MySqlDataReader dataReader = mySQLConnector.GetData("SELECT * FROM sections", null);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
int id = dataReader.IsDBNull(0) ? 0 : dataReader.GetInt16("id");
int project_id = dataReader.IsDBNull(1) ? 0 : dataReader.GetInt16("project_id");
string name = dataReader.IsDBNull(2) ? "" : dataReader.GetString("name");
bool completed = dataReader.IsDBNull(3) ? false : dataReader.GetBoolean("completed");
DateTime due_date = (DateTime)dataReader.GetMySqlDateTime("due_date");
DateTime created_at = (DateTime)dataReader.GetMySqlDateTime("created_at");
//TODO: Get task list
Section section = new Section(id, project_id, name, completed, created_at, due_date, null);
sections.Add(section);
}
}
mySQLConnector.CloseConnections(dataReader);
return(sections);
}
public List <Project> List()
{
List <Project> projects = new List <Project>();
MySqlDataReader dataReader = mySQLConnector.GetData("SELECT * FROM projects", null);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
int id = dataReader.IsDBNull(0) ? 0 : dataReader.GetInt16("id");
int parent_project_id = dataReader.IsDBNull(1) ? 0 : dataReader.GetInt16("parent_project_id");
int user_id = dataReader.IsDBNull(2) ? 0 : dataReader.GetInt16("user_id");
string name = dataReader.IsDBNull(3) ? "" : dataReader.GetString("name");
string description = dataReader.IsDBNull(4) ? "" : dataReader.GetString("description");
bool completed = dataReader.IsDBNull(5) ? false : dataReader.GetBoolean("completed");
DateTime created_at = (DateTime)dataReader.GetMySqlDateTime("created_at");
DateTime due_date = (DateTime)dataReader.GetMySqlDateTime("due_date");
Project project = new Project(id, parent_project_id, user_id, name, description, completed, created_at, due_date);
projects.Add(project);
}
}
mySQLConnector.CloseConnections(dataReader);
return(projects);
}
public bool Create(User user)
{
Dictionary <string, string> parameters = new Dictionary <string, string>
{
{ "@email", user.Email }
};
MySqlDataReader dataReader = mySQLConnector.GetData("SELECT * FROM users WHERE email = @email", parameters);
if (dataReader.HasRows != true)
{
Dictionary <string, string> newUser = new Dictionary <string, string>
{
{ "@firstname", user.Firstname },
{ "@lastname", user.Lastname },
{ "@password", user.Password },
{ "@email", user.Email },
{ "@picture", user.Picture }
};
bool response = mySQLConnector.Execute("INSERT INTO users (firstname, lastname, password, email, picture) VALUES (@firstname, @lastname, @password, @email, @picture)", newUser);
if (response)
{
mySQLConnector.CloseConnections(dataReader);
return(true);
}
}
mySQLConnector.CloseConnections(dataReader);
return(false);
}
public List <Task> List()
{
List <Task> tasks = new List <Task>();
MySqlDataReader dataReader = mySQLConnector.GetData("SELECT * FROM tasks", null);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
int id = dataReader.IsDBNull(0) ? 0 : dataReader.GetInt16("id");
int parent_task_id = dataReader.IsDBNull(1) ? 0 : dataReader.GetInt16("parent_task_id");
int requires_task_id = dataReader.IsDBNull(2) ? 0 : dataReader.GetInt16("requires_task_id");
int section_id = dataReader.IsDBNull(3) ? 0 : dataReader.GetInt16("section_id");
int user_id = dataReader.IsDBNull(4) ? 0 : dataReader.GetInt16("user_id");
string name = dataReader.IsDBNull(5) ? "" : dataReader.GetString("name");
string description = dataReader.IsDBNull(6) ? "" : dataReader.GetString("description");
DateTime start_date = (DateTime)dataReader.GetMySqlDateTime("start_date");
DateTime due_date = (DateTime)dataReader.GetMySqlDateTime("due_date");
bool completed = dataReader.IsDBNull(9) ? false : dataReader.GetBoolean("completed");
Double estimated_time = dataReader.IsDBNull(9) ? 0.0 : dataReader.GetDouble("estimated_time");
int priority = dataReader.IsDBNull(10) ? 0 : dataReader.GetInt16("priority");
DateTime created_at = (DateTime)dataReader.GetMySqlDateTime("created_at");
Task parentTask = parent_task_id == 0 ? null : this.Read(parent_task_id);
Task requiredTask = requires_task_id == 0 ? null : this.Read(requires_task_id);
Task task = new Task(id, parentTask, requiredTask, new UserDAO().Read(user_id), section_id, name, description, estimated_time, priority, completed, start_date, due_date, created_at);
tasks.Add(task);
}
}
mySQLConnector.CloseConnections(dataReader);
return(tasks);
}
