// 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>"); } }