public override object Get <T>(T entity)
{
List <BO.Room> lstRoom = new List <BO.Room>();
BO.Room roomBO = (BO.Room)(object) entity;
if (roomBO != null)
{
if (roomBO.roomTest != null)
{
if (roomBO.roomTest.ID > 0)
{
var acc_ = _context.Rooms.Include("RoomTest").Include("Location").Include("Schedule").Where(p => (p.IsDeleted == false || p.IsDeleted == null) && p.RoomTestID == roomBO.roomTest.ID && (p.Location.IsDeleted == false || p.Location.IsDeleted == null)).ToList <Room>();
if (acc_ == null || acc_.Count < 1)
{
return(new BO.ErrorObject {
ErrorMessage = "No records found.", errorObject = "", ErrorLevel = ErrorLevel.Error
});
}
foreach (Room item in acc_)
{
lstRoom.Add(Convert <BO.Room, Room>(item));
}
}
}
else if (roomBO.location != null)
{
if (roomBO.location.ID > 0)
{
var acc_ = _context.Rooms.Include("RoomTest").Include("Location").Where(p => (p.IsDeleted == false || p.IsDeleted == null) && p.LocationID == roomBO.location.ID && (p.Location.IsDeleted == false || p.Location.IsDeleted == null)).ToList <Room>();
if (acc_ == null || acc_.Count < 1)
{
return(new BO.ErrorObject {
ErrorMessage = "No records found.", errorObject = "", ErrorLevel = ErrorLevel.Error
});
}
foreach (Room item in acc_)
{
lstRoom.Add(Convert <BO.Room, Room>(item));
}
}
}
}
else
{
var acc_ = _context.Rooms.Include("RoomTest").Include("Location").Where(p => (p.IsDeleted == false || p.IsDeleted == null) && (p.Location.IsDeleted == false || p.Location.IsDeleted == null)).ToList <Room>();
if (acc_ == null || acc_.Count < 1)
{
return(new BO.ErrorObject {
ErrorMessage = "No records found.", errorObject = "", ErrorLevel = ErrorLevel.Error
});
}
foreach (Room item in acc_)
{
lstRoom.Add(Convert <BO.Room, Room>(item));
}
}
return(lstRoom);
}
public override T ObjectConvert <T, U>(U entity)
{
Room room = entity as Room;
if (room == null)
{
return(default(T));
}
BO.Room roomBO = new BO.Room();
roomBO.ID = room.id;
roomBO.name = room.Name;
roomBO.contactersonName = room.ContactPersonName;
roomBO.phone = room.Phone;
if (room.IsDeleted.HasValue)
{
roomBO.IsDeleted = room.IsDeleted.Value;
}
if (room.UpdateByUserID.HasValue)
{
roomBO.UpdateByUserID = room.UpdateByUserID.Value;
}
return((T)(object)roomBO);
}
public override List <MIDAS.GBX.BusinessObjects.BusinessValidation> Validate <T>(T entity)
{
BO.Room room = (BO.Room)(object) entity;
var result = room.Validate(room);
return(result);
}
public override T Convert <T, U>(U entity)
{
Room room = entity as Room;
if (room == null)
{
return(default(T));
}
BO.Room roomBO = new BO.Room();
roomBO.ID = room.id;
roomBO.name = room.Name;
roomBO.contactersonName = room.ContactPersonName;
roomBO.phone = room.Phone;
if (room.IsDeleted.HasValue)
{
roomBO.IsDeleted = room.IsDeleted.Value;
}
if (room.UpdateByUserID.HasValue)
{
roomBO.UpdateByUserID = room.UpdateByUserID.Value;
}
if (room.RoomTest != null)
{
BO.RoomTest roomtestBO = new BO.RoomTest();
roomtestBO.name = room.RoomTest.Name;
roomtestBO.ID = room.RoomTest.id;
roomtestBO.ColorCode = room.RoomTest.ColorCode;
if (room.RoomTest.IsDeleted.HasValue)
{
roomtestBO.IsDeleted = room.RoomTest.IsDeleted.Value;
}
if (room.RoomTest.UpdateByUserID.HasValue)
{
roomtestBO.UpdateByUserID = room.RoomTest.UpdateByUserID.Value;
}
roomBO.roomTest = roomtestBO;
}
BO.Location boLocation = new BO.Location();
using (LocationRepository sr = new LocationRepository(_context))
{
boLocation = sr.Convert <BO.Location, Location>(room.Location);
roomBO.location = boLocation;
}
BO.Schedule boSchedule = new BO.Schedule();
using (ScheduleRepository cmp = new ScheduleRepository(_context))
{
boSchedule = cmp.Convert <BO.Schedule, Schedule>(room.Schedule);
// cmp.Save(boSchedule);
roomBO.schedule = boSchedule;
}
return((T)(object)roomBO);
}
public override object Get(int id)
{
BO.Room acc_ = Convert <BO.Room, Room>(_context.Rooms.Include("RoomTest").Include("Location").Include("Schedule").Where(p => p.id == id && (p.IsDeleted == false || p.IsDeleted == null)).FirstOrDefault <Room>());
if (acc_ == null)
{
return(new BO.ErrorObject {
ErrorMessage = "No record found for this room.", errorObject = "", ErrorLevel = ErrorLevel.Error
});
}
return((object)acc_);
}
public override object Delete <T>(T entity)
{
BO.Room roomBO = entity as BO.Room;
Room roomDB = new Room();
roomDB.id = roomBO.ID;
_dbSet.Remove(_context.Rooms.Single <Room>(p => p.id == roomBO.ID));
_context.SaveChanges();
var res = (BO.GbObject)(object) entity;
return(roomDB);
}
public override object Save <T>(T entity)
{
BO.Room roomBO = (BO.Room)(object) entity;
Room roomDB = new Room();
RoomTest roomtestDB = new RoomTest();
#region room
roomDB.id = roomBO.ID;
roomDB.Name = roomBO.name;
roomDB.ContactPersonName = roomBO.contactersonName;
roomDB.Phone = roomBO.phone;
roomDB.IsDeleted = roomBO.IsDeleted.HasValue ? roomBO.IsDeleted : false;
#endregion
#region Room Test
roomtestDB.id = roomBO.roomTest.ID;
//roomtestDB.Name = roomBO.roomTest.name;
//roomtestDB.IsDeleted = roomBO.roomTest.IsDeleted.HasValue ? roomBO.roomTest.IsDeleted : false;
#endregion
if (roomBO.roomTest.ID > 0)
{
RoomTest roomtest = _context.RoomTests.Where(p => p.id == roomBO.roomTest.ID && (p.IsDeleted == false || p.IsDeleted == null)).FirstOrDefault <RoomTest>();
if (roomtest != null)
{
_context.Entry(roomtest).State = System.Data.Entity.EntityState.Modified;
roomtestDB = roomtest;
}
else
{
return new BO.ErrorObject {
errorObject = "", ErrorMessage = "Please pass valid roomtest detail.", ErrorLevel = ErrorLevel.Error
}
};
}
if (roomBO.location.ID > 0)
{
Location location = _context.Locations.Where(p => p.id == roomBO.location.ID && (p.IsDeleted == false || p.IsDeleted == null)).FirstOrDefault <Location>();
if (location != null)
{
_context.Entry(location).State = System.Data.Entity.EntityState.Modified;
roomDB.Location = location;
}
else
{
return new BO.ErrorObject {
errorObject = "", ErrorMessage = "Please pass valid location detail.", ErrorLevel = ErrorLevel.Error
}
};
}
roomDB.RoomTest = roomtestDB;
if (roomBO.schedule != null)
{
#region Schedule
if (roomBO.schedule != null)
{
if (roomBO.schedule.ID > 0)
{
Schedule schedule = _context.Schedules.Where(p => p.id == roomBO.schedule.ID).FirstOrDefault <Schedule>();
if (schedule != null)
{
roomDB.Schedule = schedule;
}
else
{
return new BO.ErrorObject {
errorObject = "", ErrorMessage = "Please pass valid Schedule.", ErrorLevel = ErrorLevel.Error
}
};
}
}
#endregion
}
else
{
//Default schedule
Schedule defaultschedule = _context.Schedules.Where(p => p.IsDefault == true).FirstOrDefault <Schedule>();
if (defaultschedule != null)
{
roomDB.Schedule = defaultschedule;
}
else
{
return new BO.ErrorObject {
errorObject = "", ErrorMessage = "Please set default schedule in database.", ErrorLevel = ErrorLevel.Error
}
};
}
if (roomDB.id > 0)
{
if (_context.Rooms.Any(o => o.Name == roomBO.name && o.LocationID == roomBO.location.ID && o.id != roomDB.id && (o.IsDeleted == false || o.IsDeleted == null)))
{
return(new BO.ErrorObject {
ErrorMessage = "Room already exists for selected location and test.", errorObject = "", ErrorLevel = ErrorLevel.Error
});
}
//For Update Record
//Find Room By ID
Room room = _context.Rooms.Where(p => p.id == roomDB.id && (p.IsDeleted == false || p.IsDeleted == null)).FirstOrDefault <Room>();
if (room != null)
{
#region Location
room.id = roomBO.ID;
room.Name = roomBO.name == null ? room.Name : roomBO.name;
room.ContactPersonName = roomBO.contactersonName == null ? room.ContactPersonName : roomBO.contactersonName;
room.Phone = roomBO.phone == null ? room.Phone : roomBO.phone;
room.IsDeleted = roomBO.IsDeleted.HasValue ? roomBO.IsDeleted : room.IsDeleted;
room.UpdateDate = roomBO.UpdateDate;
room.UpdateByUserID = roomBO.UpdateByUserID;
#endregion
#region RoomTest
if (roomBO.roomTest != null)
{
if (roomBO.roomTest.ID > 0)
{
RoomTest roomtest = _context.RoomTests.Where(p => p.id == roomBO.roomTest.ID).FirstOrDefault <RoomTest>();
if (roomtest != null)
{
room.RoomTest = roomtest;
}
else
{
return new BO.ErrorObject {
errorObject = "", ErrorMessage = "Please pass valid roomtest detail.", ErrorLevel = ErrorLevel.Error
}
};
}
}
#endregion
if (roomBO.location.ID > 0)
{
Location location = _context.Locations.Where(p => p.id == roomBO.location.ID && (p.IsDeleted == false || p.IsDeleted == null)).FirstOrDefault <Location>();
if (location != null)
{
_context.Entry(location).State = System.Data.Entity.EntityState.Modified;
room.Location = location;
}
else
{
return new BO.ErrorObject {
errorObject = "", ErrorMessage = "Please pass valid location detail.", ErrorLevel = ErrorLevel.Error
}
};
}
#region Schedule
if (roomBO.schedule != null)
{
if (roomBO.schedule.ID > 0)
{
Schedule schedule = _context.Schedules.Where(p => p.id == roomBO.schedule.ID).FirstOrDefault <Schedule>();
if (schedule != null)
{
room.Schedule = schedule;
}
else
{
return new BO.ErrorObject {
errorObject = "", ErrorMessage = "Please pass valid Schedule.", ErrorLevel = ErrorLevel.Error
}
};
}
}
#endregion
_context.Entry(room).State = System.Data.Entity.EntityState.Modified;
}
else
{
return new BO.ErrorObject {
errorObject = "", ErrorMessage = "Please pass valid room details.", ErrorLevel = ErrorLevel.Error
}
};
}
else
{
if (_context.Rooms.Any(o => o.Name == roomBO.name && o.LocationID == roomBO.location.ID && (o.IsDeleted.HasValue == false || (o.IsDeleted.HasValue == true && o.IsDeleted.Value == false))))
{
return(new BO.ErrorObject {
ErrorMessage = "Room already exists for selected location and test.", errorObject = "", ErrorLevel = ErrorLevel.Error
});
}
roomDB.CreateDate = roomBO.CreateDate;
roomDB.CreateByUserID = roomBO.CreateByUserID;
_dbSet.Add(roomDB);
}
_context.SaveChanges();
var res = Convert <BO.Room, Room>(roomDB);
return((object)res);
}