private void BindProductRepeater()
{
SqlConnection con = new SqlConnection(ConnectString);
con.Open();
if (Request.QueryString["ürün"] != null)
{
string data = Request.QueryString["ürün"].ToString();
SqlDataAdapter sda = new SqlDataAdapter("select * from Table_Product where (ProductName like '%" + data + "%')or (id like '%" + data + "%')", con);
DataTable dt = new DataTable();
sda.Fill(dt);
RepeaterProducts.DataSource = dt;
RepeaterProducts.DataBind();
con.Close();
//SqlCommand cmd = new SqlCommand("select * from Table_Product P where P.ProductName=@id", con);
//cmd.Parameters.AddWithValue("@id", data);
//cmd.ExecuteNonQuery();
//DataTable dt = new DataTable();
//SqlDataAdapter sda = new SqlDataAdapter(cmd);
//sda.Fill(dt);
RepeaterProducts.DataSource = dt;
RepeaterProducts.DataBind();
}
else
{
Response.Redirect("~/Products.aspx");
}
}
private void BindProductRepeater()
{
SqlConnection con = new SqlConnection(ConnectString);
con.Open();
if (Request.QueryString["category"] != null)
{
int id = Convert.ToInt32(Request.QueryString["category"]);
SqlCommand cmd = new SqlCommand("select * from Table_Product P inner join Tbl_Category C on C.CategoryId=P.Category inner join Tbl_Brands B on B.BrandId=P.Brand where C.CategoryId=@id", con);
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
RepeaterProducts.DataSource = dt;
RepeaterProducts.DataBind();
}
else if (Request.QueryString["BrandId"] != null)
{
int id = Convert.ToInt32(Request.QueryString["BrandId"]);
SqlCommand cmd = new SqlCommand("select * from Table_Product P inner join Tbl_Brands B on B.BrandId=P.Brand where B.BrandId=@id", con);
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
RepeaterProducts.DataSource = dt;
RepeaterProducts.DataBind();
}
else if (Request.QueryString["ürün"] != null)
{
string data = Request.QueryString["ürün"].ToString();
SqlCommand cmd = new SqlCommand("select * from Table_Product where (ProductName like '% @data %')or (id like '%@data%')", con);
cmd.Parameters.AddWithValue("@data", data);
// SqlDataAdapter sda = new SqlDataAdapter("select * from Table_Product where (ProductName like '%" + data + "%')or (id like '%" + data + "%')", con);
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
RepeaterProducts.DataSource = dt;
RepeaterProducts.DataBind();
con.Close();
RepeaterProducts.DataSource = dt;
RepeaterProducts.DataBind();
}
else
{
SqlCommand cmd = new SqlCommand("select P.id, P.ProductName, P.ProductDescription,P.ProductImages,P.ProductPrice, C.CategoryName,B.Name from Table_Product P inner Join Tbl_Category C on C.CategoryId=P.Category inner join Tbl_Brands B on B.BrandId=P.Brand ", con);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
RepeaterProducts.DataSource = dt;
RepeaterProducts.DataBind();
con.Close();
}
}
private void LoadProducts()
{
String id_category = Request.QueryString["id"].ToString();
int converId = Int16.Parse(id_category);
if (converId < 4)
{
RepeaterProducts.DataSource = DB.getProductsByCategories(converId);
RepeaterProducts.DataBind();
}
else
{
Response.Redirect("Contact.aspx");
}
}
//do dữ liệu
//phantrang
private void NapDuLieu(int currPage, int recodperpage, int Pagesize)
{
DataSet ds = DB.StoreToDataSet(currPage, recodperpage, Pagesize);
DataTable dtbData = ds.Tables[0];
DataTable dtbPhanTrang = ds.Tables[1];
if (dtbData.Rows.Count > 0)
{
RepeaterProducts.DataSource = dtbData;
RepeaterProducts.DataBind();
if (dtbPhanTrang.Rows.Count > 0)
{
ltlPhanTrang.Text = dtbPhanTrang.Rows[0]["PhanTrang"] + "";
}
}
}
private void LoadProducts()
{
String id_category = Request.QueryString["id"].ToString();
int converId = Int16.Parse(id_category);
if (DB.getProductsByProducer(converId).Rows.Count > 0)
{
lblTitle.Visible = false;
RepeaterProducts.DataSource = DB.getProductsByProducer(converId);
RepeaterProducts.DataBind();
}
else
{
lblTitle.Visible = true;
lblTitle.Text = "Sản phẩm đã hết hàng.";
}
}
protected void ddl_sort_TextChanged(object sender, EventArgs e)
{
if (ddl_sort.Text == "Nome")
{
var list = Products.OrderBy(p => p.ProductName);
RepeaterProducts.DataSource = list.ToList();
RepeaterProducts.DataBind();
}
else if (ddl_sort.Text == "Preço Ascendente")
{
var list = Products.OrderBy(p => p.Price);
RepeaterProducts.DataSource = list.ToList();
RepeaterProducts.DataBind();
}
else if (ddl_sort.Text == "Preço Descendente")
{
var list = Products.OrderByDescending(p => p.Price);
RepeaterProducts.DataSource = list.ToList();
RepeaterProducts.DataBind();
}
}
private void LoadProducts()
{
RepeaterProducts.DataSource = DB.getLidtProduct();
RepeaterProducts.DataBind();
}
private void LoadAllProducts()
{
RepeaterProducts.DataSource = _productManager.GetAllProducts();
RepeaterProducts.DataBind();
}
void RepeaterProducts_Yukle()
{
RepeaterProducts.DataSource = repoProduct.GetAll().Select(s => new { s.ID, s.Name, s.Picture, s.Description, s.Price, s.Stock, Brand = s.Brand.Name }).OrderByDescending(o => o.ID).ToList();
RepeaterProducts.DataBind();
}
private void BindigRepeaterProducts(string product)
{
/*string query = " select Product.productId, Product.productName,Product.price, Product.description,Product.quantity," +
* "Category.description from Product inner join Category on Category.categoryId = Product.categoryId " +
* "order by Product.productName";*/
Products = new List <Product>();
SqlConnection myConn = new SqlConnection(ConfigurationManager.ConnectionStrings["OnShopCenterConnectionString"].ConnectionString);
SqlCommand mycommand = new SqlCommand
{
CommandType = CommandType.StoredProcedure,
CommandText = "GetProduct",
Connection = myConn
};
myConn.Open();
var reader = mycommand.ExecuteReader();
while (reader.Read())
{
string base64 = string.Empty;
if (reader[6] != null && reader[6].ToString().Length > 1)
{
base64 = Convert.ToBase64String((byte[])reader[6]);
}
string path;
if (string.IsNullOrEmpty(base64))
{
path = "../Config/images/no-image.png";
}
else
{
path = $"data:image/jpeg;base64,{base64}";
}
Products.Add(new Product
{
ProductId = reader.GetInt32(0),
ProductName = reader.GetString(1),
Price = reader.GetSqlMoney(2),
Description = reader.GetString(3),
Category = reader.GetString(5),
ImagePath = path
});
}
reader.Close();
myConn.Close();
var list = Products.Where(p => p.ProductName.ToLower().Contains(product));
RepeaterProducts.DataSource = list.ToList();
RepeaterProducts.DataBind();
}