static SessionManagementState() { open_issue_buttons = new List <PSI_Button>(); open_play_buttons = new List <PSI_Button>(); open_sales_buttons = new List <PSI_Button>(); close_issue_buttons = new List <PSI_Button>(); close_sales_buttons = new List <PSI_Button>(); close_play_buttons = new List <PSI_Button>(); schedule = new ScheduleDataSet(StaticDsnConnection.dsn); schedule_currents = new ScheduleCurrents(schedule); schedule.Create(); schedule.Fill(); session_state = new SessionStateDataset(); DsnSQLUtil.MatchCreate(StaticDsnConnection.dsn, session_state); session_state.Fill(StaticDsnConnection.dsn); //DsnSQLUtil.FillDataSet( StaticDsnConnection.dsn, session_state, ); active_sessions = new DataView(session_state.session_day_sessions , "active_flag<>0" + " or open_for_sales_flag<>0" + " or open_for_issue_flag<>0" + " or open_for_play_flag<>0" , "bingoday,session_order", DataViewRowState.CurrentRows); if (active_sessions.Count > 0) { SessionManagementState.current_session = active_sessions[0].Row; } }
public void Load(DsnConnection dsn, ScheduleDataSet schedule, DateTime bingoday, int session, List <int> use_groups) { MySQLDataTable win_table = new MySQLDataTable(dsn , "select * from prize_validations where bingoday=" + DsnSQLUtil.MakeDateOnly(dsn, bingoday) + " and session_id=" + session ); if (win_table.Rows.Count == 0) { Log.log("No prizes for this session today."); // return; } { foreach (DataRow row in win_table.Rows) { Log.log("win record " + " Game:" + row["game_id"] + " card:" + row["card"].ToString() + " ball:" + row["ball_list"] + " unit:" + row["unit"]); } } this.use_groups = use_groups; this.schedule = schedule; if (this.schedule == null) { this.schedule = new ScheduleDataSet(dsn); } MessageBox.Show("Failed to update this method."); //ReloadSessionGames( schedule.GetSession( bingoday, 1 ) ); }
private void buttonCreateSchedule2_Click(object sender, EventArgs e) { labelStatus2.Text = "Creating schedule 2..."; schedule2 = new ScheduleDataSet(new DsnConnection(textBoxDsn2.Text)); schedule2.Create(); labelStatus2.Text = "Created schedule 2..."; }
void SessionPriceExceptionSet_TableNewRow(object sender, DataTableNewRowEventArgs e) { if (filling) { return; } if ((DataSet.Tables[SessionTable.TableName] as IXDataTable).filling) { return; } ScheduleDataSet schedule = this.DataSet as ScheduleDataSet; // received when session table gets a new row // so every session gets a 'default' price exception set. if (schedule != null) { if (default_price_exception == null) { schedule.price_exception_sets.DefaultFill(); DataRow[] default_exception = schedule.price_exception_sets.Select(PriceExceptionSet.NameColumn + "='Default'"); if (default_exception.Length > 0) { default_price_exception = default_exception[0]; } } schedule.session_price_exception_sets.AddGroupMember(e.Row, default_price_exception); } }
public SessionDayMacroSessionTable(ScheduleDataSet dataset) : base(dataset) { Columns.Add(NameColumn, typeof(String)); Columns.Add(PrizeExceptionSet.PrimaryKey, XDataTable.DefaultAutoKeyType); Columns.Add(PriceExceptionSet.PrimaryKey, XDataTable.DefaultAutoKeyType); Columns.Add(SessionTypeTable.PrimaryKey, XDataTable.DefaultAutoKeyType); if (!dataset.Tables.Contains((this as DataTable).TableName)) { dataset.Tables.Add(this); } dataset.Relations.Add(prize_relation = "session_macro_prize_exceception" , dataset.Tables[PrizeExceptionSet.TableName].Columns[PrizeExceptionSet.PrimaryKey] , this.Columns[PrizeExceptionSet.PrimaryKey] ); dataset.Relations.Add(price_relation = "session_macro_price_exceception" , dataset.Tables[PriceExceptionSet.TableName].Columns[PriceExceptionSet.PrimaryKey] , this.Columns[PriceExceptionSet.PrimaryKey] ); dataset.Relations.Add(session_type_relation = "session_macro_session_type" , dataset.Tables[SessionTypeTable.TableName].Columns[SessionTypeTable.PrimaryKey] , this.Columns[SessionTypeTable.PrimaryKey] ); }
public Patterns(ScheduleDataSet schedule) { this.pattern_info = schedule.patterns; this.pattern_data = schedule.pattern_data; this.pattern_sub_pattern = schedule.pattern_sub_pattern; this.pattern_java_server = schedule.pattern_java_server; }
public RatedGameConfigurator(ScheduleDataSet schedule) { this.schedule = schedule; game_config = new GameConfiguration(schedule); DsnSQLUtil.CreateDataTable(schedule.schedule_dsn, game_config); InitializeComponent(); }
public CurrentCardsetRanges(DataSet dataSet) { schedule = dataSet as ScheduleDataSet; base.Prefix = Names.schedule_prefix; base.TableName = TableName; Columns.Add(DisplayName, typeof(string)); Columns.Add("Start", typeof(int)); Columns.Add("End", typeof(int)); Columns.Add("Base", typeof(int)); Columns.Add("Offset", typeof(int)); Columns.Add("Double Action", typeof(bool)); Columns.Add("Electronic", typeof(bool)); Columns.Add("Barcode Paper", typeof(bool)); Columns.Add("multi level payout", typeof(bool)); Columns.Add("Sales Database", typeof(string)).MaxLength = 64; DataColumn range_bind = Columns.Add(CardsetRange.PrimaryKey, XDataTable.DefaultAutoKeyType); Columns.Add(Dealer.PrimaryKey, XDataTable.DefaultAutoKeyType); Columns.Add(PrizeLevelNames.PrimaryKey, XDataTable.DefaultAutoKeyType); if (dataSet.Tables.Contains(this.ToString()) == false) { dataSet.Tables.Add(this); dataSet.Relations.Add(new DataRelation(CardsetRange.TableName , dataSet.Tables[CardsetRange.TableName].Columns[CardsetRange.PrimaryKey] , range_bind)); //dataSet.Relations.Add( new DataRelation( CardsetRange.TableName // , dataSet.Tables[CardsetRange.TableName].Columns[CardsetRange.PrimaryKey] // , range_bind ) ); } }
static void MonitorSalesSession() { while (true) { DbDataReader reader = session_sales_monitor_dsn.KindExecuteReader( "SELECT session_order,bingoday FROM session_day_sessions where open_for_sales_flag=1" ); // DbDataReader reader = session_sales_monitor_dsn.KindExecuteReader( "SELECT session_number,bingoday FROM operational_configuration" //+ " join session_day_sessions" //+ " on current_session_day_sessions_id=session_day_sessions.ID " ); if (reader != null && reader.HasRows) { int new_session; DateTime new_bingoday; reader.Read(); new_session = reader.GetInt32(0); new_bingoday = reader.GetDateTime(1); if (new_session != session_number || new_bingoday != bingoday) { session_number = new_session; bingoday = new_bingoday; schedule = new ScheduleDataSet(session_sales_monitor_dsn, bingoday, session_number); bingo_session = new BingoGameCore4.BingoSession(schedule.sessions.Rows[0]); session_event = new BingoGameCore4.BingoSessionEvent(bingo_session, true); session_event.ball_data = ball_device; } } session_sales_monitor_dsn.EndReader(reader); Thread.Sleep(2000); } }
public RankPointsExtended(OpenSkieScheduler3.ScheduleDataSet schedule) { base.TableName = TableName; this.schedule = schedule; connection = schedule.schedule_dsn; AddColumns(true); }
public GameConfiguration(ScheduleDataSet schedule) { this.connection = schedule.schedule_dsn; base.TableName = TableName; //AddDefaultColumns( true, true, false ); this.Columns.Add(SessionGame.PrimaryKey, typeof(int)); this.Columns.Add("rate", typeof(bool)); }
public override global::System.Data.DataSet Clone() { ScheduleDataSet cln = ((ScheduleDataSet)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
/// <summary> /// This row passed is a session_game row /// </summary> /// <param name="game"></param> /// <returns></returns> public DataRow[] GetPatterns(DataRow session_game) { if (session_game.Table.TableName == SessionGame.TableName) { ScheduleDataSet schedule = session_game.Table.DataSet as ScheduleDataSet; return(session_game.GetChildRows(schedule.game_patterns.ChildrenOfParent)); } return(null); }
public CurrentSessionGamePackPrize(DataSet set) : base(set, SessionPrizeTable.TableName, true) { schedule = set as ScheduleDataSet; Columns.Add(new DataColumn(PrizeLevelNames.PrimaryKey, typeof(int))); Columns.Add(new DataColumn(GameTable.PrimaryKey, typeof(int))); Columns.Add(new DataColumn("Prize", typeof(Money))); source_table = set.Tables[SessionPrizeTable.TableName] as XDataTable <DataRow>; }
public SessionMacroTable(ScheduleDataSet dataSet) : base(Names.schedule_prefix, SessionMacroTable.TableName) { AddColumns(); if (!dataSet.Tables.Contains((this as DataTable).TableName)) { dataSet.Tables.Add(this); } }
public Form1() { //OpenSkieSchedule.PacksRelateToPrizes = true; //OpenSkieSchedule.UseGuid = true; schedule = new ScheduleDataSet(StaticDsnConnection.dsn); schedule.Create(); schedule.Fill(); InitializeComponent(); }
private void button7_Click_1(object sender, EventArgs e) { ScheduleDataSet schedule = new ScheduleDataSet(); schedule.schedule_dsn = StaticDsnConnection.dsn; DataRow session = schedule.GetSession(new DateTime(2013, 4, 1), 1); schedule.Fill(session); schedule.WriteXML("testload.xml"); }
private void buttonCreateSchedule2_Click(object sender, EventArgs e) { labelStatus2.Text = "Creating schedule 2..."; OpenSkieSchedule.UseGuid = checkBoxUseGuid2.Checked; OpenSkieSchedule.PacksRelateToPrizes = checkBoxPackToPrizes2.Checked; OpenSkieSchedule.GamesRelateToSessions = checkBoxGameToSessions2.Checked; schedule2 = new ScheduleDataSet(new DsnConnection(textBoxDsn2.Text)); schedule2.Create(); labelStatus2.Text = "Created schedule 2..."; }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { ScheduleDataSet ds = new ScheduleDataSet(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
public DataRow[] LoadPatternData(DataRow dataRow) { if (dataRow == null) { ScheduleDataSet dataset = this.DataSet as ScheduleDataSet; if (dataset != null) { return(DsnSQLUtil.FillDataTable(dataset.schedule_dsn, dataset.pattern_data).ToArray()); } return(null); } else { int mode; if (!Int32.TryParse(dataRow["real_mode"].ToString(), out mode)) { mode = 0; } if (mode == (int)match_types.Normal || mode == (int)match_types.NonOverlayable || mode == (int)match_types.TwoGroups || mode == (int)match_types.TwoGroupsNoOver || mode == (int)match_types.TwoGroupsPrime || mode == (int)match_types.TwoGroupsPrimeNoOver ) { DataRow[] data = dataRow.GetChildRows("pattern_has_bits"); if (data.Length == 0) { ScheduleDataSet dataset = this.DataSet as ScheduleDataSet; if (dataset != null) { DsnSQLUtil.FillDataTable(dataset.schedule_dsn , dataset.pattern_data , "select * from " + dataset.pattern_data.FullTableName + " where " + PatternDescriptionTable.PrimaryKey + "=" + DsnSQLUtil.GetSQLValue(connection, dataset.pattern_data.AutoKeyType, dataRow[PatternDescriptionTable.PrimaryKey]) + " order by block" , true); } data = dataRow.GetChildRows("pattern_has_bits"); } return(data); } else if ((mode == (int)match_types.CrazyMultiCard) || (mode == (int)match_types.TopMiddleBottom)) { return(LoadPatternSubs(dataRow)); } else if (mode == (int)match_types.ExternalJavaEngine) { return(LoadPatternJavaInfo(dataRow)); } return(null); } }
public RatedPackConfigurator(ScheduleDataSet schedule) { this.schedule = schedule; if (pack_config == null) { pack_config = new PackConfiguration(schedule.schedule_dsn); DsnSQLUtil.MatchCreate(schedule.schedule_dsn, pack_config); DsnSQLUtil.FillDataTable(schedule.schedule_dsn, pack_config); } InitializeComponent(); }
public PriceEditor2() { schedule = ControlList.schedule; price_data = schedule.session_price_data; current_price_data = schedule.Tables[CurrentPriceData.TableName] as CurrentPriceData; data = ControlList.data; data.SetSessionPriceExceptionSetCurrent += new ScheduleCurrents.OnSetCurrent(UpdatedCurrent); data.SetSessionCurrent += new ScheduleCurrents.OnSetCurrent(data_SetSessionCurrent); dsn = ControlList.schedule.schedule_dsn; InitializeComponent(); Disposed += new EventHandler(PriceEditor2_Disposed); }
public Form1() { ScheduleDataSet schedule = new ScheduleDataSet(StaticDsnConnection.dsn); ScheduleDataSet instance = new ScheduleDataSet(new DsnConnection("mysql.db"), schedule, DateTime.Now, 2); instance.WriteXML("M:/tmp.xml"); OpenSkieSchedule.data = instance; PrizeScheduleEditor.Form1 f = new PrizeScheduleEditor.Form1(); f.Show(); InitializeComponent(); }
static Local() { dsn = new DsnConnection(StaticDsnConnection.dsn.DataSource); schedule = new ScheduleDataSet(dsn); schedule.Create(); schedule.Fill(); //schedule.GetSession( DateTime.Now, 1 ); inited = true; }
public void UpdateAllParts( ) { ScheduleDataSet schedule = DataSet as ScheduleDataSet; if (schedule != null) { foreach (DataRow session in schedule.sessions.Rows) { UpdatePartNumbers(session); } } }
private void SessionNewSelect(object sender, EventArgs e) { ListControl lb = sender as ListControl; DataTable dt = lb.DataSource as DataTable; ScheduleDataSet sd = (dt.DataSet as ScheduleDataSet); if (lb.SelectedIndex >= 0) { sd.SetCurrentSession(sd.sessions.Rows[lb.SelectedIndex]); } //UpdateCurrent(); }
public void DefaultFill( ) { if (this.Rows.Count == 0) { ScheduleDataSet schedule = DataSet as ScheduleDataSet; DataRow[] default_exception = schedule.price_exception_sets.Select(PriceExceptionSet.NameColumn + "='Default'"); foreach (DataRow row in schedule.sessions.Rows) { AddGroupMember(row, default_exception[0]); } } }
//public PatternEditor( BingoGameCore3.Patterns patterns ) //{ // init( patterns, null ); //} public PatternEditor(OpenSkieScheduler3.ScheduleDataSet schedule) { BingoGameCore4.Patterns list = new BingoGameCore4.Patterns(schedule); this.schedule = schedule; if (schedule.patterns != null) { foreach (DataRow row in schedule.patterns.Rows) { list.Add(new Pattern(row, list)); } } init(list, null); }
public Form1() { DataRow[] drarray; BingoSQLTracking.BingoTracking.disable = true; schedule = new ScheduleDataSet(StaticDsnConnection.dsn); schedule.Create(); schedule.Fill(); schedule.patterns.DefaultView.Sort = "pattern_name ASC"; schedule.sessions.DefaultView.Sort = "session_name ASC"; patterns = new Patterns(schedule); ori = new OddsRunInfo( ); InitializeComponent(); Cardsets = new DataTable(); Cardsets.TableName = "Cardset"; Cardsets.Columns.Add("Name", typeof(String)); Cardsets.Columns.Add("filename", typeof(string)); Cardsets.Columns.Add("original_row", typeof(DataRow)); DataRow drx = Cardsets.NewRow(); drx[0] = "<No Dealers Found>"; drx[1] = null; Cardsets.Rows.Add(drx); foreach (DataRow row in schedule.cardset_ranges.Rows) { DataRow dr = Cardsets.NewRow(); dr[0] = row[OpenSkieScheduler3.BingoGameDefs.CardsetRange.NameColumn]; // skip the ',' string object o = row.GetParentRow(CardsetRange.CardsetInfoRelationName)["name"]; if (o == null) { dr[1] = DBNull.Value; } else { dr[1] = o; } dr[2] = row; Cardsets.Rows.Add(dr); } Cardsets.AcceptChanges(); PoplateGameTable(); }
/// <summary> /// Create a new BingoPack from a PackTable datarow /// </summary> /// <param name="dataRow">A row from PackTable</param> public BingoPack(BingoGameGroup game_group, DataRow dataRow) { if (dataRow != null) { this.schedule_row = dataRow; ScheduleDataSet schedule = dataRow.Table.DataSet as ScheduleDataSet; if (game_group != null) { this.game_groups.Add(game_group); this.cols = Convert.ToInt32(dataRow["width"]); this.rows = Convert.ToInt32(dataRow["height"]); this.count = cols * rows; this.name = dataRow[PackTable.NameColumn].ToString(); } if (schedule != null) { DataRow[] possible_game_group_prize = dataRow.GetChildRows("pack_has_prize_level"); List <DataRow> game_group_prize = new List <DataRow>(); foreach (DataRow prize in possible_game_group_prize) { this.prize_levels.Add(game_group.GetPrize(prize[PrizeLevelNames.PrimaryKey])); } } this.ID = dataRow[PackTable.PrimaryKey]; if (count == 0) { Log.log("Pack " + dataRow[PackTable.NameColumn] + " has 0 faces defined by length and strips(rows,cols:height,width)."); } object tmp = dataRow["_3_number"]; if (tmp == DBNull.Value) { flags.big3 = false; } else { flags.big3 = Convert.ToBoolean(tmp); } tmp = dataRow["double_action"]; if (tmp == DBNull.Value) { flags.double_action = false; } else { flags.double_action = Convert.ToBoolean(tmp); } } }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); ScheduleDataSet ds = new ScheduleDataSet(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "eip_t_scheduleDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { ScheduleDataSet ds = new ScheduleDataSet(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; }