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