public override global::System.Data.DataSet Clone() { libraryDataSet cln = ((libraryDataSet)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { libraryDataSet ds = new libraryDataSet(); 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 DataAccessLayer(SourceType dataType, string targetFile) { if (string.IsNullOrWhiteSpace(nameof(targetFile))) { throw new ArgumentException(nameof(targetFile)); } _provider = new Provider.Provider(); _dataType = dataType; _targetFile = targetFile; _libraryDataSet = _provider.GetAllData(dataType, targetFile); }
public libraryDataSet GetAllData(SourceType dataType, string targetFile) { _dataType = dataType; _targetFile = targetFile; if (dataType == SourceType.Xml) { try { _libraryDs = new libraryDataSet(); _libraryDs.ReadXml(targetFile); _libraryDs.ReadXmlSchema(targetFile); return(_libraryDs); } catch (Exception) { System.Windows.Forms.MessageBox.Show("An error occured. Restart application"); Application.ExitThread(); } } _libraryTables = new DataTable[] { _libraryDs.Items, _libraryDs.Authors, _libraryDs.Books, _libraryDs.Borrows, _libraryDs.Copies, _libraryDs.Magazines, _libraryDs.Articles, _libraryDs.ArticlesInMagazines, _libraryDs.Users }; _tablesName = new[] { "Items", "Authors", "Books", "Borrows", "Copies", "Magazines", "Articles", "ArticlesInMagazines", "Users" }; _libraryDataAdapters = new SqlDataAdapter[_tablesName.Length]; for (int i = 0; i < _tablesName.Length; i++) { _libraryDataAdapters[i] = new SqlDataAdapter("Select * from " + _tablesName[i], targetFile); new SqlCommandBuilder(_libraryDataAdapters[i]); } for (int i = 0; i < _tablesName.Length; i++) { _libraryDataAdapters[i].Fill(_libraryTables[i]); } return(_libraryDs); }