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