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