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(); } }