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