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 void Update(LessonClass entitiy)
{
_lessonDAL.Update(entitiy);
}
public void Insert(LessonClass entitiy)
{
_lessonDAL.Add(entitiy);
}
public void DeleteById(int entitiyID)
{
LessonClass lessonClass = _lessonDAL.Get(a => a.ID == entitiyID);
Delete(lessonClass);
}
public void Delete(LessonClass entitiy)
{
_lessonDAL.Remove(entitiy);
}
