public bool NewStudentAttendance(StudentAttendance _registerAttendance)
 {
     SqlParameter[] Params = new SqlParameter[]
     {
         new SqlParameter("@ModuleCode", _registerAttendance.ModuleCode),
         new SqlParameter("@Present", _registerAttendance.Present),
         new SqlParameter("@VenueCode",_registerAttendance.VenueCode),
         new SqlParameter("@DateTime", _registerAttendance.DateTime),
         new SqlParameter("@StudentNumber", _registerAttendance.StudentNumber)
     };
     return DataAccess.ExecuteNonQuery("sp_InsertStudentAttendance", CommandType.StoredProcedure,
         Params);
 }
        public StudentAttendance GetStudentAttendance(int USAI)
        {
            StudentAttendance _registerAttendance = null;

            SqlParameter[] Params = { new SqlParameter("@USAI", USAI) };
            using (DataTable table = DataAccess.ExecuteParamatizedSelectCommand("sp_GetStudentAttendance",
                CommandType.StoredProcedure, Params))
            {
                if (table.Rows.Count == 1)
                {
                    DataRow row = table.Rows[0];
                    _registerAttendance = new StudentAttendance();
                    _registerAttendance.DateTime = Convert.ToDateTime(row["DateTime"]);
                    _registerAttendance.ModuleCode = row["ModuleCode"].ToString();
                    _registerAttendance.StudentNumber = row["StudentNumber"].ToString();
                    _registerAttendance.Present = Convert.ToBoolean(row["Present"]);
                    _registerAttendance.VenueCode = row["VenueCode"].ToString();
                }
            }
            return _registerAttendance;
        }
        public List<StudentAttendance> GetAllStudentAttendance()
        {
            List<StudentAttendance> _registerAttendanceList = null;

            using (DataTable table = DataAccess.ExecuteSelectCommand("sp_GetAllStudentAttendance",
                CommandType.StoredProcedure))
            {
                if (table.Rows.Count > 0)
                {
                    _registerAttendanceList = new List<StudentAttendance>();
                    foreach (DataRow row in table.Rows)
                    {
                        StudentAttendance _attendance = new StudentAttendance();
                        _attendance.DateTime = Convert.ToDateTime(row["DateTime"]);
                        _attendance.ModuleCode = row["ModuleCode"].ToString();
                        _attendance.Present = Convert.ToBoolean(row["Present"]);
                        _attendance.StudentNumber = row["StudentNumber"].ToString();
                        _attendance.VenueCode = row["VenueCode"].ToString();
                        _registerAttendanceList.Add(_attendance);
                    }
                }
            }
            return _registerAttendanceList;
        }
 public bool InsertStudentAttendance(StudentAttendance _studentAttendance)
 {
     StudentAttendanceHandler myHandler =  new StudentAttendanceHandler(); return myHandler.NewStudentAttendance(_studentAttendance);
 }