public IEnumerable <OsVersion> GetOsVersion()
{
List <OsVersion> list = new List <OsVersion>();
using (MySqlConnection conn = singDatabase.GetConnection())
{
//conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM OSVERSIONS", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new OsVersion()
{
id = Convert.ToInt32(reader["ID"]),
Description = reader["DESCRIPTION"].ToString()
});
}
}
}
return(list);
}
public IEnumerable <Products> getProducts()
{
List <Products> products = new List <Products>();
using (MySqlConnection conn = singDatabase.GetConnection())
{
//conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM PRODUCTS WHERE ACTIVE = TRUE", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
products.Add(new Products()
{
Id = Convert.ToInt32(reader["ID"]),
Description = reader["DESCRIPTION"].ToString(),
Active = Convert.ToBoolean(reader["ACTIVE"])
});
}
}
}
return(products);
}
