public bool AddStudentToSection(StudentSectionModel model, ref string errorMessage) { using (SZPNUWContext context = new SZPNUWContext()) { Sections section = context.Sections.Where(x => x.Id == model.SectionId).FirstOrDefault(); if (section != null) { bool result = (from ss in context.Studentssections join s in context.Sections on ss.Sectionid equals s.Id where s.Subcjetsemesterid == section.Subcjetsemesterid && ss.Studentid == model.StudentId select ss).Any(); if (!result) { Studentssections studSec = new Studentssections() { Sectionid = model.SectionId, Studentid = model.StudentId.Value }; context.Studentssections.Add(studSec); context.SaveChanges(); return(true); } } errorMessage = PortalMessages.CanNotAddStudentToSection; return(false); } }
public IActionResult UpdateStudentSection([FromBody] StudentSectionModel model) { if (ModelState.IsValid) { string errorMessage = string.Empty; if (service.UpdateStudentSection(model, ref errorMessage)) { return(Json(new Result(true))); } return(Json(new Result(errorMessage))); } return(Json(new Result(ModelState.GetFirstError()))); }
public bool UpdateStudentSection(StudentSectionModel model, ref string errorMessage) { using (SZPNUWContext context = new SZPNUWContext()) { Studentssections studentSection = context.Studentssections.FirstOrDefault(x => x.Id == model.Id); if (studentSection != null) { studentSection.Rating = model.Rate; studentSection.Dateofentry = model.Date; context.SaveChanges(); return(true); } errorMessage = PortalMessages.NoSuchElement; return(false); } }
public IActionResult GetSectionStudent([FromQuery] int studentId, int sectionId) { StudentSectionModel studSec = service.GetSectionStudent(sectionId, studentId); return(Json(studSec)); }
public bool AddStudentToSection(StudentSectionModel model, ref string errorMessage) { return(service.AddStudentToSection(model, ref errorMessage)); }
public bool UpdateStudentSection(StudentSectionModel model, ref string errorMessage) { return(service.UpdateStudentSection(model, ref errorMessage)); }