private void SetConnection()
{
if( string.IsNullOrEmpty( _connection ) ) {
_connection = ConfigurationManager.ConnectionStrings[ "hublisherConnectionString" ].ConnectionString;
}
Database = new HubStoreDataContext( _connection );
}
public List<brand> GetEstablishmentBrands()
{
HubStoreDataContext db = new HubStoreDataContext();
List<brand> list = new List<brand>();
foreach (var item in db.establishment_brands.Where( x => x.establishment_id == Establishment.id && x.deleted == false ).ToList()) {
list.Add( HublisherApp._allBrands.Where( x => x.id == item.brand_id && x.deleted == false ).FirstOrDefault() );
}
return list.Distinct().ToList();
}
