public static Table Sort(Table table, TblCurriculums curriculum) { Table temp = new Table(); TableHeaderRow headerRow = new TableHeaderRow(); TableHeaderCell headerCell = new TableHeaderCell(); headerCell.Text = Translations.TeacherHelper_Sort_Student; headerRow.Cells.Add(headerCell); foreach (TblStages stage in TeacherHelper.StagesOfCurriculum(curriculum)) { foreach (TblThemes theme in TeacherHelper.ThemesOfStage(stage)) { headerCell = new TableHeaderCell(); headerCell.Text = theme.Name; headerRow.Cells.Add(headerCell); } } headerCell = new TableHeaderCell(); headerCell.Text = Translations.TeacherHelper_Sort_Total; headerRow.Cells.Add(headerCell); headerCell = new TableHeaderCell(); headerCell.Text = Translations.TeacherHelper_Sort_Percent; headerRow.Cells.Add(headerCell); headerCell = new TableHeaderCell(); headerCell.Text = "ECTS"; headerRow.Cells.Add(headerCell); temp.Rows.Add(headerRow); for (int i = 1; i < table.Rows.Count; i++) { int max = 0; int row = 0; for (int j = 1; j < table.Rows.Count; j++) { if (Int32.Parse(table.Rows[j].Cells[table.Rows[j].Cells.Count - 2].Text) > max) { max = Int32.Parse(table.Rows[j].Cells[table.Rows[j].Cells.Count - 2].Text); row = j; } } temp.Rows.Add(table.Rows[row]); table.Rows.RemoveAt(row); i--; } return(temp); }
public static bool StageContainsTheme(int stageID, int orgID) { TblStages stage = ServerModel.DB.Load <TblStages>(stageID); TblOrganizations org = ServerModel.DB.Load <TblOrganizations>(orgID); foreach (TblThemes childThemes in TeacherHelper.ThemesOfStage(stage)) { if (childThemes.OrganizationRef == org.ID) { return(true); } } return(false); }
public static Table Search_Function(Table table, string Search_Name, TblCurriculums curriculum, List <TblCurriculums> curriculums, int GroupID, string RawUrl) { Table temp = new Table(); if (curriculum != null) { TableHeaderRow headerRow = new TableHeaderRow(); TableHeaderCell headerCell = new TableHeaderCell(); headerCell.Text = Translations.TeacherHelper_Sort_Student; headerRow.Cells.Add(headerCell); foreach (TblStages stage in TeacherHelper.StagesOfCurriculum(curriculum)) { foreach (TblThemes theme in TeacherHelper.ThemesOfStage(stage)) { headerCell = new TableHeaderCell(); headerCell.Text = theme.Name; headerRow.Cells.Add(headerCell); } } headerCell = new TableHeaderCell(); headerCell.Text = Translations.TeacherHelper_Sort_Total; headerRow.Cells.Add(headerCell); headerCell = new TableHeaderCell(); headerCell.Text = Translations.TeacherHelper_Sort_Percent; headerRow.Cells.Add(headerCell); headerCell = new TableHeaderCell(); headerCell.Text = "ECTS"; headerRow.Cells.Add(headerCell); temp.Rows.Add(headerRow); } else { TableHeaderRow headerRow = new TableHeaderRow(); TableHeaderCell headerCell = new TableHeaderCell(); headerCell.Text = Translations.TeacherHelper_Sort_Student; headerRow.Cells.Add(headerCell); foreach (TblCurriculums curr in curriculums) { headerCell = new TableHeaderCell { HorizontalAlign = HorizontalAlign.Center }; headerCell.Controls.Add(new HyperLink { Text = curr.Name, NavigateUrl = ServerModel.Forms.BuildRedirectUrl(new IUDICO.DataModel.Controllers.StatisticShowController { GroupID = GroupID, CurriculumID = curr.ID, BackUrl = RawUrl }) }); headerRow.Cells.Add(headerCell); } headerCell = new TableHeaderCell(); headerCell.Text = Translations.TeacherHelper_Sort_Total; headerRow.Cells.Add(headerCell); headerCell = new TableHeaderCell(); headerCell.Text = Translations.TeacherHelper_Sort_Percent; headerRow.Cells.Add(headerCell); headerCell = new TableHeaderCell(); headerCell.Text = "ECTS"; headerRow.Cells.Add(headerCell); temp.Rows.Add(headerRow); } for (int i = 1; i < table.Rows.Count; i++) { string[] temp_array = table.Rows[i].Cells[0].Text.ToString().Split(' '); if (temp_array.Length == 2) { if (Find_Student(Search_Name, temp_array[0], temp_array[1]) == true) { temp.Rows.Add(table.Rows[i]); i--; } } else { if (Find_Student(Search_Name, temp_array[0], "") == true) { temp.Rows.Add(table.Rows[i]); } } } return(temp); }