public HttpResponseMessage Get(int user_id, int subject_id, DateTime start_date, DateTime end_date) { try { using (Entities entities = new Entities()) { var userType = new UserPublicInfoClass(entities.USERS.FirstOrDefault(u => u.USER_ID == user_id)).type; var sessions = entities.SESSIONS.ToList().Where(a => a.SUBJECT_ID == subject_id && a.EXPECTED_DATE >= start_date && a.EXPECTED_DATE <= end_date) .OrderBy(s => s.ORDR) .Select(s => new SessionClass(s, userType)).ToList(); if (sessions != null) { return(Request.CreateResponse(HttpStatusCode.OK, new Result() { statusCode = 200, status = "Done", results = sessions })); } return(Request.CreateResponse(HttpStatusCode.OK, new Result() { statusCode = 404, status = "No exist user!" })); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.OK, new Result() { statusCode = 400, status = ex.Message })); } }
public HttpResponseMessage Get(int user_id, int subject_id) { try { using (Entities entities = new Entities()) { var _doc = entities.DOCUMENT_USER.Where(s => s.USER_ID == user_id); List <Document> docs = new List <Document>(); foreach (var item in _doc) { docs.Add(new Document() { id = item.DOCUMENT_ID, name = item.DOCUMENTS.NAME, questions = GetQuestion(item.DOCUMENTS) }); } var _std = entities.STUDENT_SUBJECTS.Where(s => s.SUBJECT_ID == subject_id); List <UserPublicInfoClass> students = new List <UserPublicInfoClass>(); foreach (var item in _std) { UserPublicInfoClass std = new UserPublicInfoClass(item.STUDENTS.USER_ID); std.profileImage = null; students.Add(std); } R r = new R() { documents = docs, students = students }; return(Request.CreateResponse(HttpStatusCode.OK, new Result() { statusCode = 200, status = "Success", results = r })); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.OK, new Result() { statusCode = 400, status = ex.Message })); } }
public Student(UserPublicInfoClass student, decimal?mark, short?absent) { this.student = student; this.mark = mark; this.absent = absent; }