private static TimeInterval ExtractTimeIntervalFromTimeslot(TimeregWithTimeslot tkTimeslot) { return(new TimeInterval() { Id = tkTimeslot.TimeslotId, Interval = tkTimeslot.Timeslot }); }
private static List <TimeregWithTimeslot> GetTopTimeregsWithTimeslot(ClientRuntimeContext clientContext, List spList, Toolkit tk) { var rowLimit = 250; var query = new CamlQuery() { ViewXml = $@"<View><Query><Where><IsNotNull><FieldRef Name='{tk.TimeslotFieldName}'/></IsNotNull></Where><OrderBy><FieldRef Name='ID' Ascending='FALSE'/></OrderBy></Query><ViewFields><FieldRef Name='Sag_x003a_Sags_x0020_Id' /><FieldRef Name='{tk.TimeslotFieldName}' /></ViewFields><RowLimit>{rowLimit}</RowLimit></View>" }; var listItems = spList.GetItems(query); clientContext.Load(listItems); clientContext.ExecuteQuery(); var listOfTimeregsWithTimelots = new List <TimeregWithTimeslot>(); foreach (var item in listItems) { var timeregWithTimeslot = new TimeregWithTimeslot { Timeslot = tk.TimeslotIsFieldLookup ? (from field in item.FieldValues where field.Key == tk.TimeslotFieldName select((FieldLookupValue)field.Value).LookupValue).Single() : (from field in item.FieldValues where field.Key == tk.TimeslotFieldName select field.Value.ToString()).Single(), TimeslotId = tk.TimeslotIsFieldLookup ? (from field in item.FieldValues where field.Key == tk.TimeslotFieldName select((FieldLookupValue)field.Value).LookupId).Single() : -1, CaseId = (from field in item.FieldValues where field.Key == "Sag_x003a_Sags_x0020_Id" select ExtractCaseIdFromField(((FieldLookupValue)field.Value).LookupValue)).Single() }; listOfTimeregsWithTimelots.Add(timeregWithTimeslot); } return(listOfTimeregsWithTimelots); }