public BOReportComparer(BOReport.Columns column, BOReport.SortDirections direction) { _column = column; _direction = direction; }
private void LoadInternalsMarksMonthwise(string instituteId, string month, string year) { DataTable branches = new BOPersonalizeApplication().GetClassesList(instituteId); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[6] { new DataColumn("colBranchName", typeof(string)), new DataColumn("colSubjectName", typeof(string)), new DataColumn("col0", typeof(string)), new DataColumn("col35",typeof(string)), new DataColumn("col60",typeof(string)), new DataColumn("col85",typeof(string)) }); for (int j = 0; j < branches.Rows.Count; j++) { DataTable subjects = new BOPersonalizeApplication().GetSubjectsList(instituteId, int.Parse(branches.Rows[j][0].ToString())); for (int p = 0; p < subjects.Rows.Count; p++) { List<DTOClasswiseCount> col0Count = new BOReport().GetStudentInternalsCountClasswiseReport(Convert.ToInt32(instituteId), "col0", int.Parse(branches.Rows[j][0].ToString()), month, year, int.Parse(subjects.Rows[p][0].ToString())); List<DTOClasswiseCount> col35Count = new BOReport().GetStudentInternalsCountClasswiseReport(Convert.ToInt32(instituteId), "col35", int.Parse(branches.Rows[j][0].ToString()), month, year, int.Parse(subjects.Rows[p][0].ToString())); List<DTOClasswiseCount> col60Count = new BOReport().GetStudentInternalsCountClasswiseReport(Convert.ToInt32(instituteId), "col60", int.Parse(branches.Rows[j][0].ToString()), month, year, int.Parse(subjects.Rows[p][0].ToString())); List<DTOClasswiseCount> col85Count = new BOReport().GetStudentInternalsCountClasswiseReport(Convert.ToInt32(instituteId), "col85", int.Parse(branches.Rows[j][0].ToString()), month, year, int.Parse(subjects.Rows[p][0].ToString())); int count = Max(col0Count.Count, col35Count.Count, col60Count.Count, col85Count.Count); for (int i = 0; i < count; i++) { string finalcol0Count = "0"; if (col0Count.Count > i) { finalcol0Count = col0Count[i].Count.ToString(); } string finalcol35Count = "0"; if (col35Count.Count > i) { finalcol35Count = col35Count[i].Count.ToString(); } string finalcol60Count = "0"; if (col60Count.Count > i) { finalcol60Count = col60Count[i].Count.ToString(); } string finalcol85Count = "0"; if (col85Count.Count > i) { finalcol85Count = col85Count[i].Count.ToString(); } dt.Rows.Add(branches.Rows[j][1].ToString(), subjects.Rows[p][3].ToString(), finalcol0Count, finalcol35Count, finalcol60Count, finalcol85Count); } } } gvInternalsMonth.DataSource = dt; gvInternalsMonth.DataBind(); for (int i = 2; i < dt.Columns.Count; i++) { Series attseries = new Series(); foreach (DataRow dr in dt.Rows) { object y = dr[i]; attseries.Points.AddXY(String.Concat(dr["colBranchName"].ToString(), dr["colSubjectName"].ToString()), y); } chrtInternalsMonth.Series.Add(attseries); } }
private void LoadStudentsCount(string instituteId) { DTOInstituteDetails toins = new DTOInstituteDetails(); toins.InstituteID = int.Parse(instituteId); int? allCount = new BOReport().GetStudentCountReport(toins, "All"); int? maleCount = new BOReport().GetStudentCountReport(toins, "Male"); int? femaleCount = new BOReport().GetStudentCountReport(toins, "Female"); double? allPercent = (double)((double)allCount / double.Parse(Session["MaxStudentsInstitute"].ToString())); dvAllCount.InnerText = String.Concat(String.Format("{0:0.00}", (allPercent * 100)).ToString(), "%"); dvAllCount.Attributes["data-percent"] = (allPercent * 100).ToString(); lblAllCount.InnerText = allCount.ToString(); lblAllCountText.InnerText = "Total Students"; double? malePercent = (double)((double)maleCount / (double)allCount); dvMaleCount.InnerText = String.Concat(String.Format("{0:0.00}", (malePercent * 100)).ToString(), "%"); dvMaleCount.Attributes["data-percent"] = (malePercent * 100).ToString(); lblMaleCount.InnerText = maleCount.ToString(); lblMaleCountText.InnerText = "Male"; double? femalePercent = (double)((double)femaleCount / (double)allCount); dvFemaleCount.InnerText = String.Concat(String.Format("{0:0.00}", (femalePercent * 100)).ToString(), "%"); dvFemaleCount.Attributes["data-percent"] = (femalePercent * 100).ToString(); lblFemaleCount.InnerText = femaleCount.ToString(); lblFemaleCountText.InnerText = "Female"; }
private void LoadStudentsCountClasswise(string instituteId) { DTOInstituteDetails toins = new DTOInstituteDetails(); toins.InstituteID = int.Parse(instituteId); DataTable branches = new BOPersonalizeApplication().GetClassesList(instituteId); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[4] { new DataColumn("colBranchName", typeof(string)), new DataColumn("colTotalCount", typeof(string)), new DataColumn("colMaleCount",typeof(string)) , new DataColumn("colFemaleCount",typeof(string)) }); for (int j = 0; j < branches.Rows.Count; j++) { List<DTOClasswiseCount> allCount = new BOReport().GetStudentCountClasswiseReport(toins, "All", int.Parse(branches.Rows[j][0].ToString())); List<DTOClasswiseCount> maleCount = new BOReport().GetStudentCountClasswiseReport(toins, "Male", int.Parse(branches.Rows[j][0].ToString())); List<DTOClasswiseCount> femaleCount = new BOReport().GetStudentCountClasswiseReport(toins, "Female", int.Parse(branches.Rows[j][0].ToString())); for (int i = 0; i < allCount.Count; i++) { string finalMaleCount = "0"; if (maleCount.Count > i) { finalMaleCount = maleCount[i].Count.ToString(); } string finalFemaleCount = "0"; if (femaleCount.Count > i) { finalFemaleCount = femaleCount[i].Count.ToString(); } dt.Rows.Add(allCount[i].ClassName, allCount[i].Count.ToString(), finalMaleCount, finalFemaleCount); } } for (int i = 1; i < dt.Columns.Count; i++) { Series series = new Series(); foreach (DataRow dr in dt.Rows) { int y = Convert.ToInt32(dr[i]); series.Points.AddXY(dr["colBranchName"].ToString(), y); } chrtStudentsStrengthvsClass.Series.Add(series); } gvClasswiseStrength.DataSource = dt; gvClasswiseStrength.DataBind(); }
private void LoadStudentsAttendanceClasswise(string instituteId, string month, string year) { DataTable branches = new BOPersonalizeApplication().GetClassesList(instituteId); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[3] { new DataColumn("colBranchName", typeof(string)), new DataColumn("col35", typeof(string)), new DataColumn("col85",typeof(string)) }); for (int j = 0; j < branches.Rows.Count; j++) { List<DTOClasswiseCount> lt85Count = new BOReport().GetStudentAttendanceCountClasswiseReport(Convert.ToInt32(instituteId), "lt85", int.Parse(branches.Rows[j][0].ToString()), month, year); List<DTOClasswiseCount> gt85Count = new BOReport().GetStudentAttendanceCountClasswiseReport(Convert.ToInt32(instituteId), "gt85", int.Parse(branches.Rows[j][0].ToString()), month, year); int count = 0; if (lt85Count.Count > 0) { count = lt85Count.Count; } else { count = gt85Count.Count; } for (int i = 0; i < count; i++) { string finallt85Count = "0"; if (lt85Count.Count > i) { finallt85Count = lt85Count[i].Count.ToString(); } string finalgt85Count = "0"; if (gt85Count.Count > i) { finalgt85Count = gt85Count[i].Count.ToString(); } dt.Rows.Add(branches.Rows[j][1].ToString(), finallt85Count, finalgt85Count); } } gvAttendanceMonth.DataSource = dt; gvAttendanceMonth.DataBind(); for (int i = 1; i < dt.Columns.Count; i++) { Series attseries = new Series(); foreach (DataRow dr in dt.Rows) { int y = Convert.ToInt32(dr[i]); attseries.Points.AddXY(dr["colBranchName"].ToString(), y); } chrtAttendanceMonth.Series.Add(attseries); } }