private void btnViewInventory_Click(object sender, EventArgs e) { //lstInventory.Items.Clear(); //currentDateLbl.Text = DateTime.Now.ToLongDateString(); int empID = Convert.ToInt32(employeeIdTxtBx.Text); employee = Employee.FindEmployee(empID); lstInventory.Items.Clear(); foreach(Product i in products) { ListViewItem lvi = new ListViewItem(i.productName); lvi.SubItems.Add(i.productQuantity.ToString()); lvi.SubItems.Add(i.productBuyPrice.ToString()); lstInventory.Items.Add(lvi); } timer1.Enabled = true; //try //{ // if (employee.EmployeeID == 0) // throw new Exception(); // else // { // for (int i = 0; i < products.Length; i++) // { // productname.Add(products[i].productName); // quantity.Add(products[i].productQuantity.ToString()); // cost.Add(products[i].productBuyPrice); // } // for (int i = 0; i < products.Length; i++) // { // txtBxDisplayinventory.AppendText(string.Format("\r\n\t{0}", productname[i])); // txtBxDisplayinventory.AppendText(string.Format("\r\n\tRemaining: {0}", quantity[i].ToString())); // txtBxDisplayinventory.AppendText(string.Format("\r\n\tPurchase Cost per case: {0:C}",cost[i]*24)); // txtBxDisplayinventory.AppendText("\r\n"); // } // string empName = string.Format("{0} {1}",employee.FirstName,employee.LastName); // lblEmpName.Text = empName; // string userlog = string.Format("User {0} {1} logged to inventory", empID, empName); // Logging.Log(userlog); // } //} //catch(Exception) //{ // MessageBox.Show("Please supply valid employee ID"); //} }
/// <summary> /// Constructs an array of employee objects from the data in the Employee_T Table /// </summary> /// <returns> /// Returns an array of Employee objects /// </returns> public static Employee[] GetAllEmployees() { string query = "SELECT * FROM Employee_T"; List<Employee> employees = new List<Employee>(); Employee outEmployee; DataRowCollection results = DatabaseController.GetQueryResults(query, new Dictionary<string, object>()); foreach(DataRow i in results) { outEmployee = new Employee((int)i["ID"], (string)i["FirstName"], (string)i["LastName"]); employees.Add(outEmployee); } return employees.ToArray(); }
public transFrm(Employee employee) { current = employee; InitializeComponent(); }