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