// Method verifies if table exists in DB
public static bool TableExists(string boardName)
{
if (BoardsDO.GetBoardsCount(boardName) == 0)
{
// if table doesn t exists - return false
return(false);
}
// if table already exists return true
return(true);
}
// Set bindings on objects
private void setDataBindings()
{
// Bing grid and list views to board data object
boardGridView.DataContext = BoardsDO.GetBoard(this.boardID);
// Bind columns to DO
firstColumn.DataContext = ColumnsDO.GetBoardColumns(this.boardID)[0];
secondColumn.DataContext = ColumnsDO.GetBoardColumns(this.boardID)[1];
thirdColumn.DataContext = ColumnsDO.GetBoardColumns(this.boardID)[2];
// Bind list views to taskDO
firstColumnView.ItemsSource = TaskDO.GetListOfTasks(ColumnsDO.GetColumnID(this.boardID, 1));
secondColumnView.ItemsSource = TaskDO.GetListOfTasks(ColumnsDO.GetColumnID(this.boardID, 2));
thirdColumnView.ItemsSource = TaskDO.GetListOfTasks(ColumnsDO.GetColumnID(this.boardID, 3));
}
private void loadBoardButton_Click(object sender, RoutedEventArgs e)
{
hideWarningLabels();
if (verifyBoardNameInput() == true)
{
// verify board is already loaded on the background
if (board != null)
{
// verify loaded boardID is same as searched one
if (BoardsDO.GetBoardID(kanbanBoardTextInput.Text) == boardID)
{
// if they are the same return loaded board
board.LoadBoard(boardID);
this.Close();
}
else
{
// Create Board Window
KanbanBoardWindow newBoardWindow =
new KanbanBoardWindow(BoardsDO.GetBoardID(kanbanBoardTextInput.Text));
board.Close();
this.Close();
// Show Kanban Board Window
newBoardWindow.Top = 100;
newBoardWindow.Left = 150;
newBoardWindow.Show();
}
}
// if board is not loaded on the background create new one
else
{
// Create Board Window
KanbanBoardWindow kanbanBoardWindow =
new KanbanBoardWindow(BoardsDO.GetBoardID(kanbanBoardTextInput.Text));
// Closes Create Board WIndow
this.Close();
// Show Kanban Board Window
kanbanBoardWindow.Top = 100;
kanbanBoardWindow.Left = 150;
kanbanBoardWindow.Show();
}
}
}
private void createBoardButton_Click(object sender, RoutedEventArgs e)
{
// Hide warning labels
hideBoardWarningLabels();
// If input is valid create new board and return create columns window
if (verifyBoardNameInput() == true)
{
myBoard.BoardName = kanbanBoardTextInput.Text;
BoardsDO.CreateBoard(kanbanBoardTextInput.Text);
// Hide panel for creating board
boardNamePanel.Visibility = Visibility.Hidden;
// Show panel for creating columns
columnsPanel.Visibility = Visibility.Visible;
fillDefaultColumns();
}
}
// Method creates columns in boards
private void createColumnsButton_Click(object sender, RoutedEventArgs e)
{
// Hide warning labels
hideColumnsWarningLabels();
// Verify input
if (verifyColumnsInput(getColumnNames()) == true)
{
ColumnsDO.CreateColumns(BoardsDO.GetBoardID(myBoard.BoardName), getColumnNames());
// Create Board Window
KanbanBoardWindow kanbanBoardWindow =
new KanbanBoardWindow(BoardsDO.GetBoardID(myBoard.BoardName));
// Closes Create Board WIndow
this.Close();
// Show Kanban Board Window
kanbanBoardWindow.Top = 100;
kanbanBoardWindow.Left = 150;
kanbanBoardWindow.Show();
}
;
}
