public List <thong_tin_dienthoai> getListProductSearch(string tendienthoai)
{
List <thong_tin_dienthoai> products = new List <thong_tin_dienthoai>();
string sqlSearch1 = "select product.product_id, product.product_name, product.price,product.descriptions, product.image,category.category_name,product.category_id " +
"from product inner join category on product.category_id = category.category_id " +
"where product.product_name like '%" + @tendienthoai + "%'";
con.Open();
SqlCommand cmd = new SqlCommand(sqlSearch1, con);
cmd.Parameters.AddWithValue("tendienthoai", tendienthoai);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
thong_tin_dienthoai product = new thong_tin_dienthoai();
product.product_id = (int)dr["product_id"];
product.product_name = (string)dr["product_name"];
product.category_id = (int)dr["category_id"];
product.price = (int)dr["price"];
product.descriptions = (string)dr["descriptions"];
product.image = (string)dr["image"];
product.category_name = (string)dr["category_name"];
products.Add(product);
}
con.Close();
return(products);
}
//-----------------------------------------------truy vấn điện thoại----------------------------------
public List <thong_tin_dienthoai> laydsdt()
{
List <thong_tin_dienthoai> products = new List <thong_tin_dienthoai>();
string sqlDsdt = "select product.product_id, product.product_name, product.price,product.descriptions, product.image,category.category_name,product.category_id from product inner join category on product.category_id = category.category_id";
con.Open();
SqlCommand cmd = new SqlCommand(sqlDsdt, con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
thong_tin_dienthoai product = new thong_tin_dienthoai();
product.product_id = (int)dr["product_id"];
product.product_name = (string)dr["product_name"];
product.category_name = (string)dr["category_name"];
product.price = (int)dr["price"];
product.descriptions = (string)dr["descriptions"];
product.image = (string)dr["image"];
product.category_id = (int)dr["category_id"];
products.Add(product);
}
con.Close();
return(products);
}