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