public void StoreVerifiedCard(Guid player, object packinfo, int card_number, int win_mask, byte[, ,] card_face) { if (disable) { return; } //LoadEvents( game_event_dsn ); if (DsnSQLUtil.Compare(stream_state_cache.game_tracking_idColumn.DataType , stream_state_cache.Rows[0][stream_state_cache.game_tracking_idColumn] , NoSessionGame)) { return; } DataRow[] event_id = game_events.Select(game_events.event_nameColumn + "='winner found'"); { DataRow card_verified = game_event_log.NewRow(); card_verified[game_event_log.game_event_log_idColumn] = DsnConnection.GetGUID(game_event_dsn); card_verified[game_event_log.game_tracking_idColumn] = stream_state_cache.Rows[0][stream_state_cache.game_tracking_idColumn]; card_verified[game_event_log.game_event_idColumn] = event_id[0][game_events.game_event_idColumn]; card_verified[game_event_log.ballColumn] = 0; card_verified[game_event_log.game_event_timeColumn] = DateTime.Now; game_event_log.Rows.Add(card_verified); last_event = DateTime.Now; } }
public void UncallBall(object sender, BingoGameInterfaces.BingoEvents.BingoSimpleIntEventArgs e) { int ball = e.arg; if (disable) { return; } //LoadEvents( game_event_dsn ); if (DsnSQLUtil.Compare(stream_state_cache.game_tracking_idColumn.DataType , stream_state_cache.Rows[0][stream_state_cache.game_tracking_idColumn] , NoSessionGame)) { return; } DataRow[] event_id = game_events.Select(game_events.event_nameColumn + "='uncall'"); { DataRow call_event = game_event_log.NewRow(); call_event[game_event_log.game_event_log_idColumn] = DsnConnection.GetGUID(game_event_dsn); call_event[game_event_log.game_tracking_idColumn] = stream_state_cache.Rows[0][stream_state_cache.game_tracking_idColumn]; call_event[game_event_log.game_event_idColumn] = event_id[0][game_events.game_event_idColumn]; call_event[game_event_log.ballColumn] = ball; call_event[game_event_log.game_event_timeColumn] = DateTime.Now; game_event_log.Rows.Add(call_event); last_event = DateTime.Now; } }
public void CloseGame() { //LoadEvents( game_event_dsn ); if (DsnSQLUtil.Compare(stream_state_cache.game_tracking_idColumn.DataType , stream_state_cache.Rows[0][stream_state_cache.game_tracking_idColumn] , NoSessionGame)) { return; } DataRow[] event_id = game_events.Select(game_events.event_nameColumn + "='close'"); { DataRow close_event = game_event_log.NewRow(); close_event[game_event_log.game_event_log_idColumn] = DsnConnection.GetGUID(game_event_dsn); close_event[game_event_log.game_tracking_idColumn] = stream_state_cache.Rows[0][stream_state_cache.game_tracking_idColumn]; close_event[game_event_log.game_event_idColumn] = event_id[0][game_events.game_event_idColumn]; close_event[game_event_log.ballColumn] = 0; close_event[game_event_log.game_event_timeColumn] = DateTime.Now; game_event_log.Rows.Add(close_event); } stream_state_cache.Rows[0][stream_state_cache.game_tracking_idColumn] = NoSessionGame; last_event = DateTime.Now; }
public void CloseSession() { //LoadEvents( game_event_dsn ); if (DsnSQLUtil.Compare(stream_state_cache.session_tracking_idColumn.DataType , stream_state_cache.Rows[0][stream_state_cache.session_tracking_idColumn], NoSessionGame)) { return; } CloseGame(); DataRow[] event_id = session_events.Select(game_events.event_nameColumn + "='close'"); { DataRow close_event = session_event_log.NewRow(); close_event[session_event_log.session_event_log_idColumn] = DsnConnection.GetGUID(game_event_dsn); close_event[session_event_log.session_tracking_idColumn] = stream_state_cache.Rows[0][stream_state_cache.session_tracking_idColumn]; close_event[session_event_log.session_event_idColumn] = event_id[0][session_events.session_event_idColumn]; close_event[session_event_log.session_event_timeColumn] = DateTime.Now; session_event_log.Rows.Add(close_event); last_event = DateTime.Now; } stream_state_cache.Rows[0][stream_state_cache.session_tracking_idColumn] = NoSessionGame; DsnSQLUtil.CommitChanges(game_event_dsn, stream_state_cache); stream_state_cache.AcceptChanges(); }
//OptionMapDatasetTableAdapters.option2_mapTableAdapter map_adapter = new OptionMapDatasetTableAdapters.option2_mapTableAdapter(); public DataRow[] LoadMore(DsnConnection dsn, object uid) { DataRow[] rows; DsnSQLUtil.FillDataTable(dsn, map, map.parent_option_idColumn.ColumnName + "=" + DsnSQLUtil.GetSQLValue(dsn, map.option_idColumn, uid)); if (DsnSQLUtil.Compare(typeof(Guid), uid, Guid.Empty)) { rows = map.Select(map.option_idColumn.ColumnName + "='" + uid.ToString() + "'"); if (rows.Length == 0) { CreateOption(dsn, uid, uid, name.GetNameID(dsn, ".")); } rows = map.Select(map.parent_option_idColumn.ColumnName + "='" + uid.ToString() + "'and " + map.option_idColumn.ColumnName + "<>'" + uid.ToString() + "'"); } else { rows = map.Select(map.parent_option_idColumn.ColumnName + "='" + uid.ToString() + "'"); } return(rows); }
void ScheduleDesigner_FormClosing(object sender, FormClosingEventArgs e) { if (schedule.HasChanges()) { String pending_changes = ""; bool real_changes = false; DataSet ds = schedule.GetChanges(); StringBuilder detail = new StringBuilder(); foreach (DataTable table in ds.Tables) { foreach (Attribute attr in table.GetType().GetCustomAttributes(true)) { SchedulePersistantTable persist = attr as SchedulePersistantTable; if (null != persist) { if (table.Rows.Count > 0) { pending_changes += table.TableName + "(" + table.Rows.Count + ")\n"; detail.Append("Table "); detail.Append(table.TableName); detail.Append(" has "); detail.Append(table.Rows.Count.ToString()); detail.Append(" Changes...\n"); foreach (DataRow row in table.Rows) { bool added_row_header = false; bool first = true; if (row.RowState == DataRowState.Deleted) { detail.Append("Row " + table.Rows.IndexOf(row) + " : "); detail.Append("(deleted)\n"); real_changes = true; continue; } if (row.RowState == DataRowState.Added) { detail.Append("Row " + table.Rows.IndexOf(row) + " : "); detail.Append("(new)"); real_changes = true; } foreach (DataColumn col in table.Columns) { if (row.RowState == DataRowState.Added) { if (!added_row_header) { detail.Append("Row " + table.Rows.IndexOf(row) + " : "); added_row_header = true; } if (!first) { detail.Append(", "); } first = false; detail.Append(col.ColumnName + "=" + row[col].ToString()); continue; } object a; object b; if (!DsnSQLUtil.Compare(col.DataType, a = row[col, DataRowVersion.Original], b = row[col, DataRowVersion.Current])) { if (!added_row_header) { detail.Append("Row " + table.Rows.IndexOf(row) + " : "); added_row_header = true; } if (!first) { detail.Append(" and "); } first = false; detail.Append(col.ColumnName + "changed from [" + a.ToString() + "] to [" + b.ToString() + "]"); real_changes = true; } } if (added_row_header) { detail.Append("\n"); } } detail.Append("\n===============================================\n"); } } } } if (real_changes) { DialogResult r; if ((r = MessageBox.Show("There are unsaved changes to the schedule.\nDo you want to save now?\nCancel will show details." + pending_changes, "Unsaved Changes", MessageBoxButtons.YesNoCancel)) == System.Windows.Forms.DialogResult.Yes) { schedule.Commit(); } if (r == System.Windows.Forms.DialogResult.Cancel) { detail.Append("\nYes will save these changes, no will not commit."); if (ScrollableMessageBox.Show(detail.ToString(), "Unsaved Changes", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { schedule.Commit(); } } } } }