public Boolean CreateLearningArea(ref LearningAreaBDO laBDO, ref string message) { message = "Learning Area Added Successfully"; bool ret = true; LearningArea la = new LearningArea(); try { ConvertLearningAreaBDOToLearningArea(laBDO, la); using (var DCEnt = new DCFIEntities()) { DCEnt.LearningAreas.Add(la); DCEnt.Entry(la).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num == 0) { ret = false; message = "Adding of Learning Area 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 List<LearningAreaBDO> GetLearningAreas() { List<LearningArea> laList = new List<LearningArea>(); List<LearningAreaBDO> laBDOList = new List<LearningAreaBDO>(); try { using (var DCEnt = new DCFIEntities()) { var allLA = (DCEnt.LearningAreas); laList = allLA.ToList<LearningArea>(); foreach (LearningArea l in laList) { LearningAreaBDO laBDO = new LearningAreaBDO(); ConvertLearningAreaToLearningAreaBDO(l, laBDO); laBDOList.Add(laBDO); } } } 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 laBDOList; }
public LearningAreaBDO GetLearningArea(string learningAreaCode) { LearningAreaBDO laBDO = null; LearningArea l = new LearningArea(); try { using (var DCEnt = new DCFIEntities()) { var lA = (from learn in DCEnt.LearningAreas where learn.LearningAreaCode == learningAreaCode select learn).FirstOrDefault(); l = lA; if (l != null) { laBDO = new LearningAreaBDO(); ConvertLearningAreaToLearningAreaBDO(l, laBDO); } } } 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 laBDO; }
public void TranslateLearningAreaToLearningAreaBDO(LearningArea la, LearningAreaBDO lBdo) { lBdo.Academic = la.Academic; lBdo.Description = la.Description; lBdo.LearningAreaCode = la.LearningAreaCode; lBdo.RatePerUnit = la.RatePerUnit; lBdo.Units = la.Units; lBdo.Subjects = ToSubjectBDOList(la.Subjects); }
public void ConvertLearningAreaToLearningAreaBDO(LearningArea la, LearningAreaBDO labdo) { // SubjectDAO sdao = new SubjectDAO(); labdo.Subjects = GetSubjectsforLearningArea(la.LearningAreaCode); labdo.Academic = la.Academic; labdo.Description = la.Description; labdo.LearningAreaCode = la.LearningAreaCode; labdo.Units = la.Units; labdo.RatePerUnit = la.RatePerUnit; }
public void ConvertLearningAreaBDOToLearningArea(LearningAreaBDO labdo, LearningArea la) { SubjectDAO sdao = new SubjectDAO(); la.Academic = labdo.Academic; la.Description = labdo.Description; la.LearningAreaCode = labdo.LearningAreaCode; la.Units = labdo.Units; la.RatePerUnit = labdo.RatePerUnit; la.Subjects = sdao.ToSubjectList(labdo.Subjects); }
public void TranslateLearningAreaBDOToLearningArea(LearningAreaBDO la, LearningArea lBdo) { SubjectService ss = new SubjectService(); lBdo.Academic = la.Academic; lBdo.Description = la.Description; lBdo.LearningAreaCode = la.LearningAreaCode; lBdo.RatePerUnit = la.RatePerUnit; lBdo.Units = la.Units; lBdo.Subjects = ss.ToSubjectList(la.Subjects); }
public void TranslateSubjectToSubjectBDO(Subject sub, SubjectBDO sbdo) { LearningAreaService las = new LearningAreaService(); LearningAreaBDO lb = new LearningAreaBDO(); sbdo.SubjectID = sub.SubjectID; sbdo.Description = sub.Description; sbdo.GradeLevel = sub.GradeLevel; sbdo.LearningAreaCode = sub.LearningAreaCode; sbdo.SubjectCode = sub.SubjectCode; las.TranslateLearningAreaToLearningAreaBDO(sub.LArea, lb); sbdo.LearningArea = lb; }
public void ConvertSubjectToSubjectBDO(Subject s, SubjectBDO sbdo) { LearningAreaDAO ldao = new LearningAreaDAO(); LearningAreaBDO la = new LearningAreaBDO(); sbdo.Description = s.Description; sbdo.GradeLevel = s.GradeLevel; sbdo.LearningAreaCode = s.LearningAreaCode; sbdo.SubjectCode = s.SubjectCode; sbdo.SubjectID = s.SubjectID; // ldao.ConvertLearningAreaToLearningAreaBDO(s.LearningArea, la); sbdo.LearningArea = la; }
public void ConvertLearningAreaToLearningAreaBDO(LearningArea la, LearningAreaBDO labdo) { // labdo.Subjects = GetSubjectsforLearningArea(la.LearningAreaCode); labdo.Academic = la.Academic; labdo.Description = la.Description; labdo.LearningAreaCode = la.LearningAreaCode; labdo.Units = la.Units; labdo.RatePerUnit = la.RatePerUnit; labdo.RatePerSubject = la.RatePerSubject; foreach (Subject s in la.Subjects) { SubjectBDO sb = new SubjectBDO(); ConvertSubjectToSubjectBDO(s, sb); sb.Academic =(bool) la.Academic; labdo.Subjects.Add(sb); } }
public LearningAreaBDO GetLearningArea(string learningAreaCode) { LearningArea l = new LearningArea(); using (var DCEnt = new DCFIEntities()) { var lA = (from learn in DCEnt.LearningAreas where learn.LearningAreaCode == learningAreaCode select learn).FirstOrDefault(); l = lA; } LearningAreaBDO laBDO = new LearningAreaBDO(); ConvertLearningAreaToLearningAreaBDO(l, laBDO); return laBDO; }
public List<LearningAreaBDO> GetLearningAreas() { List<LearningArea> laList = new List<LearningArea>(); using (var DCEnt = new DCFIEntities()) { var allLA = (DCEnt.LearningAreas); laList = allLA.ToList<LearningArea>(); } List<LearningAreaBDO> laBDOList = new List<LearningAreaBDO>(); foreach (LearningArea l in laList) { LearningAreaBDO laBDO = new LearningAreaBDO(); ConvertLearningAreaToLearningAreaBDO(l, laBDO); laBDOList.Add(laBDO); } return laBDOList; }
public Boolean CreateLearningArea(ref LearningAreaBDO laBDO, ref string message) { message = "Learning Area Added Successfully"; bool ret = true; LearningArea la = new LearningArea(); ConvertLearningAreaBDOToLearningArea(laBDO, la); using (var DCEnt = new DCFIEntities()) { DCEnt.LearningAreas.Add(la); DCEnt.Entry(la).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num == 0) { ret = false; message = "Adding of Learning Area failed"; } } return ret; }
public bool UpdateLearningArea(ref LearningAreaBDO learningArea, ref string message) { return laDao.UpdateLearningArea(ref learningArea, ref message); }
public bool CreateLearningArea(ref LearningAreaBDO la, ref string message) { return laDao.CreateLearningArea(ref la, ref message); }
public Boolean UpdateLearningArea(ref LearningAreaBDO laBDO, ref string message) { Boolean ret = true; LearningArea l = new LearningArea(); ConvertLearningAreaBDOToLearningArea(laBDO, l); LearningArea laInDB = new LearningArea(); using (var DCEnt = new DCFIEntities()) { var learningAreaCode = laBDO.LearningAreaCode; laInDB = (from la in DCEnt.LearningAreas where la.LearningAreaCode.Equals(learningAreaCode) select la).FirstOrDefault(); if (laInDB == null) { throw new Exception("No Learning Area with Code " + laBDO.LearningAreaCode); } if (laInDB.Subjects.Count == 0) { foreach (Subject s in l.Subjects) { laInDB.Subjects.Add(s); } } else if (laInDB.Subjects.Count < l.Subjects.Count) { //compare 2 lists check the non existing to the other IEnumerable<Subject> sToAdd = l.Subjects.Except(laInDB.Subjects); if (sToAdd != null) { foreach (Subject child in sToAdd) { laInDB.Subjects.Add(child); } } IEnumerable<Subject> sToRemove = laInDB.Subjects.Except(l.Subjects); if (sToRemove != null) { foreach (Subject child in sToRemove) { laInDB.Subjects.Add(child); } } } else if (laInDB.Subjects.Count > l.Subjects.Count) { //compare 2 lists check the non existing to the other IEnumerable<Subject> sToAdd = l.Subjects.Except(laInDB.Subjects); if (sToAdd != null) { foreach (Subject child in sToAdd) { laInDB.Subjects.Add(child); } } IEnumerable<Subject> sToRemove = laInDB.Subjects.Except(l.Subjects); if (sToRemove != null) { foreach (Subject child in sToRemove) { laInDB.Subjects.Add(child); } } } else if (laInDB.Subjects.Count == l.Subjects.Count) { //compare 2 lists check the non existing to the other IEnumerable<Subject> sToAdd = laInDB.Subjects.Except(l.Subjects); IEnumerable<Subject> sToRemove = l.Subjects.Except(laInDB.Subjects); if (sToAdd != null) { foreach (Subject child in sToAdd) { laInDB.Subjects.Add(child); } } if (sToRemove != null) { foreach (Subject child in sToRemove) { laInDB.Subjects.Remove(child); } } } using (var DC = new DCFIEntities()) { // DC.Teachers.Remove(teacherInDB); laInDB = l; foreach (Subject s in laInDB.Subjects) DC.Entry(s).State = s.SubjectID == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; DC.Entry(laInDB).State = System.Data.Entity.EntityState.Modified; int num = DC.SaveChanges(); if (num > 0) { message = "No learning area is updated."; } } } return ret; }
public bool UpdateLearningArea(ref LearningArea learningArea, ref string message) { LearningAreaBDO labdo = new LearningAreaBDO(); TranslateLearningAreaToLearningAreaBDO(learningArea, labdo); return laLogic.UpdateLearningArea(ref labdo, ref message); }
public Boolean UpdateLearningArea(ref LearningAreaBDO laBDO, ref string message) { List<Subject> toRemove; List<Subject> toAdd; List<Subject> toUpdate; Boolean ret = true; LearningArea l = new LearningArea(); LearningArea laInDB = new LearningArea(); LearningArea laInDB2 = new LearningArea(); try { using (var DCEnt = new DCFIEntities()) { var learningAreaCode = laBDO.LearningAreaCode; laInDB = (from la in DCEnt.LearningAreas where la.LearningAreaCode.Equals(learningAreaCode) select la).FirstOrDefault(); if (laInDB == null) { throw new Exception("No Learning Area with Code " + laBDO.LearningAreaCode); } l.Academic = laBDO.Academic; l.Description = laBDO.Description; l.LearningAreaCode = laBDO.LearningAreaCode; l.RatePerSubject = laBDO.RatePerSubject; l.RatePerUnit = laBDO.RatePerUnit; l.Units = laBDO.Units; l.Subjects = ToSubjectList(laBDO.Subjects); if (laInDB.Subjects.Count == 0) { foreach (Subject s in l.Subjects) { laInDB.Subjects.Add(s); } } else if (laInDB.Subjects.Count < l.Subjects.Count) { //compare 2 lists check the non existing to the other List<Subject> sToAdd = new List<Subject>(); sToAdd= CompareSubjectLists(l.Subjects.ToList<Subject>(),laInDB.Subjects.ToList<Subject>()); //List<Subject> newSubToAdd = new List<Subject>(); //newSubToAdd = sToAdd.ToList<Subject>(); if (sToAdd != null) { foreach (Subject child in sToAdd) { laInDB.Subjects.Add(child); } } List<Subject> sToRemove = new List<Subject>(); sToRemove = CompareSubjectLists(laInDB.Subjects.ToList<Subject>(), l.Subjects.ToList<Subject>()); if (sToRemove != null) { foreach (Subject child in sToRemove) { laInDB.Subjects.Remove(child); } } } else if (laInDB.Subjects.Count > l.Subjects.Count) { //compare 2 lists check the non existing to the other List<Subject> sToAdd = new List<Subject>(); sToAdd = CompareSubjectLists(l.Subjects.ToList<Subject>(), laInDB.Subjects.ToList<Subject>()); if (sToAdd != null) { foreach (Subject child in sToAdd) { laInDB.Subjects.Add(child); } } List<Subject> sToRemove = new List<Subject>(); sToRemove = CompareSubjectLists(laInDB.Subjects.ToList<Subject>(), l.Subjects.ToList<Subject>()); if (sToRemove != null) { foreach (Subject child in sToRemove) { laInDB.Subjects.Remove(child); } } } else if (laInDB.Subjects.Count == l.Subjects.Count) { toRemove = new List<Subject>(); toAdd = new List<Subject>(); toUpdate = new List<Subject>(); foreach (Subject s in l.Subjects) { int c = laInDB.Subjects.Where(sub => sub.SubjectCode == s.SubjectCode).Count(); if (c == 0) toAdd.Add(s); } foreach (Subject c in toAdd) { DCEnt.Subjects.Add(c); DCEnt.Entry(c).State = System.Data.Entity.EntityState.Added; // DCEnt.SaveChanges(); } foreach (Subject s in laInDB.Subjects) { int c = l.Subjects.Where(sub => sub.SubjectCode == s.SubjectCode).Count(); if (c == 0) toRemove.Add(s); } foreach (Subject c in toRemove) { DCEnt.Subjects.Remove(c); DCEnt.Entry(c).State = System.Data.Entity.EntityState.Deleted; // DCEnt.SaveChanges(); } DCEnt.LearningAreas.Remove(laInDB); DCEnt.LearningAreas.Attach(laInDB); DCEnt.Entry(laInDB).State = System.Data.Entity.EntityState.Modified; // DCEnt.SaveChanges(); } //foreach (Subject s in laInDB.Subjects) // DCEnt.Entry(s).State = s.SubjectID == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num > 0) { message = "No learning area is updated."; } } } 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 UpdateLearningArea(ref LearningAreaBDO laBDO, ref string message) { List<Subject> toRemove; List<Subject> toAdd; List<Subject> toUpdate; Boolean ret = true; LearningArea l = new LearningArea(); LearningArea laInDB = new LearningArea(); LearningArea laInDB2 = new LearningArea(); try { using (var DCEnt = new DCFIEntities()) { var learningAreaCode = laBDO.LearningAreaCode; laInDB = (from la in DCEnt.LearningAreas where la.LearningAreaCode.Equals(learningAreaCode) select la).FirstOrDefault(); if (laInDB == null) { throw new Exception("No Learning Area with Code " + laBDO.LearningAreaCode); } l.Academic = laBDO.Academic; l.Description = laBDO.Description; l.LearningAreaCode = laBDO.LearningAreaCode; l.RatePerSubject = laBDO.RatePerSubject; l.RatePerUnit = laBDO.RatePerUnit; l.Units = laBDO.Units; l.Subjects = ToSubjectList(laBDO.Subjects); if (laInDB.Subjects.Count == 0) { foreach (Subject s in l.Subjects) { laInDB.Subjects.Add(s); } } else { toRemove = new List<Subject>(); toAdd = new List<Subject>(); toUpdate = new List<Subject>(); foreach (Subject s in l.Subjects) { Subject subj = new Subject(); subj = laInDB.Subjects.Where(sub => sub.SubjectCode == s.SubjectCode).FirstOrDefault(); if (subj == null) { DCEnt.Subjects.Add(s); DCEnt.Entry(s).State = System.Data.Entity.EntityState.Added; } else { if (!CompareSubject(subj, s)) { toUpdate.Add(s); } } } //Add new Subject if (toAdd.Count > 0) { foreach (Subject c in toAdd) { DCEnt.Subjects.Add(c); DCEnt.Entry(c).State = System.Data.Entity.EntityState.Added; } } foreach (Subject c in laInDB.Subjects) { Subject subj = new Subject(); subj = l.Subjects.Where(sub => sub.SubjectCode == c.SubjectCode).FirstOrDefault(); Subject upSubj = new Subject(); upSubj = toUpdate.Where(sub => sub.SubjectCode == c.SubjectCode).FirstOrDefault(); //toRemove subject if (subj == null) { DCEnt.Subjects.Remove(c); DCEnt.Entry(c).State = System.Data.Entity.EntityState.Deleted; } //toUpdate subject if (upSubj != null) { c.Description = upSubj.Description; c.MPW = upSubj.MPW; DCEnt.Entry(c).State = System.Data.Entity.EntityState.Modified; } } DCEnt.LearningAreas.Attach(laInDB); DCEnt.Entry(laInDB).State = System.Data.Entity.EntityState.Modified; } int num = DCEnt.SaveChanges(); if (num > 0) { message = "No learning area is updated."; } } } 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; }