Parallel threads with C#

Web programming
Example of some code where I decided to take the data from the DB in batches instead than all in one go, which was timing out. This could have been done one after the other, just waiting for the previous one to finish before requesting next batch, but I decided to give it a go and try to get them all at the same time by making separate calls and waiting for them all to finish to build the result in order. Important bits in commented lines. [csharp] using System.Text; using System.Threading.Tasks; public abstract class BaseExporterRepository : BaseDataRepository<DbContext> { private readonly IDbContextFactory _contextFactory; protected readonly int batchSize = 5000; protected virtual string GetHeader() => ""; protected virtual Task<StringBuilder> BuildBatchAsync(DbContext ctx, int skip) => null; protected virtual Task<int> CountAllAsync() => null;…
Read More

Performing Queries with Kibana

Web programming
Queries To get anything in the index: [csharp] GET /_search {"query": {"match_all": {}}} [/csharp] To get a document type inside the index (dragon-dev is the index name): [csharp] GET dragon-dev/organisation/_search {"query": {"match_all": {}}} GET dragon-dev/article/_search {"query": {"match_all": {}}} GET dragon-dev/person/_search {"query": {"match_all": {}}} [/csharp] Search by Guid (two different ways): [csharp] GET dragon-dev/person/_search { "query": { "match": { "id": "8dd0f391-ce67-41e6-bf68-374716a90bfe" } } } GET dragon-dev/associate/_search { "query": { "match": {"associatedWithId": "dbc8814d-9123-47d3-8dac-e31a7de5107e" } } } [/csharp] Sorting [csharp] // Sorting by a numeric or Date field is straight forward GET dragon-dev/organisation/_search { "sort": [{"websiteId": {"order" : "asc"}}], "query": {"match_all": {}} } // But a text field requires to make it a keyword type and search by keyword: GET dragon-dev/organisation/_search { "sort": [{"name.keyword": {"order" : "asc"}}], "query": {"match_all": {}} } [/csharp] Deleting…
Read More

Setting up Neo4j to work with a C#.Net project

Web programming
Just a quick guideline to refresh my mind: Installing Neo4j Server First, go to their website and download and install the latest version. If you are planning to use this installation for dev purposes only, you don't need the enterprise version, the individual works just fine. Installing it should take no time and be quite simple, but once it's done, run the program and click on Start to start the server, then click on the link to browse to it. Unless you edit the config file to set off the authentication it will ask you to login, the default user/pass was something like neo4j/neo4j or neo4j/admin, I can't remember right now. Once that's done it asks to change the default password to a new one, you can set your own…
Read More

Performing queries in .Net with NEST

Web programming
First of all, I created a document model in C# named EsOrganisation with some basic fields: [csharp] [ElasticsearchType(Name = "organisation")] public class EsOrganisation { public Guid Id { get; set; } public DateTimeOffset CreatedDate { get; set; } public DateTimeOffset? UpdatedDate { get; set; } public int OrganisationTypeId { get; set; } public string OrganisationName { get; set; } public List<string> OrganisationAliases { get; set; } public List<string> OrganisationKeywords { get; set; } public List<int> Products { get; set; } } [/csharp] Then I also created a factory to retrieve the Nest.ElasticClient, to simplify just have in mind that when I call to client.SearchAsync() I have already instantiated and prepared it. Structured vs Unstructured Search Structured or Unstructured Search refers as to how are the filters applied, Structured search refers…
Read More

Some tips on C# Generics

Web programming
Defining interfaces You can define that a generic must implement an interface, which in essence allows you to know beforehand that a generic type will have a certain method (making it less generic) [csharp] public interface ISearchable { void Search(); } public class SomeClass<T> where T : ISearchable { public void DoSomething(T entity) { entity.Search(); // Can do this on a generic type because it's implementing ISearchable } } [/csharp] You can also use generics on the interfaces, in this case: [csharp] public interface ISearchable<TEntity> { TEntity Search(); } public class SomeClass<T> where T : ISearchable<T> { public T FindMe(T entity) { return entity.Search(); } } [/csharp] Now when referencing the interface we must set the generic type too. Warning!: If you set a constraint on a generic type any…
Read More

Implementing a basic Newtonsoft’s JsonConverter

Web programming
I was deserializing an object that requires to be a string at the client but it's actually a structure inside the database, a person's name, saved as a Name { FirstName:'', LastName: '', ... } type of object. By using Newtonsoft's deserializer into a model such model can't just have a string Name as Newtonsoft's deserializer won't know how to parse the object into a simple string, so instead I had to declare the property as the same type of object that the name is saved into the database: PersonName. Now I wanted to transform it into a string when re-serializing it to send it to the client, which could do with a mapper but decided to try Newtonsoft's JsonSerializer attribute to see if it works and to my amazement…
Read More

First steps into Angular 2 from Angular 1

Web programming
With the final version of Angular 2 just been released last month after the Release Candidate was released in May this year, we decided to get into it at our next project in my company and I decided to save some notes to myself in my blog as usual. First of: Angular's official Quick start guide. TypeScript? There are many changes in Angular2 compared with Angular1, one of those is the native possibility to use TypeScript, ES2015, Dart or plain javascript to code your app and transpile that later by just using Angular's config file to set so. This is part of the demo's config file at Angular's website where you can see how TypeScript has been configured to write the app: [js] (function (global) { System.config({ // DEMO ONLY!…
Read More

Setting up Selenium in C#

Software Development, Web programming
1. Download Selenium WebDriver for C# Go to SeleniumHG website and get into Downloads, scroll down until you see the different versions of the WebDriver and get the C# version. Extract the zip files into a folder. Create a project Create a Test Project using VS (File > New > Project > Test > Unit Test). Add the WebDriver libraries: References > Right click > Add Reference... > Browse > Take the right ones for your framework (35 or 40). Note: You can create a different type of project, like a Console App, but this other allows you to get test reports, config different suites of tests, etc. Start testing Now you can start testing, include the namespaces inside OpenQa. For example to test in Chrome: using OpenQA.Selenium; using OpenQA.Selenium.Chrome;…
Read More

Mocking BackEnd with AngularJS

Web programming
I found myself on the need of isolating my FrontEnd AngularJS app from the backend so the app can continue working without Internet access or without access to the backend services. I did not want, though, to add anything too aggressive into the app, but a piece of code that can be attached or unattached very easily and without the app having to know about it at all, like an app extension. To do so, I found myself installing angular-mocks, creating a file that requests the library, attaches the $httpBackend to the app on run time, uses $httpBackend to mock the responses with some json files and forces the requests to be synchronous. Step 1. Installing angular-mocks First of all, to get access to $httpBackend we need to install angular-mocks,…
Read More

Including Google Maps into your AngularJS app

Web programming
I already did this in the past but things change and the plugin I was using has changed too. I use AngularJS with Angular-Bootstrap directives as to save me some time and make the best of Bootstrap stylesheets I'm already using. angular-google-maps is another directive int he same club of bootstrap friends and this is how to include it into your project: Installing packages I'm using bower to manage packages at the front end, so first of all let's install the required packages to make this work. I need the plugin angular-google-maps, which requires angular (obviously), lodash and angular-simple-logger to work. So just make sure you install all required packages using bower: [sourcecode language="js" wraplines="false"] bower install --save-dev angular bower install --save-dev angular-google-maps bower install --save-dev angular-simple-logger bower install --save-dev…
Read More

Managing packages with Bower

Web programming
Installing Bower Just do it globally so you can access it from anywhere. You need to have previously installed Node.js in order to install it, and Git in order to use it. npm install bower -g Have in mind you will also need to install it in your TeamCity server as you'll probably want to get the packages from there too. Installing packages Installing a package with bower is as easy as moving to the root folder of your project using the console and executing something like this: bower install angularjs You can also install a concrete version using # bower install angularjs#1.4.9 Or install more than one package with one command: bower install angularjs jquery bootstrap angular-ui Saving installed packages The main idea of bower is to keep track…
Read More

AngularJS : Service vs provider vs factory

Web programming
Just copy-pasting this answer from Ben Clinkinbeard: Services Syntax: module.service( 'serviceName', function ); Result: When declaring serviceName as an injectable argument you will be provided the actual function reference passed to module.service. Usage: Could be useful for sharing utility functions that are useful to invoke by simply appending () to the injected function reference. Could also be run with injectedArg.call( this ) or similar. Factories Syntax: module.factory( 'factoryName', function ); Result: When declaring factoryName as an injectable argument you will be provided the value that is returned by invoking the function reference passed to module.factory. Usage: Could be useful for returning a 'class' function that can then be new'ed to create instances. Providers Syntax: module.provider( 'providerName', function ); Result: When declaring providerName as an injectable argument you will be provided…
Read More

WebApi and AngularJS: Mapping parameter objects

Web programming
Looks like the parameter behavior between MVC and WebApi is slightly different, mainly because WebApi can only get one parameter from the Body which forces us to use request models. I am working with Angular resources and I have found certain problems to connect to Web API services due to the different way of thinking or structuring the data. Let's see some workarounds: Sending an array of objects If you try to send an Array, in AngularJS you may assign the Body by forming it into parameters with something like this (just because it's the usual way we add them): [sourcecode language="js" wraplines="false"] myResource.post({ myItems: myItems }) [/sourcecode] Which results in a JSON like this: [sourcecode language="js" wraplines="false"] {myItems: [{"Id": 0, "Name": "Blah"}, {"Id": 1, "Name": "Bleh"}]} [/sourcecode] And this…
Read More

Using Google Tag Manager with AngularJS

Software Development, Web programming, Web statistics
One would expect that being Angular a Google product and Google Tag Manager another of their products combining them would be quite simple and straightforward, but I personally had my doubts and not much documentation on how are we supposed to make them work. Should I just paste the code as usual or will that get into conflict with Angular? Is it going to register "page views" whenever I change the routing or not as it's not a standard page view? I checked some things and here are some of my results: Adding Google Tag Manager snippet into the page First of all, I didn't find any problem with just copy-pasting the code before the /body closing tag, but I wanted to angularize it and have everything in one piece…
Read More

Angular directives and scope

Web programming
When creating directives with angular, you can choose to use the parent's scope, create your own isolated scope for the directive or have an inherited one. Let's see what types of scope we have and how to work with them: Let's start by considering this main controller and template: [sourcecode language="js" wraplines="false"] var app = angular.module("testingDirectives", []); app.controller("mainController", function($scope, $timeout) { $scope.MainValue = "main"; $scope.ValueToOverride = "notOverridden"; $scope.ValueToOverrideOn6 = "notOverridden"; $timeout(function() { $scope.MainValue = "main updated"; }, 1000); }); [/sourcecode] [sourcecode language="html" wraplines="false"] <div ng-app="testingDirectives" ng-controller="mainController"> {{MainValue}} <directive-one></directive-one> <directive-two></directive-two> <directive-three></directive-three> <directive-four custom-att="attribute"></directive-four> <directive-five custom-att="attribute"></directive-five> <directive-six custom-att="attribute" custom-att2="overrided"></directive-six> <directive-six custom-att="attribute" custom-att2="overrided 2"></directive-six> <directive-seven custom-att="attribute" custom-att2="overrided"></directive-seven> <directive-seven custom-att="attribute" custom-att2="overrided 2"></directive-seven> <directive-eight from-parent="{{MainValue}}"></directive-eight> <directive-nine from-parent="{{MainValue}}"></directive-nine> </div> [/sourcecode] Using the parent scope In this case, the directive doesn't have a scope of its own,…
Read More