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; }
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(); } }