public DALBoards GetUserDALBoards(string email) { try { connection.Open(); command = new SQLiteCommand(null, connection); command.CommandText = "SELECT boardName FROM " + BOARDSTABLE + " WHERE email= @email"; SQLiteParameter email_param = new SQLiteParameter(@"email", email); command.Parameters.Add(email_param); SQLiteDataReader reader = command.ExecuteReader(); DALBoards output = new DALBoards(email); string boardName; while (reader.Read()) { boardName = reader["boardName"].ToString(); output.AddBoard(boardName); InitializedBoardsColumns(email, boardName, output); } return(output); } catch (Exception ex) { Console.WriteLine("Error"); Console.WriteLine(ex.ToString()); } finally { connection.Close(); } return(null); }
private void InitializedBoardsColumns(string email, string boardName, DALBoards dalBoards) { SQLiteCommand c = new SQLiteCommand(null, connection); c.CommandText = "SELECT columnName FROM " + COLUMNSTABLE + " WHERE email= @email AND boardName= @boardName"; SQLiteParameter email_param = new SQLiteParameter(@"email", email); SQLiteParameter boardName_param = new SQLiteParameter(@"boardName", boardName); c.Parameters.Add(email_param); c.Parameters.Add(boardName_param); SQLiteDataReader reader = c.ExecuteReader(); string columnName; while (reader.Read()) { columnName = reader["columnName"].ToString(); dalBoards.GetBoards()[boardName].AddColumn(columnName); InitializedColumnsTasks(email, boardName, columnName, dalBoards); } }
private void InitializedColumnsTasks(string email, string boardName, string columnName, DALBoards dalBoards) { SQLiteCommand c = new SQLiteCommand(null, connection); c.CommandText = "SELECT creationTime,dueDate,title,description FROM " + TASKSTABLE + " WHERE email= @email AND boardName= @boardName AND columnName= @columnName"; SQLiteParameter email_param = new SQLiteParameter(@"email", email); SQLiteParameter boardName_param = new SQLiteParameter(@"boardName", boardName); SQLiteParameter columnName_param = new SQLiteParameter(@"columnName", columnName); c.Parameters.Add(email_param); c.Parameters.Add(boardName_param); c.Parameters.Add(columnName_param); SQLiteDataReader reader = c.ExecuteReader(); while (reader.Read()) { DALTask dalTask = new DALTask(reader["creationTime"].ToString(), reader["dueDate"].ToString(), reader["title"].ToString(), reader["description"].ToString()); dalBoards.GetBoards()[boardName].GetColumnByName(columnName).Add(dalTask); } }