public List <Product> ConsulProductsEnabled()
{
List <Product> products = new List <Product>();
string query = "Call CompararProducto()";
DBConection connection = new DBConection();
connection.Connection().Open();
MySqlDataAdapter commandDatabase = new MySqlDataAdapter(query, connection.Connection());
DataSet dataSet = new DataSet();
commandDatabase.Fill(dataSet, "Product");
foreach (DataTable tabla in dataSet.Tables)
{
foreach (DataRow dr in tabla.Rows)
{
Product product = new Product(dr.ItemArray[0].ToString(), Convert.ToInt32(dr.ItemArray[1].ToString()));
products.Add(product);
}
}
connection.Connection().Close();
return(products);
}
/// <summary>
/// Metodo encargado de consultar a la base de datos los usuarios
/// </summary>
/// <returns>Lista de usuarios</returns>
///
public List <User> ConsultUsersList()
{
List <User> users = new List <User>();
string query = "Call ConsultarListaUsuarios()";
DBConection connection = new DBConection();
connection.Connection().Open();
MySqlDataAdapter commandDatabase = new MySqlDataAdapter(query, connection.Connection());
DataSet dataSet = new DataSet();
commandDatabase.Fill(dataSet, "User");
foreach (DataTable tabla in dataSet.Tables)
{
foreach (DataRow dr in tabla.Rows)
{
User user = new User(Int32.Parse(dr.ItemArray[0].ToString()), dr.ItemArray[1].ToString(), dr.ItemArray[2].ToString(), dr.ItemArray[3].ToString(), dr.ItemArray[4].ToString(), dr.ItemArray[5].ToString());
users.Add(user);
}
}
connection.Connection().Close();
return(users);
}