public ResTable GetTable(int noSeats, int restaurantId) { var db = new JustFeastDbDataContext(); ResTable resTable = null; resTable = db.ResTables.FirstOrDefault(t => t.noSeats == noSeats && t.restaurantId == restaurantId); return(resTable); }
private ResTable ConvertTable(Table table) { var returnTable = new ResTable(); returnTable.noSeats = Convert.ToInt32(table.NoSeats); returnTable.reserved = table.Reserved; returnTable.restaurantId = Convert.ToInt32(table.RestaurantId); return(returnTable); }
public void AddTable(ResTable resTable) { var db = new JustFeastDbDataContext(); if (db.ResTables.FirstOrDefault(t => (t.restaurantId == resTable.restaurantId)) != null) { db.ResTables.InsertOnSubmit(resTable); db.SubmitChanges(); } }
private void AddValuesToXlsRow(List <FieldBase> fields) { ResRow = ResTable.NewRow(); ResTable.Rows.Add(ResRow); foreach (FieldBase field in fields) //TODO добавить алгоритм разворота строк { string error = field.InitValue(); ResRow[ErrorFied] = ResRow[ErrorFied] + error; } }
private Table ConvertTableToModel(ResTable table) { var modelTable = new Table(); modelTable.TableId = table.id; modelTable.NoSeats = table.noSeats; modelTable.Reserved = table.reserved; modelTable.RestaurantId = table.restaurantId; return(modelTable); }
public void WriteResult(DataTable XlsTable) { onShowMessage?.Invoke("WriteResult"); onInitProgressBar?.Invoke(XlsTable.Rows.Count); foreach (DataRow row in XlsTable.Rows) { DataRow newRow = ResTable.NewRow(); SetValues(row); foreach (DataColumn column in ResTable.Columns) { if (column.ColumnName == "ROW_ID") { continue; } newRow[column.ColumnName] = GetValue(column.ColumnName); } ResTable.Rows.Add(newRow); onStepProgressBar?.Invoke(); } onHideProgressBar?.Invoke(); onShowMessage?.Invoke(""); }
public bool DeleteTable(ResTable resTable) { var db = new JustFeastDbDataContext(); ResTable tableRes = db.ResTables.First(t => t.noSeats == resTable.noSeats && t.restaurantId == resTable.restaurantId); var deleted = false; if (tableRes != null) { var enumTables = GetTablesWithReservedInTheFuture(resTable.restaurantId); foreach (var table in enumTables) { if (table.reserved && resTable.noSeats == table.noSeats) { using (var transaction = new TransactionScope()) { try { db.ResTables.DeleteOnSubmit(db.ResTables.First(t => t.id == table.id)); db.ReservedTables.DeleteOnSubmit(db.ReservedTables.First(t => t.tableId == table.id)); db.SubmitChanges(); transaction.Complete(); deleted = true; break; } catch (Exception ex) { deleted = false; } } } } } return(deleted); }
void StObjConstruct(ResTable resTable, Culture.Package culture) { _resTable = resTable; _culture = culture; }