public KitchenDispatchPageVM()
{
try
{
DisplayList = new ObservableCollection <KOTProd>(FilterOrderList());
SelectedTable = new TableDetail()
{
TableNo = "All"
};
PackedTableList = Helpers.Data.TableList.Where(x => x.IsPacked == true).ToList();
PackedTableList.Insert(0, new TableDetail()
{
TableNo = "All"
});
PackedTableList = new List <TableDetail>(PackedTableList);
ItemsList = new List <string>(DisplayList.Select(x => x.ItemDesc).Distinct().ToList());
ItemsList.Insert(0, "All");
IsDispatch = false;
IsLoading = false;
IsTable = true;
Remarks = "Order Dispatched";
CallCommand = new Command(ExecuteCallCommand);
DispatchCommand = new Command(ExecuteDispatchCommand);
SplitCommand = new Command(ExecuteSplitCommand);
BackCommand = new Command(ExecuteBackCommand);
RefreshCommand = new Command(ExecuteRefreshCommand);
}catch (Exception ex)
{
DependencyService.Get <IMessage>().ShortAlert(ex.Message);
}
}
public async void ExecuteRefreshCommand()
{
try
{
SelectedOrder = new KOTProd();
LoadingMessage = "Please Wait! Tables Loading...";
IsLoading = true;
var functionResponse = await TableDataAccess.GetTableAsync();
if (functionResponse.status == "ok")
{
var list = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString());
Helpers.Data.TableList = JsonConvert.DeserializeObject <List <TableDetail> >(functionResponse.result.ToString());
}
else
{
Helpers.Data.TableList = new List <TableDetail>();
IsLoading = false;
DependencyService.Get <IMessage>().ShortAlert(functionResponse.Message);
}
LoadingMessage = "Please Wait! Order Items Loading...";
IsLoading = true;
functionResponse = await TableDataAccess.GetAllKOTProdAsync(Helpers.Constants.User.UserName);
if (functionResponse.status == "ok")
{
IsLoading = false;
DependencyService.Get <IMessage>().ShortAlert("Order Items loaded successfully");
Helpers.Data.OrderItemsList = JsonConvert.DeserializeObject <List <KOTAppClassLibrary.Models.KOTProd> >(functionResponse.result.ToString());
IsTable = true;
SelectedTable = new TableDetail()
{
TableNo = "All"
};
PackedTableList = Helpers.Data.TableList.Where(x => x.IsPacked == true).ToList();
PackedTableList.Insert(0, new TableDetail()
{
TableNo = "All"
});
PackedTableList = new List <TableDetail>(PackedTableList);
DisplayList = new ObservableCollection <KOTProd>(FilterOrderList());
OrderItemsList = new ObservableCollection <KOTProd>(DisplayList);
ItemsList = new List <string>(DisplayList.Select(x => x.ItemDesc).Distinct().ToList());
ItemsList.Insert(0, "All");
}
else
{
IsLoading = false;
DependencyService.Get <IMessage>().ShortAlert("Error loading orders:" + functionResponse.Message);
}
}catch (Exception ex)
{
IsLoading = false;
DependencyService.Get <IMessage>().ShortAlert(ex.Message);
}
}
private ChangeTableEvent DataRowToChangeTableEvent(SqlDataReader reader, TableDetail changeTable)
{
long version;
if (!long.TryParse(reader.GetValue(reader.GetOrdinal("SYS_CHANGE_VERSION")).ToString(), out version))
{
throw new MissingFieldException(string.Format("Failed to parse ordinal SYS_CHANGE_VERSION as a long ({0})",
changeTable.TableName));
}
int primaryKeyIdOrdinal = -1;
try
{
primaryKeyIdOrdinal = reader.GetOrdinal(changeTable.PrimaryKeyName);
}
catch (IndexOutOfRangeException)
{
throw new MissingFieldException(string.Format("Failed to find ordinal (or empty) {0} (for table {1})",
changeTable.PrimaryKeyName,
changeTable.TableName));
}
var changedId = reader.GetValue(primaryKeyIdOrdinal).ToString();
var eventChar = reader["SYS_CHANGE_OPERATION"] as string;
if (string.IsNullOrEmpty(eventChar))
{
throw new MissingFieldException(
string.Format("Failed to find ordinal (or empty) SYS_CHANGE_OPERATION ({0})", changeTable.TableName));
}
EventType eventType = eventChar.Equals("D") ? EventType.Delete : EventType.Add;
return(new ChangeTableEvent(version, changedId, eventType));
}
public DataTable GetDataTable(string appSettingsConnectionStringName, TableDetail tableDetail)
{
if (!IsArgumentsValid(appSettingsConnectionStringName, tableDetail))
{
return(null);
}
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings[appSettingsConnectionStringName].ConnectionString))
{
cn.Open();
string query = "SELECT * FROM " + tableDetail.TableName
+ GetWhereClause(tableDetail.WhereClauseConditions, Constants.AppConfigFirstDatabaseConnectionStringName == appSettingsConnectionStringName);
using (SqlCommand command = new SqlCommand(query, cn))
{
DataTable dataTable = new DataTable();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
sqlDataAdapter.SelectCommand = command;
sqlDataAdapter.Fill(dataTable);
cn.Close();
return(dataTable);
}
}
}
public async Task <IActionResult> PutTableDetail([FromRoute] int id, [FromBody] TableDetail tableDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tableDetail.Iddetail)
{
return(BadRequest());
}
_context.Entry(tableDetail).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TableDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
// public List<TableDetail> GetListTableFull(){
// listTableFull = new List<TableDetail>();
// for(int i = 0; i < listTableDetail.Count; i++){
// if(listTableDetail[i].countPlaying >= maxPlayer || listTableDetail[i].countViewer >= maxViewer){
// listTableFull.Add(listTableDetail[i]);
// }
// }
// return listTableFull;
// }
public bool CanTableBeEnable(TableDetail _tableDetail)
{
if (_tableDetail.countViewer >= maxViewer ||
_tableDetail.isLockByPass)
{
return(false);
}
return(true);
}
public void InitData(ChooseTableScreenController _chooseTableScreen, TableDetail _tableDetail)
{
chooseTableScreen = _chooseTableScreen;
tableDetail = _tableDetail;
txt_TableId.text = string.Empty;
txt_Bet.text = string.Empty;
iconHavePassword.SetActive(false);
if (tableDetail == null)
{
panelLock.SetActive(true);
iconBet.SetActive(false);
panelTableId.SetActive(false);
canvasGroupListChairs.alpha = 0f;
}
else
{
if (tableDetail.isLockByPass)
{
iconHavePassword.SetActive(true);
}
panelLock.SetActive(false);
iconBet.SetActive(true);
panelTableId.SetActive(true);
txt_TableId.text = string.Format("{0:00}", tableDetail.tableId);
txt_Bet.text = MyConstant.GetMoneyString(tableDetail.bet, 9999);
canvasGroupListChairs.gameObject.SetActive(true);
canvasGroupListChairs.alpha = 1f;
int _numPlayerOnTable = tableDetail.countPlaying;
switch (DataManager.instance.miniGameData.currentMiniGameDetail.myInfo.gameType)
{
case IMiniGameInfo.Type.AnimalRacing:
_numPlayerOnTable = tableDetail.countViewer;
break;
}
Color _c = Color.white;
for (int i = 0; i < listChairHolder.Count; i++)
{
if (i < _numPlayerOnTable)
{
_c = listChairHolder[i].color;
_c.a = 1f;
listChairHolder[i].color = _c;
int _indexIcon = Random.Range(0, GameInformation.instance.otherInfo.listChooseTableIcon.Count);
listChairHolder[i].sprite = GameInformation.instance.otherInfo.listChooseTableIcon[_indexIcon];
}
else
{
_c = listChairHolder[i].color;
_c.a = 0f;
listChairHolder[i].color = _c;
}
}
}
}
public async Task <IActionResult> PostTableDetail([FromBody] TableDetail tableDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.TableDetail.Add(tableDetail);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTableDetail", new { id = tableDetail.Iddetail }, tableDetail));
}
private void BtnGo_OnClick(object sender, RoutedEventArgs e)
{
TableDetail tableDetail = LvTableList.SelectedItem as TableDetail;
if (tableDetail != null)
{
tableDetail.FirstDatabaseData = FirstDbDataProvider.GetDataTable(Constants.AppConfigFirstDatabaseConnectionStringName, tableDetail);
tableDetail.SecondDatabaseData = SecondDbDataProvider.GetDataTable(Constants.AppConfigSecondDatabaseConnectionStringName, tableDetail);
tableDetail.RowComparisonList = DataTableComparer.Compare(tableDetail, tableDetail.FirstDatabaseData, tableDetail.SecondDatabaseData);
}
}
protected bool IsArgumentsValid(string appSetttingsConnectionString, TableDetail tableDetail)
{
if (string.IsNullOrEmpty(appSetttingsConnectionString))
{
throw new ArgumentException("The application config connection string name cannot be null or empty");
}
if (tableDetail == null)
{
throw new ArgumentException("TableDetail cannot be null");
}
return(true);
}
public List <RowComparison> Compare(TableDetail tableDetail, DataTable firstDataTable, DataTable secondDataTable)
{
List <RowComparison> rowComparisonList = new List <RowComparison>();
if (firstDataTable != null)
{
int loopCount = 0;
foreach (DataRow firstDbDataRow in firstDataTable.Rows)
{
var firstDbPrimaryColumnValue = firstDbDataRow[tableDetail.PrimaryColumnName].ConvertToString();
RowComparison rowComparsion = new RowComparison();
rowComparsion.FirstDatabasePrimaryColumnValue = firstDbPrimaryColumnValue;
rowComparsion.FirstDbDataRow = firstDbDataRow;
DataRow secondDbDataRow = null;
if (secondDataTable != null)
{
// Check if same unique value exists in second db
secondDbDataRow = GetDataRow(firstDbDataRow, secondDataTable, tableDetail.CompareColumnList);
if (secondDbDataRow == null && loopCount < secondDataTable.Rows.Count)
{
secondDbDataRow = secondDataTable.Rows[loopCount];
}
if (secondDbDataRow != null)
{
rowComparsion.SecondDatabasePrimaryColumnValue = secondDbDataRow[tableDetail.PrimaryColumnName].ConvertToString();
}
List <string> uniqueValuesInSecondDb = new List <string>();
foreach (DataRow dataRow in secondDataTable.Rows)
{
uniqueValuesInSecondDb.Add(dataRow[tableDetail.PrimaryColumnName].ConvertToString());
}
rowComparsion.SecondDatabasePrimaryColumnValueList = uniqueValuesInSecondDb;
}
rowComparsion.ResultDataTable = Compare(GetAllColumns(firstDataTable, secondDataTable), firstDbDataRow, secondDbDataRow);
rowComparisonList.Add(rowComparsion);
loopCount++;
}
}
return(rowComparisonList);
}
public TransferSplitPageVM()
{
try
{
IsLoading = false;
IsSplit = false;
TransferType = "";
TransferItemsList = new ObservableCollection <KOTProd>();
TableStrList = new List <string>();
SelectedTableList = new TableDetail();
TransferCommand = new Command <KOTProd>(ExecuteTransferCommand);
CancelCommand = new Command(ExecuteCancelCommand);
BackCommand = new Command(ExecuteBackCommand);
SplitOkCommand = new Command(ExecuteSplitOkCommand);
SaveCommand = new Command(ExecuteSaveCommand);
OrderItemsList = new ObservableCollection <KOTProd>();
if (Helpers.Data.OrderItemsList != null)
{
foreach (var i in Helpers.Data.OrderItemsList)
{
var found = OrderItemsList.ToList().Find(x => x.MCODE == i.MCODE);
if (found != null)
{
found.Quantity += i.Quantity;
}
else
{
OrderItemsList.Add(i);
}
}
OrderItemsList.ForEach(x => x.TABLENO = Helpers.Data.SelectedTable.TableNo);
}
if (Helpers.Data.TableList != null)
{
foreach (var i in Helpers.Data.TableList)
{
TableStrList.Add(i.TableNo);
}
}
}
catch (Exception ex)
{
}
}
public DataTable GetDataTable(string appSettingsConnectionStringName, TableDetail tableDetail)
{
if (base.IsArgumentsValid(appSettingsConnectionStringName, tableDetail))
{
using (OleDbConnection oleDbConnection = new OleDbConnection(ConfigurationManager.ConnectionStrings[appSettingsConnectionStringName].ConnectionString))
{
// Open the connection
oleDbConnection.Open();
if (oleDbConnection.State == ConnectionState.Open)
{
string schemaQuery = "SELECT TOP 1 * FROM " + tableDetail.TableName;
OleDbCommand oleDbCommand = new OleDbCommand(schemaQuery, oleDbConnection);
OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter(oleDbCommand);
DataSet schemaDataTable = new DataSet();
oleDbDataAdapter.FillSchema(schemaDataTable, SchemaType.Source);
var newQuery = BuildQuery(schemaDataTable.Tables[0].Columns, tableDetail.TableName)
+ GetWhereClause(tableDetail.WhereClauseConditions, Constants.AppConfigFirstDatabaseConnectionStringName == appSettingsConnectionStringName);
// Dispose OleDbCommand and OleDbDataAdapter
oleDbCommand.Dispose();
oleDbDataAdapter.Dispose();
oleDbCommand = new OleDbCommand(newQuery, oleDbConnection);
oleDbDataAdapter = new OleDbDataAdapter(oleDbCommand);
DataTable dataTable = new DataTable();
oleDbDataAdapter.Fill(dataTable);
// Dispose OleDbCommand and OleDbDataAdapter
oleDbCommand.Dispose();
oleDbDataAdapter.Dispose();
// Close the connection
oleDbConnection.Close();
return(dataTable);
}
}
}
return(null);
}
public TransferTablePageVM()
{
IsLoading = false;
IsTransfer = false;
IsMerge = false;
TableList = Helpers.Data.TableList.Where(x => x.IsPacked == true).ToList();
EmptyTableList = Helpers.Data.TableList.Where(x => x.IsPacked == false).ToList();
AllTableList = new List <TableDetail>(Helpers.Data.TableList);
DivideTableView(TableList);
LoadingMessage = "";
TableBTCommand = new Command <string>(ExecuteTableBTCommand);
RefreshCommand = new Command(ExecuteRefreshCommand);
OkCommand = new Command <string>(ExecuteOkCommand);
CancelCommand = new Command(ExecuteBackCommand);
SelectedTransferFrom = new TableDetail();
SelectedTransferTo = new TableDetail();
}
private void Selector_OnSelectionChanged(object sender, SelectionChangedEventArgs e)
{
ComboBox comboBox = sender as ComboBox;
if (comboBox != null && comboBox.SelectedItem != null)
{
RowComparison rowComparison = comboBox.DataContext as RowComparison;
TableDetail tableDetail = LvTableList.SelectedItem as TableDetail;
if (rowComparison != null && tableDetail != null)
{
//var firstDbDataRow = DataTableComparer.GetDataRow(tableDetail.FirstDatabaseData, tableDetail.PrimaryColumnName, rowComparison.FirstDatabasePrimaryColumnValue);
var secondDbDataRow = DataTableComparer.GetDataRow(tableDetail.SecondDatabaseData, tableDetail.PrimaryColumnName, comboBox.SelectedItem.ToString());
if (secondDbDataRow != null)
{
DataTableComparer.Compare(tableDetail, rowComparison, rowComparison.FirstDbDataRow, secondDbDataRow);
}
}
}
}
public async void ExecuteTableBTCommand(string TableNo)
{
try
{
var res = await App.Current.MainPage.DisplayActionSheet("Select any options", "Cancel", "", "Merge", "Split", "Transfer");
SelectedTransferFrom.TableNo = TableNo;
if (res == "Transfer")
{
SelectedTransferTo = new TableDetail();
IsTransfer = true;
}
else if (res == "Split")
{
LoadingMessage = "Loading.. Please wait!!";
IsLoading = true;
Helpers.Data.SelectedTable = TableList.Find(x => x.TableNo == TableNo);
var functionResponse = await TableDataAccess.GetTableDetailsAsync(TableNo);
IsLoading = false;
if (functionResponse.status == "ok")
{
var result = JsonConvert.DeserializeObject <List <KOTProd> >(functionResponse.result.ToString());
Helpers.Data.OrderItemsList = result;
await App.Current.MainPage.Navigation.PushModalAsync(new TransferSplitPage());
}
else
{
DependencyService.Get <IMessage>().ShortAlert(functionResponse.Message);
}
}
else if (res == "Merge")
{
Helpers.Data.SelectedTable = SelectedTransferFrom;
await App.Current.MainPage.Navigation.PushModalAsync(new MergeTablePage());
}
}
catch (Exception ex)
{
DependencyService.Get <IMessage>().ShortAlert(ex.Message);
}
}
public void ViewTableItems(TableDetail tableDetail)
{
SelectedOrder = null;
_oldItem = null;
try
{
if (tableDetail.TableNo == "All")
{
OrderItemsList = new ObservableCollection <KOTProd>(DisplayList);
}
else
{
OrderItemsList = new ObservableCollection <KOTProd>(DisplayList.Where(x => x.TABLENO == tableDetail.TableNo));
}
OrderItemsList.ForEach(x => x.IsVisible = false);
}catch (Exception ex)
{
DependencyService.Get <IMessage>().ShortAlert(ex.Message);
}
}
// ==================================================================================
// table management
//management of table will goes here
//
public bool SaveTable(string tablename, int dbid, string websitename, string createdby, Guid userid)
{
TableDetail tbdetail = new TableDetail();
tbdetail.CreatedBy = createdby;
tbdetail.CreatedOn = DateTime.Now;
tbdetail.DatabaseId = dbid;
tbdetail.TableName = tablename;
tbdetail.UpdatedOn = DateTime.Now;
tbdetail.UserId = userid;
tbdetail.WebsiteName = websitename;
try
{
dbContext.TableDetails.InsertOnSubmit(tbdetail);
dbContext.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
void SetProcessPlayNow()
{
NetworkGlobal.instance.SetProcessRealTime(CMD_REALTIME.S_TABLE_PLAYNOW_TO_TABLE, (MessageReceiving _mess) => {
LoadingCanvasController.instance.Hide();
sbyte _result = _mess.readByte();
if (_result > 0)
{
NetworkGlobal.instance.instanceRealTime.PauseReceiveMessage();
TableDetail _tableDetail = new TableDetail();
_tableDetail.tableId = _mess.readShort();
DataManager.instance.miniGameData.currentMiniGameDetail.tableData.currentTableDetail = _tableDetail;
SetUserDataAgainFromServer(_mess);
ChangeSceneGamePlay();
}
else
{
SetDataWhenReceivingDataError(_result);
}
});
}
public void Compare(TableDetail tableDetail, RowComparison rowComparison, DataRow firsDbDataRow, DataRow secondDbDataRow)
{
var allColumnDictonary = GetAllColumns(tableDetail.FirstDatabaseData, tableDetail.SecondDatabaseData);
rowComparison.ResultDataTable = Compare(allColumnDictonary, firsDbDataRow, secondDbDataRow);
}
void OnFindTableClicked(string _id, string _pass)
{
SubServerDetail _serverDetail = DataManager.instance.miniGameData.currentMiniGameDetail.currentServerDetail;
if (_serverDetail == null)
{
#if TEST
Debug.LogError(">>> currentServerDetail is NULL");
#endif
return;
}
RoomDetail _roomDetail = null;
for (int i = 0; i < _serverDetail.listRoomDetail.Count; i++)
{
if (_serverDetail.listRoomDetail[i].gameId == DataManager.instance.miniGameData.currentMiniGameDetail.myInfo.gameId)
{
_roomDetail = _serverDetail.listRoomDetail[i];
break;
}
}
if (_roomDetail == null)
{
#if TEST
Debug.LogError("_roomDetail is null: " + DataManager.instance.miniGameData.currentMiniGameDetail.myInfo.gameType.ToString());
#endif
return;
}
if (_roomDetail.versionRoom > DataManager.instance.miniGameData.currentMiniGameDetail.myInfo.versionFeature)
{
#if TEST
Debug.Log("<color=green> RoomOutOfDate: " + DataManager.instance.miniGameData.currentMiniGameDetail.myInfo.versionFeature + " - " + _roomDetail.versionRoom + " </color>");
#endif
PopupManager.Instance.CreatePopupDialog(MyLocalize.GetString(MyLocalize.kWarning)
, MyLocalize.GetString("ChooseTable/RoomOutOfDate")
, string.Empty
, MyLocalize.GetString(MyLocalize.kUpdate)
, MyLocalize.GetString(MyLocalize.kCancel)
, () => {
//TODO : xử lý khi bấm nút update
Application.OpenURL(MyConstant.linkApp);
}, null);
return;
}
if (DataManager.instance.userData.databaseId == UserData.DatabaseType.DATABASEID_FACEBOOK &&
!FacebookAPI.IsLoggedIn())
{
#if TEST
Debug.LogError(">>> Chưa Login FB mà");
#endif
if (actionLoginFbAgain == null)
{
actionLoginFbAgain = FacebookAPI.DoActionLoginFb(null, () => {
actionLoginFbAgain = null;
});
StartCoroutine(actionLoginFbAgain);
}
return;
}
TableDetail _tableDetail = null;
for (int i = 0; i < DataManager.instance.miniGameData.currentMiniGameDetail.tableData.listTableDetail.Count; i++)
{
if (DataManager.instance.miniGameData.currentMiniGameDetail.tableData.listTableDetail[i].tableId == short.Parse(_id))
{
_tableDetail = DataManager.instance.miniGameData.currentMiniGameDetail.tableData.listTableDetail[i];
break;
}
}
if (_tableDetail != null)
{
DataManager.instance.miniGameData.currentMiniGameDetail.tableData.currentTableDetail = _tableDetail;
LoadingCanvasController.instance.Show(-1, false, null, () => {
NetworkGlobal.instance.StopRealTime();
});
SetProcessJoinToTable();
System.Action _onConnectionSuccess = () => {
GlobalRealTimeSendingAPI.SendMessageJoinToTable(DataManager.instance.miniGameData.currentMiniGameDetail.myInfo.gameId
, DataManager.instance.miniGameData.currentMiniGameDetail.tableData.currentTableDetail.tableId, _pass);
};
NetworkGlobal.instance.RunRealTime(_serverDetail, OnCreateConnectionError, _onConnectionSuccess, null, OnServerFull);
}
}
void SetUpTableData(bool _isGetAll, SubServerDetail _serverDetail, MessageReceiving _messageReceiving, int _error, System.Action _onSuccess = null, System.Action <int> _onError = null)
{
if (_messageReceiving != null)
{
bool _checkCase = _messageReceiving.readBoolean();
if (_checkCase)
{
long _versionRoom = _messageReceiving.readLong();
RoomDetail _roomDetail = null;
for (int i = 0; i < _serverDetail.listRoomDetail.Count; i++)
{
if (_serverDetail.listRoomDetail[i].gameId == DataManager.instance.miniGameData.currentMiniGameDetail.myInfo.gameId)
{
_roomDetail = _serverDetail.listRoomDetail[i];
break;
}
}
if (_roomDetail == null)
{
#if TEST
Debug.LogError("_roomDetail is null: " + DataManager.instance.miniGameData.currentMiniGameDetail.myInfo.gameType.ToString());
#endif
}
else
{
_roomDetail.versionRoom = _versionRoom;
}
// if(_roomDetail.myOriginalDetail != null){
// _roomDetail.myOriginalDetail.versionServer = _versionServer;
// }
TableData _tableData = new TableData();
string _gameNameRecieve = _messageReceiving.readString();
short _maxNumberTable = _messageReceiving.readShort();
_tableData.numberPlaying = _messageReceiving.readInt(); //số người đang chơi
_tableData.maxViewer = _messageReceiving.readByte();
_tableData.maxPlayer = _messageReceiving.readByte();
short _numberTableGet = _messageReceiving.readShort();
// GAMEID_UNO|59|0|8|4|20
// Debug.Log(_gameNameRecieve + "|" + _maxNumberTable + "|" + _tableData.numberPlaying + "|" + _tableData.maxViewer + "|" + _tableData.maxPlayer + "|" + _numberTableGet);
List <TableDetail> _listTableDetail = new List <TableDetail>();
for (int i = 0; i < _numberTableGet; i++)
{
TableDetail _tableDetail = new TableDetail();
_tableDetail.tableId = _messageReceiving.readShort();
_tableDetail.isLockByPass = _messageReceiving.readBoolean();
_tableDetail.status = _messageReceiving.readByte();
_tableDetail.bet = _messageReceiving.readLong();
_tableDetail.countViewer = _messageReceiving.readByte();
_tableDetail.countPlaying = _messageReceiving.readByte();
_listTableDetail.Add(_tableDetail);
}
if (DataManager.instance.miniGameData.currentMiniGameDetail.myInfo.versionFeature < _versionRoom)
{
_serverDetail.beingError = false;
if (currentState == State.Show)
{
if (_onError != null)
{
_onError(-98); // RoomOutOfDate
}
}
}
else
{
if (_isGetAll)
{
List <TableDetail> _tableDetailCollection = new List <TableDetail>();
for (int i = 0; i < _listTableDetail.Count; i++)
{
if (_tableData.CanTableBeEnable(_listTableDetail[i]))
{
_tableDetailCollection.Add(_listTableDetail[i]);
if (_tableDetailCollection.Count >= numTableDefault)
{
break;
}
}
}
_tableData.listTableDetail = _tableDetailCollection;
}
else
{
_tableData.listTableDetail = _listTableDetail;
}
DataManager.instance.miniGameData.currentMiniGameDetail.tableData = _tableData;
_serverDetail.beingError = false;
if (currentState == State.Show)
{
panelListTable.InitDataAgain();
if (_onSuccess != null)
{
_onSuccess();
}
}
}
}
else
{
#if TEST
Debug.LogError("Lỗi sever trả về rỗng");
#endif
_serverDetail.beingError = true;
_serverDetail.countConnectionError++;
if (currentState == State.Show)
{
if (_onError != null)
{
_onError(-99); // RoomIsNotAvailable
}
}
}
}
else
{
#if TEST
Debug.LogError("Room is not available");
#endif
_serverDetail.beingError = true;
_serverDetail.countConnectionError++;
if (currentState == State.Show)
{
if (_onError != null)
{
_onError(_error);
}
}
}
}
public KOTProdTabbedPageVM()
{
try
{
IsName = true;
IsLoading = false;
IsCancel = false;
IsPax = false;
IsRemarks = false;
SelectedOrderItem = new KOTProd();
if (Helpers.Data.SelectedTable.IsPacked == false)
{
IsPax = true;
}
PAX = Helpers.Data.PAX;
OrderCommand = new Command <M.MenuItem>(ExecuteOrderCommand);
CancelCommand = new Command <KOTProd>(ExecuteCancelCommand);
IncreaseOrderCommand = new Command <M.MenuItem>(ExecuteIncreaseCommand);
DecreaseMenuItemCommand = new Command <M.MenuItem>(ExecuteDecreaseMenuItemCommand);
DecreaseOrderCommand = new Command <KOTProd>(ExecuteDecreaseOrderCommand);
KOTCommand = new Command <string>(ExecuteKOTCommand);
SpecialItemCommand = new Command(ExecuteSpecialItemCommand);
BackCommand = new Command(ExecuteBackCommand);
IncCommand = new Command <KOTProd>(ExecuteIncCommand);
DecCommand = new Command <KOTProd>(ExecuteDecCommand);
RemarksOkCommand = new Command(ExecuteRemarksOkCommand);
LoginCheckCommand = new Command(ExecuteLoginCheckCommand);
TappedCommand = new Command <object>(ExecuteTappedCommand);
SelectedTable = new TableDetail();
OrderItemsList = new ObservableCollection <KOTProd>();
SelectedItemsList = new ObservableCollection <M.MenuItem>();
MenuItemsList = new List <M.MenuItem>();
MasterMenuList = new List <M.MenuItem>();
SubMenuList = new List <M.MenuItem>();
CancelingUser = new User();
if (Helpers.Data.SelectedTable != null)
{
SelectedTable = Helpers.Data.SelectedTable;
}
if (Helpers.Data.OrderItemsList != null)
{
var items = Helpers.Data.OrderItemsList;
OrderItemsList = new ObservableCollection <KOTProd>(Helpers.Data.OrderItemsList.OrderBy(x => x.SNO));
DecreaseItemCount();
}
if (Helpers.Data.MenuItemsList != null)
{
MenuItemsList = Helpers.Data.MenuItemsList;
MenuItemsList.ForEach(x => x.QUANTITY = 0);
MasterMenuList = new List <M.MenuItem>(Helpers.Data.MenuItemsList.Where(x => x.TYPE == "G").ToList());
SubMenuList = new List <M.MenuItem>(Helpers.Data.MenuItemsList.Where(x => x.TYPE == "A").ToList());
SubMenuList.ForEach(x => x.QUANTITY = 0);
SelectedItemsList = new ObservableCollection <M.MenuItem>(Helpers.Data.MenuItemsList.Where(x => x.TYPE == "A").ToList());
CountOrderQuantity();
}
MasterMenuList.ForEach(x => x.ItemCount = 0);
foreach (var item in SubMenuList)
{
var groupItem = MasterMenuList.Find(x => x.MCODE == item.PARENT);
if (groupItem != null)
{
groupItem.ItemCount += 1;
}
}
}
catch (Exception e)
{
DependencyService.Get <IMessage>().ShortAlert(e.Message);
}
}
public long GetLastChangeVersion(SqlDatabaseConnectorJobConfiguration config, TableDetail changeTableSettings)
{
using (var conn = new SqlConnection(config.ConnectionString))
using (var cmd = conn.CreateCommand())
{
cmd.CommandText =
string.Format(
"SELECT TOP ( 1 ) SYS_CHANGE_VERSION FROM CHANGETABLE (CHANGES {0}, 0) as CT ORDER BY SYS_CHANGE_VERSION desc",
changeTableSettings.TableName);
Log.Logger.Debug($"{config.JobName}: Getting the latest version number with: {cmd.CommandText}");
try
{
conn.Open();
var scalar = cmd.ExecuteScalar();
if (scalar != null)
{
return((long)scalar);
}
}
catch (SqlException e)
{
Log.Error(e, $"{config.JobName}: SQL error when executing {cmd.CommandText}");
throw;
}
}
return(0);
}
public DataChange(TableDetail table)
{
this.Table = table;
AddedIds = new List <string>();
DeletedIds = new List <string>();
}
public TableRowsCollection(Table owner, TableDetail detailDef, TableDetailInstanceList detailInstances)
{
this.m_owner = owner;
this.m_detailInstances = detailInstances;
this.m_detailDef = detailDef;
}
public void AddNewTableDetail(TableDetail _tableDetail)
{
listTableDetail.Add(_tableDetail);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!(IsPostBack))
{
var model = new AttributeMappingSource().GetModel(typeof(DataClassesDataContext));
List <TableDetail> tableDetails = new List <TableDetail>();
List <MetaTable> temp = model.GetTables().ToList();
for (int i = 0; i < temp.Count; i++)
{
string tableName = temp[i].TableName;
string prefix = tableName.Substring(0, 3);
string tableWithoutPrefix = tableName.Substring(4);
string tableNameInDB = "[" + prefix + "].[" + tableWithoutPrefix + "]";
using (Broker.LoggingDataAccess.LoggingDataContext dc = new LoggingDataContext())
{
TableDetail newDetail = new TableDetail();
newDetail.Name = tableWithoutPrefix;
newDetail.Index = i;
newDetail.Insert = true;
newDetail.Delete = true;
newDetail.Select = true;
newDetail.Update = true;
DBLoggingIgnoredTable tempIgnoredTable = dc.DBLoggingIgnoredTables.Where(c => c.TableName == tableWithoutPrefix).FirstOrDefault();
if (tempIgnoredTable != null)
{
int ignoredTableID = tempIgnoredTable.ID;
foreach (DBLoggingIgnoredTableActivity item in dc.DBLoggingIgnoredTableActivities.Where(c => c.DbLoggingIgnoredTableID == ignoredTableID).ToList())
{
switch (item.ActivityTypeID)
{
case 1:
{
newDetail.Insert = false;
break;
}
case 2:
{
newDetail.Delete = false;
break;
}
case 3:
{
newDetail.Select = false;
break;
}
case 4:
{
newDetail.Update = false;
break;
}
default:
break;
}
}
}
tableDetails.Add(newDetail);
}
}
gvTables.DataSource = tableDetails;
gvTables.DataBind();
}
}
private static DeclarationList CreateCurrentDeclarations()
{
DeclarationList declarationList = new DeclarationList();
int num = 1;
declarationList[num++] = IDOwner.GetDeclaration();
declarationList[num++] = ReportItem.GetDeclaration();
num++;
declarationList[num++] = Report.GetDeclaration();
declarationList[num++] = PageSection.GetDeclaration();
declarationList[num++] = Line.GetDeclaration();
declarationList[num++] = Rectangle.GetDeclaration();
declarationList[num++] = Image.GetDeclaration();
num++;
declarationList[num++] = CheckBox.GetDeclaration();
declarationList[num++] = TextBox.GetDeclaration();
declarationList[num++] = SubReport.GetDeclaration();
declarationList[num++] = ActiveXControl.GetDeclaration();
declarationList[num++] = DataRegion.GetDeclaration();
num++;
declarationList[num++] = ReportHierarchyNode.GetDeclaration();
declarationList[num++] = Grouping.GetDeclaration();
declarationList[num++] = Sorting.GetDeclaration();
declarationList[num++] = List.GetDeclaration();
declarationList[num++] = Pivot.GetDeclaration();
declarationList[num++] = Matrix.GetDeclaration();
declarationList[num++] = PivotHeading.GetDeclaration();
declarationList[num++] = MatrixHeading.GetDeclaration();
declarationList[num++] = MatrixColumn.GetDeclaration();
num++;
declarationList[num++] = MatrixRow.GetDeclaration();
num++;
declarationList[num++] = Subtotal.GetDeclaration();
declarationList[num++] = Table.GetDeclaration();
declarationList[num++] = TableColumn.GetDeclaration();
num++;
declarationList[num++] = TableGroup.GetDeclaration();
declarationList[num++] = TableRow.GetDeclaration();
num++;
declarationList[num++] = OWCChart.GetDeclaration();
declarationList[num++] = ChartColumn.GetDeclaration();
num++;
declarationList[num++] = ReportItemCollection.GetDeclaration();
declarationList[num++] = ReportItemIndexer.GetDeclaration();
num++;
declarationList[num++] = Style.GetDeclaration();
num++;
declarationList[num++] = AttributeInfo.GetDeclaration();
declarationList[num++] = Visibility.GetDeclaration();
declarationList[num++] = ExpressionInfo.GetDeclaration();
num++;
declarationList[num++] = DataAggregateInfo.GetDeclaration();
num++;
declarationList[num++] = RunningValueInfo.GetDeclaration();
num++;
num++;
declarationList[num++] = Filter.GetDeclaration();
num++;
declarationList[num++] = DataSource.GetDeclaration();
num++;
declarationList[num++] = DataSet.GetDeclaration();
num++;
declarationList[num++] = ReportQuery.GetDeclaration();
declarationList[num++] = Field.GetDeclaration();
num++;
declarationList[num++] = ParameterValue.GetDeclaration();
num++;
num++;
num++;
num++;
declarationList[num++] = ReportSnapshot.GetDeclaration();
declarationList[num++] = SenderInformation.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
declarationList[num++] = ReceiverInformation.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
declarationList[num++] = DocumentMapNode.GetDeclaration();
declarationList[num++] = InfoBase.GetDeclaration();
declarationList[num++] = OffsetInfo.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
declarationList[num++] = ReportItemInstanceInfo.GetDeclaration();
declarationList[num++] = ReportInstanceInfo.GetDeclaration();
declarationList[num++] = ReportItemColInstanceInfo.GetDeclaration();
declarationList[num++] = LineInstanceInfo.GetDeclaration();
declarationList[num++] = TextBoxInstanceInfo.GetDeclaration();
declarationList[num++] = RectangleInstanceInfo.GetDeclaration();
declarationList[num++] = CheckBoxInstanceInfo.GetDeclaration();
declarationList[num++] = ImageInstanceInfo.GetDeclaration();
declarationList[num++] = SubReportInstanceInfo.GetDeclaration();
declarationList[num++] = ActiveXControlInstanceInfo.GetDeclaration();
declarationList[num++] = ListInstanceInfo.GetDeclaration();
declarationList[num++] = ListContentInstanceInfo.GetDeclaration();
declarationList[num++] = MatrixInstanceInfo.GetDeclaration();
declarationList[num++] = MatrixHeadingInstanceInfo.GetDeclaration();
declarationList[num++] = MatrixCellInstanceInfo.GetDeclaration();
declarationList[num++] = TableInstanceInfo.GetDeclaration();
declarationList[num++] = TableGroupInstanceInfo.GetDeclaration();
declarationList[num++] = TableRowInstanceInfo.GetDeclaration();
declarationList[num++] = OWCChartInstanceInfo.GetDeclaration();
declarationList[num++] = ChartInstanceInfo.GetDeclaration();
declarationList[num++] = NonComputedUniqueNames.GetDeclaration();
declarationList[num++] = InstanceInfoOwner.GetDeclaration();
declarationList[num++] = ReportItemInstance.GetDeclaration();
num++;
declarationList[num++] = ReportInstance.GetDeclaration();
declarationList[num++] = ReportItemColInstance.GetDeclaration();
declarationList[num++] = LineInstance.GetDeclaration();
declarationList[num++] = TextBoxInstance.GetDeclaration();
declarationList[num++] = RectangleInstance.GetDeclaration();
declarationList[num++] = CheckBoxInstance.GetDeclaration();
declarationList[num++] = ImageInstance.GetDeclaration();
declarationList[num++] = SubReportInstance.GetDeclaration();
declarationList[num++] = ActiveXControlInstance.GetDeclaration();
declarationList[num++] = ListInstance.GetDeclaration();
declarationList[num++] = ListContentInstance.GetDeclaration();
num++;
declarationList[num++] = MatrixInstance.GetDeclaration();
declarationList[num++] = MatrixHeadingInstance.GetDeclaration();
num++;
declarationList[num++] = MatrixCellInstance.GetDeclaration();
num++;
num++;
declarationList[num++] = TableInstance.GetDeclaration();
declarationList[num++] = TableRowInstance.GetDeclaration();
declarationList[num++] = TableColumnInstance.GetDeclaration();
declarationList[num++] = TableGroupInstance.GetDeclaration();
num++;
declarationList[num++] = OWCChartInstance.GetDeclaration();
declarationList[num++] = ParameterInfo.GetDeclaration();
num++;
num++;
num++;
declarationList[num++] = InstanceInfo.GetDeclaration();
num++;
declarationList[num++] = RecordSetInfo.GetDeclaration();
declarationList[num++] = RecordRow.GetDeclaration();
declarationList[num++] = RecordField.GetDeclaration();
declarationList[num++] = ValidValue.GetDeclaration();
num++;
declarationList[num++] = ParameterDataSource.GetDeclaration();
declarationList[num++] = ParameterDef.GetDeclaration();
num++;
declarationList[num++] = ParameterBase.GetDeclaration();
num++;
declarationList[num++] = ProcessingMessage.GetDeclaration();
declarationList[num++] = MatrixSubtotalHeadingInstanceInfo.GetDeclaration();
declarationList[num++] = MatrixSubtotalCellInstance.GetDeclaration();
declarationList[num++] = CodeClass.GetDeclaration();
num++;
declarationList[num++] = TableDetail.GetDeclaration();
declarationList[num++] = TableDetailInstance.GetDeclaration();
num++;
declarationList[num++] = TableDetailInstanceInfo.GetDeclaration();
num++;
declarationList[num++] = Action.GetDeclaration();
declarationList[num++] = ActionInstance.GetDeclaration();
declarationList[num++] = Chart.GetDeclaration();
declarationList[num++] = ChartHeading.GetDeclaration();
declarationList[num++] = ChartDataPoint.GetDeclaration();
num++;
declarationList[num++] = MultiChart.GetDeclaration();
declarationList[num++] = MultiChartInstance.GetDeclaration();
num++;
declarationList[num++] = Axis.GetDeclaration();
declarationList[num++] = AxisInstance.GetDeclaration();
declarationList[num++] = ChartTitle.GetDeclaration();
declarationList[num++] = ChartTitleInstance.GetDeclaration();
declarationList[num++] = ThreeDProperties.GetDeclaration();
declarationList[num++] = PlotArea.GetDeclaration();
declarationList[num++] = Legend.GetDeclaration();
declarationList[num++] = GridLines.GetDeclaration();
declarationList[num++] = ChartDataLabel.GetDeclaration();
declarationList[num++] = ChartInstance.GetDeclaration();
declarationList[num++] = ChartHeadingInstance.GetDeclaration();
declarationList[num++] = ChartHeadingInstanceInfo.GetDeclaration();
num++;
declarationList[num++] = ChartDataPointInstance.GetDeclaration();
declarationList[num++] = ChartDataPointInstanceInfo.GetDeclaration();
num++;
num++;
declarationList[num++] = RenderingPagesRanges.GetDeclaration();
num++;
declarationList[num++] = IntermediateFormatVersion.GetDeclaration();
declarationList[num++] = ImageInfo.GetDeclaration();
declarationList[num++] = ActionItem.GetDeclaration();
declarationList[num++] = ActionItemInstance.GetDeclaration();
num++;
num++;
declarationList[num++] = DataValue.GetDeclaration();
declarationList[num++] = DataValueInstance.GetDeclaration();
num++;
num++;
declarationList[num++] = Tablix.GetDeclaration();
declarationList[num++] = TablixHeading.GetDeclaration();
declarationList[num++] = CustomReportItem.GetDeclaration();
declarationList[num++] = CustomReportItemInstance.GetDeclaration();
declarationList[num++] = CustomReportItemHeading.GetDeclaration();
declarationList[num++] = CustomReportItemHeadingInstance.GetDeclaration();
num++;
num++;
num++;
num++;
declarationList[num++] = CustomReportItemCellInstance.GetDeclaration();
num++;
num++;
declarationList[num++] = DataValueCRIList.GetDeclaration();
declarationList[num++] = BookmarkInformation.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
declarationList[num++] = DrillthroughInformation.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
num++;
declarationList[num++] = CustomReportItemInstanceInfo.GetDeclaration();
declarationList[num++] = ImageMapAreaInstanceList.GetDeclaration();
declarationList[num++] = ImageMapAreaInstance.GetDeclaration();
num++;
declarationList[num++] = InstanceInfo.GetDeclaration();
declarationList[num++] = SortFilterEventInfo.GetDeclaration();
declarationList[num++] = EndUserSort.GetDeclaration();
num++;
num++;
declarationList[num++] = RecordSetPropertyNames.GetDeclaration();
num++;
num++;
num++;
declarationList[num++] = PageSectionInstance.GetDeclaration();
num++;
declarationList[num++] = PageSectionInstanceInfo.GetDeclaration();
declarationList[num++] = SimpleTextBoxInstanceInfo.GetDeclaration();
declarationList[num++] = ScopeLookupTable.GetDeclaration();
num++;
declarationList[num++] = ReportDrillthroughInfo.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
Global.Tracer.Assert(declarationList.Count == num, "(current.Count == index)");
return(declarationList);
}
internal TableRowsCollection(Table owner, TableDetail detailDef, TableDetailInstanceList detailInstances)
{
m_owner = owner;
m_detailInstances = detailInstances;
m_detailDef = detailDef;
}
