public static DataTable GetProductsTable()
{
return(ModulesRepository.ModuleExecuteTable(
"Select Id, [" + ModuleName + "].[ProductId], DateStart, DateExpired, DiscountInTime, Product.Name, IsRepeat, DaysRepeat, SortOrder From [Module].[" + ModuleName + "] " +
"Left Join Catalog.Product On Product.ProductId = [" + ModuleName + "].[ProductId] Order By SortOrder",
CommandType.Text));
}
public static DataTable GetHistory()
{
return(ModulesRepository.ModuleExecuteTable(
"Select [Order].OrderId, MarketOrderId, Status, OrderDate, Sum " +
"From [Module].[YaMarketOrder] Left Join [Order].[Order] On [YaMarketOrder].[OrderId] = [Order].[OrderId]",
CommandType.Text));
}
public static DataTable GetStoreReviews()
{
return(ModulesRepository.ModuleExecuteTable(
"SELECT * FROM [Module].[StoreReview] ORDER BY [DateAdded] DESC",
CommandType.Text
));
}
