public AppointmentSearchReturnValue AppointmentSearch(Guid logonId, CollectionRequest collectionRequest,
AppointmentSearchCriteria criteria)
{
AppointmentSearchReturnValue returnValue = new AppointmentSearchReturnValue();
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");
}
// Create a data list creator for a list of matters
DataListCreator<Appointment> dataListCreator = new DataListCreator<Appointment>();
// Declare an inline event (annonymous delegate) to read the
// dataset if it is required
dataListCreator.ReadDataSet += delegate(object Sender, ReadDataSetEventArgs e)
{
DiaryMemberSearchItem diaryMembers = this.GetDiaryMemberDetails(criteria.MemberID);
string UsersChosenMemberID = criteria.MemberID;
DateTime usersDiaryDate = DateTime.Today;
int CurrentDiaryDays = 1;
bool ShowCancelled = false;
bool ShowTasks = false;
bool ExcludeEmptyDiaryDaysForUsers = true;
bool ExcludeEmptyDiaryDaysForGroups = true;
string memberIds;
string[] usersChosenMemberIDs = new string[] { };
int usersDiaryDaysView = 7;
DiaryViewDts dvDiary = new DiaryViewDts();
if (criteria.Date == DataConstants.BlankDate)
{
usersDiaryDate = DateTime.Today;
}
else
{
usersDiaryDate = Convert.ToDateTime(criteria.Date);
}
if (!diaryMembers.IsGroup)
{
UsersChosenMemberID = diaryMembers.MemberID;
dvDiary = SrvBookingEntryLookup.GetDiaryBookingsForMember(UsersChosenMemberID, usersDiaryDate,
CurrentDiaryDays, ShowCancelled, ShowTasks, usersDiaryDaysView, ExcludeEmptyDiaryDaysForUsers);
}
else
{
usersChosenMemberIDs = this.ResolveGroupMembers(int.Parse(diaryMembers.MemberID));
memberIds = string.Join(",", usersChosenMemberIDs);
dvDiary = SrvBookingEntryLookup.GetDiaryBookingsForMembers(memberIds, usersDiaryDate, CurrentDiaryDays, ShowCancelled, ShowTasks, usersDiaryDaysView, ExcludeEmptyDiaryDaysForGroups);
}
// Add New Column Editable
dvDiary.Tables[0].Columns.Add("isEdit");
for (int i = 0; i < dvDiary.Tables[0].Rows.Count; i++)
{
dvDiary.Tables[0].Rows[i]["isEdit"] = this.IsOccurrenceViewableBy(Convert.ToInt32(dvDiary.Tables[0].Rows[i]["OccurrenceID"]));
}
e.DataSet = dvDiary;
if (criteria.OrderBy != string.Empty)
{
DataTable dt = Functions.SortDataTable(e.DataSet.Tables[0], criteria.OrderBy);
e.DataSet.Tables.Remove("DiaryEntries");
e.DataSet.Tables.Add(dt);
}
};
returnValue.Appointments = dataListCreator.Create(logonId,
"AppointmentSearch",
// Tell it the query criteria used so if the cache is accessed
// again it knows if it is the same query
criteria.ToString(),
collectionRequest,
// Import mappings to map the dataset row fields to the data
// list entity properties
new ImportMapping[] {
new ImportMapping("Id", "OccurrenceID"),
new ImportMapping("StartDate", "Date"),
new ImportMapping("Subject", "OccSpecificText"),
new ImportMapping("StartTime", "StartTime"),
new ImportMapping("EndTime", "EndTime"),
new ImportMapping("Notes", "OccurrenceNoteText"),
new ImportMapping("VenueText", "VenueDescription"),
new ImportMapping("Duration", "EstTime"),
new ImportMapping("IsEditable", "isEdit")
// More fields are required here but the service layer query may not be
// providing them. This is enough for a test.
}
);
}
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 TaskSearchReturnValue MemberTaskSearch(Guid logonId, CollectionRequest collectionRequest,
TaskSearchCriteria criteria)
{
TaskSearchReturnValue returnValue = new TaskSearchReturnValue();
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");
}
// Create a data list creator for a list of matters
DataListCreator<Task> dataListCreator = new DataListCreator<Task>();
// Declare an inline event (annonymous delegate) to read the
// dataset if it is required
dataListCreator.ReadDataSet += delegate(object Sender, ReadDataSetEventArgs e)
{
DiaryMemberSearchItem diaryMembers = this.GetDiaryMemberDetails(criteria.MemberID);
string UsersChosenMemberID = criteria.MemberID;
DateTime usersDiaryDate = DateTime.Today;
bool ShowCancelled = false;
string memberIds;
string[] usersChosenMemberIDs = new string[] { };
DateTime taskFromDate = usersDiaryDate;
DateTime taskToDate = usersDiaryDate;
TimeSpan timeSpan = taskToDate - taskFromDate;
int taskNoOfDays = (timeSpan.Days + 1);
int taskBookingID = 0;
int statusID = 0;
string occurrencePriority = string.Empty;
int dateFilter = 0;
int incItems = 1;
int progress = 0;
DiaryViewDts dvDiary = new DiaryViewDts();
if (criteria.StartDate != DataConstants.BlankDate)
{
taskFromDate = Convert.ToDateTime(criteria.StartDate);
}
if (!diaryMembers.IsGroup)
{
UsersChosenMemberID = diaryMembers.MemberID;
dvDiary = SrvBookingEntryLookup.GetAllTasksForMember(UsersChosenMemberID, taskFromDate,
ShowCancelled, taskNoOfDays, taskBookingID, statusID, occurrencePriority, dateFilter, incItems, progress);
}
else
{
usersChosenMemberIDs = this.ResolveGroupMembers(int.Parse(diaryMembers.MemberID));
memberIds = string.Join(",", usersChosenMemberIDs);
dvDiary = SrvBookingEntryLookup.GetAllTasksForMember(memberIds, taskFromDate,
ShowCancelled, taskNoOfDays, taskBookingID, statusID, occurrencePriority, dateFilter, incItems, progress);
}
// Add New Column Editable
dvDiary.DiaryEntries.Columns.Add("isEdit");
// Add New Column Matters
dvDiary.DiaryEntries.Columns.Add("OccurrenceMatter");
// Add New Column IsLimitation
dvDiary.DiaryEntries.Columns.Add("IsLimitationTask", typeof(Boolean));
// Add New Column NewRecordedDueDate for filtering
dvDiary.DiaryEntries.Columns.Add("NewRecordedDueDate", typeof(DateTime));
System.Collections.ArrayList listIds = new System.Collections.ArrayList();
foreach (DiaryViewDts.DiaryEntriesRow row in dvDiary.DiaryEntries.Rows)
{
row["isEdit"] = this.IsOccurrenceViewableBy(row.OccurrenceID);
row["IsLimitationTask"] = this.IsALimitationTask(Convert.ToInt32(row.BookingTypeID));
if (!listIds.Contains(row.BookingID))
{
listIds.Add(row.BookingID);
}
if (row["RecordedDueDate"].ToString() != "")
{
row["NewRecordedDueDate"] = Convert.ToDateTime(row["RecordedDueDate"]);
}
}
StringBuilder ids = new StringBuilder();
foreach (int bookingId in listIds)
{
ids.Append(bookingId.ToString());
ids.Append(",");
}
DiaryViewMattersDts matterDts = new DiaryViewMattersDts();
if (ids.Length > 0)
{
ids.Length--;
matterDts = SrvBookingEntryLookup.GetMattersForBookings(ids.ToString());
}
foreach (DiaryViewDts.DiaryEntriesRow row in dvDiary.DiaryEntries.Rows)
{
DiaryViewMattersDts.BookingMatterRow[] matterRows;
matterRows = (DiaryViewMattersDts.BookingMatterRow[])matterDts.BookingMatter.Select(string.Format("BookingID = {0}", row.BookingID));
StringBuilder sb = new StringBuilder();
foreach (DiaryViewMattersDts.BookingMatterRow matterRow in matterRows)
{
sb.AppendFormat("{0}$({1}-{2}) {3}~", matterRow.ProjectID, matterRow.MatterRef.Substring(0, 6), matterRow.MatterRef.Substring(6, 4), matterRow.matDescription);
}
if (sb.Length > 0)
{
string matters = sb.ToString().Substring(0, sb.Length - 1);
row["OccurrenceMatter"] = matters;
}
}
DataView dvDiaryView = new DataView(dvDiary.Tables[0]);
string filter = string.Empty;
switch (criteria.Status)
{
case "Outstanding":
filter += " (OccStatusDesc <> 'Completed') and ";
break;
case "Completed":
filter += " (OccStatusDesc = 'Completed') and ";
break;
}
bool isStartDate = false;
if (criteria.StartDate != DataConstants.BlankDate)
{
filter += " ((NewRecordedDueDate >= #" + Convert.ToDateTime(criteria.StartDate).ToString("yyyy-MM-dd") + "#) ";
isStartDate = true;
}
if (criteria.ToDate != DataConstants.BlankDate)
{
if (isStartDate)
{
filter += " and ";
}
filter += "(NewRecordedDueDate <= #" + Convert.ToDateTime(criteria.ToDate).ToString("yyyy-MM-dd") + "#)";
if (isStartDate)
{
filter += ") ";
}
filter += " and ";
}
else
{
filter += ") and ";
}
if (!string.IsNullOrEmpty(filter))
{
filter = filter.Trim().Substring(0, filter.Trim().Length - 3);
}
dvDiaryView.RowFilter = filter;
DataSet dsFiltered = new DataSet();
dsFiltered.Tables.Add(dvDiaryView.ToTable());
e.DataSet = dsFiltered;
if (criteria.OrderBy != string.Empty)
{
DataTable dt = Functions.SortDataTable(e.DataSet.Tables[0], criteria.OrderBy);
e.DataSet.Tables.Remove("DiaryEntries");
e.DataSet.Tables.Add(dt);
}
};
returnValue.Tasks = dataListCreator.Create(logonId,
"TaskSearch",
// Tell it the query criteria used so if the cache is accessed
// again it knows if it is the same query
criteria.ToString(),
collectionRequest,
// Import mappings to map the dataset row fields to the data
// list entity properties
new ImportMapping[] {
new ImportMapping("Id", "OccurrenceID"),
new ImportMapping("RecordedDueDate", "RecordedDueDate"),
new ImportMapping("Subject", "OccSpecificText"),
new ImportMapping("StatusDesc", "OccStatusDesc"),
new ImportMapping("Progress", "OccProgress"),
new ImportMapping("Notes", "OccurrenceNoteText"),
new ImportMapping("Matters", "OccurrenceMatter"),
new ImportMapping("IsEditable", "isEdit"),
new ImportMapping("IsLimitationTask", "IsLimitationTask")
// More fields are required here but the service layer query may not be
// providing them. This is enough for a test.
}
);
}
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;
}
