public List<RoomBDO> GetAllRooms() { List<Room> roomList = new List<Room>(); List<RoomBDO> roomBDOList = new List<RoomBDO>(); try { using (var DCEnt = new DCFIEntities()) { var allRooms = (DCEnt.Rooms); roomList = allRooms.ToList<Room>(); } foreach (Room r in roomList) { RoomBDO roomBDO = new RoomBDO(); ConvertRoomToRoomBDO(r, roomBDO); roomBDOList.Add(roomBDO); } } 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 roomBDOList; }
public void ConvertGradeSectionToGradeSectionBDO(GradeSection gs, GradeSectionBDO gsBDO) { RoomDAO r = new RoomDAO(); RoomBDO room = new RoomBDO(); TeacherDAO t = new TeacherDAO(); TeacherBDO teach = new TeacherBDO(); SchoolYearDAO s = new SchoolYearDAO(); SchoolYearBDO sy = new SchoolYearBDO(); s.ConvertSYToSYBDO(gs.SchoolYear, sy); t.ConvertTeacherToTeacherBDO(gs.Teacher, teach); r.ConvertRoomToRoomBDO(gs.Room, room); gsBDO.Deactivated = gs.Deactivated; gsBDO.GradeLevel = gs.GradeLevel; gsBDO.GradeSectionCode = gs.GradeSectionCode; gsBDO.HomeRoomNumber = (int)gs.HomeRoomNumber; gsBDO.HomeRoomTeacherId = gs.HomeRoomTeacherId; gsBDO.Section = gs.Section; gsBDO.SY = gs.SY; gsBDO.Class = gs.Class; gsBDO.HomeRoom = room; gsBDO.HomeRoomTeacher = teach; gsBDO.SchoolYear = sy; }
public void ConvertSubjectAssignmentToSubjectAssignmentBDO(SubjectAssignment sa, SubjectAssignmentBDO sabdo) { sabdo.Deactivated = (bool)sa.Deactivated; GradeSectionDAO gd = new GradeSectionDAO(); GradeSectionBDO g = new GradeSectionBDO(); g = gd.GetGradeSectionBDO((int)sa.GradeSectionCode); sabdo.GradeSection = g; sabdo.GradeSectionCode = g.GradeSectionCode; RoomBDO r = new RoomBDO(); RoomDAO rd = new RoomDAO(); rd.ConvertRoomToRoomBDO(sa.Room, r); sabdo.Room = r; sabdo.RoomId = r.RoomId; SubjectDAO sd = new SubjectDAO(); SubjectBDO sb = new SubjectBDO(); sd.ConvertSubjectToSubjectBDO(sa.Subject, sb); sabdo.Subject = sb; sabdo.SubjectAssignmentsID = sa.SubjectAssignmentsID; sabdo.SubjectCode = sa.SubjectCode; sabdo.SY = sa.SY; TeacherDAO td = new TeacherDAO(); TeacherBDO tb = new TeacherBDO(); td.ConvertTeacherToTeacherBDO(sa.Teacher, tb); sabdo.Teacher = tb; sabdo.TeacherId = tb.TeacherId; TimeslotDAO tid = new TimeslotDAO(); TimeslotBDO tib = new TimeslotBDO(); tid.ConvertTimeslotToTimeslotBDO(sa.Timeslot, tib); sabdo.Timeslot = tib; sabdo.TimeSlotCode = tib.TimeSlotCode; sabdo.GradeLevel = g.GradeLevel; }
public RoomBDO GetRoom(string roomCode) { Room room = null; RoomBDO roomBDO = new RoomBDO(); try { using (var DCEnt = new DCFIEntities()) { room = (from r in DCEnt.Rooms where r.RoomCode == roomCode select r).FirstOrDefault(); } ConvertRoomToRoomBDO(room,roomBDO); } 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 roomBDO; }
public void TranslateRoomDTOtoRoomBDO(Room room, RoomBDO rBDO) { rBDO.BuildingCode = room.BuildingCode; rBDO.Capacity = room.Capacity; rBDO.Deactivated = room.Deactivated; rBDO.Description = room.Description; rBDO.RoomCode = room.RoomCode; rBDO.RoomNumber = room.RoomNumber; rBDO.RoomId = room.RoomId; }
public void TranslateRoomtoRoomBDO(Room room, RoomBDO r) { r.BuildingCode = room.BuildingCode; r.Capacity = room.Capacity; r.Deactivated = room.Deactivated; r.Description = room.Description; r.RoomCode = room.RoomCode; r.RoomNumber = room.RoomNumber; }
public Boolean UpdateRoom(ref RoomBDO roomBDO, ref string message) { if (RoomExists(roomBDO.RoomCode)) return rDAO.UpdateRoom(ref roomBDO, ref message); else { message = "Cannot get room for this Code"; return false; } }
public void ConvertRoomBDOToRoom(RoomBDO r, Room room) { room.BuildingCode = r.BuildingCode; room.Capacity = r.Capacity; room.Deactivated = r.Deactivated; room.Description = r.Description; room.RoomCode = r.RoomCode; room.RoomNumber = r.RoomNumber; room.RoomId = r.RoomId; }
public void ConvertRoomToRoomBDO(Room r, RoomBDO roomBDO) { roomBDO.BuildingCode = r.BuildingCode; roomBDO.Capacity =(int)r.Capacity; roomBDO.Deactivated = r.Deactivated; roomBDO.Description = r.Description; roomBDO.RoomCode = r.RoomCode; roomBDO.RoomNumber = r.RoomNumber; roomBDO.RoomId = r.RoomId; }
public List<RoomBDO> ToRoomBDOList(List<Room> rbdo) { List<RoomBDO> rooms = new List<RoomBDO>(); foreach (Room rb in rbdo) { RoomBDO r = new RoomBDO(); TranslateRoomtoRoomBDO(rb, r); rooms.Add(r); } return rooms; }
public RoomBDO GetRoom(string roomCode) { Room room = null; using (var DCEnt = new DCFIEntities()) { room = (from r in DCEnt.Rooms where r.RoomCode == roomCode select r).FirstOrDefault(); } RoomBDO roomBDO = new RoomBDO(); ConvertRoomToRoomBDO(room,roomBDO); return roomBDO; }
public List<RoomBDO> GetAllRooms() { List<Room> roomList = new List<Room>(); using (var DCEnt = new DCFIEntities()) { var allRooms = (DCEnt.Rooms); roomList = allRooms.ToList<Room>(); } List<RoomBDO> roomBDOList = new List<RoomBDO>(); foreach (Room r in roomList) { RoomBDO roomBDO = new RoomBDO(); ConvertRoomToRoomBDO(r, roomBDO); roomBDOList.Add(roomBDO); } return roomBDOList; }
public List<RoomBDO> GetAllRoomsForBuilding(string buildingCode) { List<Room> rooms = null; List<RoomBDO> rbdoList = new List<RoomBDO>(); using (var DCEnt = new DCFIEntities()) { rooms = (from r in DCEnt.Rooms where r.BuildingCode== buildingCode select r).ToList<Room>(); } foreach (Room r in rooms) { RoomBDO roomBDO = new RoomBDO(); ConvertRoomToRoomBDO(r, roomBDO); rbdoList.Add(roomBDO); } return rbdoList; }
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 UpdateRoom(ref RoomBDO roomBDO, ref string message) { message = "Room updated successfully."; Boolean ret = true; 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."; } } return ret; }
public Boolean CreateRoom(ref RoomBDO roomBDO, ref string message) { message = "Room Added Successfully"; bool ret = true; Room room = new Room(); try { 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"; } } } 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; }
private List<RoomBDO> ToRoomBDOList(ICollection<Room> rooms) { List<RoomBDO> rBDOList = new List<RoomBDO>(); foreach (Room r in rooms) { RoomBDO rbdo = new RoomBDO(); rbdo.BuildingCode = r.BuildingCode; rbdo.Capacity = (int)r.Capacity; rbdo.Deactivated = r.Deactivated; rbdo.Description = r.Description; rbdo.RoomCode = r.RoomCode; rbdo.RoomNumber = r.RoomNumber; rbdo.RoomId = r.RoomId; rBDOList.Add(rbdo); } return rBDOList; }
public List<RoomBDO> GetAllRoomsForBuilding(string buildingCode) { List<Room> rooms = null; List<RoomBDO> rbdoList = new List<RoomBDO>(); try { using (var DCEnt = new DCFIEntities()) { rooms = (from r in DCEnt.Rooms where r.BuildingCode== buildingCode select r).ToList<Room>(); foreach (Room r in rooms) { RoomBDO roomBDO = new RoomBDO(); ConvertRoomToRoomBDO(r, roomBDO); rbdoList.Add(roomBDO); } } } 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 rbdoList; }
public Boolean CreateRoom(ref RoomBDO roomBDO, ref string message) { Boolean ret = false; ret = rDAO.CreateRoom(ref roomBDO, ref message); 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 UpdateRoom(ref Room room, ref string message) { RoomBDO roomBDO = new RoomBDO(); TranslateRoomDTOtoRoomBDO(room, roomBDO); return rLogic.UpdateRoom(ref roomBDO, ref message); }