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; } } }