/// <summary>
/// Get products without category
/// </summary>
/// <returns></returns>
public static IEnumerable <int> GetProductIDsWithoutCategory()
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>(
"SELECT [Product].[ProductID] FROM [Catalog].[Product] WHERE [Product].[ProductID] not in (select distinct [ProductID] from [Catalog].[ProductCategories])",
CommandType.Text,
"ProductID"));
}
public static List <int> GetProductIdByType(TypeFlag type)
{
string sqlCmd;
switch (type)
{
case TypeFlag.Bestseller:
sqlCmd = "select ProductId from Catalog.Product where Bestseller=1";
break;
case TypeFlag.New:
sqlCmd = "select ProductId from Catalog.Product where New=1";
break;
case TypeFlag.Discount:
sqlCmd = "select ProductId from Catalog.Product where Discount > 0";
break;
case TypeFlag.OnSale:
sqlCmd = "select ProductId from Catalog.Product where OnSale=1";
break;
case TypeFlag.Recomended:
sqlCmd = "select ProductId from Catalog.Product where Recomended=1";
break;
default:
throw new NotImplementedException();
}
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>(sqlCmd, CommandType.Text, "ProductId", new SqlParameter {
ParameterName = "@type", Value = (int)type
}).ToList());
}
/// <summary>
/// get products in categories
/// </summary>
/// <returns></returns>
public static IEnumerable <int> GetProductIDsInCategories()
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>(
"select distinct [ProductID] from [Catalog].[ProductCategories]",
CommandType.Text,
"ProductID"));
}
/// <summary>
/// get categoryIds by productId
/// </summary>
/// <param name="productId"></param>
/// <returns></returns>
public static IEnumerable <int> GetCategoriesIDsByProductId(int productId)
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>("[Catalog].[sp_GetCategoriesIDsByProductId]",
CommandType.StoredProcedure,
"CategoryID",
new SqlParameter("@ProductID", productId)));
}
public static IEnumerable <int> GetProductIDs(int categoryId)
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>(
"SELECT [ProductID] FROM [Catalog].[ProductCategories] WHERE [CategoryID] = @CategoryID",
CommandType.Text,
"ProductID",
new SqlParameter("@CategoryID", categoryId)));
}
public static IEnumerable <int> GetChildIDsHierarchical(int catId)
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>("[Catalog].[sp_GetChildCategoriesIDHierarchical]",
CommandType.StoredProcedure,
"CategoryID",
new SqlParameter("@parent", catId)
));
}
/// <summary>
///
/// </summary>
/// <param name="mItemId"></param>
/// <param name="menuType"> </param>
/// <returns></returns>
public static IEnumerable <int> GetParentMenuItems(int mItemId, EMenuType menuType)
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>(
"[CMS].[sp_GetParentMenuItemsByItemId]",
CommandType.StoredProcedure,
"MenuItemID",
new SqlParameter("@MenuItemID", mItemId),
new SqlParameter("@MenuType", menuType.ToString())));
}
public static IEnumerable <int> GetAllCurrencyId()
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>("SELECT CurrencyID FROM [Catalog].[Currency]", CommandType.Text, "CurrencyID"));
}
/// <summary>
/// Get all products id
/// </summary>
/// <returns></returns>
public static List <int> GetProductsIDs()
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>("SELECT [ProductID] FROM [Catalog].[Product]", CommandType.Text, "ProductID").ToList());
}
public static IEnumerable <int> GetAllPaymentMethodIDs()
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>("SELECT [PaymentMethodID] FROM [Order].[PaymentMethod]", CommandType.Text, "PaymentMethodID"));
}
public static IEnumerable <int> GetOfferListIds()
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>("SELECT [OfferListID] FROM [Catalog].[OffersList]", CommandType.Text, "OfferListID"));
}
public static IEnumerable <int> GetStaticPagesIDs()
{
return(SQLDataAccess.ExecuteReadColumnIEnumerable <int>("SELECT [StaticPageID] FROM [CMS].[StaticPage] Order by SortOrder", CommandType.Text, "StaticPageID"));
}
