public IEnumerable <TableListViewModel> GetListTable(string databaseName)
{
List <TableListViewModel> listData = new List <TableListViewModel>();
var query = $"SELECT * FROM {databaseName}.INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'";
SqlCommand command = new SqlCommand(query, ConnectDatabase.connect);
SqlDataReader r = command.ExecuteReader();
try
{
while (r.Read())
{
string tb_catalog = r["TABLE_CATALOG"].ToString();
string tb_name = r["TABLE_NAME"].ToString();
var model = new TableListViewModel
{
DatabaseName = tb_catalog,
TableName = tb_name
};
listData.Add(model);
}
r.Close();
return(listData);
}
catch (SqlException e)
{
return(null);
}
}
protected override void OnInitialization()
{
_regionManager.RegisterViewWithRegion(RegionNames.MainRegion, typeof(TableSelectorView));
PermissionRegistry.RegisterPermission(PermissionNames.OpenTables, PermissionCategories.Navigation, Resources.CanOpenTableList);
PermissionRegistry.RegisterPermission(PermissionNames.ChangeTable, PermissionCategories.Ticket, Resources.CanChangeTable);
EventServiceFactory.EventService.GetEvent<GenericEvent<Department>>().Subscribe(x =>
{
if (x.Topic == EventTopicNames.SelectTable)
{
ActivateTableView();
}
});
EventServiceFactory.EventService.GetEvent<GenericEvent<VisibleViewModelBase>>().Subscribe(
x =>
{
if (x.Topic == EventTopicNames.ViewClosed)
{
if (x.Value == _tableListViewModel)
_tableListViewModel = null;
if (x.Value == _tableScreenListViewModel)
_tableScreenListViewModel = null;
}
}
);
}
// GET: Table
public ActionResult Index()
{
TableListViewModel tableList = new TableListViewModel();
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
List <TableViewModel> myTablelist = new List <TableViewModel>();
int Max_Table = 0;
if (int.TryParse(guestBusinessLayer.GetMaxTable(), out Max_Table))
{
for (int i = 1; i <= Max_Table; i++)
{
TableViewModel table = new TableViewModel();
List <TableGuestViewModel> tableGuest = new List <TableGuestViewModel>();
decimal attendees = 0;
decimal local_percentage = 0;
table.TableNo = i.ToString();
List <Guest> guests = guestBusinessLayer.GetTableGuest(i.ToString());
if (guests.Count > 0)
{
foreach (Guest gs in guests)
{
TableGuestViewModel myGuest = new TableGuestViewModel();
myGuest.GuestId = gs.GuestId.ToString();
myGuest.Name = gs.Name;
myGuest.TableNo = gs.TableNo;
myGuest.Attendance = gs.Attendance;
if (myGuest.Attendance)
{
attendees++;
}
tableGuest.Add(myGuest);
}
local_percentage = (attendees / guests.Count) * 100;
table.Percentage = (int)Math.Floor(local_percentage);
table.TableGuest = tableGuest;
myTablelist.Add(table);
}
}
}
tableList.Total = guestBusinessLayer.GetTotalGuest();
tableList.Attended = guestBusinessLayer.GetAttendedGuest();
tableList.OverallPercentage = (int)Math.Floor(((decimal)tableList.Attended / tableList.Total) * 100);
tableList.Table = myTablelist;
return(View("TableView", tableList));
}
public ActionResult Tables(int page = 1)
{
TableListViewModel model = new TableListViewModel()
{
Tables = repository.Tables
.OrderBy(p => p.TableId)
.Skip((page - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = page,
ItemsPerPage = PageSize,
TotalItems = repository.Tables.Count()
}
};
return(View(model));
}
private void OnListTablesExecute(string obj)
{
if (_tableListViewModel == null)
_tableListViewModel = new TableListViewModel();
CommonEventPublisher.PublishViewAddedEvent(_tableListViewModel);
}
