public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs)
{
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
CarrierSchema ds = new CarrierSchema();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "CarriersDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return(type);
}
public override DataSet Clone()
{
CarrierSchema cln = ((CarrierSchema)(base.Clone()));
cln.InitVars();
return(cln);
}
public override System.Data.DataSet Clone()
{
CarrierSchema cln = ((CarrierSchema)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(System.Xml.Schema.XmlSchemaSet xs)
{
CarrierSchema ds = new CarrierSchema();
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any = new System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
return(type);
}
/// <summary>
/// Methods returns the requested Carriers. If Local is true it returns the
/// local providers. If local is false it returns the long distance providers.
/// </summary>
/// <param name="siteId"></param>
/// <param name="local"></param>
/// <returns></returns>
public CarrierSchema.CarriersDataTable GetCarriers(int siteId, bool local)
{
try
{
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
// open connection
try{ sqlConnection.Open(); }
catch { throw new LogonException(); }
// now setup the command object.
string procName = local?"spGetCarriersIntraLata":"spGetCarriersInterLata";
using (SqlCommand cmd = new SqlCommand(procName, sqlConnection))
{
// build the command object
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@siteId", SqlDbType.Int).Value = siteId;
// build the dataadapter
SqlDataAdapter da = new SqlDataAdapter(cmd);
// create the dataset to fill
CarrierSchema ds = new CarrierSchema();
da.Fill(ds.Carriers);
// all done, return results.
return(ds.Carriers);
}
}
}
catch (DataSourceException)
{
// just rethrow it. it is from our internal code block
throw;
}
catch (Exception ex)
{
// DataSourceException.
throw new DataSourceException(ex);
}
}
