// Displays order information in grid view on Orders Log page on update.
private void refreshGrid()
{
var orders = Domain.OrdersManager.GetOrders();
OrdersGridView.DataSource = orders.Where(p => p.Completed == false).ToList();
OrdersGridView.DataBind();
}
private void RefreshGrid()
{
var orders = Domain.OrdersManager.GetOrders();
OrdersGridView.DataSource = orders;
OrdersGridView.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var orders = Domain.OrdersManager.GetOrders();
OrdersGridView.DataSource = orders;
OrdersGridView.DataBind();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
Thread.Sleep(2000);
GridView gv = (GridView)sender;
var value = Convert.ToInt32(gv.SelectedValue);
NorthwindEntities db = new NorthwindEntities();
OrdersGridView.DataSource = db.Orders.Where(x => x.EmployeeID == value)
.ToList();
OrdersGridView.DataBind();
}
protected void OrdersGridView_OnRowCommand(object sender,
GridViewCommandEventArgs e)
{
if (e.CommandName == "CompleteOrder")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = OrdersGridView.Rows[index];
int ID = Convert.ToInt32(row.Cells[0].Text);
OrderDTO order = OrdersService.GetOrders().Single((o) => ID == o.ID);
order.Status = "Complete";
OrdersService.UpdateOrder(order);
OrdersGridView.DataSource = null;
OrdersGridView.DataBind();
}
}
protected void DisplayButton_Click(object sender, EventArgs e)
{
try
{
Query = "select Customer.Cust_id as Customer,ItemType.type as Category , ItemType.name as Item , CustomerOrder.OrderDate as Date , CustomerOrder.status as status from ItemType Inner Join CustomerOrder ON ItemType.type_id = CustomerOrder.Type_id inner Join Customer On Customer.Cust_id = CustomerOrder.Cust_id where CustomerOrder.OrderDate = '" + Calendar.SelectedDate.ToString().Split(' ')[0] + "'";
dt = cc.GetData(Query);
if (dt.Rows.Count > 0)
{
OrdersGridView.DataSource = dt;
OrdersGridView.DataBind();
}
else
{
throw new Exception("No Date Available");
}
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "')</script>");
}
}