private void RefreshGrid()
{
var orders = Domain.OrdersManager.GetOrders();
OrdersGridView.DataSource = orders;
OrdersGridView.DataBind();
}
// 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();
}
public OrdersIndexForm()
{
InitializeComponent();
OrdersGridView.AutoGenerateColumns = false;
OrdersGridView.Select();
OrdersGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}
protected void Page_Load(object sender, EventArgs e)
{
var orders = Domain.OrdersManager.GetOrders();
OrdersGridView.DataSource = orders;
OrdersGridView.DataBind();
}
private void UpdateOrdersGridView()
{
OrdersGridView.DataSource = _listAllOrdersController.Execute();
OrdersGridView.Refresh();
SetGridViewSettings();
LastGridViewUpdateLabel.Text = DateTime.Now.ToString();
}
private void BtnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
using (Session session = new Session()) {
object orderId = OrdersGridView.GetFocusedRowCellValue(colOid);
Order order = session.GetObjectByKey <Order>(orderId);
session.Delete(order);
}
Reload();
}
private void OrdersGridView_RowClick(object sender, RowClickEventArgs e)
{
if (e.Clicks == 2)
{
e.Handled = true;
int orderID = (int)OrdersGridView.GetRowCellValue(e.RowHandle, colOid);
ShowEditForm(orderID);
}
}
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();
}
private void EditFormClosed(object sender, EventArgs e)
{
var form = (EditOrderForm)sender;
form.FormClosed -= EditFormClosed;
if (form.OrderID.HasValue)
{
Reload();
OrdersGridView.FocusedRowHandle = OrdersGridView.LocateByValue("Oid", form.OrderID.Value,
rowHandle => OrdersGridView.FocusedRowHandle = (int)rowHandle);
}
}
private void ShowEditForm(int?orderID)
{
using (EditOrderForm form = new EditOrderForm(orderID)) {
form.ShowDialog(this);
if (form.OrderID.HasValue)
{
Reload();
OrdersGridView.FocusedRowHandle = OrdersGridView.LocateByValue("Oid", form.OrderID.Value,
rowHandle => OrdersGridView.FocusedRowHandle = (int)rowHandle);
}
}
}
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>");
}
}
