public DataSet GetAdvanceSearchDataSet(string prefix, bool isActive, AspxCommonInfo aspxCommonObj, int CategoryID, bool IsGiftCard) { try { DataSet objHDSetting = new DataSet(); if (!CacheHelper.Get("AdvanceSearchDataSet" + aspxCommonObj.StoreID.ToString() + aspxCommonObj.PortalID.ToString() + "_" + aspxCommonObj.CultureName, out objHDSetting)) { int itemID = 0; List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", CategoryID)); parameterCollection.Add(new KeyValuePair<string, object>("@IsGiftCard", IsGiftCard)); parameterCollection.Add(new KeyValuePair<string, object>("@Prefix", prefix)); parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", isActive)); parameterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemID)); parameterCollection.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName)); SQLHandler sqlH = new SQLHandler(); objHDSetting = sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_AdvanceSearch]", parameterCollection); } return objHDSetting; } catch (Exception e) { throw e; } }
public static DataSet GetGeneralSearchDataSet(AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); return(sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_GetSimpleSearchInfo]", parameterCollection)); }
public DataSet GetAdvanceSearchDataSet(string prefix, bool isActive, AspxCommonInfo aspxCommonObj, int CategoryID, bool IsGiftCard) { try { DataSet objHDSetting = new DataSet(); if (!CacheHelper.Get("AdvanceSearchDataSet" + aspxCommonObj.StoreID.ToString() + aspxCommonObj.PortalID.ToString() + "_" + aspxCommonObj.CultureName, out objHDSetting)) { int itemID = 0; List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@CategoryID", CategoryID)); parameterCollection.Add(new KeyValuePair <string, object>("@IsGiftCard", IsGiftCard)); parameterCollection.Add(new KeyValuePair <string, object>("@Prefix", prefix)); parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", isActive)); parameterCollection.Add(new KeyValuePair <string, object>("@ItemID", itemID)); parameterCollection.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName)); SQLHandler sqlH = new SQLHandler(); objHDSetting = sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_AdvanceSearch]", parameterCollection); } return(objHDSetting); } catch (Exception e) { throw e; } }
public static DataSet GetCompareItemsDataSet(AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetFullParam(aspxCommonObj); SQLHandler sqlHandler = new SQLHandler(); return(sqlHandler.ExecuteAsDataSet("[dbo].[usp_Aspx_Get_CompareItemsInfo]", parameterCollection)); }
public static DataSet GetSpecialItemsandSettingDataSet(AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); SQLHandler SQLH = new SQLHandler(); return(SQLH.ExecuteAsDataSet("[dbo].[usp_Aspx_GetSpecialItemsInfo]", parameter)); }
public static DataSet GetWishItemList(AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); return(sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_GetWishListItem]", parameterCollection)); }
internal MassMailSendInfo GetMailAndUserToSendMail(string SecheduleDate) { const string sp = "[dbo].[Admin_MassMail_GetMailForSend]"; List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >(); Param.Add(new KeyValuePair <string, object>("@ScheduleDate", SecheduleDate)); SQLHandler objHandler = new SQLHandler(); try { DataSet ds = objHandler.ExecuteAsDataSet(sp, Param); if (ds != null && ds.Tables.Count > 0) { MassMailSendInfo objMail = DataSourceHelper.FillObject <MassMailSendInfo>(ds.Tables[0].CreateDataReader()); List <UserInfo> lstUsers = new List <UserInfo>(); lstUsers = DataSourceHelper.FillCollection <UserInfo>(ds.Tables[1]); objMail.MailToUsers = lstUsers; return(objMail); } else { return(null); } } catch (Exception ex) { throw ex; } }
internal MassMailEditInfo GetMassMailDetailForEdit(long massmailID) { List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >(); Param.Add(new KeyValuePair <string, object>("@MassMailID", massmailID)); SQLHandler objHandler = new SQLHandler(); try { DataSet ds = objHandler.ExecuteAsDataSet("[dbo].[usp_SCAdmin_GetMailDetailByMassMailID]", Param); if (ds != null && ds.Tables.Count > 0) { MassMailEditInfo objMail = DataSourceHelper.FillObject <MassMailEditInfo>(ds.Tables[0].CreateDataReader()); List <MassMailFilterTypeInfo> lstAdditionalUsers = new List <MassMailFilterTypeInfo>(); lstAdditionalUsers = DataSourceHelper.FillCollection <MassMailFilterTypeInfo>(ds.Tables[1]); objMail.AdditionalUsers = lstAdditionalUsers; return(objMail); } else { return(null); } } catch (Exception ex) { return(null); //base.ProcessExcetion(ex); } }
public static DataSet GetCatalogPricingRule(Int32 catalogPriceRuleID, AspxCommonInfo aspxCommonObj) { SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> paramList = CommonParmBuilder.GetParamSPUC(aspxCommonObj); paramList.Add(new KeyValuePair<string, object>("@CatalogPriceRuleID", catalogPriceRuleID)); DataSet ds = sqlHandler.ExecuteAsDataSet("usp_Aspx_GetPricingRuleInfoByID", paramList); return ds; }
public static DataSet GetCartPriceRule(Int32 cartPriceRuleID, AspxCommonInfo aspxCommonObj) { SQLHandler sqlHandler = new SQLHandler(); List <KeyValuePair <string, object> > paramList = CommonParmBuilder.GetParamPUC(aspxCommonObj); paramList.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleID)); DataSet ds = sqlHandler.ExecuteAsDataSet("[dbo].[usp_Aspx_GetCartPricingRule]", paramList); return(ds); }
public DataSet GetCatalogPricingRule(Int32 catalogPriceRuleID, Int32 storeID, Int32 portalID, string userName, string culture) { SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>(); paramList.Add(new KeyValuePair<string, object>("@CatalogPriceRuleID", catalogPriceRuleID)); paramList.Add(new KeyValuePair<string, object>("@StoreID", storeID)); paramList.Add(new KeyValuePair<string, object>("@PortalID", portalID)); paramList.Add(new KeyValuePair<string, object>("@Username", userName)); paramList.Add(new KeyValuePair<string, object>("@CultureName", culture)); DataSet ds = sqlHandler.ExecuteAsDataSet("usp_Aspx_GetPricingRuleInfoByID", paramList); return ds; }
public DataTable GetPriceRuleConditions(Int32 cartPriceRuleID, Int32 portalID, string userName) { SQLHandler sqlHandler = new SQLHandler(); List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >(); paramList.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleID)); paramList.Add(new KeyValuePair <string, object>("@PortalID", portalID)); paramList.Add(new KeyValuePair <string, object>("@Username", userName)); DataSet ds = sqlHandler.ExecuteAsDataSet("[dbo].[usp_Aspx_GetPricingRuleConditions]", paramList); return(ds.Tables[0]); }
public DataSet GetCatalogPricingRule(Int32 catalogPriceRuleID, AspxCommonInfo aspxCommonObj) { SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>(); paramList.Add(new KeyValuePair<string, object>("@CatalogPriceRuleID", catalogPriceRuleID)); paramList.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID)); paramList.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID)); paramList.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName)); paramList.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName)); DataSet ds = sqlHandler.ExecuteAsDataSet("usp_Aspx_GetPricingRuleInfoByID", paramList); return ds; }
public DataSet GetBrandSettingAndSlider(AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > ParaMeter = CommonParmBuilder.GetParamSPC(aspxCommonObj); SQLHandler sqLH = new SQLHandler(); return(sqLH.ExecuteAsDataSet("usp_Aspx_BrandSettingAndSlider", ParaMeter)); } catch (Exception e) { throw e; } }
public DataSet GetBrandSettingAndSlider(AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> ParaMeter = CommonParmBuilder.GetParamSPC(aspxCommonObj); SQLHandler sqLH = new SQLHandler(); return sqLH.ExecuteAsDataSet("usp_Aspx_BrandSettingAndSlider", ParaMeter); } catch (Exception e) { throw e; } }
public DataSet GetCartPricingRule(Int32 cartPriceRuleID, Int32 portalID, string userName, string culture) { SQLHandler sqlHandler = new SQLHandler(); List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >(); paramList.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleID)); paramList.Add(new KeyValuePair <string, object>("@PortalID", portalID)); paramList.Add(new KeyValuePair <string, object>("@Username", userName)); paramList.Add(new KeyValuePair <string, object>("@CultureName", culture)); DataSet ds = sqlHandler.ExecuteAsDataSet("usp_Aspx_GetCartPricingRuleInfoByID", paramList); return(ds); }
public DataSet GetLatestItemsByCount(AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); return sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_GetLatestItemInfo]", parameterCollection); } catch (Exception e) { throw e; } }
public DataSet GetLatestItemsByCount(AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); return(sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_GetLatestItemInfo]", parameterCollection)); } catch (Exception e) { throw e; } }
public DataSet GetCartPriceRule(Int32 cartPriceRuleID, AspxCommonInfo aspxCommonObj) { SQLHandler sqlHandler = new SQLHandler(); List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >(); paramList.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleID)); paramList.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID)); paramList.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName)); paramList.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName)); DataSet ds = sqlHandler.ExecuteAsDataSet("[dbo].[usp_Aspx_GetCartPricingRule]", paramList); return(ds); }
public static DataSet GetCartDetailsDataSet(AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); DataSet lstCart = sqlH.ExecuteAsDataSet("usp_Aspx_GetCartDetails", parameter); return(lstCart); } catch (Exception e) { throw e; } }
/// <summary> /// Connects to database and search by search word. /// </summary> /// <param name="offset">Paging offset.</param> /// <param name="limit">Paging limit.</param> /// <param name="Searchword">Search word.</param> /// <param name="SearchBy">Searching user's name.</param> /// <param name="CultureName">Culture name.</param> /// <param name="IsUseFriendlyUrls">Set true if the url is user friendly.</param> /// <param name="PortalID">Portal ID.</param> /// <returns>List of Search contents.</returns> public List <SageFrameSearchInfo> SageSearchBySearchWord(int offset, int limit, string Searchword, string SearchBy, string CultureName, bool IsUseFriendlyUrls, int PortalID) { try { List <SageFrameSearchInfo> searchList = new List <SageFrameSearchInfo>(); string spName = "[dbo].[sp_SageFrameFreeSearch11]"; List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >(); ParaMeterCollection.Add(new KeyValuePair <string, object>("@searchtxt", Searchword)); ParaMeterCollection.Add(new KeyValuePair <string, object>("@offset", offset)); ParaMeterCollection.Add(new KeyValuePair <string, object>("@limit", limit)); SQLHandler sagesql = new SQLHandler(); DataSet ds = new DataSet(); ds = sagesql.ExecuteAsDataSet(spName, ParaMeterCollection); if (ds != null && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0) { int rowCount = Convert.ToInt32(ds.Tables[0].Rows[0]["RowTotal"]); if (rowCount <= 0) { rowCount = ds.Tables[0].Rows.Count; } foreach (DataRow row in ds.Tables[0].Rows) { SageFrameSearchInfo obj = new SageFrameSearchInfo(); obj.HTMLContent = row["HTMLContent"].ToString(); obj.TabPath = row["TabPath"].ToString(); obj.URL = row["URL"].ToString(); obj.RowTotal = rowCount; obj.PageName = string.Empty; obj.SearchWord = Searchword; obj.UpdatedContentOn = string.Empty; obj.UserModuleTitle = string.Empty; searchList.Add(obj); } } return(searchList); } catch (Exception e) { throw e; } }
/// <summary> /// Connects to database and get all available portals. /// </summary> /// <returns>DataTable</returns> public DataTable GetAllPortals() { try { DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_GetAllPortals"); DataTable dt = ds.Tables[0]; return(dt); } catch (Exception e) { throw e; } }
/// <summary> /// Connects to database and returns feedback of the item /// </summary> /// <param name="PortalID">portalID</param> /// <param name="CultureName">Current culture name</param> /// <returns>Feedback item</returns> public DataTable FeedbackItemGet(int PortalID, string CultureName) { try { SQLHandler SQLH = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID)); ParamCollInput.Add(new KeyValuePair <string, object>("@CultureName", CultureName)); return(SQLH.ExecuteAsDataSet("[dbo].[sp_FeedbackItemGet]", ParamCollInput).Tables[0]); } catch (Exception ex) { throw ex; } }
public static DataSet GetCategoryDetailInfoForFilter(string categorykey, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@categorykey", categorykey)); SQLHandler sqlH = new SQLHandler(); DataSet lstCatDet = sqlH.ExecuteAsDataSet("usp_Aspx_GetAllSubCategoryForFilter", parameterCollection); return(lstCatDet); } catch (Exception ex) { throw ex; } }
public DataTable GetAllPortals() { try { DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_GetAllPortals"); DataTable dt = ds.Tables[0]; return dt; } catch (Exception e) { throw e; } }
public DataSet GetSettingsValueByKeys(string keys) { try { List <KeyValuePair <string, string> > ParaMeterCollection = new List <KeyValuePair <string, string> >(); ParaMeterCollection.Add(new KeyValuePair <string, string>("@Keys", keys)); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("[usp_Webbuilder_Settings_GetByKeys]", ParaMeterCollection); return(ds); } catch { throw; } }
public DataSet MakeHtmlDataSet(string HtmlUserModuleID) { SQLHandler sagesql = new SQLHandler(); List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@UserModuleID", HtmlUserModuleID)); DataSet objDataSet = new DataSet(); try { objDataSet = sagesql.ExecuteAsDataSet("usp_Template_ExtractModules", ParamCollInput); } catch (Exception) { throw; } return objDataSet; }
/// <summary> /// Connects to database and returns recovery password 's token value. /// </summary> /// <param name="Username">User's name.</param> /// <param name="PortalID">Portal ID.</param> /// <returns>Returns token value. </returns> public static DataTable GetPasswordRecoveryTokenValue(string Username, int PortalID) { try { SQLHandler SQLH = 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)); DataSet ds = SQLH.ExecuteAsDataSet("[dbo].[sp_GetPasswordRecoveryTokenValue]", ParamCollInput); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } }
public DataSet GetAllCachaleSettings() { try { //List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>(); //ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID)); //ParaMeterCollection.Add(new KeyValuePair<string, string>("@SettingType", SettingType)); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("[usp_Webbuilder_Settings_Getall]"); return(ds); } catch { throw; } }
internal DataSet GenerateInsertScriptForPages(string pageNames) { DataSet script = new DataSet(); try { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >(); param.Add(new KeyValuePair <string, object>("@PageNames", pageNames)); SQLHandler sagesql = new SQLHandler(); script = sagesql.ExecuteAsDataSet("[dbo].[usp_Webbuilder_GetSystemTableByPageName]", param); } catch { throw; } return(script); }
public DataSet GetSettingsByPortalAndSettingType(string PortalID, string Username) { try { List <KeyValuePair <string, string> > ParaMeterCollection = new List <KeyValuePair <string, string> >(); ParaMeterCollection.Add(new KeyValuePair <string, string>("@PortalID", PortalID)); ParaMeterCollection.Add(new KeyValuePair <string, string>("@Username", Username)); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_FeedbackGetList", ParaMeterCollection); return(ds); } catch (Exception e) { throw e; } }
/// <summary> /// Connects to database and returns application settings. /// </summary> /// <param name="portalID">portalID</param> /// <param name="settingType">Setting type.</param> /// <returns>DataSet</returns> public DataSet GetAllSettings(string portalID, string settingType) { try { List <KeyValuePair <string, string> > ParaMeterCollection = new List <KeyValuePair <string, string> >(); ParaMeterCollection.Add(new KeyValuePair <string, string>("@PortalID", portalID)); ParaMeterCollection.Add(new KeyValuePair <string, string>("@SettingType", settingType)); DataSet dataset = new DataSet(); SQLHandler sagesql = new SQLHandler(); dataset = sagesql.ExecuteAsDataSet("dbo.usp_GetAllSettings", ParaMeterCollection); return(dataset); } catch (Exception e) { throw e; } }
private DataSet GetSettingsByPortalAndSettingType(string PortalID, string SettingType) { try { List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>(); ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@SettingType", SettingType)); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_GetAllSettings", ParaMeterCollection); return ds; } catch (Exception e) { throw e; } }
public DataSet GetExtensionSettings(string ModuleID) { try { List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>(); ParaMeterCollection.Add(new KeyValuePair<string, string>("@ModuleID", ModuleID)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", GetPortalID.ToString())); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_GetExtensionSetting", ParaMeterCollection); return ds; } catch (Exception e) { throw e; } }
/// <summary> /// Connects to database and returns searching procedure list. /// </summary> /// <param name="PortalID">Portal ID.</param> /// <returns>DataTable containing list of procedures.</returns> public DataTable ListSageSerchProcedures(int PortalID) { try { List <KeyValuePair <string, string> > ParaMeterCollection = new List <KeyValuePair <string, string> >(); ParaMeterCollection.Add(new KeyValuePair <string, string>("@PortalID", PortalID.ToString())); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_SageFrameSearchProcedureList", ParaMeterCollection); return(ds.Tables[0]); } catch (Exception e) { throw e; } }
/// <summary> /// Connects to database and get settings based on PortalID and SettingType. /// </summary> /// <param name="PortalID">PortalID</param> /// <param name="SettingType">Setting type.</param> /// <returns>DataSet</returns> private DataSet GetSettingsByPortalAndSettingType(string PortalID, string SettingType) { try { List <KeyValuePair <string, string> > ParaMeterCollection = new List <KeyValuePair <string, string> >(); ParaMeterCollection.Add(new KeyValuePair <string, string>("@PortalID", PortalID)); ParaMeterCollection.Add(new KeyValuePair <string, string>("@SettingType", SettingType)); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_GetAllSettings", ParaMeterCollection); return(ds); } catch (Exception e) { throw e; } }
/// <summary> /// Get Module Control Types /// </summary> /// <param name="ModuleID">ModuleID</param> /// <returns>Module Information, Control Types, Module Package Detail</returns> public DataSet GetExtensionSettings(string ModuleID) { try { List <KeyValuePair <string, string> > ParaMeterCollection = new List <KeyValuePair <string, string> >(); ParaMeterCollection.Add(new KeyValuePair <string, string>("@ModuleID", ModuleID)); ParaMeterCollection.Add(new KeyValuePair <string, string>("@PortalID", GetPortalID.ToString())); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_GetExtensionSetting", ParaMeterCollection); return(ds); } catch (Exception e) { throw e; } }
public DataSet GetStoreSettingsByPortal(int storeID, int portalID, string cultureName) { try { 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)); parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", cultureName)); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("usp_Aspx_GetStoreSettingForCache", parameterCollection); return(ds); } catch (Exception e) { throw e; } }
public DataSet MakeHtmlDataSet(string HtmlUserModuleID) { SQLHandler sagesql = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@UserModuleID", HtmlUserModuleID)); DataSet objDataSet = new DataSet(); try { objDataSet = sagesql.ExecuteAsDataSet("usp_Template_ExtractModules", ParamCollInput); } catch (Exception) { throw; } return(objDataSet); }
public DataSet GetStoreSettingsByPortal(int storeID,int portalID, string cultureName) { try { 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)); parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", cultureName)); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("usp_Aspx_GetStoreSettingForCache", parameterCollection); return ds; } catch (Exception e) { throw e; } }
private void BindGrid(string listName, string parentKey) { try { //var listDetail = dbList.sp_GetListEntriesByNameParentKeyAndPortalID(listName, parentKey, -1,GetCurrentCultureName);//GetPortalID; 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", parentKey)); ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", -1)); ParaMeterCollection.Add(new KeyValuePair <string, object>("@Culture", GetCurrentCultureName)); SQLHandler sqlH = new SQLHandler(); DataSet ds = sqlH.ExecuteAsDataSet("dbo.sp_GetListEntriesByNameParentKeyAndPortalID", ParaMeterCollection); if (ds != null && ds.Tables != null && ds.Tables.Count > 0) { DataTable dtList = ds.Tables[0]; //LToDCon = new CommonFunction(); //dtList = LToDCon.LINQToDataTable(listDetail); gdvSubList.DataSource = dtList; gdvSubList.DataBind(); ViewState["LISTTABLE"] = dtList; ViewState["LIST"] = dtList.Rows.Count; if (gdvSubList.Rows.Count > 0) { lblEntry.Text = dtList.Rows.Count + " " + GetSageMessage("ListSettings", "Entries"); if (gdvSubList.PageIndex == 0) { gdvSubList.Rows[0].FindControl("imgListUp").Visible = false; } if (gdvSubList.PageIndex == (gdvSubList.PageCount - 1)) { gdvSubList.Rows[gdvSubList.Rows.Count - 1].FindControl("imgListDown").Visible = false; } } } } catch (Exception ex) { ProcessException(ex); } }
public static List<Countries> GetCountryList() { List<Countries> lstCountries = new List<Countries>(); DataSet ds = new DataSet(); try { SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("sp_GetCountryList"); } catch (Exception) { throw; } foreach (DataRow row in ds.Tables[0].Rows) { lstCountries.Add(new Countries("Modules/Language/flags/" + row["Value"].ToString().ToLower() + ".png", row["Text"].ToString(), row["Culture"].ToString())); } return lstCountries; }
public DataSet GetSettingsByPortalAndSettingType(string usermoduleID, string QuestionID, string PortalID, string Username) { try { List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>(); ParaMeterCollection.Add(new KeyValuePair<string, string>("@usermoduleID", usermoduleID)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@QuestionID", QuestionID)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@Username", Username)); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_PollAnswerList", ParaMeterCollection); return ds; } catch (Exception e) { throw e; } }
public static List<SubscriptionInfo> NotificationUsersGetAll(AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj); SQLHandler sqLH = new SQLHandler(); DataSet ds = sqLH.ExecuteAsDataSet("[dbo].[usp_Aspx_NotificationUsersGetAll]",parameterCollection); List<SubscriptionInfo> SubscriptionDetails = new List<SubscriptionInfo>(); if (ds.Tables.Count > 0) { SubscriptionDetails = DataSourceHelper.FillCollection<SubscriptionInfo>(ds.Tables[0]); } return SubscriptionDetails; } catch (Exception e) { throw e; } }
public DataSet GetPageSettings(string controlType, string pageID) { 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>("@PageID", pageID)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", GetPortalID.ToString())); ParaMeterCollection.Add(new KeyValuePair<string, string>("@UserName", GetUsername)); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_GetPageSetting", ParaMeterCollection); return ds; } catch (Exception e) { throw e; } }
/// <summary> /// Connects to database and returns recovery password 's token value. /// </summary> /// <param name="Username">User's name.</param> /// <param name="PortalID">Portal ID.</param> /// <returns>Returns token value. </returns> public static DataTable GetPasswordRecoveryTokenValue(string Username, int PortalID) { try { SQLHandler SQLH = 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)); DataSet ds = SQLH.ExecuteAsDataSet("[dbo].[sp_GetPasswordRecoveryTokenValue]", ParamCollInput); return ds.Tables[0]; } catch (Exception ex) { throw ex; } }
public DataSet GetMenuDetail(int portalID, string menuUserModuleID) { SQLHandler sagesql = new SQLHandler(); List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@portalID", portalID)); ParamCollInput.Add(new KeyValuePair<string, object>("@userModuleID", menuUserModuleID)); DataSet objDataSet = new DataSet(); try { objDataSet = sagesql.ExecuteAsDataSet("usp_template_GetMenu", ParamCollInput); } catch (Exception) { throw; } return objDataSet; }
public static DataSet GetWishItemList(AspxCommonInfo aspxCommonObj) { List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); return sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_GetWishListItem]", parameterCollection); }
public static DataSet GetSpecialItemsandSettingDataSet(AspxCommonInfo aspxCommonObj) { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); SQLHandler SQLH = new SQLHandler(); return SQLH.ExecuteAsDataSet("[dbo].[usp_Aspx_GetSpecialItemsInfo]", parameter); }
private void BindGrid(string listName,string parentKey) { try { //var listDetail = dbList.sp_GetListEntriesByNameParentKeyAndPortalID(listName, parentKey, -1,GetCurrentCultureName);//GetPortalID; 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", parentKey)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", -1)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@Culture", GetCurrentCultureName)); SQLHandler sqlH = new SQLHandler(); DataSet ds = sqlH.ExecuteAsDataSet("dbo.sp_GetListEntriesByNameParentKeyAndPortalID", ParaMeterCollection); if (ds != null && ds.Tables != null && ds.Tables.Count > 0) { DataTable dtList = ds.Tables[0]; //LToDCon = new CommonFunction(); //dtList = LToDCon.LINQToDataTable(listDetail); gdvSubList.DataSource = dtList; gdvSubList.DataBind(); ViewState["LISTTABLE"] = dtList; ViewState["LIST"] = dtList.Rows.Count; if (gdvSubList.Rows.Count > 0) { lblEntry.Text = dtList.Rows.Count + " " + GetSageMessage("ListSettings", "Entries"); if (gdvSubList.PageIndex == 0) { gdvSubList.Rows[0].FindControl("imgListUp").Visible = false; } if (gdvSubList.PageIndex == (gdvSubList.PageCount - 1)) { gdvSubList.Rows[gdvSubList.Rows.Count - 1].FindControl("imgListDown").Visible = false; } } } } catch (Exception ex) { ProcessException(ex); } }
public static DataSet GetCategoryDetailInfoForFilter(string categorykey, AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@categorykey", categorykey)); SQLHandler sqlH = new SQLHandler(); DataSet lstCatDet = sqlH.ExecuteAsDataSet("usp_Aspx_GetAllSubCategoryForFilter", parameterCollection); return lstCatDet; } catch (Exception ex) { throw ex; } }
/// <summary> /// Connect to database and returns the 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 entries</returns> public DataSet GetListInfoInDataSet(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(); DataSet ds = new DataSet(); ds = sqlH.ExecuteAsDataSet("dbo.sp_GetListEntriesByNameParentKeyAndPortalID", ParaMeterCollection); return ds; } catch (Exception e) { throw e; } }
public static DataSet GetItemDetailsInfo(AspxCommonInfo aspxCommonObj,string itemSKU,string userIP, string countryName) { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamNoCID(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@itemSKU", itemSKU)); parameterCollection.Add(new KeyValuePair<string, object>("@UserIP", userIP)); parameterCollection.Add(new KeyValuePair<string, object>("@ViewedFromcountry", countryName)); return sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_GetItemDetailsInfo]", parameterCollection); }
/// <summary> /// Connects to database and returns application settings. /// </summary> /// <param name="portalID">portalID</param> /// <param name="settingType">Setting type.</param> /// <returns>DataSet</returns> public DataSet GetAllSettings(string portalID, string settingType) { try { List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>(); ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", portalID)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@SettingType", settingType)); DataSet dataset = new DataSet(); SQLHandler sagesql = new SQLHandler(); dataset = sagesql.ExecuteAsDataSet("dbo.usp_GetAllSettings", ParaMeterCollection); return dataset; } catch (Exception e) { throw e; } }
public static DataSet GetCartDetailsDataSet(AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetFullParam(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); DataSet lstCart = sqlH.ExecuteAsDataSet("usp_Aspx_GetCartDetails", parameter); return lstCart; } catch (Exception e) { throw e; } }
public DataSet SageSearchBySearchWord(string Searchword, string SearchBy, string CultureName, bool IsUseFriendlyUrls, int PortalID) { try { List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>(); ParaMeterCollection.Add(new KeyValuePair<string, string>("@Searchword", Searchword)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@CultureName", CultureName)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@IsUseFriendlyUrls", IsUseFriendlyUrls.ToString())); ParaMeterCollection.Add(new KeyValuePair<string, string>("@SearchBy", SearchBy)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID.ToString())); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_SageSearchBySearchKey", ParaMeterCollection); return ds; } catch (Exception e) { throw e; } }
public DataTable ListSageSerchProcedures(int PortalID) { try { List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>(); ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID.ToString())); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_SageFrameSearchProcedureList", ParaMeterCollection); return ds.Tables[0]; } catch (Exception e) { throw e; } }
public SageFrameSearchSettingInfo LoadSearchSettings(int PortalID, string CultureName) { try { List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>(); ParaMeterCollection.Add(new KeyValuePair<string, string>("@CultureName", CultureName)); ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID.ToString())); DataSet ds = new DataSet(); SQLHandler sagesql = new SQLHandler(); ds = sagesql.ExecuteAsDataSet("dbo.sp_SageFrameSearchSettingValueGet", ParaMeterCollection); SageFrameSearchSettingInfo objSearchSettingInfo = new SageFrameSearchSettingInfo(); if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { string strKey = dt.Rows[i]["SettingKey"].ToString(); switch (strKey) { case "SearchButtonType": if (dt.Rows[i]["SettingValue"].ToString() != string.Empty) { objSearchSettingInfo.SearchButtonType = Int32.Parse(dt.Rows[i]["SettingValue"].ToString()); } break; case "SearchButtonText": objSearchSettingInfo.SearchButtonText = dt.Rows[i]["SettingValue"].ToString(); break; case "SearchButtonImage": objSearchSettingInfo.SearchButtonImage = dt.Rows[i]["SettingValue"].ToString(); break; case "SearchResultPerPage": if (dt.Rows[i]["SettingValue"].ToString() != string.Empty) { objSearchSettingInfo.SearchResultPerPage = Int32.Parse(dt.Rows[i]["SettingValue"].ToString()); } break; case "SearchResultPageName": objSearchSettingInfo.SearchResultPageName = dt.Rows[i]["SettingValue"].ToString(); break; case "MaxSearchChracterAllowedWithSpace": if (dt.Rows[i]["SettingValue"].ToString() != string.Empty) { objSearchSettingInfo.MaxSearchChracterAllowedWithSpace = Int32.Parse(dt.Rows[i]["SettingValue"].ToString()); } break; } } } return objSearchSettingInfo; } catch (Exception e) { throw e; } }
/// <summary> /// Connects to database and returns feedback of the item /// </summary> /// <param name="PortalID">portalID</param> /// <param name="CultureName">Current culture name</param> /// <returns>Feedback item</returns> public DataTable FeedbackItemGet(int PortalID, string CultureName) { try { SQLHandler SQLH = new SQLHandler(); List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); ParamCollInput.Add(new KeyValuePair<string, object>("@CultureName", CultureName)); return SQLH.ExecuteAsDataSet("[dbo].[sp_FeedbackItemGet]", ParamCollInput).Tables[0]; } catch (Exception ex) { throw ex; } }
public DataTable GetPriceRuleConditions(Int32 cartPriceRuleID, Int32 portalID, string userName) { SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>(); paramList.Add(new KeyValuePair<string, object>("@CartPriceRuleID", cartPriceRuleID)); paramList.Add(new KeyValuePair<string, object>("@PortalID", portalID)); paramList.Add(new KeyValuePair<string, object>("@Username", userName)); DataSet ds = sqlHandler.ExecuteAsDataSet("[dbo].[usp_Aspx_GetPricingRuleConditions]", paramList); return ds.Tables[0]; }