public Row UpsertRows(Row row, NewRowDBEntities db) { using (db) { if (row.RowId == default(int)) { row.RowClass = "row"; db.Rows.Add(row); } else { db.Entry(row).State = EntityState.Modified; } db.SaveChanges(); return(row); } }
public Row CreateRow(int?newPageId) { Row row = new Row(); NewRowDBEntities db = new NewRowDBEntities(); using (db) { if (row.RowId == default(int)) { row.RowClass = "row"; row.PageId = newPageId; db.Rows.Add(row); } else { db.Entry(row).State = EntityState.Modified; } db.SaveChanges(); return(row); } }
public List <Row> GetRowsByPageId(int pageId, NewRowDBEntities db) { List <Row> rowsByPageId = new List <Row>(); //Add all rows to new list foreach (var row in db.Rows) { rowsByPageId.Add(row); } // filter out list of rows foreach (var row in rowsByPageId.ToList()) { if (row.PageId != pageId) { rowsByPageId.Remove(row); } } return(rowsByPageId.OrderBy(x => x.Id).ToList()); }