public static DataSet GetCompareItemsDataSet(AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetFullParam(aspxCommonObj);
SQLHandler sqlHandler = new SQLHandler();
return(sqlHandler.ExecuteAsDataSet("[dbo].[usp_Aspx_Get_CompareItemsInfo]", parameterCollection));
}
public List <YouMayAlsoLikeInfo> GetYouMayAlsoLikeItems(string itemSKU, AspxCommonInfo aspxCommonObj, int count)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFullParam(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@itemSKU", itemSKU));
parameter.Add(new KeyValuePair <string, object>("@Count", count));
SQLHandler sqlH = new SQLHandler();
List <YouMayAlsoLikeInfo> lstYouMayLike = sqlH.ExecuteAsList <YouMayAlsoLikeInfo>("usp_Aspx_GetYouMayAlsoLikeItems", parameter);
return(lstYouMayLike);
}
catch (Exception e)
{
throw e;
}
}