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);
}
