C# Parameterless Properties – An Example Few weeks ago we investigated how C# Properties are emitted by IL. We saw how the value implicit parameter is introduced and used. In this article we take a look how one can leverage Properties’ potential to build more robust code. The code is self-explanatory and comments are added … Continue reading C# Parameterless Properties – (Part II)
C# Parameterless Properties – (Part 1)
In this blog entry we will take a look at C# Properties. Properties in C# are used as fields. Their main purpose is to isolate the actual data by allowing the developer to perform some validation prior the client access the guarded member variable. Properties are meant to be simple and efficient. In Object Oriented … Continue reading C# Parameterless Properties – (Part 1)
Magento SQL Logging – (Part II)
In the last article we saw the different ways how one can analyse the SQL Queries running under the Magento’s hood. These are listed here again: To see all queries issued to the database Modify the core Magento code that deals with the database query generation Enable Magento Pdo MySql debugging Switch on MySQL logging … Continue reading Magento SQL Logging – (Part II)
Magento SQL Logging – (Part I)
As with any e-commerce solution Magento stores nearly all the data of the online store in a database. To simplify the communication between code and the database Magento provides a number of abstraction functions. The use of abstraction to communicate with the database leads to the question of what queries are being issued to the … Continue reading Magento SQL Logging – (Part I)
Automatically mark the current week in an Excel Chart
Last time we discussed how to highlight a row in Microsoft Excel automatically. This can be accessed here. Today we will discuss how to highlight a particular entry in a Microsoft Excel chart. The final result is shown in Figure 1. To demonstrate how the above is achieved, we will use the following data: Step … Continue reading Automatically mark the current week in an Excel Chart