protected void LoadAdminPanel(WebhostEntities db, Faculty teacher, int curTerm) { PingBtn.Visible = false; if (teacher.Permissions.Where(p => p.Name.Contains("Admin") && p.AcademicYear == DateRange.GetCurrentAcademicYear()).Count() > 0) { PingBtn.Visible = true; TeacherSelect.DataSource = FacultyListItem.GetDataSource(db.Faculties.Where(f => f.isActive).OrderBy(f => f.LastName).ThenBy(f => f.FirstName).Select(f => f.ID).ToList()); TeacherSelect.DataTextField = "Text"; TeacherSelect.DataValueField = "ID"; TeacherSelect.DataBind(); StudentSelect.DataSource = StudentListItem.GetDataSource(db.Students.Where(s => s.isActive).OrderBy(f => f.LastName).ThenBy(f => f.FirstName).Select(s => s.ID).ToList()); StudentSelect.DataTextField = "Text"; StudentSelect.DataValueField = "ID"; StudentSelect.DataBind(); } else if (db.Departments.Where(d => d.DeptHeadId == teacher.ID).Count() > 0) { List <int> facids = new List <int>(); Term term = db.Terms.Find(curTerm); foreach (Department dept in teacher.Departments.ToList()) { foreach (Section section in term.Sections.Where(s => s.Course.DepartmentID == dept.id).ToList()) { foreach (Faculty t in section.Teachers.ToList()) { if (!facids.Contains(t.ID)) { facids.Add(t.ID); } } } } TeacherSelect.DataSource = FacultyListItem.GetDataSource(facids); TeacherSelect.DataTextField = "Text"; TeacherSelect.DataValueField = "ID"; TeacherSelect.DataBind(); StudentSelect.DataSource = StudentListItem.GetDataSource(teacher.Students.Where(s => s.isActive).Select(s => s.ID).ToList()); StudentSelect.DataTextField = "Text"; StudentSelect.DataValueField = "ID"; StudentSelect.DataBind(); } else { TeacherSelect.DataSource = FacultyListItem.GetDataSource(new List <int>() { user.ID }); TeacherSelect.DataTextField = "Text"; TeacherSelect.DataValueField = "ID"; TeacherSelect.DataBind(); StudentSelect.DataSource = StudentListItem.GetDataSource(teacher.Students.Where(s => s.isActive).Select(s => s.ID).ToList()); StudentSelect.DataTextField = "Text"; StudentSelect.DataValueField = "ID"; StudentSelect.DataBind(); } }
/// <summary> /// Exam List count. /// </summary> /// <param name="teacherSelect"> /// Include Name /// </param> /// <returns>Search exam list count</returns> public int ExamListCount(TeacherSelect teacherSelect) { try { return(client.ExamListCount(teacherSelect)); } catch (RequestExceprion ex) { throw ex; } }
/// <summary> /// Teacher manage student list. /// </summary> /// <param name="teacherSelect"> /// Include TeacherSortName, TeacherSortDirction, Name, PageSize, CurrentPage /// </param> /// <returns>Select exam result</returns> public TeacherManage[] ExamList(TeacherSelect teacherSelect) { try { return(client.ExamList(teacherSelect)); } catch (RequestExceprion ex) { throw ex; } }
/// <summary> /// Exam list /// </summary> /// <param name="teacherSelect"></param> /// <returns></returns> public List <TeacherManage> ExamList(TeacherSelect teacherSelect) { SqlConnection connection = new SqlConnection(CONNECTION_STRING); connection.Open(); SqlCommand command = new SqlCommand("spTeacherManage", connection); command.CommandType = CommandType.StoredProcedure; List <TeacherManage> teacherManageExam = new List <TeacherManage>(); command.Parameters.Add(new SqlParameter("@TeacherSortName", teacherSelect.TeacherSortName)); command.Parameters.Add(new SqlParameter("@TeacherSortDirction", teacherSelect.TeacherSortDirction)); command.Parameters.Add(new SqlParameter("@Name", teacherSelect.Name)); command.Parameters.Add(new SqlParameter("@CurrentPage", teacherSelect.CurrentPage)); command.Parameters.Add(new SqlParameter("@PageSize", teacherSelect.PageSize)); command.Parameters.Add(new SqlParameter("@StartDate", teacherSelect.StartTime)); command.Parameters.Add(new SqlParameter("@EndDate", teacherSelect.EndTime)); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { TeacherManage teacherManage = new TeacherManage(); teacherManage.ExamName = reader.GetString(0); teacherManage.Id = reader.GetInt32(1); teacherManage.EffectiveTime = reader.GetDateTime(2); teacherManage.QuestionQuantity = reader.GetInt32(3); teacherManage.AvgScore = reader[4] == System.DBNull.Value ? 0 : reader.GetDecimal(4); teacherManage.ExamineeCount = reader[5] == System.DBNull.Value ? 0 : reader.GetInt32(5); teacherManage.NumOfQualified = reader[6] == System.DBNull.Value ? 0 : reader.GetInt32(6); teacherManage.PassRate = reader[7] == System.DBNull.Value ? 0 : reader.GetDecimal(7); teacherManage.RowNumber = reader.GetInt64(8); teacherManageExam.Add(teacherManage); } } return(teacherManageExam); }
/// <summary> /// Exam list show /// </summary> public ExamList() { InitializeComponent(); teacherSelect = new TeacherSelect(); examManager = new TeacherExamManage(); this.pageSize.SelectedItem = "10"; teacherSelect.TeacherSortName = ""; teacherSelect.TeacherSortDirction = "asc"; teacherSelect.Name = ""; teacherSelect.PageSize = 10; teacherSelect.CurrentPage = 1; teacherSelect.StartTime = beginDate; teacherSelect.EndTime = endDate; TeacherManageExam(); this.frontPage.Click += new EventHandler(FrontPageClick); this.nextPage.Click += new EventHandler(NextPageClick); this.keyWordSelect.KeyUp += new KeyEventHandler(KeyWordSelectKeyUp); this.keyWordBtn.Click += new EventHandler(KeyWordBtnClick); this.pageSize.SelectedValueChanged += new EventHandler(PageSizeSelectedValueChanged); this.toSelectPage.KeyPress += new KeyPressEventHandler(ToSelectPageKeyPress); this.go.Click += new EventHandler(GoClick); this.examNameSort.Click += new EventHandler(SortClick); this.idSort.Click += new EventHandler(SortClick); this.effectiveTimeSort.Click += new EventHandler(SortClick); this.avgScoreSort.Click += new EventHandler(SortClick); this.passRateSort.Click += new EventHandler(SortClick); this.beginTime.Click += new EventHandler(BeginDateClick); this.endTime.Click += new EventHandler(EndTimeClick); this.monthCalendarBegin.DateSelected += new DateRangeEventHandler(MonthCalendarBeginDateChanged); this.monthCalendarEnd.DateSelected += new DateRangeEventHandler(MonthCalendarEndDateSelected); this.teacherDataGridView.CellFormatting += new DataGridViewCellFormattingEventHandler(TeacherDataGridViewCellFormatting); this.teacherDataGridView.CellContentClick += new DataGridViewCellEventHandler(TeacherDataGridViewCellContentClick); }
/// <summary> /// Teacher manage exam list count /// </summary> /// <param name="teacherSelect"></param> /// <returns></returns> public int ExamListCount(TeacherSelect teacherSelect) { int res = 0; SqlConnection connection = new SqlConnection(CONNECTION_STRING); connection.Open(); SqlCommand command = new SqlCommand("spTeacherManageTotal", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@Name", teacherSelect.Name)); command.Parameters.Add(new SqlParameter("@StartDate", teacherSelect.StartTime)); command.Parameters.Add(new SqlParameter("@EndDate", teacherSelect.EndTime)); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { res = reader.GetInt32(0); } } return(res); }
/// <summary> /// Exam list count /// </summary> /// <param name="teacherSelect"></param> /// <returns></returns> public int ExamListCount(TeacherSelect teacherSelect) { return(teacherDB.ExamListCount(teacherSelect)); }
/// <summary> /// ExamList /// </summary> /// <param name="teacherSelect"></param> /// <returns></returns> public List <TeacherManage> ExamList(TeacherSelect teacherSelect) { return(teacherDB.ExamList(teacherSelect)); }