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