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