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));
}
