protected void GetInvoice_Click(object sender, EventArgs e)
{
//convert string to date
DateTime dt = Convert.ToDateTime(clientInvoice_date.Value);
//Use service function to get invoice based off date
dynamic invoices = SR.GetInvoicebbydate(dt);
if (invoices != null)
{
string order_date = "";
string order_total = "";
string order_status = "";
string order_tax = "";
string order_shipping = "";
string order_discount = "";
string order_quantity = "";
//string delivery_name = "";
//Get most recent order's details
foreach (Order_Table i in invoices)
{
order_date = Convert.ToString(i.Order_date);
order_total = Convert.ToString(i.Order_Total);
order_status = Convert.ToString(i.Order_Status);
order_tax = Convert.ToString(i.Order_Tax);
order_shipping = Convert.ToString(i.Order_Shipping);
order_discount = Convert.ToString(i.Order_Discount);
order_quantity = Convert.ToString(i.Order_Quantity);
//delivery_name = delivery.Name;
//Display info for to client.
clientOrder_date.Value = order_date;
clientOrder_Status.Value = order_status;
clientOrder_Total.Value = order_total;
clientOrder_Tax.Value = order_tax;
clientOrder_Discount.Value = order_discount;
clientOrder_Shipping.Value = order_shipping;
clientOrder_Quantity.Value = order_quantity;
//clientOrder_Delivery.Value = delivery_name;
}
}
else
{
Response.Redirect("Home.aspx");
}
}