//Get columns by VM list
public List <List <Column> > GetColumnVMLists(int rowId, NewColumnDBEntities2 db)
{
ColumnVmList columnVMList = new ColumnVmList();
List <Column> columnsByRowId = new List <Column>();
List <Column> listToFilter = new List <Column>();
//First add all columns to two arrays. columnsByRowId and Listtofilter
foreach (var column in db.Columns)
{
listToFilter.Add(column);
}
foreach (var column in listToFilter.ToList())
{
if (column.RowId == rowId)
{
columnsByRowId.Add(column);
listToFilter.Remove(column); //20 - 1 is removed
}
}
//when nothing is left to filter, the columns get added to the return list
List <List <Column> > columnVmList = new List <List <Column> >();
columnVmList.Add(columnsByRowId);
return(columnVmList);
}
//Upsert Columns
public Column UpsertColumns(Column column, NewColumnDBEntities2 db)
{
using (db)
{
if (column.ColumnId == default(int))
{
column.ColumnClass = "col-" + column.ColumnClass;
column.ColumnClassMobile = column.ColumnClass;
column.ColumnClassTablet = column.ColumnClass;
column.ColumnClassLaptop = column.ColumnClass;
db.Columns.Add(column);
}
else
{
column.ColumnClass = "col-" + column.ColumnClass;
column.ColumnClassMobile = "col-" + column.ColumnClassMobile;
column.ColumnClassTablet = "col-" + column.ColumnClassTablet;
column.ColumnClassLaptop = "col-" + column.ColumnClassLaptop;
db.Entry(column).State = EntityState.Modified;
}
db.SaveChanges();
return(column);
}
}
public Column CreateThreeSizeColumn(int newRowId)
{
Column column = new Column();
NewColumnDBEntities2 db = new NewColumnDBEntities2();
using (db)
{
if (column.ColumnId == default(int))
{
column.ColumnClass = "col-3";
column.ColumnClassMobile = "col-12";
column.ColumnClassLaptop = "col-3";
column.ColumnClassTablet = "col-3";
column.RowId = newRowId;
db.Columns.Add(column);
}
else
{
db.Entry(column).State = EntityState.Modified;
}
db.SaveChanges();
return(column);
}
}
//Get columns by row id
public List <Column> GetColumnsByRowId(int rowId, NewColumnDBEntities2 db)
{
List <Column> columnsByRowId = new List <Column>();
//Add all rows to new list
foreach (var column in db.Columns)
{
columnsByRowId.Add(column);
}
// filter out list of rows
foreach (var column in columnsByRowId.ToList())
{
if (column.RowId != rowId)
{
columnsByRowId.Remove(column);
}
}
return(columnsByRowId.OrderBy(x => x.Id).ToList());
}
