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