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);
}
}