public Boolean CreateRoom(ref RoomBDO roomBDO, ref string message)
{
Boolean ret = false;
ret = rDAO.CreateRoom(ref roomBDO, ref message);
return(ret);
}
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 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 Boolean UpdateRoom(ref Room room, ref string message)
{
RoomBDO roomBDO = new RoomBDO();
TranslateRoomDTOtoRoomBDO(room, roomBDO);
return(rLogic.UpdateRoom(ref roomBDO, ref message));
}
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;
}
private 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;
}
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 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 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 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 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 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 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);
}
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;
rBDOList.Add(rbdo);
}
return(rBDOList);
}
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 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 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 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);
}
