private void DataGridView2Config(ViewSapXepLichTrinh viewSapXepLichTrinh)
{
//dataGridView2.Refresh();
ATINChamCongEntities context = new ATINChamCongEntities();
var lstSapXepLTT = context.spGetSapXepLichTrinhTamByNguoi(viewSapXepLichTrinh.MaNguoi).ToList();
var lstLichTrinh = context.spGetAllLichTrinh().ToList();
dataGridView2.DataSource = lstSapXepLTT;
if (lstSapXepLTT.Count < 1)
{
return;
}
dataGridView2.Columns["TuNgay"].DisplayIndex = 0;
dataGridView2.Columns["DenNgay"].DisplayIndex = 1;
dataGridView2.Columns["TenLichTrinh"].DisplayIndex = 2;
foreach (DataGridViewRow row in dataGridView2.Rows)
{
foreach (var lichtrinh in lstLichTrinh)
{
if ((row.DataBoundItem as SapXepLichTrinhTam).MaLichTrinh == lichtrinh.MaLichTrinh)
{
row.Cells["TenLichTrinh"].Value = lichtrinh.TenLichTrinh;
}
}
}
dataGridView2.Columns["LichTrinh"].Visible = false;
dataGridView2.Columns["Nguoi"].Visible = false;
dataGridView2.Columns["MaNguoi"].Visible = false;
dataGridView2.Columns["MaLichTrinh"].Visible = false;
dataGridView2.Columns["MaLichTrinhTam"].Visible = false;
}
public static List <LichTrinh> LoadAllLichTrinhs()
{
List <LichTrinh> lichTrinhs = new List <LichTrinh>();
try
{
ATINChamCongEntities context = new ATINChamCongEntities();
lichTrinhs = context.spGetAllLichTrinh().ToList();
return(lichTrinhs);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(null);
}
}
private void Set()
{
ATINChamCongEntities context = new ATINChamCongEntities();
var lstLichTrinh = context.spGetAllLichTrinh().ToList();
LichTrinh lichTrinhNuLL = new LichTrinh {
MaLichTrinh = null, TenLichTrinh = "Chưa Xếp"
};
lstLichTrinh.Add(lichTrinhNuLL);
List <LichTrinh> lstLichTrinh2 = new List <LichTrinh>(lstLichTrinh);
comboBox1.DataSource = lstLichTrinh;
comboBox2.DataSource = lstLichTrinh2;
comboBox1.DisplayMember = "TenLichTrinh";
comboBox2.DisplayMember = "TenLichTrinh";
comboBox1.ValueMember = "MaLichTrinh";
comboBox2.ValueMember = "MaLichTrinh";
dateEditFromDate.DateTime = DateTime.Now;
dateEditToDate.DateTime = DateTime.Now;
}
//using Singleton to create only one Instance of form
private PrepareEmployeeCalenda()
{
InitializeComponent();
this.Dock = DockStyle.Fill;
SetDoubleBuffer(dataGridView1, true);
SetDoubleBuffer(dataGridView2, true);
TreeView1Config();
ATINChamCongEntities context = new ATINChamCongEntities();
var lstLichTrinh = context.spGetAllLichTrinh().ToList();
LichTrinh lichTrinhEmpty = new LichTrinh {
MaLichTrinh = null, TenLichTrinh = "Chưa Xếp", LoaiChuKy = null
};
lstLichTrinh.Add(lichTrinhEmpty);
DataGridViewComboBoxColumn col = new DataGridViewComboBoxColumn();
col.DataSource = lstLichTrinh;
col.Name = "col";
col.DisplayMember = "TenLichTrinh";
col.DataPropertyName = "MaLichTrinh";
col.ValueMember = "MaLichTrinh";
col.HeaderText = "Lịch trình";
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
col.DefaultCellStyle.NullValue = lichTrinhEmpty.TenLichTrinh;
col.DefaultCellStyle.DataSourceNullValue = lichTrinhEmpty.MaLichTrinh;
dataGridView1.Columns.Add(col);
DataGridViewCheckBoxColumn checkCol = new DataGridViewCheckBoxColumn();
checkCol.Name = "Checkbox";
checkCol.DataPropertyName = "Checkbox";
checkCol.HeaderText = "";
checkCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
checkCol.Width = 120;
checkCol.DefaultCellStyle.NullValue = false;
checkCol.DefaultCellStyle.DataSourceNullValue = false;
dataGridView1.Columns.Add(checkCol);
Set();
}
