prs/prs.mobile/comal.timesheets/StoreRequis/StoreRequiList.xaml.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Comal.Classes;
using InABox.Clients;
using InABox.Core;
using Xamarin.Forms;
using Xamarin.Forms.Xaml;
using ZXing.PDF417.Internal;
using static comal.timesheets.RequiItems;

namespace comal.timesheets.StoreRequis
{
    [XamlCompilation(XamlCompilationOptions.Compile)]
    public partial class StoreRequiList : ContentPage
    {
        List<RequiShell> requiShells = new List<RequiShell>();
        public StoreRequiList()
        {
            InitializeComponent();
            //LoadHoldingsCache();
            HoldingsLoaded = true;
            if (Device.RuntimePlatform.Equals(Device.iOS))
            {
                imageBtn0.Margin = new Thickness(0);
                imageBtn0.VerticalOptions = LayoutOptions.FillAndExpand;
                imageBtn0.HeightRequest = 160;
                takerequinow.Margin = new Thickness(0);
                takerequinow.VerticalOptions = LayoutOptions.FillAndExpand;
                takerequinow.HeightRequest = 160;
                storereqimg.Margin = new Thickness(0);
                storereqimg.HeightRequest = 120;
            }
        }

        protected override void OnAppearing()
        {
            LoadList();
            base.OnAppearing();
        }

        private async void LoadList()
        {
            await Task.Run(() =>
            {
                requiShells.Clear();
                CoreTable table = new Client<Requisition>().Query(
                        new Filter<Requisition>(x => x.Filled).IsEqualTo(DateTime.MinValue),
                        new Columns<Requisition>(
                            x => x.ID, //0
                            x => x.Number, //1
                            x => x.Due, //2
                            x => x.RequestedBy.Name, //3
                            x => x.JobLink.JobNumber, //4
                            x => x.JobLink.Name, //5
                            x => x.Request //6
                            ),
                        new SortOrder<Requisition>(x => x.Due)
                    );
                foreach (var row in table.Rows)
                {
                    List<object> list = row.Values;
                    if (list[0] == null) { list[0] = Guid.Empty; } //0
                    if (list[1] == null) { list[1] = 0; } //1
                    if (list[2] == null) { list[2] = DateTime.MinValue; } //2
                    if (list[3] == null) { list[3] = ""; } //3
                    if (list[4] == null) { list[4] = ""; } //4
                    if (list[5] == null) { list[5] = ""; } //5
                    if (list[6] == null) { list[6] = ""; } //6

                    RequiShell requiShell = new RequiShell();
                    requiShell.ID = Guid.Parse(list[0].ToString());
                    requiShell.Number = "No. " + list[1].ToString();
                    requiShell.Due = "Due " + DateTime.Parse(list[2].ToString()).ToString("dd MMM yy");
                    requiShell.Contact = "Contact: " + list[3].ToString();
                    requiShell.Job = "(" + list[4].ToString() + ") " + list[5].ToString();
                    requiShell.Request = list[6].ToString();

                    requiShells.Add(requiShell);
                }
                Device.BeginInvokeOnMainThread(() =>
                {
                    requisListView.ItemsSource = null;
                    requisListView.ItemsSource = requiShells;
                    listLbl.Text = "List of Unfilled Requis (" + requiShells.Count + ")";
                });
            });
        }

        private void Requi_Clicked(object sender, EventArgs e)
        {
            RequiShell requiShell = requisListView.SelectedItem as RequiShell;
            StoreRequiScannerPage storeRequiScannerPage = new StoreRequiScannerPage(requiShell.ID);
            Navigation.PushAsync(storeRequiScannerPage);
        }

        private void TakeStockNow_Tapped(object sender, EventArgs e)
        {
            StoreRequiScannerPage page = new StoreRequiScannerPage(Guid.Empty);
            Navigation.PushAsync(page);
        }

        private void NewRequiRequest_Tapped(object sender, EventArgs e)
        {
            StoreRequiConfirmationPage storeRequiConfirmationPage = new StoreRequiConfirmationPage();
            Navigation.PushAsync(storeRequiConfirmationPage);
        }       
    }

    public class RequiShell
    {
        public Guid ID { get; set; }
        public string Number { get; set; }
        public string Due { get; set; }
        public string Contact { get; set; }
        public string Job { get; set; }

        public string Request { get; set; }

        public RequiShell()
        {
            ID = Guid.Empty;
            Number = "";
            Due = "";
            Due = "";
            Job = "";
            Request = "";
        }
    }
}