public override bool Execute() { DATASET_PATH = SVNRootPath.ItemSpec + @"DATASET\"; wssGetList.getList myList = new wssGetList.getList("http://hd16.hafsjold.dk", "administrator", "m733", "hd16"); System.Xml.Serialization.XmlSerializer ser; XmlTextWriter writer; System.Data.DataSet dsListItems = myList.getListData("ProPurList"); dsListItems.SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; ser = new System.Xml.Serialization.XmlSerializer(dsListItems.GetType()); writer = new XmlTextWriter(DATASET_PATH + "dsListItems.xml", System.Text.Encoding.UTF8); writer.Formatting = Formatting.Indented; ser.Serialize(writer, dsListItems); writer.Close(); System.Data.DataSet dsListTypeItems = myList.getListData("ProPurListType"); dsListTypeItems.SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; ser = new System.Xml.Serialization.XmlSerializer(dsListTypeItems.GetType()); writer = new XmlTextWriter(DATASET_PATH + "dsListTypeItems.xml", System.Text.Encoding.UTF8); writer.Formatting = Formatting.Indented; ser.Serialize(writer, dsListTypeItems); writer.Close(); System.Data.DataSet dsTypeItems = myList.getListData("ProPurType"); dsTypeItems.SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; ser = new System.Xml.Serialization.XmlSerializer(dsTypeItems.GetType()); writer = new XmlTextWriter(DATASET_PATH + "dsTypeItems.xml", System.Text.Encoding.UTF8); writer.Formatting = Formatting.Indented; ser.Serialize(writer, dsTypeItems); writer.Close(); System.Data.DataSet dsTypeColumnItems = myList.getListData("ProPurTypeColumn"); dsTypeColumnItems.SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; ser = new System.Xml.Serialization.XmlSerializer(dsTypeColumnItems.GetType()); writer = new XmlTextWriter(DATASET_PATH + "dsTypeColumnItems.xml", System.Text.Encoding.UTF8); writer.Formatting = Formatting.Indented; ser.Serialize(writer, dsTypeColumnItems); writer.Close(); System.Data.DataSet dsFieldItems = myList.getListData("ProPurColumn"); dsFieldItems.SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; ser = new System.Xml.Serialization.XmlSerializer(dsFieldItems.GetType()); writer = new XmlTextWriter(DATASET_PATH + "dsFieldItems.xml", System.Text.Encoding.UTF8); writer.Formatting = Formatting.Indented; ser.Serialize(writer, dsFieldItems); writer.Close(); return(true); }
public static void GenerateMetadataMain(MemoryStream sXML) { InitParams(sXML); wssGetList.getList myList = new wssGetList.getList("http://hd16.hafsjold.dk", "administrator", "m733", "hd16"); System.Xml.Serialization.XmlSerializer ser; XmlTextWriter writer; System.Data.DataSet dsListItems = myList.getListData("ProPurList"); dsListItems.SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; ser = new System.Xml.Serialization.XmlSerializer(dsListItems.GetType()); writer = new XmlTextWriter(DATASET_PATH + "dsListItems.xml", System.Text.Encoding.UTF8); writer.Formatting = Formatting.Indented; ser.Serialize(writer, dsListItems); writer.Close(); System.Data.DataSet dsListTypeItems = myList.getListData("ProPurListType"); dsListTypeItems.SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; ser = new System.Xml.Serialization.XmlSerializer(dsListTypeItems.GetType()); writer = new XmlTextWriter(DATASET_PATH + "dsListTypeItems.xml", System.Text.Encoding.UTF8); writer.Formatting = Formatting.Indented; ser.Serialize(writer, dsListTypeItems); writer.Close(); System.Data.DataSet dsTypeItems = myList.getListData("ProPurType"); dsTypeItems.SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; ser = new System.Xml.Serialization.XmlSerializer(dsTypeItems.GetType()); writer = new XmlTextWriter(DATASET_PATH + "dsTypeItems.xml", System.Text.Encoding.UTF8); writer.Formatting = Formatting.Indented; ser.Serialize(writer, dsTypeItems); writer.Close(); System.Data.DataSet dsTypeColumnItems = myList.getListData("ProPurTypeColumn"); dsTypeColumnItems.SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; ser = new System.Xml.Serialization.XmlSerializer(dsTypeColumnItems.GetType()); writer = new XmlTextWriter(DATASET_PATH + "dsTypeColumnItems.xml", System.Text.Encoding.UTF8); writer.Formatting = Formatting.Indented; ser.Serialize(writer, dsTypeColumnItems); writer.Close(); System.Data.DataSet dsFieldItems = myList.getListData("ProPurColumn"); dsFieldItems.SchemaSerializationMode = SchemaSerializationMode.IncludeSchema; ser = new System.Xml.Serialization.XmlSerializer(dsFieldItems.GetType()); writer = new XmlTextWriter(DATASET_PATH + "dsFieldItems.xml", System.Text.Encoding.UTF8); writer.Formatting = Formatting.Indented; ser.Serialize(writer, dsFieldItems); writer.Close(); }
public override void ExecuteResult(ControllerContext context) { if (this.Data != null) { context.HttpContext.Response.Clear(); var oa = new Csla.Data.ObjectAdapter(); var ds = new DataSet(); oa.Fill(ds, this.TableName, this.Data); var xs = new System.Xml.Serialization.XmlSerializer(ds.GetType()); context.HttpContext.Response.ContentType = "text/xml"; xs.Serialize(context.HttpContext.Response.Output, ds); } }
public static System.Data.DataSet OpenDataSet(string ListName) { System.Xml.Serialization.XmlSerializer ser = null; FileStream reader; string FileName = null; switch (ListName) { case "ProPurList": FileName = Metadata.DATASET_PATH + @"dsListItems.xml"; break; case "ProPurListType": FileName = Metadata.DATASET_PATH + @"dsListTypeItems.xml"; break; case "ProPurType": FileName = Metadata.DATASET_PATH + @"dsTypeItems.xml"; break; case "ProPurTypeColumn": FileName = Metadata.DATASET_PATH + @"dsTypeColumnItems.xml"; break; case "ProPurColumn": FileName = Metadata.DATASET_PATH + @"dsFieldItems.xml"; break; } System.Data.DataSet ds = new System.Data.DataSet(); ser = new System.Xml.Serialization.XmlSerializer(ds.GetType()); using (reader = new FileStream(FileName, FileMode.Open)) { ds = (System.Data.DataSet)ser.Deserialize(reader); reader.Close(); } return(ds); }
public void SaveTasks(IEnumerable<Task> tasks) { DataSet ds = new DataSet (); var dt = new DataTable (); dt.Columns.Add (new DataColumn ("Task_Deadline", Type.GetType ("System.DateTime"))); dt.Columns.Add (new DataColumn ("Task_CreateDate", Type.GetType ("System.DateTime"))); dt.Columns.Add (new DataColumn ("Task_Title", Type.GetType ("System.String"))); dt.Columns.Add (new DataColumn ("Task_Description", Type.GetType ("System.String"))); dt.Columns.Add (new DataColumn ("Task_Priority", Type.GetType ("LoganekPlaner.Priority"))); dt.Columns.Add (new DataColumn ("Task_IsDone", Type.GetType ("System.Boolean"))); ds.Tables.Add (dt); ds.Tables [0].TableName = "product"; foreach (var task in tasks) { DataRow dr; dr = dt.NewRow (); if (task.Deadline.HasValue) { dr ["Task_Deadline"] = task.Deadline; } else { dr ["Task_Deadline"] = DBNull.Value; } dr ["Task_CreateDate"] = task.CreateDate; dr ["Task_Title"] = task.Title; dr ["Task_Description"] = task.Description; dr ["Task_Priority"] = task.Priority; dr ["Task_IsDone"] = task.IsDone; dt.Rows.Add (dr); } StreamWriter serialWriter; serialWriter = new StreamWriter (path); XmlSerializer xmlWriter = new XmlSerializer (ds.GetType ()); xmlWriter.Serialize (serialWriter, ds); serialWriter.Close (); ds.Clear (); }
/// <summary> /// Passes Partner Address data as a DataSet to the caller. Loads all available /// Addresses for the Partner. /// /// </summary> /// <param name="ADataSet">DataSet that holds a DataSet with a DataTable for the /// Person</param> /// <param name="APartnerKey">PartnerKey of the Partner for which Address data is to be /// loaded</param> /// <param name="AReadTransaction">Transaction for the SELECT statement /// </param> /// <returns>void</returns> public static void LoadAll(DataSet ADataSet, Int64 APartnerKey, TDBTransaction AReadTransaction) { PLocationTable LocationDT; PPartnerLocationTable PartnerLocationDT; PPartnerLocationAccess.LoadViaPPartner(ADataSet, APartnerKey, AReadTransaction); PLocationAccess.LoadViaPPartner(ADataSet, APartnerKey, AReadTransaction); // Apply security LocationDT = (PLocationTable)ADataSet.Tables[PLocationTable.GetTableName()]; PartnerLocationDT = (PPartnerLocationTable)ADataSet.Tables[PPartnerLocationTable.GetTableName()]; ApplySecurity(ref PartnerLocationDT, ref LocationDT); // make sure that location specific fields in PartnerLocationDT get initialized if (ADataSet.GetType() == typeof(PartnerEditTDS)) { PartnerCodeHelper.SyncPartnerEditTDSPartnerLocation(LocationDT, (PartnerEditTDSPPartnerLocationTable)PartnerLocationDT); } if (TLogging.DL >= 9) { DebugLoadedDataset(ADataSet); } }
/// <summary> /// Passes Partner Address data as a DataSet to the caller. Loads the Address /// which is specified through ALocationKey. /// /// </summary> /// <param name="ADataSet">DataSet that holds a DataSet with a DataTable for the /// Person</param> /// <param name="APartnerKey">PartnerKey of the Partner for which Address data is to be /// loaded</param> /// <param name="ASiteKey">SiteKey of the Location for which Address data is to /// be loaded</param> /// <param name="ALocationKey">LocationKey of the Location for which Address data is to /// be loaded</param> /// <param name="AReadTransaction">Transaction for the SELECT statement /// </param> /// <returns>void</returns> public static void LoadByPrimaryKey(DataSet ADataSet, Int64 APartnerKey, Int64 ASiteKey, Int32 ALocationKey, TDBTransaction AReadTransaction) { PLocationTable LocationDT; PPartnerLocationTable PartnerLocationDT; PPartnerLocationAccess.LoadByPrimaryKey(ADataSet, APartnerKey, ASiteKey, ALocationKey, AReadTransaction); PLocationAccess.LoadByPrimaryKey(ADataSet, ASiteKey, ALocationKey, AReadTransaction); // Apply security LocationDT = (PLocationTable)ADataSet.Tables[PLocationTable.GetTableName()]; PartnerLocationDT = (PPartnerLocationTable)ADataSet.Tables[PPartnerLocationTable.GetTableName()]; ApplySecurity(ref PartnerLocationDT, ref LocationDT); // make sure that location specific fields in PartnerLocationDT get initialized if (ADataSet.GetType() == typeof(PartnerEditTDS)) { PartnerCodeHelper.SyncPartnerEditTDSPartnerLocation(LocationDT, (PartnerEditTDSPPartnerLocationTable)PartnerLocationDT); } }
// bug #68007 public void SerializeDataSet3 () { string xml = @"<?xml version=""1.0"" encoding=""utf-8""?><DataSet><xs:schema id=""Example"" xmlns="""" xmlns:xs=""http://www.w3.org/2001/XMLSchema"" xmlns:msdata=""urn:schemas-microsoft-com:xml-msdata""><xs:element name=""Example"" msdata:IsDataSet=""true""><xs:complexType><xs:choice maxOccurs=""unbounded"" minOccurs=""0""><xs:element name=""Packages""><xs:complexType><xs:attribute name=""ID"" type=""xs:int"" use=""required"" /><xs:attribute name=""ShipDate"" type=""xs:dateTime"" /><xs:attribute name=""Message"" type=""xs:string"" /><xs:attribute name=""Handlers"" type=""xs:int"" /></xs:complexType></xs:element></xs:choice></xs:complexType></xs:element></xs:schema><diffgr:diffgram xmlns:msdata=""urn:schemas-microsoft-com:xml-msdata"" xmlns:diffgr=""urn:schemas-microsoft-com:xml-diffgram-v1""><Example><Packages diffgr:id=""Packages1"" msdata:rowOrder=""0"" ID=""0"" ShipDate=""2004-10-11T17:46:18.6962302-05:00"" Message=""Received with no breakage!"" Handlers=""3"" /><Packages diffgr:id=""Packages2"" msdata:rowOrder=""1"" ID=""1"" /></Example></diffgr:diffgram></DataSet>"; DataSet ds = new DataSet ("Example"); // Add a DataTable DataTable dt = new DataTable ("Packages"); ds.Tables.Add (dt); // Add an ID DataColumn w/ ColumnMapping = MappingType.Attribute dt.Columns.Add (new DataColumn ("ID", typeof(int), "", MappingType.Attribute)); dt.Columns ["ID"].AllowDBNull = false; // Add a nullable DataColumn w/ ColumnMapping = MappingType.Attribute dt.Columns.Add (new DataColumn ("ShipDate", typeof (DateTime), "", MappingType.Attribute)); dt.Columns ["ShipDate"].AllowDBNull = true; // Add a nullable DataColumn w/ ColumnMapping = MappingType.Attribute dt.Columns.Add (new DataColumn ("Message", typeof (string), "", MappingType.Attribute)); dt.Columns ["Message"].AllowDBNull = true; // Add a nullable DataColumn w/ ColumnMapping = MappingType.Attribute dt.Columns.Add (new DataColumn ("Handlers", typeof (int), "", MappingType.Attribute)); dt.Columns ["Handlers"].AllowDBNull = true; // Add a non-null value row DataRow newRow = dt.NewRow(); newRow ["ID"] = 0; newRow ["ShipDate"] = DateTime.Now; newRow ["Message"] = "Received with no breakage!"; newRow ["Handlers"] = 3; dt.Rows.Add (newRow); // Add a null value row newRow = dt.NewRow (); newRow ["ID"] = 1; newRow ["ShipDate"] = DBNull.Value; newRow ["Message"] = DBNull.Value; newRow ["Handlers"] = DBNull.Value; dt.Rows.Add (newRow); ds.AcceptChanges (); XmlSerializer ser = new XmlSerializer (ds.GetType()); StringWriter sw = new StringWriter (); ser.Serialize (sw, ds); string result = sw.ToString (); Assert.AreEqual (xml, result); }
public void SerializeDataSet2 () { DataSet quota = new DataSet ("Quota"); // Dimension DataTable dt = new DataTable ("Dimension"); quota.Tables.Add (dt); dt.Columns.Add ("Number", typeof(int)); dt.Columns ["Number"].AllowDBNull = false; dt.Columns ["Number"].ColumnMapping = MappingType.Attribute; dt.Columns.Add ("Title", typeof(string)); dt.Columns ["Title"].AllowDBNull = false; dt.Columns ["Title"].ColumnMapping = MappingType.Attribute; dt.Rows.Add (new object [] {0, "Hospitals"}); dt.Rows.Add (new object [] {1, "Doctors"}); dt.Constraints.Add ("PK_Dimension", dt.Columns ["Number"], true); quota.AcceptChanges (); XmlSerializer ser = new XmlSerializer (quota.GetType ()); StringWriter sw = new StringWriter (); ser.Serialize (sw, quota); DataSet ds = (DataSet) ser.Deserialize (new StringReader (sw.ToString ())); }
/// <summary> /// Serializes a Typed DataSet to a byte[] containing only the data for each DataTable (ie no infrastructure) /// </summary> /// <param name="dataSet">The Typed DataSet to serialize.</param> /// <returns>A byte[] containing the serialized data.</returns> /// <remarks>The DataSet must be Typed and not a plain DataSet. It must also not have had any /// new columns/tables added to it. In either of these cases, use SerializeDataSet instead.</remarks> public static byte[] SerializeTypedDataSet(DataSet dataSet) { if (dataSet == null) throw new ArgumentNullException("dataSet"); if (dataSet.GetType() == typeof(DataSet)) throw new ArgumentException("Is not a typed DataSet", "dataSet"); return new FastSerializer().SerializeDataOnly(dataSet); }
/// <summary> /// Deserializes a Typed DataSet from a byte[] containing serialized data only. /// </summary> /// <param name="dataSet">The Typed DataSet to deserialize into.</param> /// <param name="serializedData">A byte[] containing the serialized data.</param> /// <returns>The same DataSet passed in.</returns> /// <remarks>The DataSet must be of the same type from which the serialized data was originally obtained.</remarks> public static DataSet DeserializeTypedDataSet(DataSet dataSet, byte[] serializedData) { if (dataSet == null) throw new ArgumentNullException("dataSet"); if (serializedData == null) throw new ArgumentNullException("serializedData"); if (dataSet.GetType() == typeof(DataSet)) throw new ArgumentException("Is not a typed DataSet", "dataSet"); return new FastDeserializer().DeserializeDataSetDataOnly(dataSet, serializedData); }