private void btnThem_Click(object sender, EventArgs e) { SanPhamBus bussp = new SanPhamBus(); SanPhamEntity sp = new SanPhamEntity(); KetNoiCSDL con = new KetNoiCSDL(); try { sp.MaSP = con.SinhMa("SANPHAM", "SP"); sp.TenSP = txtTenSP.Text; sp.SoLuong = int.Parse(txtSoLuong.Text); sp.GiaBan = int.Parse(txtGiaBan.Text); sp.GiaNhap = int.Parse(txtGiaNhap.Text); sp.MaLH = cboLoaiHang.SelectedValue.ToString(); sp.NhaCC = cboNhaCC.SelectedValue.ToString(); sp.NSX = dtNgaySX.Value.ToString(); sp.MoTa = rtbMoTa.Text; sp.HinhAnh = null; bussp.ThemSanPham(sp); MessageBox.Show("Nhập hàng thành công", "Thông báo"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void XoaNhanVien(SanPhamEntity nv) { KetNoiCSDL.MoKetNoi(); string sql = @"DELETE SANPHAM WHERE MaSP=@MaSP"; SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect); cmd.Parameters.AddWithValue("@MaSP", nv.MaSP); cmd.ExecuteNonQuery(); KetNoiCSDL.DongKetNoi(); }
public void ThemSanPham(SanPhamEntity nv) { KetNoiCSDL.MoKetNoi(); string sql = "INSERT INTO SANPHAM(MaSP, TenSP,MaLH,SoLuong,GiaNhap,GiaBan,MoTa,NSX,NhaCC) VALUES(@MaSP,@TenSP,@MaLH,@SoLuong,@GiaNhap,@GiaBan,@MoTa,@NSX,@NhaCC)"; SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect); // cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaSP", nv.MaSP); cmd.Parameters.AddWithValue("@TenSP", nv.TenSP); cmd.Parameters.AddWithValue("@MaLH", nv.MaLH); cmd.Parameters.AddWithValue("@SoLuong", nv.SoLuong); cmd.Parameters.AddWithValue("@GiaNhap", nv.GiaNhap); cmd.Parameters.AddWithValue("@GiaBan", nv.GiaBan); cmd.Parameters.AddWithValue("@MoTa", nv.MoTa); cmd.Parameters.AddWithValue("@NSX", nv.NSX); cmd.Parameters.AddWithValue("@NhaCC", nv.NhaCC); cmd.ExecuteNonQuery(); KetNoiCSDL.DongKetNoi(); }
public void SuaSanPham(SanPhamEntity nv) { KetNoiCSDL.MoKetNoi(); string sql = "UPDATE SANPHAM SET TenSP=@TenSP, MaLH =@MaLH, SoLuong =@SoLuong, GiaNhap =@GiaNhap, GiaBan =@GiaBan, MoTa =@MoTa,NSX=@NSX,NhaCC=@NhaCC Where MaSP=@MaSP"; SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect); //cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TenSP", nv.TenSP); cmd.Parameters.AddWithValue("@MaLH", nv.MaLH); cmd.Parameters.AddWithValue("@SoLuong", nv.SoLuong); cmd.Parameters.AddWithValue("@GiaNHap", nv.GiaNhap); cmd.Parameters.AddWithValue("@GiaBan", nv.GiaBan); cmd.Parameters.AddWithValue("@MoTa", nv.MoTa); cmd.Parameters.AddWithValue("@NSX", nv.NSX); cmd.Parameters.AddWithValue("@NhaCC", nv.NhaCC); cmd.ExecuteNonQuery(); KetNoiCSDL.DongKetNoi(); }