/// <summary>
        /// To Bind grid with all UP Sell Items
        /// </summary>

        public static List <ItemsInfo> GetUpSellItemsByItemID(int offset, int limit, ItemDetailsCommonInfo UpSellCommonObj, AspxCommonInfo aspxCommonObj)
        {
            List <ItemsInfo> ml;

            ml = AspxItemMgntProvider.GetUpSellItemsByItemID(offset, limit, UpSellCommonObj, aspxCommonObj);
            return(ml);
        }
       /// <summary>
       /// To Bind grid with all Related Items
       /// </summary>

       public static List<ItemsInfo> GetRelatedItemsByItemID(int offset, int limit, ItemDetailsCommonInfo IDCommonObj, 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>("@SelfItemID", IDCommonObj.SelfItemID));
           parameterCollection.Add(new KeyValuePair<string, object>("@ItemSKU", IDCommonObj.ItemSKU));
           parameterCollection.Add(new KeyValuePair<string, object>("@ItemName", IDCommonObj.ItemName));
           parameterCollection.Add(new KeyValuePair<string, object>("@ItemTypeID", IDCommonObj.ItemTypeID));
           parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetID", IDCommonObj.AttributeSetID));
           parameterCollection.Add(new KeyValuePair<string, object>("@ServiceBit", IDCommonObj.ServiceBit));
           ml = sqlH.ExecuteAsList<ItemsInfo>("dbo.usp_Aspx_GetRelatedItemsByItemID", parameterCollection);
           return ml;
       }
Ejemplo n.º 3
0
        /// <summary>
        /// To Bind grid with all UP Sell Items
        /// </summary>

        public static List <ItemsInfo> GetUpSellItemsByItemID(int offset, int limit, ItemDetailsCommonInfo UpSellCommonObj, 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>("@SelfItemID", UpSellCommonObj.SelfItemID));
            parameterCollection.Add(new KeyValuePair <string, object>("@ItemSKU", UpSellCommonObj.ItemSKU));
            parameterCollection.Add(new KeyValuePair <string, object>("@ItemName", UpSellCommonObj.ItemName));
            parameterCollection.Add(new KeyValuePair <string, object>("@ItemTypeID", UpSellCommonObj.ItemTypeID));
            parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", UpSellCommonObj.AttributeSetID));
            parameterCollection.Add(new KeyValuePair <string, object>("@ServiceBit", UpSellCommonObj.ServiceBit));
            ml = sqlH.ExecuteAsList <ItemsInfo>("dbo.usp_Aspx_GetUpSellItemsByItemID", parameterCollection);
            return(ml);
        }
 public List<ItemsInfo> GetCrossSellItemsList(int offset, int limit, ItemDetailsCommonInfo CrossSellCommonObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<ItemsInfo> ml;
         ml = AspxItemMgntController.GetCrossSellItemsByItemID(offset, limit, CrossSellCommonObj, aspxCommonObj);
         return ml;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public List<ItemsInfo> GetAssociatedItemsList(int offset, int limit, ItemDetailsCommonInfo IDCommonObj, int categoryID, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<ItemsInfo> ml;
         ml = AspxItemMgntController.GetAssociatedItemsByItemID(offset, limit, IDCommonObj, categoryID, aspxCommonObj);
         return ml;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        /// <summary>
        /// To Bind grid with all Cross Sell Items
        /// </summary>

        public static List<ItemsInfo> GetCrossSellItemsByItemID(int offset, int limit, ItemDetailsCommonInfo CrossSellCommonObj, AspxCommonInfo aspxCommonObj)
        {
            List<ItemsInfo> ml;
            ml = AspxItemMgntProvider.GetCrossSellItemsByItemID(offset, limit, CrossSellCommonObj, aspxCommonObj);
            return ml;
        }
 /// <summary>
 /// Get associated Items for group products
 /// </summary>
 /// <param name="offset"></param>
 /// <param name="limit"></param>
 /// <param name="IDCommonObj"></param>
 /// <param name="aspxCommonObj"></param>
 /// <returns></returns>
 public static List<ItemsInfo> GetAssociatedItemsByItemID(int offset, int limit, ItemDetailsCommonInfo IDCommonObj,int categoryID, AspxCommonInfo aspxCommonObj)
 {
     List<ItemsInfo> itemsList;
     itemsList = AspxItemMgntProvider.GetAssociatedItemsByItemID(offset, limit, IDCommonObj,categoryID, aspxCommonObj);
     return itemsList;
 }
        /// <summary>
        /// Get associated Items for group products
        /// </summary>
        /// <param name="offset"></param>
        /// <param name="limit"></param>
        /// <param name="IDCommonObj"></param>
        /// <param name="aspxCommonObj"></param>
        /// <returns></returns>
        public static List <ItemsInfo> GetAssociatedItemsByItemID(int offset, int limit, ItemDetailsCommonInfo IDCommonObj, int categoryID, AspxCommonInfo aspxCommonObj)
        {
            List <ItemsInfo> itemsList;

            itemsList = AspxItemMgntProvider.GetAssociatedItemsByItemID(offset, limit, IDCommonObj, categoryID, aspxCommonObj);
            return(itemsList);
        }