public ShipperDS GetShippers(FreightType freightType, string clientNumber, string clientTerminal) { //Get a list of shippers ShipperDS shippers = null; try { shippers = new ShipperDS(); if (freightType == FreightType.Regular) { VendorDS vendors = GetVendors(clientNumber, clientTerminal); shippers = new ShipperDS(); for (int i = 0; i < vendors.VendorTable.Rows.Count; i++) { shippers.ShipperTable.AddShipperTableRow(vendors.VendorTable[i].VendorNumber, vendors.VendorTable[i].VendorName, vendors.VendorTable[i].VendorParentNumber, vendors.VendorTable[i].VendorSummary); } shippers.AcceptChanges(); } else if (freightType == FreightType.Returns) { AgentDS agents = GetAgents(false); ShipperDS _shippers = new ShipperDS(); for (int i = 0; i < agents.AgentTable.Rows.Count; i++) { _shippers.ShipperTable.AddShipperTableRow(agents.AgentTable[i].AgentNumber, agents.AgentTable[i].AgentName, agents.AgentTable[i].AgentParentNumber, agents.AgentTable[i].AgentSummary); } shippers.Merge(_shippers.ShipperTable.Select("", "ShipperNumber ASC")); shippers.AcceptChanges(); } } catch (ApplicationException ex) { throw ex; } catch (Exception ex) { throw new ApplicationException("Unexpected exception creating shipper list.", ex); } return(shippers); }
public VendorDS GetVendors(string clientNumber, string clientTerminal) { //Get a list of vendors VendorDS vendors = null; try { vendors = new VendorDS(); DataSet ds = FillDataset(USP_VENDORS, TBL_VENDORS, new object[] { clientNumber, clientTerminal }); if (ds.Tables[TBL_VENDORS] != null && ds.Tables[TBL_VENDORS].Rows.Count > 0) { VendorDS _vendors = new VendorDS(); _vendors.Merge(ds); for (int i = 0; i < _vendors.VendorTable.Rows.Count; i++) { _vendors.VendorTable.Rows[i]["VendorSummary"] = (!_vendors.VendorTable.Rows[i].IsNull("VendorNumber") ? _vendors.VendorTable.Rows[i]["VendorNumber"].ToString() : " ") + " - " + (!_vendors.VendorTable.Rows[i].IsNull("VendorName") ? _vendors.VendorTable.Rows[i]["VendorName"].ToString().Trim() : ""); } vendors.Merge(_vendors.VendorTable.Select("", "VendorNumber ASC")); vendors.AcceptChanges(); } } catch (ApplicationException ex) { throw ex; } catch (Exception ex) { throw new ApplicationException("Unexpected exception creating vendor list.", ex); } return(vendors); }
public override global::System.Data.DataSet Clone() { VendorDS cln = ((VendorDS)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { VendorDS ds = new VendorDS(); 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 VendorDS GetVendorLocations(string clientNumber, string clientTerminal, string vendorNumber) { //Get a list of vendor locations (child vendors) for the specified client-vendor System.Diagnostics.Debug.WriteLine("GetVendorLocations"); VendorDS locs = null; try { locs = new VendorDS(); VendorDS ds = GetVendors(clientNumber, clientTerminal); if (clientNumber != null && vendorNumber != null && ds.VendorTable.Rows.Count > 0) { locs.Merge(ds.VendorTable.Select("VendorParentNumber = '" + vendorNumber + "'")); } } catch (ApplicationException ex) { throw ex; } catch (Exception ex) { throw new ApplicationException("Unexpected exception creating vendor list.", ex); } return(locs); }
public VendorDS GetParentVendors(string clientNumber, string clientTerminal) { //Get a list of parent vendors System.Diagnostics.Debug.WriteLine("GetParentVendors"); VendorDS vendors = null; try { vendors = new VendorDS(); VendorDS ds = GetVendors(clientNumber, clientTerminal); if (clientNumber != null && ds.VendorTable.Rows.Count > 0) { vendors.Merge(ds.VendorTable.Select("VendorParentNumber = ''")); vendors.AcceptChanges(); } } catch (ApplicationException ex) { throw ex; } catch (Exception ex) { throw new ApplicationException("Unexpected exception creating vendor list.", ex); } return(vendors); }
public VendorDS GetVendorsList(string clientNumber, string clientTerminal) { //Get a list of vendors VendorDS vendors = null; try { vendors = new VendorDS(); DataSet ds = FillDataset(USP_VENDORS, TBL_VENDORS, new object[] { clientNumber, clientTerminal }); if (ds.Tables[TBL_VENDORS] != null && ds.Tables[TBL_VENDORS].Rows.Count > 0) { VendorDS _vendors = new VendorDS(); _vendors.Merge(ds); vendors.Merge(_vendors.VendorTable.Select("", "VendorName ASC")); vendors.AcceptChanges(); } } catch (ApplicationException ex) { throw ex; } catch (Exception ex) { throw new ApplicationException("Unexpected exception creating vendor list.", ex); } return(vendors); }
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(); VendorDS ds = new VendorDS(); 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 = "VendorDetailTableDataTable"; 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); }