public Sanpham GetsanphamByMASP(string strSP)
 {
     Sanpham sp = null;
     try
     {
         if (conn.State != ConnectionState.Open) conn.Open();
         OleDbCommand cmd = new OleDbCommand("select * from tbSanPham where masp=@masp order by MaSP ASC", conn);
         cmd.Parameters.Add("@masp", OleDbType.BSTR).Value = strSP;
         OleDbDataReader rd = cmd.ExecuteReader();
         if(rd.Read())
         {
             sp = new Sanpham();
             sp.Masanpham = rd["MaSP"].ToString();
             sp.Tensanpham = rd["TenSP"].ToString();
             sp.Soluong = (int)rd["SoLuong"];
             sp.DonGia = (int)rd["DonGia"];
             sp.XuatXu = rd["XuatXu"].ToString();
             sp.MaDanhMuc = rd["MaDM"].ToString();
             rd.Close();
         }
     }
     catch (Exception e)
     {
         conn.Close();
         Console.WriteLine(e.ToString());
     }
     return sp;
 }
 private void btnXoa_Click(object sender, EventArgs e)
 {
     int sl = Convert.ToInt32(txtSoluong.Text);
     int dg = Convert.ToInt32(txtDongia.Text);
     Sanpham sp = new Sanpham(txtMasp.Text, txtTensp.Text, sl, dg, txtXuatxu.Text, comboDanhmuc.SelectedValue.ToString());
     if (objSP.XoaSanPham(sp))
     {
         MessageBox.Show("Xóa sản phẩm thành công");
         dataGridView1.DataSource = objSP.GetSanPhamByMADM(SanhForm.strSanh_chon);
     }
     else
     {
         MessageBox.Show("Xóa sản phẩm thất bại");
     }
 }
 public bool Addsanpham(Sanpham sp)
 {
     try
     {
         if (conn.State != ConnectionState.Open) conn.Open();
         OleDbCommand cmd = new OleDbCommand("INSERT INTO tbSANPHAM([MASP],[TENSP],[SOLUONG],[DONGIA],[XUATXU],[MADM]) VALUES(@masp, @tensp, @soluong, @dongia, @xuatxu, @madm)", conn);
         cmd.Parameters.Add("@masp", OleDbType.BSTR).Value = sp.Masanpham;
         cmd.Parameters.Add("@tensp", OleDbType.BSTR).Value = sp.Tensanpham;
         cmd.Parameters.Add("@soluong", OleDbType.Numeric).Value = sp.Soluong;
         cmd.Parameters.Add("@dongia", OleDbType.Numeric).Value = sp.DonGia;
         cmd.Parameters.Add("@xuatxu", OleDbType.BSTR).Value = sp.XuatXu;
         cmd.Parameters.Add("@madm", OleDbType.BSTR).Value = sp.MaDanhMuc;
         cmd.ExecuteNonQuery();
         conn.Close();
         return true;
     }
     catch (Exception e)
     {
         conn.Close();
         return false;
     }
 }
 public bool Xoasanpham(Sanpham sp)
 {
     try
     {
         if (conn.State != ConnectionState.Open) conn.Open();
         string strcmd = "DELETE FROM tbSANPHAM where MASP='" + sp.Masanpham + "'";
         OleDbCommand cmd = new OleDbCommand(strcmd, conn);
         cmd.ExecuteNonQuery();
         conn.Close();
         return true;
     }
     catch (Exception e)
     {
         conn.Close();
         return false;
     }
 }
 public bool Updatesanpham(Sanpham sp)
 {
     try
     {
         if (conn.State != ConnectionState.Open) conn.Open();
         string strcmd = "UPDATE tbSANPHAM SET TENSP='" + sp.Tensanpham + "', SOLUONG='" + sp.Soluong.ToString() + "', DONGIA='" + sp.DonGia.ToString() + "', XUATXU='" + sp.XuatXu + "',MADM='" + sp.MaDanhMuc + "' where MASP='" + sp.Masanpham + "'";
         OleDbCommand cmd = new OleDbCommand(strcmd, conn);
         cmd.ExecuteNonQuery();
         conn.Close();
         return true;
     }
     catch (Exception e)
     {
         conn.Close();
         return false;
     }
 }
 public bool XoaSanPham(Sanpham sp)
 {
     return objSP.Xoasanpham(sp);
 }
 public bool UpdateSanPham(Sanpham sp)
 {
     return objSP.Updatesanpham(sp);
 }
 public bool AddSanPham(Sanpham sp)
 {
     return objSP.Addsanpham(sp);
 }