/// <summary>
        /// To Bind grid with all Items
        /// </summary>
        public static List <ItemsInfo> GetAllItems(int offset, int limit, GetItemListInfo getItemObj, AspxCommonInfo aspxCommonObj)
        {
            List <ItemsInfo> ml;

            ml = AspxItemMgntProvider.GetAllItems(offset, limit, getItemObj, aspxCommonObj);
            return(ml);
        }
 /// <summary>
 /// To Bind grid with all Items
 /// </summary>
 public static List<ItemsInfo> GetAllItems(int offset, int limit, GetItemListInfo getItemObj, AspxCommonInfo aspxCommonObj)
 {
     List<ItemsInfo> ml;
     SQLHandler sqlH = 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>("@SKU", getItemObj.SKU));
     parameterCollection.Add(new KeyValuePair<string, object>("@ItemName", getItemObj.ItemName));
     parameterCollection.Add(new KeyValuePair<string, object>("@ItemTypeID", getItemObj.ItemTypeID));
     parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetID", getItemObj.AttributeSetID));
     parameterCollection.Add(new KeyValuePair<string, object>("@Visibility", getItemObj.Visibility));
     parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", getItemObj.IsActive));    
     ml = sqlH.ExecuteAsList<ItemsInfo>("dbo.usp_Aspx_ItemsGetAll", parameterCollection);
     return ml;
 }
示例#3
0
        /// <summary>
        /// To Bind grid with all Items
        /// </summary>
        public static List <ItemsInfo> GetAllItems(int offset, int limit, GetItemListInfo getItemObj, AspxCommonInfo aspxCommonObj)
        {
            List <ItemsInfo> ml;
            SQLHandler       sqlH = 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>("@SKU", getItemObj.SKU));
            parameterCollection.Add(new KeyValuePair <string, object>("@ItemName", getItemObj.ItemName));
            parameterCollection.Add(new KeyValuePair <string, object>("@ItemTypeID", getItemObj.ItemTypeID));
            parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", getItemObj.AttributeSetID));
            parameterCollection.Add(new KeyValuePair <string, object>("@Visibility", getItemObj.Visibility));
            parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", getItemObj.IsActive));
            ml = sqlH.ExecuteAsList <ItemsInfo>("dbo.usp_Aspx_ItemsGetAll", parameterCollection);
            return(ml);
        }
 public List<ItemsInfo> GetItemsList(int offset, int limit, GetItemListInfo getItemListObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<ItemsInfo> ml;
         ml = AspxItemMgntController.GetAllItems(offset, limit, getItemListObj, aspxCommonObj);
         return ml;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 /// <summary>
 /// To Bind grid with all Items
 /// </summary>
 public static List<ItemsInfo> GetAllItems(int offset, int limit, GetItemListInfo getItemObj, AspxCommonInfo aspxCommonObj)
 {
     List<ItemsInfo> ml;
     ml = AspxItemMgntProvider.GetAllItems(offset, limit, getItemObj, aspxCommonObj);
     return ml;
 }