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;
}
}
}
public int Update(PracticeDTO practiceDTOChanges, int id)
{
if (!PracticeExists(id))
{
return(0);
}
using (_connection = new SqlConnection(_connectionString))
{
try
{
var query = $"update Practice set Name=@name,Address=@address,Specialty=@specialty where id = {id}";
SqlCommand sqlCommand = new SqlCommand(query, _connection);
sqlCommand.Parameters.AddWithValue("Name", practiceDTOChanges.Name);
sqlCommand.Parameters.AddWithValue("Address", practiceDTOChanges.Address);
sqlCommand.Parameters.AddWithValue("Specialty", practiceDTOChanges.Specialty);
_connection.Open();
sqlCommand.ExecuteNonQuery();
return(1);
}
catch
{
throw;
}
}
}
