private void BindGridOnPageLoad() { try { bool Issystem = true; List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>(); ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", -1)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@Culture", GetCurrentCultureName)); SQLHandler sqlH = new SQLHandler(); List<sp_GetDefaultListResult> defaultList = sqlH.ExecuteAsList<sp_GetDefaultListResult>("dbo.sp_GetDefaultList", ParaMeterCollection); //var defaultList = dbList.sp_GetDefaultList(-1,GetCurrentCultureName); //{ foreach (sp_GetDefaultListResult topList in defaultList) { BindGrid(topList.ListName, topList.ParentKey);//culture //var listSystemCheck = dbList.sp_GetListsByPortalID(-1, GetCurrentCultureName); List<sp_GetListsByPortalIDResult> listSystemCheck = sqlH.ExecuteAsList<sp_GetListsByPortalIDResult>("dbo.sp_GetListsByPortalID", ParaMeterCollection); foreach (sp_GetListsByPortalIDResult system in listSystemCheck) { if (system.ListName == topList.ListName) Issystem = system.SystemList; } lblListName.Text = topList.ListName; lblDeleteList.Text = "Delete "+topList.ListName+" List"; ViewState["PARENTKEY"] = topList.ParentKey; ViewState["LISTNAME"] = topList.ListName; } if (Issystem == true) { gdvSubList.Columns[4].Visible = false; } else { gdvSubList.Columns[4].Visible = true; } lblParent.Visible = false; if (ViewState["LIST"] != null) { lblEntry.Text = ViewState["LIST"].ToString() + " " + GetSageMessage("ListSettings", "Entries"); } ViewMode(); pnlListAll.Visible = true; //} } catch (Exception ex) { ProcessException(ex); } }
public List<States> GetStatesByCountry(string countryCode) { var sqlHandler = new SQLHandler(); var paramList = new List<KeyValuePair<string, object>> { new KeyValuePair<string, object>("@CountryCode", countryCode) }; List<States> cl = sqlHandler.ExecuteAsList<States>("usp_Aspx_GetStateList", paramList); return cl; }
public List<ContactUsInfo> ContactUsGetAll(int portalID) { List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>(); ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalID)); SQLHandler sqlH = new SQLHandler(); return sqlH.ExecuteAsList<ContactUsInfo>("sp_ContactUsGetAll", ParaMeterCollection); }
public static List<LayoutMgrInfo> GetAdminModules(int PortalID) { SQLHandler SQLH = new SQLHandler(); List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>(); ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); return SQLH.ExecuteAsList<LayoutMgrInfo>("[dbo].[usp_ModuleManagerGetAdminModules]",ParaMeterCollection); }
/// <summary> /// To Bind Attribute Type dropdown /// </summary> /// <returns></returns> public List<AttributesInputTypeInfo> GetAttributesInputType() { List<AttributesInputTypeInfo> ml; SQLHandler sqlH = new SQLHandler(); ml = sqlH.ExecuteAsList<AttributesInputTypeInfo>("dbo.usp_Aspx_AttributesInputTypeGetAll"); return ml; }
public static List<PricingRuleAttributeInfo> GetPricingRuleAttributes(AspxCommonInfo aspxCommonObj) { SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> paramList = CommonParmBuilder.GetParamSPUC(aspxCommonObj); List<PricingRuleAttributeInfo> lstPriceRuleAttr = sqlHandler.ExecuteAsList<PricingRuleAttributeInfo>("usp_Aspx_GetPricingRuleAttr", paramList); return lstPriceRuleAttr; }
/// <summary> /// Connects to database and gets breadcrumb. /// </summary> /// <param name="SEOName">SEOName</param> /// <param name="PortalID">PortalID</param> /// <param name="MenuId">MenuId</param> /// <param name="CultureCode">CultureCode</param> /// <returns>Returns BreadCrumInfo list </returns> public List<BreadCrumInfo> GetBreadCrumb(string SEOName, int PortalID, int MenuId, string CultureCode) { try { List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>(); ParaMeterCollection.Add(new KeyValuePair<string, object>("@SEOName", SEOName)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@CultureCode", CultureCode)); //if (MenuId != 0) //{ // ParaMeterCollection.Add(new KeyValuePair<string, object>("@MenuID", MenuId)); // SQLHandler SQLH = new SQLHandler(); // SQLH.ExecuteNonQuery("[dbo].[usp_BreadCrumbGetFromMenuItem]", ParaMeterCollection); // return SQLH.ExecuteAsList<BreadCrumInfo>("usp_BreadCrumbMenuItemPath"); //} //else //{ SQLHandler SQLH = new SQLHandler(); return SQLH.ExecuteAsList<BreadCrumInfo>("usp_BreadCrumbGetFromPageName", ParaMeterCollection); //} } catch (Exception) { throw; } }
/// <summary> /// To Bind Attribute Type dropdown /// </summary> /// <returns></returns> public List<AttributesInputTypeInfo> GetAttributesInputType() { List<AttributesInputTypeInfo> ml = new List<AttributesInputTypeInfo>(); SQLHandler Sq = new SQLHandler(); ml = Sq.ExecuteAsList<AttributesInputTypeInfo>("dbo.usp_ASPX_AttributesInputTypeGetAll"); return ml; }
public static List<TickerInfo> LoadOngdvTickerData(int StoreID,int PortalID) { List<KeyValuePair<string, object>> Parameter = new List<KeyValuePair<string, object>>(); Parameter.Add(new KeyValuePair<string, object>("@StoreID", StoreID)); Parameter.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); SQLHandler sqlHand = new SQLHandler(); return sqlHand.ExecuteAsList<TickerInfo>("usp_TickerLoadData",Parameter); }
public static List<LayoutMgrInfo> GetModuleInformation(string ModuleName) { SQLHandler SQLH = new SQLHandler(); List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>(); ParaMeterCollection.Add(new KeyValuePair<string, object>("@FriendlyName", ModuleName)); return SQLH.ExecuteAsList<LayoutMgrInfo>("[dbo].[usp_GetModuleInformation]", ParaMeterCollection); }
public List<PortalInfo> GetPortalSeoName(int portalID, string userName) { SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>(); paramList.Add(new KeyValuePair<string, object>("@PortalID", portalID)); paramList.Add(new KeyValuePair<string, object>("@Username", userName)); return sqlHandler.ExecuteAsList<PortalInfo>("sp_PortalGetByPortalID", paramList); }
public static List<CategoryInfo> GetCategoryAll(bool isActive, AspxCommonInfo aspxCommonObj) { SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", isActive)); List<CategoryInfo> catList = sqlHandler.ExecuteAsList<CategoryInfo>("dbo.usp_Aspx_GetCategoryAll", parameterCollection); return catList; }
/// <summary> /// Connects to database and returns dashboardsettinginfo list(Top five visit). /// </summary> /// <param name="StartDate">Start date.</param> /// <param name="EndDate">End date.</param> /// <returns>DashBoardSettingInfo list.</returns> 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(); return SQLH.ExecuteAsList<DashBoardSettingInfo>("[dbo].[usp_GetTopFivevisitedPage]", ParaMeterCollection); }
public List<TickerInfo> GetAllTickerItem(int StoreID, int PortalID) { List<KeyValuePair<string, object>> Parameter = new List<KeyValuePair<string, object>>(); Parameter.Add(new KeyValuePair<string, object>("@StoreID", StoreID)); Parameter.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); SQLHandler sqlH = new SQLHandler(); return sqlH.ExecuteAsList<TickerInfo>("usp_TickerGetAllTickerItems", Parameter); }
public static List<WareHouseAddress> GetAllWareHouseById(int wareHouseID, AspxCommonInfo aspxCommonObj) { List<KeyValuePair<string, object>> paramCol = CommonParmBuilder.GetParamSP(aspxCommonObj); paramCol.Add(new KeyValuePair<string, object>("@WareHouseID", wareHouseID)); SQLHandler sageSQL = new SQLHandler(); List<WareHouseAddress> wList = sageSQL.ExecuteAsList<WareHouseAddress>("[usp_Aspx_SelectWareHouseByID]", paramCol); return wList; }
/// <summary> /// To Bind Attribute Item Type dropdown /// </summary> /// <returns></returns> public static List<AttributesItemTypeInfo> GetAttributesItemType(AspxCommonInfo aspxCommonObj) { List<AttributesItemTypeInfo> ml; SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj); ml = sqlH.ExecuteAsList<AttributesItemTypeInfo>("dbo.usp_Aspx_AttributesItemTypeGetAll", parameterCollection); return ml; }
public List<SpecialItemsInfo> GetSpecialItems(AspxCommonInfo aspxCommonObj, int count) { List<KeyValuePair<string, object>> paramCol = CommonParmBuilder.GetParamSPUC(aspxCommonObj); paramCol.Add(new KeyValuePair<string, object>("@count", count)); SQLHandler sageSQL = new SQLHandler(); List<SpecialItemsInfo> slInfo = sageSQL.ExecuteAsList<SpecialItemsInfo>("[dbo].[usp_Aspx_GetSpecialItems]", paramCol); return slInfo; }
public static List<States> GetStatesByCountry(string countryCode) { SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>(); paramList.Add(new KeyValuePair<string, object>("@CountryCode", countryCode)); List<States> lstState = sqlHandler.ExecuteAsList<States>("usp_Aspx_GetStateList", paramList); return lstState; }
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)); SQLHandler sqlH = new SQLHandler(); 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", isByCategory)); SQLHandler sqlH = new SQLHandler(); List<Filter> lstFilter = sqlH.ExecuteAsList<Filter>("usp_Aspx_ShoppingFilter", parameter); return lstFilter; }
public List<StoreInfo> GetAllStores(int portalID, string userName, string culture) { List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>(); paramList.Add(new KeyValuePair<string, object>("@PortalID", portalID)); paramList.Add(new KeyValuePair<string, object>("@Username", userName)); paramList.Add(new KeyValuePair<string, object>("@Culture", culture)); SQLHandler sqlHandler = new SQLHandler(); return sqlHandler.ExecuteAsList<StoreInfo>("usp_Aspx_PortalStoreList", paramList); }
public static List<LayoutMgrInfo> SearchModules(string search,int PortalID,bool IsAdmin) { SQLHandler SQLH = new SQLHandler(); 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>("[dbo].[usp_ModuleManagerGetSearchModules]", ParaMeterCollection); }
public static List<WareHouse> GetAllWareHouse(int offset, int limit, AspxCommonInfo aspxCommonObj) { List<KeyValuePair<string, object>> paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj); paramCol.Add(new KeyValuePair<string, object>("@limit", limit)); paramCol.Add(new KeyValuePair<string, object>("@offset", offset)); SQLHandler sageSQL = new SQLHandler(); List<WareHouse> wList = sageSQL.ExecuteAsList<WareHouse>("[dbo].[usp_Aspx_SelectWareHousesAll]", paramCol); return wList; }
public static List<CategoryAttributeInfo> GetCategoryByCategoryID(Int32 categoryID, AspxCommonInfo aspxCommonObj) { SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", categoryID)); List<CategoryAttributeInfo> catList = sqlHandler.ExecuteAsList<CategoryAttributeInfo>("dbo.usp_Aspx_GetCategoryByCategoryID", parameterCollection); return catList; }
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)); SQLHandler sqlH = new SQLHandler(); List<VisitorNewOrderStatics> lstVisitor = sqlH.ExecuteAsList<VisitorNewOrderStatics>("usp_Aspx_GetNewAccountNewOrderRatio", parameter); return lstVisitor; }
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)); SQLHandler sqlH = new SQLHandler(); List<RefundReasonStatics> lstRefund = sqlH.ExecuteAsList<RefundReasonStatics>("usp_GetTopFiveReasonsToRefund", parameter); return lstRefund; }
public 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)); SQLHandler sqlHandler = new SQLHandler(); return sqlHandler.ExecuteAsList<StoreInfo>("usp_Aspx_PortalStoreList", paramList); }
public static List<ItemCommonInfo> GetItemsListByCategory(AspxCommonInfo aspxCommonObj, int categoryID) { List<ItemCommonInfo> ml; SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", categoryID)); ml = sqlH.ExecuteAsList<ItemCommonInfo>("usp_Aspx_GetItemsListByCategory", parameterCollection); return ml; }
public List<PortalRole> GetPortalRoles(int portalID, bool isAll, string userName) { SQLHandler sqlHandler = new SQLHandler(); 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)); return sqlHandler.ExecuteAsList<PortalRole>("sp_PortalRoleList", paramList); }
/// <summary> /// To Bind Attribute Item Type dropdown /// </summary> /// <returns></returns> public List<AttributesItemTypeInfo> GetAttributesItemType(int storeId, int portalId) { List<AttributesItemTypeInfo> ml; SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>(); parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", storeId)); parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalId)); ml = sqlH.ExecuteAsList<AttributesItemTypeInfo>("dbo.usp_Aspx_AttributesItemTypeGetAll", parameterCollection); return ml; }
//---------------------------------------------------------------------------------------------- //-----------------------------------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); }
public List <ServiceItemRss> GetServiceTypeRssContent(AspxCommonInfo aspxCommonObj, int count) { try { 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)); SQLHandler SQLH = new SQLHandler(); List <ServiceItemRss> rssFeedContent = SQLH.ExecuteAsList <ServiceItemRss>("[dbo].[usp_Aspx_GetRssFeedServiceTypeItem]", Parameter); return(rssFeedContent); } catch (Exception ex) { throw ex; } }
/// <summary> /// Connects to database and get module web info. /// </summary> /// <returns>ModuleWebInfo list.</returns> public static List <ModuleWebInfo> GetModuleWebInfo() { SQLHandler sageSql = new SQLHandler(); try { List <ModuleWebInfo> list = sageSql.ExecuteAsList <ModuleWebInfo>("usp_ModuleWebInfoGetAll"); //foreach (ModuleWebInfo moduleInfo in list) //{ // moduleInfo.DownloadUrl = ""; //} return(list); } catch (Exception) { throw; } }
public static List <CardTypeInfo> AddUpdateCardType(AspxCommonInfo aspxCommonObj, CardTypeSaveInfo cardTypeSaveObj, string uploadedFile) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@CardTypeID", cardTypeSaveObj.CardTypeID)); parameter.Add(new KeyValuePair <string, object>("@CardTypeName", cardTypeSaveObj.CardTypeName)); parameter.Add(new KeyValuePair <string, object>("@ImagePath", uploadedFile)); parameter.Add(new KeyValuePair <string, object>("@AlternateText", cardTypeSaveObj.AlternateText)); parameter.Add(new KeyValuePair <string, object>("@IsActive", cardTypeSaveObj.IsActive)); SQLHandler sqlH = new SQLHandler(); List <CardTypeInfo> lstCardType = sqlH.ExecuteAsList <CardTypeInfo>("[dbo].[usp_Aspx_AddUpdateCardType]", parameter); return(lstCardType); } catch (Exception e) { throw e; } }
public static List <InvoiceDetailsInfo> GetInvoiceDetailsList(int offset, System.Nullable <int> limit, InvoiceBasicInfo invoiceObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@offset", offset)); parameter.Add(new KeyValuePair <string, object>("@limit", limit)); parameter.Add(new KeyValuePair <string, object>("@InvoiceNumber", invoiceObj.InvoiceNumber)); parameter.Add(new KeyValuePair <string, object>("@BillToName", invoiceObj.BillToName)); parameter.Add(new KeyValuePair <string, object>("@Status", invoiceObj.OrderStatusName)); SQLHandler sqlH = new SQLHandler(); List <InvoiceDetailsInfo> lstInvoiceDetail = sqlH.ExecuteAsList <InvoiceDetailsInfo>("usp_Aspx_GetInvoiceDetails", parameter); return(lstInvoiceDetail); } catch (Exception e) { throw e; } }
public List <ListManagementInfo> GetListEntriesByNameValueAndEntryID(string ListName, string Value, int EntryID, string Culture) { try { SQLHandler SQLH = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@ListName", ListName)); ParamCollInput.Add(new KeyValuePair <string, object>("@Value", Value)); ParamCollInput.Add(new KeyValuePair <string, object>("@EntryID", EntryID)); ParamCollInput.Add(new KeyValuePair <string, object>("@Culture", Culture)); return(SQLH.ExecuteAsList <ListManagementInfo>("[dbo].[sp_GetListEntrybyNameValueAndEntryID]", ParamCollInput)); } catch (Exception ex) { throw ex; } }
public List <ShippingMethodInfo> GetShippingMethods(int offset, int limit, ShippingMethodInfoByProvider shippingMethodObj, AspxCommonInfo aspxCommonObj) { List <ShippingMethodInfo> shipping; 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>("@ShippingMethodName", shippingMethodObj.ShippingMethodName)); parameterCollection.Add(new KeyValuePair <string, object>("@DeliveryTime", shippingMethodObj.DeliveryTime)); parameterCollection.Add(new KeyValuePair <string, object>("@WeightLimitFrom", shippingMethodObj.WeightLimitFrom)); parameterCollection.Add(new KeyValuePair <string, object>("@WeightLimitTo", shippingMethodObj.WeightLimitTo)); parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", shippingMethodObj.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>("@CultureName", aspxCommonObj.CultureName)); shipping = sqlH.ExecuteAsList <ShippingMethodInfo>("usp_Aspx_BindShippingMethodInGrid", parameterCollection); return(shipping); }
public static List <ItemBasicDetailsInfo> GetShoppingOptionsItemsResultByBrandAndPrice(int offset, int limit, string brandIDs, decimal priceFrom, decimal priceTo, int SortBy, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@offset", offset)); parameter.Add(new KeyValuePair <string, object>("@limit", limit)); parameter.Add(new KeyValuePair <string, object>("@brandIDs", brandIDs)); parameter.Add(new KeyValuePair <string, object>("@priceFrom", priceFrom)); parameter.Add(new KeyValuePair <string, object>("@priceTo", priceTo)); parameter.Add(new KeyValuePair <string, object>("@SortBy", SortBy)); SQLHandler sqlH = new SQLHandler(); List <ItemBasicDetailsInfo> lstItemBasicDet = sqlH.ExecuteAsList <ItemBasicDetailsInfo>("usp_Aspx_GetShoppingOptionsItemsResultByBrandAndPrice", parameter); return(lstItemBasicDet); } catch (Exception e) { throw e; } }
public static List<ShippingCostInfo> GetShippingCostByItem(int storeID, int portalID, int customerID, string sessionCode, string userName, string cultureName) { try { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID)); parameter.Add(new KeyValuePair<string, object>("@CustomerID", customerID)); parameter.Add(new KeyValuePair<string, object>("@SessionCode", sessionCode)); parameter.Add(new KeyValuePair<string, object>("@UserName", userName)); parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName)); SQLHandler sqlH = new SQLHandler(); List<ShippingCostInfo> lstShipCost= sqlH.ExecuteAsList<ShippingCostInfo>("usp_Aspx_ShippingDetailsForItem", parameter); return lstShipCost; } catch (Exception e) { throw e; } }
public static List <StoreAccessInfo> LoadStoreAccessCreditCards(int offset, int limit, string search, System.Nullable <DateTime> startDate, System.Nullable <DateTime> endDate, System.Nullable <bool> status, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@offset", offset)); parameter.Add(new KeyValuePair <string, object>("@limit", limit)); parameter.Add(new KeyValuePair <string, object>("@Search", search)); parameter.Add(new KeyValuePair <string, object>("@StartDate", startDate)); parameter.Add(new KeyValuePair <string, object>("@EndDate", endDate)); parameter.Add(new KeyValuePair <string, object>("@Status", status)); List <StoreAccessInfo> lstStoreAccess = sqlH.ExecuteAsList <StoreAccessInfo>("[dbo].[usp_Aspx_GetStoreAccessCreditCard]", parameter); return(lstStoreAccess); } catch (Exception e) { throw e; } }
/// <summary> /// Return modules assigne with page for anonymous user. /// </summary> /// <param name="controlType">Application control type.</param> /// <param name="pageSEOName">Page name.</param> /// <param name="userName">User name.</param> /// <param name="cultureCode">Culture code.</param> /// <returns>UserModuleInfo list.</returns> public List <UserModuleInfo> GetPageModules_Anonymous(string controlType, string pageSEOName, string userName, string cultureCode) { try { List <KeyValuePair <string, string> > ParaMeterCollection = new List <KeyValuePair <string, string> >(); ParaMeterCollection.Add(new KeyValuePair <string, string>("@ControlType", controlType)); ParaMeterCollection.Add(new KeyValuePair <string, string>("@PageSEOName", pageSEOName)); ParaMeterCollection.Add(new KeyValuePair <string, string>("@PortalID", GetPortalID.ToString())); ParaMeterCollection.Add(new KeyValuePair <string, string>("@UserName", userName)); ParaMeterCollection.Add(new KeyValuePair <string, string>("@CultureCode", cultureCode)); List <UserModuleInfo> lstPageModules = new List <UserModuleInfo>(); SQLHandler sagesql = new SQLHandler(); lstPageModules = sagesql.ExecuteAsList <UserModuleInfo>("[dbo].[usp_MasterPageGetPageModules_Anonymous]", ParaMeterCollection); return(lstPageModules); } catch (Exception e) { throw e; } }
public List <MessageManagementInfo> GetMessageTemplateListForSubscribe(int current, int pagesize, bool IsActive, bool IsDeleted, int PortalID, string UserName, string CultureName) { try { List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >(); Param.Add(new KeyValuePair <string, object>("@Current", current)); Param.Add(new KeyValuePair <string, object>("@Pagesize", pagesize)); Param.Add(new KeyValuePair <string, object>("@IsActive", IsActive)); Param.Add(new KeyValuePair <string, object>("@IsDeleted", IsDeleted)); Param.Add(new KeyValuePair <string, object>("@PortalID", PortalID)); Param.Add(new KeyValuePair <string, object>("@UserName", UserName)); Param.Add(new KeyValuePair <string, object>("@CurrentCulture", CultureName)); SQLHandler sqlh = new SQLHandler(); return(sqlh.ExecuteAsList <MessageManagementInfo>("usp_NL_GetMessageTemplateList", Param)); } catch (Exception ex) { throw ex; } }
public static List <PriceHistoryInfo> BindPriceHistory(int offset, int limit, AspxCommonInfo aspxCommerceObj, string itemName, string userName) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@offset", offset)); parameter.Add(new KeyValuePair <string, object>("@limit", limit)); parameter.Add(new KeyValuePair <string, object>("@StoreID", aspxCommerceObj.StoreID)); parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommerceObj.PortalID)); parameter.Add(new KeyValuePair <string, object>("@ItemName", itemName)); parameter.Add(new KeyValuePair <string, object>("@UserName", userName)); SQLHandler sqlH = new SQLHandler(); List <PriceHistoryInfo> list = sqlH.ExecuteAsList <PriceHistoryInfo>("[dbo].[usp_Aspx_GetPriceHistoryList]", parameter); return(list); } catch (Exception ex) { throw ex; } }
/// <summary> /// Connects to database and returns QuickLink list. /// </summary> /// <param name="UserName">UserName.</param> /// <param name="PortalID">PortalID.</param> /// <returns>QuickLink list.</returns> public static List <QuickLink> GetQuickLinks(string UserName, int PortalID) { string sp = "[dbo].[usp_DashboardQuickLinkGet]"; SQLHandler sagesql = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@UserName", UserName)); ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID)); List <QuickLink> lstLinks = new List <QuickLink>(); try { lstLinks = sagesql.ExecuteAsList <QuickLink>(sp, ParamCollInput); return(lstLinks); } catch (Exception) { throw; } }
public List <CategoryItemInfo> GetCategoryItems(Int32 offset, Int32 limit, Int32 categoryID, string sku, string name, System.Nullable <decimal> priceFrom, System.Nullable <decimal> priceTo, Int32 storeID, Int32 portalID, string userName, string culture) { List <CategoryItemInfo> listCategoryItem; SQLHandler sqlHandler = 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>("@CategoryID", categoryID)); parameterCollection.Add(new KeyValuePair <string, object>("@SKU", sku)); parameterCollection.Add(new KeyValuePair <string, object>("@Name", name)); parameterCollection.Add(new KeyValuePair <string, object>("@PriceFrom", priceFrom)); parameterCollection.Add(new KeyValuePair <string, object>("@PriceTo", priceTo)); parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", storeID)); parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", portalID)); parameterCollection.Add(new KeyValuePair <string, object>("@Username", userName)); parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", culture)); listCategoryItem = sqlHandler.ExecuteAsList <CategoryItemInfo>("dbo.usp_Aspx_GetItemsByCategoryID", parameterCollection); return(listCategoryItem); }
//--------------tax rates------------------ public static List <TaxRateInfo> GetTaxRateDetails(int offset, System.Nullable <int> limit, TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj) { try { 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>("@TaxName", taxRateDataObj.TaxName)); parameter.Add(new KeyValuePair <string, object>("@SearchCountry", taxRateDataObj.Country)); parameter.Add(new KeyValuePair <string, object>("@SerachState", taxRateDataObj.State)); parameter.Add(new KeyValuePair <string, object>("@Zip", taxRateDataObj.Zip)); SQLHandler sqlh = new SQLHandler(); List <TaxRateInfo> lstTaxRate = sqlh.ExecuteAsList <TaxRateInfo>("usp_Aspx_GetTaxRates", parameter); return(lstTaxRate); } catch (Exception e) { throw e; } }
public static List <GeneralSettingInfo> GetGeneralSetting(AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >(); parameterCollection.Add(new KeyValuePair <string, object>("@CustomerID", aspxCommonObj.CustomerID)); parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID)); parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName)); SQLHandler sqLH = new SQLHandler(); List <GeneralSettingInfo> lstGeneralSet = sqLH.ExecuteAsList <GeneralSettingInfo>("usp_Aspx_RewardPointsGeneralSettingsGetAll", parameterCollection); return(lstGeneralSet); } catch (Exception e) { throw e; } }
public static List <RssFeedCategory> GetCategoryRssContent(AspxCommonInfo aspxCommonObj, string rssOption, int count) { try { var rssFeedContent = new List <RssFeedCategory>(); 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)); SQLHandler SQLH = new SQLHandler(); rssFeedContent = SQLH.ExecuteAsList <RssFeedCategory>("[dbo].[usp_Aspx_GetRssFeedCategory]", Parameter); return(rssFeedContent); } catch (Exception ex) { throw ex; } }
/// <summary> /// To Bind grid /// </summary> /// <returns></returns> public List <AttributesBasicInfo> GetItemAttributes(int offset, int limit, string attributeName, System.Nullable <bool> isRequired, System.Nullable <bool> comparable, System.Nullable <bool> isSystem, int storeId, int portalId, string cultureName, string userName) //(int portalID, int userModuleID, string cultureName) { List <AttributesBasicInfo> 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>("@AttributeName", attributeName)); parameterCollection.Add(new KeyValuePair <string, object>("@IsRequired", isRequired)); parameterCollection.Add(new KeyValuePair <string, object>("@Comparable", comparable)); parameterCollection.Add(new KeyValuePair <string, object>("@IsSystem", isSystem)); parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", storeId)); parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", portalId)); parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", cultureName)); //parameterCollection.Add(new KeyValuePair<string, object>("@UserName", userName)); ml = sqlH.ExecuteAsList <AttributesBasicInfo>("dbo.usp_Aspx_AttributesGetAll", parameterCollection); return(ml); }
/// <summary> /// Connects to database and Returns all the message template type. /// </summary> /// <param name="IsActive">Set true if the message template is active.</param> /// <param name="IsDeleted">Set true if the message template is deleted.</param> /// <param name="PortalID">Portal ID.</param> /// <param name="Username">User's name.</param> /// <param name="CurrentCulture">Culture name.</param> /// <returns>List of MessageManagementInfo object containing message template type.</returns> public List <MessageManagementInfo> GetMessageTemplateTypeList(bool IsActive, bool IsDeleted, int PortalID, string Username, string CurrentCulture) { try { string sp = "[dbo].[sp_GetMessageTemplateTypeList]"; SQLHandler SQLH = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive)); ParamCollInput.Add(new KeyValuePair <string, object>("@IsDeleted", IsDeleted)); ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID)); ParamCollInput.Add(new KeyValuePair <string, object>("@UserName", Username)); ParamCollInput.Add(new KeyValuePair <string, object>("@CurrentCulture", CurrentCulture)); return(SQLH.ExecuteAsList <MessageManagementInfo>(sp, ParamCollInput)); } catch (Exception ex) { throw ex; } }
//------------------------------Get ShippingMethodByTotalItemsWeight-------------------------- public static List<ShippingMethodInfo> GetShippingMethodByWeight(int storeID, int portalID, int customerID, string userName, string cultureName, string sessionCode) { try { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID)); parameter.Add(new KeyValuePair<string, object>("@CustomerID", customerID)); parameter.Add(new KeyValuePair<string, object>("@UserName", userName)); parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName)); parameter.Add(new KeyValuePair<string, object>("@SessionCode", sessionCode)); SQLHandler sqlH = new SQLHandler(); List<ShippingMethodInfo> lstShipMethod= sqlH.ExecuteAsList<ShippingMethodInfo>("usp_Aspx_GetShippingMethodByTotalWeight", parameter); return lstShipMethod; } catch (Exception e) { throw e; } }
public List <TaskToDoInfo> GetTask(int PortalID, int UserModuleId, string CultureField, int offset, string str, string UserName, string SearchDate) { try { List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >(); Param.Add(new KeyValuePair <string, object>("@PortalID", PortalID)); Param.Add(new KeyValuePair <string, object>("@ModuleId", UserModuleId)); Param.Add(new KeyValuePair <string, object>("@CultureField", CultureField)); Param.Add(new KeyValuePair <string, object>("@offset", offset)); Param.Add(new KeyValuePair <string, object>("@STR", str)); Param.Add(new KeyValuePair <string, object>("@Date", SearchDate)); Param.Add(new KeyValuePair <string, object>("@UserName", UserName)); SQLHandler handler = new SQLHandler(); return(handler.ExecuteAsList <TaskToDoInfo>("[dbo].[usp_TaskToDo_GetTask]", Param)); } catch (Exception e) { throw e; } }
protected void BindControls() { try { List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >(); ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", GetPortalID)); SQLHandler sqlH = new SQLHandler(); List <ModuleInfo> lstAvailableModules = new List <ModuleInfo>(); lstAvailableModules = sqlH.ExecuteAsList <ModuleInfo>("sp_ModulesGetByPortalID", ParaMeterCollection); lbAvailableModules.DataSource = lstAvailableModules; lbAvailableModules.DataTextField = "ModuleName"; lbAvailableModules.DataValueField = "ModuleID"; lbAvailableModules.DataBind(); ViewState["ModulesList"] = lstAvailableModules; } catch (Exception ex) { ProcessException(ex); } }
public List <CategoryDetailsOptionsInfo> GetSpecialItemDetails(int offset, int limit, AspxCommonInfo aspxCommonObj, int sortBy) { try { 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>("@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>("@SortBy", sortBy)); SQLHandler sqlH = new SQLHandler(); return(sqlH.ExecuteAsList <CategoryDetailsOptionsInfo>("usp_Aspx_GetSpecialItemDetails", parameterCollection)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Connects to database and obtains file manager settings for given UserModuleID and PortalID. /// </summary> /// <param name="UserModuleID">UserModuleID</param> /// <param name="PortalID">PortalID</param> /// <returns>List of FileManagerSettingInfo class containing file manager settings. </returns> public static List <FileManagerSettingInfo> GetFileManagerSettings(int UserModuleID, int PortalID) { List <FileManagerSettingInfo> lstSettings = new List <FileManagerSettingInfo>(); string StoredProcedureName = "usp_FileManagerSettingGetAll"; SQLHandler sagesql = new SQLHandler(); List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >(); ParaMeterCollection.Add(new KeyValuePair <string, object>("@UserModuleID", UserModuleID)); ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", PortalID)); try { lstSettings = sagesql.ExecuteAsList <FileManagerSettingInfo>(StoredProcedureName, ParaMeterCollection); } catch (Exception e) { throw e; } return(lstSettings); }
public static List <UserRatingInformationInfo> GetAllItemReviewsList(int offset, System.Nullable <int> limit, UserRatingBasicInfo itemReviewObj, AspxCommonInfo aspxCommonObj) { try { 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>("@ItemID", itemReviewObj.ItemID)); parameter.Add(new KeyValuePair <string, object>("@UserName", itemReviewObj.UserName)); parameter.Add(new KeyValuePair <string, object>("@StatusName", itemReviewObj.Status)); parameter.Add(new KeyValuePair <string, object>("@ItemName", itemReviewObj.ItemName)); SQLHandler sqlH = new SQLHandler(); List <UserRatingInformationInfo> bind = sqlH.ExecuteAsList <UserRatingInformationInfo>("usp_Aspx_GetItemWiseReviewsList", parameter); return(bind); } catch (Exception e) { throw e; } }
/// <summary> /// To Bind grid /// </summary> /// <returns></returns> public List <AttributesBasicInfo> GetItemAttributes(int offset, int limit, AttributeBindInfo attrbuteBindObj, AspxCommonInfo aspxCommonObj) //(int portalID, int userModuleID, string cultureName) { List <AttributesBasicInfo> 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>("@AttributeName", attrbuteBindObj.AttributeName)); parameterCollection.Add(new KeyValuePair <string, object>("@IsRequired", attrbuteBindObj.IsRequired)); parameterCollection.Add(new KeyValuePair <string, object>("@Comparable", attrbuteBindObj.ShowInComparison)); parameterCollection.Add(new KeyValuePair <string, object>("@IsSystem", attrbuteBindObj.IsSystemUsed)); parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID)); parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName)); //parameterCollection.Add(new KeyValuePair<string, object>("@UserName", userName)); ml = sqlH.ExecuteAsList <AttributesBasicInfo>("dbo.usp_Aspx_AttributesGetAll", parameterCollection); return(ml); }
public static List <CouponInfo> BindAllCouponDetails(int offset, int limit, GetCouponDetailsInfo couponDetailObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@offset", offset)); parameter.Add(new KeyValuePair <string, object>("@limit", limit)); parameter.Add(new KeyValuePair <string, object>("@CouponTypeID", couponDetailObj.CouponTypeID)); parameter.Add(new KeyValuePair <string, object>("@CouponCode", couponDetailObj.CouponCode)); parameter.Add(new KeyValuePair <string, object>("@ValidateFrom", couponDetailObj.ValidateFrom)); parameter.Add(new KeyValuePair <string, object>("@ValidateTo", couponDetailObj.ValidateTo)); SQLHandler sqlH = new SQLHandler(); List <CouponInfo> lstCoupon = sqlH.ExecuteAsList <CouponInfo>("usp_Aspx_GetCouponDetails", parameter); return(lstCoupon); } catch (Exception ex) { throw ex; } }
/// <summary> /// Connects to database and returns list of list entries. /// </summary> /// <param name="listName">List name.</param> /// <param name="parentId">List's parent ID.</param> /// <param name="portalID">Portal ID</param> /// <param name="cultureName">Culture name</param> /// <returns>List of List's entities</returns> public List <ListInfo> GetListInfo(string listName, string parentId, int portalID, string cultureName) { try { List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >(); ParaMeterCollection.Add(new KeyValuePair <string, object>("@ListName", listName)); ParaMeterCollection.Add(new KeyValuePair <string, object>("@ParentKey", parentId)); ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", portalID)); ParaMeterCollection.Add(new KeyValuePair <string, object>("@Culture", cultureName)); SQLHandler sqlH = new SQLHandler(); List <ListInfo> listParentEntry = new List <ListInfo>(); listParentEntry = sqlH.ExecuteAsList <ListInfo>("dbo.sp_GetListEntriesByNameParentKeyAndPortalID", ParaMeterCollection); return(listParentEntry); } catch (Exception e) { throw e; } }
private static List <ShippingMethodInfo> GetStoreProvidersAvailableMethod(int providerId, int storeId, int portalId) { try { var sqlHandler = new SQLHandler(); var paramList = new List <KeyValuePair <string, object> > { new KeyValuePair <string, object>("@StoreID", storeId), new KeyValuePair <string, object>("@ShippingProviderId", providerId), new KeyValuePair <string, object>("@PortalID", portalId), new KeyValuePair <string, object>("@IsActive", true), new KeyValuePair <string, object>("@CultureName", "en-US") }; return(sqlHandler.ExecuteAsList <ShippingMethodInfo>("[usp_Aspx_GetProviderShippingMethods]", paramList)); } catch (Exception ex) { throw ex; } }