public HttpResponseMessage Addlesson(int session_id, string title, string objective, short order, short duration, DateTime issue_date)
{
try
{
using (Entities e = new Entities())
{
var pk = e.LESSONS.ToList().Count == 0 ? 0 : e.LESSONS.Max(s => s.LESSON_ID);
var _session = e.SESSIONS.First(s => s.SESSION_ID == session_id);
LESSONS _lession = new LESSONS()
{
LESSON_ID = pk + 1,
SESSION_ID = session_id,
SCHOOL_ID = _session.SCHOOL_ID,
CLASS_ID = _session.CLASS_ID,
SUBJECT_ID = _session.SUBJECT_ID,
EDUCATION_YEAR_ID = _session.EDUCATION_YEAR_ID,
TITLE = title,
OBJECTIVE = objective,
ORDR = order,
DURATION = duration,
ISSUE_DATE = issue_date
};
e.LESSONS.Add(_lession);
e.SaveChanges();
pk = e.SUB_HEADLINES.ToList().Count == 0 ? 0 : e.SUB_HEADLINES.Max(s => s.SUB_HEADLINE_ID);
SUB_HEADLINES _sub = new SUB_HEADLINES()
{
SUB_HEADLINE_ID = pk + 1,
HEADLINE_ID = _session.HEADLINES.First().HEADLINE_ID,
TITLE = title,
OBJECTIVE = objective
};
e.SUB_HEADLINES.Add(_sub);
e.SaveChanges();
var lesson = new LessonClass(_lession);
return(Request.CreateResponse(HttpStatusCode.OK, new Result()
{
statusCode = 200, status = "Done", results = lesson
}));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.OK, new Result()
{
statusCode = 400, status = ex.Message
}));
}
}
public LessonClass(LESSONS lesson, UserTypeClass userType)
{
title = lesson.TITLE;
duration = lesson.DURATION == null ? 0 : lesson.DURATION.Value;
if (userType.userType == UserType.Teacher)
{
files = lesson.LESSONS_SECTIONS
.Where(ls => ls.TEACHER == 1)
.Select(ls => new Resource(ls.RESOURCES)).ToList();
}
else
{
files = lesson.LESSONS_SECTIONS
.Where(ls => ls.STUDENTS == 1)
.Select(ls => new Resource(ls.RESOURCES)).ToList();
}
}
public LessonClass(LESSONS lesson)
{
title = lesson.TITLE;
duration = lesson.DURATION == null ? 0 : lesson.DURATION.Value;
}
