public bool updateteach(TEACH Teach) { var teach = db.TEACHES.First(x => x.COURSE_ID == Teach.COURSE_ID); teach.USER_ID = Teach.USER_ID; db.SaveChanges(); return(true); }
public bool addteach(TEACH Teach, COURSE Course) { TEACH tea = new TEACH(); tea.COURSE_ID = Course.ID; tea.USER_ID = Teach.USER_ID; db.TEACHES.Add(tea); db.SaveChanges(); return(true); }
public List <TOPIC> GetAllTopicOfTeacherCourse(string userId, string semId, string courseId) { //var topicsInSubTeachedByTeacher = db.C_USER.Where(x => x.ID == userId) // .Select(x => x.SUBJECTs1.Where(s => s.COURSE_ID == courseId && s.ID == subjectId) // .Select(s => s.TOPICs)).ToList(); C_USER teacher = db.C_USER.Where(u => u.ID == userId).First(); TEACH teach = teacher.TEACHES.Where(t => t.COURSE.ID == courseId).Select(t => new TEACH { COURSE = t.COURSE }).First(); List <TOPIC> topics = teach.COURSE.TOPICs.Select(t => new TOPIC { ID = t.ID, TITLE = t.TITLE, DESCRIPTION = t.DESCRIPTION, COURSE_ID = t.COURSE_ID, DOCUMENTs = t.DOCUMENTs .Select(d => new DOCUMENT { ID = d.ID, TITLE = d.TITLE, DESCRIPTION = d.DESCRIPTION, LINK = d.LINK }) .ToList(), EVENTs = t.EVENTs .Select(e => new EVENT { ID = e.ID, TITLE = e.TITLE, DESCRIPTION = e.DESCRIPTION, STARTDATE = e.STARTDATE, DEADLINE = e.DEADLINE }) .ToList() }).ToList(); return(topics); }
public JsonResult Save(HttpPostedFileBase file, string ID, string NAME, string DESCRIPTION, string SEMESTER_ID, string SUBJECT_ID, string USER_ID, string COURSE_ID) { COURSE Course = new COURSE(); Course.ID = ID; Course.NAME = NAME; Course.DESCRIPTION = DESCRIPTION; Course.SEMESTER_ID = SEMESTER_ID; Course.SUBJECT_ID = SUBJECT_ID; TEACH Teach = new TEACH(); Teach.USER_ID = USER_ID; Teach.COURSE_ID = COURSE_ID; bool status = false; string message = string.Empty; var course = new CourseDAO().CheckCouseIDExists(Course.ID); if (course == 1) { try { var model = new TeachDAO().updateteach(Teach); var cour = new CourseDAO().updatecourse(Course); if (file != null) { UploadExcel(file); } status = true; } catch (Exception ex) { status = false; message = ex.Message; } } else { try { //Course.ID = createID("COUR"); var cour = new CourseDAO().addcourse(Course); var teach = new TeachDAO().addteach(Teach, Course); UploadExcel(file); status = true; } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); raise = new InvalidOperationException(message, raise); } } throw raise; } } return(Json(new { status = status, message = message })); }