C#

CREATE TABLE `salary_slip_category` (
  `salary_slip_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `salary_slip_category_name` varchar(255) DEFAULT NULL,
  `salary_slip_category_plus_or_minus` varchar(1) DEFAULT NULL,
  `salary_slip_category_default_description` varchar(255) DEFAULT NULL,
  `salary_slip_category_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`salary_slip_category_id`),
  KEY `idx_salary_slip_category_salary_slip_category_name` (`salary_slip_category_name`),
  KEY `idx_salary_slip_category_salary_slip_category_plus_or_minus` (`salary_slip_category_plus_or_minus`),
  KEY `idx_salary_slip_category_salary_slip_category_default_descriptio` (`salary_slip_category_default_description`),
  KEY `idx_salary_slip_category_salary_slip_category_order` (`salary_slip_category_order`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

CREATE TABLE `salary_slip_details` (
  `salary_slip_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_number` int(11) DEFAULT NULL,
  `is_benefit` bit(1) DEFAULT b'0',
  `salary_slip_details_order` int(11) DEFAULT '999',
  `trxn_code` varchar(50) DEFAULT NULL,
  `salary_slip_id` int(11) DEFAULT NULL,
  `salary_slip_code` int(11) DEFAULT NULL,
  `salary_slip_month` int(11) DEFAULT NULL,
  `salary_slip_year` int(11) DEFAULT NULL,
  `salary_slip_details_category` varchar(255) DEFAULT NULL,
  `salary_slip_category_plus_or_minus` varchar(1) DEFAULT NULL,
  `salary_slip_details_description` varchar(255) DEFAULT NULL,
  `salary_slip_details_amount` double(10,3) DEFAULT NULL,
  `salary_slip_details_released` bit(1) DEFAULT b'0',
  PRIMARY KEY (`salary_slip_details_id`),
  KEY `idx_salary_slip_details_employee_number` (`employee_number`),
  KEY `idx_salary_slip_details_is_benefit` (`is_benefit`),
  KEY `idx_salary_slip_details_salary_slip_details_order` (`salary_slip_details_order`),
  KEY `idx_salary_slip_details_trxn_code` (`trxn_code`),
  KEY `idx_salary_slip_details_salary_slip_id` (`salary_slip_id`),
  KEY `idx_salary_slip_details_salary_slip_code` (`salary_slip_code`),
  KEY `idx_salary_slip_details_salary_slip_month` (`salary_slip_month`),
  KEY `idx_salary_slip_details_salary_slip_year` (`salary_slip_year`),
  KEY `idx_salary_slip_details_salary_slip_details_category` (`salary_slip_details_category`),
  KEY `idx_salary_slip_details_salary_slip_category_plus_or_minus` (`salary_slip_category_plus_or_minus`),
  KEY `idx_salary_slip_details_salary_slip_details_description` (`salary_slip_details_description`),
  KEY `idx_salary_slip_details_salary_slip_details_amount` (`salary_slip_details_amount`),
  KEY `idx_salary_slip_details_salary_slip_details_released` (`salary_slip_details_released`)
) ENGINE=InnoDB AUTO_INCREMENT=171 DEFAULT CHARSET=utf8;

CREATE TABLE `employee` (
  `employee_number` int(11) NOT NULL AUTO_INCREMENT,
  `id_number` varchar(255) DEFAULT NULL,
  `employee_name` varchar(255) DEFAULT NULL,
  `employee_gender` varchar(11) DEFAULT NULL,
  `employee_designation` varchar(255) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `employee_email` varchar(255) DEFAULT NULL,
  `employee_mobile` varchar(255) DEFAULT NULL,
  `employee_home_tel` varchar(255) DEFAULT NULL,
  `date_of_join` date DEFAULT NULL,
  `last_working_date` date DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_account` varchar(50) DEFAULT NULL,
  `current_employee` bit(1) DEFAULT b'1',
  `is_active` bit(1) DEFAULT b'1',
  `login_password` varchar(255) DEFAULT NULL,
  `login_pin` varchar(4) DEFAULT NULL,
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`employee_number`),
  KEY `idx_employee_id_number` (`id_number`),
  KEY `idx_employee_employee_name` (`employee_name`),
  KEY `idx_employee_employee_gender` (`employee_gender`),
  KEY `idx_employee_employee_designation` (`employee_designation`),
  KEY `idx_employee_date_of_birth` (`date_of_birth`),
  KEY `idx_employee_employee_email` (`employee_email`),
  KEY `idx_employee_employee_mobile` (`employee_mobile`),
  KEY `idx_employee_employee_home_tel` (`employee_home_tel`),
  KEY `idx_employee_date_of_join` (`date_of_join`),
  KEY `idx_employee_last_working_date` (`last_working_date`),
  KEY `idx_employee_bank_name` (`bank_name`),
  KEY `idx_employee_bank_account` (`bank_account`),
  KEY `idx_employee_current_employee` (`current_employee`),
  KEY `idx_employee_s_active` (`is_active`),
  KEY `idx_employee_login_password` (`login_password`),
  KEY `idx_employee_login_pin` (`login_pin`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;

1. every employee will have one row.

2. Categories will be shown as columns and total amount of the category will be shown there

try
                {
                    Sftp sftp = new Sftp(sftpServer, sftpUserName);
                    sftp.Password = sftpPassword;
                    sftp.OnTransferProgress += new FileTransferEvent(sftp_OnTransferProgress);
                    sftp.OnTransferStart += new FileTransferEvent(sftp_OnTransferStart);
                    sftp.Connect(22);
                    if (sftp.Connected)
                    {
                        DateTime now = DateTime.Now;
                        string year = now.Year.ToString();
                        string month = now.Month.ToString();
                        if (month.Length < 2) { month = "0" + month; }
                        Log("Attempting to download all files from todalton directory for the current month");
                        sftp.Get("balance//todalton//daltonAutoload" + year + month + "*", @"C:\higherone\");
//sftp.Close();
                        Log("Transfer Complete");
                    }
                }
                catch (Tamir.SharpSsh.jsch.SftpException)
                {
                    Log("No files of the given criteria exist on the server.\r\n\t\tDownload aborted."
                        + "\r\n\t :NOTE: If this is the first run of the month, this is the expected behavior.");
                }
                catch (Exception ex)
                {
                    Log(ex.Message + " :NOTE: sftp connection failed during download");
                }
                finally
                {
                    sftp.Close();
                }