MDens is a dental prosthesis laboratory. Their project consists in two parts:

1º They needed a WordPress website with the purpose to publicize their company, the academy training courses, services, a blog area for relevant news related to their activity, and their case of studies.

2º They are using an Italian software called ORISLAB X3 which they use, for management and for passing invoices. For working with this software, they had to ask the lab employees to put all client’s information such as, personal data, work description, etc.. manualy in the software. When a client ask for the status of their prosthesis work, the employees need to go to the software, and send all information to email.

MDens wanted to modernize this system, so they propose the development of an online portal, which allow their clients to logged in, check all prosthesis work status, and submit more works.

The problem with this, is that OrisLab X3 is old, and it’s using a Microsoft Access database in the format of the year 2000.

Resolution:

• I developed a PHP portal using the framework CodeIgniter. This portal was intended for the use of MDens clients.
• I also developed a connector in VB.NET with the objective of synchronizing the information between the Microsoft Access database of OrisLab with the MySQL database of the portal.

MDens also requested more features in Portal, than the OrisLab X3 allows. For allowing MDens to manage does features, I also developed a management software in VB.NET. In that software, they could:

• manage the access and credentials of the clients;
• force the synchronization;
• download the images and files submitted by the clients;
• manage the configurations of the portal, such as, the email address that is used to send automatic emails to the clients.