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