/// <summary>
/// Load the details from Exams table from sql to new grid
/// by the parameters: ID, Course Name, Start Time, End Time, Classes, Supervisors, Students enrolled and date
/// in adittion design the grid by color blue</summary>
private void Exams_List_Load()
{
//Create Columns
Exams_Grid.Columns.Add("ID", "ID");
Exams_Grid.Columns.Add("Course_Name", "Course Name");
Exams_Grid.Columns.Add("Start_Time", "Start Time");
Exams_Grid.Columns.Add("End_Time", "End Time");
Exams_Grid.Columns.Add("Class", "Class");
Exams_Grid.Columns.Add("Supervisor1_ID", "First Supervisor ID");
Exams_Grid.Columns.Add("Supervisor2_ID", "Second Supervisor ID");
Exams_Grid.Columns.Add("Students_Enrolled", "Students Enrolled");
Exams_Grid.Columns.Add("Date", "Date");
Exams_Grid.Columns.Add("DueIn", "Due In");
//Paint headers
Exams_Grid.EnableHeadersVisualStyles = false;
Exams_Grid.GridColor = Utility.HeaderBackColor;
Exams_Grid.ColumnHeadersDefaultCellStyle.BackColor = Utility.HeaderBackColor;
Exams_Grid.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
Exams_Grid.AutoResizeColumns();
Exams_Grid.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
Exams_Grid.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
using (Entities context = new Entities())
{
Exams_Grid.Rows.Clear();
foreach (Exam s in context.Exams)
{
Exams_Grid.Rows.Add(s.ID, getCourseName(s.Course_ID), s.Start_Time + ":00", s.End_Time + ":00", s.Class, s.Superviser1_ID, s.Superviser2_ID, s.Student_Enrolled, s.Date.ToShortDateString(), s.Due_in);
}
}
Exams_Grid.Refresh();
}
/// <summary>
/// Load the details from Exams table from sql to new grid
/// by the parameters: ID, Course Name, Start Time, End Time, Classes, Supervisors, Students enrolled and date
/// in adittion design the grid by color blue</summary>
private void Exams_List_Load()
{
//Create Columns
Exams_Grid.Columns.Add("ID", "ID");
Exams_Grid.Columns.Add("Course_Name", "Course Name");
Exams_Grid.Columns.Add("Class", "Class (capacity)");
Exams_Grid.Columns.Add("Students_Enrolled", "Students Enrolled");
Exams_Grid.Columns.Add("Due_In", "Due In");
Exams_Grid.Columns.Add("Date", "Date");
//Create check box column
DataGridViewCheckBoxColumn column = new DataGridViewCheckBoxColumn();
{
column.HeaderText = "Choose Course";
column.Name = "Choose_Course";
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
column.FlatStyle = FlatStyle.Standard;
column.ThreeState = false;
column.IndeterminateValue = false;
column.CellTemplate = new DataGridViewCheckBoxCell();
}
Exams_Grid.Columns.Insert(Exams_Grid.Columns.Count, column);
//Paint headers
Exams_Grid.EnableHeadersVisualStyles = false;
Exams_Grid.GridColor = Utility.HeaderBackColor;
Exams_Grid.ColumnHeadersDefaultCellStyle.BackColor = Utility.HeaderBackColor;
Exams_Grid.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
Exams_Grid.AutoResizeColumns();
Exams_Grid.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
Exams_Grid.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
}
/// <summary>
/// Reload "Exams_Grid" with the exams at Exam table that in sql</summary>
private void reloadDataGridView(Entities context)
{
Exams_Grid.Rows.Clear();
foreach (Exam s in context.Exams)
{
Exams_Grid.Rows.Add(s.ID, getCourseName(s.Course_ID), s.Start_Time + ":00", s.End_Time + ":00", s.Class, s.Superviser1_ID, s.Superviser2_ID, s.Student_Enrolled, s.Date.ToShortDateString(), s.Due_in);
}
Exams_Grid.Refresh();
}
/// <summary>
/// Reload "Exams_Grid" with the exams at Exam table that in sql</summary>
private void Exam_List_Reload()
{
Exams_Grid.Rows.Clear();
context = new Entities();
foreach (Exam s in context.Exams)
{
if (s.Course_ID == getCourseId(Combo_Course_name.Text.Substring(0, Combo_Course_name.Text.Length - 7)))
{
Exams_Grid.Rows.Add(s.ID, getCourseName(s.Course_ID), s.Class + " (" + classCapacity(s.Class) + ")", s.Student_Enrolled, s.Due_in, s.Date.ToShortDateString());
}
}
Exams_Grid.Refresh();
}
