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