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);
}
}
