private void Search()
{
this.Cursor = Cursors.WaitCursor;
strSearch = " (RegNo <> '') ";
strSearchReg = string.Empty;
strSearchName = string.Empty;
if (txtSearchReg.Text.Length > 0)
{
strSearchReg = "AND (RegNo Like '%" + txtSearchReg.Text.Trim() + "%')";
}
else
{
strSearchReg = string.Empty;
}
if (txtSearchName.Text.Length > 0)
{
strSearchName = "AND (Names Like '%" + txtSearchName.Text.Trim() + "%') ";
}
else
{
strSearchName = string.Empty;
}
myE = new EnrollmentInfo();
try
{
strSearch += strSearchReg + strSearchName;
myE.lvEnrollmentSearch(lvEnrollment, strSearch);
}
catch
{ }
myE = null;
this.Cursor = Cursors.Default;
}
public JsonResult Info([FromQuery] CollegeInfoRequest collegeName)
{
var response = new Response {
Code = 0, Data = null
};
try
{
var enrollment = _context.CollegeEnrollments.Include(c => c.Major).Where(c => c.Uname == collegeName.College).ToArrayAsync().Result;
var enrollmentInfo = new EnrollmentInfo[enrollment.Length];
for (int i = 0; i < enrollment.Length; i++)
{
enrollmentInfo[i] = new EnrollmentInfo {
Key = i,
Profession = enrollment[i].Major.Mname,
Batch = enrollment[i].Bname,
Count = enrollment[i].Menrollment
};
}
response.Data = enrollmentInfo;
}
catch (Exception ex)
{
response.Code = 1;
_logger.LogError(ex, "An error occurred while get college enrollment infomation.");
}
return(Json(response));
}
private void LoadAllEnrollments()
{
LiveClear();
myE = new EnrollmentInfo();
myE.lvEnrollment(lvEnrollment);
myE = null;
}
private void Load500Enrollments()
{
LiveClear();
myE = new EnrollmentInfo();
myE.lvEnrollmentTop500(lvEnrollment);
myE = null;
}
private void LoadEnrollment()
{
LiveClear();
myE = new EnrollmentInfo();
myE.lvEnrollmentMin(lvEnrollment);
myE = null;
}
private void DeleteInfo()
{
if ((Interactive.LInfoWarning("Are you sure you want to Delete ?", "Enrollment") == DialogResult.Yes))
{
myE = new EnrollmentInfo();
EnrollmentInfo.RegNo = lblRegNo.Text.Trim();
if (myE.RemoveEnrollment())
{
Load500Enrollments();
}
return;
}
}
private void SaveInfo()
{
if (FormIsValid())
{
myE = new EnrollmentInfo();
EnrollmentInfo.RegNo = txtRegNo.Text;
EnrollmentInfo.Names = txtName.Text;
EnrollmentInfo.Age = Convert.ToInt32(txtAge.Value);
EnrollmentInfo.AgeUnit = rbYr.Checked ? "Y" : "m";
EnrollmentInfo.Sex = rbM.Checked ? "M" : "F";
EnrollmentInfo.RegDate = dtpRegDate.Value;
EnrollmentInfo.Residence = txtResidence.Text;
try { EnrollmentInfo.ReferredBy = cmbReferredBy.SelectedValue.ToString(); }
catch { };
try { EnrollmentInfo.ReferredTo = cmbReferredTo.SelectedValue.ToString(); }
catch { };
EnrollmentInfo.Fcode = strFcode;
try { EnrollmentInfo.Category = cmbCategory.SelectedValue.ToString(); }
catch { };
EnrollmentInfo.ContactInfo = txtContact.Text;
try { EnrollmentInfo.Outcome = cmbOutcome.SelectedValue.ToString(); }
catch { };
if (EditFlag)
{
EnrollmentInfo.RegNo = lblRegNo.Text;
EnrollmentInfo.NewRegNo = txtRegNo.Text;
if ((Interactive.LInfoConfirm("Are you sure you want to Edit ?", "Enrollment") == DialogResult.Yes))
{
if (myE.EditEnrollment())
{
Load500Enrollments();
}
}
}
else
{
if (myE.NewEnrollment())
{
Load500Enrollments();
}
}
}
else
{
Interactive.LInfoError(err, "Enrollment");
}
}
public IActionResult Manage(string courseCode)
{
if (courseCode == null)
{
TempData["errorMessage"] = "You have to select a course to add student!";
return(RedirectToAction(nameof(Display)));
}
Course course = courseDB.Courses.FirstOrDefault(c => c.Code.ToUpper() == courseCode.ToUpper());
if (course == null)
{
TempData["errorMessage"] = "Please select a valid course";
return(RedirectToAction(nameof(Display)));
}
EnrollmentInfo enrollInfo = CreateEnrollInfo(course);
return(View("User", enrollInfo));
}
public IActionResult Manage(string courseCode)
{
if (courseCode == null)
{
TempData["errorMessage"] = "Please select a course to manage enrollment.";
return(RedirectToAction(nameof(List)));
}
Course course = courseDB.Courses.FirstOrDefault(c => c.Code.ToUpper() == courseCode.ToUpper());
if (course == null)
{
TempData["errorMessage"] = "Please select a valid course to manage enrollment.";
return(RedirectToAction(nameof(List)));
}
EnrollmentInfo enrollInfo = CreateEnrollInfo(course);
return(View("Enrollment", enrollInfo));
}
public IActionResult Manage(EnrollmentList list)
{
Course course = courseDB.Courses.FirstOrDefault(c => c.CourseId == list.CourseID);
if (course != null)
{
if (ModelState.IsValid)
{
foreach (long i in list.EnrollQueue)
{
Student student = studentDB.Students.FirstOrDefault(s => s.StudentNumber == i);
if (!course.Students.Contains(student))
{
CourseStudent csdb = course.AddStudent(student);
studentDB.SaveStudent(student);
csDB.AddCourseStudents(csdb);
}
}
foreach (long i in list.UnEnrollQueue)
{
Student student = studentDB.Students.FirstOrDefault(s => s.StudentNumber == i);
if (course.Students.Contains(student))
{
CourseStudent csdb = course.DeleteStudent(student);
studentDB.SaveStudent(student);
csDB.DeleteCourseStudents(csdb);
}
}
courseDB.SaveCourse(course);
TempData["successMessage"] = $"Enrollment changes successfully saved.";
return(RedirectToAction(nameof(List)));
}
else
{
EnrollmentInfo enrollInfo = CreateEnrollInfo(course);
return(View("Enrollment", enrollInfo));
}
}
else
{
TempData["errorMessage"] = "Please select a valid course to manage enrollment.";
return(RedirectToAction(nameof(List)));
}
}
private void Display()
{
LoadDefaults();
EnrollmentInfo.RegNo = txtRegNo.Text = lblRegNo.Text = lvEnrollment.SelectedItems[0].Text;
txtName.Text = lvEnrollment.SelectedItems[0].SubItems[1].Text;
DisplayAgeUnit(lvEnrollment.SelectedItems[0].SubItems[3].Text);
txtAge.Value = Convert.ToDecimal(lvEnrollment.SelectedItems[0].SubItems[2].Text);
DisplaySex(lvEnrollment.SelectedItems[0].SubItems[4].Text);
dtpRegDate.Value = Convert.ToDateTime(lvEnrollment.SelectedItems[0].SubItems[5].Text);
dtpRegDate.Checked = true;
EnrollmentInfo En = new EnrollmentInfo();
En.ShowEnrollment();
cmbReferredBy.SelectedValue = EnrollmentInfo.ReferredBy;
cmbReferredTo.SelectedValue = EnrollmentInfo.ReferredTo;
cmbOutcome.SelectedValue = EnrollmentInfo.Outcome;
txtResidence.Text = EnrollmentInfo.Residence;
txtContact.Text = EnrollmentInfo.ContactInfo;
btnEdit.Enabled = true;
btnDelete.Enabled = true;
}
public JsonResult ApprovalGet()
{
var response = new Response {
Code = 1, Data = null
};
DateTime now = DateTime.Now;
if (_context.Batches.SingleOrDefault(b => b.Bname == "提前批").ApplicationBeginTime < now)//若志愿填报工作已经开始
{
return(Json(response));
}
try
{
var universities = _context.Universities.Include(u => u.Majors).ThenInclude(m => m.Major).ToList();
EnrollmentInfo[] info = new EnrollmentInfo[universities.Count];
for (int i = 0; i < universities.Count; i++)
{
info[i] = new EnrollmentInfo();
info[i].School = universities[i].Uname;
info[i].Population = universities[i].Enrollment;
info[i].Professions = new CollegeMajorEnrollment[universities[i].Majors.Count];
var majors = universities[i].Majors.ToList();
for (int j = 0; j < universities[i].Majors.Count; j++)
{
info[i].Professions[j] = new CollegeMajorEnrollment();
info[i].Professions[j].Profession = majors[j].Major.Mname;
info[i].Professions[j].Population = majors[j].Menrollment;
}
}
response.Code = 0;
response.Data = info.ToArray();
}
catch (Exception ex)
{
_logger.LogInformation(ex, "An error occured while getting college enrollment info");
}
return(Json(response));
}
public IActionResult Manage(EnrollmentList list)
{
Course course = courseDB.Courses.FirstOrDefault(c => c.CourseId == list.CourseID);
if (course != null)
{
if (ModelState.IsValid)
{
if (list.EnrollQueue == null)
{
TempData["errorMessage"] = "Please select a valid student.";
EnrollmentInfo enrollInfo = CreateEnrollInfo(course);
return(View("User", enrollInfo));
}
foreach (long i in list.EnrollQueue)
{
Student student = studentDB.Students.FirstOrDefault(s => s.StudentNumber == i);
CourseStudent csdb = course.AddStudent(student);
studentDB.SaveStudent(student);
csDB.AddCourseStudents(csdb);
}
courseDB.SaveCourse(course);
TempData["successMessage"] = $"Student(s) successfully added to the course {course.Name}";
return(RedirectToAction(nameof(Display)));
}
else
{
EnrollmentInfo enrollInfo = CreateEnrollInfo(course);
return(View("User", enrollInfo));
}
}
else
{
TempData["errorMessage"] = "Please select a valid course!";
return(RedirectToAction(nameof(Display)));
}
}
private void lvEnrollment_ColumnClick(object sender, ColumnClickEventArgs e)
{
Search();
myE = new EnrollmentInfo();
switch (e.Column)
{
case 0:
if (SortAsc)
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "RegNo", "ASC");
SortAsc = false;
}
else
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "RegNo", "DESC");
SortAsc = true;
}
break;
case 1:
if (SortAsc)
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "Names", "ASC");
SortAsc = false;
}
else
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "Names", "DESC");
SortAsc = true;
}
break;
case 2:
if (SortAsc)
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "Age", "ASC");
SortAsc = false;
}
else
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "Age", "DESC");
SortAsc = true;
}
break;
case 3:
if (SortAsc)
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "AgeUnit", "ASC");
SortAsc = false;
}
else
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "AgeUnit", "DESC");
SortAsc = true;
}
break;
case 4:
if (SortAsc)
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "Sex", "ASC");
SortAsc = false;
}
else
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "Sex", "DESC");
SortAsc = true;
}
break;
case 5:
if (SortAsc)
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "RegDate", "ASC");
SortAsc = false;
}
else
{
myE.lvEnrollmentSearchSort(lvEnrollment, strSearch, "RegDate", "DESC");
SortAsc = true;
}
break;
}
myE = null;
}
private void SetLabels()
{
myE = new EnrollmentInfo();
lblNumerator.Text = lvEnrollment.Items.Count.ToString();
lblDenominator.Text = myE.GetAll().ToString();
}
