prs/prs.mobile/comal.timesheets/Data Classes/CacheLoader.cs

using comal.timesheets.CustomControls;
using Comal.Classes;
using InABox.Clients;
using InABox.Core;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Xamarin.Forms;
using PRSSecurity = InABox.Core.Security;

namespace comal.timesheets
{
    public static class CacheLoader
    {
        #region Jobs
        public static void LoadJobs()
        {
            Task.Run(() =>
            {
                try
                {
                    List<JobShell> jobShells = new List<JobShell>();

                    if (GlobalVariables.IsJobOnlyEmployee)
                    {
                        CoreTable table = DoJobEmployeeQuery();
                        while (table == null)
                            table = DoJobEmployeeQuery();
                        if (!table.Rows.Any())
                            return;

                        foreach (CoreRow row in table.Rows)
                            jobShells.Add(AddJobShell(row));
                    }

                    else
                    {
                        CoreTable table = DoJobsQuery(AssignFilter());
                        while (table == null)
                            table = DoJobsQuery(AssignFilter());
                        foreach (CoreRow row in table.Rows)
                            jobShells.Add(CreateJobShell(row));
                    }

                    AssignJobShells(jobShells);
                }
                catch
                { }
            });
        }

        private static CoreTable DoJobEmployeeQuery()
        {
            try
            {
                return new Client<JobEmployee>().Query(new Filter<JobEmployee>(x => x.EmployeeLink.ID).IsEqualTo(GlobalVariables.EmpID));
            }
            catch (Exception ex)
            {
                var log = new MobileLogging(LogType.Query, "DoJobEmployeeQuery()", ex.Message + ex.StackTrace, "CacheLoader");
                return null;
            }
        }

        private static void AssignJobShells(List<JobShell> jobShells)
        {
            GlobalVariables.JobShells = jobShells;
            GlobalVariables.JobShells.Insert(0, new JobShell { ID = Guid.Empty, JobNumber = "No Job", Name = "Empty Job", JobStatusDescription = "Hidden" });
            GlobalVariables.JobsLoaded = true;
        }

        private static Filter<Job> AssignFilter()
        {
            Filter<Job> filter = new Filter<Job>(x => x.JobStatus.Active).IsEqualTo(true);

            if (!PRSSecurity.IsAllowed<CanViewAllJobs>())
            {
                List<Guid> jobIDs = new List<Guid>();
                CoreTable jobEmployees = new Client<JobEmployee>().Query(
                    new Filter<JobEmployee>(x => x.EmployeeLink.ID).IsEqualTo(GlobalVariables.EmpID),
                    new Columns<JobEmployee>(x => x.JobLink.ID)
                    );
                foreach (CoreRow row in jobEmployees.Rows)
                {
                    jobIDs.Add(row.Get<JobEmployee, Guid>(x => x.JobLink.ID));
                }
                filter = filter.And(x => x.ID).InList(jobIDs.ToArray());
            }

            return filter;
        }

        private static CoreTable DoJobsQuery(Filter<Job> filter)
        {
            try
            {
                return new Client<Job>().Query(
                                filter,
                                new Columns<Job>(x => x.ID, x => x.Name, x => x.JobNumber, x => x.JobStatus.Description, x => x.Color),
                                new SortOrder<Job>(x => x.JobNumber)
                                );
            }
            catch (Exception ex)
            {
                var log = new MobileLogging(LogType.Query, "DoJobsQuery", ex.Message + ex.StackTrace, "CacheLoader");
                return null;
            }
        }

        private static JobShell CreateJobShell(CoreRow row)
        {
            Job job = row.ToObject<Job>();
            if (job.Color == null)
                job.Color = "";
            JobShell jobshell = new JobShell
            {
                ID = job.ID,
                Name = job.Name,
                JobNumber = job.JobNumber,
                JobStatusDescription = job.JobStatus.Description,
                Color = Color.FromHex(job.Color)
            };

            if (jobshell.JobStatusDescription.Equals("Active Projects"))
                jobshell.JobStatusDescription = "Active";
            else if (jobshell.JobStatusDescription.Equals("Projects - Hidden from View"))
                jobshell.JobStatusDescription = "Hidden";
            else if (jobshell.JobStatusDescription.Equals("Projects in Defect Liability Period"))
                jobshell.JobStatusDescription = "Defect Liability";

            jobshell.DisplayName = "(" + jobshell.JobNumber + ") " + jobshell.Name;

            return jobshell;
        }

        private static JobShell AddJobShell(CoreRow row)
        {
            JobShell job = new JobShell();
            job.ID = row.Get<JobEmployee, Guid>(x => x.JobLink.ID);
            job.JobNumber = row.Get<JobEmployee, string>(x => x.JobLink.JobNumber);
            job.Name = row.Get<JobEmployee, string>(x => x.JobLink.Name);
            job.JobStatusDescription = row.Get<JobEmployee, string>(x => x.JobLink.JobStatus.Description);
            job.DisplayName = "(" + job.JobNumber + ") " + job.Name;
            return job;
        }
        #endregion
    }
}