Browsing articles in "Blog"

Adding unsupported Paypal Currency for Opencart 1.5.4 checkout screen

Dec 1, 2012   //   by mukthar   //   Blog  //  No Comments

Recently we had to show the price in AED in an open cart eCommerce project. Even though we tried the solution as suggested in the OpenCart Forum, the conversion from AED ( a non supported currency for PayPal) was not being converted to USD. We solved it as explained below :

1. EDIT : catalog/controller/payment/pp_standard.php

2. FIND (First Instance only)

$order_info = $this->model_checkout_order->getOrder

And add the following code above

if ($order_info)

$currencies = array(‘AUD’,'CAD’,'EUR’,'GBP’,'JPY’,'USD’,'NZD’,'CHF’,'HKD’,'SGD’,'SEK’,'DKK’,'PLN’,'NOK’,'HUF’,'CZK’,'ILS’,'MXN’,'MYR’,'BRL’,'PHP’,'TWD’,'THB’,'TRY’);
//the  $currencies array now have a list of supported currencies supported by pal

if (!in_array(strtoupper($this->currency->getCode()), $currencies))
{
//Current currrency is not supported  by PayPal, so just overwrite currency code.
$order_info['currency_code'] = ‘USD’;

}

Instead of using “your choice of supported currency” here as mentioned in the referenced link, we got the conversion working when we just overwrote the currency code as USD.
3. EDIT: catalog/model/payment/pp_standard.php

FIND AND COMMENT THE BELOW LINE:

if (!in_array(strtoupper($this->currency->getCode()), $currencies)) {
$status = false;
}

References:

  1. http://forum.opencart.com/viewtopic.php?f=136&t=65005

Human Resource Management System

Jan 19, 2012   //   by mukthar   //   Blog  //  No Comments

human-resource-management-system-middle-eastHRKare Human Resource Management System offered by Seeroo is a complete solution focusing on the needs of small and medium scale industries. Our HRMS software package is tailored to suit the industrial needs of Gulf Cooperation Council (GCC) countries including Saudi Arabia (Jedddah, Riyadh), Oman ( Muscat ), Kuwait, UAE (Dubai, Abu Dhabi, Ajman) and Bahrain. Powered by a flexible web based back end and desktop interface with one click installation support, the HRMS software package supports multiple companies that are located in multiple locations.

The HRMS Software package covers following modules which are essential for Human Resource Management Systems in Middle East: Employee Management, Leave Management, Pay roll Allowances & Deductions, Salary Process and Transfers, Daily/Weekly/Monthly Attendances, Daily/Monthly Over Time.

The system supports storage of Employee related documents, Asset allocation to employees, full cycle of employee leave management (Employee Leave Application, Leave Approvals, Leave Settlements, Leave, Employee Rejoins) and monthly salary processing.

The attendance module of the Human Resource software covers normal OT, special OT, absent days and sick leaves.

Web design cochin

Jan 17, 2012   //   by mukthar   //   Blog  //  No Comments

web design cochin
Seeroo IT Solutions offers professional web design services to its clients in Cochin, Kerala. In a short period of time, Seeroo has proved it’s capabilities and has become one of the most reputed web design and development company in Cochin. Our Cochin team of Web design and development features an integrated team of web project consultants , designers with creative minds, content writers, web programmers and marketing team who have enough experience in web development and design.

Our approach to web design is completely different compared to other web design companies. We do not simply design generic templates that merely display wares to sell. Ours is not a design alone but a design with life.

Contact us today to get a custom package of services that best suit your business’ needs.

Import English and Arabic Country Names to your Database

Nov 10, 2011   //   by sabir   //   Blog  //  3 Comments

With the application provided you can import over 200 country names to your Database from an excel sheet.

Steps to be followed

1. Download excel sheet containing the country names and application Download from Here

2. Change the database connection string in App.config
3. Create a stored procedure to insert the country names into your database
4. Change the procedure call in the application

Test Link Simplified Workflow

Nov 10, 2011   //   by mukthar   //   Blog, QA  //  1 Comment

This is from our QA team.

TestLink is web based Test Management system extensively used by our QA team. The workflow diagram given below might help to understand how Testlink assists in managing test cases preparation and execution.

Amazon EC2 Windows Server IIS , FileZilla and SQL Server Express
 Jul 1, 2011   //   by mukthar   //   Blog  //  7 Comments
This tutorial helps you understand how you could launch an EC2 instance quickly with FTP and SQL Server remote connectivity.
Note:  No method in this tutorial is considered safe and secure. This is just a basic tutorial which will help you setup an EC2 instance quickly, you would probably want to dump this instance in most cases or enhance your security parameters if you plan to continue using the created instance.
Launch an instance
Steps
  • Login to your Amazon EC2 Account
  • Click on Launch Instance
  • Select an Instance from the Quick Start tab. Since we are configuring a windows server, we will select Microsoft Windows Server 2008 R2 with SQL Server Express and IIS
  • In the next tab, select number of instances, Availability Zone.  Remember that EBS volumes may not be available across zones and Instance Type
  • Accept default values in next tab and  click on Continue
  • The next tab (“Create new Key Pair”) is more important because you will be retrieving Windows Administrator password using the Key Pair file you are creating in this tab. You could skip this tab if you already have an existing Key Pair File
  • From the Configure Firewall Tab, create a security group name and continue. Just make a note of the default port rules setup, we will extend this settings for Filezilla server later
     
  • Launch the instance
Reference Links
Setting up Remote Desktop Protocol(RDP)
Steps
  • For connecting to your instance using RDP , you will need to retrieve Administrator password of the instance. For this, select the instance from the Running instances list in EC2 console and select Get Windows Password. You will need the Key Pair file created earlier to decrypt the Administrator password. You may have to wait upto 15 minutes to get Administrator password of a fresh instance
Configuring and Enabling Remote Connectivity in SQL Server ( EC2)
Steps
  • Connect to instance using RDP.
  • By default, the SQL Server Related Services are not enabled and not set to start automatically in Large Instance with SQL Server Express. So you will have to enable SQL Server, SQL Agent  and SQL browser services and make them start automatically from control panel
  • Try connectivity to SQL express from the SQL Server management studio available in the instance. You could use windows Authentication. You will have to browse for the server name and wait for some time till the list of servers are retrieved.
  • Enable login for SA, set a password and try login with SA using SQL server authentication
  • Allow SQL Server to accept incoming connections using Windows Firewall-> Allow a program or Feature through this firewall. The SQL Server Express executable (sqlservr.exe) will be probably located in C:\Program Files\Microsoft SQL Server\MSSQL10_50.EC2SQLEXPRESS\MSSQL\Binn
  • Start SQL Server Configuration manager
  • Select SQL Server Network Configuration
  • Enable TCP/ IP
  • Right click on TCP / IP Properties (“IP Addresses”)
  • In the property sheet , select last Section “IPAll”
  • Remove any text set against “Dynamic Ports”
  • Set 1433 against TCP Port (This port needs to be added as a custom rule for the security group of this instance. As you have seen in the Launch Instance stage, this is automatically done by EC2)
     
  • Try connecting from a remote machine now. The server name is just the public DNS of this instance (or an IP address if you have attached an Elastic IP address to this instance)
Reference Links
Configuring and Enabling   FileZilla FTP Server (EC2)
Steps
  • Connect to instance using RDP.
  • Download File Zilla Server version
  • Install Filezilla. Select default values during installation
  • Start FileZilla server. (First time you may have to set an administrator password)
  • Select Edit -> Settings
  • Select Passive Mode Settings
  • Enable Use Custom Port Range and give values  1024 and 1048. (These ports needs to be added as a custom rule for the security group of this instance).
  • Also enable reteieve external ip address from …
     
  • Allow Filezilla server to accept incoming connections using Windows Firewall-> Allow a program or Feature through this firewall. The Filezilla server executable (FileZilla server.exe) will be probably located in C:\Program Files (x86)\FileZilla Server
  • Add 21(FTP port) under Custom TCP Rule in Security Group of the instance in Amazon EC2 console.
  • Add  1024-1048 under Custom TCP Rule in Security Group of the instance in Amazon EC2 console
  • Create a user name and password from File zilla server interface and try connecting with this information from a remote machine. The ftp host is just the public DNS of this instance (or an IP address if you have attached an Elastic IP address to this instance)
Reference Links
Script to change case of mysql tables
 Jul 1, 2011   //   by mukthar   //   Blog  //  No Comments
Here is  an SQL script that renames all tables in a mysql schema schema to its lower case form.
select concat(‘rename table ‘, table_name, ‘ to  temp’ , ‘;’,'rename table temp to  ’,  lower(table_name), ‘;’ ) from information_schema.tables where table_schema = ‘your-schema’;
The above script generates SQL statements (which you can copy-paste) that will help you to change case of table names to lower.
Best of MVC Links
 Jun 11, 2011   //   by vishnu   //   Blog  //  No Comments
For Starters
MVC Edit Update tutorial
Ajax
Progressive enhancement ajax mvc
Calling Ajax Directly
Unobtrusive Ajax in ASP.NET MVC 3
MVC VALIDATION
BEHAVIOUR AND A TUTORIAL
MVC DEPLOYMENT IN IIS5
OTHER SUGGESTED LINKS IN MVC
NUGET
  • http://nuget.codeplex.com/ - NuGet is a free, open source developer focused package management system for the .NET platform intent on simplifying the process of incorporating third party libraries into a .NET application during development. NuGet is a member of the ASP.NET Gallery.
MVC FILE UPLOADING
JQ Grid in MVC
Membership authentication
ELMAH IN MVC
Handling FAVICON EXCEPTION in ASP.NET MVC
Bookmarklet to test your pages in different screen resolutions
 Apr 15, 2011   //   by mukthar   //   Blog  //  No Comments
Today, we are publishing few bookmarklets which will help you to test your pages in different screen resolutions from same browser  window. Just drag the required links from below list to your browser toolbar and start testing. After opening the page, click on the required bookmarklet to open the page in a new window with the required dimensions.
If you need help installing these bookmarklets, please check the instructions provided at http://www.scholar.com/bookmarklet.dobbb and http://www.jeteye.com/bookmarket.html
Calling a COM component directly from C#
 Apr 15, 2011   //   by mukthar   //   Blog  //  No Comments
This post title could be using SMTPsvg.Mailer component in c# code too:-).
 Recently, we had to call a COM component from C# code. The COM component in question was SMTPsvg.Mailer. Sample code in classic ASP was available. The easiest way to do this method is using Interop. But we were not in a situation to generate interop libraries. We also learned this could have been easier had we used vb.net instead of c#. On further investigation we found two links that helped us to solve the issue:
Sample code showing usage of SMTPsvg.Mailer in c# (you might need to change values in BOLD in the code below).
 
 object objMailer = null;
 System.Type m_MailerType = System.Type.GetTypeFromProgID("SMTPsvg.Mailer");
 objMailer=System.Activator.CreateInstance(m_MailerType);
 m_MailerType.InvokeMember("FromName", System.Reflection.BindingFlags.SetProperty, null, objMailer, new object[] {"FROM_NAME"});
 m_MailerType.InvokeMember("FromAddress", System.Reflection.BindingFlags.SetProperty, null, objMailer, new object[] {"FROM_EMAIL"});
 m_MailerType.InvokeMember("RemoteHost", System.Reflection.BindingFlags.SetProperty, null, objMailer, new object[] {"REMOTE_HOST_NAME"});
 m_MailerType.InvokeMember("Subject", System.Reflection.BindingFlags.SetProperty, null, objMailer, new object[] {“YOUR_SUBJECT”});
 m_MailerType.InvokeMember("BodyText", System.Reflection.BindingFlags.SetProperty, null, objMailer, new object[] {“MAIL_BODY”});
 m_MailerType.InvokeMember("ContentType", System.Reflection.BindingFlags.SetProperty, null, objMailer, new object[] {" Text/HTML "});//Content type, set to Text/HTML for HTML mail need not set this for text mails
 m_MailerType.InvokeMember("AddRecipient", System.Reflection.BindingFlags.InvokeMethod | System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public, null, objMailer, new object[] {“RECEPIENT_NAME”,”RECEPIENT_ADDRESS”); // name value pairs
 bool bReturn = (bool)m_MailerType.InvokeMember("SendMail", System.Reflection.BindingFlags.InvokeMethod | System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public, null, objMailer, null);
 
Be aware that the above method is likely to be slow, but still might be useful in some cases.
Visio Stencils for Web Design and Development
 Apr 15, 2011   //   by mukthar   //   Blog  //  No Comments
A collection of free Visio Stencils that will aid in web design and development
Wireframes
Web GUI Prototypes
User Experience
Process Flow
Sitemap
Navigation icons
Customizing JOMRES Booking Component
 Apr 15, 2011   //   by mukthar   //   Blog  //  No Comments
We recently worked with JOMRES , a hotel booking component for Joomla. We implemented following major changes to the core set of features.
Showing count of rooms by room type in Front End administration, especially in micro managed mode. This helped the client to easily add or remove number of rooms at will depending on demand.
 Customize “Form” Gateway, Modify available card types and add Luhn10 validation on credit card numbers
 Show room type names and count in guest confirmation mails
 Show room type names in black bookings
 Added text box to set supplements by room types in Normal Tariff mode
Pages:12»