public HashSet <PharmacySaleItemModel> GetPharmacySales()
{
string query = "SELECT pharmacy_sale.id, medicine.name, employee.first_name, employee.last_name," +
"employee.middle_name, pharmacy_sale.quantity, pharmacy_sale.profit, pharmacy_sale.date " +
"FROM pharmacy_sale " +
"LEFT JOIN medicine ON medicine.id = pharmacy_sale.id_medicine " +
"LEFT JOIN employee ON employee.id = pharmacy_sale.id_employee ";
command = new MySqlCommand(query, connection);
MySqlDataReader reader = command.ExecuteReader();
HashSet <PharmacySaleItemModel> items = new HashSet <PharmacySaleItemModel>();
PharmacySaleItemModel item;
while (reader.Read())
{
item = new PharmacySaleItemModel();
item.id = reader.GetValue(0).ToString();
item.name = reader.GetValue(1).ToString();
item.employee = reader.GetValue(2).ToString() + reader.GetValue(3).ToString() + reader.GetValue(4).ToString();
item.quantity = reader.GetValue(5).ToString();
item.profit = reader.GetValue(6).ToString();
item.date = reader.GetValue(7).ToString();
items.Add(item);
}
command.Dispose();
return(items);
}
public PharmacySaleViewModel()
{
_selectedItem = null;
GetDataFromDatabase();
}