prs/prs.mobile.new/PRS.Mobile/Components/DigitalForms/Editor/QAFormViewer.cs

using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using System.Threading;
using System.Linq;
using Xamarin.Forms;
using InABox.Core;
using InABox.Clients;
using System.IO;
using InABox.Mobile;
using Syncfusion.XForms.SignaturePad;
using Comal.Classes;
using PRSClasses;
using Syncfusion.XForms.PopupLayout;

namespace PRS.Mobile
{

    public class QAFormViewer : Grid, IDFRenderer
    {
        #region Fields
        public Dictionary<DFLayoutField, View> pairs = new Dictionary<DFLayoutField, View>();
        public Dictionary<String, String> results = new Dictionary<String, String>();
        public Dictionary<String, String> propertyResults = new Dictionary<String, String>();
        Dictionary<String, String> loadData = new Dictionary<String, String>();
        public Dictionary<DFLayoutLookupField, Dictionary<Guid, string>> dfLayoutLookupFieldLookupOptions = new Dictionary<DFLayoutLookupField, Dictionary<Guid, string>>();
        DFLayout dfLayout = null;
        public IDigitalFormDataModel model = null;
        const string nullOrInvalidType = "Null or Invalid Type";
        int rbGroup;
        private Guid userID;
        bool isRequired = false;
        bool readOnly = false;
        bool isSecure = false;
        bool loadRetainedForm = false;
        List<string> useSavedSignatures = new List<string>();
        public List<string> errors = new List<string>();
        public bool isRequiredEmpty { get; set; }
        public string isRequiredMessage { get; set; }
        InABox.Core.Location location = new InABox.Core.Location();
        Guid digitalFormID = Guid.Empty;
        Color isRequiredColor = Color.DarkOrange;
        public string FormData = "";
        public DateTime FormCompleted = DateTime.MinValue;
        public Guid JobID = Guid.Empty;
        DateTime timeStarted = DateTime.MinValue;
        List<DigitalFormsHeader> headersToCollapse = new List<DigitalFormsHeader>();
        int collapsedHeaderCount = 1;

        #endregion

        #region Constructor

        public QAFormViewer()
        {
            
        }
        
        public QAFormViewer(IDigitalFormDataModel _model, DFLayout _dfLayout, bool newForm, bool _readOnly,
            Guid _jobid = default(Guid)) : this()
        {
            Load(_model, _dfLayout, newForm, _readOnly, _jobid);
        }
        
        public void Load(IDigitalFormDataModel _model, DFLayout _dfLayout, bool newForm, bool _readOnly, Guid _jobid = default(Guid))
        {
            GetLocation();
            
            timeStarted = DateTime.Now;
            userID = ClientFactory.UserGuid;
            model = _model;
            dfLayout = _dfLayout;
            dfLayout.Renderer = this;
            readOnly = _readOnly;
            isRequiredEmpty = false;
            loadRetainedForm = false;
            isRequiredMessage = "";
            JobID = _jobid;
            if (RetainedResults.IsFormRetained)
            {
                loadRetainedForm = true;
            }
            if (newForm)
            {
                LoadForm();
            }
            else if (!newForm)
            {
                loadData.Clear();
                Dictionary<String, Object> data = DigitalForm.DeserializeFormData(model.Instance);
                if (data != null)
                {
                    foreach (KeyValuePair<string, object> keyValuePair in data)
                    {
                        loadData.Add(keyValuePair.Key, keyValuePair.Value.ToString());
                    }
                }
                LoadForm();
            }
        }

        #endregion

        #region Location
        
        private async void GetLocation()
        {
            await Task.Run(() =>
            {
                LocationServices locationServices = new LocationServices();
                locationServices.OnLocationFound += LocationFound;
                locationServices.OnLocationError += LocationError;
                locationServices.GetLocation();
            });
        }

        private async void LocationFound(LocationServices sender)
        {
            location.Latitude = sender.Latitude;
            location.Longitude = sender.Longitude;
        }
        private async void LocationError(LocationServices sender, Exception error)
        {
            errors.Add("Location error: " + error.Message);
        }
        
        #endregion Location

        #region Load Form Layout
        private async void LoadForm()
        {
            {
                LoadRowsAndColumns();
                LoadElements();
            }
        }
        private void LoadRowsAndColumns()
        {
            LoadRows();
            LoadColumns();
        }
        
        
        
        private void LoadRows()
        {
            foreach (var row in dfLayout.RowHeights)
            {
                RowDefinition def = new RowDefinition { Height = new GridLength(1, GridUnitType.Auto) };
                SetRowHeight(row, def);
                Device.BeginInvokeOnMainThread(() => { RowDefinitions.Add(def); });
            }
        }

        private static void SetRowHeight(string row, RowDefinition def)
        {
            if (int.TryParse(row, out int rowHeight))
            {
                def.Height = new GridLength(Math.Max(60,rowHeight), GridUnitType.Absolute);
            }
            else if (row.Contains("*"))
            {
                if (int.TryParse(row.Substring(0, row.IndexOf("*")), out int result))
                    def.Height = new GridLength(result, GridUnitType.Star);
                else
                    def.Height = new GridLength(1, GridUnitType.Star);
            }
            else
                def.Height = new GridLength(1, GridUnitType.Auto);

        }

        private void LoadColumns()
        {
            foreach (var col in dfLayout.ColumnWidths)
            {
                ColumnDefinition def = new ColumnDefinition { Width = new GridLength(1, GridUnitType.Auto) };
                if (int.TryParse(col, out int colWidth))
                    def = new ColumnDefinition { Width = new GridLength(colWidth, GridUnitType.Absolute) };
                else if (col.Contains("*"))
                {
                    if (int.TryParse(col.Substring(0, col.IndexOf("*")), out int result))
                    {
                        def = new ColumnDefinition { Width = new GridLength(result, GridUnitType.Star) };
                    }
                    else
                        def = new ColumnDefinition { Width = new GridLength(1, GridUnitType.Star) };
                }
                Device.BeginInvokeOnMainThread(() => { ColumnDefinitions.Add(def); });
            }
        }
        private void LoadElements()
        {
            rbGroup = 0; //used for customboolean - has to be outside of foreach loop
            foreach (DFLayoutControl element in dfLayout.Elements)
            {
                if (!string.IsNullOrEmpty(element.Description))
                {
                    LoadViewAccordingToElement(element);
                }
            }
            Task.Run(() =>
            {
                Thread.Sleep(1000);
                foreach (var header in headersToCollapse)
                {
                    Device.BeginInvokeOnMainThread(() =>
                    {
                        AdjustHeaderSection(header, false);
                        header.Collapse();
                    });
                }
            });
        }
        #endregion

        #region Load Element Methods
        private void LoadViewAccordingToElement(DFLayoutControl element)
        {
            isSecure = false;

            if (element is DFLayoutBooleanField)
            {
                var tuple = LoadCustomBoolean(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
            else if (element is DFLayoutLabel)
            {
                var tuple = LoadLabel(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
            else if (element is DFLayoutStringField || element is DFLayoutIntegerField || element is DFLayoutDoubleField)
            {
                var tuple = LoadEditor(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
            else if (element is DFLayoutDateField)
            {
                var tuple = LoadDatePicker(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, false);
            }
            else if (element is DFLayoutTimeField)
            {
                var tuple = LoadTimePicker(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, false);
            }
            else if (element is DFLayoutOptionField)
            {
                var tuple = LoadOptionPicker(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, false);
            }
            else if (element is DFLayoutImage)
            {
                var tuple = LoadImage(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
            else if (element is DFLayoutLookupField)
            {
                var tuple = LoadLookupPicker(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
            else if (element is DFLayoutSignaturePad)
            {
                var tuple = LoadSignaturePad(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
            else if (element is DFLayoutEmbeddedImage)
            {
                var tuple = LoadEmbeddedImage(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
            else if (element is DFLayoutMultiImage)
            {
                var tuple = LoadMultiImage(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
            else if (element is DFLayoutMultiSignaturePad)
            {
                var tuple = LoadMultiSignaturePad(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
            else if (element is DFLayoutAddTaskField)
            {
                var tuple = LoadAddTaskField(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
            else if (element is DFLayoutHeader)
            {
                
                FormatAndAddView(LoadHeader(element), element, false, true);
            }
            else if (element is DFLayoutVideoField)
            {
                var tuple = LoadVideoField(element);
                FormatAndAddView(tuple.Item1, element, tuple.Item2, true);
            }
        }

        private View LoadHeader(DFLayoutControl element)
        {
            DFLayoutHeader dFLayoutHeader = (DFLayoutHeader)element;
            DigitalFormsHeader header = new DigitalFormsHeader(dFLayoutHeader.Collapsed);
            header.SetHeaderStyle(dFLayoutHeader);
            if (dFLayoutHeader.Collapsed)
                header = AddNumberToHeader(header);

            header.SetHeaderValue(dFLayoutHeader.Header);

            header.OnTapped += (bCollapsed) =>
            {
                AdjustHeaderSection(header, bCollapsed);
            };

            return header;
        }

        private DigitalFormsHeader AddNumberToHeader(DigitalFormsHeader header)
        {
            header.Number = collapsedHeaderCount;
            collapsedHeaderCount++;
            return header;
        }

        private void AdjustHeaderSection(DigitalFormsHeader header, bool collapsed)
        {
            try
            {
                var thisHeaderRow = GetRow(header);
                var headerRows = GetOtherHeaders(thisHeaderRow);
                if (headerRows.Any())
                    AdjustHeightsToNextHeader(headerRows, thisHeaderRow, collapsed);
                else
                    AdjustHeightsBelowHeader(headerRows, thisHeaderRow, collapsed);
            }
            catch
            {

            }
        }

        private List<int> GetOtherHeaders(int thisHeaderRow)
        {
            List<int> headerRows = new List<int>();
            foreach (var child in Children)
            {
                if (child is DigitalFormsHeader)
                {
                    var dfheader = (DigitalFormsHeader)child;
                    if (GetRow(dfheader) > thisHeaderRow)
                    {
                        headerRows.Add(GetRow(dfheader));
                    }
                }
            }
            return headerRows;
        }

        private void AdjustHeightsToNextHeader(List<int> headerRows, int thisHeaderRow, bool collapsed)
        {
            headerRows.Sort();
            int nextHeaderRow = headerRows[0];

            for (int i = thisHeaderRow + 1; i < nextHeaderRow; i++)
            {
                AdjustHeight(i, collapsed);
            }
        }

        private void AdjustHeightsBelowHeader(List<int> headerRows, int thisHeaderRow, bool collapsed)
        {
            for (int i = thisHeaderRow + 1; i < RowDefinitions.Count; i++)
            {
                AdjustHeight(i, collapsed);
            }
        }

        private void AdjustHeight(int i, bool collapsed)
        {
            var rowdef = RowDefinitions[i];
            
            if (collapsed)
            {
                SetRowHeight(dfLayout.RowHeights[i], rowdef);
                //rowdef.Height = 60;
                //AnimateChildren(i, 0, 250);
            }
            else
            {
                //AnimateChildren(i, -60, 500);
                rowdef.Height = 0;
            }
        }

        private async void AnimateChildren(int i, int movement, int length)
        {
            foreach (var child in Children)
            {
                if (GetRow(child) == i)
                {
                    await child.TranslateTo(0, movement, 250);
                }
            }
        }

        private Tuple<View, Boolean> LoadCustomBoolean(DFLayoutControl element)
        {
            CustomBoolean item = new CustomBoolean(rbGroup);
            DFLayoutBooleanField dfLayoutBooleanField = element as DFLayoutBooleanField;

            if (!string.IsNullOrWhiteSpace(dfLayoutBooleanField.Properties.TrueValue))
                item.TrueValue = dfLayoutBooleanField.Properties.TrueValue;
            if (!string.IsNullOrWhiteSpace(dfLayoutBooleanField.Properties.FalseValue))
                item.FalseValue = dfLayoutBooleanField.Properties.FalseValue;

            String sValue = "";
            if (loadRetainedForm)
                RetainedResults.Results.TryGetValue(dfLayoutBooleanField.Name, out sValue);
            if (String.IsNullOrWhiteSpace(sValue))
                loadData.TryGetValue(dfLayoutBooleanField.Name, out sValue);
            
            if (bool.TryParse(sValue, out bool bValue))
                item.Value = bValue;

            item.BackgroundColor = dfLayoutBooleanField.Properties.Required
                ? isRequiredColor
                : Color.Gray;

            item.OnCustomBooleanValueChanged += (boolvalue) =>
            {
                dfLayout.ChangeField(dfLayoutBooleanField.Name);
            };

            return new Tuple<View, Boolean>(item, dfLayoutBooleanField.Properties.Required);
        }

        private Tuple<View, Boolean> LoadLabel(DFLayoutControl element)
        {
            DFLayoutLabel label = element as DFLayoutLabel;
            Label item = new Label();
            item.Text = label.Caption;

            item.LineBreakMode = label.Style.TextWrapping == true ? LineBreakMode.WordWrap : LineBreakMode.NoWrap;
            item.VerticalOptions = LayoutOptions.FillAndExpand;
            item.MinimumHeightRequest = 60;
            item.BackgroundColor = label.Style.BackgroundColour.IsEmpty ? Color.Transparent : label.Style.BackgroundColour;

            item.FontAttributes = label.Style.IsBold ? FontAttributes.Bold
                : label.Style.IsItalic ? FontAttributes.Italic
                : FontAttributes.None;
            item.TextDecorations = label.Style.Underline == UnderlineType.Single || label.Style.Underline == UnderlineType.Double ?
                TextDecorations.Underline : TextDecorations.None;

            item.FontSize = label.Style.FontSize > 5 && label.Style.FontSize < 37 ? label.Style.FontSize
                : Device.GetNamedSize(NamedSize.Small, item);

            item.TextColor = label.Style.ForegroundColour.IsEmpty ? Color.Black : label.Style.ForegroundColour;

            if (ColumnDefinitions.Count == 1)
            {
                item.HorizontalOptions = LayoutOptions.CenterAndExpand;
                item.HorizontalTextAlignment = TextAlignment.Center;
            }

            item.HorizontalTextAlignment = label.Style.HorizontalTextAlignment == DFLayoutAlignment.Start ? TextAlignment.Start
                : label.Style.HorizontalTextAlignment == DFLayoutAlignment.Middle ? TextAlignment.Center
                : label.Style.HorizontalTextAlignment == DFLayoutAlignment.End ? TextAlignment.End
                : item.HorizontalTextAlignment;

            item.VerticalTextAlignment = label.Style.VerticalTextAlignment == DFLayoutAlignment.Start ? TextAlignment.Start
                : label.Style.HorizontalTextAlignment == DFLayoutAlignment.Middle ? TextAlignment.Center
                : label.Style.HorizontalTextAlignment == DFLayoutAlignment.End ? TextAlignment.End
                : TextAlignment.Center;

            return new Tuple<View, Boolean>(item, false);
        }

        private Tuple<View, Boolean> LoadEditor(DFLayoutControl element)
        {

            View view = null;
           
            var isrequired = false;
            var issecure = false;
            var name = (element as DFLayoutField)?.Name;
            String value = "";
            if (loadRetainedForm)
                RetainedResults.Results.TryGetValue(name, out value);
            else
                loadData.TryGetValue(name, out value);
            
            if (element is DFLayoutStringField)
            {
                DFLayoutStringField dfLayoutStringField = element as DFLayoutStringField;
                isrequired = dfLayoutStringField.Properties.Required;
                issecure = dfLayoutStringField.Properties.Secure;

                
                if (dfLayoutStringField.Properties.PopupEditor)
                {
                    DataButtonControl button = new DataButtonControl();
                    button.BackgroundColor = isrequired
                        ? isRequiredColor 
                        : readOnly
                            ? Color.Silver 
                            : Color.LightYellow;
                            
                    button.Clicked += (s, e) =>
                    {
                        PopupEditor edt = new PopupEditor(button.Data);
                        edt.OnPopupEdtSaved += (text) =>
                        {
                            button.Data = text;
                            button.Text = text.Length > 25 ? text.Substring(0, 25) + "..." : text;
                            dfLayout.ChangeField(dfLayoutStringField.Name);
                        };
                        Navigation.PushAsync(edt);
                    };
                    button.Text = "Edit";
                    button.Text = String.IsNullOrWhiteSpace(value)
                        ? "Edit"
                        : value.Length > 25 
                            ? value.Substring(0, 25) + "..." 
                            : value;
                    
                    button.IsEnabled = !readOnly && !issecure;

                    view = button;
                }
                else
                {
                    MobileEditor item = new MobileEditor();
                    item.BackgroundColor = isrequired
                        ? isRequiredColor 
                        : readOnly
                            ? Color.Silver 
                            : Color.LightYellow;
                    item.AutoSize = EditorAutoSizeOption.TextChanges;
                    item.Placeholder = "Enter answer";
                    item.Text = value ?? "";
                    item.TextChanged += (o,e) =>  dfLayout.ChangeField(dfLayoutStringField.Name);
                    item.IsEnabled = !readOnly && !issecure;
                    view = item;
                }
            }

            else if (element is DFLayoutIntegerField)
            {
                DFLayoutIntegerField dfLayoutIntegerField = element as DFLayoutIntegerField;
                isrequired = dfLayoutIntegerField.Properties.Required;
                issecure = dfLayoutIntegerField.Properties.Secure;
                
                MobileEditor item = new MobileEditor();
                item.BackgroundColor = isrequired
                    ? isRequiredColor 
                    : readOnly
                        ? Color.Silver 
                        : Color.LightYellow;
                item.TextColor = Color.Black;
                item.Placeholder = "Enter number";
                item.Keyboard = Keyboard.Numeric;
                item.Text = value ?? "";
                item.TextChanged += (o,e) => dfLayout.ChangeField(dfLayoutIntegerField.Name);
                item.IsEnabled = !readOnly && !issecure;
                view = item;
            }

            else if (element is DFLayoutDoubleField)
            {
                DFLayoutDoubleField dfLayoutDoubleField = element as DFLayoutDoubleField;
                isrequired = dfLayoutDoubleField.Properties.Required;
                issecure = dfLayoutDoubleField.Properties.Secure;
                
                MobileEditor item = new MobileEditor();
                item.BackgroundColor = isrequired
                    ? isRequiredColor 
                    : readOnly
                        ? Color.Silver 
                        : Color.LightYellow;
                item.TextColor = Color.Black;
                item.Placeholder = "Enter number";
                item.Keyboard = Keyboard.Numeric;
                item.Text = value ?? "";
                item.TextChanged += (o,e) => dfLayout.ChangeField(dfLayoutDoubleField.Name);
                item.IsEnabled = !readOnly && !issecure;
                view = item;
            }
            return new Tuple<View, Boolean>(view, isrequired);
        }

        private Tuple<View, Boolean> LoadDatePicker(DFLayoutControl element)
        {
            string value = "";
            DFLayoutDateField dfLayoutDateField = element as DFLayoutDateField;

            MobileDateButton button = new MobileDateButton();
            button.Format = "dd MMM yy";
            button.HeightRequest = 40;
            
            if (dfLayoutDateField.Properties.Required)
                button.BackgroundColor = isRequiredColor;

            if (loadData.TryGetValue(dfLayoutDateField.Name, out value))
            {
                if (!string.IsNullOrWhiteSpace(value))
                {
                    try
                    {
                        button.Date = DateTime.Parse(value);
                    }
                    catch { }
                }
            }
            if (loadRetainedForm)
            {
                if (RetainedResults.Results.TryGetValue(dfLayoutDateField.Name, out value))
                {
                    button.Date = DateTime.Parse(value);
                }
            }
            button.Changed += (sender, args) => dfLayout.ChangeField(dfLayoutDateField.Name);
            //     += (object sender, DateChangedEventArgs e) =>
            // {
            //     dfLayout.ChangeField(dfLayoutDateField.Name);
            // };

            return new Tuple<View, Boolean>(button, dfLayoutDateField.Properties.Required);
        }

        private Tuple<View, Boolean> LoadTimePicker(DFLayoutControl element)
        {
            string value = "";
            DFLayoutTimeField dfLayoutTimeField = element as DFLayoutTimeField;

            MobileTimeButton button = new MobileTimeButton();
            button.HeightRequest = 40;
            
            if (dfLayoutTimeField.Properties.Required)
                button.BackgroundColor = isRequiredColor;
            if (loadData.TryGetValue(dfLayoutTimeField.Name, out value))
            {
                if (!string.IsNullOrWhiteSpace(value))
                {
                    button.Time = DateTime.Parse(value).TimeOfDay;
                }
            }
            if (loadRetainedForm)
            {
                if (RetainedResults.Results.TryGetValue(dfLayoutTimeField.Name, out value))
                {
                    button.Time = DateTime.Parse(value).TimeOfDay;
                }
            }
            button.Changed += (sender, args) => dfLayout.ChangeField(dfLayoutTimeField.Name);
            
            return new Tuple<View, Boolean>(button, dfLayoutTimeField.Properties.Required);
        }

        private SfPopupLayout _popup = new SfPopupLayout();
        
        private Tuple<View, Boolean> LoadOptionPicker(DFLayoutControl element)
        {
            View view = null;
            bool isrequired = false;
            if (element is DFLayoutOptionField dfLayoutOptionField)
            {
                isrequired = dfLayoutOptionField.Properties.Required;
                
                var options = dfLayoutOptionField.Properties.Options.Split(',');

                string value = "";
                
                if (loadRetainedForm)
                    RetainedResults.Results.TryGetValue(dfLayoutOptionField.Name, out value);
                
                if (String.IsNullOrWhiteSpace(value))
                    loadData.TryGetValue(dfLayoutOptionField.Name, out value);
                
                if (String.IsNullOrWhiteSpace(value))
                    value = dfLayoutOptionField.Properties.Default;
                
                if (dfLayoutOptionField.Properties.OptionType == DFLayoutOptionType.Radio)
                {
                    var list = new MobileRadioList();
                    foreach (var option in options)
                        list.Items.Add(new MobileRadioListItem() { Text = option });
                    list.SelectedItem = list.Items.FirstOrDefault((x => x.Text == value));
                    list.Changed += (sender, args) =>
                    {
                        //dfLayout.ChangeField(dfLayoutOptionField.Name);
                    };
                    list.HeightRequest = 22 + (options.Length * 20) + ((options.Length-1) * 5);
                    view = list;
                }
                else if (dfLayoutOptionField.Properties.OptionType == DFLayoutOptionType.Combo)
                {
                    var strip = new MobileTabStrip();
                    strip.UnselectedBackground = Color.Gray;
                    strip.SeparatorColor = Color.Gray;
                    strip.UnselectedForeground = Color.WhiteSmoke;
                    strip.SelectedForeground = Color.Black;
                    strip.FontSize = Device.GetNamedSize(NamedSize.Small, typeof(Label));
                    strip.HeightRequest = 40;
                    foreach (var option in options)
                        strip.Items.Add(new MobileTabStripItem() { Text = option });
                    strip.SelectedItem = strip.Items.FirstOrDefault((x => x.Text == value));
                    strip.SelectionChanged += (sender, args) =>
                    {
                        //dfLayout.ChangeField(dfLayoutOptionField.Name);
                    };
                    view = strip;
                }
                else
                {
                    var button = new MobileButton();
                    button.Text = String.IsNullOrWhiteSpace(value)
                        ? "Select"
                        : value;
                    button.Clicked += (sender, args) =>
                    {
                        // Do the Popupo Here
                        // dfLayout.ChangeField(dfLayoutOptionField.Name);
                    };
                    view = button;
                }
            }
            return new Tuple<View, Boolean>(view, isrequired);
        }

        private Tuple<View, Boolean> LoadImage(DFLayoutControl element)
        {
            View view = null;
            DFLayoutImage dfLayoutImage = element as DFLayoutImage;
            Image img = new Image();
            CoreTable table = new Client<Document>().Query(
                    new Filter<Document>(x => x.ID).IsEqualTo(dfLayoutImage.Image.ID),
                    null,
                    null);
            if (table.Rows.Any())
            {
                CoreRow row = table.Rows.FirstOrDefault();
                byte[] data = row.Get<Document, byte[]>(x => x.Data);
                ImageSource src = ImageSource.FromStream(() => new MemoryStream(data));
                img.MinimumHeightRequest = 150;
                img.MinimumWidthRequest = 150;
                img.Aspect = Aspect.AspectFit;
                img.Source = src;
                img.HorizontalOptions = LayoutOptions.FillAndExpand;
                img.VerticalOptions = LayoutOptions.FillAndExpand;
                img.GestureRecognizers.Add(new TapGestureRecognizer
                {
                    Command = new Command(OnTap),
                    CommandParameter = src,
                    NumberOfTapsRequired = 1
                });
                if (img != null)
                {
                    view = img;
                }
            }

            return new Tuple<View, Boolean>(view, false);
        }

        private void OnTap(object obj)
        {
            ImageViewerPage viewer = new ImageViewerPage(obj as ImageSource);
            Navigation.PushAsync(viewer);
        }

        private Tuple<View, Boolean> LoadLookupPicker(DFLayoutControl element)
        {
            View view = null;
            string value = "";
            DFLayoutLookupField dfLayoutLookupField = element as DFLayoutLookupField;
            var isrequired = dfLayoutLookupField.Properties.Required;
            Dictionary<Guid, string> lookupFieldOptions = new Dictionary<Guid, string>();
            string type = dfLayoutLookupField.Properties.LookupType;

            Type lookuptype = CoreUtils.GetEntityOrNull(type);
            if (lookuptype == typeof(DrawingTemplate))
                view = LoadDrawingTemplateLookupButton(lookuptype, dfLayoutLookupField, lookupFieldOptions, element);

            else if (!string.IsNullOrWhiteSpace(dfLayoutLookupField.Properties.Filter))
                view = LoadGenericLookupButton(lookuptype, dfLayoutLookupField, lookupFieldOptions, element);

            else if (lookuptype == typeof(Product))
                view = LoadProductLookupPicker(view, dfLayoutLookupField, value);

            else if (lookuptype != null)
                view = LoadGenericLookupButton(lookuptype, dfLayoutLookupField, lookupFieldOptions, element);

            else if (lookuptype == null)
                view = new Label { Text = "Null lookup selected", HorizontalOptions = LayoutOptions.Center, HorizontalTextAlignment = TextAlignment.Center };

            return new Tuple<View, Boolean>(view, isrequired);
        }

        private View LoadGenericLookupButton(Type lookuptype, DFLayoutLookupField dfLayoutLookupField, Dictionary<Guid, string> lookupFieldOptions, DFLayoutControl element)
        {
            string value = "";
            CoreTable table = new CoreTable();
            var client = ClientFactory.CreateClient(lookuptype);
            var columns = LookupFactory.DefineColumns(lookuptype);
            var sort = LookupFactory.DefineSort(lookuptype);
            var filter = LookupFactory.DefineFilter(lookuptype);

            foreach (var property in dfLayoutLookupField.Properties.AdditionalPropertiesList)
            {
                columns.Add(property);
            }

            if (!string.IsNullOrWhiteSpace(dfLayoutLookupField.Properties.Filter))
                filter = ReturnFilter(dfLayoutLookupField, lookuptype);

            if (lookuptype == typeof(ProductStyle) && JobID != Guid.Empty)
                table = ReturnJobStyleProducts(table, client, columns, sort);

            if (table.Rows.Count == 0)
                table = client.Query(filter, columns, sort); // do generic query if a specific one hasn't already been done

            Dictionary<Guid, Dictionary<string, object>> additionalPropertyValues = new Dictionary<Guid, Dictionary<string, object>>();

            foreach (var row in table.Rows)
            {
                Guid id = row.Get<Guid>("ID");
                Dictionary<string, object> values = row.ToDictionary(new string[] { "ID" });
                additionalPropertyValues.Add(id, values);
                string display = LookupFactory.FormatLookup(lookuptype, values, new string[] { });
                lookupFieldOptions[id] = display;
            }
            dfLayoutLookupFieldLookupOptions[element as DFLayoutLookupField] = lookupFieldOptions;
            List<string> itemList = lookupFieldOptions.Values.ToList();
            DataButtonControl button = new DataButtonControl()
            {
                Text = "Choose Option",
                Margin = 0,
                ExtraData = additionalPropertyValues,
                LookupFieldOptions = lookupFieldOptions
            };
            button.Clicked += (object sender, EventArgs eventArgs) =>
            {
                ListSelectionPage selectionPage = new ListSelectionPage(lookupFieldOptions);
                selectionPage.OnSimpleListTapped += (s) =>
                {
                    button.Data = s;
                    button.Text = s;
                    dfLayout.ChangeField(dfLayoutLookupField.Name);
                };
                selectionPage.OnDictionaryItemTapped += (id, s) =>
                {
                    button.Data = s;
                    button.Text = s;
                    button.ChosenID = id;
                    dfLayout.ChangeField(dfLayoutLookupField.Name);
                };
                Navigation.PushAsync(selectionPage);
            };
            if (loadData.TryGetValue(dfLayoutLookupField.Name, out value))
            {
                if (!string.IsNullOrWhiteSpace(value))
                {
                    button.Data = value;
                    button.Text = value;
                }
            }
            if (loadRetainedForm)
            {
                if (RetainedResults.Results.TryGetValue(dfLayoutLookupField.Name, out value))
                {
                    button.Data = value;
                    button.Text = value;
                }
            }
            if (isRequired)
            {
                button.BackgroundColor = isRequiredColor;
            }
            return button;
        }

        private View LoadDrawingTemplateLookupButton(Type lookuptype, DFLayoutLookupField dfLayoutLookupField, Dictionary<Guid, string> lookupFieldOptions, DFLayoutControl element)
        {
            string value = "";
            var columns = new Columns<DrawingTemplate>(x => x.Code, x => x.Document.ID);
            CoreTable table = new Client<DrawingTemplate>().Query(null, columns);
            Dictionary<string, Guid> dictionary = new Dictionary<string, Guid>();
            foreach (var row in table.Rows)
            {
                List<object> list = row.Values;
                if (list[0] != null && list[1] != null)
                    dictionary.Add(list[0].ToString(), Guid.Parse(list[1].ToString()));
            }
            DataButtonControl button = new DataButtonControl()
            {
                Text = "Choose Option",
            };
            button.Clicked += (object sender, EventArgs eventArgs) =>
            {
                ListSelectionPage selectionPage = new ListSelectionPage(dictionary);
                selectionPage.OnSimpleListTapped += (s) =>
                {
                    button.Data = s;
                    button.Text = s;
                    dfLayout.ChangeField(dfLayoutLookupField.Name);
                };
                Navigation.PushAsync(selectionPage);
            };
            if (loadData.TryGetValue(dfLayoutLookupField.Name, out value))
            {
                if (!string.IsNullOrWhiteSpace(value))
                {
                    button.Data = value;
                    button.Text = value;
                }
            }
            if (loadRetainedForm)
            {
                if (RetainedResults.Results.TryGetValue(dfLayoutLookupField.Name, out value))
                {
                    button.Data = value;
                    button.Text = value;
                }
            }
            if (isRequired)
            {
                button.BackgroundColor = isRequiredColor;
            }
            return button;
        }

        private IFilter ReturnFilter(DFLayoutLookupField dfLayoutLookupField, Type lookuptype)
        {
            var propertyFilter = dfLayoutLookupField.Properties.Filter;
            var filtertype = typeof(Filter<>).MakeGenericType(lookuptype);
            var deserialised = Serialization.Deserialize(filtertype, propertyFilter);
            IFilter filter = deserialised as IFilter;
            return filter;
        }

        private CoreTable ReturnJobStyleProducts(CoreTable table, IClient client, IColumns columns, ISortOrder sort)
        {
            CoreTable jobStyleTable = new Client<JobStyle>().Query(new Filter<JobStyle>(x => x.Job.ID).IsEqualTo(JobID),
                    new Columns<JobStyle>(x => x.Style.ID));
            if (jobStyleTable.Rows.Any())
            {
                Guid firstID = Guid.Parse(jobStyleTable.Rows.FirstOrDefault().Values[0].ToString());
                var stylefilter = new Filter<ProductStyle>(x => x.ID).IsEqualTo(firstID);
                foreach (CoreRow jobStyleRow in jobStyleTable.Rows)
                {
                    if (jobStyleRow != jobStyleTable.Rows.FirstOrDefault())
                    {
                        stylefilter = stylefilter.Or(x => x.ID).IsEqualTo(Guid.Parse(jobStyleRow.Values[0].ToString()));
                    }
                }
                table = client.Query(stylefilter, columns, sort);
            }
            return table;
        }

        private View LoadProductLookupPicker(View view, DFLayoutLookupField dfLayoutLookupField, string value)
        {
            FrameButton framebutton = new FrameButton();
            if (loadData.TryGetValue(dfLayoutLookupField.Name, out value))
            {
                framebutton.SetButtonText(value);
                framebutton.Data = value + "," + (App.Data.Products.Items.FirstOrDefault(x => x.Code == value)).ID.ToString();
                //CoreTable productTable = new Client<Product>().Query(new Filter<Product>(x => x.Code).IsEqualTo(value),
                //    new Columns<Product>(x => x.Image.ID));
                //if (productTable.Rows.Any())
                //{
                //    CoreTable imageTable1 = new Client<Document>().Query(new Filter<Document>(x => x.ID).IsEqualTo(Guid.Parse(productTable.Rows.First().Values[0].ToString())),
                //            new Columns<Document>(x => x.Data));
                //    CoreRow docrow = imageTable1.Rows.FirstOrDefault();
                //    if (docrow != null)
                //    {
                //        byte[] data = docrow.Get<Document, byte[]>(x => x.Data);
                //        ImageSource src = ImageSource.FromStream(() => new MemoryStream(data));
                //        if (src != null)
                //        {
                //            framebutton.SetImage(src);
                //        }
                //    }
                //}

            }
            framebutton.OnFrameButtonClicked += (() =>
            {
                ProductList2 productList = new ProductList2(App.Data.Products.Items.ToList(), true);
                productList.OnProductSelected += () =>
                {
                    framebutton.SetButtonText(productList.SelectedProduct.Code);
                    framebutton.Data = productList.SelectedProduct.Code + "," + productList.SelectedProduct.ID.ToString();
                    //CoreTable imageTable = new Client<Document>().Query(new Filter<Document>(x => x.ID).IsEqualTo(productList.SelectedProduct.ImageID),
                    //    new Columns<Document>(x => x.Data));
                    //CoreRow docrow = imageTable.Rows.FirstOrDefault();
                    //if (docrow != null)
                    //{
                    //    byte[] data = docrow.Get<Document, byte[]>(x => x.Data);
                    //    ImageSource src = ImageSource.FromStream(() => new MemoryStream(data));
                    //    if (src != null)
                    //    {
                    //        framebutton.SetImage(src);
                    //    }
                    //}
                    dfLayout.ChangeField(dfLayoutLookupField.Name);
                };
                Navigation.PushAsync(productList);
            });
            view = framebutton;
            return view;
        }

        private Tuple<View, Boolean> LoadSignaturePad(DFLayoutControl element)
        {
            string value = "";
            View view = null;
            DFLayoutSignaturePad dFLayoutSignaturePad = element as DFLayoutSignaturePad;
            var isrequired = dFLayoutSignaturePad.Properties.Required;
            if (loadData.TryGetValue(dFLayoutSignaturePad.Name, out value))
            {
                if (!string.IsNullOrWhiteSpace(value))
                {
                    EmbeddedImageCapture embeddedImageCapture = new EmbeddedImageCapture();
                    byte[] data = Convert.FromBase64String(value);
                    embeddedImageCapture.DataToImage(data);
                    view = embeddedImageCapture;
                    view.IsEnabled = false;
                }
            }
            else
            {
                SfSignaturePad signaturePad = new SfSignaturePad();
                EmbeddedImageCapture hiddenEmbeddedImageCapture = new EmbeddedImageCapture() { HeightRequest = 200, IsVisible = false, IsEnabled = false };
                if (isrequired) signaturePad.BackgroundColor = isRequiredColor;
                signaturePad.MinimumHeightRequest = 200;
                signaturePad.MinimumStrokeWidth = 0.2;
                signaturePad.MaximumStrokeWidth = 17;
                Button clearButton = new Button()
                {
                    Text = "Clear",
                    HorizontalOptions = LayoutOptions.FillAndExpand,
                    VerticalOptions = LayoutOptions.End,
                    Margin = 0,
                    BackgroundColor = Color.FromHex("#15C7C1"),
                    FontAttributes = FontAttributes.Bold,
                    TextColor = Color.White,
                    CornerRadius = 5,
                    Padding = 1
                };
                clearButton.Clicked += (object sender, EventArgs e) =>
                {
                    signaturePad.IsVisible = true;
                    hiddenEmbeddedImageCapture.IsVisible = false;
                    useSavedSignatures.Remove(dFLayoutSignaturePad.Name);
                    signaturePad.Clear();
                };
                Grid.SetColumn(clearButton, 2);

                Button signNowButton = new Button()
                {
                    Text = "Apply Saved",
                    HorizontalOptions = LayoutOptions.FillAndExpand,
                    VerticalOptions = LayoutOptions.End,
                    Margin = 0,
                    BackgroundColor = Color.FromHex("#15C7C1"),
                    FontAttributes = FontAttributes.Bold,
                    TextColor = Color.White,
                    CornerRadius = 5,
                    Padding = 1
                };
                signNowButton.Clicked += (object sender, EventArgs e) =>
                {
                    if (Application.Current.Properties.ContainsKey("SavedSignature"))
                    {
                        Task.Run(() =>
                        {
                            hiddenEmbeddedImageCapture.DataToImage((Application.Current.Properties["SavedSignature"]) as byte[]);
                        });
                        Thread.Sleep(1000);
                        signaturePad.IsVisible = false;
                        hiddenEmbeddedImageCapture.IsVisible = true;
                        if (!useSavedSignatures.Contains(dFLayoutSignaturePad.Name))
                            useSavedSignatures.Add(dFLayoutSignaturePad.Name);
                    }
                };
                Grid.SetColumn(signNowButton, 1);

                Button createSignatureButton = new Button()
                {
                    Text = "Save New",
                    HorizontalOptions = LayoutOptions.FillAndExpand,
                    VerticalOptions = LayoutOptions.End,
                    Margin = 0,
                    BackgroundColor = Color.FromHex("#15C7C1"),
                    FontAttributes = FontAttributes.Bold,
                    TextColor = Color.White,
                    CornerRadius = 5,
                    Padding = 1
                };
                createSignatureButton.Clicked += (object sender, EventArgs e) =>
                {
                    SignatureSaver saver = new SignatureSaver();
                    saver.OnSignatureSaved += () =>
                    {
                        Task.Run(() =>
                        {
                            hiddenEmbeddedImageCapture.DataToImage((Application.Current.Properties["SavedSignature"]) as byte[]);
                        });
                        Thread.Sleep(1000);
                        signaturePad.IsVisible = false;
                        hiddenEmbeddedImageCapture.IsVisible = true;
                        if (!useSavedSignatures.Contains(dFLayoutSignaturePad.Name))
                            useSavedSignatures.Add(dFLayoutSignaturePad.Name);
                    };
                    Navigation.PushAsync(saver);
                };
                Grid.SetColumn(createSignatureButton, 0);

                Grid buttonsGrid = new Grid { Margin = 0, Padding = 0, VerticalOptions = LayoutOptions.End };
                buttonsGrid.ColumnDefinitions.Add(new ColumnDefinition { Width = new GridLength(1, GridUnitType.Star) });
                buttonsGrid.ColumnDefinitions.Add(new ColumnDefinition { Width = new GridLength(1, GridUnitType.Star) });
                buttonsGrid.ColumnDefinitions.Add(new ColumnDefinition { Width = new GridLength(1, GridUnitType.Star) });
                buttonsGrid.Children.Add(createSignatureButton);
                buttonsGrid.Children.Add(signNowButton);
                buttonsGrid.Children.Add(clearButton);

                Grid grid = new Grid() { Margin = 0, Padding = 0 };
                grid.RowDefinitions.Add(new RowDefinition { Height = new GridLength(200, GridUnitType.Absolute) });
                Grid.SetRow(signaturePad, 0);
                Grid.SetRow(hiddenEmbeddedImageCapture, 0);

                grid.Children.Add(hiddenEmbeddedImageCapture);
                grid.Children.Add(signaturePad);
                grid.Children.Add(buttonsGrid);

                view = grid;
            }

            return new Tuple<View, Boolean>(view, isrequired);
        }

        private Tuple<View, Boolean> LoadEmbeddedImage(DFLayoutControl element)
        {
            string value = "";
            bool disableLibrary = false;
            DFLayoutEmbeddedImage dfLayoutEmbeddedImage = element as DFLayoutEmbeddedImage;

            try
            {
                disableLibrary = dfLayoutEmbeddedImage.Properties.DisableLibrary;
            }
            catch { }
            EmbeddedImageCapture embeddedImageCapture = new EmbeddedImageCapture(disableLibrary);
            if (disableLibrary)
                embeddedImageCapture.LibraryButton.BackgroundColor = Color.LightGray;
            if (loadData.TryGetValue(dfLayoutEmbeddedImage.Name, out value))
            {
                if (!string.IsNullOrWhiteSpace(value))
                {
                    byte[] data = Convert.FromBase64String(value);
                    embeddedImageCapture.DataToImage(data);
                }
            }
            else
            {
                if (dfLayoutEmbeddedImage.Properties.Required)
                    embeddedImageCapture.BackgroundColor = isRequiredColor;
            }

            return new Tuple<View, Boolean>(embeddedImageCapture, dfLayoutEmbeddedImage.Properties.Required);
        }

        private Tuple<View, Boolean> LoadVideoField(DFLayoutControl element)
        {
            string value = "";
            bool disableLibrary = false;
            DFLayoutVideoField vidField = element as DFLayoutVideoField;

            EmbeddedImageCapture embeddedImageCapture = new EmbeddedImageCapture(false, true);

            embeddedImageCapture.VideoQuality =
                vidField.Properties.Quality == DFLayoutVideoFieldProperties.VideoQuality.Low ? Plugin.Media.Abstractions.VideoQuality.Low :
                vidField.Properties.Quality == DFLayoutVideoFieldProperties.VideoQuality.Medium ? Plugin.Media.Abstractions.VideoQuality.Medium :
                vidField.Properties.Quality == DFLayoutVideoFieldProperties.VideoQuality.High ? Plugin.Media.Abstractions.VideoQuality.High :
                vidField.Properties.Quality == DFLayoutVideoFieldProperties.VideoQuality.Default ? Plugin.Media.Abstractions.VideoQuality.Medium :
                Plugin.Media.Abstractions.VideoQuality.Medium;           

           embeddedImageCapture.VideoLength =
                vidField.Properties.MaximumVideoLength == 0 ? new TimeSpan(0, 0, 20) :
                new TimeSpan(0, 0, vidField.Properties.MaximumVideoLength);

            if (loadData.TryGetValue(vidField.Name, out value))
            {
                byte[] data = Convert.FromBase64String(value);
            }
            else
            {
                if (vidField.Properties.Required)
                    embeddedImageCapture.BackgroundColor = isRequiredColor;
            }
            return new Tuple<View, Boolean>(embeddedImageCapture, vidField.Properties.Required);
        }

        private Tuple<View, Boolean> LoadMultiImage(DFLayoutControl element)
        {
            string value = "";
            bool disableLibrary = false;
            DFLayoutMultiImage dfLayoutMultiEmbeddedImage = element as DFLayoutMultiImage;
            try
            {
                disableLibrary = dfLayoutMultiEmbeddedImage.Properties.DisableLibrary;
            }
            catch { }
            MultiImageCapture multiImageCapture = new MultiImageCapture(disableLibrary);
            if (loadData.TryGetValue(dfLayoutMultiEmbeddedImage.Name, out value))
            {
                List<string> values = Serialization.Deserialize<List<string>>(value);
                foreach (string s in values)
                {
                    byte[] data = Convert.FromBase64String(s);
                    multiImageCapture.DataToImage(data);
                }
            }

            return new Tuple<View, bool>(multiImageCapture, dfLayoutMultiEmbeddedImage.Properties.Required);
        }

        private Tuple<View, bool> LoadMultiSignaturePad(DFLayoutControl element)
        {
            string value = "";
            DFLayoutMultiSignaturePad dfLayoutMultiSignaturePad = element as DFLayoutMultiSignaturePad;
            DataButtonControl button = new DataButtonControl
            {
                Text = "Add Signatures",
            };
            if (loadData.TryGetValue(dfLayoutMultiSignaturePad.Name, out value))
            {
                button.Data = value;
            }
            MultiSignaturePad multiSignaturePad = new MultiSignaturePad(button.Data);
            multiSignaturePad.OnMultiSignatureSaved += (result) =>
            {
                button.Data = result;
            };
            button.Clicked += (object sender, EventArgs e) =>
            {
                Navigation.PushAsync(multiSignaturePad);
            };

            return new Tuple<View, bool>(button, dfLayoutMultiSignaturePad.Properties.Required);
        }

        private Tuple<View, bool> LoadAddTaskField(DFLayoutControl element)
        {
            string value = "";
            DFLayoutAddTaskField field = element as DFLayoutAddTaskField;
            DFCreateTaskView taskView = new DFCreateTaskView();
            taskView.OnAddTaskButtonClicked += () =>
            {
                AddEditTask addEditTask = new AddEditTask(Guid.Empty, "New task from Digital Form");
                if (field.Properties.TaskType != null)
                {
                    addEditTask.kanban.Type.ID = field.Properties.TaskType.ID;
                    try
                    {
                        addEditTask.kanban.Type.Description = new Client<KanbanType>().Query
                        (new Filter<KanbanType>(x => x.ID).IsEqualTo(field.Properties.TaskType.ID),
                        new Columns<KanbanType>(x => x.Description)).Rows.FirstOrDefault().Values[0].ToString();
                    }
                    catch { }
                    addEditTask.UpdateScreen(true);
                }
                addEditTask.OnTaskSaved += (taskNumber) =>
                {
                    taskView.DisableButton();
                    taskView.TaskNumber = taskNumber.ToString();
                };
                Navigation.PushAsync(addEditTask);
            };
            if (loadData.TryGetValue(field.Name, out value))
            {
                taskView.TaskNumber = value;
                taskView.DisableButton();
            }

            return new Tuple<View, bool>(taskView, field.Properties.Required);
        }

        private void FormatAndAddView(View view, DFLayoutControl element, bool isrequired, bool requiresFrame)
        {
            try
            {
                if (element is DFLayoutField)
                {
                    pairs[element as DFLayoutField] = view;
                    if (isSecure || readOnly || !string.IsNullOrWhiteSpace((element as DFLayoutField).GetPropertyValue<string>("Expression")))
                        view.IsEnabled = false;

                    if (requiresFrame)
                    {
                        MobileCard frame = new MobileCard
                        {
                            Content = view,
                            BorderColor = Color.Gray,
                            BackgroundColor = Color.LightYellow,
                            CornerRadius = 5,
                            Padding = 2,
                            HasShadow = false,
                        };
                        if (readOnly || isSecure)
                        {
                            frame.BorderColor = Color.Gray;
                            frame.BackgroundColor = Color.LightGray;
                            frame.VerticalOptions = LayoutOptions.FillAndExpand;
                            frame.MinimumHeightRequest = 60;
                        }

                        if (isrequired)
                        {
                            frame.BackgroundColor = isRequiredColor;
                        }

                        view = frame;
                    }
                }

                if (element.Row > 0)
                    SetRow(view, element.Row - 1); //rows and columns coming in from the desktop designer start from 1, not 0 (most of the time??)
                else if (element.Row == 0)
                    SetRow(view, dfLayout.RowHeights.Count + 1);
                if (element.RowSpan > 0)
                    SetRowSpan(view, element.RowSpan);
                else if (element.RowSpan == 0)
                    SetRowSpan(view, 1);
                if (element.Column > 0)
                    SetColumn(view, element.Column - 1); //rows and columns coming in from the desktop designer start from 1, not 0 (most of the time??)
                if (element.ColumnSpan > 0)
                    SetColumnSpan(view, element.ColumnSpan);

                if (element.ColumnSpan > 1)
                {
                    view.HorizontalOptions = LayoutOptions.FillAndExpand;
                    if (view is Label)
                    {
                        view.HorizontalOptions = LayoutOptions.CenterAndExpand;
                        Label lblView = view as Label;
                        lblView.HorizontalTextAlignment = TextAlignment.Center;
                        view = lblView;
                    }
                }
                else if (element.ColumnSpan == 0) SetColumnSpan(view, 1);

                view.SetValue(Grid.MarginProperty, 0.01);

                if (element is DFLayoutSignaturePad)
                    view.Margin = new Thickness(25, 0, 25, 0);

                Device.BeginInvokeOnMainThread(() =>
                {
                    Children.Add(view);
                });

                if (element is DFLayoutHeader)
                    if ((element as DFLayoutHeader).Collapsed)
                        headersToCollapse.Add(view as DigitalFormsHeader);
            }
            catch
            { }
        }
        #endregion

        #region Save 
        public void SaveData(bool saveForLater)
        {
            try
            {
                results.Clear();
                propertyResults.Clear();
                isRequiredEmpty = false;
                isRequiredMessage = "";
                foreach (DFLayoutField field in pairs.Keys)
                {
                    View view = pairs[field];
                    String userInput = AddResultsToDictionary(field, view);
                    if (isRequiredEmpty)
                    {
                        if (!saveForLater)
                            return;
                    }
                    AddPropertyToDictionary(field, userInput);
                }
                UpdateInstanceAndModel(saveForLater);
            }
            catch (Exception ex)
            {
                
            }
        }

        #region Adding Results to dictionaries
        private string AddResultsToDictionary(DFLayoutField field, View view, bool AddToDictionary = true) //"results" dictionary is the data to be saved in Form.Data
        {
            string userInput = "";
            if (field is DFLayoutStringField || field is DFLayoutIntegerField || field is DFLayoutDoubleField)
            {
                if (field is DFLayoutStringField && (field as DFLayoutStringField).Properties.PopupEditor)
                    userInput = (view as DataButtonControl).Data;
                else
                    userInput = (view as Editor).Text;
            }
            else if (field is DFLayoutBooleanField)
            {
                if ((view as CustomBoolean).ValueChanged)
                {
                    userInput = (view as CustomBoolean).Value.ToString();
                }
            }
            else if (field is DFLayoutDateField)
            {
                userInput = ((view as DatePicker).Date).ToString("dd-MM-yyyy");
            }
            else if (field is DFLayoutTimeField)
            {
                userInput = ((view as TimePicker).Time).ToString("c");
            }
            else if (field is DFLayoutOptionField)
            {
                userInput = GetStringFromOptionField(view);
            }
            else if (field is DFLayoutLookupField)
            {
                if (view is DataButtonControl)
                {
                    var button = view as DataButtonControl;
                    userInput = FindIDForDesignLookupField(button); //userinput is used to set guid later on for properties, but will not get added to form data only for lookupfields             
                    results.Add(field.Name, button.Data);

                    if (RetainedResults.IsFormRetained)
                        if ((field as DFLayoutLookupField).Properties.Retain)
                            RetainedResults.Results.Add(field.Name, button.Data);
                }
                else if (view is FrameButton) //currently only used for Products - we already have the Product.ID in Framebutton.Data (saved as Code,ID)
                {
                    FrameButton framebutton = view as FrameButton;
                    if (!string.IsNullOrWhiteSpace(framebutton.Data))
                    {
                        string[] buttonData = framebutton.Data.Split(',');
                        if (AddToDictionary)
                            results.Add(field.Name, buttonData[0]); //[0] is product.code
                        userInput = buttonData[1]; //[1] is product id as string

                        if (RetainedResults.IsFormRetained)
                            if ((field as DFLayoutLookupField).Properties.Retain)
                                RetainedResults.Results.Add(field.Name, buttonData[0]);
                    }
                }
            }
            else if (field is DFLayoutSignaturePad)
            {
                string value = "";
                var grid = view as Grid;
                var signaturePad = grid.Children.OfType<SfSignaturePad>().FirstOrDefault();
                DFLayoutSignaturePad dFLayoutSignaturePad = field as DFLayoutSignaturePad;
                if (loadData.TryGetValue(dFLayoutSignaturePad.Name, out value))
                {
                    userInput = value;
                }
                else
                {
                    if (useSavedSignatures.Contains(dFLayoutSignaturePad.Name))
                    {
                        ImageSource src = ImageSource.FromStream(() => new MemoryStream((Application.Current.Properties["SavedSignature"]) as byte[]));
                        userInput = ImageSourceToBase64(src);
                    }
                    else
                    {
                        signaturePad.Save();
                        if (signaturePad.ImageSource != null)
                        {
                            userInput = ImageSourceToBase64(signaturePad.ImageSource);
                        }
                    }
                }
            }
            else if (field is DFLayoutEmbeddedImage)
            {
                var embeddedImage = view as EmbeddedImageCapture;
                if (embeddedImage.Image.Source != null)
                {
                    try
                    {
                        userInput = ImageSourceToBase64(embeddedImage.Image.Source);
                    }
                    catch (Exception e)
                    {
                        userInput = "";
                    }
                }
            }
            else if (field is DFLayoutVideoField)
            {
                var embeddedImage = view as EmbeddedImageCapture;
                if (embeddedImage.bytes != null)
                {
                    if (embeddedImage.bytes.Length > 0)
                    {
                        try
                        {
                            userInput = BytesToBase64(embeddedImage.bytes);
                        }
                        catch (Exception e)
                        {
                            userInput = "";
                        }
                    }
                }
            }
            else if (field is DFLayoutMultiImage)
            {
                var multiImage = view as MultiImageCapture;
                if (multiImage.Images.Count > 0)
                {
                    try
                    {
                        userInput = ImagesToBase64(multiImage.Images);
                    }
                    catch (Exception e)
                    {
                        userInput = "";
                    }
                }
            }
            else if (field is DFLayoutAddTaskField)
            {
                var addTaskButton = view as DFCreateTaskView;
                if (!string.IsNullOrWhiteSpace(addTaskButton.TaskNumber))
                {
                    userInput = addTaskButton.TaskNumber;
                }
            }
            else if (field is DFLayoutMultiSignaturePad)
            {
                var databutton = view as DataButtonControl;
                if (!string.IsNullOrWhiteSpace(databutton.Data))
                    userInput = databutton.Data;
            }

            //add the field name and input to 'results' dictionary for processing outside of QAFormViewer
            if (!String.IsNullOrWhiteSpace(userInput) && AddToDictionary)
            {
                if (field is DFLayoutLookupField)
                { /*do nothing as results have already been added*/ }
                else
                {
                    try
                    {
                        results.Add(field.Name, userInput);
                    }
                    catch (Exception e)
                    {
                        errors.Add(e.Message);
                    }
                    if (RetainedResults.IsFormRetained)
                    {
                        AddRetainedToDictionary(field, userInput);
                    }
                }
            }
            else CheckRequired(field);
            return userInput;
        }

        private void AddPropertyToDictionary(DFLayoutField field, String userInput)
        {
            if (!string.IsNullOrWhiteSpace(userInput))
            {
                try
                {
                    string property = "";
                    if (field is DFLayoutStringField)
                        property = (field as DFLayoutStringField).Properties.Property;
                    else if (field is DFLayoutIntegerField)
                        property = (field as DFLayoutIntegerField).Properties.Property;
                    else if (field is DFLayoutDoubleField)
                        property = (field as DFLayoutDoubleField).Properties.Property;
                    else if (field is DFLayoutBooleanField)
                        property = (field as DFLayoutBooleanField).Properties.Property;
                    else if (field is DFLayoutDateField)
                        property = (field as DFLayoutDateField).Properties.Property;
                    else if (field is DFLayoutTimeField)
                        property = (field as DFLayoutTimeField).Properties.Property;
                    else if (field is DFLayoutOptionField)
                        property = (field as DFLayoutOptionField).Properties.Property;
                    else if (field is DFLayoutLookupField)
                        property = (field as DFLayoutLookupField).Properties.Property;

                    //'propertyResults' dictionary for processing outside of QAFormViewer
                    if (!string.IsNullOrWhiteSpace(property)) propertyResults.Add(property, userInput);
                }
                catch (Exception e)
                {
                    errors.Add(e.Message);
                    return;
                }
            }
        }

        private async void AddRetainedToDictionary(DFLayoutField field, string userInput)
        {
            await Task.Run(() =>
            {
                try
                {
                    if (field is DFLayoutStringField)
                    {
                        if ((field as DFLayoutStringField).Properties.Retain)
                            RetainedResults.Results.Add(field.Name, userInput);
                    }
                    else if (field is DFLayoutIntegerField)
                    {
                        if ((field as DFLayoutIntegerField).Properties.Retain)
                            RetainedResults.Results.Add(field.Name, userInput);
                    }
                    else if (field is DFLayoutDoubleField)
                    {
                        if ((field as DFLayoutDoubleField).Properties.Retain)
                            RetainedResults.Results.Add(field.Name, userInput);
                    }
                    else if (field is DFLayoutBooleanField)
                    {
                        if ((field as DFLayoutBooleanField).Properties.Retain)
                            RetainedResults.Results.Add(field.Name, userInput);
                    }
                    else if (field is DFLayoutDateField)
                    {
                        if ((field as DFLayoutDateField).Properties.Retain)
                            RetainedResults.Results.Add(field.Name, userInput);
                    }
                    else if (field is DFLayoutTimeField)
                    {
                        if ((field as DFLayoutTimeField).Properties.Retain)
                            RetainedResults.Results.Add(field.Name, userInput);
                    }
                    else if (field is DFLayoutOptionField)
                    {
                        if ((field as DFLayoutOptionField).Properties.Retain)
                            RetainedResults.Results.Add(field.Name, userInput);
                    }
                }
                catch (Exception e)
                {
                    errors.Add("Retained results error: " + e.Message);
                }
            });

        }
        #endregion

        #region Checks / Custom methods

        private void CheckRequired(DFLayoutField field)
        {
            if (field is DFLayoutStringField)
            {
                if ((field as DFLayoutStringField).Properties.Required)
                {
                    isRequiredEmpty = true;
                    isRequiredMessage = (field as DFLayoutStringField).Description;
                }
            }
            else if (field is DFLayoutIntegerField)
            {
                if ((field as DFLayoutIntegerField).Properties.Required)
                {
                    isRequiredEmpty = true;
                    isRequiredMessage = (field as DFLayoutIntegerField).Description;
                }
            }
            else if (field is DFLayoutDoubleField)
            {
                if ((field as DFLayoutDoubleField).Properties.Required)
                {
                    {
                        isRequiredEmpty = true;
                        isRequiredMessage = (field as DFLayoutIntegerField).Description;
                    }
                }
            }
            else if (field is DFLayoutBooleanField)
            {
                if ((field as DFLayoutBooleanField).Properties.Required)
                {
                    {
                        isRequiredEmpty = true;
                        isRequiredMessage = (field as DFLayoutBooleanField).Description;
                    }
                }
            }
            else if (field is DFLayoutDateField)
            {
                if ((field as DFLayoutDateField).Properties.Required)
                {
                    {
                        isRequiredEmpty = true;
                        isRequiredMessage = (field as DFLayoutDateField).Description;
                    }
                }
            }
            else if (field is DFLayoutTimeField)
            {
                if ((field as DFLayoutTimeField).Properties.Required)
                {
                    {
                        isRequiredEmpty = true;
                        isRequiredMessage = (field as DFLayoutTimeField).Description;
                    }
                }
            }
            else if (field is DFLayoutOptionField)
            {
                if ((field as DFLayoutOptionField).Properties.Required)
                {
                    {
                        isRequiredEmpty = true;
                        isRequiredMessage = (field as DFLayoutOptionField).Description;
                    }
                }
            }
            else if (field is DFLayoutLookupField)
            {
                if ((field as DFLayoutLookupField).Properties.Required)
                {
                    {
                        isRequiredEmpty = true;
                        isRequiredMessage = (field as DFLayoutLookupField).Description;
                    }
                }
            }
            else if (field is DFLayoutSignaturePad)
            {
                if ((field as DFLayoutSignaturePad).Properties.Required)
                {
                    {
                        isRequiredEmpty = true;
                        isRequiredMessage = (field as DFLayoutSignaturePad).Description;
                    }
                }
            }
            else if (field is DFLayoutEmbeddedImage)
            {
                if ((field as DFLayoutEmbeddedImage).Properties.Required)
                {
                    {
                        isRequiredEmpty = true;
                        isRequiredMessage = (field as DFLayoutEmbeddedImage).Description;
                    }
                }
            }
            else if (field is DFLayoutMultiImage)
            {
                if ((field as DFLayoutMultiImage).Properties.Required)
                {
                    {
                        isRequiredEmpty = true;
                        isRequiredMessage = (field as DFLayoutMultiImage).Description;
                    }
                }
            }
            else if (field is DFLayoutMultiSignaturePad)
            {
                if ((field as DFLayoutMultiSignaturePad).Properties.Required)
                {
                    {
                        isRequiredEmpty = true;
                        isRequiredMessage = (field as DFLayoutMultiSignaturePad).Description;
                    }
                }
            }
        }

        private string ImagesToBase64(List<Image> images)
        {
            List<string> strings = new List<string>();
            foreach (Image image in images)
            {
                strings.Add(ImageSourceToBase64(image.Source));
            }
            return Serialization.Serialize(strings);
        }

        private string ImageSourceToBase64(ImageSource source)
        {
            StreamImageSource streamImageSource = (StreamImageSource)source;
            System.Threading.CancellationToken cancellationToken = System.Threading.CancellationToken.None;
            Task<Stream> task = streamImageSource.Stream(cancellationToken);
            Stream stream = task.Result;
            byte[] bytes = new byte[stream.Length];
            stream.Read(bytes, 0, bytes.Length);
            string s = Convert.ToBase64String(bytes, Base64FormattingOptions.InsertLineBreaks);
            return s;
        }

        private string BytesToBase64(byte[] bytes)
        {
            string s = Convert.ToBase64String(bytes, Base64FormattingOptions.InsertLineBreaks);
            return s;
        }

        private string FindIDForDesignLookupField(DataButtonControl button)
        {
            try
            {
                string userInputValue = button.Data;
                string guidString = "";
                if (userInputValue != nullOrInvalidType)
                {
                    foreach (KeyValuePair<DFLayoutLookupField, Dictionary<Guid, string>> pair in dfLayoutLookupFieldLookupOptions)
                    {
                        foreach (KeyValuePair<Guid, string> innerPair in pair.Value)
                        {
                            if (innerPair.Value == userInputValue)
                            {
                                guidString = innerPair.Key.ToString();
                            }
                        }
                    }
                }

                return guidString;
            }
            catch
            {
                return "";
            }
        }
        #endregion

        #region Save Completion
        //point of determination for whether or not QA form gets completed or saved for later
        private void UpdateInstanceAndModel(bool saveForLater)
        {
            if (results.Count != 0)
            {
                if (!saveForLater)
                {
                    CompleteForm();
                }
                model.Instance.FormCompletedBy.ID = userID;
                if (digitalFormID != Guid.Empty) model.Instance.Form.ID = digitalFormID;

                DigitalForm.SerializeFormData(model.Instance, QueryVariables(model.Instance), results.ToDictionary(x => x.Key, x => x.Value as object));

                FormData = model.Instance.FormData;
                if (model.Instance.FormStarted == DateTime.MinValue)
                {
                    model.Instance.FormStarted = timeStarted;
                }
                TimeSpan span = DateTime.Now - timeStarted;
                model.Instance.FormOpen = model.Instance.FormOpen + span;
                model.Update(null);
            }
        }

        public List<DigitalFormVariable> QueryVariables(IDigitalFormInstance form)
        {
            List<DigitalFormVariable> variables = new List<DigitalFormVariable>();
            var table = new Client<DigitalFormVariable>().Query(
                    new Filter<DigitalFormVariable>(x => x.Form.ID).IsEqualTo(form.Form.ID),
                    new Columns<DigitalFormVariable>(x => x.Code, x => x.Parameters, x => x.Description, x => x.VariableType),
                    null
                    );
            foreach (CoreRow coreRow in table.Rows)
            {
                var variable = coreRow.ToObject<DigitalFormVariable>();
                variables.Add(variable);
            }
            return variables;
        }

        private void CompleteForm()
        {
            model.Instance.FormCompleted = DateTime.Now;
            FormCompleted = model.Instance.FormCompleted;
            model.Instance.Location.Longitude = location.Longitude;
            model.Instance.Location.Latitude = location.Latitude;
            model.Instance.Location.Timestamp = model.Instance.FormCompleted;
        }
        #endregion
        #endregion

        #region Expressions
        public object GetFieldValue(string field)
        {
            try
            {
                Tuple<DFLayoutField, View> tuple = FindView(field);
                return GetValueFromView(tuple.Item1, tuple.Item2);
            }
            catch
            {
                return "";
            }
        }

        public void SetFieldValue(string field, object value)
        {
            try
            {
                Tuple<DFLayoutField, View> tuple = FindView(field);
                SetValueOfView(tuple.Item1, tuple.Item2, value);
            }
            catch { }
        }

        private void SetValueOfView(DFLayoutField field, View view, object value)
        {
            if (field is DFLayoutBooleanField)
                (view as CustomBoolean).Value = (bool)value;

            else if (field is DFLayoutStringField || field is DFLayoutIntegerField || field is DFLayoutDoubleField)
            {
                if (field is DFLayoutStringField && (field as DFLayoutStringField).Properties.PopupEditor)
                {
                    (view as DataButtonControl).Data = value.ToString();
                    (view as DataButtonControl).Text = value.ToString();
                }
                else
                    (view as Editor).Text = value.ToString();
            }

            else if (field is DFLayoutDateField)
                (view as DatePicker).Date = (DateTime)(value as DateTime?);

            else if (field is DFLayoutDateTimeField)
                (view as TimePicker).Time = (TimeSpan)(value as TimeSpan?);

            else if (field is DFLayoutOptionField)
                AssignPickerOption(view, field as DFLayoutOptionField, value as string);

            else if (field is DFLayoutLookupField)
                AssignLookupOption(view, value as string);

            else if (field is DFLayoutEmbeddedImage)
                AssignImage(view, value as byte[]);
        }

        private void AssignImage(View view, byte[] bytes)
        {
            var imageCapture = view as EmbeddedImageCapture;
            imageCapture.DataToImage(bytes);
        }

        private void AssignLookupOption(View view, string value)
        {
            if (view is DataButtonControl)
            {
                (view as DataButtonControl).Text = value;
                (view as DataButtonControl).Data = value;
            }
            else if (view is FrameButton) //currently only used for Products - we already have the Product.ID in Framebutton.Data (saved as Code,ID)
            {
                (view as FrameButton).SetButtonText(value);
                (view as FrameButton).Data = value + "," + Guid.Empty.ToString();
            }
        }

        private Tuple<DFLayoutField, View> FindView(string field)
        {
            DFLayoutField dflayoutfield = pairs.Keys.FirstOrDefault(x => x.Name == field);
            View view = pairs[dflayoutfield];
            return new Tuple<DFLayoutField, View>(dflayoutfield, view);
        }

        private void AssignPickerOption(View view, DFLayoutOptionField field, string value)
        {
            string s = field.Properties.Options;
            string[] substrings = s.Split(',');
            var optionList = substrings.ToList();

            if (Device.RuntimePlatform == Device.iOS)
            {
                var iOSPicker = view as CustomPickeriOS;
                iOSPicker.SelectedIndex = optionList.IndexOf(value);
            }
            else
            {
                var picker = view as Picker;
                picker.SelectedIndex = optionList.IndexOf(value);
            }
        }

        private object GetValueFromView(DFLayoutField field, View view)
        {
            if (field is DFLayoutBooleanField)
                return (view as CustomBoolean).Value;

            if (field is DFLayoutStringField)
            {
                if ((field as DFLayoutStringField).Properties.PopupEditor)
                    return (view as DataButtonControl).Data;
                else
                    return (view as Editor).Text;
            }

            else if (field is DFLayoutIntegerField)
                return int.Parse((view as Editor).Text);

            else if (field is DFLayoutDoubleField)
                return double.Parse((view as Editor).Text);

            else if (field is DFLayoutDateField)
                return (view as DatePicker).Date;

            else if (field is DFLayoutDateTimeField)
                return (view as TimePicker).Time;

            else if (field is DFLayoutOptionField)
                return GetStringFromOptionField(view);

            else if (field is DFLayoutLookupField)
                return GetStringFromLookupField(view);

            else if (field is DFLayoutSignaturePad)
                return GetByteArrayFromSignaturePad(view, field.Name);

            else if (field is DFLayoutEmbeddedImage)
                return GetByteArrayFromEmbeddedImage(view);

            else if (field is DFLayoutMultiImage)
                return GetByteArrayListFromMultiImage(view);

            else return "";
        }

        private object GetByteArrayListFromMultiImage(View view)
        {
            List<byte[]> list = new List<byte[]>();
            var multiImage = view as MultiImageCapture;
            if (multiImage.Images.Count > 0)
            {
                foreach (Image image in multiImage.Images)
                {
                    string base64 = ImageSourceToBase64(image.Source);
                    list.Add(Convert.FromBase64String(base64));
                }
            }
            return list;
        }

        private object GetByteArrayFromEmbeddedImage(View view)
        {
            var embeddedImage = view as EmbeddedImageCapture;
            if (embeddedImage.Image.Source != null)
            {
                string base64 = ImageSourceToBase64(embeddedImage.Image.Source);
                return Convert.FromBase64String(base64);
            }
            else
                return null;
        }

        private byte[] GetByteArrayFromSignaturePad(View view, string name)
        {
            var grid = view as Grid;
            var signaturePad = grid.Children.OfType<SfSignaturePad>().FirstOrDefault();
            if (useSavedSignatures.Contains(name))
            {
                return Application.Current.Properties["SavedSignature"] as byte[];
            }
            else
            {
                signaturePad.Save();
                if (signaturePad.ImageSource != null)
                {
                    string base64 = ImageSourceToBase64(signaturePad.ImageSource);
                    return Convert.FromBase64String(base64);
                }
                else
                    return null;
            }
        }

        private object GetStringFromLookupField(View view)
        {
            string value = "";
            if (view is DataButtonControl)
            {
                var button = view as DataButtonControl;
                value = FindIDForDesignLookupField(button); //userinput is used to set guid later on for properties, but will not get added to form data only for lookupfields                                          
            }
            else if (view is FrameButton) //currently only used for Products - we already have the Product.ID in Framebutton.Data (saved as Code,ID)
            {
                FrameButton framebutton = view as FrameButton;
                if (!string.IsNullOrWhiteSpace(framebutton.Data))
                {
                    string[] buttonData = framebutton.Data.Split(',');
                    value = buttonData[1]; //[1] is product id as string
                }
            }
            return value;
        }

        private string GetStringFromOptionField(View view)
        {
            if (Device.RuntimePlatform == Device.iOS)
            {
                var iOSPicker = view as CustomPickeriOS;
                if (iOSPicker.SelectedIndex != -1)
                {
                    return iOSPicker.SelectedItem.ToString();
                }
                else
                    return "";
            }
            else
            {
                var picker = view as Picker;
                if (picker.SelectedIndex != -1)
                {
                    return picker.SelectedItem.ToString();
                }
                else
                    return "";
            }
        }

        public object GetFieldData(string fieldName, string dataField)
        {
            Tuple<DFLayoutField, View> tuple = FindView(fieldName);
            try
            {
                if (tuple.Item1 is DFLayoutLookupField)
                {
                    DFLayoutLookupField field = tuple.Item1 as DFLayoutLookupField;
                    string type = field.Properties.LookupType;
                    Type lookuptype = CoreUtils.GetEntityOrNull(type);
                    if (lookuptype == typeof(Product))
                    {
                        var framebutton = tuple.Item2 as FrameButton;
                        string[] buttonData = framebutton.Data.Split(',');
                        string id = buttonData[1]; //[1] is product id as string

                        CoreTable table = new Client<Product>().Query(new Filter<Product>(x => x.ID).IsEqualTo(Guid.Parse(id)), new Columns<Product>(x => x.Image.ID));
                        if (table.Rows.Any())
                        {
                            Guid returnid = table.Rows.FirstOrDefault().Get<Product, Guid>(x => x.Image.ID);
                            return returnid;
                        }
                        else
                            return null;
                    }
                    else
                    {
                        var button = tuple.Item2 as DataButtonControl;
                        Dictionary<string, object> dict = button.ExtraData[button.ChosenID];
                        return dict[dataField];
                    }
                }
                else
                    return null;
            }
            catch
            {
                return null;
            }

        }

        public void SetFieldColour(string field, System.Drawing.Color? colour = null)
        {
            if (colour != null)
            {
                try
                {
                    System.Drawing.Color color = (System.Drawing.Color)colour;
                    FindView(field).Item2.BackgroundColor = Color.FromRgba(
                        Convert.ToDouble(color.R),
                        Convert.ToDouble(color.G),
                        Convert.ToDouble(color.B),
                        Convert.ToDouble(color.A));
                }
                catch { }
            }
        }
        #endregion


    }
}