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);
}
