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