public NhlStatsSet.playerstatsDataTable QueryPlayerStats(String query) { NhlStatsSet result = new NhlStatsSet(); DataAdapter adapter = new SQLiteDataAdapter(query, connection); adapter.Fill(result); return(result.playerstats); }
public NHLDatabaseOperator() { nhlStatsDatabase = new NhlStatsSet(); String dbPath = "nhlstatsdb"; connection = new SQLiteConnection("Data Source=" + dbPath); connection.Open(); playerStatsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.playerstatsTableAdapter(); goalieStatsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.goaliestatsTableAdapter(); teamStatsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.teamstatsTableAdapter(); seasonsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.seasonsTableAdapter(); scheduleAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.scheduleTableAdapter(); teamsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.teamsTableAdapter(); playerStatsAdapter.Connection = connection; goalieStatsAdapter.Connection = connection; teamStatsAdapter.Connection = connection; scheduleAdapter.Connection = connection; teamsAdapter.Connection = connection; }
public void CommitToDatabase() { NhlStatsSet changes = (NhlStatsSet)nhlStatsDatabase.GetChanges(); System.Console.Write("Commiting to SQLite database..."); transaction = connection.BeginTransaction(); playerStatsAdapter.Update(changes.playerstats); goalieStatsAdapter.Update(changes.goaliestats); teamStatsAdapter.Update(changes.teamstats); scheduleAdapter.Update(changes.schedule); teamsAdapter.Update(changes.teams); transaction.Commit(); transaction.Dispose(); nhlStatsDatabase.playerstats.AcceptChanges(); nhlStatsDatabase.goaliestats.AcceptChanges(); nhlStatsDatabase.teamstats.AcceptChanges(); nhlStatsDatabase.schedule.AcceptChanges(); nhlStatsDatabase.teams.AcceptChanges(); System.Console.WriteLine("done!"); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { NhlStatsSet ds = new NhlStatsSet(); 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 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(); NhlStatsSet ds = new NhlStatsSet(); 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 = "teamsDataTable"; 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 virtual int Update(NhlStatsSet dataSet) { return this.Adapter.Update(dataSet, "teams"); }
public virtual int Update(NhlStatsSet.teamsDataTable dataTable) { return this.Adapter.Update(dataTable); }
public virtual int Update(NhlStatsSet dataSet) { return this.Adapter.Update(dataSet, "schedule"); }
public virtual int Fill(NhlStatsSet.scheduleDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public virtual int FillBy(NhlStatsSet.seasonsDataTable dataTable, long Season) { this.Adapter.SelectCommand = this.CommandCollection[1]; this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Season)); if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }