protected void BindOrdersList()
{
BPOrders bpcat = new BPOrders();
DSOrders = bpcat.SelectAll();
// DSOrders.tbl_Orders.DefaultView.Sort = "CustomerLastName";
dgOrders.DataBind();
}
private void GetOrderInfo()
{
BPOrders bpCat = new BPOrders();
BEOrders ds = bpCat.SelectOrdersByID(OrderID);
BEOrders.tbl_OrdersRow order = ds.tbl_Orders.FindByOrderID(OrderID);
lblTitle.Text = "View Order - " + order.OrderID + " - " + order.CustomerLastName + ", " + order.CustomerFirstName;
lblOrderID.Text = order.OrderID.ToString();
lblOrderDate.Text = order.OrderDate.ToString();
lblCustomerFirstName.Text = order.CustomerFirstName;
lblCustomerLastName.Text = order.CustomerLastName;
if (!order.IsCustomerEmailNull())
{
lblCustomerEmail.Text = order.CustomerEmail;
}
BPShippingMethods bp = new BPShippingMethods();
BEShipping.tbl_ShippingMethodsRow shipMethod = bp.SelectShippingMethodsByID(order.ShippingMethodID).tbl_ShippingMethods[0];
lblShippingMethod.Text = shipMethod.ShippingMethodName;
if (order.OrderApproved == true)
{
imgApproved.Visible = true;
imgNotApproved.Visible = false;
}else
{
imgApproved.Visible = false;
imgNotApproved.Visible = true;
}
//Billing address info
lblBillingFirstName.Text = order.BillingFirstName;
lblBillingLastName.Text = order.BillingLastName;
lblBillingLine1.Text = order.BillingLine1;
if (!order.IsBillingLine2Null())
{
lblBillingLine2.Text = order.BillingLine2;
}
if (!order.IsBillingEmailNull())
{
lblBillingEmail.Text = order.BillingEmail;
}
lblBillingPhone.Text = order.BillingPhone;
lblBillingCity.Text = order.BillingCity;
lblBillingProvinceName.Text = order.BillingProvinceName;
lblBillingCountryName.Text = order.BillingCountryName;
lblBillingPostalCode.Text = order.BillingPostalCode;
//shipping address info
lblShippingFirstName.Text = order.ShippingFirstName;
lblShippingLastName.Text = order.ShippingLastName;
lblShippingLine1.Text = order.ShippingLine1;
if (!order.IsShippingLine2Null())
{
lblShippingLine2.Text = order.ShippingLine2;
}
if (!order.IsShippingEmailNull())
{
lblShippingEmail.Text = order.ShippingEmail;
}
lblShippingPhone.Text = order.ShippingPhone;
lblShippingCity.Text = order.ShippingCity;
lblShippingProvinceName.Text = order.ShippingProvinceName;
lblShippingCountryName.Text = order.ShippingCountryName;
lblShippingPostalCode.Text = order.ShippingPostalCode;
//Order Details
DSOrders = bpCat.SelectOrderDetailsByOrderID(OrderID);
rptOrderList.DataBind();
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
BEOrders ds = new BEOrders();
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;
}
protected void BindSalesList(int CustomerID)
{
BPOrders bp = new BPOrders();
DSOrders = bp.SelectByCustomerID(CustomerID);
string searchString = string.Empty;
if (dtStart.SelectedDate != DateTime.MinValue)
{
searchString += String.Format("OrderDate >= {0}", dtStart.SelectedDate.ToString("MM/dd/yyyy"));
}
if (dtEnd.SelectedDate != DateTime.MinValue)
{
if (searchString != string.Empty)
{
searchString += " and ";
}
searchString += String.Format("OrderDate <= {0}", dtEnd.SelectedDate.ToString("MM/dd/yyyy"));
}
DSOrders.tbl_Orders.DefaultView.RowFilter = searchString;
dgOrders.DataBind();
}
protected void BindSalesList()
{
int CustomerID = Convert.ToInt32(ddlCustomers.SelectedValue);
BPOrders bp = new BPOrders();
if (CustomerID == -1)
{
DSOrders = bp.SelectAll();
}
else
{
DSOrders = bp.SelectByCustomerID(CustomerID);
}
string searchString = string.Empty;
if (dtStart.SelectedDate != DateTime.MinValue)
{
//searchString += String.Format("OrderDate >= '{0}'", dtStart.SelectedDate.ToString("MM/dd/yyyy"));
searchString += String.Format("OrderDate >= '{0}'", Convert.ToDateTime(dtStart.SelectedDate.ToString("MM/dd/yyyy")));
//searchString += String.Format("OrderDate >= '" + dtStart.SelectedDate.ToString("MM/dd/yyyy") + "'");
//searchString += "OrderDate >= " + Convert.ToDateTime(dtStart.SelectedDate.ToString("MM/dd/yyyy"));
}
if (dtEnd.SelectedDate != DateTime.MinValue)
{
if (searchString != string.Empty)
{
searchString += " and ";
}
//searchString += String.Format("OrderDate <= '{0}'", dtEnd.SelectedDate.ToString("MM/dd/yyyy"));
searchString += String.Format("OrderDate < '{0}'", Convert.ToDateTime((dtEnd.SelectedDate.AddDays(1).ToString("MM/dd/yyyy"))));
//searchString += String.Format("OrderDate <= '" + dtEnd.SelectedDate.ToString("dd/MM/yyyy") + "'");
//searchString += "OrderDate <= " + Convert.ToDateTime(dtEnd.SelectedDate.ToString("MM/dd/yyyy"));
}
string Filter = searchString;
if (Filter != null && Filter != "" && Filter != " ")
{
Filter = "(" + Filter + ") and ";
}
Filter += " OrderApproved = 1";
//DataRow [] somearray;
//somearray = DSOrders.tbl_Orders.Select(Filter);
DSOrders.tbl_Orders.DefaultView.RowFilter = Filter;
}
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();
BEOrders ds = new BEOrders();
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 = "tbl_OrdersDataTable";
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;
}
