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