// Kliento duomenu ivedimas public void InsertClient(bool personalNumNotExist, long personalNumber) { using (SqlConnection sqlConnection = new SqlConnection(connectionStr)) { if (personalNumNotExist) { Client client = functionsForClient.AddClient(); sqlConnection.Open(); using SqlCommand command = new SqlCommand($"INSERT INTO clients (personalNumber, name, surename, dateOfBirth, address, city)" + $"VALUES (@personalNumber, @name, @surename, @dateOfBirth, @address, @city)", sqlConnection); command.Parameters.AddWithValue("@personalNumber", personalNumber); command.Parameters.AddWithValue("@name", client.Name); command.Parameters.AddWithValue("@surename", client.Surename); command.Parameters.AddWithValue("@dateOfBirth", client.DateOfBirth); command.Parameters.AddWithValue("@address", client.Address); command.Parameters.AddWithValue("@city", client.City); command.ExecuteNonQuery(); sqlConnection.Close(); } } }