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 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 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 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 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 Boolean SaveClassGrades(List<StudentSubjectBDO> grades) {
Boolean ret = true;
StudentSubject gradeInDB = new StudentSubject();
try {
using (var DCEnt = new DCFIEntities())
{
foreach (StudentSubjectBDO grade in grades)
{
gradeInDB = (from ss in DCEnt.StudentSubjects
where ss.StudentEnrSubCode == grade.StudentEnrSubCode
select ss).FirstOrDefault();
DCEnt.StudentSubjects.Remove(gradeInDB);
ConvertStuSubjectsBDOToStuSubjects(grade, gradeInDB);
DCEnt.StudentSubjects.Attach(gradeInDB);
DCEnt.Entry(gradeInDB).State = System.Data.Entity.EntityState.Modified;
int num = DCEnt.SaveChanges();
if (grade.FourthPeriodicRating != 0 && grade.FirstPeriodicRating != 0 && grade.SecondPeriodicRating != 0 && grade.ThirdPeriodicRating != 0)
UpdateStudentGPA(grade.StudentSY);
else if (grade.FourthPeriodicRating == 0 && grade.ThirdPeriodicRating != 0 && grade.FirstPeriodicRating != 0 && grade.SecondPeriodicRating != 0)
UpdateStudentThirdGPA(grade.StudentSY);
else if (grade.FourthPeriodicRating == 0 && grade.ThirdPeriodicRating == 0 && grade.SecondPeriodicRating != 0 && grade.FirstPeriodicRating != 0)
UpdateStudentSecondGPA(grade.StudentSY);
else if (grade.FourthPeriodicRating == 0 && grade.ThirdPeriodicRating == 0 && grade.SecondPeriodicRating == 0 && grade.FirstPeriodicRating != 0)
UpdateStudentFirstGPA(grade.StudentSY);
if (num != 1)
ret = false;
}
}
}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 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 Boolean SaveClassGrades(List <StudentSubjectBDO> grades)
{
Boolean ret = true;
StudentSubject gradeInDB = new StudentSubject();
try {
using (var DCEnt = new DCFIEntities())
{
foreach (StudentSubjectBDO grade in grades)
{
gradeInDB = (from ss in DCEnt.StudentSubjects
where ss.StudentEnrSubCode == grade.StudentEnrSubCode
select ss).FirstOrDefault();
DCEnt.StudentSubjects.Remove(gradeInDB);
ConvertStuSubjectsBDOToStuSubjects(grade, gradeInDB);
DCEnt.StudentSubjects.Attach(gradeInDB);
DCEnt.Entry(gradeInDB).State = System.Data.Entity.EntityState.Modified;
int num = DCEnt.SaveChanges();
if (grade.FourthPeriodicRating != 0 && grade.FirstPeriodicRating != 0 && grade.SecondPeriodicRating != 0 && grade.ThirdPeriodicRating != 0)
{
UpdateStudentGPA(grade.StudentSY);
}
else if (grade.FourthPeriodicRating == 0 && grade.ThirdPeriodicRating != 0 && grade.FirstPeriodicRating != 0 && grade.SecondPeriodicRating != 0)
{
UpdateStudentThirdGPA(grade.StudentSY);
}
else if (grade.FourthPeriodicRating == 0 && grade.ThirdPeriodicRating == 0 && grade.SecondPeriodicRating != 0 && grade.FirstPeriodicRating != 0)
{
UpdateStudentSecondGPA(grade.StudentSY);
}
else if (grade.FourthPeriodicRating == 0 && grade.ThirdPeriodicRating == 0 && grade.SecondPeriodicRating == 0 && grade.FirstPeriodicRating != 0)
{
UpdateStudentFirstGPA(grade.StudentSY);
}
if (num != 1)
{
ret = false;
}
}
}
}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);
}