private int CheckActiveSemester()
 {
     using (Maintenance maintain = new Maintenance())
     {
         return(maintain.GetActiveSemester().Where(x => x.Active == true).ToList().Count);
     }
 }
 void LoadYearClass()
 {
     cmbYearClass.Items.Clear();
     using (Maintenance maintain = new Maintenance())
     {
         maintain.GetActiveSemester().OrderBy(o => o.YearSemester).ToList().ForEach(f =>
         {
             cmbYearClass.Items.Add(f.YearSemester);
         });
     }
 }
 void GetActiveSemester()
 {
     using (Maintenance maintain = new Maintenance())
     {
         var value = maintain.GetActiveSemester().Where(x => x.Active == true).FirstOrDefault();
         if (value != null)
         {
             SystemProperties.SemesterActive.YearSemester = value.YearSemester;
             SystemProperties.SemesterActive.Start        = value.DateStart.Value;
             SystemProperties.SemesterActive.End          = value.DateEnd.Value;
             SystemProperties.SemesterActive.Semester     = value.Semester;
         }
     }
 }
        void GetYearClass()
        {
            int i = 1;

            dgYearClass.Rows.Clear();
            using (Maintenance maintain = new Maintenance())
            {
                maintain.GetActiveSemester().OrderBy(o => o.Semester).ToList().ForEach(x =>
                {
                    dgYearClass.Rows.Add(x.ID, i, x.YearSemester, x.Semester, x.DateStart, x.DateEnd, x.Active);
                    i++;
                });
            }
            ObjEnable(false);
        }
 void dgYearClass_CellClick(object sender, DataGridViewCellEventArgs e)
 {
     if (dgYearClass.Rows.Count > 0)
     {
         using (Maintenance _maintain = new Maintenance())
         {
             var value = _maintain.GetActiveSemester().Where(x => x.ID == Convert.ToInt64(dgYearClass.SelectedRows[0].Cells[0].Value)).FirstOrDefault();
             if (value != null)
             {
                 txtYearClass.Text = value.YearSemester;
                 dtDateStart.Value = value.DateStart.Value;
                 dtDateEnd.Value   = value.DateEnd.Value;
                 cmbSemester.Text  = value.Semester;
                 cbActive.Checked  = value.Active.Value;
                 btnDelete         = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString());
                 btnEdit           = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString());
             }
         }
     }
 }