public DataSet.DsPSMS.ATTENDANCE_RESULTDataTable selectAttendanceData(DataSet.DsPSMS.ST_STUDENT_DATARow sr, DataSet.DsPSMS.ST_ATTENDANCE_DATARow dr, out string msg) { DataSet.DsPSMS.ATTENDANCE_RESULTDataTable result = new DataSet.DsPSMS.ATTENDANCE_RESULTDataTable(); if (dr == null) { msg = "data is empty"; return(null); } try { db.Open(); result = db.selectAttendanceData(sr, dr); if (result != null) { msg = result.Rows.Count + " day found"; } else { result = null; msg = "attendance not found"; } } catch { msg = "error has occure when insert data"; return(null); } finally { db.Close(); } return(result); }
protected void btnSearch_Click(object sender, EventArgs e) { if (!checkValidation()) { gridViewAttendance.DataSource = null; gridViewAttendance.DataBind(); studentRow = new DataSet.DsPSMS.ST_STUDENT_DATADataTable().NewST_STUDENT_DATARow(); studentRow.EDU_YEAR = Convert.ToInt16(eduYearList.Text); studentRow.GRADE_ID = gradeList.Text; studentRow.ROOM_ID = roomList.Text; studentRow.ROLL_NO = ""; studentRow.STUDENT_NAME = ""; if (attendDate.Text.Trim().Length == 0) { DataSet.DsPSMS.ST_STUDENT_DATADataTable resultDt = attService.selectStudentData(studentRow, out msg); if (resultDt == null || resultDt.Count == 0) { ModelState.AddModelError(string.Empty, "Data doesn't found"); gridViewAttendance.DataSource = null; gridViewAttendance.DataBind(); } else { gridViewAttendance.DataSource = resultDt; gridViewAttendance.DataBind(); } } else { DataSet.DsPSMS.ST_ATTENDANCE_DATARow adr = new DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable().NewST_ATTENDANCE_DATARow(); adr.ATTENDANCE_DATE = attendDate.Text; DataSet.DsPSMS.ATTENDANCE_RESULTDataTable resultDt = attService.selectAttendanceData(studentRow, adr, out msg); if (resultDt.Count != 0) { gridViewAttendance.DataSource = resultDt; gridViewAttendance.DataBind(); for (int i = 0; i < resultDt.Count; i++) { Label date = (Label)gridViewAttendance.Rows[i].FindControl("Date"); date.Text = resultDt.Rows[i]["ATTENDANCE_DATE"].ToString(); CheckBox chkAM = (CheckBox)gridViewAttendance.Rows[i].FindControl("AM"); chkAM.Checked = false; if (Convert.ToInt16(resultDt.Rows[i]["MORNING"]) == 1) { chkAM.Checked = true; } else { chkAM.Checked = false; } CheckBox chkPM = (CheckBox)gridViewAttendance.Rows[i].FindControl("PM"); chkPM.Checked = false; if (Convert.ToInt16(resultDt.Rows[i]["EVENING"]) == 1) { chkPM.Checked = true; } else { chkPM.Checked = false; } } } } showAllButton(); } }