/// <inheritdoc /> public virtual void OnProvidersExecuted(ApplicationModelProviderContext context) { if (context == null) { throw new ArgumentNullException(nameof(context)); } var implicitVersionModel = new ApiVersionModel(Options.DefaultApiVersion); var conventionBuilder = Options.Conventions; var application = context.Result; var controllers = application.Controllers; if (Options.UseApiBehavior) { controllers = ControllerFilter.Apply(controllers); } for (var i = 0; i < controllers.Count; i++) { var controller = controllers[i]; controller.ControllerName = TrimTrailingNumbers(controller.ControllerName); if (!conventionBuilder.ApplyTo(controller)) { ApplyAttributeOrImplicitConventions(controller, implicitVersionModel); } } }
public static int GetControllersCount(ControllerFilter filter) { int count; var sql = @" SELECT COUNT(*) FROM [dbo].[Controller] left outer join dbo.Technology on [dbo].[Controller].TechnologyId = dbo.Technology.TechnologyId where (1=1)" + getFilterString(filter); using (SqlConnection sqlConnection = new SqlConnection(DBHelper.strConnString)) { SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection); try { sqlConnection.Open(); count = (int)sqlCommand.ExecuteScalar(); } catch (Exception ex) { throw ex; } finally { sqlConnection.Close(); } } return(count); }
public DataTable GetControllersForExcel(ControllerFilter filter) { DataTable dataTable = new DataTable(); var sql = @" SELECT dbo.Technology.TechnologyName, dbo.Controller.ControllerName, STUFF(( SELECT ', '+ dbo.[User].EmailAddress FROM dbo.[User] JOIN dbo.ControllerUser ON ControllerUser.UserId = dbo.[User].UserID WHERE dbo.ControllerUser.ControllerId = dbo.Controller.ControllerId FOR XML PATH('')), 1, 1, '') AS 'Assigned_Users' FROM dbo.Controller INNER JOIN dbo.Technology ON dbo.Controller.TechnologyId = dbo.Technology.TechnologyID WHERE (1 = 1) "; sql += getFilterString(filter); sql += " ORDER BY dbo.Technology.TechnologyID, dbo.Controller.ControllerName "; using (SqlConnection sqlConnection = new SqlConnection(DBHelper.strConnString)) { sqlConnection.Open(); SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, sqlConnection); sqlAdapter.Fill(dataTable); } return(dataTable); }
private ControllerFilter GetFilter() { ControllerFilter entity = new ControllerFilter(); entity.ControllerName = txtControllerName.Text.ToString(); entity.TechnologyId = int.Parse(DropDownListTech.SelectedValue); return(entity); }
private static string getFilterString(ControllerFilter filter) { string sql = ""; if (!string.IsNullOrEmpty(filter.ControllerName)) { sql += " AND [Controller].[ControllerName] LIKE '%" + filter.ControllerName + "%'"; } if (filter.TechnologyId > 0) { sql += "AND [Controller].[TechnologyId] = " + filter.TechnologyId; } return(sql); }
private void parentChanged(TECChangedEventArgs obj) { if (obj.Value is TECLocation location) { if (obj.Change == Change.Add) { this.Locations.Add(location); } else if (obj.Change == Change.Remove) { this.Locations.Remove(location); } } else if (obj.Value is IControllerConnection) { ControllerFilter.RaiseFilter(); ConnectableFilter.RaiseFilter(); } }
/// <inheritdoc /> public virtual void OnProvidersExecuted(ApplicationModelProviderContext context) { Arg.NotNull(context, nameof(context)); var implicitVersionModel = new ApiVersionModel(Options.DefaultApiVersion); var conventionBuilder = Options.Conventions; var application = context.Result; var controllers = application.Controllers; if (Options.UseApiBehavior) { controllers = ControllerFilter.Apply(controllers); } foreach (var controller in controllers) { if (!conventionBuilder.ApplyTo(controller)) { ApplyAttributeOrImplicitConventions(controller, implicitVersionModel); } } }
public static DataTable GetControllers(ControllerFilter filter, int maximumRows, int startRowIndex) { DataTable dataTable = new DataTable(); var sql = @" SELECT * from ( SELECT ROW_NUMBER() OVER ( ORDER BY dbo.Technology.TechnologyID, dbo.Controller.ControllerName ) ROWNUMBER, [dbo].[Controller].[ControllerId], [dbo].[Controller].[ControllerName] , [dbo].[Controller].[TechnologyId], dbo.Technology.TechnologyName, STUFF(( SELECT ', '+ dbo.[User].EmailAddress FROM dbo.[User] JOIN dbo.ControllerUser ON ControllerUser.UserId = dbo.[User].UserID WHERE dbo.ControllerUser.ControllerId = dbo.Controller.ControllerId FOR XML PATH('')), 1, 1, '') AS 'Assigned_Users' FROM [dbo].[Controller] left outer join dbo.Technology on [dbo].[Controller].TechnologyId = dbo.Technology.TechnologyID WHERE (1 = 1) " ; sql += getFilterString(filter); // sql += " ORDER BY dbo.Technology.TechnologyID, dbo.Controller.ControllerName "; sql += ") As query where query.ROWNUMBER > " + startRowIndex + " AND query.ROWNUMBER <= " + (startRowIndex + maximumRows); using (SqlConnection sqlConnection = new SqlConnection(DBHelper.strConnString)) { sqlConnection.Open(); SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, sqlConnection); sqlAdapter.Fill(dataTable); } return(dataTable); }