home

I wanted to find a way to automatically rebuild the index of a particular mongoDB collection, but this time with kind of different approach. As I've been getting familiar with PowerShell for some time now, I wanted to write a script and resign from writing anything with the help of pure .NET technology and Visual Studio (I'm aware that PowerShell is based on .NET but it's not the same as writing code using the most popular IDE by Microsoft). To make a long story short if you want to use PowerShell cmdlet(s) to work with your mongoDB instance visit the following website - https://www.powershellgallery.com/packages/Mdbc/5.1.5 - and read more on how to work with Mdbc module written by Roman Kuzmin.

Install the module and list all the cmdlet(s) included in the package:

If you want to read more about each of these cmdlet(s) use the following command pattern: Get-Help <Cmdlet> -Full (or use my second favorite pattern: Help <Cmdlet> -Examples)

My short script looks as follows:

The reason why I put the database name in a red circle is to indicate, that this is the database you authenticate your mongoDB user against. If another database is used to authenticate a user then you should attach it at the end of that connection string - simply replace phonebook with the right one.

Another thing is to check if the script actually works:

And the last thing was to add it to Windows Scheduler so it could run daily:

I've been familiar with C# for a long time and yet there are moments when I consider this language quite difficult to read. I want to create an extension method to be able to count a specific character in a string object. I could do it using simple foreach loop but no - let's try different approach. I wanna use the Count method and provide simple lambda expression as the parameter. When some people look at some complex declarations of various methods in C#, they usually say "What is that?!" - look at the following declaration of the Count method:

int IEnumerable<char>.Count<char>(Func<char, bool> predicate)

 Let's try to decrypt the declaration which is not that easy to understand at first glance.

int - method returns int - number of a specific character in a string object, this is easy
IEnumerable<char>. - doesn't it look like: (IEnumerable<char>).method()? - so we have a simple OBJECT in brackets, 
and the dot says that we're about to call one of its methods. No matter what, the object in brackets must implement the IEnumerable interface.
.Count<char> - our method which needs a simple character as the input parameter
(Func<char, bool> predicate) - Func is a delegate which needs a simple character as the input parameter 
to provide a bool value as the result - so we need a piece of code here. It can be a method or a simple lambda expression.

The lambda expression is called for each character in the Array. Each character becomes the input paramater and each time either false (_c != c) or true (_c == c) value is return.

Recently I've been working on a small ASP.NET MVC project and I was about to launch it on the production server. Everything seemed just fine until I called one jQuery function from my Scripts\phonebook.js file. The result was very clear - 404 NOT FOUND (btw. developer tools available in either Firefox or Chrome are very helpful in the process of solving these types of network / web development issues). According to what I've found on the web, it's quite common problem but it wasn't that obvious when it came to the solution. Here's a piece of the code:

$.ajax({
type: 'POST',
            url: '/Home/InsertNumber',
            data: JSON.stringify({
                Firstname: firstname.trim(),
                Lastname: lastname.trim(),
                Department: department.trim(),
                Telephone: telephone.trim(),
                Keywords: keywords.trim()
            }),

So when I click my #button on the website and InsertNumber is called then I get NOT FOUND (404) - why? When I run it on IIS Express instance in debug mode, everything is ok but after I publish my app on IIS it doesn't work. Is there something wrong with my InsertNumber method?

[HttpPost]
        public JsonResult InsertNumber(string firstname, string lastname, string department, string telephone, string keywords)
        {
            try
            {
                var client = new MongoClient(_connectionString);
                var database = client.GetDatabase(_database);
                var collection = database.GetCollection<BsonDocument>(_queue);
                // .. 
 
                return Json("result");

This method is fine - there must be something wrong with ajax call. It came up that I forgot about one very important thing. When you upload your website on IIS you give it a name - right? I called my app (website) 'telefony' - so when I run it i type: http://server/telefony - so all I had to do to fix my 404 problem was to add telefony before /Home/InsertNumber method call in url parameter: /telefony/Home/InsertNumber.

To make it work like a charm I had to correct this one part only:

$.ajax({
            type: 'POST',
            url: '/telefony/Home/InsertNumber',
            data: JSON.stringify({
                Firstname: firstname.trim(),
                Lastname: lastname.trim(),
                Department: department.trim(),
                Telephone: telephone.trim(),
                Keywords: keywords.trim()
            }),

Solution: Let's do not forget about the name of our app deployed on IIS server - it must be included in url parameter when want to call a method from jQuery! You can optionally paste your java code in html and use '@Url.Action('Method', 'Controller')' as the parameter of url - then simply look at the source code. You'll find something like this: url: '/telefony/Home/InsertNumber' - do it when you're not sure about the correct url.