public Brand ConvertFromServiceBrand(ServiceBrand serviceBrand)
{
Brand brandToReturn = new Brand();
brandToReturn.Name = serviceBrand.Name;
brandToReturn.BrandId = serviceBrand.BrandId;
return(brandToReturn);
}
public IEnumerable <ServiceBrand> GetAllBrands()
{
List <ServiceBrand> brands = new List <ServiceBrand>();
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmdGetAllBrands = connection.CreateCommand())
{
cmdGetAllBrands.CommandText = "SELECT name, brandId FROM Brand";
SqlDataReader brandReader = cmdGetAllBrands.ExecuteReader();
while (brandReader.Read())
{
ServiceBrand brand = new ServiceBrand();
brand.Name = brandReader.GetString(brandReader.GetOrdinal("name"));
brand.BrandId = brandReader.GetInt32(brandReader.GetOrdinal("brandId"));
brands.Add(brand);
}
}
}
return(brands);
}