protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Manager m = (Manager)Session["manager"]; HelloLabel.Text = m.CManagerName; Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS(); DataSet ds = webser.GetAllOrders(""); if (ds.Tables[0].Rows.Count != 0) { CloseOrders.Visible = true; ShowOrder.Visible = true; ShowOrder.DataSource = ds; ShowOrder.DataBind(); } else { Response.Write("<script>alert('לא נמצאו הזמנות')</script>"); } } }
protected void SortButton_Click(object sender, EventArgs e) { string order = " ORDER BY ", temp = order; if (HighToLow.Checked) { if (order.Equals(temp)) { order += "OrderTotalMoney DESC"; } else { order += ",OrderTotalMoney DESC"; } } if (LowToHigh.Checked) { if (order.Equals(temp)) { order += "OrderTotalMoney ASC"; } else { order += ",OrderTotalMoney ASC"; } } if (SortUser.Checked) { if (order.Equals(temp)) { order += "OrderUserId ASC"; } else { order += ",OrderUserId ASC"; } } if (SortDate.Checked) { if (order.Equals(temp)) { order += "OrderDate"; } else { order += ",OrderDate"; } } if (IsSupplied.Checked) { if (order.Equals(temp)) { order += "OrderIsSupplied"; } else { order += ",OrderIsSupplied"; } } if (order.Equals(temp)) { order = ""; } Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS(); //sort the orders DataSet ds = webser.GetAllOrders(order); if (ds.Tables[0].Rows.Count != 0) { ShowOrder.Visible = true; ShowDetails.Visible = false; CloseOrders.Visible = true; ShowOrder.DataSource = ds; ShowOrder.DataBind(); } else { CloseOrders_Click(sender, e); Response.Write("<script>alert('לא נמצאו הזמנות')</script>"); } }