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