protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
if (Request.QueryString["StandardID"] != null && Request.QueryString["StudentID"] != null && Request.QueryString["WorksheetID"] != null)
{
QueryStringData();
Base.Classes.CompetencyTracking.CompetencyTrackingReport obj = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
ds = obj.GetStudentStandardList(workSheetID, standardID, roblicSortOrder, LevelID, LevelObjectID, StudentId);
BindRepeaterData();
}
}
}
protected void BindStudentDetails()
{
Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
QueryStringData();
//TODO PASS QUERYSTRING VALUES HERE and remove hard coded values
/*When something in not selected pass 0 it will be converted to null in procedure and will not be included in where clause*/
try
{
DataSet dsStudentList = oCTR.GetCVTEReportStudentList(workSheetID, standardID, roblicSortOrder, viewBySelectedValue, techerID, demographicID, groupID);
if (dsStudentList != null)
{
DataTable dtViewByDetail = dsStudentList.Tables[0];
if (dtViewByDetail.Rows.Count > 0)
{
lblViewBy.Text = dtViewByDetail.Rows[0]["ViewBy"].ToString() + " : ";// +dtViewByDetail.Rows[0]["ViewByValue"].ToString();
tdViewByText.InnerText = dtViewByDetail.Rows[0]["ViewByValue"].ToString();
lblRubric.Text = "Rubric Value: ";
spnRubricValue.InnerText = dtViewByDetail.Rows[0]["RubricValue"].ToString();
lblCompetency.Text = "Competency: ";
aCompetencyValue.InnerText = dtViewByDetail.Rows[0]["Competency"].ToString();
spnCompetencyDetail.InnerText = dtViewByDetail.Rows[0]["CompetencyDesc"].ToString();
lblStudentCount.Text = "Students:" + dtViewByDetail.Rows[0]["StudentCount"].ToString();
}
DataTable dtStudentList = dsStudentList.Tables[1];
radGridStudentCount.DataSource = dtStudentList;
radGridStudentCount.DataBind();
}
}
catch (Exception ex)
{
}
}
public void BindDataToGrid()
{
radGridResults.MasterTableView.Columns.Clear();
radGridResults.MasterTableView.DataSource = new string[0];
radGridResults.Visible = true;
lblInitialText.Visible = false;
SelectedCriteria selectedCriteria = GetCriteriaControlValues();
//ViewBy
string selectedViewBy = selectedCriteria.SelectedViewBy;
//School
int selectedSchoolId = selectedCriteria.SelectedSchoolId;
//Teacher
//The code below forces passing the current teacher to the backend procs, this way a teacher can ONLY see their data.
string selectedTeacher = string.Empty;
if (_loggedOnUserRoleName != null
&& _loggedOnUserRoleName.Equals("Teacher", StringComparison.InvariantCultureIgnoreCase)
&& (_loggedOnUser != null && !string.IsNullOrEmpty(_loggedOnUser.Page.ToString())))
{
selectedTeacher = _loggedOnUser.Page.ToString(); // force current user
}
else
{
selectedTeacher = selectedCriteria.SelectedTeacher;
}
//Class
string selectedClass = selectedCriteria.SelectedClass;
//Student
string selectedStudent = selectedCriteria.SelectedStudent;
//StandardLevel
string standardLevel = selectedCriteria.StandardLevel;
//Demographics
string selectedDemographics = selectedCriteria.SelectedDemographics;
//Group;
string selectedGroup = selectedCriteria.SelectedGroup;
//Worksheet List
string selectedWorksheet = selectedCriteria.SelectedWorksheet;
/* Created Date Range */
string startDate = selectedCriteria.StartDate;
string endDate = selectedCriteria.EndDate;
//GET THE DATA HERE
GridDataTable = new DataTable();
string standardSet = string.Empty; //GetStandardSetValueFromParmsTable();
TGDetail selectedType;
Enum.TryParse(selectedViewBy, true, out selectedType);
if (selectedType != null)
{
Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
//selectedWorksheet, standardSet, standardLevel, selectedSchoolId.ToString(), selectedTeacher, selectedClass, selectedDemographics, selectedGroup, selectedStudent, startDate, endDate
oCTR.worksheetId = selectedWorksheet;
oCTR.standardSet = selectedCriteria.StandardSet;
oCTR.standardLevel = standardLevel;
oCTR.schoolID = selectedSchoolId.ToString();
oCTR.teacherId = selectedTeacher;
oCTR.className = selectedClass;
oCTR.demographicID = selectedDemographics;
oCTR.groupID = selectedGroup;
oCTR.studentId = selectedStudent;
oCTR.startDate = startDate;
oCTR.endDate = endDate;
oCTR.standardId = String.IsNullOrEmpty(selectedCriteria.StandardId) ? null : selectedCriteria.StandardId.Split('_').Select(str => int.Parse(str)).ToArray();
oCTR.grade = selectedCriteria.Grade;
oCTR.course = selectedCriteria.Course;
oCTR.subject = selectedCriteria.Subject;
switch (selectedType)
{
case TGDetail.Student:
GridDataTable = oCTR.GetCvteReportByStudent();
break;
case TGDetail.District:
GridDataTable = oCTR.GetCvteReportByDistrict();
if (GridDataTable.Rows.Count > 0)
SelectedObject = "0";//GridDataTable.Rows[0]["DistrictID"].ToString();
break;
case TGDetail.School:
GridDataTable = oCTR.GetCvteReportBySchool();
if (GridDataTable.Rows.Count > 0)
SelectedObject = selectedSchoolId.ToString();//GridDataTable.Rows[0]["SchoolID"].ToString();
break;
case TGDetail.Teacher:
GridDataTable = oCTR.GetCvteReportByTeacher();
if (GridDataTable.Rows.Count > 0)
SelectedObject = selectedTeacher;//GridDataTable.Rows[0]["TeacherID"].ToString();
break;
case TGDetail.Class:
GridDataTable = oCTR.GetCvteReportByClass();
if (GridDataTable.Rows.Count > 0)
SelectedObject = selectedClass; //GridDataTable.Rows[0]["ClassID"].ToString();
break;
case TGDetail.Demographics:
GridDataTable = oCTR.GetCvteReportByDemographics();
if (GridDataTable.Rows.Count > 0)
{
SelectedObject = selectedDemographics;//GridDataTable.Rows[0]["DemographicsID"].ToString();
}
break;
case TGDetail.Group:
GridDataTable = oCTR.GetCvteReportByGroup();
if (GridDataTable.Rows.Count > 0)
SelectedObject = selectedGroup;//GridDataTable.Rows[0]["DistrictID"].ToString();
break;
}
if (GridDataTable.Rows.Count > 0)
{
GridDataTable = Standpoint.Core.Classes.Encryption.EncryptDataTableColumn(GridDataTable, "StandardID", "EncryptedID");
DataTableCount = GridDataTable.Rows.Count;
DataView view = new DataView(GridDataTable);
_distinctRowsCount = view.ToTable(true, selectedViewBy + "Name").Rows.Count;
_distinctObjectivesCount = view.ToTable(true, "StandardName").Rows.Count;
if (oCTR.worksheetId != null)
totalStudents = Convert.ToString(GridDataTable.Rows[0]["TotalStudent"]);
else
{
totalStudents = GridDataTable.DefaultView.ToTable(true, "TotalStudent").Compute("Sum(TotalStudent)", "").ToString();
}
radGridResults.DataSource = GridDataTable;
BuildTheColumns(selectedType, GridDataTable.Rows[0], standardLevel);
}
}
//if (selectedViewBy != null)
//{
// switch (selectedViewBy.ToLower())
// {
// case "student":
// GridDataTable = GetCvteReportByStudent(selectedWorksheet, standardSet, standardLevel, selectedSchoolId.ToString(), selectedTeacher, selectedClass, selectedDemographics, selectedGroup, selectedStudent, startDate, endDate);
// break;
// case "teacher":
// GridDataTable = GetCvteReportByTeacher(selectedWorksheet, standardSet, standardLevel, selectedSchoolId.ToString(), selectedTeacher, selectedDemographics, selectedGroup, startDate, endDate);
// break;
// case "class":
// GridDataTable = GetCvteReportByClass(selectedWorksheet, standardSet, standardLevel, selectedSchoolId.ToString(), selectedClass, selectedTeacher, selectedStudent, selectedDemographics, selectedGroup, startDate, endDate);
// break;
// case "demographic":
// GridDataTable = GetCvteReportByDemographic(selectedWorksheet, standardSet, standardLevel, selectedSchoolId.ToString(), selectedClass, selectedTeacher, selectedDemographics, selectedGroup, startDate, endDate);
// break;
// }
// if (GridDataTable.Rows.Count > 0)
// {
// GridDataTable = Standpoint.Core.Classes.Encryption.EncryptDataTableColumn(GridDataTable, "StandardID", "EncryptedID");
// DataTableCount = GridDataTable.Rows.Count;
// DataView view = new DataView(GridDataTable);
// _distinctRowsCount = view.ToTable(true, selectedViewBy + "Name").Rows.Count;
// _distinctObjectivesCount = view.ToTable(true, "StandardName").Rows.Count;
// radGridResults.DataSource = GridDataTable;
// BuildTheColumns(selectedViewBy, GridDataTable.Rows[0]);
// }
//}
//FormatColumnsForExcel(selectedViewBy, standardLevel, SelectedCriteria);
FormatColumnsForExcel(selectedCriteria);
radGridResults.DataBind();
initialDisplayText.Visible = false;
}
private void PopulateStandardListDropdown()
{
Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
cmbStandardList.DataSource = oCTR.GetStandardList();
cmbStandardList.DataTextField = "TypeValue";
cmbStandardList.DataValueField = "EnumValue";
}
private void PopulateDemographicDropdown()
{
Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
cmbDemos.DataSource = oCTR.GetDemographicList();
cmbDemos.DataTextField = "Label";
cmbDemos.DataValueField = "ID";
}
private void PopulateViewByDropdown()
{
Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
DataTable competencyTypeList = oCTR.GetCompetencyTypeList();
if (_sessionObject == null)
{
_sessionObject = (SessionObject)Session["SessionObject"];
}
var rolePortal = (RolePortal)_sessionObject.LoggedInUser.Roles.Where(w => w.RolePortalSelection != 0).Min(m => m.RolePortalSelection);
/* Check rolePortal */
switch (rolePortal)
{
case RolePortal.District:
{
for (int i = competencyTypeList.Rows.Count - 1; i >= 0; i--)
if (competencyTypeList.Rows[i]["TypeValue"].ToString() == "Group")
{
competencyTypeList.Rows.RemoveAt(i);
}
cmbGroup.Visible = false;
break;
}
case RolePortal.School:
{
for (int i = competencyTypeList.Rows.Count - 1; i >= 0; i--)
if (competencyTypeList.Rows[i]["TypeValue"].ToString() == "District" || competencyTypeList.Rows[i]["TypeValue"].ToString() == "Group")
{
competencyTypeList.Rows.RemoveAt(i);
}
cmbGroup.Visible = false;
break;
}
case RolePortal.Teacher:
{
for (int i = competencyTypeList.Rows.Count - 1; i >= 0; i--)
if (competencyTypeList.Rows[i]["TypeValue"].ToString() == "District" || competencyTypeList.Rows[i]["TypeValue"].ToString() == "School")
{
competencyTypeList.Rows.RemoveAt(i);
}
break;
}
}
cmbViewBy.DataSource = competencyTypeList;
cmbViewBy.DataTextField = "TypeValue";
cmbViewBy.DataValueField = "EnumValue";
}
public DataTable PopulateListSelectionDropdownByTeacher(int teacherID)
{
Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
return oCTR.GetListSelectionByTeacher(teacherID);
}
public static string GetStudentListBySchoolTeacherAndClass(int schoolID, int teacherPage, int classId)
{
if (schoolID < 0) return null;
DataTable studentListBySchoolTeacherAndClass = new DataTable();
Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
studentListBySchoolTeacherAndClass = oCTR.GetStudentListBySchoolTeacherAndClass(schoolID, teacherPage, classId);
return studentListBySchoolTeacherAndClass.ToJSON(false);
}
public static string GetTeacherListForSchool(int schoolID)
{
if (schoolID < 0) return null;
DataTable teacherListForSchool = new DataTable();
//set teacher dropdown to the current user if they are a teacher
if (_loggedOnUserRoleName != null && _loggedOnUserRoleName.Equals("Teacher", StringComparison.InvariantCultureIgnoreCase))
{
if (!string.IsNullOrEmpty(_loggedOnUser.UserFullName) || !string.IsNullOrEmpty(_loggedOnUser.Page.ToString()))
{
return "[{\"TeacherName\":\"" + _loggedOnUser.UserFullName + "\",\"TeacherPage\":\"" + _loggedOnUser.Page + "\"}]";
}
return teacherListForSchool.ToJSON(false); //user was a teacher but SessionObject.LoggedInUser object had null values (return new 'empty' datatable')
}
Base.Classes.CompetencyTracking.CompetencyTrackingReport oCTR = new Base.Classes.CompetencyTracking.CompetencyTrackingReport();
teacherListForSchool = oCTR.GetTeacherListBySchool(schoolID);
return teacherListForSchool.ToJSON(false);
}
