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