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