public PracticeDTO Add(PracticeDTO practiceDTO)
{
using (_connection = new SqlConnection(_connectionString))
{
try
{
var query = "insert into Practice(Name,Address,Specialty) values (@name,@address,@specialty)";
SqlCommand sqlCommand = new SqlCommand(query, _connection);
sqlCommand.Parameters.AddWithValue("@name", practiceDTO.Name);
sqlCommand.Parameters.AddWithValue("@address", practiceDTO.Address);
sqlCommand.Parameters.AddWithValue("@specialty", practiceDTO.Specialty);
_connection.Open();
sqlCommand.ExecuteNonQuery();
var practice = new Practices
{
Name = practiceDTO.Name,
Address = practiceDTO.Address,
Specialty = practiceDTO.Specialty
};
return(PracticeToDTO(practice));
}
catch
{
throw;
}
}
}
private static PracticeDTO PracticeToDTO(Practices practice) =>
new PracticeDTO
{
ID = practice.ID,
Name = practice.Name,
Address = practice.Address,
Specialty = practice.Specialty
};