public int SaveMeetingRoom(Model.MeetingRoom meetingRoom)
{
DataAccess.Mapping.MeetingRoom mr = null;
bool find = false;
if (meetingRoom.MeetingRoomID == -1)
{
mr = new Mapping.MeetingRoom();
dc.MeetingRoom.InsertOnSubmit(mr);
find = true;
}
else
{
mr = (from meeting in dc.MeetingRoom
where meeting.MeetingRoomID == meetingRoom.MeetingRoomID
select meeting).FirstOrDefault();
if (mr != null)
{
find = true;
mr.MeetingRoomID = meetingRoom.MeetingRoomID;
}
}
if (find)
{
mr.MeetingRoomCapacity = meetingRoom.MeetingRoomCapacity;
mr.MeetingRoomName = meetingRoom.MeetingRoomName;
mr.MeetingRoomStatus = meetingRoom.MeetingRoomStatus;
mr.MeetingTypeID = meetingRoom.MeetingTypeID;
try
{
dc.SubmitChanges();
}
catch (ChangeConflictException)
{
dc.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
dc.SubmitChanges();
}
return(mr.MeetingRoomID);
}
else
{
return(-1);
}
}
public int SaveMeetingRoom(Model.MeetingRoom meetingRoom)
{
DataAccess.Mapping.MeetingRoom mr = null;
bool find = false;
if (meetingRoom.MeetingRoomID == -1)
{
mr = new Mapping.MeetingRoom();
dc.MeetingRoom.InsertOnSubmit(mr);
find = true;
}
else
{
mr = (from meeting in dc.MeetingRoom
where meeting.MeetingRoomID == meetingRoom.MeetingRoomID
select meeting).FirstOrDefault();
if (mr != null)
{
find = true;
mr.MeetingRoomID = meetingRoom.MeetingRoomID;
}
}
if (find)
{
mr.MeetingRoomCapacity = meetingRoom.MeetingRoomCapacity;
mr.MeetingRoomName = meetingRoom.MeetingRoomName;
mr.MeetingRoomStatus = meetingRoom.MeetingRoomStatus;
mr.MeetingTypeID = meetingRoom.MeetingTypeID;
try
{
dc.SubmitChanges();
}
catch (ChangeConflictException)
{
dc.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
dc.SubmitChanges();
}
return mr.MeetingRoomID;
}
else
{
return -1;
}
}