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();
PackageSales ds = new PackageSales();
xs.Add(ds.GetSchemaSerializable());
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 = "PackageSaleDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return(type);
}
public override global::System.Data.DataSet Clone()
{
PackageSales cln = ((PackageSales)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
PackageSales ds = new PackageSales();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
xs.Add(ds.GetSchemaSerializable());
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
return(type);
}
private void buttonPackageSales_Click(object sender, RibbonControlEventArgs e)
{
PseudoProgressForm progress = new PseudoProgressForm();
progress.ProgressLabel = "Querying SAP...";
BackgroundWorker backgroundWorker = new BackgroundWorker();
PackageSales packageSalesDataset = new PackageSales();
backgroundWorker.DoWork +=
delegate(object workSender, DoWorkEventArgs eventArg)
{
PackageSales.PackageSaleDataTable packageSalesTable =
packageSalesDataset.PackageSale;
Sales sales = DataHelper.GetSalesData();
foreach (Sales.PackageRow packageRow in sales.Package.Rows)
{
PackageSales.PackageSaleRow packageSaleRow = packageSalesTable.NewPackageSaleRow();
packageSaleRow.PackageName = packageRow.PackageName;
packageSaleRow.NumberOfSales = 0;
packageSaleRow.PriceOfSales = 0;
foreach (DataRow row in packageRow.GetChildRows("Package_PackageSale"))
{
Sales.PackageSaleRow salesPackageSaleRow = row as Sales.PackageSaleRow;
packageSaleRow.NumberOfSales += 1;
packageSaleRow.PriceOfSales += salesPackageSaleRow.Price;
}
packageSalesTable.AddPackageSaleRow(packageSaleRow);
}
};
backgroundWorker.RunWorkerCompleted +=
delegate(object workSender, RunWorkerCompletedEventArgs eventArg)
{
progress.Close();
progress.Dispose();
ExcelHelper.LoadExcelSheet(
"PackageSalesDistribution",
Resources.PackageSalesDistribution,
packageSalesDataset);
};
backgroundWorker.RunWorkerAsync();
progress.ShowDialog();
}
