public void BindStudentAttendance() { ApplicationResult objResult = new ApplicationResult(); StudentAttendenceBL objStudentAttendanceBl = new StudentAttendenceBL(); objResult = objStudentAttendanceBl.Sarasari_Report(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), ddlYear.SelectedItem.ToString(), Convert.ToInt32(ddlMonth.SelectedValue)); if (objResult.resultDT.Rows.Count > 0) { gvReport.DataSource = objResult.resultDT; gvReport.DataBind(); gvAttendance.DataSource = objResult.resultDT; gvAttendance.DataBind(); divReport.Visible = true; divButtons.Visible = true; btnBack.Visible = true; btnPrintDetail.Visible = true; pnlStudentAttendanceInfo.Visible = false; lblSchoolName.Text = Session[ApplicationSession.SCHOOLNAME].ToString(); lblYear.Text = ddlYear.SelectedItem.ToString(); lblMonth.Text = ddlMonth.SelectedItem.ToString(); lblSchool1.Text = Session[ApplicationSession.SCHOOLNAME].ToString(); lblYear1.Text = ddlYear.SelectedItem.ToString(); lblMonth1.Text = ddlMonth.SelectedItem.ToString(); } else { divReport.Visible = false; btnPrintDetail.Visible = false; pnlStudentAttendanceInfo.Visible = true; btnBack.Visible = false; divButtons.Visible = true; ClearAll(); ScriptManager.RegisterStartupScript(this, GetType(), "alert", "alert('No Records Found.');", true); } }
protected void BindStudentGrid() { try { StudentAttendenceBL objStudentAttendenceBL = new StudentAttendenceBL(); ApplicationResult objResult = new ApplicationResult(); StudentBL objStudentBL = new StudentBL(); ViewState["ClassMID"] = Convert.ToInt32(Request.Form[ddlClass.UniqueID]); ViewState["DivisionName"] = Convert.ToInt32(Request.Form[ddlDivision.UniqueID]); ViewState["AcademicYear"] = ddlAcademicYear.SelectedItem.ToString(); objResult = objStudentBL.Student_SelectFor_Upgrade(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlAcademicYear.SelectedItem.ToString(), 1); if (objResult != null) { gvStudent.DataSource = objResult.resultDT; gvStudent.DataBind(); if (objResult.resultDT.Rows.Count > 0) { btnSMS.Visible = true; objResult = objStudentAttendenceBL.StudentAttendence_Select_Datewise(txtdate.Text, Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlAcademicYear.SelectedItem.ToString()); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { ViewState["Mode"] = "Edit"; ViewState["StudentAttendenceMID"] = objResult.resultDT.Rows[0][StudentAttendenceBO.STUDENTATTENDENCE_STUDENTATTENDENCEMID].ToString(); string PresentStudentIDs = objResult.resultDT.Rows[0][StudentAttendenceBO.STUDENTATTENDENCE_PRESENTSTUDENTIDS].ToString(); string AbsentStudentIDs = objResult.resultDT.Rows[0][StudentAttendenceBO.STUDENTATTENDENCE_ABSENTSTUDENTIDS].ToString(); string[] Presentids = PresentStudentIDs.Split(','); string[] Absentids = AbsentStudentIDs.Split(','); foreach (GridViewRow row in gvStudent.Rows) { foreach (string pid in Presentids) { if (row.Cells[0].Text == pid) { ((CheckBox)row.FindControl("chkChild")).Checked = true; ((CheckBox)row.FindControl("chkSms")).Checked = false; ((CheckBox)row.FindControl("chkSms")).Enabled = false; // ((CheckBox)gvStudent.HeaderRow.FindControl("chkHeader")).Enabled = false; } } foreach (string aid in Absentids) { if (row.Cells[0].Text == aid) { ((CheckBox)row.FindControl("chkChild")).Checked = false; ((CheckBox)row.FindControl("chkSms")).Checked = true; } } } Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "BindDorpdownOnButtonClick();", true); } else { ViewState["Mode"] = "Save"; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "CheckAll();BindDorpdownOnButtonClick();", true); } } } else { btnSMS.Visible = false; } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
public void BindStudentAttendance() { ApplicationResult objResult = new ApplicationResult(); StudentAttendenceBL objStudentAttendanceBl = new StudentAttendenceBL(); objResult = objStudentAttendanceBl.StudentAttendence_MonthlyReport(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ddlclass.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue), ddlYear.SelectedItem.ToString(), Convert.ToInt32(ddlMonth.SelectedValue)); if (objResult.resultDT.Rows.Count > 0) { for (int i = 0; i < objResult.resultDT.Columns.Count; i++) { // gvReport.AutoGenerateColumns = true; if (i == 0) { BoundField bfield = new BoundField(); bfield.DataField = "StudentName"; bfield.HeaderText = "Student Name"; bfield.HeaderStyle.Width = 100; bfield.ItemStyle.Width = 100; bfield.ItemStyle.VerticalAlign = VerticalAlign.Top; bfield.ItemStyle.Wrap = false; gvReport.Columns.Add(bfield); gvAttendance.Columns.Add(bfield); } else if (i == objResult.resultDT.Columns.Count - 1) { BoundField bfield1 = new BoundField(); bfield1.DataField = "PresentCount"; bfield1.HeaderText = "Average Present(%)"; bfield1.HeaderStyle.Width = 100; bfield1.ItemStyle.Width = 100; bfield1.ItemStyle.VerticalAlign = VerticalAlign.Top; gvReport.Columns.Add(bfield1); gvAttendance.Columns.Add(bfield1); } else { BoundField bfield2 = new BoundField(); bfield2.DataField = objResult.resultDT.Columns[i].ToString(); bfield2.HeaderText = Convert.ToString(i); bfield2.HeaderStyle.Width = 100; bfield2.ItemStyle.Width = 100; bfield2.ItemStyle.VerticalAlign = VerticalAlign.Top; gvReport.Columns.Add(bfield2); gvAttendance.Columns.Add(bfield2); } } gvReport.DataSource = objResult.resultDT; gvReport.DataBind(); gvAttendance.DataSource = objResult.resultDT; gvAttendance.DataBind(); divReport.Visible = true; divButtons.Visible = true; btnBack.Visible = true; btnPrintDetail.Visible = true; pnlStudentAttendanceInfo.Visible = false; lblYear.Text = ddlYear.SelectedItem.ToString(); lblMonth.Text = ddlMonth.SelectedItem.ToString(); lblSchool1.Text = Session[ApplicationSession.SCHOOLNAME].ToString(); lblClass1.Text = ddlclass.SelectedItem.ToString() + "-" + ddlDivision.SelectedItem.ToString(); lblYear1.Text = ddlYear.SelectedItem.ToString(); lblMonth1.Text = ddlMonth.SelectedItem.ToString(); } else { divReport.Visible = false; btnPrintDetail.Visible = false; pnlStudentAttendanceInfo.Visible = true; btnBack.Visible = false; divButtons.Visible = true; ClearAll(); ScriptManager.RegisterStartupScript(this, GetType(), "alert", "alert('No Records Found.');", true); } }
protected void btnSave_Click(object sender, EventArgs e) { ViewState["ClassMID"] = Convert.ToInt32(Request.Form[ddlClass.UniqueID]); ViewState["DivisionName"] = Convert.ToInt32(Request.Form[ddlDivision.UniqueID]); ViewState["AcademicYear"] = ddlAcademicYear.SelectedItem.ToString(); StudentAttendenceBL objStudentAttendenceBL = new StudentAttendenceBL(); StudentAttendenceBO objStudentAttendenceBO = new StudentAttendenceBO(); ApplicationResult objResults = new ApplicationResult(); try { string PresentIds = string.Empty; string AbsentIds = string.Empty; int Count = 0; foreach (GridViewRow row in gvStudent.Rows) { ViewState["StudentMID"] = Convert.ToInt32(row.Cells[0].Text); if (((CheckBox)row.FindControl("chkChild")).Checked) { PresentIds += ViewState["StudentMID"].ToString() + ","; Count = Count + 1; } else { AbsentIds += ViewState["StudentMID"].ToString() + ","; } } objStudentAttendenceBO.PresentStudentIDs = PresentIds.TrimEnd(','); objStudentAttendenceBO.AbsentStudentIds = AbsentIds.TrimEnd(','); objStudentAttendenceBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objStudentAttendenceBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objStudentAttendenceBO.EmployeeMID = Convert.ToInt32(Session[ApplicationSession.USERID]); objStudentAttendenceBO.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString()); objStudentAttendenceBO.DivisionTID = Convert.ToInt32(ViewState["DivisionName"].ToString()); objStudentAttendenceBO.AcademicYear = ViewState["AcademicYear"].ToString(); objStudentAttendenceBO.Date = txtdate.Text; objStudentAttendenceBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objStudentAttendenceBO.Time = System.DateTime.Now.ToShortTimeString(); objStudentAttendenceBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); if (Count > 0) { if (ViewState["Mode"].ToString() == "Save") { objResults = objStudentAttendenceBL.StudentAttendence_Insert(objStudentAttendenceBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Student Attendence Done Successfully.');</script>"); } } else { objStudentAttendenceBO.StudentAttendenceMID = Convert.ToInt32(ViewState["StudentAttendenceMID"].ToString()); objResults = objStudentAttendenceBL.StudentAttendence_Update(objStudentAttendenceBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Student Attendence Updated Successfully.');</script>"); ViewState["Mode"] = "Save"; } } } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Select Any One Checkbox For Attendence.');</script>"); ViewState["ClassMID"] = Convert.ToInt32(Request.Form[ddlClass.UniqueID]); ViewState["DivisionName"] = Convert.ToInt32(Request.Form[ddlDivision.UniqueID]); ViewState["AcademicYear"] = ddlAcademicYear.SelectedItem.ToString(); hfCLassMID.Value = ViewState["ClassMID"].ToString(); hfDivisionTID.Value = ViewState["DivisionName"].ToString(); Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "BindDorpdownOnButtonClick();", true); } BindStudentGrid(); Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "BindSection();", true); } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }