// loads all available menu utems
public void Load_Items()
{
string querySelectAllItems = string.Format("SELECT item_code AS ItemCode, " +
"item_name AS ItemName," +
"item_price AS ItemPrice " +
"FROM items");
try
{
dgItemsList.ItemsSource = SqlQueries.Load_DataGridItems(querySelectAllItems).DefaultView;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
//load available item menu
public void Load_POSItems()
{
string queryLoadAvailableItems = string.Format("SELECT item_code AS Code, " +
"item_name AS Item, " +
"item_price AS Price " +
"FROM items");
try
{
this.dgPOSItems.ItemsSource = SqlQueries.Load_DataGridItems(queryLoadAvailableItems).DefaultView;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
// loads all active users in DB
public void Load_ActiveUsers()
{
string querySelectAllActiveUsers = string.Format("SELECT " +
"users_information.emp_id AS Emp_ID," +
"users_information.fname AS FName," +
"users_information.lname AS LName," +
"roles.description AS Role " +
"FROM users_information LEFT JOIN users " +
"ON users_information.emp_id = users.emp_id " +
"LEFT JOIN roles " +
"ON users.role_id = roles.role_id " +
"WHERE users_information.status = 'Active'");
try
{
this.dgUserList.ItemsSource = SqlQueries.Load_DataGridItems(querySelectAllActiveUsers).DefaultView;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}