// Method returns list of column names
public static List <string> GetBoardColumnNames(
int boardID)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
List <ColumnsDO> columns;
// Select that returns OrderID, OrderDate & EmployeesLastName
columns = context.kanban_columns
.Where(x => x.ID_BOARD == boardID)
.OrderBy(x => x.COLUMN_POS)
.Select(x => new ColumnsDO()
{
ColumnName = x.NAME,
ColumnPos = x.COLUMN_POS,
ColumnId = x.ID
})
.ToList();
List <string> columnNames = new List <string>();
foreach (ColumnsDO column in columns)
{
columnNames.Add(column.ColumnName);
}
return(columnNames);
}
}
// Method for getting task
public static TaskDO GetTask(int taskID)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
// select rows from db
return(context.kanban_task
.Where(x => x.ID_TASK == taskID)
.Join
(
context.kanban_columns
.Select(y => new
{
ColumnID = y.ID,
ColumnPos = y.COLUMN_POS
}),
task => task.ID_COLUMN,
col => col.ColumnID,
(task, col) => new { Task = task, Column = col })
.Select(x => new TaskDO()
{
TaskName = x.Task.TASK_NAME,
TaskDesc = x.Task.TASK_DESCRIPTION,
TaskId = x.Task.ID_TASK,
ColumnId = x.Task.ID_COLUMN,
ColumnPos = x.Column.ColumnPos
}).First());
}
}
// Method for getting boards ID
public static int GetBoardID(string boardName)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
// select row from db
kanban_board board = context.kanban_board.First(x => x.BOARD_NAME == boardName);
int boardID = board.ID;
// return board ID
return(boardID);
}
}
// Method returnt Column ID
public static int GetColumnID(int boardID, int colPos)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
// select row from db
kanban_columns column = context.kanban_columns.First(x => (x.ID_BOARD == boardID) && (x.COLUMN_POS == colPos));
int columnID = column.ID;
// return column ID
return(columnID);
}
}
// Method for creating new Board in DB
public static void CreateBoard(string boardName)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
// Create new entity
kanban_board newBoard = new kanban_board();
newBoard.BOARD_NAME = boardName;
// Add entity into the table and save changes
context.kanban_board.Add(newBoard);
context.SaveChanges();
}
}
// Method for getting count of boards with boardName in DB
public static int GetBoardsCount(string boardName)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
// Returns count of searched Board Names
return(context.kanban_board
.Where(x => x.BOARD_NAME == boardName)
.Select(x => new BoardsDO()
{
BoardName = x.BOARD_NAME
}).Count());
}
}
// Method for getting boards ID
public static List <BoardsDO> GetBoard(int boardID)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
// select row from db
return(context.kanban_board
.Where(x => x.ID == boardID)
.Select(x => new BoardsDO()
{
BoardName = x.BOARD_NAME,
BoardID = x.ID
}).ToList());
}
}
// Method for creating task in DB
public static void UpdateTask(int taskID, int columnID, string taskName, string taskDesc)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
// Create new entity
kanban_task task = context.kanban_task.First(x => x.ID_TASK == taskID);
task.ID_COLUMN = columnID;
task.TASK_NAME = taskName;
task.TASK_DESCRIPTION = taskDesc;
// Add entity into the table and save changes
context.SaveChanges();
}
}
// Method for creating task in DB
public static void CreateTask(int columnID, string taskName, string taskDesc)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
// Create new entity
kanban_task newTask = new kanban_task();
newTask.ID_COLUMN = columnID;
newTask.TASK_NAME = taskName;
newTask.TASK_DESCRIPTION = taskDesc;
// Add entity into the table and save changes
context.kanban_task.Add(newTask);
context.SaveChanges();
}
}
// Method returns list of tasks for certain column
public static List <TaskDO> GetListOfTasks(int columnID)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
// select rows from db
return(context.kanban_task
.Where(x => x.ID_COLUMN == columnID)
.Select(x => new TaskDO()
{
TaskName = x.TASK_NAME,
TaskDesc = x.TASK_DESCRIPTION,
TaskId = x.ID_TASK,
ColumnId = x.ID_COLUMN
}).ToList());
}
}
// Method returns list of columns
public static List <ColumnsDO> GetBoardColumns(
int boardID)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
return(context.kanban_columns
.Where(x => x.ID_BOARD == boardID)
.OrderBy(x => x.COLUMN_POS)
.Select(x => new ColumnsDO()
{
ColumnName = x.NAME,
ColumnPos = x.COLUMN_POS,
ColumnId = x.ID
})
.ToList());
}
}
// Method for creating Columns in DB
public static void CreateColumns(int boardID, List <string> columnList)
{
// Create new connection
using (QKOLA01_VSE_DBEntities context =
new QKOLA01_VSE_DBEntities())
{
int columnPos = 0;
foreach (string column in columnList)
{
columnPos++;
// Create new entity
kanban_columns newColumn = new kanban_columns();
newColumn.ID_BOARD = boardID;
newColumn.NAME = column;
newColumn.COLUMN_POS = columnPos;
// Add entity into the table and save changes
context.kanban_columns.Add(newColumn);
context.SaveChanges();
}
}
}
