private void LoadSettingtoControl()
{
try
{
ddlSubscriptionType.Items.Clear();
BindSubscriptionTypeList();
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UserModuleID", usermoduleIDControl));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", GetPortalID));
SQLHandler objSql = new SQLHandler();
NewsLetterSettingsInfo newsLetterSettingObj = objSql.ExecuteAsObject<NewsLetterSettingsInfo>("dbo.sp_NewsLetterSettingsGetAll", ParaMeterCollection);
if (newsLetterSettingObj != null)
{
ddlSubscriptionType.SelectedIndex = ddlSubscriptionType.Items.IndexOf(ddlSubscriptionType.Items.FindByValue(newsLetterSettingObj.SubscriptionType.ToString()));
txtSubscriptionModuleTitle.Text = newsLetterSettingObj.SubscriptionModuleTitle.ToString();
txtSubscriptionHelpText.Text = newsLetterSettingObj.SubscriptionHelpText.ToString();
txtTextBoxWaterMark.Text = newsLetterSettingObj.TextBoxWaterMarkText.ToString()!=""?newsLetterSettingObj.TextBoxWaterMarkText.ToString():"Email Address Required";
txtSubmitButtonText.Text = newsLetterSettingObj.SubmitButtonText.ToString();
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public TickerInfo getTickerObject(int tickerID)
{
List<KeyValuePair<string, object>> Parameter = new List<KeyValuePair<string, object>>();
Parameter.Add(new KeyValuePair<string, object>("@tickerID", tickerID));
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteAsObject<TickerInfo>("[usp_TickerGetByTickerID]", Parameter);
}
/// <summary>
///Connect to database and obtain active template.
/// </summary>
/// <param name="PortalID">PortalID</param>
/// <returns>Object of TemplateInfo class.</returns>
public static TemplateInfo GetActiveTemplate(int PortalID)
{
SQLHandler sagesql = new SQLHandler();
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
return (sagesql.ExecuteAsObject<TemplateInfo>("usp_sftemplate_GetActiveTemplate",ParaMeterCollection));
}
private void GetNewsLetterSettings()
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UserModuleID", usermoduleIDControl));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", GetPortalID));
SQLHandler objSql = new SQLHandler();
newsLetterSettingObj = objSql.ExecuteAsObject<NewsLetterSettingsInfo>("dbo.sp_NewsLetterSettingsGetAll", ParaMeterCollection);
lblHelpText.Text = "<p>" + newsLetterSettingObj.SubscriptionHelpText.ToString() + "</p>";
txtWatermarkExtender.WatermarkText = newsLetterSettingObj.TextBoxWaterMarkText.ToString() != "" ? newsLetterSettingObj.TextBoxWaterMarkText.ToString() : "Email Address Required";
btnSubscribe.Text = newsLetterSettingObj.SubmitButtonText.ToString();
btnSubscribe.ToolTip = newsLetterSettingObj.SubmitButtonText.ToString();
}
public HeaderItemsCount GetHeaderItemsCount(AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetFullParam(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteAsObject<HeaderItemsCount>("[usp_Aspx_GetHeaderItemsCount]", parameter);
}
catch (Exception e)
{
throw e;
}
}
internal DashboardLinkInfo GetLinkByID(int LinkID)
{
try
{
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("@LinkID", LinkID));
SQLHandler sagesql = new SQLHandler();
return(sagesql.ExecuteAsObject <DashboardLinkInfo>("[dbo].[usp_DashboardLink_GetByID]", param));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and returns Payment Gateways and their setting values.
/// </summary>
/// <param name="portalID">portalID</param>
/// <returns>PaymentGatewayInfo object containg settingkey and values of Payment Gateway.</returns>
public PaymentGatewayInfo GetPaymentGatewaysSetting(int portalID)
{
try
{
List<KeyValuePair<string, object>> Param = new List<KeyValuePair<string, object>>();
Param.Add(new KeyValuePair<string, object>("@PortalID", portalID));
SQLHandler sqlh = new SQLHandler();
return sqlh.ExecuteAsObject<PaymentGatewayInfo>("usp_PaymentGatewaySetting_GetSettingValue", Param);
}
catch
{
throw;
}
}
/// <summary>
/// Connects to database and returns Payment Gateways and their setting values.
/// </summary>
/// <param name="portalID">portalID</param>
/// <returns>PaymentGatewayInfo object containg settingkey and values of Payment Gateway.</returns>
public PaymentGatewayInfo GetPaymentGatewaysSetting(int portalID)
{
try
{
List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >();
Param.Add(new KeyValuePair <string, object>("@PortalID", portalID));
SQLHandler sqlh = new SQLHandler();
return(sqlh.ExecuteAsObject <PaymentGatewayInfo>("usp_PaymentGatewaySetting_GetSettingValue", Param));
}
catch
{
throw;
}
}
public string GetFeedbackSettingValueList(int PortalID)
{
try
{
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
return(SQLH.ExecuteAsObject <FeedbackSettingInfo>("[dbo].[sp_FeedbackSettingValueList]", ParamCollInput).SettingValue);
}
catch (Exception ex)
{
throw ex;
}
}
private void GetNewsLetterSettings()
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@UserModuleID", usermoduleIDControl));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", GetPortalID));
SQLHandler objSql = new SQLHandler();
newsLetterSettingObj = objSql.ExecuteAsObject <NewsLetterSettingsInfo>("dbo.sp_NewsLetterSettingsGetAll", ParaMeterCollection);
lblHelpText.Text = "<p>" + newsLetterSettingObj.SubscriptionHelpText.ToString() + "</p>";
txtWatermarkExtender.WatermarkText = newsLetterSettingObj.TextBoxWaterMarkText.ToString() != "" ? newsLetterSettingObj.TextBoxWaterMarkText.ToString() : "Email Address Required";
btnSubscribe.Text = newsLetterSettingObj.SubmitButtonText.ToString();
btnSubscribe.ToolTip = newsLetterSettingObj.SubmitButtonText.ToString();
}
//While downloading template zip
public PresetKeyValue GetPageModules()
{
string sp = "[dbo].[usp_template_getPageModuleRel]";
SQLHandler sagesql = new SQLHandler();
try
{
return(sagesql.ExecuteAsObject <PresetKeyValue>(sp));
}
catch (Exception)
{
throw;
}
}
public static NotificationGetAllInfo NotificationGetAll(AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
NotificationGetAllInfo listInfo = sqlH.ExecuteAsObject<NotificationGetAllInfo>("[dbo].[usp_Aspx_NotificationGetAll]", parameterCollection);
return listInfo;
}
catch (Exception e)
{
throw e;
}
}
public SageBannerInfo GetBannerByID(int BannerID)
{
try
{
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("@BannerID", BannerID));
SQLHandler sagesql = new SQLHandler();
return(sagesql.ExecuteAsObject <SageBannerInfo>("[dbo].[usp_SageBannerGetByBannerID]", param));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and returns SageBannerInfo object for given ImageID.
/// </summary>
/// <param name="ImageID">ImageID</param>
/// <returns>Object of SageBannerInfo class containing ImageID,HTMLBodyText and NavigationImage.</returns>
public SageBannerInfo GetHTMLContentForEditByID(int ImageID)
{
try
{
List <KeyValuePair <string, object> > para = new List <KeyValuePair <string, object> >();
para.Add(new KeyValuePair <string, object>("@ImageID", ImageID));
SQLHandler SQLH = new SQLHandler();
return(SQLH.ExecuteAsObject <SageBannerInfo>("[dbo].[usp_SageBannerGetHTMLContentForEditByID]", para));
}
catch (Exception ex)
{
throw ex;
}
}
public static NotificationGetAllInfo NotificationGetAll(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
NotificationGetAllInfo listInfo = sqlH.ExecuteAsObject <NotificationGetAllInfo>("[dbo].[usp_Aspx_NotificationGetAll]", parameterCollection);
return(listInfo);
}
catch (Exception e)
{
throw e;
}
}
internal SocialFeedSettingInfo GetSocialFeedSettingInfo()
{
SQLHandler objHandler = new SQLHandler();
try
{
SocialFeedSettingInfo objSetting = objHandler.ExecuteAsObject <SocialFeedSettingInfo>("[dbo].[usp_SocailFeed_GetSocialFeedSettingInfo]");
return(objSetting);
}
catch (Exception ex)
{
throw ex;
}
}
public CouponVerificationInfo VerifyUserCoupon(decimal totalCost, string couponCode, AspxCommonInfo aspxCommonObj, int appliedCount)
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@totalCost", totalCost));
parameter.Add(new KeyValuePair <string, object>("@CouponCode", couponCode));
parameter.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair <string, object>("@AppliedCount", appliedCount));
SQLHandler sqlH = new SQLHandler();
return(sqlH.ExecuteAsObject <CouponVerificationInfo>("[usp_Aspx_VerifyCouponCode]", parameter));
}
public static HeavyDiscountSettingInfo GetHeavyDiscountSetting(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
SQLHandler sqlHandle = new SQLHandler();
HeavyDiscountSettingInfo objHDSetting = sqlHandle.ExecuteAsObject <HeavyDiscountSettingInfo>("usp_Aspx_GetHeavyDiscountSettings", parameterCollection);
return(objHDSetting);
}
catch (Exception e)
{
throw e;
}
}
public ItemSEOInfo GetSEOSettingsBySKU(string itemSKU, int storeID, int portalID, string userName,
string cultureName)
{
List <KeyValuePair <string, object> > ParaMeter = new List <KeyValuePair <string, object> >();
ParaMeter.Add(new KeyValuePair <string, object>("@itemSKU", itemSKU));
ParaMeter.Add(new KeyValuePair <string, object>("@StoreID", storeID));
ParaMeter.Add(new KeyValuePair <string, object>("@PortalID", portalID));
ParaMeter.Add(new KeyValuePair <string, object>("@UserName", userName));
ParaMeter.Add(new KeyValuePair <string, object>("@CultureName", cultureName));
SQLHandler sqlH = new SQLHandler();
return(sqlH.ExecuteAsObject <ItemSEOInfo>("usp_Aspx_ItemsSEODetailsBySKU", ParaMeter));
}
/// <summary>
/// Connects to database and returns module control.
/// </summary>
/// <param name="ModuleControlID">Module control ID.</param>
/// <returns>Module control.</returns>
public ModuleEntities ModuleControlsGetByModuleControlID(int ModuleControlID)
{
try
{
string sp = "[dbo].[sp_ModuleControlsGetByModuleControlID]";
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@ModuleControlID", ModuleControlID));
return(SQLH.ExecuteAsObject <ModuleEntities>(sp, ParamCollInput));
}
catch (Exception)
{
throw;
}
}
public static OrderStatusListInfo GetOrderStatusDetailByOrderStatusID(AspxCommonInfo aspxCommonObj,int OrderStatusID)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@OrderStatusID", OrderStatusID));
SQLHandler sqlH = new SQLHandler();
OrderStatusListInfo lstOrderStat = sqlH.ExecuteAsObject<OrderStatusListInfo>("[dbo].[usp_Aspx_GetOrderStatusDetailByOrderStatusID]", parameter);
return lstOrderStat;
}
catch (Exception e)
{
throw e;
}
}
public static HeaderSettingInfo GetHeaderSetting(AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
SQLHandler sqlHandle = new SQLHandler();
HeaderSettingInfo objHeadSetting = new HeaderSettingInfo();
objHeadSetting = sqlHandle.ExecuteAsObject<HeaderSettingInfo>("[usp_Aspx_GetHeaderSettings]", parameterCollection);
return objHeadSetting;
}
catch (Exception e)
{
throw e;
}
}
public RegistrationEntity GetUsersByID(int UserID)
{
try
{
SQLHandler sqlh = new SQLHandler();
List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >();
Param.Add(new KeyValuePair <string, object>("@UserID", UserID));
return(sqlh.ExecuteAsObject <RegistrationEntity>("usp_Registration_GetUsersByID", Param));
}
catch (Exception ex)
{
throw ex;
}
}
public static StoreSettingInfo GetAllStoreSettings(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
StoreSettingInfo DefaultStoreSettings;
DefaultStoreSettings = sqlH.ExecuteAsObject <StoreSettingInfo>("usp_Aspx_GetAllStoreSettings", parameter);
return(DefaultStoreSettings);
}
catch (Exception e)
{
throw e;
}
}
public SpecialItemsSettingInfo GetSpecialItemsSetting(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
SpecialItemsSettingInfo objHDSetting = new SpecialItemsSettingInfo();
objHDSetting = sqlH.ExecuteAsObject <SpecialItemsSettingInfo>("[dbo].[usp_Aspx_SpecialItemsSettingsGet]", parameterCollection);
return(objHDSetting);
}
catch (Exception e)
{
throw e;
}
}
public static ItemCommonInfo GetItemInfoFromSKU(string SKU, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@SKU", SKU));
SQLHandler sqlH = new SQLHandler();
ItemCommonInfo lstItem = sqlH.ExecuteAsObject <ItemCommonInfo>("usp_Aspx_GetItemInfoFromSKU", parameter);
return(lstItem);
}
catch (Exception e)
{
throw e;
}
}
public LatestItemSettingInfo GetLatestItemSetting(AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
LatestItemSettingInfo objLatestSetting = new LatestItemSettingInfo();
objLatestSetting = sqlH.ExecuteAsObject<LatestItemSettingInfo>("[dbo].[usp_Aspx_LatestItemSettingGet]", parameterCollection);
return objLatestSetting;
}
catch (Exception e)
{
throw e;
}
}
//public sp_PagePortalGetByCustomPrefixResult GetAllPagesLists(string prefix, System.Nullable<bool> isActive, System.Nullable<bool> isDeleted, System.Nullable<int> portalID, string username, System.Nullable<bool> isVisible, System.Nullable<bool> isRequiredPage)
//{
// try
// {
// List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
// ParaMeterCollection.Add(new KeyValuePair<string, object>("@prefix", prefix));
// ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsActive", isActive));
// ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsDeleted", isDeleted));
// ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalID));
// ParaMeterCollection.Add(new KeyValuePair<string, object>("@Username", username));
// ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsVisible", isVisible));
// ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsRequiredPage", isRequiredPage));
// SQLHandler objsql = new SQLHandler();
// return objsql.ExecuteAsObject<sp_PagePortalGetByCustomPrefixResult>("[dbo].[sp_PagePortalGetByCustomPrefix]", ParaMeterCollection);
// }
// catch (Exception e)
// {
// throw e;
// }
//}
public BannerInfo GetCorporateBannerDetailsByBannerID(int BannerID, int PortalID)
{
try
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@BannerID", BannerID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
SQLHandler objsql = new SQLHandler();
return objsql.ExecuteAsObject<BannerInfo>("[dbo].[usp_CorporateBannerGetByBannerID]", ParaMeterCollection);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Returns object of GoogleAnalyticsInfo class based on PortalID.
/// </summary>
/// <param name="PortalID">PortalID</param>
/// <returns>Object of GoogleAnalyticsInfo class</returns>
public GoogleAnalyticsInfo GetGoogleAnalyticsByPortalID(int PortalID)
{
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
SQLHandler sqlH = new SQLHandler();
GoogleAnalyticsInfo defaultList = sqlH.ExecuteAsObject <GoogleAnalyticsInfo>("dbo.sp_GoogleAnalyticsListByPortalID", ParaMeterCollection);
return(defaultList);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Connects to database and returns HTML comments by HTMLCommentID
/// </summary>
/// <param name="PortalID">portalID</param>
/// <param name="HTMLCommentID">HTMLCommentID</param>
/// <returns>Returns HTML Comments</returns>
public HTMLContentInfo HtmlCommentGetByHTMLCommentID(int PortalID, int HTMLCommentID)
{
try
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@HTMLCommentID", HTMLCommentID));
SQLHandler sq = new SQLHandler();
return sq.ExecuteAsObject<HTMLContentInfo>("dbo.sp_HtmlCommentGetByHTMLCommentID", ParaMeterCollection);
}
catch (Exception e)
{
throw e;
}
}
public BrandSettingInfo GetBrandSetting(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
BrandSettingInfo view =
sqlH.ExecuteAsObject <BrandSettingInfo>("[dbo].[usp_Aspx_BrandSettingGet]", paramCol);
return(view);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and returns the startup control's details by portalStartUpID.
/// </summary>
/// <param name="PortalStartUpID">PortalStartUpID</param>
/// <returns>Details of startup event.</returns>
public SystemEventStartUpInfo GetSystemEventStartUpDetails(int PortalStartUpID)
{
try
{
string sp = "[dbo].[usp_GetSystemEventStartUpDetails]";
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalStartUpID", PortalStartUpID));
return(SQLH.ExecuteAsObject <SystemEventStartUpInfo>(sp, ParamCollInput));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and returns search procedure name by search procedure ID.
/// </summary>
/// <param name="SageFrameSearchProcedureID">Search procedure ID.</param>
/// <returns>Search procedure.</returns>
public SageFrameSearchProcedureInfo SageFrameSearchProcedureGet(string SageFrameSearchProcedureID)
{
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@SageFrameSearchProcedureID", SageFrameSearchProcedureID));
SQLHandler sagesql = new SQLHandler();
SageFrameSearchProcedureInfo objSpIno = sagesql.ExecuteAsObject <SageFrameSearchProcedureInfo>("dbo.sp_SageFrameSearchProcedureGet", ParaMeterCollection);
return(objSpIno);
}
catch (Exception e)
{
throw e;
}
}
public YouMayAlsoLikeSettingInfo GetYouMayAlsoLikeSetting(AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
YouMayAlsoLikeSettingInfo view =
sqlH.ExecuteAsObject<YouMayAlsoLikeSettingInfo>("[dbo].[usp_Aspx_YouMayAlsoLikeSettingGet]", paramCol);
return view;
}
catch (Exception ex)
{
throw ex;
}
}
public static StoreSettingInfo GetAllStoreSettings(AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
StoreSettingInfo DefaultStoreSettings;
DefaultStoreSettings = sqlH.ExecuteAsObject<StoreSettingInfo>("usp_Aspx_GetAllStoreSettings", parameter);
return DefaultStoreSettings;
}
catch (Exception e)
{
throw e;
}
}
public static OrderStatusListInfo GetOrderStatusDetailByOrderStatusID(AspxCommonInfo aspxCommonObj, int OrderStatusID)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@OrderStatusID", OrderStatusID));
SQLHandler sqlH = new SQLHandler();
OrderStatusListInfo lstOrderStat = sqlH.ExecuteAsObject <OrderStatusListInfo>("[dbo].[usp_Aspx_GetOrderStatusDetailByOrderStatusID]", parameter);
return(lstOrderStat);
}
catch (Exception e)
{
throw e;
}
}
public HTMLContentInfo HtmlCommentGetByHTMLCommentID(int PortalID, int HTMLCommentID)
{
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@HTMLCommentID", HTMLCommentID));
SQLHandler sq = new SQLHandler();
return(sq.ExecuteAsObject <HTMLContentInfo>("dbo.sp_HtmlCommentGetByHTMLCommentID", ParaMeterCollection));
}
catch (Exception e)
{
throw e;
}
}
public static Vefification VerifyGiftCard(string giftcardCode, string pinCode, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@GiftCardCode", giftcardCode));
parameter.Add(new KeyValuePair <string, object>("@GiftCardPinCode", Encrypt(pinCode)));
SQLHandler sqlH = new SQLHandler();
Vefification objVerify = sqlH.ExecuteAsObject <Vefification>("usp_Aspx_VerifyGiftCard", parameter);
return(objVerify);
}
catch (Exception e)
{
throw e;
}
}
public static ScheduleHistory GetScheduleHistory(int ScheduleHistoryID)
{
List <KeyValuePair <string, object> > ParameterCollection = new List <KeyValuePair <string, object> >();
ParameterCollection.Add(new KeyValuePair <string, object>("@ScheduleID", ScheduleHistoryID));
try
{
SQLHandler sagesql = new SQLHandler();
return(sagesql.ExecuteAsObject <ScheduleHistory>("usp_ScheduleHistoryRetrieve", ParameterCollection));
}
catch (Exception)
{
throw;
}
}
public LogoEntity GetLogoData(int userModuleID, int portalID, string CultureCode)
{
try
{
SQLHandler sqLH = new SQLHandler();
List<KeyValuePair<string, object>> Param = new List<KeyValuePair<string, object>>();
Param.Add(new KeyValuePair<string, object>("@UserModuleID", userModuleID));
Param.Add(new KeyValuePair<string, object>("@PortalID", portalID));
Param.Add(new KeyValuePair<string, object>("@CultureCode", CultureCode));
return sqLH.ExecuteAsObject<SageFrame.Logo.LogoEntity>("usp_Logo_GetData", Param);
}
catch (Exception ex)
{
throw ex;
}
}
public HTMLContentInfo HtmlTextGetByPortalAndUserModule(int PortalID, int UsermoduleID, string CultureName)
{
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@UsermoduleID", UsermoduleID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@CultureName", CultureName));
SQLHandler Sq = new SQLHandler();
return(Sq.ExecuteAsObject <HTMLContentInfo>("dbo.sp_HtmlTextGetByPortalAndUserModule", ParaMeterCollection));
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Connects to database and obtain general snapshot.
/// </summary>
/// <param name="PortalID">PortalID.</param>
/// <param name="IsAdmin">IsAdmin.</param>
/// <returns>CountUserInfo object.</returns>
public static CountUserInfo GetGeneralSnapShot(int PortalID, bool IsAdmin)
{
SQLHandler sageSql = new SQLHandler();
try
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsAdmin", IsAdmin));
return(sageSql.ExecuteAsObject <CountUserInfo>("[dbo].[usp_DashBoardPageModuleStatistics]", ParamCollInput));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and returns quick link details for given QuickLinkItemID.
/// </summary>
/// <param name="QuickLinkItemID">Quick link item id.</param>
/// <returns>Quick link details for given quick link item id.</returns>
public static QuickLink GetQuickLinkDetails(int QuickLinkItemID)
{
string sp = "[dbo].[usp_DashboardQuickLinkGetDetails]";
SQLHandler sagesql = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@QuickLinkItemID", QuickLinkItemID));
try
{
return(sagesql.ExecuteAsObject <QuickLink>(sp, ParamCollInput));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and returns the startup control's details by portalStartUpID.
/// </summary>
/// <param name="PortalStartUpID">PortalStartUpID</param>
/// <returns>Details of startup event.</returns>
public SystemEventStartUpInfo GetSystemEventStartUpDetails(int PortalStartUpID)
{
try
{
string sp = "[dbo].[usp_GetSystemEventStartUpDetails]";
SQLHandler SQLH = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalStartUpID", PortalStartUpID));
return SQLH.ExecuteAsObject<SystemEventStartUpInfo>(sp, ParamCollInput);
}
catch (Exception ex)
{
throw ex;
}
}
public UsersInfo GetUserDetails(AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
UsersInfo lstStatus = sqlH.ExecuteAsObject <UsersInfo>("usp_Aspx_GetUserDetails", parameter);
return(lstStatus);
}
catch (Exception e)
{
throw e;
}
}
private void GetUserShippingAddress(int shippingAddressId)
{
try
{
var parameter = new List <KeyValuePair <string, object> > {
new KeyValuePair <string, object>("@ShippingAddressId", shippingAddressId)
};
var sqlH = new SQLHandler();
_userShippingAddresInfo = sqlH.ExecuteAsObject <UserAddressInfo>("usp_Aspx_mb_GetShippingAddressByAddressId",
parameter);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connect to database and obtain user profile.
/// </summary>
/// <param name="UserName">User name.</param>
/// <param name="PortalID">PortalID</param>
/// <returns>Object of UserProfileInfo class.</returns>
public static UserProfileInfo GetProfile(string UserName, int PortalID)
{
string sp = "[dbo].[usp_GetUserProfile]";
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));
try
{
return (sagesql.ExecuteAsObject<UserProfileInfo>(sp, ParamCollInput));
}
catch (Exception)
{
throw;
}
}
public static BreadCrumInfo GetBreadCrumb(string SEOName, int PortalID)
{
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));
try
{
SQLHandler SQLH = new SQLHandler();
return SQLH.ExecuteAsObject<BreadCrumInfo>("[dbo].[usp_BreadCrumbGetFromPageName]", ParaMeterCollection);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connect to database and obtain module message.
/// </summary>
/// <param name="ModuleID">ModuleID</param>
/// <param name="Culture">Culture code.</param>
/// <returns>Object of ModuleMessageInfo.</returns>
public static ModuleMessageInfo GetModuleMessage(int ModuleID,string Culture)
{
try
{
SQLHandler SQLH = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ModuleID", ModuleID));
ParamCollInput.Add(new KeyValuePair<string, object>("@Culture", Culture));
return SQLH.ExecuteAsObject<ModuleMessageInfo>("[dbo].[usp_ModuleMessageGet]", ParamCollInput);
}
catch (Exception)
{
throw;
}
}
public static ImageGalleryInfo GetGallerySettingValues(int userModuleID, AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
try
{
parameterCollection.Add(new KeyValuePair<string, object>("@UserModuleID", userModuleID));
parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameterCollection.Add(new KeyValuePair<string, object>("@Culture", aspxCommonObj.CultureName));
SQLHandler sagesql = new SQLHandler();
ImageGalleryInfo infoObject = sagesql.ExecuteAsObject<ImageGalleryInfo>("[dbo].[usp_Aspx_GetGallerySettings]", parameterCollection);
return infoObject;
}
catch (Exception e)
{
throw e;
}
}
public ImageGalleryInfo GetGallerySettingValues(int UserModuleID, int PortalID, string culture)
{
ImageGalleryInfo infoObject = new ImageGalleryInfo();
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
try
{
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UserModuleID", UserModuleID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Culture", culture));
SQLHandler sagesql = new SQLHandler();
infoObject = sagesql.ExecuteAsObject<ImageGalleryInfo>("[dbo].[usp_aspx_GetGallerySettings]", ParaMeterCollection);
return infoObject;
}
catch (Exception ex)
{
throw ex;
}
}
public static UspsSetting GetSetting(int providerId, AspxCommonInfo commonInfo )
{
try
{
List<KeyValuePair<string, object>> paraMeter = new List<KeyValuePair<string, object>>();
paraMeter.Add(new KeyValuePair<string, object>("@StoreID", commonInfo.StoreID));
paraMeter.Add(new KeyValuePair<string, object>("@PortalID", commonInfo.PortalID));
paraMeter.Add(new KeyValuePair<string, object>("@ShippingProviderID", providerId));
var sqLh = new SQLHandler();
UspsSetting setting= sqLh.ExecuteAsObject<UspsSetting>("usp_Aspx_GetUSPSShippingProviderSetting", paraMeter);
return setting;
}
catch (Exception ex)
{
throw ex;
}
}
private static ShippingProvider GetProviderInfo(int providerId, int storeId, int portalId)
{
try
{
var paraMeter = new List<KeyValuePair<string, object>>
{
new KeyValuePair<string, object>("@StoreId", storeId),
new KeyValuePair<string, object>("@PortalId", portalId),
new KeyValuePair<string, object>("@ShippingProviderId", providerId)
};
var sqLh = new SQLHandler();
return sqLh.ExecuteAsObject<ShippingProvider>("usp_Aspx_GetShippingProviderInfo", paraMeter);
}
catch (Exception ex)
{
throw ex;
}
}
public static SettingInfo GetSettingByKey(SettingInfo objSetting)
{
string sp = "[dbo].[usp_DashboardGetSettingByKey]";
SQLHandler sagesql = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@SettingKey", objSetting.SettingKey));
ParamCollInput.Add(new KeyValuePair<string, object>("@UserName", objSetting.UserName));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", objSetting.PortalID));
try
{
return (sagesql.ExecuteAsObject<SettingInfo>(sp, ParamCollInput));
}
catch (Exception)
{
throw;
}
}
public SageBannerInfo GetHTMLContentForEditByID(int ImageID)
{
try
{
List<KeyValuePair<string, object>> para = new List<KeyValuePair<string, object>>();
para.Add(new KeyValuePair<string, object>("@ImageID", ImageID));
SQLHandler SQLH = new SQLHandler();
return SQLH.ExecuteAsObject<SageBannerInfo>("[dbo].[usp_SageBannerGetHTMLContentForEditByID]", para);
}
catch (Exception ex)
{
throw ex;
}
}
public SageBannerSettingInfo GetSageBannerSettingList(int PortalID, int UserModuleID, string CultureCode)
{
try
{
SageBannerSettingInfo Getsettin = new SageBannerSettingInfo();
List<KeyValuePair<string, object>> paramCol = new List<KeyValuePair<string, object>>();
paramCol.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
paramCol.Add(new KeyValuePair<string, object>("@UserModuleID", UserModuleID));
paramCol.Add(new KeyValuePair<string, object>("@CultureCode", CultureCode));
SQLHandler sageSQL = new SQLHandler();
Getsettin = sageSQL.ExecuteAsObject<SageBannerSettingInfo>("[dbo].[usp_SageBannerGetBannerSetting]", paramCol);
return Getsettin;
}
catch (Exception ex)
{
throw ex;
}
}
public static CountUserInfo GetGeneralSnapShot(int PortalID, bool IsAdmin)
{
SQLHandler sageSql = new SQLHandler();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsAdmin", IsAdmin));
return sageSql.ExecuteAsObject<CountUserInfo>("[dbo].[usp_DashBoardPageModuleStatistics]", ParamCollInput);
}
catch (Exception ex)
{
throw ex;
}
}
public static CountUserInfo GetOnlineUserCount()
{
try
{
SQLHandler Objsql = new SQLHandler();
return Objsql.ExecuteAsObject<CountUserInfo>("[dbo].[usp_OnlineUserCountGet]");
}
catch (Exception)
{
throw;
}
}
public static QuickLink GetQuickLinkDetails(int QuickLinkItemID)
{
string sp = "[dbo].[usp_DashboardQuickLinkGetDetails]";
SQLHandler sagesql = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@QuickLinkItemID", QuickLinkItemID));
try
{
return (sagesql.ExecuteAsObject<QuickLink>(sp, ParamCollInput));
}
catch (Exception)
{
throw;
}
}
public static Sidebar GetSidebarDetails(int SidebarItemID)
{
string sp = "[dbo].[usp_DashboardSidebarGetDetails]";
SQLHandler sagesql = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@SidebarItemID", SidebarItemID));
try
{
return(sagesql.ExecuteAsObject<Sidebar>(sp, ParamCollInput));
}
catch (Exception)
{
throw;
}
}