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