private void btnTimKiem_Click(object sender, EventArgs e)
{
ChamCong_DTO cc = new ChamCong_DTO();
cc.Manv = cbbmanv.Text;
cc.Ngaycong = dtpngaycong.Text;
cc.Ghichu = txtghichu.Text;
dtgrvchamcong.DataSource = chamCong_BUL.findChamCong(cc);
}
private void btnXoa_Click(object sender, EventArgs e)
{
ChamCong_DTO chamCong = new ChamCong_DTO();
chamCong.Manv = cbbmanv.Text;
chamCong.Ngaycong = dtpngaycong.Text;
if (chamCong_BUL.deleteChamcong(chamCong))
{
MessageBox.Show("Xóa thành công");
}
else
{
MessageBox.Show("Xóa không thành công");
}
hienthi();
}
private void btnSua_Click(object sender, EventArgs e)
{
ChamCong_DTO chamCong = new ChamCong_DTO();
chamCong.Manv = cbbmanv.Text;
chamCong.Ngaycong = dtpngaycong.Text;
chamCong.Ghichu = txtghichu.Text;
if (chamCong_BUL.updateChamcong(chamCong))
{
MessageBox.Show("Sửa thành công");
}
else
{
MessageBox.Show("Sửa không thành công");
}
hienthi();
}
private void btnThem_Click_1(object sender, EventArgs e)
{
ChamCong_DTO chamCong = new ChamCong_DTO();
chamCong.Manv = cbbmanv.Text;
chamCong.Ngaycong = dtpngaycong.Text;
chamCong.Ghichu = txtghichu.Text;
if (chamCong_BUL.insertChamcong(chamCong))
{
MessageBox.Show("Thêm thành công");
}
else
{
MessageBox.Show("Thêm không thành công");
}
hienthi();
}
public Boolean deleteChamCong(ChamCong_DTO c)
{
String sql = "DELETE FROM cong WHERE manv = @manv AND ngaycong = @ngaycong";
try
{
SqlConnection conn = getConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@manv", c.Manv);
cmd.Parameters.AddWithValue("@ngaycong", c.Ngaycong);
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException)
{
}
return(false);
}
public DataTable findChamCong(ChamCong_DTO c)
{
try
{
string sql = "SELECT * FROM dbo.Fn_Find() WHERE manv = '" + c.Manv + "' AND ghichu LIKE '%" + c.Ghichu + "%'";
SqlConnection conn = getConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(dt);
}
catch (SqlException)
{
}
return(null);
}
public Boolean insertChamCong(ChamCong_DTO c)
{
String sql = "INSERT INTO cong VALUES (@manv, @ngaycong, @ghichu)";
try
{
SqlConnection conn = getConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@manv", c.Manv);
cmd.Parameters.AddWithValue("@ngaycong", c.Ngaycong);
cmd.Parameters.AddWithValue("@ghichu", c.Ghichu);
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException)
{
}
return(false);
}
public DataTable findChamCong(ChamCong_DTO c)
{
return(cc.findChamCong(c));
}
public Boolean deleteChamcong(ChamCong_DTO c)
{
return(cc.deleteChamCong(c));
}
public Boolean updateChamcong(ChamCong_DTO c)
{
return(cc.updateChamCong(c));
}
public Boolean insertChamcong(ChamCong_DTO c)
{
return(cc.insertChamCong(c));
}
