public void BindStudentDetails(string StudentID)
{
try
{
StudentGenderwiseReport_BLogic objStudentReport = new StudentGenderwiseReport_BLogic();
DataTable dtResult = new DataTable();
dtResult = objStudentReport.GetStudentDetailsByStudentIDAcademicYear(Convert.ToInt32(StudentID), Session["ReportYear"].ToString());
if (dtResult.Rows.Count > 0)
{
lblFirstNameValue.Text = dtResult.Rows[0]["FirstName"].ToString();
lblMiddleNameValue.Text = dtResult.Rows[0]["MiddleName"].ToString();
lblLastNameValue.Text = dtResult.Rows[0]["LastName"].ToString();
lblGenderValue.Text = dtResult.Rows[0]["Gender"].ToString();
lblDoBValue.Text = Convert.ToDateTime(dtResult.Rows[0]["DateOfBirth"]).ToString("dd-MMM-yyyy");
lblAddressValue.Text = dtResult.Rows[0]["Address"].ToString();
lblContactNoValue.Text = dtResult.Rows[0]["ContactNo"].ToString();
lblEmailIDValue.Text = dtResult.Rows[0]["EmailID"].ToString();
lblBloodGroupValue.Text = dtResult.Rows[0]["BloodGroup"].ToString();
lblBMSValue1.Text = dtResult.Rows[0]["BMS"].ToString();
lblSchoolValue1.Text = dtResult.Rows[0]["School"].ToString();
lblGrNoValue.Text = dtResult.Rows[0]["GRNo"].ToString();
lblRollNoValue.Text = dtResult.Rows[0]["RollNo"].ToString();
lblCurrentYearValue.Text = dtResult.Rows[0]["CurrentAcademicYear"].ToString();
lblDivValue.Text = dtResult.Rows[0]["Division"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void StageFirstCalling()
{
objGenderReport = new StudentGenderwiseReport_BLogic();
SchoolwiseStudentGenderGrid.Visible = true;
dsResult = new DataSet();
dsResult = objGenderReport.GetSchoolwiseStudentGenderReport(this.SchoolID);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
SchoolwiseStudentGenderGrid.XMLReportFile = Server.MapPath("../ReportXMLFiles/SchoolwiseStudentGender.xml");
SchoolwiseStudentGenderGrid.Search(dsResult.Tables[0]);
CurrentReport = "Schoolwise Report";
}
private void StageThirdCalling()
{
objStudentReport = new StudentGenderwiseReport_BLogic();
dsResult = new DataSet();
dsResult = objStudentReport.GetStudentListBySchoolBMSGenderDivisionID(this.SchoolID, this.BMSID, this.DivisionID, this.AcademicYear);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaStudentString();
BMSwiseStudentList.XMLReportFile = Server.MapPath("../ReportXMLFiles/BMSwiseStudentListReport.xml");
BMSwiseStudentList.Search(dsResult.Tables[0]);
CurrentReport = "BMSwise Student List";
}
private void StageTwoCalling()
{
dsResult = new DataSet();
this.objGenderReport = new StudentGenderwiseReport_BLogic();
dsResult = objGenderReport.GetBMSwiseStudentGenderReport(this.SchoolID, this.BoardID, this.MediumID, this.StandardID, this.AcademicYear);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaStudentString();
BMSwiseStudentGender.XMLReportFile = Server.MapPath("../ReportXMLFiles/BMSwiseStudentGenderReport.xml");
BMSwiseStudentGender.Search(dsResult.Tables[0]);
CurrentReport = "BMSwise Student Gender";
}