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