public List<Company> Search(SearchPattern pattern)
{
List<Company> result = new List<Company>();
using (var sqlConnection = new SqlConnection(ConnectionString))
{
sqlConnection.Open();
SqlCommand cmd = new SqlCommand("select Id,FullName,Name,INN,OGRN,Rating from Companies where Region=@region and ActivityType=@atype", sqlConnection);
cmd.Parameters.AddWithValue("region", pattern.Region);
cmd.Parameters.AddWithValue("atype", pattern.ActivityType);
using (var reader = cmd.ExecuteReader())
{
while(reader.Read())
{
Company c = new Company();
c.Id = reader.GetInt32(0);
c.FullName = reader.GetString(1);
c.Name = reader.GetString(2);
c.INN = reader.GetInt64(3);
c.OGRN = reader.GetInt64(4);
c.Rating = float.Parse(reader.GetValue(5).ToString());
result.Add(c);
}
}
}
return result;
}
public Company GetCompany(int Id)
{
using (var sqlConnection = new SqlConnection(ConnectionString))
{
sqlConnection.Open();
SqlCommand cmd = new SqlCommand("select Id,FullName,Name,INN,OGRN,Rating from Companies where Id=@id", sqlConnection);
cmd.Parameters.AddWithValue("id", Id);
using (var reader = cmd.ExecuteReader())
{
reader.Read();
Company c = new Company();
c.Id = reader.GetInt32(0);
c.FullName = reader.GetString(1);
c.Name = reader.GetString(2);
c.INN = reader.GetInt64(3);
c.OGRN = reader.GetInt64(4);
c.Rating = float.Parse(reader.GetValue(5).ToString());
return c;
}
}
}
