public IActionResult UpdateTableInfo(int id)
{
var check = _context.Table.Where(q => q.TableId == id).AsNoTracking().FirstOrDefault();
TableVm tablevm = new TableVm()
{
TableId = id,
TableNumber = check.TableNumber,
TableCapacity = check.TableCapacity,
BookingPrice = check.BookingPrice
};
return(View(tablevm));
}
public ActionResult DeleteTable()
{
TableVm vm = new TableVm();
OleDbDataBaseReader reader = new OleDbDataBaseReader(DataBaseInfo.ConnectionString);
var tables = reader.GetTableNames();
var items = tables.Select(tableName => new SelectListItem {
Text = tableName, Value = tableName
}).ToArray();
vm.AvailableColumns.AddRange(items);
return(PartialView(vm));
}
public IActionResult UpdateTableInfo(TableVm tablevm)
{
Table table = new Table()
{
TableId = tablevm.TableId,
TableNumber = tablevm.TableNumber,
TableCapacity = tablevm.TableCapacity,
BookingPrice = tablevm.BookingPrice
};
_context.Table.Update(table);
_context.SaveChanges();
return(RedirectToAction("TableList"));
}
private void DealNewRandomHands()
{
Services.GameServices.SelectedHand = null;
Services.TableServices.RemoveAllHandsFromTable(TableVm.MainTable);
Services.TableServices.ClearCommunityCards(TableVm.MainTable);
Services.TableServices.PutHandsOnTable(TableVm.MainTable, new Random().Next(2, TableVm.MainTable.MaxHands + 1));
TableVm.OnPropertyChanged(nameof(TableVm.MainTable));
TableVm.RefreshHandViews();
TableVm.CommunityVM.RefreshImageSources();
MainTable.OnPropertyChanged(nameof(TableVm.MainTable.Hands));
MainTable.State = TableState.PreFlop;
MainTable.HasSelectedHands = false;
GetHandsInfo();
GameInfoText = "Select your hand on table.";
SetMainButton();
Services.GameServices.Bet = Services.GameServices.StartingBet;
}
public ActionResult DeleteTableConfirmed(TableVm vm)
{
if (ModelState.IsValid)
{
IHelper helper = new SqlServerHelper(DataBaseInfo);
var result = helper.DeleteTable(vm.TableName);
if (string.IsNullOrEmpty(result))
{
result = $"Таблица {vm.TableName} удалена успешно!";
}
TempData["StatusMessage"] = result;
return(RedirectToAction("Index", new { dbId = DbId }));
}
TempData["StatusMessage"] = "Были введены недопустимые данные.";
return(RedirectToAction("Index", new { dbId = DbId }));
}
public ActionResult Admin(int?id)
{
using (InsuranceEntities db = new InsuranceEntities())
{
var tables = db.Tables.Where(x => x.Id != null).ToList();
var tableVms = new List <TableVm>();
foreach (var x in tables)
{
var tableVm = new TableVm();
tableVm.FirstName = x.FirstName;
tableVm.LastName = x.LastName;
tableVm.EmailAddress = x.EmailAddress;
tableVm.Quote = x.Quote;
tableVms.Add(tableVm);
}
return(View(tableVms));
}
}
public IActionResult TableList(int Page = 1)
{
var tablelist = _context.Table.AsNoTracking().Where(s => s.TableId != 1).ToList();
var tablelistvm = new List <TableVm>();
int count = 1;
foreach (var item in tablelist)
{
TableVm tablevm = new TableVm()
{
Serial = count,
TableId = item.TableId,
TableNumber = item.TableNumber,
TableCapacity = item.TableCapacity,
BookingPrice = item.BookingPrice
};
count++;
tablelistvm.Add(tablevm);
}
var sent = tablelistvm.ToPagedList(Page, 5);
return(View(sent));
}
public IActionResult AddNewTable(TableVm tablevm)
{
var valid = _context.Table.AsNoTracking().
Where(t => t.TableNumber == tablevm.TableNumber).FirstOrDefault();
if (valid != null)
{
ViewBag.Validation = "You have already added " + tablevm.TableNumber + ".";
return(View());
}
Table table = new Table
{
TableNumber = tablevm.TableNumber,
TableCapacity = tablevm.TableCapacity,
BookingPrice = tablevm.BookingPrice
};
_context.Table.Add(table);
_context.SaveChanges();
ViewBag.Success = "You have succesfully added " + tablevm.TableNumber + ".";
ModelState.Clear();
return(View());
}
