C# Online Compiler | .NET Fiddle

<no name> by Anonymous

using Newtonsoft.Json;
using GloucesterAsap.Forms.Extensions;
using GloucesterAsap.Forms.PlatformSpecificInterfaces;
using GloucesterAsap.Forms.Services.Interfaces;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using System.Text;
using System.Xml.Linq;
using System.Xml.Serialization;
using System.Net.Http;

namespace GloucesterAsap.Forms.Services
{
    public class NhsChoicesService : Interfaces.INhsChoicesService
    {

        //Defining the classes that will hold new NHS Choices API returned data
        public class Rootobject
        {
            public int odatacount { get; set; }
            public Value[] value { get; set; }
            public string tracking { get; set; }
        }

        public class Value
        {
            public float searchscore { get; set; }
            public string OrganisationID { get; set; }
            public string OrganisationName { get; set; }
            public string[] OrganisationAliases { get; set; }
            public string OrganisationTypeID { get; set; }
            public string OrganisationType { get; set; }
            public string OrganisationStatus { get; set; }
            public bool IsPimsManaged { get; set; }
            public string PIMSCode { get; set; }
            public string NACSCode { get; set; }
            public object LocalAuthorityCode { get; set; }
            public string SummaryText { get; set; }
            public string URL { get; set; }
            public string Address1 { get; set; }
            public string Address2 { get; set; }
            public string Address3 { get; set; }
            public string City { get; set; }
            public string County { get; set; }
            public decimal Latitude { get; set; }
            public decimal Longitude { get; set; }
            public string OrganisationSubType { get; set; }
            public DateTime LastUpdatedDate { get; set; }
            public string Postcode { get; set; }
            public Geocode Geocode { get; set; }
            public string[] CCG { get; set; }
            public object[] RelatedIAPTCCGs { get; set; }
            public object[] Trusts { get; set; }
            public object[] CCGLocalAuthority { get; set; }
            public string[] ServicesOffered { get; set; }
            public string[] ServicesProvided { get; set; }
            public string[] ServiceCodesProvided { get; set; }
            public string[] ServicesProvidedConditions { get; set; }
            public string[] OrgTypeConditions { get; set; }
            public string OpeningTimes { get; set; }
            public string Contacts { get; set; }
            public object VenueType { get; set; }
            public string Metrics { get; set; }
            public object GSD { get; set; }
            public Openingtimesv2[] OpeningTimesV2 { get; set; }
            public float distanceMiles { get; set; }
        }

        public class Geocode
        {
            public string type { get; set; }
            public float[] coordinates { get; set; }
            public Crs crs { get; set; }
        }

        public class Crs
        {
            public string type { get; set; }
            public Properties properties { get; set; }
        }

        public class Properties
        {
            public string name { get; set; }
        }

        public class Openingtimesv2
        {
            public string Weekday { get; set; }
            public string Times { get; set; }
            public int OffsetOpeningTime { get; set; }
            public int OffsetClosingTime { get; set; }
            public string OpeningTimeType { get; set; }
            public string AdditionalOpeningDate { get; set; }
            public bool IsOpen { get; set; }
        }

        public class ContactsArray
        {
            public string OrganisationContactType { get; set; }
            public string OrganisationContactAvailabilityType { get; set; }
            public string OrganisationContactMethodType { get; set; }
            public string OrganisationContactValue { get; set; }
        }

        public class ContactsRoot
        {
            public List<ContactsArray> ContactsArray { get; set; }
        }
        //End of classes









        private readonly IConfigurationReader _configurationReader;
        private readonly INetworkConnection _networkConnection;
        public NhsChoicesService()
        {
            _configurationReader = App.DependencyServiceResolver.Get<IConfigurationReader>(Xamarin.Forms.DependencyFetchTarget.GlobalInstance) ?? throw new Exception($"Failed to resolve {nameof(IConfigurationReader)}");
            _networkConnection = App.DependencyServiceResolver.Get<INetworkConnection>() ?? throw new Exception($"Failed to resolve {nameof(INetworkConnection)}");
        }

        /// <summary>
        /// Fetches the NHS choices data for user location asynchronous.
        /// </summary>
        /// <param name="postcode">The postcode.</param>
        /// <param name="userLocationId">The user location identifier.</param>
        /// <returns></returns>
        /// <exception cref="ArgumentNullException">postcode</exception>
        public async Task<bool> FetchNhsChoicesDataForUserLocationAsync(string postcode, int userLocationId)
        {
            if (string.IsNullOrWhiteSpace(postcode))
            {
                throw new ArgumentNullException($"{nameof(postcode)}");
            }
            if (!await _networkConnection.HasNetworkConnectionAsync())
            {

                System.Diagnostics.Debug.WriteLine("Detected no internet connection.");
                return false;
            }

            try
            {
                await this.GetGpPracticesByPostcodeAndStoreInTableAsync(postcode, userLocationId);

                await this.GetPharmaciesByPostcodeAndStoreInTableAsync(postcode, userLocationId);


                // Actually, Hospitals are statically inserted as they're local to their area and the client has chosen specific ones. 
                //await this.GetHospitalsByPostcodeAndStoreInTableAsync(postcode, userLocationId);


                await this.FetchOpeningTimesForAllOrganisationsAsync(userLocationId);


                // This is now done on the fly, and the app reads the StaticOrganisations file,
                // when a specific service type is selected. 
                // -- DAR 10/09/2018
                // we have to insert some static records for organisations. 
                // Run this after fteching the opening times for the NHS choices records. 
                //	await this.GenerateAndInsertStaticOrganisationsAsync(userLocationId);


                return true;
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine($"Exception throw when trying to download NHS choices data {ex}");
            }

            return false;
        }



        /// <summary>
        /// Returns wether there is any NHS choices data for the location asynchronous.
        /// </summary>
        /// <param name="locationId">The location identifier.</param>
        /// <returns></returns>
        public async Task<bool> DoesNhsChoicesDataExistForLocationAsync(int locationId)
        {
            return await App.DatabaseRepository.AnyAsync<DAL.Entities.NhsChoicesData>(x => x.UserLocationId == locationId);
        }


        /// <summary>
        /// Deletes the NHS choices data for the location asynchronous.
        /// </summary>
        /// <param name="locationId">The location identifier.</param>
        /// <returns></returns>
        public async Task<bool> DeleteNhsChoicesDataForLocationAsync(int locationId)
        {
            // Step 1) Check to see if there's any nhs choices entities for this record. 
            if (await this.DoesNhsChoicesDataExistForLocationAsync(locationId))
            {
                // Step 2) We have related choices entities. Now we need to delete them. 
                var matchingLocationById = await App.DatabaseRepository.GetFirstOrDefaultAsync<DAL.Entities.UserLocation>(x => x.Id == locationId);
                if (matchingLocationById != null)
                {
                    // Now, we need to get the related NHS choices data. 
                    var relatedNhsChoicesDataForLocation = await matchingLocationById.GetAllRelatedNhsChoicesDataForThisLocationAsync();
                    if (!relatedNhsChoicesDataForLocation.IsNullOrEmpty())
                    {
                        return await App.DatabaseRepository.DeleteAsync(relatedNhsChoicesDataForLocation) >= 1;
                    }
                }
            }
            else
            {
                // There's no records, so just return true. 
                return true;
            }
            return false;
        }



        #region Organisation fetches and inserts


        /// <summary>
        /// Gets the gp practices by postcode and store in table asynchronous.
        /// </summary>
        /// <param name="postcode">The postcode.</param>
        /// <param name="userLocationId">The user location identifier.</param>
        /// <returns></returns>
        /// <exception cref="Exception">
        /// xmlDataForGpPractices
        /// or
        /// GpPracticesModel
        /// </exception>
        private async Task GetGpPracticesByPostcodeAndStoreInTableAsync(string postcode, long userLocationId)
        {

            //Lets create a new URL for the new ChoicesAPI - Grabbing URL from config file
            var path = "https://api.nhs.uk/service-search/search-postcode-or-place?api-version=1&search=" + postcode;

            //Grab the subscription key from the config file
            var subscriptionKey = "cdadee486e564c2dbe2d85b8c29bc7fb";

            //Filter depending on querying for GP or Pharmacy
            var gpFilterQuery = "OrganisationTypeID eq 'GPB'";

            var queryBodyContent = JsonConvert.SerializeObject(
                new
                {
                    filter = gpFilterQuery,
                    top = "25",
                    skip = "0",
                    count = true
                });

            var data = new StringContent(queryBodyContent, Encoding.UTF8, "application/json");

            using (var client = new HttpClient())
            {
                client.DefaultRequestHeaders.Add("subscription-key", subscriptionKey);
                var response = client.PostAsync(path, data).Result.Content.ReadAsStringAsync().Result;

                dynamic deserialisedObj = JsonConvert.DeserializeObject(response);
                //The result
                var result = deserialisedObj;
                //Map the values to our model classes above..
                Rootobject rootobject = JsonConvert.DeserializeObject<Rootobject>(response);

                //Now loop through the rootobject values and assign them to variables
                foreach (var item in rootobject.value)
                {
                    //We need item id, item title, ods code, address 1,2,3,4, postcode, distance, tel, lat, long
                    var orgId = item.OrganisationID;
                    var nacs = item.NACSCode;
                    var orgName = (!item.OrganisationAliases.IsNullOrEmpty() && item.OrganisationAliases.Any()) ? item.OrganisationAliases.First() : item.OrganisationName;
                    var odsCode = item.OrganisationID;
                    var addressLine1 = item.Address1;
                    var addressLine2 = item.Address2;
                    var addressLine3 = item.Address3;
                    var orgPostcode = item.Postcode;
                    var distanceInMiles = item.distanceMiles;
                    string telephone = null;
                    var orgLong = item.Longitude;
                    var orgLat = item.Latitude;

                    if (!string.IsNullOrEmpty(item.Contacts))
                    {
                        var contacts = JsonConvert.DeserializeObject<List<ContactsArray>>(item.Contacts);
                        foreach (var contact in contacts)
                        {
                            var contactMethodType = contact.OrganisationContactMethodType;
                            var contactValue = contact.OrganisationContactValue;
                            if (contactMethodType == "Telephone" && !string.IsNullOrWhiteSpace(contactValue))
                            {
                                telephone = contactValue;
                            }
                        }
                    }

                    var entityToSave = new DAL.Entities.NhsChoicesData(orgId, orgName,
                        nacs,
                        addressLine1, addressLine2, addressLine3, null,
                        orgPostcode, distanceInMiles, telephone, Enums.ServiceType.Gp, orgLat, orgLong, userLocationId);

                    var numberOfSavedRecords = await App.DatabaseRepository.SaveAsync(entityToSave);
                    System.Diagnostics.Debug.WriteLine($"Saved {numberOfSavedRecords} GP practice records.");
                }
            }



            //var fullyQualifiedUrl = $"{this.BaseNhsChoicesUrl}/organisations/gppractices/postcode/{postcode}.xml?apikey={this.NhsChoicesApiKey}&range=100";

            //var xmlDataForGpPractices = await Helpers.WebRequestHelpers.LoadXmlStringFromUrlAsync(fullyQualifiedUrl);
            //if (string.IsNullOrWhiteSpace(xmlDataForGpPractices))
            //{
            //    throw new Exception($"returned value for {nameof(xmlDataForGpPractices)} was null or whitespace.");
            //}

            //var deserializedXml = Helpers.SerializeHelper.DeserializeXmlToObject<Models.NhsChoicesModel.GpPracticesModel>(xmlDataForGpPractices);
            //if (deserializedXml == null || deserializedXml.EntryLinks.IsNullOrEmpty())
            //{
            //    throw new Exception($"Failed to deserialize the XML to an object type of {nameof(Models.NhsChoicesModel.GpPracticesModel)}");
            //}

            //foreach (var item in deserializedXml.EntryLinks)
            //{
            //    var content = item.Content;
            //    var organisationSummary = content.OrganisationSummary;
            //    var addressInformation = organisationSummary.address;
            //    var geographyInformation = organisationSummary.GeographicCoordinates;

            //    var telephoneNumber = organisationSummary?.SummaryContactInformation?.TelephoneNumber ?? string.Empty;

            //    var addressLine1 = this.GetAddressLineForIndex(addressInformation?.addressLine, 0);
            //    var addressLine2 = this.GetAddressLineForIndex(addressInformation?.addressLine, 1);
            //    var addressLine3 = this.GetAddressLineForIndex(addressInformation?.addressLine, 2);
            //    var addressLine4 = this.GetAddressLineForIndex(addressInformation?.addressLine, 3);

            //    var entityToSave = new DAL.Entities.NhsChoicesData(item.Id, item.Title,
            //        organisationSummary.ODSCode,
            //        addressLine1, addressLine2, addressLine3, addressLine4,
            //        addressInformation.postcode, organisationSummary.Distance, telephoneNumber, Enums.ServiceType.Gp, geographyInformation.Latitude, geographyInformation.Longitude, userLocationId);

            //    var numberOfSavedRecords = await App.DatabaseRepository.SaveAsync(entityToSave);
            //    System.Diagnostics.Debug.WriteLine($"Saved {numberOfSavedRecords} GP practice records.");

            //}


        }

        /// <summary>
        /// Gets the pharmacies by postcode and store in table asynchronous.
        /// </summary>
        /// <param name="postcode">The postcode.</param>
        /// <param name="userLocationId">The user location identifier.</param>
        /// <returns></returns>
        /// <exception cref="Exception">
        /// xmlDataForGpPractices
        /// or
        /// PharmaciesModel
        /// </exception>
        private async Task GetPharmaciesByPostcodeAndStoreInTableAsync(string postcode, long userLocationId)
        {
            //Lets create a new URL for the new ChoicesAPI - Grabbing URL from config file
            var path = "https://api.nhs.uk/service-search/search-postcode-or-place?api-version=1&search=" + postcode;

            //Grab the subscription key from the config file
            var subscriptionKey = "cdadee486e564c2dbe2d85b8c29bc7fb";

            //Filter depending on querying for GP or Pharmacy
            var pharmaFilterQuery = "OrganisationTypeID eq 'PHA'";

            var queryBodyContent = JsonConvert.SerializeObject(
                new
                {
                    filter = pharmaFilterQuery,
                    top = "25",
                    skip = "0",
                    count = true
                });

            var data = new StringContent(queryBodyContent, Encoding.UTF8, "application/json");

            using (var client = new HttpClient())
            {
                client.DefaultRequestHeaders.Add("subscription-key", subscriptionKey);
                var response = client.PostAsync(path, data).Result.Content.ReadAsStringAsync().Result;

                dynamic deserialisedObj = JsonConvert.DeserializeObject(response);
                //The result
                var result = deserialisedObj;
                //Map the values to our model classes above..
                Rootobject rootobject = JsonConvert.DeserializeObject<Rootobject>(response);

                //Now loop through the rootobject values and assign them to variables
                foreach (var item in rootobject.value)
                {
                    //We need item id, item title, ods code, address 1,2,3,4, postcode, distance, tel, lat, long
                    var orgId = item.OrganisationID;
                    var nacs = item.NACSCode;
                    var orgName = (!item.OrganisationAliases.IsNullOrEmpty() && item.OrganisationAliases.Any()) ? item.OrganisationAliases.First() : item.OrganisationName;
                    var odsCode = item.OrganisationID;
                    var addressLine1 = item.Address1;
                    var addressLine2 = item.Address2;
                    var addressLine3 = item.Address3;
                    var orgPostcode = item.Postcode;
                    var distanceInMiles = item.distanceMiles;
                    string telephone = null;
                    var orgLong = item.Longitude;
                    var orgLat = item.Latitude;

                    if (!string.IsNullOrEmpty(item.Contacts))
                    {
                        var contacts = JsonConvert.DeserializeObject<List<ContactsArray>>(item.Contacts);
                        foreach (var contact in contacts)
                        {
                            var contactMethodType = contact.OrganisationContactMethodType;
                            var contactValue = contact.OrganisationContactValue;
                            if (contactMethodType == "Telephone" && !string.IsNullOrWhiteSpace(contactValue))
                            {
                                telephone = contactValue;
                            }
                        }
                    }

                    var entityToSave = new DAL.Entities.NhsChoicesData(orgId, orgName,
                        nacs,
                        addressLine1, addressLine2, addressLine3, null,
                        orgPostcode, distanceInMiles, telephone, Enums.ServiceType.Pharmacy, orgLat, orgLong, userLocationId);

                    var numberOfSavedRecords = await App.DatabaseRepository.SaveAsync(entityToSave);
                    System.Diagnostics.Debug.WriteLine($"Saved {numberOfSavedRecords} {nameof(Enums.ServiceType.Pharmacy)} records.");
                }
            }



            //var fullyQualifiedUrl = $"{this.BaseNhsChoicesUrl}/organisations/pharmacies/postcode/{postcode}.xml?apikey={this.NhsChoicesApiKey}&range=100";

            //var xmlDataForGpPractices = await Helpers.WebRequestHelpers.LoadXmlStringFromUrlAsync(fullyQualifiedUrl);
            //if (string.IsNullOrWhiteSpace(xmlDataForGpPractices))
            //{
            //    throw new Exception($"returned value for {nameof(xmlDataForGpPractices)} was null or whitespace.");
            //}

            //var deserializedXml = Helpers.SerializeHelper.DeserializeXmlToObject<Models.NhsChoicesModel.PharmaciesModel>(xmlDataForGpPractices);
            //if (deserializedXml == null || deserializedXml.EntryLinks.IsNullOrEmpty())
            //{
            //    throw new Exception($"Failed to deserialize the XML to an object type of {nameof(Models.NhsChoicesModel.PharmaciesModel)}");
            //}

            //foreach (var item in deserializedXml.EntryLinks)
            //{
            //    var content = item.Content;
            //    var organisationSummary = content.OrganisationSummary;
            //    var addressInformation = organisationSummary.address;
            //    var geographyInformation = organisationSummary.GeographicCoordinates;

            //    var telephoneNumber = organisationSummary?.SummaryContactInformation?.TelephoneNumber ?? string.Empty;

            //    var addressLine1 = this.GetAddressLineForIndex(addressInformation?.addressLine, 0);
            //    var addressLine2 = this.GetAddressLineForIndex(addressInformation?.addressLine, 1);
            //    var addressLine3 = this.GetAddressLineForIndex(addressInformation?.addressLine, 2);
            //    var addressLine4 = this.GetAddressLineForIndex(addressInformation?.addressLine, 3);

            //    var entityToSave = new DAL.Entities.NhsChoicesData(item.Id, item.Title,
            //        organisationSummary.ODSCode,
            //        addressLine1, addressLine2, addressLine3, addressLine4,
            //        addressInformation.postcode, organisationSummary.Distance, telephoneNumber, Enums.ServiceType.Pharmacy, geographyInformation.Latitude, geographyInformation.Longitude, userLocationId);

            //    var numberOfSavedRecords = await App.DatabaseRepository.SaveAsync(entityToSave);
            //    System.Diagnostics.Debug.WriteLine($"Saved {numberOfSavedRecords} {nameof(Enums.ServiceType.Pharmacy)} records.");

            //}


        }


        /// <summary>
        /// Gets the hospitals by postcode and store in table asynchronous.
        /// </summary>
        /// <param name="postcode">The postcode.</param>
        /// <param name="userLocationId">The user location identifier.</param>
        /// <returns></returns>
        /// <exception cref="Exception">
        /// xmlDataForGpPractices
        /// or
        /// HospitalModel
        /// </exception>
        private async Task GetHospitalsByPostcodeAndStoreInTableAsync(string postcode, long userLocationId)
        {
            var fullyQualifiedUrl = $"{this.BaseNhsChoicesUrl}/organisations/hospitals/postcode/{postcode}.xml?apikey={this.NhsChoicesApiKey}&range=100";

            var xmlDataForGpPractices = await Helpers.WebRequestHelpers.LoadXmlStringFromUrlAsync(fullyQualifiedUrl);
            if (string.IsNullOrWhiteSpace(xmlDataForGpPractices))
            {
                throw new Exception($"returned value for {nameof(xmlDataForGpPractices)} was null or whitespace.");
            }

            var deserializedXml = Helpers.SerializeHelper.DeserializeXmlToObject<Models.NhsChoicesModel.HospitalModel>(xmlDataForGpPractices);
            if (deserializedXml == null || deserializedXml.EntryLinks.IsNullOrEmpty())
            {
                throw new Exception($"Failed to deserialize the XML to an object type of {nameof(Models.NhsChoicesModel.HospitalModel)}");
            }

            foreach (var item in deserializedXml.EntryLinks)
            {
                var content = item.Content;
                var organisationSummary = content.OrganisationSummary;
                var addressInformation = organisationSummary.address;
                var geographyInformation = organisationSummary.GeographicCoordinates;

                var telephoneNumber = organisationSummary?.SummaryContactInformation?.TelephoneNumber ?? string.Empty;

                var addressLine1 = this.GetAddressLineForIndex(addressInformation?.addressLine, 0);
                var addressLine2 = this.GetAddressLineForIndex(addressInformation?.addressLine, 1);
                var addressLine3 = this.GetAddressLineForIndex(addressInformation?.addressLine, 2);
                var addressLine4 = this.GetAddressLineForIndex(addressInformation?.addressLine, 3);

                var entityToSave = new DAL.Entities.NhsChoicesData(item.Id, item.Title,
                    organisationSummary.ODSCode,
                    addressLine1, addressLine2, addressLine3, addressLine4,
                    addressInformation.postcode, organisationSummary.Distance, telephoneNumber, Enums.ServiceType.Hospital, geographyInformation.Latitude, geographyInformation.Longitude, userLocationId);

                var numberOfSavedRecords = await App.DatabaseRepository.SaveAsync(entityToSave);
                System.Diagnostics.Debug.WriteLine($"Saved {numberOfSavedRecords} {nameof(Enums.ServiceType.Hospital)} records.");
            }


        }

        #endregion


        #region Opening times fetch
        private async Task FetchOpeningTimesForAllOrganisationsAsync(int userLocationId)
        {
            // Step 1) Fetch all the records we've inserted. 
            var allOrganisationEntitiesFromLocalDbForLocationId = await App.DatabaseRepository.GetAllAsync<DAL.Entities.NhsChoicesData>(x => x.UserLocationId == userLocationId);

            try
            {



                // Step 2) Enumerate through each record, and fetch the opening times. 
                foreach (var entity in allOrganisationEntitiesFromLocalDbForLocationId)
                {
                    try
                    {



                        if (string.IsNullOrWhiteSpace(entity.ChoicesUrl))
                        {
                            System.Diagnostics.Debug.WriteLine($"Error! NhsChoicesData entity did not have a valid value  {nameof(entity.ChoicesUrl)} for id --> {entity.Id}. Skipping to next record.");
                            continue;
                        }
                        if (entity.ServiceType == Enums.ServiceType.Hospital)
                        {
                            continue; // Skip the current entity as a Hospital is always 24 hours. 
                        }

                        // Get the opening times
                        var nacs = entity.OdsCode;

                        //Lets create a new URL for the new ChoicesAPI - Grabbing URL from config file
                        var path = "https://api.nhs.uk/service-search/search?api-version=1";

                        //Grab the subscription key from the config file
                        var subscriptionKey = "cdadee486e564c2dbe2d85b8c29bc7fb";

                        var filterQuery = "NACSCode eq '" + nacs + "'";

                        var queryBodyContent = JsonConvert.SerializeObject(
                            new
                            {
                                filter = filterQuery,
                                select = "OpeningTimesV2",
                                top = "1",
                                skip = "0",
                                count = true
                            });

                        var data = new StringContent(queryBodyContent, Encoding.UTF8, "application/json");

                        using (var client = new HttpClient())
                        {
                            client.DefaultRequestHeaders.Add("subscription-key", subscriptionKey);
                            var response = client.PostAsync(path, data).Result.Content.ReadAsStringAsync().Result;

                            dynamic deserialisedObj = JsonConvert.DeserializeObject(response);
                            //The result
                            var result = deserialisedObj;
                            //Map the values to our model classes above..
                            //To replicate the functionality of v1 on this, we first deserialise the result to a model
                            Rootobject rootobject = JsonConvert.DeserializeObject<Rootobject>(response);
                            if (!rootobject.value.IsNullOrEmpty())
                            {

                                //Now loop through our API results
                                foreach (var item in rootobject.value)
                                {
                                    //Then we check the entity has openingtimesv2
                                    if (!item.OpeningTimesV2.IsNullOrEmpty() && item.OpeningTimesV2.Any())
                                    {
                                        //Now we check if the entity is a GP or PHA, IF GP use reception times PHA use surgery times
                                        if (entity.ServiceType == Enums.ServiceType.Gp)
                                        {
                                            //Times for GPs
                                            //Get reception times
                                            var receptionTimes = item.OpeningTimesV2.Where(x => x.OpeningTimeType == "Reception");
                                            var rectest = receptionTimes.Any();
                                            var tst = rectest;
                                            var mondayTimes = receptionTimes.Where(x => x.Weekday == "Monday");
                                            var tuesdayTimes = receptionTimes.Where(x => x.Weekday == "Tuesday");
                                            var wednesdayTimes = receptionTimes.Where(x => x.Weekday == "Wednesday");
                                            var thursdayTimes = receptionTimes.Where(x => x.Weekday == "Thursday");
                                            var fridayTimes = receptionTimes.Where(x => x.Weekday == "Friday");
                                            var saturdayTimes = receptionTimes.Where(x => x.Weekday == "Saturday");
                                            var sundayTimes = receptionTimes.Where(x => x.Weekday == "Sunday");
                                            string mondayOpeningTimes = null; string tuesdayOpeningTimes = null; string wednesdayOpeningTimes = null; string thursdayOpeningTimes = null; string fridayOpeningTimes = null; string saturdayOpeningTimes = null; string sundayOpeningTimes = null;
                                            //If we have multiple times for these days, this usually means the time is split into morning and afternoon times, so we concat


                                            if (mondayTimes.Any() && mondayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in mondayTimes)
                                                {
                                                    mondayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (mondayTimes.Any()) { mondayOpeningTimes = mondayTimes?.FirstOrDefault().Times; }

                                            if (tuesdayTimes.Any() && tuesdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in tuesdayTimes)
                                                {
                                                    tuesdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (tuesdayTimes.Any()) { tuesdayOpeningTimes = tuesdayTimes?.FirstOrDefault().Times; }

                                            if (wednesdayTimes.Any() && wednesdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in wednesdayTimes)
                                                {
                                                    wednesdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (wednesdayTimes.Any()) { wednesdayOpeningTimes = wednesdayTimes?.FirstOrDefault().Times; }

                                            if (thursdayTimes.Any() && thursdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in thursdayTimes)
                                                {
                                                    thursdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (thursdayTimes.Any()) { thursdayOpeningTimes = thursdayTimes?.FirstOrDefault().Times; }

                                            if (fridayTimes.Any() && fridayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in fridayTimes)
                                                {
                                                    fridayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (fridayTimes.Any()) { fridayOpeningTimes = fridayTimes?.FirstOrDefault().Times; }

                                            if (saturdayTimes.Any() && saturdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in saturdayTimes)
                                                {
                                                    saturdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (saturdayTimes.Any()) { saturdayOpeningTimes = saturdayTimes?.FirstOrDefault().Times; }

                                            if (sundayTimes.Any() && sundayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in sundayTimes)
                                                {
                                                    sundayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (sundayTimes.Any()) { sundayOpeningTimes = sundayTimes?.FirstOrDefault().Times; }


                                            entity.UpdateOpeniningTimes(mondayOpeningTimes, tuesdayOpeningTimes, wednesdayOpeningTimes, thursdayOpeningTimes, fridayOpeningTimes, saturdayOpeningTimes, sundayOpeningTimes);

                                            var didSucessfullyUpdatEntity = await App.DatabaseRepository.UpdateAsync(entity) >= 1;
                                            if (didSucessfullyUpdatEntity)
                                            {
                                                System.Diagnostics.Debug.WriteLine($"Sucessfully updated entity id {entity.Id} with reception opening times.");
                                            }
                                            else
                                            {
                                                System.Diagnostics.Debug.WriteLine($"ERROR! FAILED TO UPDATE entity id {entity.Id} with reception opening times.");
                                            }

                                            continue;

                                        }
                                        else if (entity.ServiceType == Enums.ServiceType.Pharmacy)
                                        {

                                            //Times for pharmacies
                                            //Get general times
                                            var generalTimes = item.OpeningTimesV2.Where(x => x.OpeningTimeType == "General");
                                            var gentest = generalTimes.Any();
                                            var teest = gentest;
                                            var mondayTimes = generalTimes.Where(x => x.Weekday == "Monday");
                                            var tuesdayTimes = generalTimes.Where(x => x.Weekday == "Tuesday");
                                            var wednesdayTimes = generalTimes.Where(x => x.Weekday == "Wednesday");
                                            var thursdayTimes = generalTimes.Where(x => x.Weekday == "Thursday");
                                            var fridayTimes = generalTimes.Where(x => x.Weekday == "Friday");
                                            var saturdayTimes = generalTimes.Where(x => x.Weekday == "Saturday");
                                            var sundayTimes = generalTimes.Where(x => x.Weekday == "Sunday");
                                            string mondayOpeningTimes = null; string tuesdayOpeningTimes = null; string wednesdayOpeningTimes = null; string thursdayOpeningTimes = null; string fridayOpeningTimes = null; string saturdayOpeningTimes = null; string sundayOpeningTimes = null;

                                            //If we have multiple times for these days, this usually means the time is split into morning and afternoon times, so we concat
                                            if (mondayTimes.Any() && mondayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in mondayTimes)
                                                {
                                                    mondayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (mondayTimes.Any()) { mondayOpeningTimes = mondayTimes?.FirstOrDefault().Times; }

                                            if (tuesdayTimes.Any() && tuesdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in tuesdayTimes)
                                                {
                                                    tuesdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (tuesdayTimes.Any()) { tuesdayOpeningTimes = tuesdayTimes?.FirstOrDefault().Times; }

                                            if (wednesdayTimes.Any() && wednesdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in wednesdayTimes)
                                                {
                                                    wednesdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (wednesdayTimes.Any()) { wednesdayOpeningTimes = wednesdayTimes?.FirstOrDefault().Times; }

                                            if (thursdayTimes.Any() && thursdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in thursdayTimes)
                                                {
                                                    thursdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (thursdayTimes.Any()) { thursdayOpeningTimes = thursdayTimes?.FirstOrDefault().Times; }

                                            if (fridayTimes.Any() && fridayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in fridayTimes)
                                                {
                                                    fridayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (fridayTimes.Any()) { fridayOpeningTimes = fridayTimes?.FirstOrDefault().Times; }

                                            if (saturdayTimes.Any() && saturdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in saturdayTimes)
                                                {
                                                    saturdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (saturdayTimes.Any()) { saturdayOpeningTimes = saturdayTimes?.FirstOrDefault().Times; }

                                            if (sundayTimes.Any() && sundayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in sundayTimes)
                                                {
                                                    sundayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (sundayTimes.Any()) { sundayOpeningTimes = sundayTimes?.FirstOrDefault().Times; }


                                            entity.UpdateOpeniningTimes(mondayOpeningTimes, tuesdayOpeningTimes, wednesdayOpeningTimes, thursdayOpeningTimes, fridayOpeningTimes, saturdayOpeningTimes, sundayOpeningTimes);


                                            var didSucessfullyUpdatEntity = await App.DatabaseRepository.UpdateAsync(entity) >= 1;
                                            if (didSucessfullyUpdatEntity)
                                            {
                                                System.Diagnostics.Debug.WriteLine($"Sucessfully updated entity id {entity.Id} with opening times.");
                                            }
                                            else
                                            {
                                                System.Diagnostics.Debug.WriteLine($"ERROR! FAILED TO UPDATE entity id {entity.Id} with opening times.");
                                            }


                                            continue;
                                        }
                                    }
                                    else
                                    {
                                        //Skip
                                        continue;
                                    }
                                }
                            }


                        }


                        //// Replace any whitespace within the url. 
                        //var sanitizedUrl = $"{entity.ChoicesUrl.Trim()}/overview.xml?apikey={this.NhsChoicesApiKey}";

                        //// Read the content of the URL into an XElement, so that we can use XML2Linq.
                        //var xmlElement = XElement.Load(sanitizedUrl);
                        //// Get the opening times element, 
                        //var openingTimesXmlElement = xmlElement?.Descendants()?.FirstOrDefault(x => x.Name.LocalName.Equals("openingTimes", StringComparison.InvariantCultureIgnoreCase));
                        //if (openingTimesXmlElement == null)
                        //{
                        //    System.Diagnostics.Debug.WriteLine($"Failed to get any information for the current entity with Id --> {entity.Id} with a type of --> {entity.ServiceType}. " +
                        //        $"Tried to go to URL --> {sanitizedUrl}. Skipping record.");
                        //    // Skip to next record as there's no opening times.
                        //    // Outputting debug above to allow for manual investigation.
                        //    continue;
                        //}
                        //// create a string reader, so that we can deserialize the content, later on to a strongly typed model. 
                        //var reader = new StringReader(openingTimesXmlElement.ToString());

                        //var serializer = new XmlSerializer(typeof(Models.NhsChoicesModel.OpeningTimes));

                        //var deserializedOpeningTimes = (Models.NhsChoicesModel.OpeningTimes)serializer.Deserialize(reader);




                        //// NOTE: Not run into this problem yet, so will leave for now.
                        //// OH OF COURSE! JS is loosely typed, so when it didn't hit an array/ multiple items it just created the single object. 
                        //// This *shouldn't* happen with .Net -- DAR 25/07/2018
                        ////------------------------------------------------------------------------------------------------
                        //// Shit NHS CHOICES data structure, means that some opening time value are stored under s_timesSessionType as an array,
                        //// Where other records are stored under s_timesSessionType.s_daysOfWeek as an array.
                        //// To resolve, we check the length of the sessionTypes.s_timesSessionType. -- DAR 17/03/2015
                        //if ((deserializedOpeningTimes.timesSessionTypes.Length >= 1))
                        //{
                        //    // so it looks like s_timesSessionType is an array.
                        //    // Lets see if we can see the properties
                        //    // of each object in each array.
                        //    // Only get the data for the reception.
                        //    // hac is also a gp surgery.
                        //    if (entity.ServiceType == Enums.ServiceType.Gp) //|| entity.ServiceType == Enums.ServiceType.HAC)
                        //    {
                        //        var receptionOpeningTimes = deserializedOpeningTimes.timesSessionTypes.FirstOrDefault(x => x.sessionType == "reception");


                        //        if (receptionOpeningTimes != null && !receptionOpeningTimes.daysOfWeek.IsNullOrEmpty())
                        //        {
                        //            var sundayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("sunday", StringComparison.InvariantCultureIgnoreCase));
                        //            var mondayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("monday", StringComparison.InvariantCultureIgnoreCase));
                        //            var tuesdayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("tuesday", StringComparison.InvariantCultureIgnoreCase));
                        //            var wednesdayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("wednesday", StringComparison.InvariantCultureIgnoreCase));
                        //            var thursdayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("thursday", StringComparison.InvariantCultureIgnoreCase));
                        //            var fridayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("friday", StringComparison.InvariantCultureIgnoreCase));
                        //            var saturdayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("saturday", StringComparison.InvariantCultureIgnoreCase));

                        //            var sundayOpeningTimes = this.ExtractOpeningTimeForDay(sundayOpeniningTimesRecord);
                        //            var mondayOpeningTimes = this.ExtractOpeningTimeForDay(mondayOpeniningTimesRecord);
                        //            var tuesdayOpeningTimes = this.ExtractOpeningTimeForDay(tuesdayOpeniningTimesRecord);
                        //            var wednesdayOpeningTimes = this.ExtractOpeningTimeForDay(wednesdayOpeniningTimesRecord);
                        //            var thursdayOpeningTimes = this.ExtractOpeningTimeForDay(thursdayOpeniningTimesRecord);
                        //            var fridayOpeningTimes = this.ExtractOpeningTimeForDay(fridayOpeniningTimesRecord);
                        //            var saturdayOpeningTimes = this.ExtractOpeningTimeForDay(saturdayOpeniningTimesRecord);

                        //            entity.UpdateOpeniningTimes(mondayOpeningTimes, tuesdayOpeningTimes, wednesdayOpeningTimes, thursdayOpeningTimes, fridayOpeningTimes, saturdayOpeningTimes, sundayOpeningTimes);

                        //            var didSucessfullyUpdatEntity = await App.DatabaseRepository.UpdateAsync(entity) >= 1;
                        //            if (didSucessfullyUpdatEntity)
                        //            {
                        //                System.Diagnostics.Debug.WriteLine($"Sucessfully updated entity id {entity.Id} with opening times.");
                        //            }
                        //            else
                        //            {
                        //                System.Diagnostics.Debug.WriteLine($"ERROR! FAILED TO UPDATE entity id {entity.Id} with opening times.");
                        //            }
                        //            continue;
                        //        }

                        //        //else
                        //        //{
                        //        //	throw new Exception("BRoke");
                        //        //}
                        //    }
                        //    else if (entity.ServiceType == Enums.ServiceType.Pharmacy)
                        //    {
                        //        // We want to take the 'general' values for pharmacies. 
                        //        var generalOpeningTimes = deserializedOpeningTimes.timesSessionTypes.FirstOrDefault(x => x.sessionType == "general");
                        //        if (generalOpeningTimes != null && !generalOpeningTimes.daysOfWeek.IsNullOrEmpty())
                        //        {
                        //            var sundayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("sunday", StringComparison.InvariantCultureIgnoreCase));
                        //            var mondayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("monday", StringComparison.InvariantCultureIgnoreCase));
                        //            var tuesdayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("tuesday", StringComparison.InvariantCultureIgnoreCase));
                        //            var wednesdayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("wednesday", StringComparison.InvariantCultureIgnoreCase));
                        //            var thursdayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("thursday", StringComparison.InvariantCultureIgnoreCase));
                        //            var fridayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("friday", StringComparison.InvariantCultureIgnoreCase));
                        //            var saturdayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("saturday", StringComparison.InvariantCultureIgnoreCase));

                        //            var sundayOpeningTimes = this.ExtractOpeningTimeForDay(sundayOpeniningTimesRecord);
                        //            var mondayOpeningTimes = this.ExtractOpeningTimeForDay(mondayOpeniningTimesRecord);
                        //            var tuesdayOpeningTimes = this.ExtractOpeningTimeForDay(tuesdayOpeniningTimesRecord);
                        //            var wednesdayOpeningTimes = this.ExtractOpeningTimeForDay(wednesdayOpeniningTimesRecord);
                        //            var thursdayOpeningTimes = this.ExtractOpeningTimeForDay(thursdayOpeniningTimesRecord);
                        //            var fridayOpeningTimes = this.ExtractOpeningTimeForDay(fridayOpeniningTimesRecord);
                        //            var saturdayOpeningTimes = this.ExtractOpeningTimeForDay(saturdayOpeniningTimesRecord);

                        //            entity.UpdateOpeniningTimes(mondayOpeningTimes, tuesdayOpeningTimes, wednesdayOpeningTimes, thursdayOpeningTimes, fridayOpeningTimes, saturdayOpeningTimes, sundayOpeningTimes);

                        //            var didSucessfullyUpdatEntity = await App.DatabaseRepository.UpdateAsync(entity) >= 1;
                        //            if (didSucessfullyUpdatEntity)
                        //            {
                        //                System.Diagnostics.Debug.WriteLine($"Sucessfully updated entity id {entity.Id} with opening times.");
                        //            }
                        //            else
                        //            {
                        //                System.Diagnostics.Debug.WriteLine($"ERROR! FAILED TO UPDATE entity id {entity.Id} with opening times.");
                        //            }
                        //            continue;
                        //        }
                        //        //else
                        //        //{
                        //        //	throw new Exception("BRoke");
                        //        //}
                        //    }
                        //}
                        // NOTE: Not run into this problem yet, so will leave for now.
                        // OH OF COURSE! JS is loosely typed, so when it didn't hit an array/ multiple items it just created the single object. 
                        // This *shouldn't* happen with .Net 
                        //else
                        //{
                        //	// This is usually for the majority of pharmacies, however it could be for gp's as well.
                        //	// s_timesSessionType is not an array in this case.

                        //}

                        //var mondayOpeningTime = deserializedOpeningTimes.timesSessionTypes.FirstOrDefault(x => x.sessionType == "Surgery")



                    }
                    catch (Exception ex)
                    {
                        System.Diagnostics.Debug.WriteLine($"Error >> {ex}");
                    }

                }

            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine($"Error >> {ex}");
            }

        }



        private string ExtractOpeningTimeForDay(Models.NhsChoicesModel.openingTimesTimesSessionTypeDayOfWeek dayOfWeekModel)
        {
            if (dayOfWeekModel != null)
            {
                if (dayOfWeekModel != null
                    // Time sessions are an array in NHS Choices markup.
                    // The sample I used to generate the Model must've been a singular value, so I've corrected this now.
                    // -- DAR 13/02/2019
                    && !dayOfWeekModel.timesSessions.IsNullOrEmpty())
                //&& !string.IsNullOrWhiteSpace(dayOfWeekModel.timesSessions.timesSession.fromTime)
                //&& !string.IsNullOrWhiteSpace(dayOfWeekModel.timesSessions.timesSession.toTime))
                {
                    var openingTimes = new List<string>();
                    foreach (var timeSession in dayOfWeekModel.timesSessions)
                    {
                        if (timeSession != null)
                        {

                            // if BOTH 'from' and 'to' times ARE NOT empty, then use these.
                            if (!string.IsNullOrWhiteSpace(timeSession.fromTime)
                            && !string.IsNullOrWhiteSpace(timeSession.toTime))
                            {
                                openingTimes.Add($"{timeSession.fromTime} - {timeSession.toTime}");
                            }
                            // If 'from' time is NOT empty BUT 'to' time IS empty then append from time
                            else if (!string.IsNullOrWhiteSpace(timeSession.fromTime)
                                    && string.IsNullOrWhiteSpace(timeSession.toTime))
                            {
                                openingTimes.Add($"{timeSession.fromTime}");
                            }
                            // If 'from' time IS empty BUT 'to' time is NOT empty then append from time
                            else if (string.IsNullOrWhiteSpace(timeSession.fromTime)
                                     && !string.IsNullOrWhiteSpace(timeSession.toTime))
                            {
                                openingTimes.Add($"{timeSession.toTime}");
                            }
                            // if BOTH 'from' and 'to' times ARE empty, then check the 'text' value. 
                            else if (!timeSession.Text.IsNullOrEmpty())
                            {
                                openingTimes.Add($"{timeSession.Text?.FirstOrDefault()}"); // Take the first value.
                            }
                        }
                    }

                    return (!openingTimes.IsNullOrEmpty()) ? string.Join("\n", openingTimes) : string.Empty;
                    //return $"{dayOfWeekModel.timesSessions.timesSession.fromTime} - {dayOfWeekModel.timesSessions.timesSession.toTime}";
                }
                // This is usually if the pharmacy is closed on this date.
                return dayOfWeekModel?.timesSessions?.FirstOrDefault()?.Text?.FirstOrDefault() ??
                       string.Empty;
                //return dayOfWeekModel.timesSessions.timesSession.Text.FirstOrDefault();
            }
            return string.Empty;
        }





        #endregion

        #region Static data/ organisations		
        // TODO: not used?
        //        /// <summary>
        //        /// Generates and inserts the static organisations asynchronous.
        //        /// </summary>
        //        /// <returns></returns>
        //        public async Task GenerateAndInsertStaticOrganisationsAsync(int userLocationId)
        //        {
        //            var staticOrganisationsToInsert = new List<DAL.Entities.NhsChoicesData>();
        //            // Load the static organisations from the file. 
        //            var organisationsDataToDeserialize = string.Empty;
        //            try
        //            {
        //                var assembly = IntrospectionExtensions.GetTypeInfo(typeof(NhsChoicesService)).Assembly;
        //                Stream stream = assembly.GetManifestResourceStream("GloucesterAsap.Forms.ConditionsData.StaticOrganisations.txt");
        //                using (var reader = new System.IO.StreamReader(stream))
        //                {
        //                    organisationsDataToDeserialize = reader.ReadToEnd();
        //                }

        //            }
        //            catch (Exception ex)
        //            {
        //                System.Diagnostics.Debug.WriteLine($"Got an exception when trying to read conditions file. Exception --> {ex}");
        //#if DEBUG
        //				throw;
        //#endif
        //            }

        //            if (!string.IsNullOrWhiteSpace(organisationsDataToDeserialize))
        //            {
        //                staticOrganisationsToInsert = JsonConvert.DeserializeObject<List<DAL.Entities.NhsChoicesData>>(organisationsDataToDeserialize);
        //            }


        //            var locationService = App.DependencyServiceResolver.Get<Services.Interfaces.ILocationService>()
        //                ?? throw new Exception($"Could not resolve {nameof(Services.Interfaces.ILocationService)}");

        //            var geoLocationService = App.DependencyServiceResolver.Get<Forms.PlatformSpecificInterfaces.IGeoLocationService>()
        //                    ?? throw new Exception($"Could not resolve {nameof(Forms.PlatformSpecificInterfaces.IGeoLocationService)}");


        //            var matchingUserLocationEntityById = await App.DatabaseRepository.GetFirstOrDefaultAsync<DAL.Entities.UserLocation>(x => x.Id == userLocationId);

        //            var fromLocationModel = new Models.LatLongModel(matchingUserLocationEntityById.Latitude, matchingUserLocationEntityById.Longitude);

        //            // now, we need to get the latlong from the postcodes. 
        //            foreach (var staticOrganisationToInsert in staticOrganisationsToInsert)
        //            {
        //                var latLongForOrganisation = await locationService.ConvertPostcodeToLatLongAsync(staticOrganisationToInsert.PostCode);
        //                if (latLongForOrganisation == null)
        //                {
        //                    throw new Exception($"Could not get lat long for static organisaion with the name of {staticOrganisationToInsert.Name}");
        //                }

        //                staticOrganisationToInsert.Latitude = latLongForOrganisation.Latitude;
        //                staticOrganisationToInsert.Longitude = latLongForOrganisation.Longitude;

        //                staticOrganisationToInsert.UserLocationId = userLocationId;

        //                var toLocationModel = new Models.LatLongModel(latLongForOrganisation.Latitude, latLongForOrganisation.Longitude);

        //                // Get the distance between the two locations.
        //                staticOrganisationToInsert.Distance = await geoLocationService.GetDistanceBetweenTwoLocationsAsync(fromLocationModel, toLocationModel);

        //                // Next, we need to get the distance between the two points. 

        //                await App.DatabaseRepository.SaveAsync<DAL.Entities.NhsChoicesData>(staticOrganisationToInsert);
        //            }

        //        }

        #endregion


        #region private helpers		

        private string BaseNhsChoicesUrl => _configurationReader.GetConfigValueFromFile("NhsChoicesApiUrl");

        private string NhsChoicesApiKey => _configurationReader.GetConfigValueFromFile("NhsChoicesApiKey");


        private string GetAddressLineForIndex(string[] addresses, int index)
        {
            if (index < addresses.Length)
            {
                return addresses[index];
            }
            return string.Empty;
        }







        #endregion


    }
}

​x
 
using Newtonsoft.Json;
using GloucesterAsap.Forms.Extensions;
using GloucesterAsap.Forms.PlatformSpecificInterfaces;
using GloucesterAsap.Forms.Services.Interfaces;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using System.Text;
using System.Xml.Linq;
using System.Xml.Serialization;
using System.Net.Http;
​
namespace GloucesterAsap.Forms.Services
{
    public class NhsChoicesService : Interfaces.INhsChoicesService
    {
​
        //Defining the classes that will hold new NHS Choices API returned data
        public class Rootobject
        {
            public int odatacount { get; set; }
            public Value[] value { get; set; }
            public string tracking { get; set; }
        }
​
        public class Value
        {
            public float searchscore { get; set; }
            public string OrganisationID { get; set; }
            public string OrganisationName { get; set; }
            public string[] OrganisationAliases { get; set; }
            public string OrganisationTypeID { get; set; }
            public string OrganisationType { get; set; }
            public string OrganisationStatus { get; set; }
            public bool IsPimsManaged { get; set; }
            public string PIMSCode { get; set; }
            public string NACSCode { get; set; }
            public object LocalAuthorityCode { get; set; }
            public string SummaryText { get; set; }
            public string URL { get; set; }
            public string Address1 { get; set; }
            public string Address2 { get; set; }
            public string Address3 { get; set; }
            public string City { get; set; }
            public string County { get; set; }
            public decimal Latitude { get; set; }
            public decimal Longitude { get; set; }
            public string OrganisationSubType { get; set; }
            public DateTime LastUpdatedDate { get; set; }
            public string Postcode { get; set; }
            public Geocode Geocode { get; set; }
            public string[] CCG { get; set; }
            public object[] RelatedIAPTCCGs { get; set; }
            public object[] Trusts { get; set; }
            public object[] CCGLocalAuthority { get; set; }
            public string[] ServicesOffered { get; set; }
            public string[] ServicesProvided { get; set; }
            public string[] ServiceCodesProvided { get; set; }
            public string[] ServicesProvidedConditions { get; set; }
            public string[] OrgTypeConditions { get; set; }
            public string OpeningTimes { get; set; }
            public string Contacts { get; set; }
            public object VenueType { get; set; }
            public string Metrics { get; set; }
            public object GSD { get; set; }
            public Openingtimesv2[] OpeningTimesV2 { get; set; }
            public float distanceMiles { get; set; }
        }
​
        public class Geocode
        {
            public string type { get; set; }
            public float[] coordinates { get; set; }
            public Crs crs { get; set; }
        }
​
        public class Crs
        {
            public string type { get; set; }
            public Properties properties { get; set; }
        }
​
        public class Properties
        {
            public string name { get; set; }
        }
​
        public class Openingtimesv2
        {
            public string Weekday { get; set; }
            public string Times { get; set; }
            public int OffsetOpeningTime { get; set; }
            public int OffsetClosingTime { get; set; }
            public string OpeningTimeType { get; set; }
            public string AdditionalOpeningDate { get; set; }
            public bool IsOpen { get; set; }
        }
​
        public class ContactsArray
        {
            public string OrganisationContactType { get; set; }
            public string OrganisationContactAvailabilityType { get; set; }
            public string OrganisationContactMethodType { get; set; }
            public string OrganisationContactValue { get; set; }
        }
​
        public class ContactsRoot
        {
            public List<ContactsArray> ContactsArray { get; set; }
        }
        //End of classes
​
​
​
​
​
​
​
​
​
        private readonly IConfigurationReader _configurationReader;
        private readonly INetworkConnection _networkConnection;
        public NhsChoicesService()
        {
            _configurationReader = App.DependencyServiceResolver.Get<IConfigurationReader>(Xamarin.Forms.DependencyFetchTarget.GlobalInstance) ?? throw new Exception($"Failed to resolve {nameof(IConfigurationReader)}");
            _networkConnection = App.DependencyServiceResolver.Get<INetworkConnection>() ?? throw new Exception($"Failed to resolve {nameof(INetworkConnection)}");
        }
​
        /// <summary>
        /// Fetches the NHS choices data for user location asynchronous.
        /// </summary>
        /// <param name="postcode">The postcode.</param>
        /// <param name="userLocationId">The user location identifier.</param>
        /// <returns></returns>
        /// <exception cref="ArgumentNullException">postcode</exception>
        public async Task<bool> FetchNhsChoicesDataForUserLocationAsync(string postcode, int userLocationId)
        {
            if (string.IsNullOrWhiteSpace(postcode))
            {
                throw new ArgumentNullException($"{nameof(postcode)}");
            }
            if (!await _networkConnection.HasNetworkConnectionAsync())
            {
​
                System.Diagnostics.Debug.WriteLine("Detected no internet connection.");
                return false;
            }
​
            try
            {
                await this.GetGpPracticesByPostcodeAndStoreInTableAsync(postcode, userLocationId);
​
                await this.GetPharmaciesByPostcodeAndStoreInTableAsync(postcode, userLocationId);
​
​
                // Actually, Hospitals are statically inserted as they're local to their area and the client has chosen specific ones. 
                //await this.GetHospitalsByPostcodeAndStoreInTableAsync(postcode, userLocationId);
​
​
                await this.FetchOpeningTimesForAllOrganisationsAsync(userLocationId);
​
​
                // This is now done on the fly, and the app reads the StaticOrganisations file,
                // when a specific service type is selected. 
                // -- DAR 10/09/2018
                // we have to insert some static records for organisations. 
                // Run this after fteching the opening times for the NHS choices records. 
                //  await this.GenerateAndInsertStaticOrganisationsAsync(userLocationId);
​
​
                return true;
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine($"Exception throw when trying to download NHS choices data {ex}");
            }
​
            return false;
        }
​
​
​
        /// <summary>
        /// Returns wether there is any NHS choices data for the location asynchronous.
        /// </summary>
        /// <param name="locationId">The location identifier.</param>
        /// <returns></returns>
        public async Task<bool> DoesNhsChoicesDataExistForLocationAsync(int locationId)
        {
            return await App.DatabaseRepository.AnyAsync<DAL.Entities.NhsChoicesData>(x => x.UserLocationId == locationId);
        }
​
​
        /// <summary>
        /// Deletes the NHS choices data for the location asynchronous.
        /// </summary>
        /// <param name="locationId">The location identifier.</param>
        /// <returns></returns>
        public async Task<bool> DeleteNhsChoicesDataForLocationAsync(int locationId)
        {
            // Step 1) Check to see if there's any nhs choices entities for this record. 
            if (await this.DoesNhsChoicesDataExistForLocationAsync(locationId))
            {
                // Step 2) We have related choices entities. Now we need to delete them. 
                var matchingLocationById = await App.DatabaseRepository.GetFirstOrDefaultAsync<DAL.Entities.UserLocation>(x => x.Id == locationId);
                if (matchingLocationById != null)
                {
                    // Now, we need to get the related NHS choices data. 
                    var relatedNhsChoicesDataForLocation = await matchingLocationById.GetAllRelatedNhsChoicesDataForThisLocationAsync();
                    if (!relatedNhsChoicesDataForLocation.IsNullOrEmpty())
                    {
                        return await App.DatabaseRepository.DeleteAsync(relatedNhsChoicesDataForLocation) >= 1;
                    }
                }
            }
            else
            {
                // There's no records, so just return true. 
                return true;
            }
            return false;
        }
​
​
​
        #region Organisation fetches and inserts
​
​
        /// <summary>
        /// Gets the gp practices by postcode and store in table asynchronous.
        /// </summary>
        /// <param name="postcode">The postcode.</param>
        /// <param name="userLocationId">The user location identifier.</param>
        /// <returns></returns>
        /// <exception cref="Exception">
        /// xmlDataForGpPractices
        /// or
        /// GpPracticesModel
        /// </exception>
        private async Task GetGpPracticesByPostcodeAndStoreInTableAsync(string postcode, long userLocationId)
        {
​
            //Lets create a new URL for the new ChoicesAPI - Grabbing URL from config file
            var path = "https://api.nhs.uk/service-search/search-postcode-or-place?api-version=1&search=" + postcode;
​
            //Grab the subscription key from the config file
            var subscriptionKey = "cdadee486e564c2dbe2d85b8c29bc7fb";
​
            //Filter depending on querying for GP or Pharmacy
            var gpFilterQuery = "OrganisationTypeID eq 'GPB'";
​
            var queryBodyContent = JsonConvert.SerializeObject(
                new
                {
                    filter = gpFilterQuery,
                    top = "25",
                    skip = "0",
                    count = true
                });
​
            var data = new StringContent(queryBodyContent, Encoding.UTF8, "application/json");
​
            using (var client = new HttpClient())
            {
                client.DefaultRequestHeaders.Add("subscription-key", subscriptionKey);
                var response = client.PostAsync(path, data).Result.Content.ReadAsStringAsync().Result;
​
                dynamic deserialisedObj = JsonConvert.DeserializeObject(response);
                //The result
                var result = deserialisedObj;
                //Map the values to our model classes above..
                Rootobject rootobject = JsonConvert.DeserializeObject<Rootobject>(response);
​
                //Now loop through the rootobject values and assign them to variables
                foreach (var item in rootobject.value)
                {
                    //We need item id, item title, ods code, address 1,2,3,4, postcode, distance, tel, lat, long
                    var orgId = item.OrganisationID;
                    var nacs = item.NACSCode;
                    var orgName = (!item.OrganisationAliases.IsNullOrEmpty() && item.OrganisationAliases.Any()) ? item.OrganisationAliases.First() : item.OrganisationName;
                    var odsCode = item.OrganisationID;
                    var addressLine1 = item.Address1;
                    var addressLine2 = item.Address2;
                    var addressLine3 = item.Address3;
                    var orgPostcode = item.Postcode;
                    var distanceInMiles = item.distanceMiles;
                    string telephone = null;
                    var orgLong = item.Longitude;
                    var orgLat = item.Latitude;
​
                    if (!string.IsNullOrEmpty(item.Contacts))
                    {
                        var contacts = JsonConvert.DeserializeObject<List<ContactsArray>>(item.Contacts);
                        foreach (var contact in contacts)
                        {
                            var contactMethodType = contact.OrganisationContactMethodType;
                            var contactValue = contact.OrganisationContactValue;
                            if (contactMethodType == "Telephone" && !string.IsNullOrWhiteSpace(contactValue))
                            {
                                telephone = contactValue;
                            }
                        }
                    }
​
                    var entityToSave = new DAL.Entities.NhsChoicesData(orgId, orgName,
                        nacs,
                        addressLine1, addressLine2, addressLine3, null,
                        orgPostcode, distanceInMiles, telephone, Enums.ServiceType.Gp, orgLat, orgLong, userLocationId);
​
                    var numberOfSavedRecords = await App.DatabaseRepository.SaveAsync(entityToSave);
                    System.Diagnostics.Debug.WriteLine($"Saved {numberOfSavedRecords} GP practice records.");
                }
            }
​
​
​
            //var fullyQualifiedUrl = $"{this.BaseNhsChoicesUrl}/organisations/gppractices/postcode/{postcode}.xml?apikey={this.NhsChoicesApiKey}&range=100";
​
            //var xmlDataForGpPractices = await Helpers.WebRequestHelpers.LoadXmlStringFromUrlAsync(fullyQualifiedUrl);
            //if (string.IsNullOrWhiteSpace(xmlDataForGpPractices))
            //{
            //    throw new Exception($"returned value for {nameof(xmlDataForGpPractices)} was null or whitespace.");
            //}
​
            //var deserializedXml = Helpers.SerializeHelper.DeserializeXmlToObject<Models.NhsChoicesModel.GpPracticesModel>(xmlDataForGpPractices);
            //if (deserializedXml == null || deserializedXml.EntryLinks.IsNullOrEmpty())
            //{
            //    throw new Exception($"Failed to deserialize the XML to an object type of {nameof(Models.NhsChoicesModel.GpPracticesModel)}");
            //}
​
            //foreach (var item in deserializedXml.EntryLinks)
            //{
            //    var content = item.Content;
            //    var organisationSummary = content.OrganisationSummary;
            //    var addressInformation = organisationSummary.address;
            //    var geographyInformation = organisationSummary.GeographicCoordinates;
​
            //    var telephoneNumber = organisationSummary?.SummaryContactInformation?.TelephoneNumber ?? string.Empty;
​
            //    var addressLine1 = this.GetAddressLineForIndex(addressInformation?.addressLine, 0);
            //    var addressLine2 = this.GetAddressLineForIndex(addressInformation?.addressLine, 1);
            //    var addressLine3 = this.GetAddressLineForIndex(addressInformation?.addressLine, 2);
            //    var addressLine4 = this.GetAddressLineForIndex(addressInformation?.addressLine, 3);
​
            //    var entityToSave = new DAL.Entities.NhsChoicesData(item.Id, item.Title,
            //        organisationSummary.ODSCode,
            //        addressLine1, addressLine2, addressLine3, addressLine4,
            //        addressInformation.postcode, organisationSummary.Distance, telephoneNumber, Enums.ServiceType.Gp, geographyInformation.Latitude, geographyInformation.Longitude, userLocationId);
​
            //    var numberOfSavedRecords = await App.DatabaseRepository.SaveAsync(entityToSave);
            //    System.Diagnostics.Debug.WriteLine($"Saved {numberOfSavedRecords} GP practice records.");
​
            //}
​
​
        }
​
        /// <summary>
        /// Gets the pharmacies by postcode and store in table asynchronous.
        /// </summary>
        /// <param name="postcode">The postcode.</param>
        /// <param name="userLocationId">The user location identifier.</param>
        /// <returns></returns>
        /// <exception cref="Exception">
        /// xmlDataForGpPractices
        /// or
        /// PharmaciesModel
        /// </exception>
        private async Task GetPharmaciesByPostcodeAndStoreInTableAsync(string postcode, long userLocationId)
        {
            //Lets create a new URL for the new ChoicesAPI - Grabbing URL from config file
            var path = "https://api.nhs.uk/service-search/search-postcode-or-place?api-version=1&search=" + postcode;
​
            //Grab the subscription key from the config file
            var subscriptionKey = "cdadee486e564c2dbe2d85b8c29bc7fb";
​
            //Filter depending on querying for GP or Pharmacy
            var pharmaFilterQuery = "OrganisationTypeID eq 'PHA'";
​
            var queryBodyContent = JsonConvert.SerializeObject(
                new
                {
                    filter = pharmaFilterQuery,
                    top = "25",
                    skip = "0",
                    count = true
                });
​
            var data = new StringContent(queryBodyContent, Encoding.UTF8, "application/json");
​
            using (var client = new HttpClient())
            {
                client.DefaultRequestHeaders.Add("subscription-key", subscriptionKey);
                var response = client.PostAsync(path, data).Result.Content.ReadAsStringAsync().Result;
​
                dynamic deserialisedObj = JsonConvert.DeserializeObject(response);
                //The result
                var result = deserialisedObj;
                //Map the values to our model classes above..
                Rootobject rootobject = JsonConvert.DeserializeObject<Rootobject>(response);
​
                //Now loop through the rootobject values and assign them to variables
                foreach (var item in rootobject.value)
                {
                    //We need item id, item title, ods code, address 1,2,3,4, postcode, distance, tel, lat, long
                    var orgId = item.OrganisationID;
                    var nacs = item.NACSCode;
                    var orgName = (!item.OrganisationAliases.IsNullOrEmpty() && item.OrganisationAliases.Any()) ? item.OrganisationAliases.First() : item.OrganisationName;
                    var odsCode = item.OrganisationID;
                    var addressLine1 = item.Address1;
                    var addressLine2 = item.Address2;
                    var addressLine3 = item.Address3;
                    var orgPostcode = item.Postcode;
                    var distanceInMiles = item.distanceMiles;
                    string telephone = null;
                    var orgLong = item.Longitude;
                    var orgLat = item.Latitude;
​
                    if (!string.IsNullOrEmpty(item.Contacts))
                    {
                        var contacts = JsonConvert.DeserializeObject<List<ContactsArray>>(item.Contacts);
                        foreach (var contact in contacts)
                        {
                            var contactMethodType = contact.OrganisationContactMethodType;
                            var contactValue = contact.OrganisationContactValue;
                            if (contactMethodType == "Telephone" && !string.IsNullOrWhiteSpace(contactValue))
                            {
                                telephone = contactValue;
                            }
                        }
                    }
​
                    var entityToSave = new DAL.Entities.NhsChoicesData(orgId, orgName,
                        nacs,
                        addressLine1, addressLine2, addressLine3, null,
                        orgPostcode, distanceInMiles, telephone, Enums.ServiceType.Pharmacy, orgLat, orgLong, userLocationId);
​
                    var numberOfSavedRecords = await App.DatabaseRepository.SaveAsync(entityToSave);
                    System.Diagnostics.Debug.WriteLine($"Saved {numberOfSavedRecords} {nameof(Enums.ServiceType.Pharmacy)} records.");
                }
            }
​
​
​
            //var fullyQualifiedUrl = $"{this.BaseNhsChoicesUrl}/organisations/pharmacies/postcode/{postcode}.xml?apikey={this.NhsChoicesApiKey}&range=100";
​
            //var xmlDataForGpPractices = await Helpers.WebRequestHelpers.LoadXmlStringFromUrlAsync(fullyQualifiedUrl);
            //if (string.IsNullOrWhiteSpace(xmlDataForGpPractices))
            //{
            //    throw new Exception($"returned value for {nameof(xmlDataForGpPractices)} was null or whitespace.");
            //}
​
            //var deserializedXml = Helpers.SerializeHelper.DeserializeXmlToObject<Models.NhsChoicesModel.PharmaciesModel>(xmlDataForGpPractices);
            //if (deserializedXml == null || deserializedXml.EntryLinks.IsNullOrEmpty())
            //{
            //    throw new Exception($"Failed to deserialize the XML to an object type of {nameof(Models.NhsChoicesModel.PharmaciesModel)}");
            //}
​
            //foreach (var item in deserializedXml.EntryLinks)
            //{
            //    var content = item.Content;
            //    var organisationSummary = content.OrganisationSummary;
            //    var addressInformation = organisationSummary.address;
            //    var geographyInformation = organisationSummary.GeographicCoordinates;
​
            //    var telephoneNumber = organisationSummary?.SummaryContactInformation?.TelephoneNumber ?? string.Empty;
​
            //    var addressLine1 = this.GetAddressLineForIndex(addressInformation?.addressLine, 0);
            //    var addressLine2 = this.GetAddressLineForIndex(addressInformation?.addressLine, 1);
            //    var addressLine3 = this.GetAddressLineForIndex(addressInformation?.addressLine, 2);
            //    var addressLine4 = this.GetAddressLineForIndex(addressInformation?.addressLine, 3);
​
            //    var entityToSave = new DAL.Entities.NhsChoicesData(item.Id, item.Title,
            //        organisationSummary.ODSCode,
            //        addressLine1, addressLine2, addressLine3, addressLine4,
            //        addressInformation.postcode, organisationSummary.Distance, telephoneNumber, Enums.ServiceType.Pharmacy, geographyInformation.Latitude, geographyInformation.Longitude, userLocationId);
​
            //    var numberOfSavedRecords = await App.DatabaseRepository.SaveAsync(entityToSave);
            //    System.Diagnostics.Debug.WriteLine($"Saved {numberOfSavedRecords} {nameof(Enums.ServiceType.Pharmacy)} records.");
​
            //}
​
​
        }
​
​
        /// <summary>
        /// Gets the hospitals by postcode and store in table asynchronous.
        /// </summary>
        /// <param name="postcode">The postcode.</param>
        /// <param name="userLocationId">The user location identifier.</param>
        /// <returns></returns>
        /// <exception cref="Exception">
        /// xmlDataForGpPractices
        /// or
        /// HospitalModel
        /// </exception>
        private async Task GetHospitalsByPostcodeAndStoreInTableAsync(string postcode, long userLocationId)
        {
            var fullyQualifiedUrl = $"{this.BaseNhsChoicesUrl}/organisations/hospitals/postcode/{postcode}.xml?apikey={this.NhsChoicesApiKey}&range=100";
​
            var xmlDataForGpPractices = await Helpers.WebRequestHelpers.LoadXmlStringFromUrlAsync(fullyQualifiedUrl);
            if (string.IsNullOrWhiteSpace(xmlDataForGpPractices))
            {
                throw new Exception($"returned value for {nameof(xmlDataForGpPractices)} was null or whitespace.");
            }
​
            var deserializedXml = Helpers.SerializeHelper.DeserializeXmlToObject<Models.NhsChoicesModel.HospitalModel>(xmlDataForGpPractices);
            if (deserializedXml == null || deserializedXml.EntryLinks.IsNullOrEmpty())
            {
                throw new Exception($"Failed to deserialize the XML to an object type of {nameof(Models.NhsChoicesModel.HospitalModel)}");
            }
​
            foreach (var item in deserializedXml.EntryLinks)
            {
                var content = item.Content;
                var organisationSummary = content.OrganisationSummary;
                var addressInformation = organisationSummary.address;
                var geographyInformation = organisationSummary.GeographicCoordinates;
​
                var telephoneNumber = organisationSummary?.SummaryContactInformation?.TelephoneNumber ?? string.Empty;
​
                var addressLine1 = this.GetAddressLineForIndex(addressInformation?.addressLine, 0);
                var addressLine2 = this.GetAddressLineForIndex(addressInformation?.addressLine, 1);
                var addressLine3 = this.GetAddressLineForIndex(addressInformation?.addressLine, 2);
                var addressLine4 = this.GetAddressLineForIndex(addressInformation?.addressLine, 3);
​
                var entityToSave = new DAL.Entities.NhsChoicesData(item.Id, item.Title,
                    organisationSummary.ODSCode,
                    addressLine1, addressLine2, addressLine3, addressLine4,
                    addressInformation.postcode, organisationSummary.Distance, telephoneNumber, Enums.ServiceType.Hospital, geographyInformation.Latitude, geographyInformation.Longitude, userLocationId);
​
                var numberOfSavedRecords = await App.DatabaseRepository.SaveAsync(entityToSave);
                System.Diagnostics.Debug.WriteLine($"Saved {numberOfSavedRecords} {nameof(Enums.ServiceType.Hospital)} records.");
            }
​
​
        }
​
        #endregion
​
​
        #region Opening times fetch
        private async Task FetchOpeningTimesForAllOrganisationsAsync(int userLocationId)
        {
            // Step 1) Fetch all the records we've inserted. 
            var allOrganisationEntitiesFromLocalDbForLocationId = await App.DatabaseRepository.GetAllAsync<DAL.Entities.NhsChoicesData>(x => x.UserLocationId == userLocationId);
​
            try
            {
​
​
​
                // Step 2) Enumerate through each record, and fetch the opening times. 
                foreach (var entity in allOrganisationEntitiesFromLocalDbForLocationId)
                {
                    try
                    {
​
​
​
                        if (string.IsNullOrWhiteSpace(entity.ChoicesUrl))
                        {
                            System.Diagnostics.Debug.WriteLine($"Error! NhsChoicesData entity did not have a valid value  {nameof(entity.ChoicesUrl)} for id --> {entity.Id}. Skipping to next record.");
                            continue;
                        }
                        if (entity.ServiceType == Enums.ServiceType.Hospital)
                        {
                            continue; // Skip the current entity as a Hospital is always 24 hours. 
                        }
​
                        // Get the opening times
                        var nacs = entity.OdsCode;
​
                        //Lets create a new URL for the new ChoicesAPI - Grabbing URL from config file
                        var path = "https://api.nhs.uk/service-search/search?api-version=1";
​
                        //Grab the subscription key from the config file
                        var subscriptionKey = "cdadee486e564c2dbe2d85b8c29bc7fb";
​
                        var filterQuery = "NACSCode eq '" + nacs + "'";
​
                        var queryBodyContent = JsonConvert.SerializeObject(
                            new
                            {
                                filter = filterQuery,
                                select = "OpeningTimesV2",
                                top = "1",
                                skip = "0",
                                count = true
                            });
​
                        var data = new StringContent(queryBodyContent, Encoding.UTF8, "application/json");
​
                        using (var client = new HttpClient())
                        {
                            client.DefaultRequestHeaders.Add("subscription-key", subscriptionKey);
                            var response = client.PostAsync(path, data).Result.Content.ReadAsStringAsync().Result;
​
                            dynamic deserialisedObj = JsonConvert.DeserializeObject(response);
                            //The result
                            var result = deserialisedObj;
                            //Map the values to our model classes above..
                            //To replicate the functionality of v1 on this, we first deserialise the result to a model
                            Rootobject rootobject = JsonConvert.DeserializeObject<Rootobject>(response);
                            if (!rootobject.value.IsNullOrEmpty())
                            {
​
                                //Now loop through our API results
                                foreach (var item in rootobject.value)
                                {
                                    //Then we check the entity has openingtimesv2
                                    if (!item.OpeningTimesV2.IsNullOrEmpty() && item.OpeningTimesV2.Any())
                                    {
                                        //Now we check if the entity is a GP or PHA, IF GP use reception times PHA use surgery times
                                        if (entity.ServiceType == Enums.ServiceType.Gp)
                                        {
                                            //Times for GPs
                                            //Get reception times
                                            var receptionTimes = item.OpeningTimesV2.Where(x => x.OpeningTimeType == "Reception");
                                            var rectest = receptionTimes.Any();
                                            var tst = rectest;
                                            var mondayTimes = receptionTimes.Where(x => x.Weekday == "Monday");
                                            var tuesdayTimes = receptionTimes.Where(x => x.Weekday == "Tuesday");
                                            var wednesdayTimes = receptionTimes.Where(x => x.Weekday == "Wednesday");
                                            var thursdayTimes = receptionTimes.Where(x => x.Weekday == "Thursday");
                                            var fridayTimes = receptionTimes.Where(x => x.Weekday == "Friday");
                                            var saturdayTimes = receptionTimes.Where(x => x.Weekday == "Saturday");
                                            var sundayTimes = receptionTimes.Where(x => x.Weekday == "Sunday");
                                            string mondayOpeningTimes = null; string tuesdayOpeningTimes = null; string wednesdayOpeningTimes = null; string thursdayOpeningTimes = null; string fridayOpeningTimes = null; string saturdayOpeningTimes = null; string sundayOpeningTimes = null;
                                            //If we have multiple times for these days, this usually means the time is split into morning and afternoon times, so we concat
​
​
                                            if (mondayTimes.Any() && mondayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in mondayTimes)
                                                {
                                                    mondayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (mondayTimes.Any()) { mondayOpeningTimes = mondayTimes?.FirstOrDefault().Times; }
​
                                            if (tuesdayTimes.Any() && tuesdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in tuesdayTimes)
                                                {
                                                    tuesdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (tuesdayTimes.Any()) { tuesdayOpeningTimes = tuesdayTimes?.FirstOrDefault().Times; }
​
                                            if (wednesdayTimes.Any() && wednesdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in wednesdayTimes)
                                                {
                                                    wednesdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (wednesdayTimes.Any()) { wednesdayOpeningTimes = wednesdayTimes?.FirstOrDefault().Times; }
​
                                            if (thursdayTimes.Any() && thursdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in thursdayTimes)
                                                {
                                                    thursdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (thursdayTimes.Any()) { thursdayOpeningTimes = thursdayTimes?.FirstOrDefault().Times; }
​
                                            if (fridayTimes.Any() && fridayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in fridayTimes)
                                                {
                                                    fridayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (fridayTimes.Any()) { fridayOpeningTimes = fridayTimes?.FirstOrDefault().Times; }
​
                                            if (saturdayTimes.Any() && saturdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in saturdayTimes)
                                                {
                                                    saturdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (saturdayTimes.Any()) { saturdayOpeningTimes = saturdayTimes?.FirstOrDefault().Times; }
​
                                            if (sundayTimes.Any() && sundayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in sundayTimes)
                                                {
                                                    sundayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (sundayTimes.Any()) { sundayOpeningTimes = sundayTimes?.FirstOrDefault().Times; }
​
​
                                            entity.UpdateOpeniningTimes(mondayOpeningTimes, tuesdayOpeningTimes, wednesdayOpeningTimes, thursdayOpeningTimes, fridayOpeningTimes, saturdayOpeningTimes, sundayOpeningTimes);
​
                                            var didSucessfullyUpdatEntity = await App.DatabaseRepository.UpdateAsync(entity) >= 1;
                                            if (didSucessfullyUpdatEntity)
                                            {
                                                System.Diagnostics.Debug.WriteLine($"Sucessfully updated entity id {entity.Id} with reception opening times.");
                                            }
                                            else
                                            {
                                                System.Diagnostics.Debug.WriteLine($"ERROR! FAILED TO UPDATE entity id {entity.Id} with reception opening times.");
                                            }
​
                                            continue;
​
                                        }
                                        else if (entity.ServiceType == Enums.ServiceType.Pharmacy)
                                        {
​
                                            //Times for pharmacies
                                            //Get general times
                                            var generalTimes = item.OpeningTimesV2.Where(x => x.OpeningTimeType == "General");
                                            var gentest = generalTimes.Any();
                                            var teest = gentest;
                                            var mondayTimes = generalTimes.Where(x => x.Weekday == "Monday");
                                            var tuesdayTimes = generalTimes.Where(x => x.Weekday == "Tuesday");
                                            var wednesdayTimes = generalTimes.Where(x => x.Weekday == "Wednesday");
                                            var thursdayTimes = generalTimes.Where(x => x.Weekday == "Thursday");
                                            var fridayTimes = generalTimes.Where(x => x.Weekday == "Friday");
                                            var saturdayTimes = generalTimes.Where(x => x.Weekday == "Saturday");
                                            var sundayTimes = generalTimes.Where(x => x.Weekday == "Sunday");
                                            string mondayOpeningTimes = null; string tuesdayOpeningTimes = null; string wednesdayOpeningTimes = null; string thursdayOpeningTimes = null; string fridayOpeningTimes = null; string saturdayOpeningTimes = null; string sundayOpeningTimes = null;
​
                                            //If we have multiple times for these days, this usually means the time is split into morning and afternoon times, so we concat
                                            if (mondayTimes.Any() && mondayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in mondayTimes)
                                                {
                                                    mondayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (mondayTimes.Any()) { mondayOpeningTimes = mondayTimes?.FirstOrDefault().Times; }
​
                                            if (tuesdayTimes.Any() && tuesdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in tuesdayTimes)
                                                {
                                                    tuesdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (tuesdayTimes.Any()) { tuesdayOpeningTimes = tuesdayTimes?.FirstOrDefault().Times; }
​
                                            if (wednesdayTimes.Any() && wednesdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in wednesdayTimes)
                                                {
                                                    wednesdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (wednesdayTimes.Any()) { wednesdayOpeningTimes = wednesdayTimes?.FirstOrDefault().Times; }
​
                                            if (thursdayTimes.Any() && thursdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in thursdayTimes)
                                                {
                                                    thursdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (thursdayTimes.Any()) { thursdayOpeningTimes = thursdayTimes?.FirstOrDefault().Times; }
​
                                            if (fridayTimes.Any() && fridayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in fridayTimes)
                                                {
                                                    fridayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (fridayTimes.Any()) { fridayOpeningTimes = fridayTimes?.FirstOrDefault().Times; }
​
                                            if (saturdayTimes.Any() && saturdayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in saturdayTimes)
                                                {
                                                    saturdayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (saturdayTimes.Any()) { saturdayOpeningTimes = saturdayTimes?.FirstOrDefault().Times; }
​
                                            if (sundayTimes.Any() && sundayTimes.Count() > 1)
                                            {
                                                //We have multiple times for this day, loop and concat
                                                foreach (var time in sundayTimes)
                                                {
                                                    sundayOpeningTimes += time.Times;
                                                }
                                            }
                                            else if (sundayTimes.Any()) { sundayOpeningTimes = sundayTimes?.FirstOrDefault().Times; }
​
​
                                            entity.UpdateOpeniningTimes(mondayOpeningTimes, tuesdayOpeningTimes, wednesdayOpeningTimes, thursdayOpeningTimes, fridayOpeningTimes, saturdayOpeningTimes, sundayOpeningTimes);
​
​
                                            var didSucessfullyUpdatEntity = await App.DatabaseRepository.UpdateAsync(entity) >= 1;
                                            if (didSucessfullyUpdatEntity)
                                            {
                                                System.Diagnostics.Debug.WriteLine($"Sucessfully updated entity id {entity.Id} with opening times.");
                                            }
                                            else
                                            {
                                                System.Diagnostics.Debug.WriteLine($"ERROR! FAILED TO UPDATE entity id {entity.Id} with opening times.");
                                            }
​
​
                                            continue;
                                        }
                                    }
                                    else
                                    {
                                        //Skip
                                        continue;
                                    }
                                }
                            }
​
​
                        }
​
​
                        //// Replace any whitespace within the url. 
                        //var sanitizedUrl = $"{entity.ChoicesUrl.Trim()}/overview.xml?apikey={this.NhsChoicesApiKey}";
​
                        //// Read the content of the URL into an XElement, so that we can use XML2Linq.
                        //var xmlElement = XElement.Load(sanitizedUrl);
                        //// Get the opening times element, 
                        //var openingTimesXmlElement = xmlElement?.Descendants()?.FirstOrDefault(x => x.Name.LocalName.Equals("openingTimes", StringComparison.InvariantCultureIgnoreCase));
                        //if (openingTimesXmlElement == null)
                        //{
                        //    System.Diagnostics.Debug.WriteLine($"Failed to get any information for the current entity with Id --> {entity.Id} with a type of --> {entity.ServiceType}. " +
                        //        $"Tried to go to URL --> {sanitizedUrl}. Skipping record.");
                        //    // Skip to next record as there's no opening times.
                        //    // Outputting debug above to allow for manual investigation.
                        //    continue;
                        //}
                        //// create a string reader, so that we can deserialize the content, later on to a strongly typed model. 
                        //var reader = new StringReader(openingTimesXmlElement.ToString());
​
                        //var serializer = new XmlSerializer(typeof(Models.NhsChoicesModel.OpeningTimes));
​
                        //var deserializedOpeningTimes = (Models.NhsChoicesModel.OpeningTimes)serializer.Deserialize(reader);
​
​
​
​
                        //// NOTE: Not run into this problem yet, so will leave for now.
                        //// OH OF COURSE! JS is loosely typed, so when it didn't hit an array/ multiple items it just created the single object. 
                        //// This *shouldn't* happen with .Net -- DAR 25/07/2018
                        ////------------------------------------------------------------------------------------------------
                        //// Shit NHS CHOICES data structure, means that some opening time value are stored under s_timesSessionType as an array,
                        //// Where other records are stored under s_timesSessionType.s_daysOfWeek as an array.
                        //// To resolve, we check the length of the sessionTypes.s_timesSessionType. -- DAR 17/03/2015
                        //if ((deserializedOpeningTimes.timesSessionTypes.Length >= 1))
                        //{
                        //    // so it looks like s_timesSessionType is an array.
                        //    // Lets see if we can see the properties
                        //    // of each object in each array.
                        //    // Only get the data for the reception.
                        //    // hac is also a gp surgery.
                        //    if (entity.ServiceType == Enums.ServiceType.Gp) //|| entity.ServiceType == Enums.ServiceType.HAC)
                        //    {
                        //        var receptionOpeningTimes = deserializedOpeningTimes.timesSessionTypes.FirstOrDefault(x => x.sessionType == "reception");
​
​
                        //        if (receptionOpeningTimes != null && !receptionOpeningTimes.daysOfWeek.IsNullOrEmpty())
                        //        {
                        //            var sundayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("sunday", StringComparison.InvariantCultureIgnoreCase));
                        //            var mondayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("monday", StringComparison.InvariantCultureIgnoreCase));
                        //            var tuesdayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("tuesday", StringComparison.InvariantCultureIgnoreCase));
                        //            var wednesdayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("wednesday", StringComparison.InvariantCultureIgnoreCase));
                        //            var thursdayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("thursday", StringComparison.InvariantCultureIgnoreCase));
                        //            var fridayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("friday", StringComparison.InvariantCultureIgnoreCase));
                        //            var saturdayOpeniningTimesRecord = receptionOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("saturday", StringComparison.InvariantCultureIgnoreCase));
​
                        //            var sundayOpeningTimes = this.ExtractOpeningTimeForDay(sundayOpeniningTimesRecord);
                        //            var mondayOpeningTimes = this.ExtractOpeningTimeForDay(mondayOpeniningTimesRecord);
                        //            var tuesdayOpeningTimes = this.ExtractOpeningTimeForDay(tuesdayOpeniningTimesRecord);
                        //            var wednesdayOpeningTimes = this.ExtractOpeningTimeForDay(wednesdayOpeniningTimesRecord);
                        //            var thursdayOpeningTimes = this.ExtractOpeningTimeForDay(thursdayOpeniningTimesRecord);
                        //            var fridayOpeningTimes = this.ExtractOpeningTimeForDay(fridayOpeniningTimesRecord);
                        //            var saturdayOpeningTimes = this.ExtractOpeningTimeForDay(saturdayOpeniningTimesRecord);
​
                        //            entity.UpdateOpeniningTimes(mondayOpeningTimes, tuesdayOpeningTimes, wednesdayOpeningTimes, thursdayOpeningTimes, fridayOpeningTimes, saturdayOpeningTimes, sundayOpeningTimes);
​
                        //            var didSucessfullyUpdatEntity = await App.DatabaseRepository.UpdateAsync(entity) >= 1;
                        //            if (didSucessfullyUpdatEntity)
                        //            {
                        //                System.Diagnostics.Debug.WriteLine($"Sucessfully updated entity id {entity.Id} with opening times.");
                        //            }
                        //            else
                        //            {
                        //                System.Diagnostics.Debug.WriteLine($"ERROR! FAILED TO UPDATE entity id {entity.Id} with opening times.");
                        //            }
                        //            continue;
                        //        }
​
                        //        //else
                        //        //{
                        //        //    throw new Exception("BRoke");
                        //        //}
                        //    }
                        //    else if (entity.ServiceType == Enums.ServiceType.Pharmacy)
                        //    {
                        //        // We want to take the 'general' values for pharmacies. 
                        //        var generalOpeningTimes = deserializedOpeningTimes.timesSessionTypes.FirstOrDefault(x => x.sessionType == "general");
                        //        if (generalOpeningTimes != null && !generalOpeningTimes.daysOfWeek.IsNullOrEmpty())
                        //        {
                        //            var sundayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("sunday", StringComparison.InvariantCultureIgnoreCase));
                        //            var mondayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("monday", StringComparison.InvariantCultureIgnoreCase));
                        //            var tuesdayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("tuesday", StringComparison.InvariantCultureIgnoreCase));
                        //            var wednesdayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("wednesday", StringComparison.InvariantCultureIgnoreCase));
                        //            var thursdayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("thursday", StringComparison.InvariantCultureIgnoreCase));
                        //            var fridayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("friday", StringComparison.InvariantCultureIgnoreCase));
                        //            var saturdayOpeniningTimesRecord = generalOpeningTimes.daysOfWeek.FirstOrDefault(x => x.dayName.Equals("saturday", StringComparison.InvariantCultureIgnoreCase));
​
                        //            var sundayOpeningTimes = this.ExtractOpeningTimeForDay(sundayOpeniningTimesRecord);
                        //            var mondayOpeningTimes = this.ExtractOpeningTimeForDay(mondayOpeniningTimesRecord);
                        //            var tuesdayOpeningTimes = this.ExtractOpeningTimeForDay(tuesdayOpeniningTimesRecord);
                        //            var wednesdayOpeningTimes = this.ExtractOpeningTimeForDay(wednesdayOpeniningTimesRecord);
                        //            var thursdayOpeningTimes = this.ExtractOpeningTimeForDay(thursdayOpeniningTimesRecord);
                        //            var fridayOpeningTimes = this.ExtractOpeningTimeForDay(fridayOpeniningTimesRecord);
                        //            var saturdayOpeningTimes = this.ExtractOpeningTimeForDay(saturdayOpeniningTimesRecord);
​
                        //            entity.UpdateOpeniningTimes(mondayOpeningTimes, tuesdayOpeningTimes, wednesdayOpeningTimes, thursdayOpeningTimes, fridayOpeningTimes, saturdayOpeningTimes, sundayOpeningTimes);
​
                        //            var didSucessfullyUpdatEntity = await App.DatabaseRepository.UpdateAsync(entity) >= 1;
                        //            if (didSucessfullyUpdatEntity)
                        //            {
                        //                System.Diagnostics.Debug.WriteLine($"Sucessfully updated entity id {entity.Id} with opening times.");
                        //            }
                        //            else
                        //            {
                        //                System.Diagnostics.Debug.WriteLine($"ERROR! FAILED TO UPDATE entity id {entity.Id} with opening times.");
                        //            }
                        //            continue;
                        //        }
                        //        //else
                        //        //{
                        //        //    throw new Exception("BRoke");
                        //        //}
                        //    }
                        //}
                        // NOTE: Not run into this problem yet, so will leave for now.
                        // OH OF COURSE! JS is loosely typed, so when it didn't hit an array/ multiple items it just created the single object. 
                        // This *shouldn't* happen with .Net 
                        //else
                        //{
                        //  // This is usually for the majority of pharmacies, however it could be for gp's as well.
                        //  // s_timesSessionType is not an array in this case.
​
                        //}
​
                        //var mondayOpeningTime = deserializedOpeningTimes.timesSessionTypes.FirstOrDefault(x => x.sessionType == "Surgery")
​
​
​
                    }
                    catch (Exception ex)
                    {
                        System.Diagnostics.Debug.WriteLine($"Error >> {ex}");
                    }
​
                }
​
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine($"Error >> {ex}");
            }
​
        }
​
​
​
        private string ExtractOpeningTimeForDay(Models.NhsChoicesModel.openingTimesTimesSessionTypeDayOfWeek dayOfWeekModel)
        {
            if (dayOfWeekModel != null)
            {
                if (dayOfWeekModel != null
                    // Time sessions are an array in NHS Choices markup.
                    // The sample I used to generate the Model must've been a singular value, so I've corrected this now.
                    // -- DAR 13/02/2019
                    && !dayOfWeekModel.timesSessions.IsNullOrEmpty())
                //&& !string.IsNullOrWhiteSpace(dayOfWeekModel.timesSessions.timesSession.fromTime)
                //&& !string.IsNullOrWhiteSpace(dayOfWeekModel.timesSessions.timesSession.toTime))
                {
                    var openingTimes = new List<string>();
                    foreach (var timeSession in dayOfWeekModel.timesSessions)
                    {
                        if (timeSession != null)
                        {
​
                            // if BOTH 'from' and 'to' times ARE NOT empty, then use these.
                            if (!string.IsNullOrWhiteSpace(timeSession.fromTime)
                            && !string.IsNullOrWhiteSpace(timeSession.toTime))
                            {
                                openingTimes.Add($"{timeSession.fromTime} - {timeSession.toTime}");
                            }
                            // If 'from' time is NOT empty BUT 'to' time IS empty then append from time
                            else if (!string.IsNullOrWhiteSpace(timeSession.fromTime)
                                    && string.IsNullOrWhiteSpace(timeSession.toTime))
                            {
                                openingTimes.Add($"{timeSession.fromTime}");
                            }
                            // If 'from' time IS empty BUT 'to' time is NOT empty then append from time
                            else if (string.IsNullOrWhiteSpace(timeSession.fromTime)
                                     && !string.IsNullOrWhiteSpace(timeSession.toTime))
                            {
                                openingTimes.Add($"{timeSession.toTime}");
                            }
                            // if BOTH 'from' and 'to' times ARE empty, then check the 'text' value. 
                            else if (!timeSession.Text.IsNullOrEmpty())
                            {
                                openingTimes.Add($"{timeSession.Text?.FirstOrDefault()}"); // Take the first value.
                            }
                        }
                    }
​
                    return (!openingTimes.IsNullOrEmpty()) ? string.Join("\n", openingTimes) : string.Empty;
                    //return $"{dayOfWeekModel.timesSessions.timesSession.fromTime} - {dayOfWeekModel.timesSessions.timesSession.toTime}";
                }
                // This is usually if the pharmacy is closed on this date.
                return dayOfWeekModel?.timesSessions?.FirstOrDefault()?.Text?.FirstOrDefault() ??
                       string.Empty;
                //return dayOfWeekModel.timesSessions.timesSession.Text.FirstOrDefault();
            }
            return string.Empty;
        }
​
​
​
​
​
        #endregion
​
        #region Static data/ organisations      
        // TODO: not used?
        //        /// <summary>
        //        /// Generates and inserts the static organisations asynchronous.
        //        /// </summary>
        //        /// <returns></returns>
        //        public async Task GenerateAndInsertStaticOrganisationsAsync(int userLocationId)
        //        {
        //            var staticOrganisationsToInsert = new List<DAL.Entities.NhsChoicesData>();
        //            // Load the static organisations from the file. 
        //            var organisationsDataToDeserialize = string.Empty;
        //            try
        //            {
        //                var assembly = IntrospectionExtensions.GetTypeInfo(typeof(NhsChoicesService)).Assembly;
        //                Stream stream = assembly.GetManifestResourceStream("GloucesterAsap.Forms.ConditionsData.StaticOrganisations.txt");
        //                using (var reader = new System.IO.StreamReader(stream))
        //                {
        //                    organisationsDataToDeserialize = reader.ReadToEnd();
        //                }
​
        //            }
        //            catch (Exception ex)
        //            {
        //                System.Diagnostics.Debug.WriteLine($"Got an exception when trying to read conditions file. Exception --> {ex}");
        //#if DEBUG
        //              throw;
        //#endif
        //            }
​
        //            if (!string.IsNullOrWhiteSpace(organisationsDataToDeserialize))
        //            {
        //                staticOrganisationsToInsert = JsonConvert.DeserializeObject<List<DAL.Entities.NhsChoicesData>>(organisationsDataToDeserialize);
        //            }
​
​
        //            var locationService = App.DependencyServiceResolver.Get<Services.Interfaces.ILocationService>()
        //                ?? throw new Exception($"Could not resolve {nameof(Services.Interfaces.ILocationService)}");
​
        //            var geoLocationService = App.DependencyServiceResolver.Get<Forms.PlatformSpecificInterfaces.IGeoLocationService>()
        //                    ?? throw new Exception($"Could not resolve {nameof(Forms.PlatformSpecificInterfaces.IGeoLocationService)}");
​
​
        //            var matchingUserLocationEntityById = await App.DatabaseRepository.GetFirstOrDefaultAsync<DAL.Entities.UserLocation>(x => x.Id == userLocationId);
​
        //            var fromLocationModel = new Models.LatLongModel(matchingUserLocationEntityById.Latitude, matchingUserLocationEntityById.Longitude);
​
        //            // now, we need to get the latlong from the postcodes. 
        //            foreach (var staticOrganisationToInsert in staticOrganisationsToInsert)
        //            {
        //                var latLongForOrganisation = await locationService.ConvertPostcodeToLatLongAsync(staticOrganisationToInsert.PostCode);
        //                if (latLongForOrganisation == null)
        //                {
        //                    throw new Exception($"Could not get lat long for static organisaion with the name of {staticOrganisationToInsert.Name}");
        //                }
​
        //                staticOrganisationToInsert.Latitude = latLongForOrganisation.Latitude;
        //                staticOrganisationToInsert.Longitude = latLongForOrganisation.Longitude;
​
        //                staticOrganisationToInsert.UserLocationId = userLocationId;
​
        //                var toLocationModel = new Models.LatLongModel(latLongForOrganisation.Latitude, latLongForOrganisation.Longitude);
​
        //                // Get the distance between the two locations.
        //                staticOrganisationToInsert.Distance = await geoLocationService.GetDistanceBetweenTwoLocationsAsync(fromLocationModel, toLocationModel);
​
        //                // Next, we need to get the distance between the two points. 
​
        //                await App.DatabaseRepository.SaveAsync<DAL.Entities.NhsChoicesData>(staticOrganisationToInsert);
        //            }
​
        //        }
​
        #endregion
​
​
        #region private helpers     
​
        private string BaseNhsChoicesUrl => _configurationReader.GetConfigValueFromFile("NhsChoicesApiUrl");
​
        private string NhsChoicesApiKey => _configurationReader.GetConfigValueFromFile("NhsChoicesApiKey");
​
​
        private string GetAddressLineForIndex(string[] addresses, int index)
        {
            if (index < addresses.Length)
            {
                return addresses[index];
            }
            return string.Empty;
        }
​
​
​
​
​
​
​
        #endregion
​
​
    }
}
​

Jazz: Miles Davis - So What
Rock: Pink Floyd - Comfortably numb

Cached Result
Last Run:	10:11:08 pm
Compile:	0.237s
Execute:	0s
Memory:	32kb
CPU:	0.016s

View IL Code