protected void capnhat_click(object sender, EventArgs e)
{
Connect data = new Connect();
try
{
data.conect();
WEBBANHANG.SanPham sp = new WEBBANHANG.SanPham();
sp.Iddanhmuc = int.Parse(dropDanhMucSanPham.SelectedItem.Value);
sp.Ten = txtTenSanPham.Text;
sp.Giasanpham = int.Parse(txtGia.Text);
sp.Mota = txtmota.Text;
sp.Dulieuhinhsanpham = fileuploadHinhSanPham.FileName;
string sql = "insert into SanPham(tenSP,DanhMuc,GiaSP,ChiTiet,AnhSP) values(N'" + sp.Ten + "','" + sp.Iddanhmuc + "','" + sp.Giasanpham + "',N'" + sp.Mota + "','" + sp.Dulieuhinhsanpham + "')";
data.ExeCuteNonQuery(sql);
Response.Write("<script>alert('Đã thêm thành công !')</script>");
}
catch (SqlException sqle)
{
Response.Write("<script>alert('Thêm Không thành công !')</script>");;
}
finally
{
data.disconnect();
}
}
protected void capnhat_click(object sender, EventArgs e)
{
int idSP = int.Parse(Request.QueryString["id"]);
Connect data = new Connect();
try
{
data.conect();
WEBBANHANG.SanPham sp = new WEBBANHANG.SanPham();
if (idDanhMuc != int.Parse(dropDanhMucSanPham.SelectedItem.Value))
{
sp.Iddanhmuc = int.Parse(dropDanhMucSanPham.SelectedItem.Value);
}
else
{
sp.Iddanhmuc = idDanhMuc;
}
sp.Ten = txtTenSanPham.Text;
sp.Giasanpham = int.Parse(txtGia.Text);
sp.Mota = txtmota.Text;
if (fileuploadHinhSanPham.FileName != "")
{
if (fileuploadHinhSanPham.FileName != hinh)
{
sp.Dulieuhinhsanpham = fileuploadHinhSanPham.FileName;
}
}
else
{
sp.Dulieuhinhsanpham = hinh;
}
string sql = "update SanPham set tenSP = N'" + sp.Ten + "',danhMuc ='" + sp.Iddanhmuc + "',GiaSP ='" + sp.Giasanpham + "',ChiTiet = N'" + sp.Mota + "', AnhSP = '" + sp.Dulieuhinhsanpham + "' where idSP='" + idSP + "'";
data.ExeCuteNonQuery(sql);
Response.Write("<script>alert('Cập Nhật thành công !')</script>");
}
catch
{
Response.Write("<script>alert('Cập nhật thất bại!')</script>");
}
finally
{
data.disconnect();
}
}
