private void DataGridView1Config(TreeNode node)
{
ATINChamCongEntities context = new ATINChamCongEntities();
if ((node.Tag as PhongBan).MaPhongBan == 0 && node.Text.Trim() == "Nhân viên mới")
{
var lstNguoi = context.spGetAllNguoi().Where(x => x.TrangThaiHoatDong == 2).ToList();
List <ViewSapXepLichTrinh> viewSapXepLichTrinhs = new List <ViewSapXepLichTrinh>();
foreach (var nguoi in lstNguoi)
{
viewSapXepLichTrinhs.Add(context.spGetViewSapXepLichTrinhByNguoi(nguoi.MaNguoi).FirstOrDefault());
}
dataGridView1.DataSource = viewSapXepLichTrinhs;
if (viewSapXepLichTrinhs.Count < 1)
{
return;
}
barEditItem3.EditValue = viewSapXepLichTrinhs.Count.ToString();
}
if ((node.Tag as PhongBan).MaPhongBan == 0 && node.Text.Trim() == "ATI")
{
var lstNguoi = context.spGetAllNguoi().ToList();
List <ViewSapXepLichTrinh> viewSapXepLichTrinhs = new List <ViewSapXepLichTrinh>();
foreach (var nguoi in lstNguoi)
{
viewSapXepLichTrinhs.Add(context.spGetViewSapXepLichTrinhByNguoi(nguoi.MaNguoi).FirstOrDefault());
}
dataGridView1.DataSource = viewSapXepLichTrinhs;
if (viewSapXepLichTrinhs.Count < 1)
{
return;
}
barEditItem3.EditValue = viewSapXepLichTrinhs.Count.ToString();
}
if ((node.Tag as PhongBan).MaPhongBan == 0 && node.Text.Trim() == "Văn phòng")
{
var lstNguoi = context.spGetAllNguoi().Where(x => x.TrangThaiHoatDong == 1).ToList();
List <ViewSapXepLichTrinh> viewSapXepLichTrinhs = new List <ViewSapXepLichTrinh>();
foreach (var nguoi in lstNguoi)
{
viewSapXepLichTrinhs.Add(context.spGetViewSapXepLichTrinhByNguoi(nguoi.MaNguoi).FirstOrDefault());
}
dataGridView1.DataSource = viewSapXepLichTrinhs;
if (viewSapXepLichTrinhs.Count < 1)
{
return;
}
barEditItem3.EditValue = viewSapXepLichTrinhs.Count.ToString();
}
else if ((node.Tag as PhongBan).MaPhongBan != 0)
{
var lstNguoi = context.spGetAllNguoi().Where(x => (x.TrangThaiHoatDong == 1) && (x.MaPhongBan == (node.Tag as PhongBan).MaPhongBan)).ToList();
List <ViewSapXepLichTrinh> viewSapXepLichTrinhs = new List <ViewSapXepLichTrinh>();
foreach (var nguoi in lstNguoi)
{
viewSapXepLichTrinhs.Add(context.spGetViewSapXepLichTrinhByNguoi(nguoi.MaNguoi).FirstOrDefault());
}
dataGridView1.DataSource = viewSapXepLichTrinhs;
if (viewSapXepLichTrinhs.Count < 1)
{
return;
}
barEditItem3.EditValue = viewSapXepLichTrinhs.Count.ToString();
}
dataGridView1.Columns["MaSapXep"].Visible = false;
dataGridView1.Columns["Checkbox"].DisplayIndex = 0;
dataGridView1.Columns["MaNguoi"].DisplayIndex = 1;
dataGridView1.Columns["MaChamCong"].DisplayIndex = 2;
dataGridView1.Columns["HoTen"].DisplayIndex = 3;
//dataGridView1.Columns["MaLichTrinh"].Visible = false;
dataGridView1.Columns["col"].DisplayIndex = 4;
dataGridView1.Refresh();
}
