public StatsViewModel SQL_Action(StatsViewModel model) { switch (model.Selectedid) { case 1: //Estadisticas 12.1 model.partialName = "ActiveUsersWeek"; model.ActiveUsersWeek = BL.Acitve_Users_Week(); break; case 2: //Estadisticas 12.2 model.partialName = "ActiveUsersMonth"; model.ActiveUsersMonth = BL.Acitve_Users_Month(); break; case 3: //Estadisticas 5 model.partialName = "DBIndexes"; model.Indexes = BL.GetIndexes(); break; case 4: //Estadisticas 1 model.partialName = "SPRangeHours"; model._SPbyHourViewModel = new SPbyHourViewModel(); break; case 5: //Estaditicas 2 model.partialName = "SP_ConexionesActivas"; model.ActiveConnections = BL.GetActiveConnections(); break; case 6: //Estadisticas 3 model.partialName = "TablesWithCounts"; model.Tablas = BL.TableWithCounts(); break; case 7: //Estadisticas 4 model.partialName = "TableColumns"; model._ColumnsViewModel = new ColumnsViewModel(); break; case 8: //Estadisticas 8 model.partialName = "Tables1000"; model.TablasMil = BL.Table1000(); break; case 9: //Estadisticas 6 model.partialName = "Views"; model.Vistas = BL.GetViews(); break; case 10: //Estadisticas 7 NO PROBADO model.partialName = "MaxMin_SP"; model.MaxMinSP = BL.MaxMinSP(); break; case 11: //Estadisticas 9 model.partialName = "SPRange"; model._SPRangeViewModel = new SPRangeViewModel(); break; case 12: //Estadisticas 10 model.partialName = "UnusedSP"; model.Unused = BL.UnusedSP(); break; case 13: //Estadisticas 11.1 model.partialName = "ExecAvg"; model.ExecAverage = BL.ExecAvg(); break; case 14: //Estadisticas 11.2 model.partialName = "ExecCount"; model.SPCounts = BL.ExecCount(); break; case 15: //Estadisticas 12.3 model.partialName = "InactiveUsers"; model.Inactive = BL.InactiveUsers(); break; case 16: //Estadisticas 12.4 model.partialName = "HotDays"; model.Dias = BL.HotDays(); break; case 17: //Estadisticas 12.4 model.partialName = "HotHours"; model.Horas = BL.HotHours(); break; case 18: //Estadisticas 12.6 model.partialName = "SPByUser"; model._SPByUserViewModel = new SPByUserViewModel(); break; case 19: //Estadisticas 12.7 model.partialName = "GetUserSubtotals"; model.Subtotals = BL.GetUsersSubtotals(); break; case 20: //Estadisticas 13 model.partialName = "GetUserContains"; model._GetUserContains = new GetUserContains(); break; default: break; } return(model); }