protected void btnback_Click(object sender, EventArgs e)
{
if (CurrentReport == "SchoolAttendance")
{
}
else if (CurrentReport == "ClassAttendance")
{
rptSchoolAttendance.Visible = true;
rptClassAttendance.Visible = false;
//FirstReport.Visible = true;
Div1.Visible = true;
secondRpt.Visible = false;
btnback.Visible = false;
DataSet ds = new DataSet();
this.Obj_Dal_ClassroomWiseAttendance = new ClassroomWiseAttendance();
ReportsForResult objRsultReport = new ReportsForResult();
ds = this.Obj_Dal_ClassroomWiseAttendance.GetClasswiseAttendance(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(ddlBoard.SelectedValue), Convert.ToInt32(ddlMedium.SelectedValue), Convert.ToInt32(ddlStandard.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue), Get_DDMMYYYY(txtDate.Text));
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
try
{
rptSchoolAttendance.XMLReportFile = Server.MapPath("../ReportXMLFiles/ClassroomWiseAttendanceFirst.xml");
rptSchoolAttendance.Search(ds.Tables[0]);
CurrentReport = "SchoolAttendance";
}
catch (Exception ex)
{
WebMsg.Show("" + ex.Message.ToString());
}
}
}
private void StageFirstCalling()
{
DataSet ds = new DataSet();
this.Obj_Dal_AgewiseStudentReport = new AgewiseStudentReport();
string Groupname;
string Year;
if (ddlGroupName.SelectedIndex == 0)
{
Groupname = null;
}
else
{
Groupname = ddlGroupName.SelectedItem.ToString();
}
if (ddlYear.SelectedIndex == 0)
{
Year = null;
}
else
{
Year = ddlYear.SelectedItem.ToString();
}
ds = this.Obj_Dal_AgewiseStudentReport.GetAgewiseStudentReport(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(ddlBoard.SelectedValue), Convert.ToInt32(ddlMedium.SelectedValue), Convert.ToString(Groupname), Convert.ToString(Year));
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
rptSchool.Visible = true;
CommanCallUserControl(ds, "../ReportXMLFiles/AgewiseStudentReportFirst.xml");
rptSchool.Search(ds.Tables[0]);
CurrentReport = "School";
}
private void CommanCallUserControl(DataTable dt, string reporttype, int control)
{
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
try
{
if (control == 1)
{
RptCtrlSessionSummury.ConnectionString = connectionstring;
RptCtrlSessionSummury.XMLReportFile = Server.MapPath(reporttype);
RptCtrlSessionSummury.Search(dt);
RptCtrlSessionSummury.Visible = true;
}
else if (control == 2)
{
RptCtrlSessionDetails.ConnectionString = connectionstring;
RptCtrlSessionDetails.XMLReportFile = Server.MapPath(reporttype);
RptCtrlSessionDetails.Search(dt);
RptCtrlSessionDetails.Visible = true;
lblfooterdiv.Visible = false;
}
}
catch (Exception ex)
{
WebMsg.Show("" + ex.Message.ToString());
}
}
private void StageOneCalli()
{
DataSet ds = new DataSet();
ReportsForResult objRsultReport = new ReportsForResult();
ds = objRsultReport.BAL_SYS_ResultStudentwise_Select(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(ddlBoard.SelectedValue), Convert.ToInt32(ddlMedium.SelectedValue), Convert.ToInt32(ddlStandard.SelectedValue), Convert.ToInt32(ddlsubject.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue), Convert.ToDateTime(txtfromdate.Text), Convert.ToDateTime(txttodate.Text));
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
WebUserControl1.Visible = true;
CommanCallUserControl(ds, "../ReportXMLFiles/StudentWiseFirstReport.xml");
}
private void StageTwoCalling()
{
DataSet ds = new DataSet();
ReportsForResult objRsultReport = new ReportsForResult();
ds = objRsultReport.BAL_SYS_ResultClassroomwiseByFirRPT_Select(this.SchoolID, this.BMSSCTID, this.EmployeeID, this.DivisionID, this.ExamDate);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
CommanCallUserControl(ds, "../ReportXMLFiles/SchoolExamReportsSec.xml");
}
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";
}
private void StageThirdCalling()
{
DataSet dtResult = new DataSet();
this.Obj_Dal_AgewiseStudentReport = new AgewiseStudentReport();
dtResult = this.Obj_Dal_AgewiseStudentReport.GetAgewiseStudent(this.SchoolID, this.BoardID, this.MediumID, this.GroupName, this.Year, this.BMSID, this.DivisionID, this.Description);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
rptStudent.XMLReportFile = Server.MapPath("../ReportXMLFiles/AgewiseStudentReportThird.xml");
rptStudent.Search(dtResult.Tables[0]);
CurrentReport = "Student";
}
private void StageSecondCalling()
{
DataSet dtResult = new DataSet();
this.Obj_Dal_AgewiseStudentReport = new AgewiseStudentReport();
dtResult = this.Obj_Dal_AgewiseStudentReport.GetAgewise(this.SchoolID, this.BoardID, this.MediumID, this.GroupName, this.Year, this.StudentAgeGropIDPara);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
rptAgeGroup.XMLReportFile = Server.MapPath("../ReportXMLFiles/AgewiseStudentReportSecond.xml");
rptAgeGroup.Search(dtResult.Tables[0]);
CurrentReport = "AgeGroup";
}
private void StageForthCalling()
{
obj_Dal_ClasswiseCoveredSyllabus = new ClasswiseCoveredSyllabus();
DataSet dsResult = new DataSet();
dsResult = obj_Dal_ClasswiseCoveredSyllabus.GetTopicwiseCoveredSyllavbus(this.BMSID, this.SubjectID, this.DivisionID, this.SchoolID, this.ChapterID);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
TopicwiseSyllabusGrid.XMLReportFile = Server.MapPath("../ReportXMLFiles/TopicwiseCoveredSyllabus.xml");
TopicwiseSyllabusGrid.Search(dsResult.Tables[0]);
CurrentReport = "Topicwise Report";
//CommanCallUserControl(dsResult, "../ReportXMLFiles/TopicwiseCoveredSyllabus.xml");
}
private void CommanCallUserControl(DataSet dtResult, string reporttype)
{
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
try
{
ClasswiseSyllabusGrid.ConnectionString = connectionstring;
ClasswiseSyllabusGrid.XMLReportFile = Server.MapPath(reporttype);
ClasswiseSyllabusGrid.Search(dtResult.Tables[0]);
}
catch (Exception ex)
{
WebMsg.Show("" + ex.Message.ToString());
}
}
private void StageOneCalling()
{
DataSet dtResult = new DataSet();
this.obj_Dal_ClasswiseCoveredSyllabus = new ClasswiseCoveredSyllabus();
dtResult = this.obj_Dal_ClasswiseCoveredSyllabus.GetClasswiseCoveredDetails(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(ddlBoard.SelectedValue), Convert.ToInt32(ddlMedium.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue), Convert.ToInt32(ddlStandard.SelectedValue), Convert.ToInt32(ddlSubject.SelectedValue), Convert.ToInt32(ddlChapter.SelectedValue), Convert.ToInt32(ddlTopic.SelectedValue));
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
ClasswiseSyllabusGrid.XMLReportFile = Server.MapPath("../ReportXMLFiles/ClasswiseCoveredSyllabus.xml");
ClasswiseSyllabusGrid.Search(dtResult.Tables[0]);
CurrentReport = "Classwise Report";
ClasswiseSyllabusGrid.Visible = true;
//CommanCallUserControl(dtResult, "../ReportXMLFiles/ClasswiseCoveredSyllabus.xml");
}
private void StageTwoCalling()
{
DataSet ds = new DataSet();
ReportsForResult objRsultReport = new ReportsForResult();
ds = objRsultReport.BAL_SYS_ResultStudentwiseSecond_Select(this.SchoolID, this.StudentID, this.BMSID, this.SubjectID, this.DivisionID, this.FromDate, this.ToDate);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
CommanCallUserControl(ds, "../ReportXMLFiles/StudentWiseReportSecond.xml");
Chart1.Visible = true;
BindChart(ds);
}
private void CommanCallUserControl(DataSet ds, string reporttype)
{
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
try
{
rptSchool.ConnectionString = connectionstring;
//reporttype = Server.MapPath("Files/MonthlySummary.xml");
rptSchool.XMLReportFile = Server.MapPath(reporttype);
rptSchool.Search(ds.Tables[0]);
// WebUserControl1.status = "1";
}
catch (Exception ex)
{
WebMsg.Show("" + ex.Message.ToString());
}
}
private void StageTwoCalling()
{
DataSet dsResult = new DataSet();
this.obj_Dal_ClasswiseCoveredSyllabus = new ClasswiseCoveredSyllabus();
dsResult = obj_Dal_ClasswiseCoveredSyllabus.SelectBMS(this.BMSID);
this.BoardID = Convert.ToInt32(dsResult.Tables[0].Rows[0]["BoardID"]);
this.MediumID = Convert.ToInt32(dsResult.Tables[0].Rows[0]["MediumID"]);
this.StandardID = Convert.ToInt32(dsResult.Tables[0].Rows[0]["StandardID"]);
dsResult = new DataSet();
this.obj_Dal_ClasswiseCoveredSyllabus = new ClasswiseCoveredSyllabus();
dsResult = this.obj_Dal_ClasswiseCoveredSyllabus.GetSubjectwiseCoveredDetails(this.BMSID, this.SchoolID, this.DivisionID);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
SubjectwiseSyllabusGrid.XMLReportFile = Server.MapPath("../ReportXMLFiles/SubjectwiseCoveredSyllabus.xml");
SubjectwiseSyllabusGrid.Search(dsResult.Tables[0]);
CurrentReport = "Subjectwise Report";
//CommanCallUserControl(dsResult, "../ReportXMLFiles/SubjectwiseCoveredSyllabus.xml");
}
public void Displayselecteddata(Hashtable hashtable, object objsender)
{
ReportControl rpt = (ReportControl)objsender;
if (rpt.ID == "rptSchoolAttendance")
{
rptSchoolAttendance.Visible = false;
rptClassAttendance.Visible = true;
//FirstReport.Visible = false;
Div1.Visible = true;
secondRpt.Visible = true;
btnback.Visible = true;
this.SchoolID = Convert.ToInt32(ddlSchool.SelectedValue.ToString());
this.BMSID = Convert.ToInt32(hashtable["BMSID"].ToString());
ViewState["BMSID"] = Convert.ToInt32(hashtable["BMSID"].ToString());
this.BMS = (hashtable["BMS"].ToString());
this.Attendance = (hashtable["Attendance"].ToString());
this.Division = (hashtable["Division"].ToString());
this.Date = Convert.ToDateTime(txtDate.Text);
BindValuesToLabels();
DataSet ds = new DataSet();
ReportsForResult objRsultReport = new ReportsForResult();
this.Obj_Dal_ClassroomWiseAttendance = new ClassroomWiseAttendance();
ds = this.Obj_Dal_ClassroomWiseAttendance.GetAttendance(SchoolID, Date, BMSID);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
try
{
rptClassAttendance.XMLReportFile = Server.MapPath("../ReportXMLFiles/ClassroomWiseAttendanceSecond.xml");
rptClassAttendance.Search(ds.Tables[0]);
CurrentReport = "ClassAttendance";
}
catch (Exception ex)
{
WebMsg.Show("" + ex.Message.ToString());
}
}
if (rpt.ID == "rptClassAttendance")
{
this.SchoolID = Convert.ToInt32(ddlSchool.SelectedValue.ToString());
this.BMSID = Convert.ToInt32(ViewState["BMSID"].ToString());
this.Date = Convert.ToDateTime(txtDate.Text);
BindValuesToLabels();
DataSet ds = new DataSet();
ReportsForResult objRsultReport = new ReportsForResult();
this.Obj_Dal_ClassroomWiseAttendance = new ClassroomWiseAttendance();
ds = this.Obj_Dal_ClassroomWiseAttendance.GetAttendance(SchoolID, Date, BMSID);
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
try
{
rptClassAttendance.XMLReportFile = Server.MapPath("../ReportXMLFiles/ClassroomWiseAttendanceSecond.xml");
rptClassAttendance.Search(ds.Tables[0]);
CurrentReport = "ClassAttendance";
}
catch (Exception ex)
{
WebMsg.Show("" + ex.Message.ToString());
}
}
}
private void CommanCallUserControl(DataTable dt, string reporttype, int control)
{
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
try
{
if (control == 1)
{
ReportControl1.ConnectionString = connectionstring;
//reporttype = Server.MapPath("Files/MonthlySummary.xml");
ReportControl1.XMLReportFile = Server.MapPath(reporttype);
ReportControl1.Search(dt);
}
else if (control == 2)
{
ReportControl2.ConnectionString = connectionstring;
//reporttype = Server.MapPath("Files/MonthlySummary.xml");
ReportControl2.XMLReportFile = Server.MapPath(reporttype);
ReportControl2.Search(dt);
}
else if (control == 3)
{
//ReportControl3.ConnectionString = connectionstring;
////reporttype = Server.MapPath("../ReportXMLFiles/TeacherTrackRPTEmpWiseBMSSCT.xml");
//ReportControl3.XMLReportFile = Server.MapPath(reporttype);
//ReportControl3.Search(dt);
StringBuilder ReportString = new StringBuilder();
//Header
//XML to Dataset
DataSet xmllanguage = new DataSet();
xmllanguage.ReadXml(Server.MapPath("../ReportXMLFiles/TeacherTrackRPTEmpWiseBMSSCT.xml"));
//End XML to Dataset
//HiddenFields list get
List <string> HiddenFields;
HiddenFields = GetHiddenFields();
//End HiddenFields list get
DataTable dtTableHeder = dt.DefaultView.ToTable(true, "SessionID");
for (int i = 0; i < dtTableHeder.Rows.Count; i++)
{
CreadeRowColumMainTable(ReportString);
//ReportString.Append(xmllanguage.Tables[Session["LANG"].ToString().ToLower()].Rows[0]["Session"].ToString()+" : "+dtTableHeder.Rows[i]["SessionID"].ToString());
ReportString.Append(xmllanguage.Tables[Session["Varnindra"].ToString().ToLower()].Rows[0]["Session"].ToString() + " : " + dtTableHeder.Rows[i]["SessionID"].ToString());
CloseTDTR(ReportString);
OpenTDTR(ReportString);
DataView dv1 = dt.DefaultView;
dv1.RowFilter = " SessionID = '" + dtTableHeder.Rows[i]["SessionID"].ToString() + "'";
DataTable dtNew = dv1.ToTable();
ReportString.Append("<table class=\"GridViewCss\" cellspacing=\"2\" cellpadding=\"2\" border=\"1\" style=\"border-width:1px;border-style:None;width:100%;\" rules=\"all\">");
ReportString.Append("<tr class=\"GridViewHeadercss\">");
for (int j = 0; j < dtNew.Columns.Count; j++)
{
if (HiddenFields != null)
{
foreach (string s in HiddenFields)
{
if (dtNew.Columns[j].ToString().ToLower() != s.ToLower())
{
string Columen = dtNew.Columns[j].ToString().Trim().Replace(" ", "");
string str = xmllanguage.Tables[Session["Varnindra"].ToString().ToLower()].Rows[0][Columen].ToString();
ReportString.Append("<th scope=\"col\">" + str + "</th>");
break;
}
else
{
break;
}
}
}
}
ReportString.Append("</tr>");
for (int ij = 0; ij < dtNew.Rows.Count; ij++)
{
ReportString.Append("<tr class=\"GridViewItem\">");
for (int ro = 0; ro < dtNew.Columns.Count; ro++)
{
if (HiddenFields != null)
{
foreach (string s in HiddenFields)
{
if (dtNew.Columns[ro].ToString().ToLower() != s.ToLower())
{
ReportString.Append("<td>" + dtNew.Rows[ij][ro].ToString() + "</td>"); break;
}
else
{
break;
}
}
}
}
ReportString.Append("</tr>");
}
ReportString.Append("</table>");
CloseRowColumnMainTable(ReportString);
}
div1.InnerHtml = ReportString.ToString();
}
}
catch (Exception ex)
{
WebMsg.Show("" + ex.Message.ToString());
}
}
