public List <clsCaLamViec_DTO> LayDanhSachCaLamViec()
{
List <clsCaLamViec_DTO> lstCa = new List <clsCaLamViec_DTO>();
SqlConnection con = ThaoTacDuLieu_DAO.TaoKetNoi();
string query = "SELECT * FROM CaLamViec";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
clsCaLamViec_DTO ca = new clsCaLamViec_DTO();
if (!reader.IsDBNull(0))
{
ca.MaCaLamViec = (string)reader["ma_ca_lam"];
}
if (!reader.IsDBNull(1))
{
ca.TenCaLamViec = (string)reader["ten_ca"];
}
if (!reader.IsDBNull(2))
{
ca.ThoiGianBatDau = DateTime.Parse(reader["thoi_gian_bat_dau"].ToString());
}
if (!reader.IsDBNull(3))
{
ca.ThoiGianKetThuc = DateTime.Parse(reader["thoi_gian_ket_thuc"].ToString());
}
if (!reader.IsDBNull(4))
{
ca.TrangThai = (bool)reader["trang_thai"];
}
lstCa.Add(ca);
}
ThaoTacDuLieu_DAO.DongKetNoi(con);
return(lstCa);
}
private void dgvLichLamViec_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dgvLichLamViec.Rows.Count > 0)
{
if (dgvLichLamViec.Columns[e.ColumnIndex].Name == "colHoTen")
{
dtoNV = lstNV.First(u => u.MaNhanVien == e.Value.ToString());
e.Value = dtoNV.HoTen;
}
if (dgvLichLamViec.Columns[e.ColumnIndex].Name == "colCa")
{
dtoCa = lstCa.First(u => u.MaCaLamViec == e.Value.ToString());
e.Value = dtoCa.TenCaLamViec;
}
if (dgvLichLamViec.Columns[e.ColumnIndex].Name == "colTrangThai")
{
dtoTTBanPhanCong = lstTTBanPhanCong.First(u => u.MaTrangThaiBanPhanCong == (int)e.Value);
e.Value = dtoTTBanPhanCong.TenTrangThaiBanPhanCong;
}
}
}
