public void Post([FromBody] LessonPlanRequest lessonPlan)
{
var ClassId = (from academicClasses in _dbcontext.AcademicClasses
join academicClassSubject in _dbcontext.AcademicClassSubjects on academicClasses.AcademicClassId equals academicClassSubject.AcademicClassId
join sub in _dbcontext.Subjects on academicClassSubject.SubjectID equals sub.SubjectID
orderby sub.SubjectID
select new
{
academicClasses.ClassName,
academicClassSubject.AcademicClassId,
academicClassSubject.AcademicClassSubjectId,
sub.SubjectDescr
}).Where(X => X.ClassName == lessonPlan.ClassName && X.SubjectDescr == lessonPlan.SubjectName).Distinct().FirstOrDefault();
LessonPlan _updLessonPlan = new LessonPlan();
_updLessonPlan.AcademicClassId = ClassId.AcademicClassId;
_updLessonPlan.AcademicClassSubjectId = ClassId.AcademicClassSubjectId;
_updLessonPlan.date = lessonPlan.date;
_updLessonPlan.classWork = lessonPlan.classWork;
_updLessonPlan.homeWork = lessonPlan.homeWork;
_updLessonPlan.lesson = lessonPlan.lesson;
_updLessonPlan.games = lessonPlan.games;
_updLessonPlan.activity = lessonPlan.activity;
_updLessonPlan.classActivity = lessonPlan.classActivity;
_updLessonPlan.topic = lessonPlan.topic;
_updLessonPlan.extraInfo = lessonPlan.extraInfo;
_updLessonPlan.concept = lessonPlan.concept;
_dbcontext.LessonPlans.Add(_updLessonPlan);
_dbcontext.SaveChanges();
}
public LessonPlan NewLessonPlan(string userId, LessonPlanRequest lessonPlan)
{
var result = _dbContext.LessonPlan.Add(new LessonPlan
{
UserId = userId,
LessonId = lessonPlan.LessonId,
ToType = lessonPlan.ToType,
Title = lessonPlan.Title,
LessonDate = lessonPlan.LessonDate,
Subject = lessonPlan.Subject,
Grade = lessonPlan.Grade
});
_dbContext.SaveChanges();
return(result.Entity);
}
