private void btnXoa_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn có muốn xóa không?", "Cảnh Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { BCDT bc = new BCDT(); bc.SOPBC = txtSPBC.Text; if (bllbc.DeletePBCDT(bc)) { ShowAllPBCDT(); } else { MessageBox.Show("Đã xảy ra lỗi xin thử lại sau", "Thông Báo Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } }
private void btnThem_Click(object sender, EventArgs e) { if (CheckData()) { BCDT bc = new BCDT(); bc.SOPBC = txtSPBC.Text; bc.MAKHO = txtMK.Text; bc.SOPX = txtSPX.Text; if (bllbc.InsertPBCDT(bc)) { ShowAllPBCDT(); } else { MessageBox.Show("Đã có lỗi xin thử lại sau", "Thông Báo Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } }
public bool DeletePBCDT(BCDT bc) { string sql = "DELETE PHIEUBCDT WHERE SOPBC = @SOPBC "; SqlConnection con = dc.getConnect(); try { cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.Add("@SOPBC", SqlDbType.NChar).Value = bc.SOPBC; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { return(false); } return(true); }
private void btnSua_Click(object sender, EventArgs e) { if (CheckData()) { BCDT bc = new BCDT(); bc.SOPBC = txtSPBC.Text; bc.MAKHO = txtMK.Text; bc.SOPX = txtSPX.Text; bc.TUNGAY = DateTime.Parse(dtpTN.Text); bc.DENNGAY = DateTime.Parse(dtpDN.Text); if (bllbc.UpdatePBCDT(bc)) { ShowAllPBCDT(); } else { MessageBox.Show("Đã có lỗi xin thử lại sau", "Thông Báo Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } }
public bool UpdatePBCDT(BCDT bc) { string sql = "UPDATE PHIEUBCDT SET MAKHO=@MAKHO, TUNGAY=@TUNGAY, DENNGAY=@DENNGAY, SOPX=@SOPX WHERE SOPBC = @SOPBC "; SqlConnection con = dc.getConnect(); try { cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.Add("@SOPBC", SqlDbType.NChar).Value = bc.SOPBC; cmd.Parameters.Add("@MAKHO", SqlDbType.NChar).Value = bc.MAKHO; cmd.Parameters.Add("@TUNGAY", SqlDbType.Date).Value = bc.TUNGAY; cmd.Parameters.Add("@DENNGAY", SqlDbType.Date).Value = bc.DENNGAY; cmd.Parameters.Add("@SOPX", SqlDbType.NChar).Value = bc.SOPX; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { return(false); } return(true); }
public bool InsertPBCDT(BCDT bc) { string sql = "INSERT INTO PHIEUBCDT (SOPBC, MAKHO, TUNGAY, DENNGAY, SOPX) VALUES (@SOPBC, @MAKHO, @TUNGAY, @DENNGAY, @SOPX) "; SqlConnection con = dc.getConnect(); try { cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.Add("@SOPBC", SqlDbType.NChar).Value = bc.SOPBC; cmd.Parameters.Add("@MAKHO", SqlDbType.NChar).Value = bc.MAKHO; cmd.Parameters.Add("@TUNGAY", SqlDbType.Date).Value = bc.TUNGAY; cmd.Parameters.Add("@DENNGAY", SqlDbType.Date).Value = bc.DENNGAY; cmd.Parameters.Add("@SOPX", SqlDbType.NChar).Value = bc.SOPX; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { return(false); } return(true); }
public bool DeletePBCDT(BCDT bc) { return(dalbc.DeletePBCDT(bc)); }
public bool UpdatePBCDT(BCDT bc) { return(dalbc.UpdatePBCDT(bc)); }
public bool InsertPBCDT(BCDT bc) { return(dalbc.InsertPBCDT(bc)); }