public static List <SearchTermInfo> GetSearchStatistics(int count, string commandName, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("Count", count));
parameter.Add(new KeyValuePair <string, object>("CommandName", commandName));
OracleHandler sqlH = new OracleHandler();
List <SearchTermInfo> lstSearchTerm = sqlH.ExecuteAsList <SearchTermInfo>("usp_Aspx_GetSearchTermStatistics", parameter);
return(lstSearchTerm);
}
public static List <Filter> GetShoppingFilter(AspxCommonInfo aspxCommonObj, string categoryName, bool isByCategory)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("categoryKey", categoryName));
parameter.Add(new KeyValuePair <string, object>("isByCategory", Convert.ToString(isByCategory).ToLower()));
OracleHandler sqlH = new OracleHandler();
List <Filter> lstFilter = sqlH.ExecuteAsList <Filter>("usp_Aspx_ShoppingFilter", parameter);
return(lstFilter);
}
public static List <VisitorNewOrderStatics> GetVisitorsNewOrder(int day, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("Day", day));
OracleHandler sqlH = new OracleHandler();
List <VisitorNewOrderStatics> lstVisitor =
sqlH.ExecuteAsList <VisitorNewOrderStatics>("usp_Aspx_GetNewAccountNewOrderRatio", parameter);
return(lstVisitor);
}
public static List <LayoutMgrInfo> SearchModules(string search, int PortalID, bool IsAdmin)
{
//SQLHandler SQLH = new SQLHandler();
OracleHandler SQLH = new OracleHandler();
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("SearchText", search));
ParaMeterCollection.Add(new KeyValuePair <string, object>("PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("IsAdmin", IsAdmin));
return(SQLH.ExecuteAsList <LayoutMgrInfo>("usp_ModuleManagerGetSearchModules", ParaMeterCollection));
}
public static List <DashBoardSettingInfo> GetTopFiveVisitedPage(string StartDate, string EndDate)
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("DashBoardStartDate", StartDate));
ParaMeterCollection.Add(new KeyValuePair <string, object>("DashBoardEndDate", EndDate));
//SQLHandler SQLH = new SQLHandler();
OracleHandler SQLH = new OracleHandler();
return(SQLH.ExecuteAsList <DashBoardSettingInfo>("usp_GetTopFivevisitedPage", ParaMeterCollection));
}
public List <CompareItemListInfo> GetCompareList(string itemIDs, string CostVariantValueIDs, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemIDs", itemIDs));
parameter.Add(new KeyValuePair <string, object>("CostVariantValueIDs", CostVariantValueIDs));
OracleHandler sqlH = new OracleHandler();
List <CompareItemListInfo> lstCompItem = sqlH.ExecuteAsList <CompareItemListInfo>("usp_Aspx_GetItemCompareList", parameter);
return(lstCompItem);
}
public static List <CartPriceRuleCondition> GetCartPriceRuleConditions(Int32?ruleConditionID, Int32 portalID)
{
OracleHandler sqlHandler = new OracleHandler();
List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >();
paramList.Add(new KeyValuePair <string, object>("RuleConditionID", ruleConditionID));
paramList.Add(new KeyValuePair <string, object>("PortalID", portalID));
List <CartPriceRuleCondition> lstCPRC = sqlHandler.ExecuteAsList <CartPriceRuleCondition>("usp_Aspx_GetCartPriceConditions", paramList);
return(lstCPRC);
}
public List <Filter> GetDynamicAttributesForAdvanceSearch(AspxCommonInfo aspxCommonObj, int CategoryID, bool IsGiftCard)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("CategoryID", CategoryID));
parameter.Add(new KeyValuePair <string, object>("IsGiftCard", IsGiftCard));
OracleHandler sqlH = new OracleHandler();
List <Filter> lstFilter = sqlH.ExecuteAsList <Filter>("usp_Aspx_GetDynamicAttrByCategoryIDforAdvanceSearch", parameter);
return(lstFilter);
}
public static List <RefundReasonStatics> GetTopRefundReason(int day, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("Day", day));
OracleHandler sqlH = new OracleHandler();
List <RefundReasonStatics> lstRefund =
sqlH.ExecuteAsList <RefundReasonStatics>("usp_GetTopFiveReasonsToRefund", parameter);
return(lstRefund);
}
public List <CouponSettingKeyValueInfo> GetCouponSettingKeyValueInfo(int couponID, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("CouponID", couponID));
parameter.Add(new KeyValuePair <string, object>("StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
OracleHandler sqlH = new OracleHandler();
return(sqlH.ExecuteAsList <CouponSettingKeyValueInfo>("usp_Aspx_GetCouponSettingKeyValueByCouponID", parameter));
}
private List <MethodList> GetAllMethodsFromProvider(int storeId, int portalId)
{
var sqlHandler = new OracleHandler();
var paramList = new List <KeyValuePair <string, object> >();
paramList.Add(new KeyValuePair <string, object>("StoreID", storeId));
paramList.Add(new KeyValuePair <string, object>("PortalID", portalId));
List <MethodList> cl = sqlHandler.ExecuteAsList <MethodList>("usp_Aspx_GetDynamicRateMethodList", paramList);
return(cl);
}
private List <ShippingMethodInfo> GetProvidersAvailableMethod(int storeId, int portalId)
{
var sqlHandler = new OracleHandler();
var paramList = new List <KeyValuePair <string, object> >();
paramList.Add(new KeyValuePair <string, object>("StoreID", storeId));
paramList.Add(new KeyValuePair <string, object>("PortalID", portalId));
paramList.Add(new KeyValuePair <string, object>("CultureName", "en-US"));
return(sqlHandler.ExecuteAsList <ShippingMethodInfo>("usp_Aspx_GetShippingMethodsOfR", paramList));
//return sqlHandler.ExecuteAsList<ShippingMethodInfo>("usp_Aspx_GetShippingMethodsOfRealTime", paramList);
}
public static List <RssFeedItemInfo> GetItemRssContent(AspxCommonInfo aspxCommonObj, string rssOption, int count)
{
try
{
var rssFeedContent = new List <RssFeedItemInfo>();
List <KeyValuePair <string, object> > Parameter = new List <KeyValuePair <string, object> >();
Parameter.Add(new KeyValuePair <string, object>("StoreID", aspxCommonObj.StoreID));
Parameter.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
Parameter.Add(new KeyValuePair <string, object>("CultureName", aspxCommonObj.CultureName));
Parameter.Add(new KeyValuePair <string, object>("UserName", aspxCommonObj.UserName));
Parameter.Add(new KeyValuePair <string, object>("Count", count));
OracleHandler SQLH = new OracleHandler();
switch (rssOption)
{
case "latestitems":
rssFeedContent = SQLH.ExecuteAsList <RssFeedItemInfo>("usp_Aspx_GetRssFeedLatestItem", Parameter);
break;
case "bestsellitems":
rssFeedContent = SQLH.ExecuteAsList <RssFeedItemInfo>("usp_Aspx_GetRssFeedBestSellItem", Parameter);
break;
case "specialitems":
rssFeedContent = SQLH.ExecuteAsList <RssFeedItemInfo>("usp_Aspx_GetRssFeedSpecialItem", Parameter);
break;
case "featureitems":
rssFeedContent = SQLH.ExecuteAsList <RssFeedItemInfo>("usp_Aspx_GetRssFeedFeatureItem", Parameter);
break;
case "heavydiscountitems":
rssFeedContent = SQLH.ExecuteAsList <RssFeedItemInfo>("usp_Aspx_GetRssFeedHeavyDiscountItem", Parameter);
break;
}
return(rssFeedContent);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <SearchTermInfo> ManageSearchTerm(int offset, int?limit, AspxCommonInfo aspxCommonObj, string searchTerm)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("Offset", offset));
parameter.Add(new KeyValuePair <string, object>("Limit", limit));
parameter.Add(new KeyValuePair <string, object>("SearchTerm", searchTerm));
OracleHandler sqlH = new OracleHandler();
List <SearchTermInfo> lstSearchTerm = sqlH.ExecuteAsList <SearchTermInfo>("usp_Aspx_GetSearchTermDetails", parameter);
return(lstSearchTerm);
}
public static List <ImageGalleryItemsInfo> GetItemInfoList(int storeID, int portalID, string culture)
{
List <KeyValuePair <string, object> > paramCollection = new List <KeyValuePair <string, object> >();
paramCollection.Add(new KeyValuePair <string, object>("PortalID", portalID));
paramCollection.Add(new KeyValuePair <string, object>("StoreID", storeID));
paramCollection.Add(new KeyValuePair <string, object>("Culture", culture));
OracleHandler sageSql = new OracleHandler();
List <ImageGalleryItemsInfo> itemsInfoList = sageSql.ExecuteAsList <ImageGalleryItemsInfo>("usp_Aspx_GalleryItemsInfo", paramCollection);
return(itemsInfoList);
}
private static List <MethodList> GetAllMethodsFromProvider(int storeId, int portalId)
{
OracleHandler OracleHandler = new OracleHandler();
List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >();
paramList.Add(new KeyValuePair <string, object>("StoreID", storeId));
paramList.Add(new KeyValuePair <string, object>("PortalID", portalId));
//List<MethodList> lstMethod = OracleHandler.ExecuteAsList<MethodList>("usp_Aspx_GetDynamicRateMethodList", paramList);
List <MethodList> lstMethod = OracleHandler.ExecuteAsList <MethodList>("usp_Aspx_GetDynamicRateMethodL", paramList);
return(lstMethod);
}
//--------------------Store Lists------------------------
public static List <StoreInfo> GetAllStores(AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >();
paramList.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
paramList.Add(new KeyValuePair <string, object>("UserName", aspxCommonObj.UserName));
paramList.Add(new KeyValuePair <string, object>("Culture", aspxCommonObj.CultureName));
OracleHandler sqlHandler = new OracleHandler();
List <StoreInfo> lstStore = sqlHandler.ExecuteAsList <StoreInfo>("usp_Aspx_PortalStoreList", paramList);
return(lstStore);
}
public static List <PortalRole> GetPortalRoles(int portalID, bool isAll, string userName)
{
OracleHandler sqlHandler = new OracleHandler();
List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >();
paramList.Add(new KeyValuePair <string, object>("PortalID", portalID));
paramList.Add(new KeyValuePair <string, object>("IsAll", isAll));
paramList.Add(new KeyValuePair <string, object>("UserName", userName));
List <PortalRole> lstPortalRole = sqlHandler.ExecuteAsList <PortalRole>("sp_PortalRoleList", paramList);
return(lstPortalRole);
}
public List <GoogleCheckOutSettingKeyInfo> GoogleCheckOutSettingKey()
{
try
{
OracleHandler sqLH = new OracleHandler();
return(sqLH.ExecuteAsList <GoogleCheckOutSettingKeyInfo>("[usp_Aspx_GoogleCheckOutSettingsKey]"));
}
catch (Exception ex)
{
throw ex;
}
}
public static List <CategoryRevenueStatics> GetTopCategoryByHighestRevenue(int top, int day, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("Day", day));
parameter.Add(new KeyValuePair <string, object>("Top", top));
OracleHandler sqlH = new OracleHandler();
List <CategoryRevenueStatics> lstCat =
sqlH.ExecuteAsList <CategoryRevenueStatics>("usp_Aspx_GetTopCategoriesByHighestRevenue", parameter);
return(lstCat);
}
public List <Kit> GetKits(AspxCommonInfo commonInfo)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(commonInfo);
OracleHandler sqLh = new OracleHandler();
return(sqLh.ExecuteAsList <Kit>("usp_Aspx_GetKits", parameter));
}
catch (Exception)
{
throw;
}
}
public List <ItemsInfoSettings> GetItemsImageGalleryInfoByItemSKU(string itemSKU, AspxCommonInfo aspxCommonObj, string combinationId)
{
List <ItemsInfoSettings> itemsInfoContainer;
OracleHandler sageSql = new OracleHandler();
List <KeyValuePair <string, object> > paramCol = new List <KeyValuePair <string, object> >();
paramCol.Add(new KeyValuePair <string, object>("ItemSKU", itemSKU));
paramCol.Add(new KeyValuePair <string, object>("StoreID", aspxCommonObj.StoreID));
paramCol.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
paramCol.Add(new KeyValuePair <string, object>("CostVariantConfigID", combinationId));
itemsInfoContainer = sageSql.ExecuteAsList <ItemsInfoSettings>("usp_Aspx_GetImageInformationsBySKU", paramCol);
return(itemsInfoContainer);
}
public static List <ItemsInfoSettings> GetItemsImageGalleryInfoByItemID(int itemID, AspxCommonInfo aspxCommonObj)
{
OracleHandler sageSql = new OracleHandler();
List <KeyValuePair <string, object> > paramCol = new List <KeyValuePair <string, object> >();
paramCol.Add(new KeyValuePair <string, object>("ItemID", itemID));
paramCol.Add(new KeyValuePair <string, object>("StoreID", aspxCommonObj.StoreID));
paramCol.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
paramCol.Add(new KeyValuePair <string, object>("CultureName", aspxCommonObj.CultureName));
List <ItemsInfoSettings> itemsInfoContainer = sageSql.ExecuteAsList <ItemsInfoSettings>("usp_Aspx_GetImageInformationsByItemID", paramCol);
return(itemsInfoContainer);
}
private static List <ShippingMethodInfo> GetProvidersAvailableMethod(int storeId, int portalId, string cultureName)
{
OracleHandler OracleHandler = new OracleHandler();
List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >();
paramList.Add(new KeyValuePair <string, object>("StoreID", storeId));
paramList.Add(new KeyValuePair <string, object>("PortalID", portalId));
paramList.Add(new KeyValuePair <string, object>("CultureName", cultureName));
List <ShippingMethodInfo> lstShipMethod = OracleHandler.ExecuteAsList <ShippingMethodInfo>("usp_Aspx_GetShippingMethodsOfR", paramList);
//List<ShippingMethodInfo> lstShipMethod = OracleHandler.ExecuteAsList<ShippingMethodInfo>("[usp_Aspx_GetShippingMethodsOfRealTime]", paramList);
return(lstShipMethod);
}
public static List <OrderChartInfo> GetOrderChartDetailsBy24Hours(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
OracleHandler sqlH = new OracleHandler();
return(sqlH.ExecuteAsList <OrderChartInfo>("usp_Aspx_GetOrderChartBy24hours", parameter));;
}
catch (Exception e)
{
throw e;
}
}
private static List <ParamList> GetParamsOfMethod(int id, int storeId, int portalId)
{
OracleHandler OracleHandler = new OracleHandler();
List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >();
paramList.Add(new KeyValuePair <string, object>("DynamicMethodID", id));
paramList.Add(new KeyValuePair <string, object>("StoreID", storeId));
paramList.Add(new KeyValuePair <string, object>("PortalID", portalId));
//List<ParamList> lstParamList = OracleHandler.ExecuteAsList<ParamList>("dbo.usp_Aspx_GetParamListByID", paramList);
List <ParamList> lstParamList = OracleHandler.ExecuteAsList <ParamList>("usp_Aspx_GetParamListByID", paramList);
return(lstParamList);
}
public List <ItemTypeInfo> GetItemTypeList()
{
try
{
OracleHandler sqlH = new OracleHandler();
List <ItemTypeInfo> lstItemType = sqlH.ExecuteAsList <ItemTypeInfo>("usp_Aspx_GetItemTypeList");
return(lstItemType);
}
catch (Exception e)
{
throw e;
}
}
public static List <ModuleMessageInfo> GetAllModules()
{
try
{
//SQLHandler SQLH = new SQLHandler();
OracleHandler SQLH = new OracleHandler();
return(SQLH.ExecuteAsList <ModuleMessageInfo>("usp_ModuleMessageGetModules"));
}
catch (Exception)
{
throw;
}
}
public static List <CategoryInfo> GetCategoryMenuList(AspxCommonInfo aspxCommonObj)
{
List <CategoryInfo> catInfo = new List <CategoryInfo>();
if (!CacheHelper.Get("CategoryInfo" + aspxCommonObj.StoreID + aspxCommonObj.PortalID + "_" + aspxCommonObj.CultureName, out catInfo))
{
List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
OracleHandler sageSQL = new OracleHandler();
catInfo = sageSQL.ExecuteAsList <CategoryInfo>("usp_Aspx_GetCategoryMenuAttributes", paramCol);
CacheHelper.Add(catInfo, "CategoryInfo" + aspxCommonObj.StoreID + aspxCommonObj.PortalID + "_" + aspxCommonObj.CultureName);
}
return(catInfo);
}
public static List <Notification> GetAllNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo getNotificationObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("itemId", getNotificationObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("costVariantValuesIds", getNotificationObj.VariantID));
parameter.Add(new KeyValuePair <string, object>("ItemSKU", getNotificationObj.ItemSKU));
parameter.Add(new KeyValuePair <string, object>("UserEmail", getNotificationObj.Email));
OracleHandler sqlH = new OracleHandler();
List <Notification> lstNotification = sqlH.ExecuteAsList <Notification>("usp_Aspx_GetAllNotification", parameter);
return(lstNotification);
}