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