コード例 #1
0
        public ResponseMessage examResulList(attendence_details addind)
        {
            var query = (from staff in entity.attendence_details
                         join section in entity.school_details on addind.school_id equals section.school_id
                         where addind.student_id == staff.student_id
                         where addind.school_id == staff.school_id
                         where addind.class_id == staff.class_id
                         //where addind.attendence_roll_no==staff.attendence_roll_no
                         select new
            {
                staff.attendence_parent_name,
                staff.attendence_roll_no,
                staff.attendence_section,
                staff.attendence_setion,
                staff.attendence_status,
                staff.school_id,
                staff.student_id,
                staff.class_id
            }
                         );

            rs.Data    = query;
            rs.code    = 200;
            rs.message = "Data success";
            return(rs);
        }
コード例 #2
0
        public IHttpActionResult updateAttendence(attendence_details update)
        {
            Boolean s = new AttendenceDetails().updateAttendence(update);

            if (s)
            {
                rs.code    = 200;
                rs.message = "succesfully data has been updated";
                return(Content(HttpStatusCode.OK, rs));
            }
            else
            {
                rs.code    = 100;
                rs.message = "failed to update";
                return(Content(HttpStatusCode.OK, rs));
            }
        }
コード例 #3
0
        public IHttpActionResult addingAttendance(attendence_details addind)
        {
            Boolean ff = new AttendenceDetails().addingAteendance(addind);

            if (ff)
            {
                addind.insert_date = DateTime.Now;
                entity.attendence_details.Add(addind);
                entity.SaveChanges();

                rs.code    = 200;
                rs.message = "succesfully data has been inserted";
                return(Content(HttpStatusCode.OK, rs));
            }
            else
            {
                rs.code    = 100;
                rs.message = "failed to insert data";
                return(Content(HttpStatusCode.OK, rs));
            }
        }