Example #1
0
        public async Task <JsonBoxData> ScanBoxes()
        {
            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri("http://10.10.14.13:8081/");
                client.DefaultRequestHeaders.Accept.Clear();
                client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

                try
                {
                    HttpResponseMessage response = await client.GetAsync("scanOnce");

                    if (response.IsSuccessStatusCode)
                    {
                        DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(JsonBoxData));
                        Stream s = await response.Content.ReadAsStreamAsync();

                        JsonBoxData boxes = (JsonBoxData)ser.ReadObject(s);
                        return(boxes);
                    }
                }

                //catch (SocketException SE)
                catch (Exception E)
                {
                    Console.WriteLine(E);
                    return(null);
                }
            }
            return(null);
        }
Example #2
0
        public void ScanStash(JsonBoxData CurrentItems)
        {
            //Get all boxeditems in one list
            string[] BoxedItems = CurrentItems.Boxes[0].TagIDs.Concat(CurrentItems.Boxes[1].TagIDs).Concat(CurrentItems.Boxes[2].TagIDs).ToArray();

            UpdateRemovedItems(CurrentItems, BoxedItems);
            UpdateReturnedItems(CurrentItems, BoxedItems);
        }
Example #3
0
        /// <summary>
        /// View of all box's contents
        /// </summary>
        /// <author>Daniel Sacdalan and Matt Lucrida</author>
        /// <returns></returns>
        public async Task <ActionResult> Index(string searchString)
        {
            DataAccess.DataAccess dataAccess   = new DataAccess.DataAccess();
            JsonBoxData           CurrentItems = new JsonBoxData();

            CurrentItems = await dataAccess.ScanBoxes(); // How are the box keys being assigned?

            if (CurrentItems != null)
            {
                dataAccess.ScanStash(CurrentItems);
            }

            return(View(Service.BoxIndex(searchString)));
        }
Example #4
0
        public void UpdateRemovedItems(JsonBoxData CurrentItems, string[] BoxedItems)
        {
            //Find all entries with NULL out times
            string[] RecordedInItems = (from I in db.Items
                                        join T in db.Itemtransactions on I.itemkey equals T.itemkey
                                        where T.out_time == null
                                        select I.RFIDkey).ToArray();

            //Returns all items currently out of stash
            IEnumerable <string> OutItems = RecordedInItems.Except(BoxedItems);

            //Update each transaction to show item was removed.
            foreach (var item in OutItems)
            {
                //Find the transaction to update
                var update = from Item in db.Items
                             join T in db.Itemtransactions on Item.itemkey equals T.itemkey
                             where Item.RFIDkey == item && T.out_time == null
                             select T;

                //Update the out_time
                //Will only loop once
                foreach (Itemtransaction It in update)
                {
                    It.out_time = DateTime.UtcNow;
                }

                //Save changes to db
                try
                {
                    db.SaveChanges();
                }

                catch (Exception e)
                {
                    Console.WriteLine(e);
                }
            }
        }
Example #5
0
        public void UpdateReturnedItems(JsonBoxData CurrentItems, String[] BoxedItems)
        {
            //numBoxes IS FOR DEBUGGING SET TO 3 WHEN FINSIHED
            int numBoxes = 3;

            for (int i = 0; i < numBoxes; i++)
            {
                int curBoxKey = CurrentItems.Boxes[i].BoxID;

                //Look at all the items that are boxed
                foreach (var item in BoxedItems)
                {
                    //If there is any record with an out_time NULL,
                    //that means it is in the box.
                    bool Out = (from I in db.Items
                                join T in db.Itemtransactions on I.itemkey equals T.itemkey
                                where I.RFIDkey == item && T.out_time == null
                                select T).Any();

                    //If there is NO record with the out_time NULL,
                    //Then that means the item is being returned.
                    if (!Out)
                    {
                        //Find the item's itemkey
                        int curItemKey = (from I in db.Items
                                          where I.RFIDkey == item
                                          select I.itemkey).FirstOrDefault();

                        //Create new transaction record
                        Itemtransaction Transaction = new Itemtransaction
                        {
                            itemkey  = curItemKey,
                            boxkey   = curBoxKey,
                            in_time  = DateTime.UtcNow,
                            out_time = null
                        };

                        //Save the changes to the db
                        try
                        {
                            db.Itemtransactions.Add(Transaction);
                            db.SaveChanges();
                        }

                        catch (Exception e)
                        {
                            Console.WriteLine(e);
                        }
                    }

                    //else
                    //{
                    //    bool newRFID = ((from I in db.Items
                    //                     where I.RFIDkey == item
                    //                     select I).Any())
                    //                    ||
                    //                    ((from I in db.Items
                    //                      where I.RFIDkey == item && I.delete_date != null
                    //                      select I).Any());


                    //    if (newRFID)
                    //    {
                    //        Item newItem = new Item
                    //        {
                    //            RFIDkey = item,
                    //            name = "NEW ITEM",
                    //            object_description = null,
                    //            itemgroupkey = null,
                    //            photokey = null,
                    //            create_date = DateTime.UtcNow
                    //        };

                    //        try
                    //        {
                    //            db.Items.Add(newItem);
                    //            db.SaveChanges();
                    //        }

                    //        catch (Exception e)
                    //        {
                    //            Console.WriteLine(e);
                    //        }

                    //    }
                    //}
                }
            }
        }