public override global::System.Data.DataSet Clone() { dsInstance cln = ((dsInstance)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { dsInstance ds = new dsInstance(); 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); }
private void frmGetOrder_Load(object sender, EventArgs e) { cboAs400Connections.Items.AddRange(new string[] { Properties.Settings.Default.ConnectionPeover, Properties.Settings.Default.ConnectionLonda }); cboAs400Connections.SelectedIndex = 1; cboSqlServer.Items.AddRange(new string[] { Properties.Settings.Default.FcukIntegrationConnectionStringLIFE_user, Properties.Settings.Default.FcukIntegrationConnectionStringFCUK_user }); // load combo of old instances if (this.dsI == null) { this.dsI = new dsInstance(); } vInstanceHeaderByDate_descTableAdapter taHcombo = new vInstanceHeaderByDate_descTableAdapter() { Connection = new SqlConnection(cboSqlServer.Text) }; taHcombo.Fill(this.dsI._vInstanceHeaderByDate_desc); cboOrderToRetrieveSql.DataSource = this.dsI._vInstanceHeaderByDate_desc; cboOrderToRetrieveSql.DisplayMember = "NameStatus"; cboOrderToRetrieveSql.ValueMember = "Id"; }
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(); dsInstance ds = new dsInstance(); 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 = "Security_InstanceDataTable"; 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); }
private void btnXmlCreate_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; if (!chkXmlFromSql.Checked) { if (tOrd != null) { try { string savedStyle = ""; var ords = from myRows in tOrd.AsEnumerable() select myRows; FcukProducts sty = new FcukProducts(); foreach (var o in ords) { string[] images = null; if (savedStyle != (string)o["STYLE"]) { // write a Style parent ColorSize parent = new ColorSize(); parent.SkuNumber = (string)o["STYLE"]; parent.Category = (string)o["RANGENAME"] + "," + (string)o["CATEGORY"]; parent.ParentSku = "Parent"; parent.Description = (string)o["STYLEDESCRIPTION"]; try { images = getImages((string)o["STYLE"]); FileInfo fi = new FileInfo(images[0]); parent.Images.Add(new Image() { ImageFileName = fi.Name.Replace(" ", "") }); } catch (Exception) { } sty.ColorSizeVariations.Add(parent); savedStyle = (string)o["STYLE"]; } ColorSize colsz = new ColorSize(); colsz.SkuNumber = (string)o["STYLE"]; colsz.Category = (string)o["RANGENAME"] + "," + (string)o["CATEGORY"]; colsz.Ean = (string)o["UPCCODE"]; colsz.Condition = "NEW"; colsz.StockStatus = "0"; colsz.Price = ((decimal)o["WHOLESALEPRICE"]).ToString(); colsz.PriceCurrency = (string)o["CURRENCY"]; colsz.Description = (string)o["STYLEDESCRIPTION"]; colsz.SellerCost = ((decimal)o["WHOLESALEPRICE"]).ToString(); colsz.SellerCostCurrency = (string)o["CURRENCY"]; colsz.ManufSuggRetailPrice = ((decimal)o["SALESPRICEFROMLIST"]).ToString(); colsz.ManufSuggRetailPriceCurrency = (string)o["CURRENCY"]; colsz.ParentSku = (string)o["STYLE"]; colsz.RelationshipName = "STYLE_COLORSIZE"; colsz.ResellerSilhouette = ""; colsz.AgeGroups = ""; colsz.Brand = "FCUK"; colsz.Gender = (string)o["RANGENAME"]; colsz.ColorCode = (string)o["COLOR"]; colsz.ColorDescription = (string)o["COLOURDESC"]; colsz.Season = (string)o["SEASON"]; switch ((string)o["SIZE"]) { case "10": colsz.Size = (string)o["SZ1"]; break; case "20": colsz.Size = (string)o["SZ2"]; break; case "30": colsz.Size = (string)o["SZ3"]; break; case "40": colsz.Size = (string)o["SZ4"]; break; case "50": colsz.Size = (string)o["SZ5"]; break; case "60": colsz.Size = (string)o["SZ6"]; break; default: colsz.Size = "UNKNOWN"; break; } colsz.SizeRegister = (string)o["SIZE"]; //colsz.SpecialDescription = "SPECIAL DESCRIPTION FROM SOPHIA XLSX"; colsz.SpecialDescription = getDescription((string)o["STYLE"]); colsz.SupplierColor = (string)o["COLOURDESC"]; colsz.VatType = "100"; colsz.OuterFabricMaterial = (string)o["FABRIC"]; colsz.WashInstructions = getCareInstructions((string)o["STYLE"]); colsz.Lining = getLining((string)o["STYLE"]); // "LINING"; colsz.Filling = getFilling((string)o["STYLE"]); //"FILLING"; //colsz.GarmentLength = "dummy length"; //colsz.Collar = "dummy collar"; //colsz.Fastening = "dummy fastening"; //colsz.SleeveLength = "dummy sleeve"; //colsz.InsideLeg = "dummy leg"; if (images != null && images.Length > 0) { foreach (string i in images) { FileInfo fi = new FileInfo(i); colsz.Images.Add(new Image() { ImageFileName = fi.Name }); } } sty.ColorSizeVariations.Add(colsz); } // save XML XmlSerializer mySerializer = new XmlSerializer(typeof(FcukProducts)); // To write to a file, create a StreamWriter object. // desired format is: FCUK_Zalando_Products_20200220115345.MAIN.xml StreamWriter myWriter = new StreamWriter(string.Format("c:\\temp\\FCUK_Zalando_Products_{0}.MAIN.xml", DateTime.Now.ToString("yyyyMMddHHmmss"))); mySerializer.Serialize(myWriter, sty); using (var stringwriter = new System.IO.StringWriter()) { var serializer = new XmlSerializer(sty.GetType()); serializer.Serialize(stringwriter, sty); string myString = stringwriter.ToString(); //XmlTreeDisplay(myString); } myWriter.Close(); } catch (Exception ex) { MessageBox.Show(string.Format("Message: <{0}>, line: <{1}>", ex.Message, ex.StackTrace), "Making XML from IBM data"); } } } else // use SQL data source { if (dsI == null) { dsI = new dsInstance(); } if (taD == null) { taD = new tInstanceDetailTableAdapter() { Connection = new SqlConnection(cboSqlServer.Text), ClearBeforeFill = true }; } if (taH == null) { taH = new tInstanceHeaderTableAdapter() { Connection = new SqlConnection(cboSqlServer.Text), ClearBeforeFill = true }; } taH.Fill(dsI.tInstanceHeader); taD.FillByHeaderId(dsI.tInstanceDetail, headerId); try { string savedStyle = ""; var ords = from myRows in tOrd.AsEnumerable() select myRows; FcukProducts sty = new FcukProducts(); foreach (dsInstance.tInstanceDetailRow r in dsI.tInstanceDetail.Rows) { string[] images = null; if (savedStyle != r.SkuNumber) { // write a Style parent ColorSize parent = new ColorSize(); parent.SkuNumber = r.SkuNumber; parent.Category = r.Category; parent.ParentSku = "Parent"; parent.Description = r.ProductDescription; try { images = getImages(r.SkuNumber); FileInfo fi = new FileInfo(images[0]); parent.Images.Add(new Image() { ImageFileName = fi.Name.Replace(" ", "") }); } catch (Exception) { } sty.ColorSizeVariations.Add(parent); savedStyle = r.SkuNumber; } ColorSize colsz = new ColorSize(); colsz.SkuNumber = r.SkuNumber; colsz.Category = r.Category; colsz.Ean = r.EAN; colsz.Condition = r.Condition; colsz.StockStatus = r.StockStatus.ToString(); colsz.Price = r.Price.ToString(); colsz.PriceCurrency = r.PriceCurrency; colsz.Description = r.ProductDescription; colsz.SellerCost = r.Price.ToString(); colsz.SellerCostCurrency = r.PriceCurrency; colsz.ManufSuggRetailPrice = r.ManufSuggRetailPrice.ToString(); // ((decimal)o["SALESPRICEFROMLIST"]).ToString(); colsz.ManufSuggRetailPriceCurrency = r.ManufSuggRetailPriceCurrency; // (string)o["CURRENCY"]; colsz.ParentSku = r.SkuNumber; colsz.RelationshipName = "STYLE_COLORSIZE"; colsz.ResellerSilhouette = r.ResellerSilhouette; colsz.AgeGroups = r.AgeGroups; colsz.Brand = r.Brand; colsz.Gender = r.Gender; colsz.ColorDescription = r.MainColor; colsz.Season = r.Season; colsz.Size = r.Size; colsz.SizeRegister = r.SizeRegister; //switch (r.Size) //{ // case "10": // colsz.Size = (string)o["SZ1"]; // break; // case "20": // colsz.Size = (string)o["SZ2"]; // break; // case "30": // colsz.Size = (string)o["SZ3"]; // break; // case "40": // colsz.Size = (string)o["SZ4"]; // break; // case "50": // colsz.Size = (string)o["SZ5"]; // break; // case "60": // colsz.Size = (string)o["SZ6"]; // break; // default: // colsz.Size = "UNKNOWN"; // break; //} colsz.SizeRegister = r.SizeRegister; //colsz.SpecialDescription = "SPECIAL DESCRIPTION FROM SOPHIA XLSX"; colsz.SpecialDescription = r.SpecialDescription; // getDescription((string)o["STYLE"]); colsz.SupplierColor = r.SupplierColor; colsz.VatType = r.VatType; colsz.OuterFabricMaterial = r.OuterFabricMaterial; colsz.WashInstructions = r.WashInstructions; colsz.Lining = r.Lining; colsz.Filling = r.Filling; //colsz.GarmentLength = "dummy length"; //colsz.Collar = "dummy collar"; //colsz.Fastening = "dummy fastening"; //colsz.SleeveLength = "dummy sleeve"; //colsz.InsideLeg = "dummy leg"; if (images != null && images.Length > 0) { foreach (string i in images) { FileInfo fi = new FileInfo(i); colsz.Images.Add(new Image() { ImageFileName = fi.Name }); } } sty.ColorSizeVariations.Add(colsz); } // save XML XmlSerializer mySerializer = new XmlSerializer(typeof(FcukProducts)); // To write to a file, create a StreamWriter object. StreamWriter myWriter = new StreamWriter(string.Format("c:\\temp\\FCUK_Zalando_Products_{0}.xml", DateTime.Now.ToString("yyyyMMddHHmmss"))); mySerializer.Serialize(myWriter, sty); using (var stringwriter = new System.IO.StringWriter()) { var serializer = new XmlSerializer(sty.GetType()); serializer.Serialize(stringwriter, sty); string myString = stringwriter.ToString(); //XmlTreeDisplay(myString); } myWriter.Close(); } catch (Exception ex) { MessageBox.Show(string.Format("Message: <{0}>, line: <{1}>", ex.Message, ex.StackTrace), "Making XML from IBM data"); } } Cursor.Current = Cursors.Default; }