public SpecialOfferProductCollection GetSpecialOfferProductsCollection(string where, string orderBy) { SpecialOfferProductData data = new SpecialOfferProductData(); SpecialOfferProductCollection col = new SpecialOfferProductCollection(); try { col = data.GetAllSpecialOfferProductsDynamicCollection(where, orderBy); } catch (Exception ex) { log.Write(ex.Message, "GetSpecialOfferProductsCollection"); throw (ex); } finally { data = null; } return(col); }