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