public TablePlace UpdatedTable(int venueId, int tableId, TablePlace table) { try { var venue = _context.Venues.SingleOrDefault(v => v.Id == venueId); var tables = venue.Tables.ToList(); var tableForUpdate = tables.SingleOrDefault(t => t.Id == tableId); if (tableForUpdate == null) { return(null); } table.Id = tableId; tableForUpdate = table; venue.Tables = tables; _context.Set <Venue>().Update(venue); _context.SaveChanges(); return(tableForUpdate); } catch (Exception e) { return(null); } }
public TablePlace AddNewTable(TablePlace table, int venueId) { try { var venue = _context.Venues .SingleOrDefault(v => v.Id == venueId); var tables = venue.Tables.ToList(); tables.Add(table); venue.Tables = tables; _context.Set <Venue>().Update(venue); _context.SaveChanges(); return(table); } catch (Exception e) { return(null); } }