public IEnumerable <ReportOverview> Get(string workArea, string productionLineFilter, string workCellFilter, string ruleTypeFilter, string materialFilter, int pageNumber, int pageSize) { var list = new List <ReportOverview>(); IQueryOperations storageManager = StorageManagerFactory.CreateDatabaseManager(this.ConnectionString); var set = storageManager.ExecuteCommand("sp_VCC_local_reportOverview", new[] { this.CreateDataParameter("@workArea", workArea), this.CreateDataParameter("@productionLineFilter", productionLineFilter), this.CreateDataParameter("@workCellFilter", workCellFilter), this.CreateDataParameter("@ruleTypeFilter", ruleTypeFilter), this.CreateDataParameter("@materialFilter", materialFilter), this.CreateDataParameter("@pageNumber", pageNumber), this.CreateDataParameter("@pageSize", pageSize), }); if (set.IsEmpty()) { return(list); } var rows = set.Tables[0].Rows.Cast <DataRow>(); return(rows.MapTo <IEnumerable <ReportOverview> >()); }
// GET api/<controller> public IEnumerable <ReportOverviewViewModel> Get(string area) { var list = new List <ReportOverviewViewModel>(); IQueryOperations storageManager = StorageManagerFactory.CreateDatabaseManager(_connectionString); var set = storageManager.ExecuteCommand("sp_VCC_local_reportOverview", new[] { new SqlParameter("@workArea", area) }); if (set.IsEmpty()) { return(list); } var rows = set.Tables[0].Rows.Cast <DataRow>(); return(rows.MapTo <IEnumerable <ReportOverviewViewModel> >()); }