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