public AppointmentReturnValue GetAppointmentDetails(Guid logonId, Int32 appointmentId)
{
AppointmentReturnValue returnValue = new AppointmentReturnValue();
try
{
// Get the logged on user from the current logons and add their
// ApplicationSettings the list of concurrent sessions.
Host.LoadLoggedOnUser(logonId);
try
{
Functions.RestrictRekoopIntegrationUser(UserInformation.Instance.DbUid);
switch (UserInformation.Instance.UserType)
{
case DataConstants.UserType.Staff:
// Can do everything
break;
case DataConstants.UserType.Client:
case DataConstants.UserType.ThirdParty:
throw new Exception("Access denied");
default:
throw new Exception("Access denied");
}
string attendeesNames = string.Empty;
string attendeesIds = string.Empty;
Appointment appointmentDetails = new Appointment();
SrvBookingEntry bookingEntryData = new SrvBookingEntry();
bookingEntryData.OccurrenceData.Id = appointmentId;
bookingEntryData.Load(bookingEntryData.OccurrenceData.Id);
this.GetBookingMembers(bookingEntryData.OccurrenceData.Id, ref attendeesNames, ref attendeesIds);
appointmentDetails.AttendeesName = attendeesNames;
appointmentDetails.Attendees = attendeesIds;
if (bookingEntryData.OccurrenceData.Id != 0)
{
appointmentDetails.Id = bookingEntryData.OccurrenceData.Id;
appointmentDetails.VenueId = bookingEntryData.OccurrenceData.VenueId;
DsServiceSearch dsServiceSearch = SrvServiceLookup.ServiceSearch(bookingEntryData.OccurrenceData.VenueId);
if (dsServiceSearch.uvw_ServicesSearch.Count > 0)
{
appointmentDetails.VenueText = dsServiceSearch.uvw_ServicesSearch[0].OrgName + " - " + dsServiceSearch.uvw_ServicesSearch[0].IndustryName;
}
else
{
appointmentDetails.VenueText = "Not Set";
}
DsMattersForBooking.MatterForBookingDataTable dsMattersForBooking = bookingEntryData.DsBookingsMatters.MatterForBooking;
if (dsMattersForBooking.Rows.Count > 0)
{
appointmentDetails.ProjectId = new Guid(dsMattersForBooking[0].ProjectId.ToString());
}
else
{
appointmentDetails.ProjectId = DataConstants.DummyGuid;
}
appointmentDetails.StartTime = bookingEntryData.OccurrenceData.StartTime;
appointmentDetails.EndTime = bookingEntryData.OccurrenceData.EndTime;
appointmentDetails.StartDate = bookingEntryData.OccurrenceData.StartDate;
appointmentDetails.Subject = bookingEntryData.OccurrenceData.Text;
appointmentDetails.Notes = bookingEntryData.OccurrenceData.OccurrenceNotes;
if (bookingEntryData.OccurrenceData.ReminderDate != Convert.ToDateTime("01/01/1753"))
{
appointmentDetails.IsReminderSet = true;
if (bookingEntryData.OccurrenceData.ReminderMinutesBefore == 0)
{
appointmentDetails.ReminderType = "On";
}
else
{
appointmentDetails.ReminderType = "Before";
}
appointmentDetails.ReminderBeforeTime = bookingEntryData.OccurrenceData.ReminderMinutesBefore.ToString();
appointmentDetails.ReminderDate = bookingEntryData.OccurrenceData.ReminderDate;
appointmentDetails.ReminderTime = bookingEntryData.OccurrenceData.ReminderTime;
}
else
{
appointmentDetails.IsReminderSet = false;
appointmentDetails.ReminderType = "On";
appointmentDetails.ReminderBeforeTime = "15 minutes";
appointmentDetails.ReminderTime = "";
}
}
returnValue.Appointment = appointmentDetails;
}
finally
{
// Remove the logged on user's ApplicationSettings from the
// list of concurrent sessions
Host.UnloadLoggedOnUser();
}
}
catch (System.Data.SqlClient.SqlException)
{
returnValue.Success = false;
returnValue.Message = Functions.SQLErrorMessage;
}
catch (Exception Ex)
{
returnValue.Success = false;
returnValue.Message = Ex.Message;
}
return returnValue;
}
public AppointmentReturnValue GetAppointmentDetails(HostSecurityToken oHostSecurityToken, Int32 appointmentId)
{
AppointmentReturnValue returnValue = null;
if (Functions.ValidateIWSToken(oHostSecurityToken))
{
oDiaryService = new DiaryService();
returnValue = oDiaryService.GetAppointmentDetails(Functions.GetLogonIdFromToken(oHostSecurityToken), appointmentId);
}
else
{
returnValue = new AppointmentReturnValue();
returnValue.Success = false;
returnValue.Message = "Invalid Token";
}
return returnValue;
}
public AppointmentReturnValue SaveAppointment(Guid logonId, Appointment appointmentDetails)
{
AppointmentReturnValue returnValue = new AppointmentReturnValue();
try
{
// Get the logged on user from the current logons and add their
// ApplicationSettings the list of concurrent sessions.
Host.LoadLoggedOnUser(logonId);
try
{
Functions.RestrictRekoopIntegrationUser(UserInformation.Instance.DbUid);
switch (UserInformation.Instance.UserType)
{
case DataConstants.UserType.Staff:
// Can add/edit subject to permissions
break;
case DataConstants.UserType.Client:
case DataConstants.UserType.ThirdParty:
throw new Exception("Access denied");
default:
throw new Exception("Access denied");
}
SrvBookingEntry bookingEntryData = new SrvBookingEntry();
bookingEntryData.OccurrenceData.Id = appointmentDetails.Id;
bookingEntryData.Load(bookingEntryData.OccurrenceData.Id);
if (bookingEntryData.OccurrenceData.Id != 0)
{
bookingEntryData.ActionEditMode = ActionEditMode.Amend;
}
// Ensure we have permission
if (bookingEntryData.ActionEditMode == ActionEditMode.Create)
{
// Create new bookings
if (!UserSecuritySettings.GetUserSecuitySettings(100))
throw new Exception("You do not have sufficient permissions to carry out this request");
}
else
{
// Edit existing bookings
if (!UserSecuritySettings.GetUserSecuitySettings(102))
throw new Exception("You do not have sufficient permissions to carry out this request");
}
DiaryViewMembersDts diaryViewMembers = this.GetDiaryViewMembersDts(appointmentDetails.Attendees);
this.SetBookingMembersData(diaryViewMembers, ref bookingEntryData);
if (bookingEntryData.ActionEditMode == ActionEditMode.Create)
{
// Add the first attendee as the organiser
bookingEntryData.OrganiserId = new Guid(diaryViewMembers.DiaryViewMembers[0].MemberID);
}
#region Add Matter to Appointment
// Adding Matter to the Appointment
Guid oldProjectId = DataConstants.DummyGuid;
if (bookingEntryData.OccurrenceData.Id != 0)
{
DsMattersForBooking.MatterForBookingDataTable dsMattersForBooking = bookingEntryData.DsBookingsMatters.MatterForBooking;
if (bookingEntryData.DsBookingsMatters.MatterForBooking.Rows.Count > 0)
{
if (appointmentDetails.ProjectId != null)
{
oldProjectId = new Guid(dsMattersForBooking[0].ProjectId.ToString());
// If New Matter is same as that of the Old Matter, then don't add any new matters
if (oldProjectId != appointmentDetails.ProjectId)
{
// Check if old matter been replaced by new matter is already present in the list or not
// If New Matter is been replaced, then remove Old Matter
// If New Matter been added is already present in the list of existing matters, then throw error
if (!(bookingEntryData.DsBookingsMatters.MatterForBooking.Select(string.Format("ProjectId = '{0}'", appointmentDetails.ProjectId.ToString())).Length > 0))
{
// Remove Old Matter
if (bookingEntryData.DsBookingsMatters.MatterForBooking.FindByProjectId(oldProjectId.ToString()) != null)
{
bookingEntryData.DsBookingsMatters.MatterForBooking.RemoveMatterForBookingRow(bookingEntryData.DsBookingsMatters.MatterForBooking.FindByProjectId(oldProjectId.ToString()));
Collection<SrvBookingMatter> bookingMatterTableIndividual = bookingEntryData.BookingMatterTable;
this.AddMatterData(ref bookingMatterTableIndividual, bookingEntryData.DsBookingsMatters);
}
}
else if (bookingEntryData.DsBookingsMatters.MatterForBooking.Select(string.Format("ProjectId = '{0}'", appointmentDetails.ProjectId.ToString())).Length > 1)
{
throw new Exception("This matter is already present for this appointment");
}
}
}
}
}
if (appointmentDetails.ProjectId != null)
{
if (appointmentDetails.ProjectId != DataConstants.DummyGuid)
{
this.AddMatter(appointmentDetails.ProjectId, ref bookingEntryData);
}
}
#endregion
if (appointmentDetails.Id == 0)
{
bookingEntryData.OccurrenceData.BookingText = appointmentDetails.Subject;
bookingEntryData.OccurrenceData.BookingColour = (System.Drawing.Color.Black);
}
else
{
bookingEntryData.OccurrenceData.StartDate = appointmentDetails.StartDate;
}
#region Date & Time Calculations
TimeSpan tsStartTime;
TimeSpan tsEndTime;
try
{
tsStartTime = TimeSpan.Parse(appointmentDetails.StartTime);
tsEndTime = TimeSpan.Parse(appointmentDetails.EndTime);
DateTime dtStartDate = appointmentDetails.StartDate;
//If the end time is smaller than the start time
//then the appointment must have spanned midnight
//and therefore the enddate should be amended to
//include the extra day.
if (tsEndTime < tsStartTime)
{
bookingEntryData.OccurrenceData.EndDate = dtStartDate.AddDays(1);
}
else
{
bookingEntryData.OccurrenceData.EndDate = dtStartDate;
}
}
catch
{
bookingEntryData.OccurrenceData.EndDate = DateTime.Now;
}
bookingEntryData.OccurrenceData.DueDate = DateTime.Now;
bookingEntryData.OccurrenceData.StartTime = appointmentDetails.StartTime;
bookingEntryData.OccurrenceData.EndTime = appointmentDetails.EndTime;
if (string.IsNullOrEmpty(appointmentDetails.StartTime))
{
appointmentDetails.StartTime = ":";
}
if (string.IsNullOrEmpty(appointmentDetails.EndTime))
{
appointmentDetails.EndTime = ":";
}
appointmentDetails.StartTime = SrvBookingEntryCommon.EnsureTimeFormat(appointmentDetails.StartTime);
appointmentDetails.EndTime = SrvBookingEntryCommon.EnsureTimeFormat(appointmentDetails.EndTime);
if (!SrvBookingEntryCommon.IsValidTime(Convert.ToString(appointmentDetails.StartDate), appointmentDetails.StartTime, true))
{
throw new Exception("Invalid Start Time");
}
if (!SrvBookingEntryCommon.IsValidTime(Convert.ToString(appointmentDetails.StartDate), appointmentDetails.EndTime, true))
{
throw new Exception("Invalid End Time");
}
bookingEntryData.OccurrenceData.EstimatedTime = SrvBookingEntryCommon.CalculateDuration(appointmentDetails.StartTime, "", appointmentDetails.EndTime);
#endregion
this.LoadBookingPriority(ref bookingEntryData);
bookingEntryData.OccurrenceData.IsOccurrenceProvisional = false;
bookingEntryData.OccurrenceData.IsOccurrenceIgnoredBook = false;
bookingEntryData.OccurrenceData.OccurrenceNotes = appointmentDetails.Notes;
bookingEntryData.OccurrenceData.Text = appointmentDetails.Subject;
bookingEntryData.OccurrenceData.IsPrivateBooking = false;
// Set Status Default to "Not Set"
this.LoadBookingStatus(ref bookingEntryData, "Not Set");
// Set Type Default to "Appointment"
this.LoadBookingTypes(ref bookingEntryData);
bookingEntryData.BookingDates = Convert.ToString(appointmentDetails.StartDate);
bookingEntryData.RecurrenceData.IsSaturdayInclude = false;
bookingEntryData.RecurrenceData.IsSundayInclude = false;
#region Set Reminder details
if (appointmentDetails.IsReminderSet)
{
if (appointmentDetails.ReminderType == "Before")
{
bookingEntryData.OccurrenceData.ReminderDate = appointmentDetails.ReminderDate;
bookingEntryData.OccurrenceData.ReminderTime = appointmentDetails.ReminderTime;
bookingEntryData.OccurrenceData.ReminderMinutesBefore = Convert.ToInt16(appointmentDetails.ReminderBeforeTime);
}
else
{
bookingEntryData.OccurrenceData.ReminderDate = appointmentDetails.ReminderDate;
bookingEntryData.OccurrenceData.ReminderTime = appointmentDetails.ReminderTime;
bookingEntryData.OccurrenceData.ReminderMinutesBefore = 0;
}
}
else
{
bookingEntryData.OccurrenceData.ReminderDate = Convert.ToDateTime("01/01/1753");
bookingEntryData.OccurrenceData.ReminderTime = "09:00";
bookingEntryData.OccurrenceData.ReminderMinutesBefore = 0;
}
bookingEntryData.OccurrenceData.ReminderFutureAction = 0;
#endregion
bookingEntryData.OccurrenceData.TaskStartDate = Convert.ToDateTime("01/01/1753");
bookingEntryData.ReminderRepeatForOccurrences = false;
bookingEntryData.OccurrenceData.VenueId = appointmentDetails.VenueId;
string errorMessage = string.Empty;
bool returnValueRows = false;
returnValueRows = bookingEntryData.Save(out errorMessage);
if (returnValueRows == false)
{
if (errorMessage != string.Empty)
{
returnValue.Success = false;
returnValue.Message = errorMessage;
}
}
else
{
appointmentDetails.Id = bookingEntryData.OccurrenceData.Id;
returnValue.Appointment = appointmentDetails;
}
}
finally
{
// Remove the logged on user's ApplicationSettings from the
// list of concurrent sessions
Host.UnloadLoggedOnUser();
}
}
catch (System.Data.SqlClient.SqlException)
{
returnValue.Success = false;
returnValue.Message = Functions.SQLErrorMessage;
}
catch (Exception Ex)
{
returnValue.Success = false;
returnValue.Message = Ex.Message;
}
return returnValue;
}