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