public List <CategoryItemInfo> GetCategoryItems(Int32 offset, int?limit, GetCategoryItemInfo categoryItemsInfo, AspxCommonInfo aspxCommonObj) { List <CategoryItemInfo> listCategoryItem; OracleHandler sqlHandler = new OracleHandler(); List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >(); parameterCollection.Add(new KeyValuePair <string, object>("offset", offset)); parameterCollection.Add(new KeyValuePair <string, object>("limit", limit)); parameterCollection.Add(new KeyValuePair <string, object>("CategoryID", categoryItemsInfo.CategoryID)); parameterCollection.Add(new KeyValuePair <string, object>("SKU", categoryItemsInfo.SKU)); parameterCollection.Add(new KeyValuePair <string, object>("Name", categoryItemsInfo.Name)); parameterCollection.Add(new KeyValuePair <string, object>("PriceFrom", categoryItemsInfo.PriceFrom)); parameterCollection.Add(new KeyValuePair <string, object>("PriceTo", categoryItemsInfo.PriceTo)); parameterCollection.Add(new KeyValuePair <string, object>("StoreID", aspxCommonObj.StoreID)); parameterCollection.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair <string, object>("UserName", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair <string, object>("CultureName", aspxCommonObj.CultureName)); //listCategoryItem = sqlHandler.ExecuteAsList<CategoryItemInfo>("dbo.usp_Aspx_GetItemsByCategoryID", parameterCollection); listCategoryItem = sqlHandler.ExecuteAsList <CategoryItemInfo>("usp_Aspx_GetItemsByCategoryIDService", parameterCollection); return(listCategoryItem); }
public static List <CategoryItemInfo> GetCategoryItems(Int32 offset, int?limit, GetCategoryItemInfo categoryItemsInfo, AspxCommonInfo aspxCommonObj, bool serviceBit) { SQLHandler sqlHandler = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset)); parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit)); parameterCollection.Add(new KeyValuePair <string, object>("@serviceBit", serviceBit)); parameterCollection.Add(new KeyValuePair <string, object>("@CategoryID", categoryItemsInfo.CategoryID)); parameterCollection.Add(new KeyValuePair <string, object>("@SKU", categoryItemsInfo.SKU)); parameterCollection.Add(new KeyValuePair <string, object>("@Name", categoryItemsInfo.Name)); parameterCollection.Add(new KeyValuePair <string, object>("@PriceFrom", categoryItemsInfo.PriceFrom)); parameterCollection.Add(new KeyValuePair <string, object>("@PriceTo", categoryItemsInfo.PriceTo)); List <CategoryItemInfo> listCategoryItem = sqlHandler.ExecuteAsList <CategoryItemInfo>("[dbo].[usp_Aspx_GetItemsByCategoryIDService]", parameterCollection); return(listCategoryItem); }
public static List <CategoryItemInfo> GetCategoryItems(Int32 offset, System.Nullable <int> limit, GetCategoryItemInfo categoryItemsInfo, AspxCommonInfo aspxCommonObj, bool serviceBit) { List <CategoryItemInfo> listCategoryItem = AspxCategoryManageProvider.GetCategoryItems(offset, limit, categoryItemsInfo, aspxCommonObj, serviceBit); return(listCategoryItem); }
public List<CategoryItemInfo> GetCategoryItems(Int32 offset, int? limit, GetCategoryItemInfo categoryItemsInfo, AspxCommonInfo aspxCommonObj) { List<CategoryItemInfo> listCategoryItem; SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>(); parameterCollection.Add(new KeyValuePair<string, object>("@offset", offset)); parameterCollection.Add(new KeyValuePair<string, object>("@limit", limit)); parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID",categoryItemsInfo.CategoryID)); parameterCollection.Add(new KeyValuePair<string, object>("@SKU",categoryItemsInfo.SKU)); parameterCollection.Add(new KeyValuePair<string, object>("@Name",categoryItemsInfo.Name)); parameterCollection.Add(new KeyValuePair<string, object>("@PriceFrom", categoryItemsInfo.PriceFrom)); parameterCollection.Add(new KeyValuePair<string, object>("@PriceTo", categoryItemsInfo.PriceTo)); parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID)); parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName)); //listCategoryItem = sqlHandler.ExecuteAsList<CategoryItemInfo>("dbo.usp_Aspx_GetItemsByCategoryID", parameterCollection); listCategoryItem = sqlHandler.ExecuteAsList<CategoryItemInfo>("[dbo].[usp_Aspx_GetItemsByCategoryIDService]", parameterCollection); return listCategoryItem; }
public List<CategoryItemInfo> GetCategoryItems(Int32 offset, System.Nullable<int> limit, GetCategoryItemInfo categoryItemsInfo, AspxCommonInfo aspxCommonObj, bool serviceBit) { try { List<CategoryItemInfo> listCategoryItem = AspxCategoryManageController.GetCategoryItems(offset, limit, categoryItemsInfo, aspxCommonObj, serviceBit); return listCategoryItem; } catch (Exception e) { ErrorHandler errHandler = new ErrorHandler(); errHandler.LogWCFException(e); throw e; } }
public static List<CategoryItemInfo> GetCategoryItems(Int32 offset, System.Nullable<int> limit, GetCategoryItemInfo categoryItemsInfo, AspxCommonInfo aspxCommonObj, bool serviceBit) { List<CategoryItemInfo> listCategoryItem = AspxCategoryManageProvider.GetCategoryItems(offset, limit,categoryItemsInfo,aspxCommonObj,serviceBit); return listCategoryItem; }
public static List<CategoryItemInfo> GetCategoryItems(Int32 offset, int? limit, GetCategoryItemInfo categoryItemsInfo, AspxCommonInfo aspxCommonObj, bool serviceBit) { SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@offset", offset)); parameterCollection.Add(new KeyValuePair<string, object>("@limit", limit)); parameterCollection.Add(new KeyValuePair<string, object>("@serviceBit", serviceBit)); parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", categoryItemsInfo.CategoryID)); parameterCollection.Add(new KeyValuePair<string, object>("@SKU", categoryItemsInfo.SKU)); parameterCollection.Add(new KeyValuePair<string, object>("@Name", categoryItemsInfo.Name)); parameterCollection.Add(new KeyValuePair<string, object>("@PriceFrom", categoryItemsInfo.PriceFrom)); parameterCollection.Add(new KeyValuePair<string, object>("@PriceTo", categoryItemsInfo.PriceTo)); List<CategoryItemInfo> listCategoryItem = sqlHandler.ExecuteAsList<CategoryItemInfo>("[dbo].[usp_Aspx_GetItemsByCategoryIDService]", parameterCollection); return listCategoryItem; }