public SalesModelList GetSalesByCategory(string categoryName, string orderYear) { SalesModelList salesResults = new SalesModelList(); htParams["@CategoryName"] = categoryName; htParams["@OrdYear"] = orderYear; try { DataSet ds = results.GetSPDataSet("[dbo].[SalesByCategory]", htParams); } catch (Exception) { throw; } return(salesResults); }
public SalesModelList GetSalesByYear(DateTime beginningDate, DateTime endingDate) { SalesModelList salesResults = new SalesModelList(); htParams["@Beginning_Date"] = beginningDate; htParams["@Ending_Date"] = endingDate; try { DataSet ds = results.GetSPDataSet("[dbo].[Sales by Year]", htParams); salesResults = MappingSalesByYear(ds); } catch (Exception) { throw; } return(salesResults); }