private void RefreshGridView() { DataTable dt = new BOPersonalizeApplication().GetClassesList(Session["InstituteID"].ToString()); string strSort = String.Empty; if (ViewState.Keys.Count > 0) { strSort = String.Format("{0} {1}", m_strSortExp, (m_SortDirection == SortDirection.Descending) ? "DESC" : "ASC"); dt.DefaultView.Sort = strSort; } DataView dv = new DataView(dt, String.Empty, strSort, DataViewRowState.CurrentRows); gvClasses.DataSource = dv; gvClasses.DataBind(); }
private void BindSubjectsList() { DataTable dt = new BOPersonalizeApplication().GetSubjectsList(Session["InstituteID"].ToString(), int.Parse(ddlClass.SelectedValue)); ddlSubjects.DataSource = dt; ddlSubjects.DataBind(); System.Web.UI.WebControls.ListItem Item = new System.Web.UI.WebControls.ListItem("Select", "Select"); ddlSubjects.Items.Insert(0, Item); ddlSubjects.SelectedIndex = 0; }
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 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 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); } }