public void ConvertStuSubjectsBDOToStuSubjects(StudentSubjectBDO sbdo, StudentSubject s)
{
s.StudentSY = sbdo.StudentSY;
s.SubjectCode = sbdo.SubjectCode;
s.StudentSubjectsID = sbdo.StudentSubjectsID;
s.StudentEnrSubCode = sbdo.StudentEnrSubCode;
s.Remarks = sbdo.Remarks;
s.FirstPeriodicRating = sbdo.FirstPeriodicRating;
s.SecondPeriodicRating = sbdo.SecondPeriodicRating;
s.ThirdPeriodicRating = sbdo.ThirdPeriodicRating;
s.FourthPeriodicRating = sbdo.FourthPeriodicRating;
s.SubjectAssignments = sbdo.SubjectAssignments;
s.FirstEntered = sbdo.FirstEntered;
s.SecondEntered = sbdo.SecondEntered;
s.FourthEntered = sbdo.FourthEntered;
s.ThirdEntered = sbdo.ThirdEntered;
s.LockFirst = sbdo.LockFirst;
s.LockSecond = sbdo.LockSecond;
s.LockThird = sbdo.LockThird;
s.LockFourth = sbdo.LockFourth;
s.FirstLocked = sbdo.FirstLocked;
s.SecondLocked = sbdo.SecondLocked;
s.ThirdLocked = sbdo.ThirdLocked;
s.FourthLocked = sbdo.FourthLocked;
}
public List<StudentSubjectBDO> GetAllStudentSubjects()
{
List<StudentSubjectBDO> subjectBDOList = new List<StudentSubjectBDO>();
List<StudentSubject> subjectList = new List<StudentSubject>();
try {
using (var DCEnt = new DCFIEntities())
{
var allStudentSubjects = (DCEnt.StudentSubjects);
subjectList = allStudentSubjects.ToList<StudentSubject>();
foreach (StudentSubject s in subjectList)
{
StudentSubjectBDO subjectBDO = new StudentSubjectBDO();
ConvertStuSubjectsToStuSubjectsBDO(s, subjectBDO);
subjectBDOList.Add(subjectBDO);
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return subjectBDOList;
}
public Boolean ControlSubjects(string StudentId, string sy, List<StudentSubject> subjects)
{
Boolean ret = false;
foreach (StudentSubject sub in subjects)
{
string message = string.Empty;
StudentSubjectBDO ssb = new StudentSubjectBDO();
TranslateStuSubjectsToStuSubjectsBDO(sub, ssb);
ret = ssl.ControlStudent(ssb,ref message);
}
return ret;
}
public void ConvertStuSubjectsToStuSubjectsBDO(StudentSubject s, StudentSubjectBDO sbdo)
{
StudentEnrolmentDAO sed = new StudentEnrolmentDAO();
StudentEnrollmentBDO sedb = new StudentEnrollmentBDO();
sed.ConvertEnrolToEnrolBDO(s.StudentEnrollment, sedb);
sbdo.StudentEnrollment = sedb;
StudentDAO sd = new StudentDAO();
StudentBDO sb = new StudentBDO();
sd.ConvertStudentToStudentBDO(s.StudentEnrollment.Student, sb);
sbdo.StudentEnrollment.Student = sb;
SubjectDAO subd = new SubjectDAO();
SubjectBDO sbo = new SubjectBDO();
subd.ConvertSubjectToSubjectBDO(s.Subject, sbo);
sbdo.Subject = sbo;
sbdo.StudentSY = s.StudentSY;
sbdo.SubjectCode = s.SubjectCode;
sbdo.StudentSubjectsID = s.StudentSubjectsID;
sbdo.StudentEnrSubCode = s.StudentEnrSubCode;
sbdo.Remarks = s.Remarks;
sbdo.FirstPeriodicRating = s.FirstPeriodicRating;
sbdo.SecondPeriodicRating = s.SecondPeriodicRating;
sbdo.ThirdPeriodicRating = s.ThirdPeriodicRating;
sbdo.FourthPeriodicRating = s.FourthPeriodicRating;
sbdo.StudentEnrSubCode = s.StudentEnrSubCode;
sbdo.SubjectAssignments = s.SubjectAssignments;
sbdo.FirstEntered = s.FirstEntered;
sbdo.SecondEntered = s.SecondEntered;
sbdo.FourthEntered = s.FourthEntered;
sbdo.ThirdEntered = s.ThirdEntered;
sbdo.LockFirst = s.LockFirst;
sbdo.LockSecond = s.LockSecond;
sbdo.LockThird = s.LockThird;
sbdo.LockFourth = s.LockFourth;
sbdo.FirstLocked = s.FirstLocked;
sbdo.SecondLocked = s.SecondLocked;
sbdo.ThirdLocked = s.ThirdLocked;
sbdo.FourthLocked = s.FourthLocked;
}
public List<StudentSubjectBDO> GetClassList(string SubjectAssignments, string gender)
{
List<StudentSubject> studlist = new List<StudentSubject>();
List<StudentSubjectBDO> classList = new List<StudentSubjectBDO>();
try {
using (var DCEnt = new DCFIEntities())
{
DCEnt.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
var ss = (from sub in DCEnt.StudentSubjects
where sub.SubjectAssignments == SubjectAssignments & sub.StudentEnrollment.Student.Gender == gender & sub.StudentEnrollment.Student.Dismissed== false
orderby sub.StudentEnrollment.Student.LastName
select sub).ToList<StudentSubject>();
studlist = ss;
foreach (StudentSubject st in studlist)
{
StudentSubjectBDO ssbdo = new StudentSubjectBDO();
ConvertStuSubjectsToStuSubjectsBDO(st, ssbdo);
classList.Add(ssbdo);
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return classList;
}
public List<StudentSubjectBDO> GetClassGradeReport(string SubjectAssignments, string gender)
{
List<StudentSubjectBDO> classgradeBDO = new List<StudentSubjectBDO>();
List<StudentSubject> classgrade = new List<StudentSubject>();
try
{
using (var DCEnt = new DCFIEntities())
{
var classEval = (from s in DCEnt.StudentSubjects
where s.SubjectAssignments == SubjectAssignments && s.StudentEnrollment.Student.Gender == gender
orderby s.StudentEnrollment.Student.LastName
select s);
classgrade = classEval.ToList();
foreach (StudentSubject ss in classgrade)
{
StudentSubjectBDO ssb = new StudentSubjectBDO();
ssd.ConvertStuSubjectsToStuSubjectsBDO(ss, ssb);
classgradeBDO.Add(ssb);
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return classgradeBDO;
}
public List<StudentSubjectBDO> GetStudentEvaluation(string StudentId)
{
List<StudentSubjectBDO> evalBdo = new List<StudentSubjectBDO>();
List<StudentSubject> eval = new List<StudentSubject>();
try {
using (var DCEnt = new DCFIEntities())
{
var studentEval = (from s in DCEnt.StudentSubjects
where s.StudentSY.Contains(StudentId)
select s);
eval = studentEval.ToList();
foreach (StudentSubject ss in eval)
{
StudentSubjectBDO ssb = new StudentSubjectBDO();
ssd.ConvertStuSubjectsToStuSubjectsBDO(ss, ssb);
evalBdo.Add(ssb);
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return evalBdo;
}
public List<StudentSubjectBDO> GetStudentSubjects(string studentsy)
{
List<StudentSubjectBDO> ssb = new List<StudentSubjectBDO>();
List<StudentSubject> ss = new List<StudentSubject>();
try {
using (var DCEnt = new DCFIEntities())
{
ss = (from sub in DCEnt.StudentSubjects
where sub.StudentSY == studentsy
select sub).ToList<StudentSubject>();
foreach (StudentSubject s in ss)
{
StudentSubjectBDO subBDO = new StudentSubjectBDO();
ConvertStuSubjectsToStuSubjectsBDO(s, subBDO);
ssb.Add(subBDO);
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return ssb;
}
public List<StudentSubjectBDO> GetFailedSubjects(string IdSy) {
List<StudentSubject> fails = new List<StudentSubject>();
List<StudentSubjectBDO> ssbl = new List<StudentSubjectBDO>();
try {
using (var DCEnt = new DCFIEntities())
{
var allStudentSubjects = (from subs in DCEnt.StudentSubjects
where subs.StudentSY.Equals(IdSy) && subs.FourthPeriodicRating < 75.00
select subs);
fails = allStudentSubjects.ToList<StudentSubject>();
foreach (StudentSubject ss in fails)
{
StudentSubjectBDO ssb = new StudentSubjectBDO();
ConvertStuSubjectsToStuSubjectsBDO(ss, ssb);
ssbl.Add(ssb);
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return ssbl;
}
public Boolean DeleteStudentSubject(StudentSubjectBDO ssb, ref string message) {
String studentEnrSub = ssb.StudentEnrSubCode;
try {
using (var DCEnt = new DCFIEntities())
{
var x = (from ss in DCEnt.StudentSubjects
where ss.StudentEnrSubCode == studentEnrSub
select ss).FirstOrDefault();
if (x != null)
{
DCEnt.StudentSubjects.Remove(x);
DCEnt.SaveChanges();
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return true;
}
public Boolean DeleteStudentLoad(StudentSubjectBDO ssb, ref string message)
{
return ssd.DeleteStudentSubject(ssb, ref message);
}
public Boolean CreateStudentSubject(StudentSubjectBDO subBDO,ref string message)
{
message = "Student Subject Successfully Saved";
bool ret = true;
StudentSubject sa = new StudentSubject();
ConvertStuSubjectsBDOToStuSubjects(subBDO, sa);
try{
using (var DCEnt = new DCFIEntities())
{
DCEnt.StudentSubjects.Attach(sa);
DCEnt.Entry(sa).State = System.Data.Entity.EntityState.Added;
int num = DCEnt.SaveChanges();
if (num != 1)
{
ret = false;
message = "Saving Failed";
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return ret;
}
public bool SaveClassGrades(List<StudentSubject> grades)
{
GradingLogic gl = new GradingLogic();
List<StudentSubjectBDO> ssbdo = new List<StudentSubjectBDO>();
foreach (StudentSubject stusub in grades)
{
StudentSubjectBDO stuSubBdo = new StudentSubjectBDO();
TranslateStudentSubjectToStudentSubjectBDO(stusub, stuSubBdo);
ssbdo.Add(stuSubBdo);
}
return gl.SaveClassGrades(ssbdo);
}
public void TranslateStudentSubjectToStudentSubjectBDO(StudentSubject ss, StudentSubjectBDO ssbdo)
{
ssbdo.FirstEntered = ss.FirstEntered;
ssbdo.FirstLocked = ss.FirstLocked;
ssbdo.FirstPeriodicRating = ss.FirstPeriodicRating;
ssbdo.FourthEntered = ss.FourthEntered;
ssbdo.FourthLocked = ss.FourthLocked;
ssbdo.FourthPeriodicRating = ss.FourthPeriodicRating;
ssbdo.LockFirst = ss.LockFirst;
ssbdo.LockFourth = ss.LockFourth;
ssbdo.LockSecond = ss.LockSecond;
ssbdo.LockThird = ss.LockThird;
ssbdo.Remarks = ss.Remarks;
ssbdo.SecondEntered = ss.SecondEntered;
ssbdo.SecondLocked = ss.SecondLocked;
ssbdo.SecondPeriodicRating = ss.SecondPeriodicRating;
ssbdo.ThirdEntered = ss.ThirdEntered;
ssbdo.ThirdLocked = ss.ThirdLocked;
ssbdo.ThirdPeriodicRating = ss.ThirdPeriodicRating;
ssbdo.StudentEnrSubCode = ss.StudentEnrSubCode;
ssbdo.StudentEnrSubCode = ss.StudentEnrSubCode;
ssbdo.StudentSubjectsID = ss.StudentSubjectsID;
ssbdo.StudentSY = ss.StudentSY;
ssbdo.SubjectAssignments = ss.SubjectAssignments;
ssbdo.SubjectCode = ss.SubjectCode;
}
public void TranslateStudentSubjectBDOToStudentSubject(StudentSubjectBDO ssbdo, StudentSubject ss)
{
SubjectService s = new SubjectService();
Subject sub = new Subject();
s.TranslateSubjectBDOToSubject(ssbdo.Subject, sub);
RegistrationService r = new RegistrationService();
StudentEnrollment se = new StudentEnrollment();
r.TranslatEnrolBDOToEnrol(ssbdo.StudentEnrollment, se);
ss.StudentEnr = se;
ss.Description = sub.Description;
ss.FirstPeriodicRating = ssbdo.FirstPeriodicRating;
ss.SecondPeriodicRating = ssbdo.SecondPeriodicRating;
ss.ThirdPeriodicRating = ssbdo.ThirdPeriodicRating;
ss.FourthPeriodicRating = ssbdo.FourthPeriodicRating;
ss.FirstEntered = ssbdo.FirstEntered;
ss.SecondEntered = ssbdo.SecondEntered;
ss.ThirdEntered = ssbdo.ThirdEntered;
ss.FourthEntered = ssbdo.FourthEntered;
ss.LockFirst = (bool)ssbdo.LockFirst;
ss.LockFourth = (bool)ssbdo.LockFourth;
ss.LockSecond = (bool)ssbdo.LockSecond;
ss.LockThird = (bool)ssbdo.LockThird;
ss.FirstLocked = ssbdo.FirstLocked;
ss.SecondLocked = ssbdo.SecondLocked;
ss.ThirdLocked = ssbdo.ThirdLocked;
ss.FourthLocked = ssbdo.FourthLocked;
ss.Remarks = ssbdo.Remarks;
ss.StudentEnrSubCode = ssbdo.StudentEnrSubCode;
ss.StudentEnrSubCode = ssbdo.StudentEnrSubCode;
ss.StudentSubjectsID = ssbdo.StudentSubjectsID;
ss.StudentSY = ssbdo.StudentSY;
ss.SubjectCode = ssbdo.SubjectCode;
ss.StudentId = se.StudentId;
ss.StudentName = se.StudentName;
}
public Boolean ControlStudent(StudentSubjectBDO ssb, ref string message)
{
return ssd.CreateStudentSubject(ssb, ref message);
}
public void TranslateStuSubjectsBDOToStuSubjects(StudentSubjectBDO sbdo, StudentSubject s)
{
SubjectService ss = new SubjectService();
Subject sub = new Subject();
ss.TranslateSubjectBDOToSubject(sbdo.Subject, sub);
s.SubjectCode = sbdo.SubjectCode;
s.Description = sub.Description;
RegistrationService rs = new RegistrationService();
StudentEnrollment se = new StudentEnrollment();
rs.TranslatEnrolBDOToEnrol(sbdo.StudentEnrollment, se);
s.StudentEnr = se;
s.StudentSY = sbdo.StudentSY;
s.StudentId = se.StudentId;
s.StudentName = se.StudentName;
s.StudentSubjectsID = sbdo.StudentSubjectsID;
s.StudentEnrSubCode = sbdo.StudentEnrSubCode;
s.Remarks = sbdo.Remarks;
s.FirstPeriodicRating = sbdo.FirstPeriodicRating;
s.SecondPeriodicRating = sbdo.SecondPeriodicRating;
s.ThirdPeriodicRating = sbdo.ThirdPeriodicRating;
s.FourthPeriodicRating = sbdo.FourthPeriodicRating;
s.Description = sub.Description;
s.SubjectAssignments = sbdo.SubjectAssignments;
s.FirstEntered = sbdo.FirstEntered;
s.FirstLocked = sbdo.FirstLocked;
s.FourthEntered = sbdo.FourthEntered;
s.FourthLocked = sbdo.FourthLocked;
s.LockFirst = sbdo.LockFirst;
s.LockFourth = sbdo.LockFourth;
s.LockSecond = sbdo.LockSecond;
s.LockThird = sbdo.LockThird;
s.SecondEntered = sbdo.SecondEntered;
s.SecondLocked = sbdo.SecondLocked;
s.ThirdEntered = sbdo.ThirdEntered;
s.ThirdLocked = sbdo.ThirdLocked;
s.FinalRating = (double)sbdo.FourthPeriodicRating;
if (s.FinalRating > 90)
s.Proficiency = "O";
else if (s.FinalRating >= 85)
s.Proficiency = "VS";
else if (s.FinalRating >= 80)
s.Proficiency = "S";
else if (s.FinalRating >= 75)
s.Proficiency = "FS";
else if (s.FinalRating <= 74)
s.Proficiency = "D";
}
public List<StudentSubjectBDO> GetStudentGradeReport(string StudentId, string sy)
{
List<StudentSubjectBDO> studentGradeBDO = new List<StudentSubjectBDO>();
List<StudentSubject> studentgrade = new List<StudentSubject>();
try {
using (var DCEnt = new DCFIEntities())
{
var sg = (from s in DCEnt.StudentSubjects
where s.StudentSY.Equals(StudentId + sy)
select s);
studentgrade = sg.ToList();
foreach (StudentSubject ss in studentgrade)
{
StudentSubjectBDO ssb = new StudentSubjectBDO();
ssd.ConvertStuSubjectsToStuSubjectsBDO(ss, ssb);
studentGradeBDO.Add(ssb);
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return studentGradeBDO;
}
public bool DeleteLoadedSubjects(string StudentId, string sy, List<StudentSubject> subs)
{
Boolean ret = false;
foreach (StudentSubject sub in subs)
{
string message = string.Empty;
StudentSubjectBDO ssb = new StudentSubjectBDO();
TranslateStuSubjectsToStuSubjectsBDO(sub, ssb);
ret = ssl.DeleteStudentLoad(ssb, ref message);
}
return ret;
}
