private Placering(int id, string hylde, string plads, Vare vare) { this.id = id; this.hylde = hylde; this.plads = plads; this.vare = vare; }
//Adds an ITEM in to the database look in "Firma" class under Addvare Method for more info static private void AddData(Firma P) { 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); string prisstr = Console.ReadLine(); double pris = Double.Parse(prisstr); Console.SetCursorPosition(9, 3); int antal = Convert.ToInt32(Console.ReadLine()); Console.SetCursorPosition(0, 5); Vare V = new Vare(varenavn, pris, antal); P.AddVare(V); Console.WriteLine("Succesfully Inserted Item into Database"); Console.Write("Press any key to continue..."); Console.ReadLine(); Menu(P); }
//Adds an ITEM to the database using the Insert method in SQLconnection //Tries to replace , with . in the price because if there is a , in the database it cannot display the , in the Console //Also we can't write . to begin with because the convert to double removes the . from the variable public void AddVare(Vare P) { varer.Add(P); string pris = P.Pris.ToString().Replace(",", "."); string query = $"INSERT INTO Vare (navn, pris, stock) VALUES ('{P.Navn}','{pris}','{P.Antal}')"; Insert(query); }
public Placering Get(int id) { DataTable dataTable = new DataTable(); string placeringQuery = $"SELECT * FROM Placering WHERE id = {id}"; dataTable = Select(placeringQuery); foreach (DataRow row in dataTable.Rows) { return(new Placering(Convert.ToInt32(row.ItemArray[0]), row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), Vare.Get(Convert.ToInt32(row.ItemArray[3])))); } return(null); }
public Placering(string hylde, string plads, Vare vare) { this.hylde = hylde; this.plads = plads; this.vare = vare; }