//-----------------------------------------truy vấn chi tiết điện thoại --------------------------------
public List <product_detail_hienthi> danhSachDienThoaiTheoMa(int product_id)
{
List <product_detail_hienthi> product_Details = new List <product_detail_hienthi>();
string dsdttheoma = "select product.product_id,product.product_name,color.color_name,product_detail.quantity, product.image,product_detail.product_detail_id from product_detail inner join product on product_detail.product_id = product.product_id inner join color on product_detail.color_id = color.color_id where product_detail.product_id =@product_id";
con.Open();
SqlCommand sqlCommand = new SqlCommand(dsdttheoma, con);
sqlCommand.Parameters.AddWithValue("product_id", product_id);
SqlDataReader dr = sqlCommand.ExecuteReader();
while (dr.Read())
{
product_detail_hienthi product_Detail_Hienthi = new product_detail_hienthi();
product_Detail_Hienthi.product_detail_id = (int)dr["product_detail_id"];
product_Detail_Hienthi.color_name = (string)dr["color_name"];
product_Detail_Hienthi.image = (string)dr["image"];
product_Detail_Hienthi.product_name = (string)dr["product_name"];
product_Detail_Hienthi.quantity = (int)dr["quantity"];
product_Detail_Hienthi.product_id = (int)dr["product_id"];
product_Details.Add(product_Detail_Hienthi);
}
con.Close();
return(product_Details);
}
protected void edit_Click(object sender, EventArgs e)
{
product_detail_hienthi product_Detail_Hienthi = new product_detail_hienthi();
product_Detail_Hienthi.color_id = int.Parse(dsmau.SelectedValue);
product_Detail_Hienthi.quantity = int.Parse(soluong.Value);
product_Detail_Hienthi.product_detail_id = int.Parse(product_detail_id.Value);
DataUtils.suaSoLuongVaMau(product_Detail_Hienthi);
}
protected void edit_click(object sender, CommandEventArgs e1)
{
if (e1.CommandName == "edit")
{
int productDetailId = Convert.ToInt16(e1.CommandArgument);
product_detail_hienthi product_detail_hienthi = dataUtils.layProductDetail(productDetailId);
Session["product_detail_hienthi"] = product_detail_hienthi;
Response.Redirect("editProductDetail.aspx");
}
}
public void suaSoLuongVaMau(product_detail_hienthi product_Detail_Hienthi)
{
string sqlSua = "update product_detail set color_id=@color_id,quantity=@quantity where product_detail_id=@product_detail_id";
con.Open();
SqlCommand cmd = new SqlCommand(sqlSua, con);
cmd.Parameters.AddWithValue("color_id", product_Detail_Hienthi.color_id);
cmd.Parameters.AddWithValue("quantity", product_Detail_Hienthi.quantity);
cmd.Parameters.AddWithValue("product_detail_id", product_Detail_Hienthi.product_detail_id);
cmd.ExecuteNonQuery();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
product_detail_hienthi product_Detail_Hienthi = (product_detail_hienthi)Session["product_detail_hienthi"];
product_name.Text = product_Detail_Hienthi.product_name;
soluong.Value = product_Detail_Hienthi.quantity.ToString();
product_detail_id.Value = product_Detail_Hienthi.product_detail_id.ToString();
dsmau.DataSource = DataUtils.GetColors();
dsmau.DataValueField = "color_id";
dsmau.DataTextField = "color_name";
dsmau.DataBind();
dsmau.SelectedValue = product_Detail_Hienthi.color_id.ToString();
quayvetrangchitiet.PostBackUrl = "~/product-detail-ad.aspx?product_id=" + product_Detail_Hienthi.product_id;
}
}
public product_detail_hienthi layProductDetail(int productDetailId)
{
product_detail_hienthi product_detail_hienthi = new product_detail_hienthi();
string ds = "select product_detail.quantity,color.color_name,product.product_name,color.color_id,product_detail.product_detail_id,product_detail.product_id from product_detail inner join product on product_detail.product_id = product.product_id inner join color on product_detail.color_id = color.color_id where product_detail.product_detail_id = @product_detail_id";
con.Open();
SqlCommand cmd = new SqlCommand(ds, con);
cmd.Parameters.AddWithValue("product_detail_id", productDetailId);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
product_detail_hienthi.product_detail_id = (int)dr["product_detail_id"];
product_detail_hienthi.product_name = (string)dr["product_name"];
product_detail_hienthi.color_name = (string)dr["color_name"];
product_detail_hienthi.quantity = (int)dr["quantity"];
product_detail_hienthi.color_id = (int)dr["color_id"];
product_detail_hienthi.product_id = (int)dr["product_id"];
}
con.Close();
return(product_detail_hienthi);
}
