public DataTable getAllProductos(string nombre)
{
dbConection conn = new dbConection();
string query = @"SELECT * from productos where nombre = @nombre";
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@nombre", nombre);
dt = conn.queryCmd(cmd);
return(dt);
}
public DataTable productosPorCat(int cat_id)
{
dbConection conn = new dbConection();
string query = @"SELECT * from productos where categoria_id = @cat_id";
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@cat_id", cat_id);
dt = conn.queryCmd(cmd);
return(dt);
}
public int getId(string nombre)
{
dbConection function = new dbConection();
int id;
string query = @"select * from productos where nombre = @proNombre";
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@proNombre", nombre);
dt = function.queryCmd(cmd);
id = Int32.Parse(dt.Rows[0]["id"].ToString());
return((int)id);
}