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