public async Task CondensedSystemsTables()
        {
            var databaseManager = new Managers.DatabaseManager();
            var systems         = await databaseManager.GetSystemsTable();

            listData = systems.ToList <Models.System>();

            for (int i = 0; i < listData.Count; i++)
            {
                Stack <int> duplicateSystemsIndices = new Stack <int>();
                duplicateSystemsIndices.Push(i);
                for (int j = i + 1; j < listData.Count; j++)
                {
                    if (listData[i].SKU.Equals(listData[j].SKU))
                    {
                        duplicateSystemsIndices.Push(j);
                    }
                }
                if (duplicateSystemsIndices.Count > 1)
                {
                    Condense(listData[i], duplicateSystemsIndices);
                    i--;
                }
            }
            Data = listData.ToArray();
            return;
        }
Пример #2
0
        static void Main(string[] args)
        {
            var DatabaseManager = Shared.DBconnection.GetManager();
            var dbManager       = new Managers.DatabaseManager();

            try
            {
                Console.WriteLine("Connection Successful");

                //Equipment.AddEquipment.addEquipment("Dell Inspiron 7559", "Office B Storage Closet", "has radioactive robotics testing software");
                //Deletion.Delete("parts", 7);

                var table = dbManager.GetPartsTable().Result;
                Console.WriteLine(table[2].serializable);

                //int result = AddToSystem.Add(2, 1111);
                //Console.WriteLine(result);

                Console.ReadKey();
            }
            catch (Exception ex)
            {
                Console.Error.Write(ex.Message);
                DatabaseManager.GetConnection().Close();
            }
        }