public int IsOrderReady(int Cust_ID)
{
try
{
DataSet1.Order_DetailsDataTable orders;
DataSet1TableAdapters.Order_DetailsTableAdapter adapter = new DataSet1TableAdapters.Order_DetailsTableAdapter();
orders = adapter.GetCompletedOrderByCustomerID(Cust_ID);
if (orders.Count > 0)
{
return Convert.ToInt32(orders[0]["Order_ID"]);
}
else
{
return 0;
}
}
catch { }
return 0;
}
public static int SubmitOrder(int Rest_ID, int[] Order_List, double Total, string Notes)
{
// TODO: Setup loading customer ID
int Cust_ID = 0;
// Order ID = unixtimestamp + customer ID
Int32 unixTimestamp = (Int32)(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds;
int Order_ID = unixTimestamp + Cust_ID;
// Create adapter to create order (Wat)
DataSet1TableAdapters.Order_DetailsTableAdapter adapter = new DataSet1TableAdapters.Order_DetailsTableAdapter();
adapter.CreateOrder(Order_ID, Cust_ID, Rest_ID, DateTime.Now, Total, "Visa", 0);
// Create adapter to submit order to database
DataSet1TableAdapters.Order_ItemsTableAdapter adapter2 = new DataSet1TableAdapters.Order_ItemsTableAdapter();
for (int i = 0; i < Order_List.Length; i++)
{
adapter2.Insert(Order_ID, Order_List[i], Notes, i);
}
return Order_ID;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
string resourceFileName = "XtraReport2.resx";
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand();
this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand();
this.dataSet11 = new DataSet1();
this.order_DetailsTableAdapter1 = new DataSet1TableAdapters.Order_DetailsTableAdapter();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel1,
this.xrLabel2,
this.xrLabel3,
this.xrLabel4
});
this.Detail.Height = 25;
this.Detail.Name = "Detail";
this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// PageHeader
//
this.PageHeader.Height = 30;
this.PageHeader.Name = "PageHeader";
this.PageHeader.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.PageHeader.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// PageFooter
//
this.PageFooter.Height = 30;
this.PageFooter.Name = "PageFooter";
this.PageFooter.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.PageFooter.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// order_DetailsTableAdapter1
//
this.order_DetailsTableAdapter1.ClearBeforeFill = true;
//
// xrLabel1
//
this.xrLabel1.BackColor = System.Drawing.Color.PaleGoldenrod;
this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Order Details.OrderID")
});
this.xrLabel1.Location = new System.Drawing.Point(92, 0);
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrLabel1.Size = new System.Drawing.Size(100, 25);
this.xrLabel1.StylePriority.UseBackColor = false;
this.xrLabel1.Text = "xrLabel1";
//
// xrLabel2
//
this.xrLabel2.BackColor = System.Drawing.Color.PaleGoldenrod;
this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Order Details.ProductID")
});
this.xrLabel2.Location = new System.Drawing.Point(225, 0);
this.xrLabel2.Name = "xrLabel2";
this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrLabel2.Size = new System.Drawing.Size(100, 25);
this.xrLabel2.StylePriority.UseBackColor = false;
this.xrLabel2.Text = "xrLabel2";
//
// xrLabel3
//
this.xrLabel3.BackColor = System.Drawing.Color.PaleGoldenrod;
this.xrLabel3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Order Details.Quantity")
});
this.xrLabel3.Location = new System.Drawing.Point(350, 0);
this.xrLabel3.Name = "xrLabel3";
this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrLabel3.Size = new System.Drawing.Size(100, 25);
this.xrLabel3.StylePriority.UseBackColor = false;
this.xrLabel3.Text = "xrLabel3";
//
// xrLabel4
//
this.xrLabel4.BackColor = System.Drawing.Color.PaleGoldenrod;
this.xrLabel4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Order Details.UnitPrice")
});
this.xrLabel4.Location = new System.Drawing.Point(467, 0);
this.xrLabel4.Name = "xrLabel4";
this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrLabel4.Size = new System.Drawing.Size(100, 25);
this.xrLabel4.StylePriority.UseBackColor = false;
this.xrLabel4.Text = "xrLabel4";
//
// XtraReport2
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.Detail,
this.PageHeader,
this.PageFooter
});
this.DataAdapter = this.order_DetailsTableAdapter1;
this.DataMember = "Order Details";
this.DataSource = this.dataSet11;
this.Version = "9.2";
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
private DataSet1.Order_DetailsDataTable GetOrderDetailssById(int Order_ID)
{
DataSet1TableAdapters.Order_DetailsTableAdapter adapter = new DataSet1TableAdapters.Order_DetailsTableAdapter();
return adapter.GetOrderByID(Order_ID);
}
