//updates the data of an ITEM in the database it also displays the current ITEMS in the database so you can provide a ID for updating //using the Insert Method in the SQLconnection Class static private void UpdateData(Firma P) { Console.Clear(); string selectquery = $"SELECT id, navn FROM Vare"; DataTable dataTable = new DataTable(); dataTable = Select(selectquery); foreach (DataRow row in dataTable.Rows) { string updatestring = string.Format("ID: {0} | Navn: {1}", row.ItemArray); Console.WriteLine(updatestring); } Console.WriteLine("Write the ID number of the item you want updated"); string userinput = Console.ReadLine(); bool errorCheck = int.TryParse(userinput, out int result); if (errorCheck) { foreach (DataRow row in dataTable.Rows) { if (Convert.ToInt32(row.ItemArray[0]) == result) { Console.Clear(); Console.WriteLine(" _______________________________ "); Console.WriteLine("| Navn: |"); Console.WriteLine("| Pris: |"); Console.WriteLine("| Antal: |"); Console.WriteLine("|_______________________________|"); Console.SetCursorPosition(8, 1); string varenavn = Console.ReadLine(); Console.SetCursorPosition(8, 2); double pris = Convert.ToDouble(Console.ReadLine()); Console.SetCursorPosition(9, 3); int antal = Convert.ToInt32(Console.ReadLine()); Insert($"UPDATE Vare SET navn ='{varenavn}', pris = '{pris}', stock = '{antal}' WHERE id = {result}"); break; } } } Menu(P); }
//Adds a placement for an item in the database static private void AddPlacering(Firma P) { Console.Clear(); string selectquery = $"SELECT id, navn FROM Vare"; DataTable dataTable = new DataTable(); dataTable = Select(selectquery); foreach (DataRow row in dataTable.Rows) { string placeringstring = string.Format("ID: {0} | Navn: {1}", row.ItemArray); Console.WriteLine(placeringstring); } string userinput = Console.ReadLine(); bool errorCheck = int.TryParse(userinput, out int result); if (errorCheck) { foreach (DataRow row in dataTable.Rows) { if (Convert.ToInt32(row.ItemArray[0]) == result) { Console.Clear(); Console.WriteLine(" _______________________________ "); Console.WriteLine("| Hylde: |"); Console.WriteLine("| Plads: |"); Console.WriteLine("|_______________________________|"); Console.SetCursorPosition(9, 1); string hylde = Console.ReadLine(); Console.SetCursorPosition(9, 2); double plads = Convert.ToDouble(Console.ReadLine()); Insert($"INSERT INTO Placering (hylde, plads, vare) VALUES ('{hylde}','{plads}','{result}')"); break; } } } Menu(P); }