protected void btnGo_Click(object sender, EventArgs e)
{
ddlSchool.Enabled = false;
ddlBoard.Enabled = false;
ddlMedium.Enabled = false;
ddlStandard.Enabled = false;
ddlDivision.Enabled = false;
grdAtt.Visible = true;
btnexporttoexcel.Visible = true;
DataSet ds = new DataSet();
this.Obj_Dal_ClassroomWiseAttendance = new ClassroomWiseAttendance();
ds = this.Obj_Dal_ClassroomWiseAttendance.GetClasswiseMonthlyAttendance(Convert.ToInt32(ddlSchool.SelectedValue), Get_DDMMYYYY(txtDate.Text), Convert.ToInt64(ViewState["BMSID"]), Convert.ToInt32(ddlDivision.SelectedValue));
ViewState["reportdatatable"] = ds.Tables[0];
if (ds.Tables[0].Rows.Count > 0)
{
grdAtt.DataSource = ds.Tables[0];
grdAtt.DataBind();
}
else
{
grdAtt.DataSource = null;
grdAtt.DataBind();
}
}
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 BindClassWiseAttendanceGrid()
{
DataSet dtResult = new DataSet();
this.Obj_Dal_ClassroomWiseAttendance = new ClassroomWiseAttendance();
dtResult = 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, Session["LANG"].ToString()));
Session["Date"] = txtDate.Text;
grdClassroomWiseAttendance.DataSource = dtResult;
grdClassroomWiseAttendance.DataBind();
}
private void BindClassroomattendaceGrid()
{
try
{
int SchoolID = Convert.ToInt32(Session["SchoolID"]);
DateTime Date = Convert.ToDateTime(Session["Date"]);
int BMSID = Convert.ToInt32(Request.QueryString["BMSID"].ToString());
DataSet dtResult = new DataSet();
this.Obj_Dal_ClassroomWiseAttendance = new ClassroomWiseAttendance();
dtResult = this.Obj_Dal_ClassroomWiseAttendance.GetAttendance(SchoolID, Date, BMSID);
grdAttendance.DataSource = dtResult;
grdAttendance.DataBind();
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Int32 BMSID = Convert.ToInt32(Request.QueryString["BMSID"]);
Session["BMSID"] = Convert.ToInt32(Request.QueryString["BMSID"]);
this.Obj_Dal_ClassroomWiseAttendance = new ClassroomWiseAttendance();
DataSet dsResult = Obj_Dal_ClassroomWiseAttendance.SelectBMS(BMSID);
lblSchoolValue.Text = Session["SchoolName"].ToString();
lblAttendanceValue.Text = Request.QueryString["Attendance"].ToString();
lblBMSValue.Text = dsResult.Tables[0].Rows[0]["BMS"].ToString();
Session["BMS"] = dsResult.Tables[0].Rows[0]["BMS"].ToString();
lblDivValue.Text = Request.QueryString["Division"];
Session["DivisionName"] = Request.QueryString["Division"];
lblDateValue.Text = Session["Date"].ToString();
BindClassroomattendaceGrid();
}
}
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());
}
}
}