public int CreateRoom(RoomModel rm)
{
int result = DaoUtilities.NO_CHANGES;
ROOM r = db.ROOM.Create();
r.ROOM_ID = rm.RoomId;
r.ROOM_NAME = rm.Name;
r.ROOM_SUPERFICY = rm.Superficy;
r.ROOM_MAXNBR = rm.MaxNb;
db.ROOM.Add(r);
try
{
int saveResult = db.SaveChanges();
if (saveResult == 1)
result = DaoUtilities.SAVE_SUCCESSFUL;
}
catch (DbUpdateConcurrencyException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.UPDATE_CONCURRENCY_EXCEPTION;
}
catch (DbUpdateException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.UPDATE_EXCEPTION;
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.ENTITY_VALIDATION_EXCEPTION;
}
catch (NotSupportedException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.UNSUPPORTED_EXCEPTION;
}
catch (ObjectDisposedException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.DISPOSED_EXCEPTION;
}
catch (InvalidOperationException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.INVALID_OPERATION_EXCEPTION;
}
return result;
}
/// <summary>
/// Convert a room from the database to a RoomModel
/// </summary>
/// <param name="r"></param>
/// <returns></returns>
public RoomModel ConvertRoomToRoomModel(ROOM r)
{
RoomModel rm = new RoomModel();
if (r != null)
{
rm.RoomId = r.ROOM_ID;
rm.Name = r.ROOM_NAME;
rm.Superficy = r.ROOM_SUPERFICY;
rm.MaxNb = r.ROOM_MAXNBR;
}
else
rm = null;
return rm;
}
public int DeleteRoom(RoomModel rm)
{
int result = DaoUtilities.NO_CHANGES;
ROOM r = db.ROOM.Find(rm.RoomId);
if (r != null)
{
db.ROOM.Remove(r);
try
{
int saveResult = db.SaveChanges();
if (saveResult == 1)
result = DaoUtilities.SAVE_SUCCESSFUL;
}
catch (DbUpdateConcurrencyException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.UPDATE_CONCURRENCY_EXCEPTION;
}
catch (DbUpdateException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.UPDATE_EXCEPTION;
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.ENTITY_VALIDATION_EXCEPTION;
}
catch (NotSupportedException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.UNSUPPORTED_EXCEPTION;
}
catch (ObjectDisposedException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.DISPOSED_EXCEPTION;
}
catch (InvalidOperationException e)
{
Console.WriteLine(e.GetBaseException().ToString());
result = DaoUtilities.INVALID_OPERATION_EXCEPTION;
}
}
return result;
}