protected void Page_Load(object sender, EventArgs e) { BlUser user = (BlUser)Session["user"]; BlOrderUser orderUser = null; try { orderUser = (BlOrderUser)Session["user"]; } catch { Response.Redirect("HomePage.aspx"); return; } //take care of all the options of user BlOrderUser/BlShopManager/null if (user is BlOrderUser User) { orderUser = User; } if (user is BlShopManager shopManager) { orderUser = shopManager; } if (user.Type == 2)//system manager { DataTable shopsTable = BLshopDB.ShopAndManagerTable(); if (shopsTable != null && shopsTable.Rows.Count > 0) { ShopTable.Visible = true; ShopTable.DataSource = shopsTable; ShopTable.DataBind(); } else { ErShopTable.Text = "There is no shops"; //msg } } if (orderUser == null) { Response.Redirect("HomePage.aspx"); return; } if (Page.IsPostBack) { return; } //get data DataTable customers = orderUser.CustomersTable(); DataTable deliveries = orderUser.DeliveriesTable(); ErDelivery.Text = !BindTable(deliveries, DeliveriesTable) ? "fail show deliveries table" : ""; //error massage ErCustomer.Text = !BindTable(customers, CustomersTable) ? "fail show customers table" : ""; //error massage //set the labels information NumOfOrders.Text = "Number of orders- " + orderUser.GetNumOfOrders(); NumOfCustomers.Text = "Number of customers- " + customers.Rows.Count; }
private void ConfigShopTalbesAndItems() { if (itemPrefabNames != null) { GameObject shopTablePrefab; Vector2 centerPosition = new Vector2(transform.position.x + blockWidth / 2.0f, transform.position.y - blockWidth / 2.0f); for (int i = 0; i < itemPrefabNames.Count; i++) { shopTablePrefab = (GameObject)Resources.Load("Item/ShopTable"); Vector2 spwanLocation = new Vector2(centerPosition.x + (-1 + i) * tableOffset, centerPosition.y); ShopTable st = Instantiate(shopTablePrefab, spwanLocation, Quaternion.identity).GetComponent <ShopTable>(); st.transform.parent = transform; st.ConfigGoods(itemPrefabNames[i]); } } }
public IShopTable Execute(ShopID id) { ShopTable table; using (var r = ExecuteReader(id)) { if (!r.Read()) { return(null); } table = new ShopTable(); table.ReadValues(r); } return(table); }