protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lblUser.Text = GlobalAccess.Fullname; } var collection = Event_Log.GetCurrentEvents(); // var empList = collection.Where(o => o.TableName == "employee" && o.Event == "insert").ToList(); int empCount = empList.Count; var kioskList = collection.Where(o => o.TableName == "kiosk" && o.Event == "insert").ToList(); int kioskCount = kioskList.Count; var productList = collection.Where(o => o.TableName == "product" && o.Event == "insert").ToList(); int productCount = productList.Count; var salesList = collection.Where(o => o.TableName == "salesinfo" && o.Event == "insert").ToList(); int salesCount = salesList.Count; // lblEmployee.Text = string.Format("{0}({1})", "Employee", empCount); lblKiosk.Text = string.Format("{0}({1})", "Kiosk", kioskCount); lblItems.Text = string.Format("{0}({1})", "Items", productCount); lblSales.Text = string.Format("{0}({1})", "Sales", salesCount); /// CallEmployeeLog(); }