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