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