public IEnumerable <ServiceCoefficient> GetAll() { var result = new List <ServiceCoefficient>(); using (_connection) { _connection.Open(); string sql = "select * from coefficient"; SqlCommand cmd = new SqlCommand(sql, _connection); cmd.CommandType = CommandType.Text; var reader = cmd.ExecuteReader(); while (reader.Read()) { ServiceCoefficient serviceCoefficient = new ServiceCoefficient() { Id = (long)reader["id"], Name = (string)reader["name"], Coefficient = (double)reader["coefficient"] }; result.Add(serviceCoefficient); } } return(result.AsEnumerable()); }
public ServiceCoefficient Create(string name, double coefficient) { using (_connection) { _connection.Open(); string sql = "insert into coefficient (name, coefficient) values (@name, @coefficient)"; SqlCommand cmd = new SqlCommand(sql, _connection); cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@coefficient", coefficient); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); sql = "select * from coefficient where name = @name"; cmd = new SqlCommand(sql, _connection); cmd.Parameters.AddWithValue("@name", name); var reader = cmd.ExecuteReader(); if (reader.Read()) { ServiceCoefficient serviceCoefficient = new ServiceCoefficient() { Id = (long)reader["id"], Name = (string)reader["name"], Coefficient = (double)reader["coefficient"] }; return(serviceCoefficient); } throw new Exception("Coefficient with this name is already registered"); } }