// Insert to DB "Insert Kunde to DB"
private void InsertToDB()
{
ConnWrite = new Domain_DB_Connection_Write(); // "Write to DB Class instance"
string KundeQuery = $"BEGIN DECLARE @UNIQUEX UNIQUEIDENTIFIER SET @UNIQUEX = NEWID(); Insert into Kunde Values('{kundeinstance.Fornavn}','{kundeinstance.Efternavn}',{kundeinstance.PostNr},'{kundeinstance.Adresse}', (@UNIQUEX),'{kundeinstance.Mail}', '{DateTime.Now.ToString("dd-MM-yyyy HH-mm-ss")}'); Insert INTO Kunde_Tlf Values('{kunder_tlf_textBox.Text}',(@UNIQUEX)); END;"; // Query
successful = ConnWrite.CreateCommand(KundeQuery); // Write to DB Input and "Execution"
}
// Insert to DB "Insert Ydelse to DB"
private void InsertToDB()
{
ConnWrite = new Domain_DB_Connection_Write(); // "Write to DB Class instance"
string YdelseQuery = $"BEGIN DECLARE @UNIQUEX UNIQUEIDENTIFIER SET @UNIQUEX = NEWID(); Insert Into Ydelse Values('{ydelseinstance.Navn}', {ydelseinstance.Pris},'{ydelseinstance.Type}','{ydelseinstance.Art}', (@UNIQUEX), '{DateTime.Now.ToString("dd-MM-yyyy HH-mm-ss")}') END;"; // Query
successful = ConnWrite.CreateCommand(YdelseQuery); // Write to DB Input and "Execution"
}
