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