C# (CSharp) AspxCommerce.Core ItemSmallCommonInfo Examples

Example #1

        //----------------------------------------------------------------------------------------------
        //-----------------------------------Get Low Stock Items----------------------------------------
        public List <LowStockItemsInfo> GetAllLowStockItems(int offset, int?limit, ItemSmallCommonInfo lowStockObj, AspxCommonInfo aspxCommonObj, int lowStock)
        {
            List <LowStockItemsInfo> ml;
            SQLHandler sqlH = 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>("@SKU", lowStockObj.SKU));
            parameterCollection.Add(new KeyValuePair <string, object>("@ItemName", lowStockObj.ItemName));
            parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", lowStockObj.IsActive));
            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.UserName));
            parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
            parameterCollection.Add(new KeyValuePair <string, object>("@LowStockQuantity", lowStock));
            ml = sqlH.ExecuteAsList <LowStockItemsInfo>("dbo.usp_Aspx_GetLowStockItems", parameterCollection);
            return(ml);
        }

Example #2

File: AspxCoreController.cs Project: xiaoxiaocoder/AspxCommerce2.7

        // --------------------------Get Low Stock Items----------------------------------------------------

        public List<LowStockItemsInfo> GetLowStockItemsList(int offset, int? limit, ItemSmallCommonInfo lowStockObj, AspxCommonInfo aspxCommonObj, int lowStock)
        {
            try
            {
                List<LowStockItemsInfo> lstLowStockItem = AspxItemMgntController.GetAllLowStockItems(offset, limit, lowStockObj, aspxCommonObj, lowStock);
                return lstLowStockItem;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

Example #3

File: ItemsManagementSqlProvider.cs Project: xiaoxiaocoder/AspxCommerce2.7

 //----------------------------------------------------------------------------------------------
 //-----------------------------------Get Low Stock Items----------------------------------------
 public List<LowStockItemsInfo> GetAllLowStockItems(int offset, int? limit, ItemSmallCommonInfo lowStockObj, AspxCommonInfo aspxCommonObj, int lowStock)
 {
     List<LowStockItemsInfo> ml;
     SQLHandler sqlH = 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>("@SKU", lowStockObj.SKU));
     parameterCollection.Add(new KeyValuePair<string, object>("@ItemName", lowStockObj.ItemName));
     parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", lowStockObj.IsActive));
     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.UserName));
     parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
     parameterCollection.Add(new KeyValuePair<string, object>("@LowStockQuantity", lowStock));
     ml = sqlH.ExecuteAsList<LowStockItemsInfo>("dbo.usp_Aspx_GetLowStockItems", parameterCollection);
     return ml;
 }

Example #4

        //----------------------------------------------------------------------------------------------
        //-----------------------------------Get Low Stock Items----------------------------------------
        public static List <LowStockItemsInfo> GetAllLowStockItems(int offset, int?limit, ItemSmallCommonInfo lowStockObj, AspxCommonInfo aspxCommonObj, int lowStock)
        {
            List <LowStockItemsInfo> 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", lowStockObj.SKU));
            parameterCollection.Add(new KeyValuePair <string, object>("@ItemName", lowStockObj.ItemName));
            parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", lowStockObj.IsActive));
            parameterCollection.Add(new KeyValuePair <string, object>("@LowStockQuantity", lowStock));
            ml = sqlH.ExecuteAsList <LowStockItemsInfo>("dbo.usp_Aspx_GetLowStockItems", parameterCollection);
            return(ml);
        }

Example #5

File: AspxItemMgntController.cs Project: xiaoxiaocoder/AspxCommerce2.7

 //----------------------------------------------------------------------------------------------
 //-----------------------------------Get Low Stock Items----------------------------------------
 public static List<LowStockItemsInfo> GetAllLowStockItems(int offset, int? limit, ItemSmallCommonInfo lowStockObj, AspxCommonInfo aspxCommonObj, int lowStock)
 {
     List<LowStockItemsInfo> ml;
     ml = AspxItemMgntProvider.GetAllLowStockItems(offset, limit, lowStockObj, aspxCommonObj, lowStock);
     return ml;
 }

Example #6

File: AspxItemMgntController.cs Project: zahedbri/AspxCommerce2.0_Source

        //----------------------------------------------------------------------------------------------
        //-----------------------------------Get Low Stock Items----------------------------------------
        public static List <LowStockItemsInfo> GetAllLowStockItems(int offset, int?limit, ItemSmallCommonInfo lowStockObj, AspxCommonInfo aspxCommonObj, int lowStock)
        {
            List <LowStockItemsInfo> ml;

            ml = AspxItemMgntProvider.GetAllLowStockItems(offset, limit, lowStockObj, aspxCommonObj, lowStock);
            return(ml);
        }

Example #7

File: AspxItemMgntProvider.cs Project: xiaoxiaocoder/AspxCommerce2.7

 //----------------------------------------------------------------------------------------------
 //-----------------------------------Get Low Stock Items----------------------------------------
 public static List<LowStockItemsInfo> GetAllLowStockItems(int offset, int? limit, ItemSmallCommonInfo lowStockObj, AspxCommonInfo aspxCommonObj, int lowStock)
 {
     List<LowStockItemsInfo> 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", lowStockObj.SKU));
     parameterCollection.Add(new KeyValuePair<string, object>("@ItemName", lowStockObj.ItemName));
     parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", lowStockObj.IsActive));
     parameterCollection.Add(new KeyValuePair<string, object>("@LowStockQuantity", lowStock));          
     ml = sqlH.ExecuteAsList<LowStockItemsInfo>("dbo.usp_Aspx_GetLowStockItems", parameterCollection);
     return ml;
 }