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