public Boolean CreateGradeSection(ref GradeSectionBDO gsBDO, ref string message) { message = "Grade Section Added Successfully"; bool ret = true; GradeSection gs = new GradeSection(); try{ ConvertGradeSectionBDOToGradeSection(gsBDO, gs); using (var DCEnt = new DCFIEntities()) { DCEnt.GradeSections.Attach(gs); DCEnt.Entry(gs).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Adding of Grade Section 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 ActivateUser(int userId, ref string message) { message = "User Activated successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { User userInDB = (from u in DCEnt.Users where u.UserId == userId select u).FirstOrDefault(); if (userInDB == null) { throw new Exception("No user with ID " + userId); } DCEnt.Users.Remove(userInDB); userInDB.Deactivated = false; DCEnt.Users.Attach(userInDB); DCEnt.Entry(userInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Activation Failed."; } } return ret; }
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 Boolean AddLog(LogBDO log) { //string message = "Log Added Successfully"; bool ret = true; try { Log l = new Log(); ConvertLogBDOToLog(log, l); using (var DCEnt = new DCFIEntities()) { DCEnt.Logs.Add(l); DCEnt.Entry(l).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); 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 DeleteUser(int userId, ref string message) { message = "User Deleted successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { User userInDB = (from u in DCEnt.Users where u.UserId == userId select u).FirstOrDefault(); if (userInDB == null) { throw new Exception("No user with ID " + userId); } DCEnt.Users.Remove(userInDB); DCEnt.Entry(userInDB).State = System.Data.Entity.EntityState.Deleted; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Deletion of User Failed."; } } return(ret); }
public Boolean DeleteTimeslot(string timeslotCode, ref string message) { message = "Timeslot Deleted successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { Timeslot tInDB = (from t in DCEnt.Timeslots where t.TimeSlotCode == timeslotCode select t).FirstOrDefault(); if (tInDB == null) { throw new Exception("No timeslot with code " + tInDB); } DCEnt.Timeslots.Remove(tInDB); DCEnt.Entry(tInDB).State = System.Data.Entity.EntityState.Deleted; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Deletion of Timeslot Failed."; } } return(ret); }
public Boolean UpdateTimeslot(ref TimeslotBDO tBDO, ref string message) { message = "Timeslot updated successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { var timeslotCode = tBDO.TimeSlotCode; Timeslot timeslotInDB = (from t in DCEnt.Timeslots where t.TimeSlotCode == timeslotCode select t).FirstOrDefault(); if (timeslotInDB == null) { throw new Exception("No timeslot with code " + tBDO.TimeSlotCode); } DCEnt.Timeslots.Remove(timeslotInDB); timeslotInDB.TimeStart = tBDO.TimeStart; timeslotInDB.TimeEnd = tBDO.TimeEnd; timeslotInDB.Days = tBDO.Days; DCEnt.Timeslots.Attach(timeslotInDB); DCEnt.Entry(timeslotInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No timeslot is updated."; } } return(ret); }
public Boolean UpdateSY(ref SchoolYearBDO syBDO, ref string message) { message = "School Year updated successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { var SY = syBDO.SY; SchoolYear syInDB = (from u in DCEnt.SchoolYears where u.SY == SY select u).FirstOrDefault(); if (syInDB == null) { throw new Exception(syBDO.SY + " doesn't exist"); } DCEnt.SchoolYears.Remove(syInDB); syInDB.SY = syBDO.SY; syInDB.CurrentSY = syBDO.CurrentSY; DCEnt.SchoolYears.Attach(syInDB); DCEnt.Entry(syInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No SY is updated."; } } return(ret); }
public Boolean CreateTimeslot(ref TimeslotBDO tBDO, ref string message) { message = "Timeslot Added Successfully"; bool ret = true; Timeslot t = new Timeslot() { TimeSlotCode = tBDO.TimeSlotCode, TimeStart = tBDO.TimeStart, TimeEnd = tBDO.TimeEnd, Days = tBDO.Days }; using (var DCEnt = new DCFIEntities()) { DCEnt.Timeslots.Attach(t); DCEnt.Entry(t).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); tBDO.TimeSlotCode = t.TimeSlotCode; if (num != 1) { ret = false; message = "Adding of Timeslot failed"; } } return(ret); }
public Boolean DeleteSY(string schoolyear, ref string message) { message = "SY " + schoolyear + " Deleted successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { SchoolYear SYInDB = (from u in DCEnt.SchoolYears where u.SY == schoolyear select u).FirstOrDefault(); if (SYInDB == null) { throw new Exception("No SY " + schoolyear + " existed"); } DCEnt.SchoolYears.Remove(SYInDB); DCEnt.Entry(SYInDB).State = System.Data.Entity.EntityState.Deleted; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Deletion of SY Failed."; } } return(ret); }
public Boolean DismissStudent(string studentID, ref string message) { message = "Student dismissed successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { Student studentInDB = (from s in DCEnt.Students where s.StudentId == studentID select s).FirstOrDefault(); if (studentInDB == null) { throw new Exception("No student with ID " + studentID); } DCEnt.Students.Remove(studentInDB); studentInDB.Dismissed = true; DCEnt.Students.Attach(studentInDB); DCEnt.Entry(studentInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Fail to Dismiss Student."; } } return ret; }
public Boolean CreateSY(ref SchoolYearBDO syBDO, ref string message) { message = "School Year Added Successfully"; bool ret = true; SchoolYear u = new SchoolYear() { SY = syBDO.SY, CurrentSY = syBDO.CurrentSY }; using (var DCEnt = new DCFIEntities()) { DCEnt.SchoolYears.Attach(u); DCEnt.Entry(u).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); syBDO.SY = u.SY; if (num != 1) { ret = false; message = "Adding of School Year failed"; } } return(ret); }
public Boolean CreateUser(ref UserBDO userBDO, ref string message) { message = "User Added Successfully"; bool ret = true; UserType ut = new UserType() { UserType1 = userBDO.UserType.UsersType, UserTypeCode = userBDO.UserType.UserTypeCode }; User u = new User() { UserName = userBDO.UserName, Password = userBDO.Password, LastName = userBDO.LastName, FirstName = userBDO.FirstName, MiddleName = userBDO.MiddleName, UserTypeCode = userBDO.UserType.UserTypeCode, UserType = ut }; using (var DCEnt = new DCFIEntities()) { DCEnt.Users.Attach(u); DCEnt.Entry(u).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); userBDO.UserId = u.UserId; if (num != 1) { ret = false; message = "Adding of User failed"; } } return(ret); }
public Boolean UpdateCurriculum(ref CurriculumBDO cbdo, ref string message) { message = "Curriculum updated successfully."; Boolean ret = true; Curriculum c = new Curriculum(); ConvertCurriculumBDOToCurriculum(cbdo, c); using (var DCEnt = new DCFIEntities()) { var cCode = c.CurriculumCode; Curriculum cInDB = (from curri in DCEnt.Curriculums where curri.CurriculumCode == cCode select curri).FirstOrDefault(); if (cInDB == null) { throw new Exception("No Curriculum with Code" + c.CurriculumCode); } DCEnt.Curriculums.Remove(cInDB); ConvertCurriculumBDOToCurriculum(cbdo, cInDB); DCEnt.Curriculums.Attach(cInDB); DCEnt.Entry(cInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num == 0) { ret = false; message = "No Curriculum is updated."; } } return(ret); }
public Boolean AddLog(LogBDO log) { //string message = "Log Added Successfully"; bool ret = true; try { Log l = new Log(); ConvertLogBDOToLog(log, l); using (var DCEnt = new DCFIEntities()) { DCEnt.Logs.Add(l); DCEnt.Entry(l).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); 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 UpdateTrait(ref TraitBDO tBDO, ref string message) { message = "Trait updated successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { var traitCode = tBDO.TraitCode; Trait tInDB = (from t in DCEnt.Traits where t.TraitCode == traitCode select t).FirstOrDefault(); if (tInDB == null) { throw new Exception("No Trait with TraitCode " + tBDO.TraitCode); } DCEnt.Traits.Remove(tInDB); tInDB.Description = tBDO.Description; tInDB.GradeLevel = tBDO.GradeLevel; tInDB.TraitCode = tBDO.TraitCode; DCEnt.Traits.Attach(tInDB); DCEnt.Entry(tInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No trait is updated."; } } return(ret); }
public Boolean CreateTrait(ref TraitBDO tBDO, ref string message) { message = "Trait Added Successfully"; bool ret = true; Trait t = new Trait(); try { ConvertTraitBDOToTrait(tBDO, t); using (var DCEnt = new DCFIEntities()) { DCEnt.Traits.Attach(t); DCEnt.Entry(t).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Adding of Trait 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 CreateSY(ref SchoolYearBDO syBDO, ref string message) { message = "School Year Added Successfully"; bool ret = true; SchoolYear u = new SchoolYear() { SY = syBDO.SY, CurrentSY = syBDO.CurrentSY }; using (var DCEnt = new DCFIEntities()) { DCEnt.SchoolYears.Attach(u); DCEnt.Entry(u).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); syBDO.SY = u.SY; if (num != 1) { ret = false; message = "Adding of School Year failed"; } } return ret; }
public Boolean UpdateGradeLevel(ref GradeLevelBDO gBDO, ref string message) { message = "Grade Level updated successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { var gCode = gBDO.GradeLev; GradeLevel gInDB = (from g in DCEnt.GradeLevels where g.GradeLevel1 == gCode select g).FirstOrDefault(); if (gInDB == null) { throw new Exception("No Grade Level " + gBDO.GradeLev); } DCEnt.GradeLevels.Remove(gInDB); gInDB.GradeLevel1 = gBDO.GradeLev; gInDB.Description = gBDO.Description; DCEnt.GradeLevels.Attach(gInDB); DCEnt.Entry(gInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No grade level is updated."; } } return ret; }
// DCEnt.Scholarships.Remove(sInDB); // sInDB.Condition = sBDO.Condition; // sInDB.Deactivated = sBDO.Deactivated; // sInDB.Description = sBDO.Description; // sInDB.Privilege = sBDO.Privilege; // sInDB.ScholarshipCode = sBDO.ScholarshipCode; // DCEnt.Scholarships.Attach(sInDB); // DCEnt.Entry(sInDB).State = System.Data.Entity.EntityState.Modified; // int num = DCEnt.SaveChanges(); // if (num != 1) // { // ret = false; // message = "No scholarship is updated."; // } //} //return ret; public Boolean UpdateScholarshipDiscount(ref ScholarshipDiscountBDO sBDO, ref string message) { message = "Scholarship discount updated successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { var scholarshipCode = sBDO.ScholarshipCode; ScholarshipDiscount sInDB = (from s in DCEnt.ScholarshipDiscounts where s.ScholarshipCode == scholarshipCode select s).FirstOrDefault(); if (sInDB == null) { throw new Exception("No Scholarship discount with ScholarshipCode " + sBDO.ScholarshipCode); } DCEnt.ScholarshipDiscounts.Remove(sInDB); sInDB.FeeCode = sBDO.FeeCode; sInDB.Deactivated = sBDO.Deactivated; sInDB.Discount = sBDO.Discount; sInDB.ScholarshipCode = sBDO.ScholarshipCode; DCEnt.ScholarshipDiscounts.Attach(sInDB); DCEnt.Entry(sInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No scholarship discount is updated."; } } return(ret); }
public Boolean DeleteScholarshipDiscount(string sdCode, string scholarshipCode) { //message = "User Deleted successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { ScholarshipDiscount sdInDB = (from sd in DCEnt.ScholarshipDiscounts where sd.ScholarshipCode == scholarshipCode && sd.ScholarshipFeeCode == sdCode select sd).FirstOrDefault(); if (sdInDB == null) { throw new Exception("No Scholarship Discount with ID " + sdCode); } DCEnt.ScholarshipDiscounts.Remove(sdInDB); DCEnt.Entry(sdInDB).State = System.Data.Entity.EntityState.Deleted; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; //message = "Deletion of User Failed."; } } return(ret); }
public Boolean AddScholarshipDiscount(ScholarshipDiscountBDO discount,int scholarshipCode, ref string message) { message = "Scholarship Discount Added Successfully"; Boolean ret = true; ScholarshipDiscount sd = new ScholarshipDiscount(); try { ConvertScholarshipDiscountBDOToScholarshipDiscount(discount, sd); using (var DCEnt = new DCFIEntities()) { DCEnt.ScholarshipDiscounts.Add(sd); DCEnt.Entry(sd).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Adding of Scholarship Discount 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 CreateUser(ref UserBDO userBDO, ref string message) { message = "User Added Successfully"; bool ret = true; UserType ut = new UserType() { UserType1 = userBDO.UserType.UsersType, UserTypeCode = userBDO.UserType.UserTypeCode }; User u = new User() { UserName = userBDO.UserName, Password = userBDO.Password, LastName = userBDO.LastName, FirstName = userBDO.FirstName, MiddleName = userBDO.MiddleName, UserTypeCode = userBDO.UserType.UserTypeCode, UserType = ut }; using (var DCEnt = new DCFIEntities()) { DCEnt.Users.Attach(u); DCEnt.Entry(u).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); userBDO.UserId = u.UserId; if (num != 1) { ret = false; message = "Adding of User failed"; } } return ret; }
public Boolean CreateFee(ref FeeBDO fBDO, ref string message) { message = "Fee Added Successfully"; bool ret = true; Fee f = new Fee(); try { ConvertFeeBDOToFee(fBDO, f); using (var DCEnt = new DCFIEntities()) { DCEnt.Fees.Attach(f); DCEnt.Entry(f).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Adding of Fee 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 UpdateGradeLevel(ref GradeLevelBDO gBDO, ref string message) { message = "Grade Level updated successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { var gCode = gBDO.GradeLev; GradeLevel gInDB = (from g in DCEnt.GradeLevels where g.GradeLevel1 == gCode select g).FirstOrDefault(); if (gInDB == null) { throw new Exception("No Grade Level " + gBDO.GradeLev); } DCEnt.GradeLevels.Remove(gInDB); gInDB.GradeLevel1 = gBDO.GradeLev; gInDB.Description = gBDO.Description; DCEnt.GradeLevels.Attach(gInDB); DCEnt.Entry(gInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No grade level is updated."; } } return(ret); }
public Boolean CreateCurriculum(ref CurriculumBDO cbdo, ref string message) { message = "Curriculum Added Successfully"; bool ret = true; Curriculum cur = new Curriculum(); try { ConvertCurriculumBDOToCurriculum(cbdo, cur); using (var DCEnt = new DCFIEntities()) { DCEnt.Curriculums.Add(cur); DCEnt.Entry(cur).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num == 0) { ret = false; message = "Adding of Curriculum 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 UpdateSubject(ref SubjectBDO subjectBDO, ref string message) { message = "Subject updated successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { var subjectCode = subjectBDO.SubjectCode; Subject subjectInDB = (from s in DCEnt.Subjects where s.SubjectCode == subjectCode select s).FirstOrDefault(); if (subjectInDB == null) { throw new Exception("No Subject with SubjectCode " + subjectBDO.SubjectCode); } DCEnt.Subjects.Remove(subjectInDB); subjectInDB.SubjectID = subjectBDO.SubjectID; subjectInDB.Description = subjectBDO.Description; subjectInDB.GradeLevel = subjectBDO.GradeLevel; subjectInDB.LearningAreaCode = subjectBDO.LearningAreaCode; subjectInDB.SubjectCode = subjectBDO.SubjectCode; DCEnt.Subjects.Attach(subjectInDB); DCEnt.Entry(subjectInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No subject is updated."; } } return(ret); }
public Boolean GraduateStudent(string studentID, ref string message) { message = "User Retained successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { Student studentInDB = (from s in DCEnt.Students where s.StudentId == studentID select s).FirstOrDefault(); if (studentInDB == null) { throw new Exception("No student with ID " + studentID); } DCEnt.Students.Remove(studentInDB); studentInDB.Graduated = false; DCEnt.Students.Attach(studentInDB); DCEnt.Entry(studentInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Changing Graduate Status Failed."; } } return(ret); }
public Boolean CreateBuilding(ref BuildingBDO buildBDO, ref string message) { message = "Building Added Successfully"; bool ret = true; try { Building b = new Building(); ConvertBuildingBDOToBuilding(buildBDO,b); using (var DCEnt = new DCFIEntities()) { DCEnt.Buildings.Add(b); DCEnt.Entry(b).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); buildBDO.BuildingCode = b.BuildingCode; if (num < 1) { ret = false; message = "Adding of Building 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 DeleteSY(string schoolyear, ref string message) { message = "SY " + schoolyear + " Deleted successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { SchoolYear SYInDB = (from u in DCEnt.SchoolYears where u.SY == schoolyear select u).FirstOrDefault(); if (SYInDB == null) { throw new Exception("No SY " + schoolyear + " existed"); } DCEnt.SchoolYears.Remove(SYInDB); DCEnt.Entry(SYInDB).State = System.Data.Entity.EntityState.Deleted; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Deletion of SY Failed."; } } return ret; }
public Boolean UpdateUser(ref UserBDO userBDO, ref string message) { message = "User updated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { var userID = userBDO.UserId; User userInDB = (from u in DCEnt.Users where u.UserId == userID select u).FirstOrDefault(); if (userInDB == null) { throw new Exception("No user with ID " + userBDO.UserId); } DCEnt.Users.Remove(userInDB); UserType ut = new UserType(); ut.UserTypeCode = userBDO.UserType.UserTypeCode; ut.UserType1 = userBDO.UserType.UsersType; userInDB.LastName = userBDO.LastName; userInDB.FirstName = userBDO.FirstName; userInDB.MiddleName = userBDO.MiddleName; userInDB.UserName = userBDO.UserName; userInDB.Password = userBDO.Password; userInDB.Deactivated = userBDO.Deactivated; userInDB.UserTypeCode = ut.UserTypeCode; DCEnt.Users.Attach(userInDB); DCEnt.Entry(userInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No user 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 UpdateGradeSection(ref GradeSectionBDO gsBDO, ref string message) { message = "Grade Section updated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { var gsCode = gsBDO.GradeSectionCode; GradeSection gsInDB = (from gs in DCEnt.GradeSections where gs.GradeSectionCode == gsCode select gs).FirstOrDefault(); if (gsInDB == null) { throw new Exception("No Grade Section with Grade Section Code " + gsBDO.GradeSectionCode); } DCEnt.GradeSections.Remove(gsInDB); gsInDB.Deactivated = gsBDO.Deactivated; gsInDB.GradeLevel = gsBDO.GradeLevel; gsInDB.GradeSectionCode = gsBDO.GradeSectionCode; gsInDB.HomeRoomNumber = gsBDO.HomeRoomNumber; gsInDB.HomeRoomTeacherId = gsBDO.HomeRoomTeacherId; gsInDB.Section = gsBDO.Section; gsInDB.SY = gsBDO.SY; gsInDB.Class = gsBDO.Class; DCEnt.GradeSections.Attach(gsInDB); DCEnt.Entry(gsInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No grade section 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 UpdateRoom(ref RoomBDO roomBDO, ref string message) { message = "Room updated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { var roomCode = roomBDO.RoomCode; Room roomInDB = (from r in DCEnt.Rooms where r.RoomCode == roomCode select r).FirstOrDefault(); if (roomInDB == null) { throw new Exception("No room with RoomCode " + roomBDO.RoomCode); } DCEnt.Rooms.Remove(roomInDB); roomInDB.BuildingCode = roomBDO.BuildingCode; roomInDB.Capacity = roomBDO.Capacity; roomInDB.Deactivated = roomBDO.Deactivated; roomInDB.Description = roomBDO.Description; roomInDB.RoomCode = roomBDO.RoomNumber; roomInDB.RoomNumber = roomBDO.RoomNumber; roomInDB.RoomId = roomBDO.RoomId; DCEnt.Rooms.Attach(roomInDB); DCEnt.Entry(roomInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No room 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 UpdateSubject(ref SubjectBDO subjectBDO, ref string message) { message = "Subject updated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { var subjectCode = subjectBDO.SubjectCode; Subject subjectInDB = (from s in DCEnt.Subjects where s.SubjectCode == subjectCode select s).FirstOrDefault(); if (subjectInDB == null) { throw new Exception("No Subject with SubjectCode " + subjectBDO.SubjectCode); } DCEnt.Subjects.Remove(subjectInDB); subjectInDB.SubjectID = subjectBDO.SubjectID; subjectInDB.Description = subjectBDO.Description; subjectInDB.GradeLevel = subjectBDO.GradeLevel; subjectInDB.LearningAreaCode = subjectBDO.LearningAreaCode; subjectInDB.SubjectCode = subjectBDO.SubjectCode; subjectInDB.MPW = subjectBDO.MPW; DCEnt.Subjects.Attach(subjectInDB); DCEnt.Entry(subjectInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No subject 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 CreateUser(ref UserBDO userBDO, ref string message) { message = "User Added Successfully"; bool ret = true; UserType ut = new UserType() { UserType1 = userBDO.UserType.UsersType, UserTypeCode = userBDO.UserType.UserTypeCode }; User u = new User() { UserName = userBDO.UserName, Password = userBDO.Password, LastName = userBDO.LastName, FirstName = userBDO.FirstName, MiddleName = userBDO.MiddleName, UserTypeCode = userBDO.UserType.UserTypeCode, UserType = ut }; try { using (var DCEnt = new DCFIEntities()) { DCEnt.Users.Attach(u); DCEnt.Entry(u).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); userBDO.UserId = u.UserId; if (num != 1) { ret = false; message = "Adding of User 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 CreateUser(ref UserBDO userBDO, ref string message) { message = "User Added Successfully"; bool ret = true; UserType ut = new UserType() { UserType1 = userBDO.UserType.UsersType, UserTypeCode = userBDO.UserType.UserTypeCode }; User u = new User() { UserName = userBDO.UserName, Password = userBDO.Password, LastName = userBDO.LastName, FirstName = userBDO.FirstName, MiddleName = userBDO.MiddleName, UserTypeCode = userBDO.UserType.UserTypeCode, UserType = ut }; try { using (var DCEnt = new DCFIEntities()) { DCEnt.Users.Attach(u); DCEnt.Entry(u).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); userBDO.UserId = u.UserId; if (num != 1) { ret = false; message = "Adding of User 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; }
// DCEnt.Scholarships.Remove(sInDB); // sInDB.Condition = sBDO.Condition; // sInDB.Deactivated = sBDO.Deactivated; // sInDB.Description = sBDO.Description; // sInDB.Privilege = sBDO.Privilege; // sInDB.ScholarshipCode = sBDO.ScholarshipCode; // DCEnt.Scholarships.Attach(sInDB); // DCEnt.Entry(sInDB).State = System.Data.Entity.EntityState.Modified; // int num = DCEnt.SaveChanges(); // if (num != 1) // { // ret = false; // message = "No scholarship is updated."; // } //} //return ret; public Boolean UpdateScholarshipDiscount(ref ScholarshipDiscountBDO sBDO, ref string message) { message = "Scholarship discount updated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { var scholarshipCode = sBDO.ScholarshipDiscountId; ScholarshipDiscount sInDB = (from s in DCEnt.ScholarshipDiscounts where s.ScholarshipDiscountId == scholarshipCode select s).FirstOrDefault(); if (sInDB == null) { throw new Exception("No Scholarship discount with ScholarshipCode " + sBDO.ScholarshipDiscountId); } DCEnt.ScholarshipDiscounts.Remove(sInDB); // sInDB.FeeID= sBDO.FeeID; sInDB.Deactivated = sBDO.Deactivated; sInDB.Discount = sBDO.Discount; sInDB.ScholarshipDiscountId = sBDO.ScholarshipDiscountId; DCEnt.ScholarshipDiscounts.Attach(sInDB); DCEnt.Entry(sInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No scholarship discount 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 UpdateTimeslot(ref TimeslotBDO tBDO, ref string message) { message = "Timeslot updated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { var timeslotCode = tBDO.TimeSlotCode; Timeslot timeslotInDB = (from t in DCEnt.Timeslots where t.TimeSlotCode == timeslotCode select t).FirstOrDefault(); if (timeslotInDB == null) { throw new Exception("No timeslot with code " + tBDO.TimeSlotCode); } DCEnt.Timeslots.Remove(timeslotInDB); timeslotInDB.TimeStart = tBDO.TimeStart; timeslotInDB.TimeEnd = tBDO.TimeEnd; timeslotInDB.Days = tBDO.Days; timeslotInDB.TotalMins = tBDO.TotalMins; DCEnt.Timeslots.Attach(timeslotInDB); DCEnt.Entry(timeslotInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No timeslot 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 UpdateStudentSection(String studentSy, int gradeSectionCode) { try { using (var DCEnt = new DCFIEntities()) { var x = (from ss in DCEnt.StudentEnrollments where ss.StudentSY == studentSy select ss).FirstOrDefault(); StudentEnrollment s = new StudentEnrollment(); s.DiscountId = x.DiscountId; s.Dismissed = x.Dismissed; s.GradeLevel = x.GradeLevel; s.Stat = x.Stat; s.StudentEnrollmentsID = x.StudentEnrollmentsID; //s.SY = x.SY; DCEnt.StudentEnrollments.Remove(x); x.StudentId = studentSy.Substring(0, 8); x.GradeSectionCode = gradeSectionCode; x.SY = studentSy.Substring(8, 9); x.DiscountId = s.DiscountId; x.GradeLevel = s.GradeLevel; x.Stat = s.Stat; DCEnt.StudentEnrollments.Attach(x); DCEnt.Entry(x).State = System.Data.Entity.EntityState.Modified; int num = 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 SaveTraitsGrades(List <StudentTraitBDO> grades) { Boolean ret = true; StudentTrait gradeInDB = new StudentTrait(); try { using (var DCEnt = new DCFIEntities()) { foreach (StudentTraitBDO grade in grades) { gradeInDB = (from ss in DCEnt.StudentTraits where ss.StudentEnrTraitCode == grade.StudentEnrTraitCode select ss).FirstOrDefault(); DCEnt.StudentTraits.Remove(gradeInDB); ConvertStuTraitsBDOToStuTraits(grade, gradeInDB); DCEnt.StudentTraits.Attach(gradeInDB); DCEnt.Entry(gradeInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); 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 UpdateSY(ref SchoolYearBDO syBDO, ref string message) { message = "School Year updated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { var SY = syBDO.SY; SchoolYear syInDB = (from u in DCEnt.SchoolYears where u.SY == SY select u).FirstOrDefault(); if (syInDB == null) { throw new Exception(syBDO.SY + " doesn't exist"); } DCEnt.SchoolYears.Remove(syInDB); syInDB.SY = syBDO.SY; syInDB.CurrentSY = syBDO.CurrentSY; DCEnt.SchoolYears.Attach(syInDB); DCEnt.Entry(syInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No SY 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 UpdateFee(ref FeeBDO fBDO, ref string message) { message = "Fee updated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { var fCode = fBDO.FeeID; Fee fInDB = (from f in DCEnt.Fees where f.FeeID == fCode select f).FirstOrDefault(); if (fInDB == null) { throw new Exception("No Fee " + fBDO.FeeID); } DCEnt.Fees.Remove(fInDB); ConvertFeeBDOToFee(fBDO, fInDB); DCEnt.Fees.Attach(fInDB); DCEnt.Entry(fInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No fee 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 GraduateStudent(string studentID, ref string message) { message = "User Retained successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { Student studentInDB = (from s in DCEnt.Students where s.StudentId == studentID select s).FirstOrDefault(); if (studentInDB == null) { throw new Exception("No student with ID " + studentID); } DCEnt.Students.Remove(studentInDB); studentInDB.Graduated = false; DCEnt.Students.Attach(studentInDB); DCEnt.Entry(studentInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Changing Graduate Status 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 UpdateGradeLevel(ref GradeLevelBDO gBDO, ref string message) { message = "Grade Level updated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { var gCode = gBDO.GradeLev; GradeLevel gInDB = (from g in DCEnt.GradeLevels where g.GradeLevel1 == gCode select g).FirstOrDefault(); if (gInDB == null) { throw new Exception("No Grade Level " + gBDO.GradeLev); } DCEnt.GradeLevels.Remove(gInDB); gInDB.GradeLevel1 = gBDO.GradeLev; gInDB.Description = gBDO.Description; DCEnt.GradeLevels.Attach(gInDB); DCEnt.Entry(gInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No grade level 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 ActivateUser(int userId, ref string message) { message = "User Activated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { User userInDB = (from u in DCEnt.Users where u.UserId == userId select u).FirstOrDefault(); if (userInDB == null) { throw new Exception("No user with ID " + userId); } DCEnt.Users.Remove(userInDB); userInDB.Deactivated = false; DCEnt.Users.Attach(userInDB); DCEnt.Entry(userInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Activation 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 ActivateUser(int userId, ref string message) { message = "User Activated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { User userInDB = (from u in DCEnt.Users where u.UserId == userId select u).FirstOrDefault(); if (userInDB == null) { throw new Exception("No user with ID " + userId); } DCEnt.Users.Remove(userInDB); userInDB.Deactivated = false; DCEnt.Users.Attach(userInDB); DCEnt.Entry(userInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Activation 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 ActivateTimeslot(string timeslotCode, ref string message) { message = "Timeslot Activated successfully."; Boolean ret = true; try { using (var DCEnt = new DCFIEntities()) { Timeslot tInDB = (from t in DCEnt.Timeslots where t.TimeSlotCode == timeslotCode select t).FirstOrDefault(); if (tInDB == null) { throw new Exception("No timeslot with code " + tInDB); } DCEnt.Timeslots.Remove(tInDB); tInDB.Deactivated = false; DCEnt.Timeslots.Attach(tInDB); DCEnt.Entry(tInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Activation 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 CreateCurriculum(ref CurriculumBDO cbdo, ref string message) { message = "Curriculum Added Successfully"; bool ret = true; Curriculum cur = new Curriculum(); ConvertCurriculumBDOToCurriculum(cbdo, cur); using (var DCEnt = new DCFIEntities()) { DCEnt.Curriculums.Add(cur); DCEnt.Entry(cur).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num == 0) { ret = false; message = "Adding of Curriculum failed"; } } return ret; }
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 Boolean CreateGradeLevel(ref GradeLevelBDO gBDO, ref string message) { message = "Grade Level Added Successfully"; bool ret = true; GradeLevel g = new GradeLevel(); ConvertGradeLevelBDOToGradeLevel(gBDO, g); using (var DCEnt = new DCFIEntities()) { DCEnt.GradeLevels.Attach(g); DCEnt.Entry(g).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Adding of Grade Level failed"; } } return ret; }
public Boolean CreateTrait(ref TraitBDO tBDO, ref string message) { message = "Trait Added Successfully"; bool ret = true; Trait t = new Trait(); ConvertTraitBDOToTrait(tBDO, t); using (var DCEnt = new DCFIEntities()) { DCEnt.Traits.Attach(t); DCEnt.Entry(t).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Adding of Trait failed"; } } return ret; }
public Boolean CreateFee(ref FeeBDO fBDO, ref string message) { message = "Fee Added Successfully"; bool ret = true; Fee f = new Fee(); ConvertFeeBDOToFee(fBDO, f); using (var DCEnt = new DCFIEntities()) { DCEnt.Fees.Attach(f); DCEnt.Entry(f).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Adding of Fee failed"; } } return ret; }
public Boolean CreateRoom(ref RoomBDO roomBDO, ref string message) { message = "Room Added Successfully"; bool ret = true; Room room = new Room(); ConvertRoomBDOToRoom(roomBDO, room); using (var DCEnt = new DCFIEntities()) { DCEnt.Rooms.Attach(room); DCEnt.Entry(room).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Adding of Room failed"; } return ret; } }
public Boolean CreateSY(ref SchoolYearBDO syBDO, ref string message) { message = "School Year Added Successfully"; bool ret = true; SchoolYear u = new SchoolYear() { SY = syBDO.SY, CurrentSY = syBDO.CurrentSY }; try { using (var DCEnt = new DCFIEntities()) { DCEnt.SchoolYears.Attach(u); DCEnt.Entry(u).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); syBDO.SY = u.SY; if (num != 1) { ret = false; message = "Adding of School Year 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 CreateScholarship(ref ScholarshipBDO sBDO, ref string message) { message = "Scholarship Added Successfully"; bool ret = true; Scholarship s = new Scholarship(); ConvertScholarshipBDOToScholarship(sBDO, s); using (var DCEnt = new DCFIEntities()) { DCEnt.Scholarships.Add(s); DCEnt.Entry(s).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); sBDO.ScholarshipCode = s.ScholarshipCode; if (num != 1) { ret = false; message = "Adding of Scholarship failed"; } } return ret; }
public Boolean CreateBuilding(ref BuildingBDO buildBDO, ref string message) { message = "Building Added Successfully"; bool ret = true; Building b = new Building(); ConvertBuildingBDOToBuilding(buildBDO,b); using (var DCEnt = new DCFIEntities()) { DCEnt.Buildings.Add(b); DCEnt.Entry(b).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); buildBDO.BuildingCode = b.BuildingCode; if (num != 1) { ret = false; message = "Adding of Building failed"; } } return ret; }
public Boolean CreateSubject(ref SubjectBDO subjectBDO, ref string message) { message = "Subject Added Successfully"; bool ret = true; Subject s = new Subject(); ConvertSubjectBDOToSubject(subjectBDO, s); using (var DCEnt = new DCFIEntities()) { DCEnt.Subjects.Attach(s); DCEnt.Entry(s).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Adding of Subject failed"; } } return ret; }
public Boolean AddScholarshipDiscount(ScholarshipDiscountBDO discount, string scholarshipCode, ref string message) { message = "Scholarship Discount Added Successfully"; Boolean ret = true; ScholarshipDiscount sd = new ScholarshipDiscount(); ConvertScholarshipDiscountBDOToScholarshipDiscount(discount, sd, scholarshipCode); using (var DCEnt = new DCFIEntities()) { DCEnt.ScholarshipDiscounts.Attach(sd); DCEnt.Entry(sd).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Adding of Scholarship Discount failed"; } return ret; } }
public Boolean UpdateFee(ref FeeBDO fBDO, ref string message) { message = "Fee updated successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { var fCode = fBDO.FeeCode; Fee fInDB = (from f in DCEnt.Fees where f.FeeCode == fCode select f).FirstOrDefault(); if (fInDB == null) { throw new Exception("No Fee " + fBDO.FeeCode); } DCEnt.Fees.Remove(fInDB); fInDB.Deactivated = fBDO.Deactivated; fInDB.FeeCode = fBDO.FeeCode; fInDB.FeeDescription = fBDO.FeeDescription; fInDB.Unit = fBDO.Unit; fInDB.Amount = fBDO.Amount; fInDB.DateSet = fBDO.DateSet; fInDB.GradeLevel = fBDO.GradeLevel; fInDB.SYImplemented = fBDO.SYImplemented; DCEnt.Fees.Attach(fInDB); DCEnt.Entry(fInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No fee is updated."; } } return ret; }
public Boolean UpdateGradeSection(ref GradeSectionBDO gsBDO, ref string message) { message = "Grade Section updated successfully."; Boolean ret = true; using (var DCEnt = new DCFIEntities()) { var gsCode = gsBDO.GradeSectionCode; GradeSection gsInDB = (from gs in DCEnt.GradeSections where gs.GradeSectionCode== gsCode select gs).FirstOrDefault(); if (gsInDB == null) { throw new Exception("No Grade Section with Grade Section Code " + gsBDO.GradeSectionCode); } DCEnt.GradeSections.Remove(gsInDB); gsInDB.Deactivated = gsBDO.Deactivated; gsInDB.GradeLevel = gsBDO.GradeLevel; gsInDB.GradeSectionCode = gsBDO.GradeSectionCode; gsInDB.HomeRoomNumber = gsBDO.HomeRoomNumber; gsInDB.HomeRoomTeacherId = gsBDO.HomeRoomTeacherId; gsInDB.Section = gsBDO.Section; gsInDB.SY = gsBDO.SY; DCEnt.GradeSections.Attach(gsInDB); DCEnt.Entry(gsInDB).State = System.Data.Entity.EntityState.Modified; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "No grade section is updated."; } } return ret; }