public static List<GiftCardReport> GetGiftCardReport(int offset, int? limit, GiftCardReport objGiftcard, AspxCommonInfo aspxCommonObj)
{
try
{
List<GiftCardReport> giftCardReports = AspxGiftCardProvider.GetGiftCardReport(offset, limit, objGiftcard, aspxCommonObj);
return giftCardReports;
}
catch (Exception ex)
{
throw ex;
}
}
public static List <GiftCardReport> GetGiftCardReport(int offset, int?limit, GiftCardReport objGiftcard, AspxCommonInfo aspxCommonObj)
{
try
{
List <GiftCardReport> giftCardReports = AspxGiftCardProvider.GetGiftCardReport(offset, limit, objGiftcard, aspxCommonObj);
return(giftCardReports);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <GiftCardReport> GetGiftCardReport(int offset, int?limit, GiftCardReport objGiftcard, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
paramCol.Add(new KeyValuePair <string, object>("@offset", offset));
paramCol.Add(new KeyValuePair <string, object>("@limit", limit));
paramCol.Add(new KeyValuePair <string, object>("@FromDate", objGiftcard.FromDate));
paramCol.Add(new KeyValuePair <string, object>("@ToDate", objGiftcard.ToDate));
paramCol.Add(new KeyValuePair <string, object>("@SKU", objGiftcard.SKU));
paramCol.Add(new KeyValuePair <string, object>("@ItemName", objGiftcard.ItemName));
paramCol.Add(new KeyValuePair <string, object>("@GiftCardType", objGiftcard.GiftCardType));
SQLHandler sqlHl = new SQLHandler();
List <GiftCardReport> lstGiftCard =
sqlHl.ExecuteAsList <GiftCardReport>("[dbo].[usp_Aspx_GetGiftCardReports]",
paramCol);
return(lstGiftCard);
}
catch (Exception e)
{
throw e;
}
}
public static List<GiftCardReport> GetGiftCardReport(int offset, int? limit, GiftCardReport objGiftcard, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
paramCol.Add(new KeyValuePair<string, object>("@offset", offset));
paramCol.Add(new KeyValuePair<string, object>("@limit", limit));
paramCol.Add(new KeyValuePair<string, object>("@FromDate", objGiftcard.FromDate));
paramCol.Add(new KeyValuePair<string, object>("@ToDate", objGiftcard.ToDate));
paramCol.Add(new KeyValuePair<string, object>("@SKU", objGiftcard.SKU));
paramCol.Add(new KeyValuePair<string, object>("@ItemName", objGiftcard.ItemName));
paramCol.Add(new KeyValuePair<string, object>("@GiftCardType", objGiftcard.GiftCardType));
SQLHandler sqlHl = new SQLHandler();
List<GiftCardReport> lstGiftCard =
sqlHl.ExecuteAsList<GiftCardReport>("[dbo].[usp_Aspx_GetGiftCardReports]",
paramCol);
return lstGiftCard;
}
catch (Exception e)
{
throw e;
}
}