SQL Server and MySQL

Riyadh24 is a first working ground web-portal and complete web solution for Kingdom of Saudi Arabia, which includes features like search for different categories, weather information, e-mail, phone and map information, Prayer timings, Things to Do, Al-Riyadh News, Buy & Sell, Business Listing, Jobs, Polls, Ads Manager, Photo gallery and videos, R24 Reseller, Feedbacks , Top 5 categories, Travel & tourism, Accommodation, Shopping & Dining and Up Coming Events.

Companies can register for their respective commercial categories to manage company description, maps and other content. Public users can rate other companies and also give comments. Technologies deployed in making this portal are Microsoft .Net 2008 / SQL Server 2005.

Hanns Seidel Foundation operates as an international not-for-profit organization that needed to have a web presence for its division in Pakistan. ESOLPK thoroughly studied and analyzed the current business processes, procedures and existing situation and deployed this website using .NET platform and SQL Server.

This website has a user friendly GUI and it provides information resource platform for all the visitors. There is also an admin panel for administrative purpose, so that administrator can login to easily delete, update or add contents. Using the admin panel the organization can update their news, pictures, details of work and other information.

This project was a complete redesign of the RSEG website to enhance the appearance, functionality, structure and content of its website. Main purpose was to improve the functionality and manageability of RSEG business. The project is segmented into 2 parts.

(a) CRM + Salentica integration
(b) Website Redesign (includes CMS, search and reports)

The web application has been deployed using .NET platform and is used to store information and data for oil and gas companies in North America to determine potential companies for purchase. It has some graphical elements such as graphs that will be generated from the data stored in backend database. This application is used to index and catalog drilling activity in various areas of the united states for different companies. It is tied in to stock prices & news for companies from a source like Google news, Google finance and gives one summary page for a company showing their production links to the graphs as well as other general information about whether they are operating, financial analysis etc.

Quest Pharmaceuticals is a generic drug distribution company located in western Kentucky. Their website contains two portions, a front end which serves as a standard business card style website, and a backend which handles all of their business operations.

This project included the redesign of the currently implemented web application. The application was written and working using Ruby on Rails and needed to be ported to a more manageable coding language i.e. PHP. The site was also using a MySQL database, and that need to be ported over to a Microsoft SQL database. The application needed to be written in a format compatible with Microsoft Internet Information Services (IIS) 6.0 running on the Windows Server 2003 operating system. The web application was visually and functionally identical to the already operational site.

The history of Estron Chemical began in 1976 with the formation of SBS Chemicals. The company was founded by Dr. Stanislaw B. Skora, who recognized the promise of solvent-free coatings technology while it was still in its infancy. Estron has subsequently developed over 100 proprietary, high-performance additives and resins, making it one of the most successful coatings additives companies in its field.

The initial website of Estron was pretty basic website and was developed using the Ruby on Rails framework. Basically, it is a small e-commerce shopping cart style site. The requirement of our client was to change technology of this website. ESOLPK provided the required services to Estron for this website conversion from Ruby on Rails to PHP and MySQL.

The Livestock and Dairy Development Board, having its head office in Islamabad, have 5 other branch offices with 4 offices in each Provincial Capital and one in Northern Areas. All of their working and processing was being done through manual work. The data was managed either on papers or in a simple Microsoft Excel sheet, which was not reliable as there was no backup available for that file. There was no central database where the data can be stored.

ESOLPK thoroughly studied their current business processes, procedures and existing situation. Keeping in mind the analysis done by our team, ESOLPK provided the extensive solution for the development of database management system in the technolgy ASP.NET and MS SQL Server. The developed database system consisted of various modules. The “Manage Farmer Personal Profile module” covered the information of the farmer, including his whereabouts and how big his farm is in terms of number of animals he has. Another module “Region wise Profile management” covered all the information about the farms in a city, district and province, so that data could be filtered on the basis of province, district and city/town/village. This database management system also had the functionality of managing other profiles, that are not be related to the Regional Profile. Other key features include Record Searching throughout the database on different search criteria, Reports generation on different formats and importing previous data through existing files.

Our client provides several products which require video and textual training and assessment of the training. This application can be used for uploading the tutorials, administer tests, and report the results. It has administrators, sub administrators and users features for login. There are levels of logins determining what the user can do. It has additional features like emailing results on a regular basis to point personnel at the business so they are up to date with the user progression through the training courses.

After receiving the results, users can also retake the test if they wish to. In such a case, a counter keeps track of the number of times they take the test and the scores can also be tracked.