Exemplo n.º 1
0
        public async void SubmitCartToAzureLocalDB()
        {
            try
            {
                List <OrderItems> Items = new List <OrderItems>();
                for (int i = 0; i < CartItems.Count; i++)
                {
                    Items.Add(new OrderItems()
                    {
                        ItemCount = CartItems[i].Count, ItemID = CartItems[i].ID, OrderID = OrderID, Id = Guid.NewGuid().ToString()
                    });
                }

                Order order = new Order()
                {
                    SubmittedOffline = true,
                    ID     = OrderID,
                    UserID = SharedUser.ID,
                };

                await client.InsertOfflineSyncObjectAsync <Order>(order, OrdersTable);

                for (int i = 0; i < Items.Count; i++)
                {
                    await client.InsertOfflineSyncObjectAsync <OrderItems>(Items[i], OrdersItemsTable);
                }
            }
            catch (Exception)
            {
                await PopUpsHelper.DisplayMessage("Connection Error", "Error While Submitting To Local DB", "OK");
            }
        }
Exemplo n.º 2
0
        private async Task SyncAllTables()
        {
            var ItemsTable      = OfflineManager.GetOfflineSyncTableReference <Item>();
            var UsersTable      = OfflineManager.GetOfflineSyncTableReference <User>();
            var OrdersTable     = OfflineManager.GetOfflineSyncTableReference <Order>();
            var OrderItemsTable = OfflineManager.GetOfflineSyncTableReference <OrderItems>();

            if (Connectivity.NetworkAccess == NetworkAccess.Internet)
            {
                await OfflineManager.PushAsync();

                await OfflineManager.PullAsync <Item>(ItemsTable);

                await OfflineManager.PullAsync <User>(UsersTable);

                await OfflineManager.PullAsync <Order>(OrdersTable);

                await OfflineManager.PullAsync <OrderItems>(OrderItemsTable);

                //var result = await OfflineManager.GetAllOfflineSyncItemsAsync<Item>(ItemsTable);
                //var result1 = await OfflineManager.GetAllOfflineSyncItemsAsync<User>(UsersTable);
                //var result2 = await OfflineManager.GetAllOfflineSyncItemsAsync<Order>(OrdersTable);
                //var result4 = await OfflineManager.GetAllOfflineSyncItemsAsync<OrderItems>(OrderItemsTable);
            }
            else
            {
                await PopUpsHelper.DisplayMessage("Connection Error", "Please Connect your phone to the internet to sync items", "OK");
            }
        }
Exemplo n.º 3
0
        public async Task SyncItems()
        {
            try
            {
                IsLoading = true;
                var Table = OfflineManager.GetOfflineSyncTableReference <Item>();
                if (Connectivity.NetworkAccess == NetworkAccess.Internet)
                {
                    await OfflineManager.PushAsync();

                    await OfflineManager.PullAsync <Item>(Table);

                    await NavigationHelper.PopPageAsync();

                    await NavigationHelper.NavigateToPageAsync(new HomePage());
                }
                else
                {
                    await PopUpsHelper.DisplayMessage("Connection Error", "Please Connect your phone to the internet", "OK");

                    IsLoading = false;
                }
            }
            catch (Exception ex)
            {
                IsLoading = false;
                await PopUpsHelper.DisplayMessage("Sync Error", "Error While Syncing new products", "OK");
            }
        }
Exemplo n.º 4
0
        public async Task <ObservableCollection <Item> > GetCartItemsFromAzureLocalDB()
        {
            try
            {
                IsLoading = true;

                AllItems = await client.GetAllOfflineSyncItemsAsync <Item>(ItemsTable);

                Users = await client.GetAllOfflineSyncItemsAsync <User>(UsersTable);

                Orders = await client.GetAllOfflineSyncItemsAsync <Order>(OrdersTable);

                OrdersItems = await client.GetAllOfflineSyncItemsAsync <OrderItems>(OrdersItemsTable);


                User          User     = SharedUser;
                Order         Order    = Orders.FirstOrDefault(o => (o.UserID == User.ID && (o.SubmittedOffline == false || o.SubmittedOnline == false)));
                List <string> ItemsIDS = OrdersItems.Where(i2 => i2.OrderID == Order.ID).Select(i => i.ItemID).ToList();

                CartItems = new ObservableCollection <Item>(AllItems.Where(o =>
                {
                    var orderitem = OrdersItems.FirstOrDefault(oi => oi.ItemID == o.ID);
                    if (orderitem != null)
                    {
                        o.Count = orderitem.ItemCount;
                    }

                    return(ItemsIDS.Contains(o.ID));
                }));
                if (CartItems.Count == 0)
                {
                    IsCartNotEmpty = false;
                }
                else
                {
                    IsCartNotEmpty = true;
                }
                IsLoading = false;
                return(CartItems);
            }
            catch (Exception)
            {
                IsLoading = false;
                await PopUpsHelper.DisplayMessage("Connection Error", "Error While getting Data From local DB", "OK");

                return(null);
            }
        }
Exemplo n.º 5
0
        public async Task GetAllItemsFromLocalDBAsync()
        {
            try
            {
                IsLoading = true;
                var Table  = OfflineManager.GetOfflineSyncTableReference <Item>();
                var result = await OfflineManager.GetAllOfflineSyncItemsAsync <Item>(Table);

                for (int i = 0; i < result?.Count; i++)
                {
                    result[i].SmallDetails = result[i].Details.Length > 51 ? result[i].Details.Substring(0, 50) : result[i].Details;
                }
                Filter(result);
                IsLoading = false;
            }
            catch (Exception ex)
            {
                IsLoading = false;
                await PopUpsHelper.DisplayMessage("Sync Error", "Error While Getting all offline products", "OK");
            }
        }
Exemplo n.º 6
0
        public async void SubmitCartToAzureDB()
        {
            try
            {
                if (InternetConnected)
                {
                    List <OrderItems> Items = new List <OrderItems>();
                    for (int i = 0; i < SQLITEItems.Count; i++)
                    {
                        Items.Add(new OrderItems()
                        {
                            ItemCount = SQLITEItems[i].Count, ItemID = SQLITEItems[i].ItemID
                        });
                    }

                    Order order = new Order()
                    {
                        User = new Models.User()
                        {
                            Name = SharedUser.Name, ID = SharedUser.ID
                        },
                        OrderItems = Items,
                    };

                    var table = Client.GetTableReference <Order>();
                    await Client.InsertObjectAsync(order, table);
                }
                else
                {
                    await PopUpsHelper.DisplayMessage("Connection Error", "Please Connect your phone to the internet to Submit Order items", "OK");
                }
            }
            catch (Exception ex)
            {
                await PopUpsHelper.DisplayMessage("Connection Error", "Please Check Your Internet", "OK");
            }
        }