private void LoadAndBindStudentCredentails()
{
var s = (Thinkgate.Base.Classes.Student)Tile.TileParms.GetParm("student");
if (s == null) return;
drGeneric_String drStringObj = new drGeneric_String();
drStringObj.Add("0");
DataSet ds = Base.Classes.Credentials.GetCredentialsForStudent(s.ID, StudentCredentialsView.Summary, drStringObj);
DataTable dtCredential = new DataTable();
if (ds != null && ds.Tables.Count > 0)
{
dtCredential = ds.Tables[0];
}
studentCredentialGrid.DataSource = dtCredential;
studentCredentialGrid.DataBind();
}
/// <summary>
/// Builds the QuestionSearchCriteria. Used both from Search Button and from Service
/// </summary>
public static AddendumSearchCriteriaV2 BuildSearchCriteriaObject(ThinkgateUser user, CriteriaController criteriaController, string requestedSortField = null)
{
/* Sort */
string sortField = null;
NameValue nvSortField = SortFields().Find(x => x.Name == requestedSortField); // ensure that the user given value for sort is in the defined list of options
if (nvSortField != null) sortField = nvSortField.Value;
/* Item Banks - Remove from master list based on filter if given */
var itemBanks = ItemBankMasterList.GetItemBanksForUser(user);
if (TestCategory != null && TestCategory == AssessmentCategories.District.ToString())
{
for (var rowIndex = itemBanks.Rows.Count - 1; rowIndex >= 0; rowIndex--)
{
if (itemBanks.Rows[rowIndex]["Label"].ToString() == "Personal")
{ itemBanks.Rows[rowIndex].Delete(); }
}
}
var selectedItemBanks = criteriaController.ParseCriteria<CheckBoxList.ValueObject>("ItemBank").Select(x => x.Text);
if (selectedItemBanks.Any()) itemBanks.DeleteByLabel(selectedItemBanks);
/* Text Search */
string searchText = string.Empty;
string searchOption = string.Empty;
var txtSearchList = criteriaController.ParseCriteria<TextWithDropdown.ValueObject>("TextSearch");
if (txtSearchList.Count > 0)
{
// we ensure that the value the user gave us for text search type is a valid option
var confirmedOption = TextSearchDropdownValues().Find(x => x.Name == txtSearchList[0].Option) ?? TextSearchDropdownValues().First();
if (!String.IsNullOrEmpty(txtSearchList[0].Text))
{
searchText = txtSearchList[0].Text;
searchOption = confirmedOption.Value;
}
}
/* Courses */
var selectedGrades = criteriaController.ParseCriteria<CheckBoxList.ValueObject>("Grade").Select(x => x.Text).ToList();
var selectedSubjects = criteriaController.ParseCriteria<CheckBoxList.ValueObject>("Subject").Select(x => x.Text).ToList();
var selectedCourses = criteriaController.ParseCriteria<CheckBoxList.ValueObject>("Course").Select(x => x.Text).ToList();
var selectedStandardSets = new drGeneric_String(criteriaController.ParseCriteria<CheckBoxList.ValueObject>("StandardSet").Select(x => x.Text)); // take straight to drGeneric_String because it's going to SQL
var filteredCourses = CourseMasterList.GetStandardCoursesForUser(user).FilterByGradesSubjectsStandardSetsAndCourse(selectedGrades, selectedSubjects, selectedStandardSets, selectedCourses);
/* Type/Genre */
var selectedAddendumGenres = new drGeneric_String();
var selectedAddendumTypes = new drGeneric_String();
var selectedTypesGenres = criteriaController.ParseCriteria<AddendumType.ValueObject>("AddendumType");
foreach (var selectedTypesGenre in selectedTypesGenres)
{
if (selectedTypesGenre.Genre != null)
{
selectedAddendumGenres.Add(selectedTypesGenre.Genre);
}
else
{
selectedAddendumTypes.Add(selectedTypesGenre.Text);
}
}
if (selectedAddendumGenres.Count > 0)
selectedAddendumTypes.Add("Passage");
var selectedExpirationStatus = criteriaController.ParseCriteria<DropDownList.ValueObject>("ExpirationStatus").FirstOrDefault() != null ?
criteriaController.ParseCriteria<DropDownList.ValueObject>("ExpirationStatus").FirstOrDefault().Value : "I";
if (!ShowExpiredItems)
{
selectedExpirationStatus = "E";
}
drGeneric_String_String selectedExpirationDateRange = new drGeneric_String_String();
foreach (var val in criteriaController.ParseCriteria<DateRange.ValueObject>("ExpirationDateRange"))
{
selectedExpirationDateRange.Add(val.Type == "Start" ? "CreatedDateStart" : "CreatedDateEnd", val.Date);
}
/* Build Criteria Object */
var asc = new AddendumSearchCriteriaV2()
{
ItemBanks = itemBanks,
CourseList = filteredCourses,
AddendumType = selectedAddendumTypes,
AddendumGenre = selectedAddendumGenres,
UserAccessItemReservations = "",
Text = searchText,
TextOpt = searchOption,
SortKeyword = sortField,
courseSelected = selectedCourses.Count > 0 ? true : false,
ExpirationStatus = selectedExpirationStatus,
ExpirationDateRange = selectedExpirationDateRange
};
return asc;
}
/// <summary>
/// GetListOfStandards - Get string back of standard Id's to be used as a list.
/// </summary>
/// <param name="selectedStandards"></param>
/// <returns>string</returns>
private string GetListOfStandards(StandardSelections selectedStandards)
{
string stringListOfStandards = selectedStandards.Key;
if (!stringListOfStandards.IsInt() && !string.IsNullOrEmpty(selectedStandards.StandardSet))
{
var standardSetList = new drGeneric_String();
if (!String.IsNullOrEmpty(selectedStandards.StandardSet))
{
standardSetList.Add(selectedStandards.StandardSet.Trim());
}
var gradeList = new drGeneric_String();
if (!String.IsNullOrEmpty(selectedStandards.Grade))
{
gradeList.Add(selectedStandards.Grade.Trim());
}
var subjectList = new drGeneric_String();
if (!String.IsNullOrEmpty(selectedStandards.Subject))
{
subjectList.Add(selectedStandards.Subject.Trim());
}
var courseList = new drGeneric_String();
if (!String.IsNullOrEmpty(selectedStandards.Course))
{
courseList.Add(selectedStandards.Course.Trim());
}
DataTable filteredStandards = Base.Classes.Standards.SearchStandards(false,
"", //TextSearch
"", //TextSearchVal
null, //itemBanks
null, //StandardCourses
null,
standardSetList.Count > 0 ? standardSetList : null,
gradeList.Count > 0 ? gradeList : null,
subjectList.Count > 0 ? subjectList : null,
courseList.Count > 0 ? courseList : null);
List<object> listOfStandards = (from lststd in filteredStandards.DataSet.Tables[0].AsEnumerable()
select lststd["StandardID"]).ToList();
stringListOfStandards = string.Join(",", listOfStandards);
if (stringListOfStandards == "") stringListOfStandards = "0";
}
return stringListOfStandards;
}
private void DoSearch(bool excelExport=false)
{
var criteriaController = Master.CurrentCriteria(); // just going to go ahead and pull this from master instead of from search handler so it will work on tree updates
/* Courses */
var selectedGrades = criteriaController.ParseCriteria<E3Criteria.CheckBoxList.ValueObject>("Grade").Select(x => x.Text).ToList();
var selectedSubjects = criteriaController.ParseCriteria<E3Criteria.CheckBoxList.ValueObject>("Subject").Select(x => x.Text).ToList();
var selectedCourses = criteriaController.ParseCriteria<E3Criteria.CheckBoxList.ValueObject>("Course").Select(x => x.Text).ToList();
var selectedStandardSets = new drGeneric_String(criteriaController.ParseCriteria<E3Criteria.CheckBoxList.ValueObject>("StandardSet").Select(x => x.Text)); // take straight to drGeneric_String because it's going to SQL
var filteredCourses = CourseMasterList.GetStandardCoursesForUser(SessionObject.LoggedInUser).FilterByGradesSubjectsStandardSetsAndCourse(selectedGrades, selectedSubjects, selectedStandardSets, selectedCourses);
List<DropDownList.ValueObject> selectedLevels = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("Level");
_standardLevel = selectedLevels.Count > 0 ? selectedLevels[0].Text : "";
/* Text Search */
string searchText = string.Empty;
string searchOption = string.Empty;
var txtSearchList = criteriaController.ParseCriteria<TextWithDropdown.ValueObject>("TextSearch");
if (txtSearchList.Count > 0)
{
// we ensure that the value the user gave us for text search type is a valid option
var confirmedOption = TextSearchDropdownValues().Find(x => x.Name == txtSearchList[0].Option) ?? TextSearchDropdownValues().First();
if (!String.IsNullOrEmpty(txtSearchList[0].Text))
{
searchText = txtSearchList[0].Text;
searchOption = confirmedOption.Value;
}
}
/* Standard Filters */
var standardFilters = new drGeneric_Int();
var selectedStandardFilter = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("StandardFilter");
if (selectedStandardFilter != null && selectedStandardFilter.Count >= 1 && SessionObject.LoggedInUser.StandardFilters.ContainsKey(selectedStandardFilter[0].Text))
{
IEnumerable<int> ids = SessionObject.LoggedInUser.StandardFilters[selectedStandardFilter[0].Text].Split(',').Select(DataIntegrity.ConvertToInt);
standardFilters.AddRange(ids);
}
dtItemBank itemBanks = ItemBankMasterList.GetItemBanksForUser(SessionObject.LoggedInUser, ThinkgatePermission.PermissionLevelValues.ItemBankEdit, "Search");
DtGrid = Thinkgate.Base.Classes.Standards.SearchStandards( itemReservation: UserHasPermission(Permission.Access_ItemReservation),
textSearch:searchText,
textSearchVal:searchOption,
itemBanks:itemBanks,
standardCourses:filteredCourses,
filterList:standardFilters,
standardSetList:selectedStandardSets,
standardLevel: _standardLevel);
// Add columns to the data table.
DataColumn displayTextCol = DtGrid.Columns.Add("NameDisplayText", typeof(String));
List<Int32> allStandardIds = (from s in DtGrid.AsEnumerable() select s.Field<Int32>("StandardID")).Distinct().ToList();
String currRoot = "";
foreach (DataRow row in DtGrid.Rows)
{
currRoot = (String)((String)row["StandardName"]).Clone();
row[displayTextCol] = currRoot;
}
if (excelExport)
return;
DtGrid = Standpoint.Core.Classes.Encryption.EncryptDataTableColumn(DtGrid, "StandardID", "LinkID");
if (_isStandardEncrypted)
{
DtGrid = Standpoint.Core.Classes.Encryption.EncryptDataTableColumn(DtGrid, "StandardID", "EncryptedID");
}
else
{
DtGrid.Columns.Add("EncryptedID");
foreach (DataRow dr in DtGrid.Rows)
{
dr["EncryptedID"] = dr["StandardID"];
}
}
foreach (DataRow row in DtGrid.Rows)
{
if (row["ParentID"].Equals(0) || !string.IsNullOrEmpty(searchText))
{
row["ParentID"] = System.DBNull.Value;
}
}
if (DtGrid != null)
{
if (DtGrid.Rows.Count > 5000)
{
var windowManager = Master.FindControl("RadWindowManager1");
if (windowManager != null)
{
RadWindowManager radWindowManager = (RadWindowManager)windowManager;
radWindowManager.RadAlert(LargeCountMessage, 330, 180, "Message from webpage", string.Empty);
}
DataTable dt = DtGrid.Rows.Cast<System.Data.DataRow>().Take(5000).CopyToDataTable();
DtGrid.Clear();
DtGrid = dt;
}
DataView dv = new DataView(DtGrid, "", "", DataViewRowState.CurrentRows);
radTreeResults.DataSource = dv;
}
}
/// <summary>
/// Builds the QuestionSearchCriteria. Used both from Search Button and from Service
/// </summary>
public static ItemImageSearchCriteriaV2 BuildSearchCriteriaObject(ThinkgateUser user, CriteriaController criteriaController, string requestedSortField = null)
{
/* Sort */
string sortField = null;
NameValue nvSortField = SortFields().Find(x => x.Name == requestedSortField); // ensure that the user given value for sort is in the defined list of options
if (nvSortField != null) sortField = nvSortField.Value;
/* Item Banks - Remove from master list based on filter if given */
var itemBanks = ItemBankMasterList.GetItemBanksForUser(user);
var selectedItemBanks = criteriaController.ParseCriteria<CheckBoxList.ValueObject>("ItemBank").Select(x => x.Text);
if (selectedItemBanks.Any()) itemBanks.DeleteByLabel(selectedItemBanks);
/* Text Search */
string searchText = string.Empty;
string searchOption = string.Empty;
var txtSearchList = criteriaController.ParseCriteria<TextWithDropdown.ValueObject>("TextSearch");
if (txtSearchList.Count > 0)
{
// we ensure that the value the user gave us for text search type is a valid option
var confirmedOption = TextSearchDropdownValues().Find(x => x.Name == txtSearchList[0].Option) ?? TextSearchDropdownValues().First();
if (!String.IsNullOrEmpty(txtSearchList[0].Text))
{
searchText = txtSearchList[0].Text;
searchOption = confirmedOption.Value;
}
}
/* Courses */
var selectedGrades = criteriaController.ParseCriteria<CheckBoxList.ValueObject>("Grade").Select(x => x.Text).ToList();
var selectedSubjects = criteriaController.ParseCriteria<CheckBoxList.ValueObject>("Subject").Select(x => x.Text).ToList();
var selectedCourses = criteriaController.ParseCriteria<CheckBoxList.ValueObject>("Course").Select(x => x.Text).ToList();
var selectedStandardSets = new drGeneric_String(criteriaController.ParseCriteria<CheckBoxList.ValueObject>("StandardSet").Select(x => x.Text)); // take straight to drGeneric_String because it's going to SQL
var filteredCourses = CourseMasterList.GetStandardCoursesForUser(user).FilterByGradesSubjectsStandardSetsAndCourse(selectedGrades, selectedSubjects, selectedStandardSets, selectedCourses);
var selectedExpirationStatus = criteriaController.ParseCriteria<DropDownList.ValueObject>("ExpirationStatus").FirstOrDefault() != null ?
criteriaController.ParseCriteria<DropDownList.ValueObject>("ExpirationStatus").FirstOrDefault().Value : "I";
if (!ShowExpiredItems)
{
selectedExpirationStatus = "E";
}
drGeneric_String_String selectedExpirationDateRange = new drGeneric_String_String();
foreach (var val in criteriaController.ParseCriteria<DateRange.ValueObject>("ExpirationDateRange"))
{
selectedExpirationDateRange.Add(val.Type == "Start" ? "CreatedDateStart" : "CreatedDateEnd", val.Date);
}
/* Build Criteria Object */
var asc = new ItemImageSearchCriteriaV2()
{
ItemBanks = itemBanks,
StandardCourses = filteredCourses,
TextWords = searchText,
TextWordsOpt = searchOption,
GradeLimited = selectedGrades.Count > 0,
SubjectLimited = selectedSubjects.Count > 0,
CourseLimited = selectedCourses.Count > 0,
SortBy = sortField == "ItemBank" || sortField == "Standard"
? null
: sortField,
ExpirationStatus = selectedExpirationStatus,
ExpirationDateRange = selectedExpirationDateRange
};
return asc;
}
private void BindPageControls()
{
List<string> selectedAlignments = GetSelectedNodeWithChildren();
DataSet ds = new DataSet();
bool flagFetchFreshData = true;
if (Session["dsCredentials"] != null)
{
ds = (DataSet)Session["dsCredentials"];
try
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
flagFetchFreshData = false;
}
}
catch (Exception ex)
{
flagFetchFreshData = true;
}
}
if (flagFetchFreshData)
{
drGeneric_String drStringObj = new drGeneric_String();
foreach (string str in selectedAlignments)
{
drStringObj.Add(str);
}
//include drStringObj in future
ds = Base.Classes.Credentials.GetCredentials("ALL", "DETAIL");
Session["dsCredentials"] = ds;
}
if (ds != null && ds.Tables.Count == 4)
{
ds.Relations.Clear();
ds.Relations.Add(new DataRelation("CredentialUrls", ds.Tables[0].Columns["ID"], ds.Tables[3].Columns["CredentialId"], false));
ds.Relations.Add(new DataRelation("CredentialAlignments", ds.Tables[0].Columns["ID"], ds.Tables[2].Columns["CredentialId"], false));
ds.Relations.Add(new DataRelation("CredentialAlignmentsMaster", ds.Tables[2].Columns["AlignmentId"], ds.Tables[1].Columns["ID"], false));
List<int> iAlign = new List<int>();
if (!this.IsPostBack)
{
ds.Tables[0].DefaultView.RowFilter = ddlEarned.SelectedIndex == 0 ? "IsActive = true" : "IsActive= false";
gridCredentials.DataSource = ds.Tables[0].DefaultView;
gridCredentials.DataBind();
}
else
{
string filter = string.Empty;
if (selectedAlignments.Count > 0 && selectedAlignments[0] == "0")
{
filter = ddlEarned.SelectedIndex == 0 ? "IsActive = true" : "IsActive= false";
}
else
{
if (selectedAlignments.Count > 0)
{
ds.Tables[2].DefaultView.RowFilter = "AlignmentId in (" + string.Join(",", selectedAlignments.ToArray()) + ")";
foreach (DataRow dr in ds.Tables[2].DefaultView.ToTable().Rows)
{
iAlign.Add(Convert.ToInt32(dr["CredentialId"]));
}
if (iAlign.Count == 0)
{
iAlign.Add(0);
}
}
string status = ddlEarned.SelectedIndex == 0 ? "IsActive = true" : "IsActive= false";
if (iAlign.Count > 0)
filter = status + " AND ID in (" + string.Join(",", iAlign.ToArray()) + ")";
else
filter = status;
}
ds.Tables[0].DefaultView.RowFilter = filter;
gridCredentials.DataSource = ds.Tables[0].DefaultView;
gridCredentials.DataBind();
}
}
BindAlignmentsTree();
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "SetControlCSS", "setControlCSS();", true);
}
private void BindPageControls()
{
lblStudentName.Text = _selectedStudent.StudentName;
lblStudentName.Attributes.Add("initialValue", lblStudentName.Text);
List<string> selectedAlignments = GetSelectedNodeWithChildren();
DataSet ds = new DataSet();
bool flagFetchFreshData = true;
if (Session["dsStudentCredentials"] != null)
{
ds = (DataSet)Session["dsStudentCredentials"];
try
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0]["StudentId"]) == GetDecryptedEntityId(X_ID))
{
flagFetchFreshData = false;
}
}
catch (Exception ex)
{
flagFetchFreshData = true;
}
}
if (flagFetchFreshData)
{
drGeneric_String drStringObj = new drGeneric_String();
foreach (string str in selectedAlignments)
{
drStringObj.Add(str);
}
ds = Base.Classes.Credentials.GetCredentialsForStudent(_selectedStudent.ID, StudentCredentialsView.Detail, drStringObj);
Session["dsStudentCredentials"] = ds;
}
if (ds != null)
{
if (ds.Tables.Count > 2)
{
ds.Relations.Clear();
ds.Relations.Add(new DataRelation("CredentialUrls", ds.Tables[0].Columns["CredentialID"], ds.Tables[2].Columns["CredentialID"], false));
}
if (ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
DataSet dsComment = GetStudentComments(_selectedStudent.ID.ToString() + "_" + dr["CredentialID"].ToString(), Convert.ToInt32(Convert.IsDBNull(dr["ID"]) ? 0 : dr["ID"]), _selectedStudent.ID, Convert.ToInt32(dr["CredentialID"]));
if (dsComment != null && dsComment.Tables.Count > 1)
{
dr["CommentsCount"] = dsComment.Tables[1].Rows.Count;
}
}
ds.Tables[0].DefaultView.RowFilter = ddlEarned.SelectedIndex == 1 ? "Earned = 1" : "1=1";
gridStudentCredentials.DataSource = ds.Tables[0];
gridStudentCredentials.DataBind();
}
if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0 /*There should always be 1 row containing credentials count*/)
{
lblCredentialsEarned.Text = ds.Tables[1].Rows[0]["CredentialsCount"].ToString();
}
}
if (SessionObject.IsAlignmentDataAvailable == null)
{
SessionObject.IsAlignmentDataAvailable = Base.Classes.Credentials.IsAlignmentDataAvailable();
}
if (SessionObject.IsAlignmentDataAvailable == true)
{
ddlAlignments.Visible = true;
BindAlignmentsTree();
}
else
{
ddlAlignments.Visible = false;
}
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "RefreshCommentLink", "commentLinkEnable();", true);
}
