public bool ThemKiemTra(DTO_KiemTra kt)
{
try
{
_conn.Open();
// Create List Sql Parameter
string cm = "insert into KiemTra values(@ID,@KiemTra,@HoaDon)";
SqlCommand cmd;
cmd = new SqlCommand(cm, _conn);
cmd.Parameters.AddWithValue("@ID", kt.kiemtra_id);
cmd.Parameters.AddWithValue("@KiemTra", kt.kiemtra_tenkiemtra);
cmd.Parameters.AddWithValue("@HoaDon", kt.kiemtra_donGia);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_conn.Close();
}
return(false);
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
if (txtID.Text != "")
{
if (busKT.CheckTrung(txtID.Text) == true)
{
MessageBox.Show("Trung ID");
txtID.Select();
}
else
{
if (txtDonGia.Text == "")
{
txtDonGia.Text = "0";
}
DTO_KiemTra th = new DTO_KiemTra(Convert.ToInt32(txtID.Text), txtTenKiemTra.Text, Convert.ToInt32(txtDonGia.Text));
if (busKT.ThemKiemTra(th))
{
MessageBox.Show("Thêm thành công");
this.kiemTraTableAdapter.Fill(this.quanLyPhongKhamDataSet.KiemTra);
}
else
{
MessageBox.Show("Thêm ko thành công");
}
}
}
else
{
MessageBox.Show("Chưa nhập ID");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool ThemKiemTra(DTO_KiemTra kiemtra)
{
return(dal_kiemtra.ThemKiemTra(kiemtra));
}
