/// them đơn bảo hành public static void ThemDonBaoHanh(SANPHAMDTO dbh) { SqlConnection cnn = sqlconnectionData.hamKetNoi(); SqlCommand cmd = new SqlCommand("Them_san_pham_bao_hanh", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MaSP", SqlDbType.Int); cmd.Parameters.Add("@MaKH", SqlDbType.Int); cmd.Parameters.Add("@TinhTrang", SqlDbType.NVarChar, 100); cmd.Parameters.Add("@MaNCC", SqlDbType.Int); cmd.Parameters.Add("@NgayBaoHanh", SqlDbType.DateTime); cmd.Parameters.Add("@HinhThucBH", SqlDbType.NVarChar, 5); //gán giá trị cmd.Parameters["@MaSP"].Value = dbh.MaSP1; cmd.Parameters["@MaKH"].Value = dbh.MaKH1; cmd.Parameters["@TinhTrang"].Value = dbh.TinhTrang1; cmd.Parameters["@MaNCC"].Value = dbh.MaNCC1; cmd.Parameters["@NgayBaoHanh"].Value = dbh.NgayBaoHanh1; cmd.Parameters["@HinhThucBH"].Value = dbh.HinhThucBH1; cnn.Open(); cmd.ExecuteNonQuery(); cnn.Close(); }
private void btnThem_Click(object sender, EventArgs e) { SANPHAMDTO dbh = new SANPHAMDTO(); dbh.MaSP1 = int.Parse(txtMaSP.Text); dbh.MaKH1 = int.Parse(txtMaKH.Text); dbh.TinhTrang1 = txtTinhTrangBH.Text; dbh.MaNCC1 = int.Parse(txtMaNCC.Text); dbh.NgayBaoHanh1 = txtNgayBaoHanh.Value; dbh.HinhThucBH1 = txtHinhThuc.Text; NhanVienBaoHanhBUS.ThemDonBaoHanh(dbh); MessageBox.Show("Đã thêm thành công", "Thông báo"); }
// them don bao hanh public static void ThemDonBaoHanh(SANPHAMDTO dbh) { NhanVienBaoHanhDAO.ThemDonBaoHanh(dbh); }