public DataSet sp_actualizar_log_inactivo(employees_compensations employee_compensations)
        {
            DataSet             ds             = new DataSet();
            List <SqlParameter> listparameters = new List <SqlParameter>();
            Datos data = new Datos();

            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@employee_number", SqlDbType = SqlDbType.Int, Value = employee_compensations.employee_number
            });
            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@id_bond_type", SqlDbType = SqlDbType.Int, Value = employee_compensations.id_bond_type
            });
            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@id_bond_type_automatic", SqlDbType = SqlDbType.Int, Value = employee_compensations.id_bond_type
            });
            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@UpdateBy", SqlDbType = SqlDbType.Int, Value = employee_compensations.modified_by
            });
            try
            {
                ds = data.enviar("sp_actualizar_log_inactivo", listparameters, false, 4);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(ds);
        }
        public DataSet sp_Insert_Employee_Compensations(employees_compensations employee_compensations)
        {
            DataSet             ds             = new DataSet();
            List <SqlParameter> listparameters = new List <SqlParameter>();
            Datos data = new Datos();

            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@employee_number", SqlDbType = SqlDbType.Int, Value = employee_compensations.employee_number
            });
            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@id_bond_type", SqlDbType = SqlDbType.Int, Value = employee_compensations.id_bond_type
            });
            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@amount", SqlDbType = SqlDbType.Int, Value = employee_compensations.amount
            });
            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@id_periodicity", SqlDbType = SqlDbType.Int, Value = employee_compensations.id_periodicity
            });
            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@created_by", SqlDbType = SqlDbType.Int, Value = employee_compensations.created_by
            });
            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@modified_by", SqlDbType = SqlDbType.Int, Value = employee_compensations.modified_by
            });
            listparameters.Add(new SqlParameter()
            {
                ParameterName = "@Porcentaje", SqlDbType = SqlDbType.Int, Value = employee_compensations.percentage_extra
            });
            try
            {
                ds = data.enviar("sp_Insert_Employee_Compensations", listparameters, false, 4);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(ds);
        }