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