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