public bool DeleteSubjectSemester(int id, ref string errorMessage) { using (SZPNUWContext context = new SZPNUWContext()) { Subjectssemesters subSem = context.Subjectssemesters.FirstOrDefault(x => x.Id == id); if (subSem == null) { errorMessage = PortalMessages.NoSuchElement; return(false); } if (context.Subjectssemesters.Where(x => x.Subjectid == subSem.Subjectid).ToList().Count <= 1) { errorMessage = PortalMessages.LastEntryForTheItem; return(false); } if (context.Sections.Where(x => x.Subcjetsemesterid == id).AnyLazy()) { errorMessage = PortalMessages.SemesterDependence; return(false); } context.Subjectssemesters.Attach(subSem); context.Subjectssemesters.Remove(subSem); context.SaveChanges(); return(true); } }
public SubjectSemesterModel GetSubjectSemester(int subjectId, int semesterId) { using (SZPNUWContext context = new SZPNUWContext()) { Subjectssemesters subsem = context.Subjectssemesters.FirstOrDefault(x => x.Subjectid == subjectId && x.Semesterid == semesterId); return(subsem == null ? null : new SubjectSemesterModel { Id = subsem.Id, SemesterId = subsem.Semesterid, SubjectId = subsem.Subjectid }); } }
public bool AddSubjectSemester(SubjectSemesterModel model, ref string errorMessage) { using (SZPNUWContext context = new SZPNUWContext()) { if (!context.Subjectssemesters.Where(x => x.Subjectid == model.SubjectId && x.Semesterid == model.SemesterId).AnyLazy()) { Subjectssemesters subSem = new Subjectssemesters(); subSem.Subjectid = model.SubjectId; subSem.Semesterid = model.SemesterId; context.Add(subSem); context.SaveChanges(); return(true); } else { errorMessage = PortalMessages.ObjectExist; } return(false); } }
public bool AddSubject(SubjectModel model, ref string errorMessage) { using (SZPNUWContext context = new SZPNUWContext()) { if (!context.Subjects.Where(x => x.Name == model.Name).AnyLazy()) { Subjects subject = new Subjects() { Name = model.Name, Description = model.Description, Leaderid = model.LeaderId.Value }; Subjectssemesters subSem = new Subjectssemesters(); using (var transaction = context.Database.BeginTransaction()) { try { context.Add(subject); context.SaveChanges(); int id = context.Subjects.Where(x => x.Name == subject.Name).Select(x => x.Id).First(); subSem.Subjectid = id; subSem.Semesterid = model.SemesterId.Value; context.Add(subSem); context.SaveChanges(); transaction.Commit(); return(true); } catch (Exception) { transaction.Rollback(); errorMessage = PortalMessages.InvalidData; } } } else { errorMessage = PortalMessages.SubjectExist; } return(false); } }