public static List <string> SubscribeGetAllCustomerEmails() { return(SQLDataAccess.ExecuteReadColumn <string>( "SELECT [Email] FROM [Customers].[Customer] WHERE [Subscribed4News] = 1 union SELECT Email FROM Subscribe WHERE (Enable = 1)", CommandType.Text, "Email")); }
public static List <string> SubscribeGetUnRegCustomerEmails() { return(SQLDataAccess.ExecuteReadColumn <string>( "SELECT Email FROM dbo.Subscribe", CommandType.Text, "Email")); }
public static List <string> SubscribeGetRegCustomerEmails() { return(SQLDataAccess.ExecuteReadColumn <string>( "SELECT Email FROM Customers.Customer WHERE Subscribed4News = 1", CommandType.Text, "Email")); }
public static bool IsMainLink(int productId, int categoryId) { return (SQLDataAccess.ExecuteReadColumn <bool>( "SELECT Main FROM [Catalog].[ProductCategories] WHERE [ProductID] = @ProductID AND [CategoryID] = @CategoryID", CommandType.Text, "Main", new SqlParameter("@ProductID", productId), new SqlParameter("@CategoryID", categoryId)).FirstOrDefault()); }
protected List <int> GetBrokenCategoriesIDs() { return (SQLDataAccess.ExecuteReadColumn <int>( "(Select CategoryID From Catalog.Category as chiledCat Where (Select COUNT(CategoryID) from Catalog.Category Where CategoryID = chiledCat.ParentCategory) = 0)", CommandType.Text, "CategoryID")); }
/// <summary> /// /// </summary> /// <param name="parent"></param> /// <param name="menuType"></param> /// <returns></returns> public static List <int> GetAllChildIdByParent(int parent, EMenuType menuType) { return(SQLDataAccess.ExecuteReadColumn <int>( "[CMS].[sp_GetChildMenuItemByParent]", CommandType.StoredProcedure, "MenuItemID", new SqlParameter("@MenuType", menuType.ToString()), new SqlParameter("@ParentId", parent))); }
public static IEnumerable <int> GetAllShippingMethodIds() { return(SQLDataAccess.ExecuteReadColumn <int>("SELECT ShippingMethodID FROM [Order].[ShippingMethod]", CommandType.Text, "ShippingMethodID")); }
/// <summary> /// /// </summary> /// <returns></returns> public static List <int> GetThemeIDs() { return(SQLDataAccess.ExecuteReadColumn <int>("SELECT [VoiceThemeID] FROM [Voice].[VoiceTheme]", CommandType.Text, "VoiceThemeID")); }
public static List <TResult> ModuleExecuteReadColumn <TResult>(string query, CommandType commandType, string columnName, params SqlParameter[] parameters) where TResult : IConvertible { return(SQLDataAccess.ExecuteReadColumn <TResult>(query, commandType, columnName, parameters)); }
/// <summary> /// /// </summary> /// <param name="viewed"></param> /// <returns></returns> public static List <int> GetAdminMesssagesFromDatabase(bool viewed) { return(SQLDataAccess.ExecuteReadColumn <int>("SELECT [ID] FROM [dbo].[AdminMessages] WHERE [Viewed] = @Viewed", CommandType.Text, "ID", new SqlParameter("@Viewed", viewed))); }
public static List <int> GetAllChildIdByParent(int parent) { return(SQLDataAccess.ExecuteReadColumn <int>("[CMS].[sp_GetChildStaticPagesByParent]", CommandType.StoredProcedure, "StaticPageID", new SqlParameter("@ParentId", parent))); }
public static List <int> GetParentStaticPages(int pageId) { return(SQLDataAccess.ExecuteReadColumn <int>("[CMS].[sp_GetParentStaticPages]", CommandType.StoredProcedure, "StaticPageID", new SqlParameter("@ChildPageId", pageId))); }
public static List <string> GetCustomersEmails() { return(SQLDataAccess.ExecuteReadColumn <string>("SELECT Email FROM [Customers].[Customer]", CommandType.Text, "Email")); }
public static List <int> GetCertificatePaymentMethodsID() { return(SQLDataAccess.ExecuteReadColumn <int>( "SELECT * FROM [Settings].[GiftCertificatePayments]", CommandType.Text, "PaymentID")); }