public ActionResult <List <Students> > Get() { IStudentSelect studentSelect = new StudentSelect(conn); var studentlist = studentSelect.SelectAllStudent(0); return(studentlist); }
public ActionResult <Students> Get(int id) { IStudentSelect studentSelect = new StudentSelect(conn); var student = studentSelect.SelectAllStudent(id).FirstOrDefault(); return(student); }
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> /// My exam init /// </summary> public MyExamList() { InitializeComponent(); studentSelect = new StudentSelect(); studentExam = new StudentExamManage(); studentSelect.StudentSortName = STRING_EMPTY; studentSelect.StudentSortDirction = "asc"; studentSelect.CurrentPage = INT_ONE; studentSelect.PageSize = INT_TEN; studentSelect.IsFinished = STRING_EMPTY; studentSelect.Id = Login.userOverall.Id; pagination(); StudentExamShow(); this.pageSize.SelectedItem = "" + 10; this.studentDataGridView.CellFormatting += new DataGridViewCellFormattingEventHandler(StudentDataGridViewCellFormatting); this.studentDataGridView.CellContentClick += new DataGridViewCellEventHandler(StudentDataGridViewCellContentClick); this.frontPage.Click += new EventHandler(FrontPageClick); this.nextPage.Click += new EventHandler(NextPageClick); this.finishedExam.Click += new EventHandler(FinishedExamClick); this.unFinishedExam.Click += new EventHandler(UnFinishedClick); this.allExam.Click += new EventHandler(AllExamClick); this.nameSort.Click += new EventHandler(SortClick); this.sortId.Click += new EventHandler(SortClick); this.sortEffectiveTime.Click += new EventHandler(SortClick); this.sortPassCriteria.Click += new EventHandler(SortClick); this.sortExamScore.Click += new EventHandler(SortClick); this.sortOperation.Click += new EventHandler(SortClick); this.pageSize.SelectedValueChanged += new EventHandler(PageSizeSelectedValueChanged); this.toSelectPage.KeyPress += new KeyPressEventHandler(ToSelectPageKeyPress); this.go.Click += new EventHandler(GoClick); }
/// <summary> /// Search student exam count. /// </summary> /// <param name="studentSelect">Operation(if = 0)</param> /// <returns>student exam count</returns> public int StudentExamCount(StudentSelect studentSelect) { try { return(client.StudentExamCount(studentSelect)); } catch (RequestExceprion ex) { throw ex; } }
/// <summary> /// Student exam list. /// </summary> /// <param name="studentSelect"> /// Include StudentSortName, StudentSortDirction, CurrentPage, PageSize, IsFinished, Id /// </param> /// <returns>Search student exam list</returns> public StudentExam[] StudentExam(StudentSelect studentSelect) { try { return(client.StudentExam(studentSelect)); } catch (RequestExceprion ex) { throw ex; } }
/// <summary> /// Student exam list /// </summary> /// <param name="studentSelect"></param> /// <returns></returns> public List <StudentExam> StudentExam(StudentSelect studentSelect) { SqlConnection connection = new SqlConnection(CONNECTION_STRING); connection.Open(); SqlCommand command = new SqlCommand("spStudentExam", connection); command.CommandType = CommandType.StoredProcedure; List <StudentExam> studentExamList = new List <StudentExam>(); command.Parameters.Add(new SqlParameter("@Id", studentSelect.Id)); command.Parameters.Add(new SqlParameter("@CurrentPage", studentSelect.CurrentPage)); command.Parameters.Add(new SqlParameter("@PageSize", studentSelect.PageSize)); command.Parameters.Add(new SqlParameter("@StudentSortName", studentSelect.StudentSortName)); command.Parameters.Add(new SqlParameter("@StudentSortDirction", studentSelect.StudentSortDirction)); command.Parameters.Add(new SqlParameter("@IsFinished", studentSelect.IsFinished)); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { StudentExam studentExam = new StudentExam(); studentExam.ExamName = reader.GetString(0); studentExam.Id = reader.GetInt32(1); studentExam.EffectiveTime = reader.GetDateTime(2); studentExam.Duration = reader.GetInt32(3); studentExam.PassCriteria = reader.GetInt32(4); studentExam.Operation = reader.GetInt32(5); studentExam.ExamSocre = reader[6] == System.DBNull.Value ? 0 : reader.GetInt32(6); studentExam.RowNumber = reader.GetInt64(7); studentExamList.Add(studentExam); } } return(studentExamList); }
/// <summary> /// Student Exam Count /// </summary> /// <param name="studentSelect"></param> /// <returns></returns> public int StudentExamCount(StudentSelect studentSelect) { int res = 0; SqlConnection connection = new SqlConnection(CONNECTION_STRING); connection.Open(); SqlCommand command = new SqlCommand("spStudentExamCount", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@Id", studentSelect.Id)); command.Parameters.Add(new SqlParameter("@IsFinished", studentSelect.IsFinished)); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { res = reader.GetInt32(0); } } return(res); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { int year = DateRange.GetCurrentAcademicYear(); using (WebhostEntities db = new WebhostEntities()) { StudentSelect.DataSource = StudentListItem.GetDataSource(db.Students.Where(s => s.isActive).OrderBy(s => s.GraduationYear).ThenBy(s => s.LastName).ThenBy(s => s.FirstName).Select(s => s.ID).ToList()); StudentSelect.DataTextField = "Text"; StudentSelect.DataValueField = "ID"; StudentSelect.DataBind(); CreditTypeDDL.DataSource = GradeTableEntryListItem.GetDataSource(db.GradeTables.Where(t => t.Name.Equals("Credit Types") && t.AcademicYearID == year).Single().GradeTableEntries.Select(d => d.id).ToList()); CreditTypeDDL.DataTextField = "Text"; CreditTypeDDL.DataValueField = "ID"; CreditTypeDDL.DataBind(); CreditValueDDL.DataSource = GradeTableEntryListItem.GetDataSource(db.GradeTables.Where(t => t.Name.Equals("Credit Values") && t.AcademicYearID == year).Single().GradeTableEntries.Select(d => d.id).ToList()); CreditValueDDL.DataTextField = "Text"; CreditValueDDL.DataValueField = "ID"; CreditValueDDL.DataBind(); } } }
/// <summary> /// Student Exam Count /// </summary> /// <param name="studentSelect"></param> /// <returns></returns> public int StudentExamCount(StudentSelect studentSelect) { return(studentDb.StudentExamCount(studentSelect)); }
/// <summary> /// Student Exam /// </summary> /// <param name="studentSelect"></param> /// <returns></returns> public List <StudentExam> StudentExam(StudentSelect studentSelect) { return(studentDb.StudentExam(studentSelect)); }