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