public List <Product> GetSingleProducts()
{
var products = new List <Product>();
var query = $"SELECT * FROM single_products_per_routine WHERE ROUTINE_idRoutine = {IdRoutine}";
var consult = DbConnection.consultar_datos(query);
if (consult == null)
{
return(products);
}
for (var index = 0; index < consult.Rows.Count; index++)
{
var row = consult.Rows[index];
var id = (int)row[0];
var name = (string)row[1];
var price = (decimal)row[2];
var points = (int)row[3];
var image = DataControl.Base64StringToImage((string)row[4]);
var p = new Product(id, name, price, points, image);
products.Add(p);
}
return(products);
}
public List <Product> GetAvailableProducts()
{
var products = new List <Product>();
var query = "SELECT products_view.* FROM products_view " +
"LEFT JOIN " +
"routine_has_product ON routine_has_product.PRODUCT_idProduct = products_view.idProduct " +
$"WHERE routine_has_product.ROUTINE_idRoutine IS NULL OR routine_has_product.ROUTINE_idRoutine != {IdRoutine}";
var consult = DbConnection.consultar_datos(query);
if (consult == null)
{
return(products);
}
for (var index = 0; index < consult.Rows.Count; index++)
{
var row = consult.Rows[index];
var id = (int)row[0];
var name = (string)row[1];
var price = (decimal)row[2];
var points = (int)row[3];
var image = DataControl.Base64StringToImage((string)row[4]);
var p = new Product(id, name, price, points, image);
products.Add(p);
}
return(products);
}
public static List <Product> GetAllProducts()
{
var products = new List <Product>();
var query = "SELECT * FROM products_view";
var consult = DbConnection.consultar_datos(query);
if (consult == null)
{
return(products);
}
for (var index = 0; index < consult.Rows.Count; index++)
{
var row = consult.Rows[index];
var id = (int)row[0];
var name = (string)row[1];
var price = (decimal)row[2];
var points = (int)row[3];
var image = DataControl.Base64StringToImage((string)row[4]);
var p = new Product(id, name, price, points, image);
products.Add(p);
}
return(products);
}
private void dgvProducts_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
var row = dgvProducts.CurrentRow; //Obtiene la fila seleccionada
if (row == null || row.Index == -1 || e.RowIndex == -1)
{
return;
}
//Obtiene los datos de la fila seleccioanda y la convierte a objeto de PRODUCTO
var idProduct = int.Parse(row.Cells[0].Value.ToString());
var nameProduct = row.Cells[1].Value.ToString();
var initialPrice = decimal.Parse(row.Cells[2].Value.ToString());
var pointsValue = int.Parse(row.Cells[3].Value.ToString());
var image = DataControl.Base64StringToImage(row.Cells[4].Value.ToString());
var product = new Product
{
IdProduct = idProduct,
Name = nameProduct,
Price = initialPrice,
Points = pointsValue,
ImageProduct = image
};
var form = new FrmProduct(product, this); //Instancia un nuevo formulario para agregar productos
form.Show(); //Abre el formulario
}
public static Product GetProductById(int idProduct)
{
var product = new Product();
var query = $"SELECT * FROM products_view WHERE idProduct = {idProduct}";
var productDataTable = DbConnection.consultar_datos(query);
if (productDataTable == null)
{
return(product);
}
foreach (DataRow row in productDataTable.Rows)
{
var image = DataControl.Base64StringToImage((string)row[4]);
product = new Product((int)row[0], (string)row[1], (decimal)row[2], (int)row[3], image);
}
return(product);
}