public TreatmentRoomBO ConvertTrmtRmRecToBO(TreatmentRoom_Record treatmentRoom)
{
TreatmentRoomBO treatmentRoomBO = new TreatmentRoomBO(treatmentRoom.Room_ID, Convert.ToString(treatmentRoom.Timings),
treatmentRoom.DateOfJoin, treatmentRoom.IsBooked, treatmentRoom.Patient_ID);
return(treatmentRoomBO);
}
public TreatmentRoom_Record ConvertBOToTreatmentRoomRec(TreatmentRoom_Record treatmentRoom, TreatmentRoomBO treatmentRoomBO)
{
if (treatmentRoomBO.room_ID != null)
{
treatmentRoom.Room_ID = treatmentRoomBO.room_ID;
}
if (!string.IsNullOrEmpty(treatmentRoomBO.timings))
{
treatmentRoom.Timings = TimeSpan.Parse(treatmentRoomBO.timings);
}
if (treatmentRoomBO.date != DateTime.MinValue)
{
treatmentRoom.DateOfJoin = treatmentRoomBO.date;
}
if (treatmentRoomBO.patient_ID != 0)
{
treatmentRoom.Patient_ID = treatmentRoomBO.patient_ID;
}
if (treatmentRoomBO.appointment_ID != 0)
{
treatmentRoom.Appointment_ID = treatmentRoomBO.appointment_ID;
}
treatmentRoom.IsBooked = treatmentRoomBO.isBooked;
return(treatmentRoom);
}
public IEnumerable <TreatmentRoomBO> UpdateTreatmentRoomRecord(TreatmentRoom_Record treatmentRoomRec)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
var treatmentRmRec = objHmsDataContext.TreatmentRoom_Records.Where(trmntRooms => (trmntRooms.Room_ID == treatmentRoomRec.Room_ID && trmntRooms.Appointment_ID == treatmentRoomRec.Appointment_ID)).FirstOrDefault();
treatmentRmRec.IsBooked = treatmentRoomRec.IsBooked;
objHmsDataContext.SubmitChanges();
return(GetAllTreatmentRooms());
}
}
catch (Exception e)
{
IEnumerable <TreatmentRoomBO> room = null;
return(room);
}
}
public TreatmentRoomBO InsertTreatmentRoomRec(TreatmentRoomBO treatmentRoomBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
TreatmentRoom_Record trmntRoom = new TreatmentRoom_Record();
objHmsDataContext.TreatmentRoom_Records.InsertOnSubmit(ConvertBOToTreatmentRoomRec(trmntRoom, treatmentRoomBO));
objHmsDataContext.SubmitChanges();
TreatmentRoom_Record newtrmntRoom = objHmsDataContext.TreatmentRoom_Records.SingleOrDefault(trmntroom => (trmntroom.Room_ID == treatmentRoomBO.room_ID && trmntroom.DateOfJoin == treatmentRoomBO.date));
return(ConvertTrmtRmRecToBO(newtrmntRoom));
}
}
catch (Exception e)
{
TreatmentRoomBO treatmentRoom_BO = new TreatmentRoomBO();
return(treatmentRoom_BO);
}
}
//Method to update TreatmentRoom details, with string as return type and treatment business object as parameter
public IEnumerable <TreatmentRoomBO> UpdateTreatmentRoom(TreatmentRoomBO treatmentRoomBO)
{
try
{
using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString))
{
if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed)
{
objHmsDataContext.Connection.Open();
}
Treatment_Room treatmentRoom = objHmsDataContext.Treatment_Rooms.Where(trmntRooms => (trmntRooms.Room_ID == treatmentRoomBO.room_ID && trmntRooms.Appointment_ID == treatmentRoomBO.appointment_ID)).FirstOrDefault();
if (treatmentRoom != null)
{
Treatment_Room updateTrmntRoom = ConvertBOToTreatmentRoom(treatmentRoom, treatmentRoomBO);
}
objHmsDataContext.SubmitChanges();
TreatmentRoom_Record tr = new TreatmentRoom_Record();
tr.Appointment_ID = treatmentRoomBO.appointment_ID;
tr.DateOfJoin = treatmentRoomBO.date;
tr.Patient_ID = treatmentRoomBO.patient_ID;
tr.Room_ID = treatmentRoomBO.room_ID;
//tr.Timings = treatmentRoomBO.timings;
if (treatmentRoomBO.isBooked != false)
{
tr.IsBooked = true;
}
else
{
tr.IsBooked = false;
}
//objHmsDataContext.TreatmentRoom_Records.InsertOnSubmit(tr);
objHmsDataContext.SubmitChanges();
UpdateTreatmentRoomRecord(tr);
return(GetAllTreatmentRooms());
}
}
catch (Exception e)
{
IEnumerable <TreatmentRoomBO> room = null;
return(room);
}
}
