Code Assistant

systemjs

2021-08-16T01:49:00.002-07:00

module.exports = function(config) {
	config.set({

	// base path that will be used to resolve all patterns (eg. files, exclude)
	basePath: './',

	// frameworks to use
	// available frameworks: https://npmjs.org/browse/keyword/karma-adapter
	frameworks: ['systemjs', 'jasmine'],

	systemjs: {
	configFile: 'config.js',
	config: {
	paths: {
	"typescript": "node_modules/typescript/lib/typescript.js",
	"systemjs": "node_modules/systemjs/dist/system.js",
	'system-polyfills': 'node_modules/systemjs/dist/system-polyfills.js',
	'es6-module-loader': 'node_modules/es6-module-loader/dist/es6-module-loader.js'
	},
	packages: {
	'test/unit': {
	defaultExtension: 'ts'
	},
	'src': {
	defaultExtension: 'ts'
	}
	},
	transpiler: 'typescript'
	},
	serveFiles: [
	'src/*/.ts'
	]
	},

	// list of files / patterns to load in the browser
	files: [
	'test/unit/app.spec.ts'
	],


	// list of files to exclude
	exclude: [],


	// preprocess matching files before serving them to the browser
	// available preprocessors: https://npmjs.org/browse/keyword/karma-preprocessor
	preprocessors: {

	},

	// test results reporter to use
	// possible values: 'dots', 'progress'
	// available reporters: https://npmjs.org/browse/keyword/karma-reporter
	reporters: ['progress'],


	// web server port
	port: 9876,


	// enable / disable colors in the output (reporters and logs)
	colors: true,


	// level of logging
	// possible values: config.LOG_DISABLE \|\| config.LOG_ERROR \|\| config.LOG_WARN \|\| config.LOG_INFO \|\| config.LOG_DEBUG
	logLevel: config.LOG_INFO,


	// enable / disable watching file and executing tests whenever any file changes
	autoWatch: true,


	// start these browsers
	// available browser launchers: https://npmjs.org/browse/keyword/karma-launcher
	browsers: ['PhantomJS'],


	// Continuous Integration mode
	// if true, Karma captures browsers, runs the tests and exits
	singleRun: false
	});
	};

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

test

2021-04-27T03:21:00.006-07:00

module.exports = function(config) {
    config.set({

        basePath: '.',

        frameworks: ['jasmine'],

        files: [
            // paths loaded by Karma
            {pattern: 'node_modules/angular2/bundles/angular2-polyfills.js', included: true, watched: true},
            {pattern: 'node_modules/systemjs/dist/system.src.js', included: true, watched: true},
            {pattern: 'node_modules/rxjs/bundles/Rx.js', included: true, watched: true},
            {pattern: 'node_modules/angular2/bundles/angular2.dev.js', included: true, watched: true},
            {pattern: 'node_modules/angular2/bundles/testing.dev.js', included: true, watched: true},
            {pattern: 'node_modules/angular2/bundles/http.dev.js', included: true, watched: true},
            {pattern: 'karma-test-shim.js', included: true, watched: true},

            // paths loaded via module imports
            {pattern: 'dist/**/*.js', included: false, watched: true},

            // paths to support debugging with source maps in dev tools
            {pattern: 'src/**/*.ts', included: false, watched: false},
            {pattern: 'dist/**/*.js.map', included: false, watched: false}
        ],

        // proxied base paths
        proxies: {
            // required for component assests fetched by Angular's compiler
            '/src/': '/base/src/'
        },

        port: 9876,

        logLevel: config.LOG_INFO,

        colors: true,

        autoWatch: true,

        browsers: ['Chrome'],

        // Karma plugins loaded
        plugins: [
            'karma-jasmine',
            'karma-coverage',
            'karma-chrome-launcher'
        ],

        // Coverage reporter generates the coverage
        reporters: ['progress', 'dots', 'coverage'],

        // Source files that you wanna generate coverage for.
        // Do not include tests or libraries (these files will be instrumented by Istanbul)
        preprocessors: {
            'dist/**/!(*spec).js': ['coverage']
        },

        coverageReporter: {
            reporters:[
                {type: 'json', subdir: '.', file: 'coverage-final.json'}
            ]
        },

        singleRun: true
    })
};

// Tun on full stack traces in errors to help debugging
Error.stackTraceLimit = Infinity;

jasmine.DEFAULT_TIMEOUT_INTERVAL = 1000;

// // Cancel Karma's synchronous start,
// // we will call `__karma__.start()` later, once all the specs are loaded.
__karma__.loaded = function() {};

System.config({
    packages: {
        'base/dist': {
            defaultExtension: false,
            format: 'cjs',
            map: Object.keys(window.__karma__.files).filter(onlyAppFiles).reduce(createPathRecords, {})
        }
    }
});

System.import('angular2/src/platform/browser/browser_adapter')
    .then(function(browser_adapter) { browser_adapter.BrowserDomAdapter.makeCurrent(); })
    .then(function() { return Promise.all(resolveTestFiles()); })
    .then(function() { __karma__.start(); }, function(error) { __karma__.error(error.stack || error); });

function createPathRecords(pathsMapping, appPath) {
    // creates local module name mapping to global path with karma's fingerprint in path, e.g.:
    // './vg-player/vg-player':
    // '/base/dist/vg-player/vg-player.js?f4523daf879cfb7310ef6242682ccf10b2041b3e'
    var moduleName = './' + resolveKeyPathForMapping('base/dist/', appPath);
    moduleName = moduleName.replace(/\.js$/, '');
    pathsMapping[moduleName] = appPath + '?' + window.__karma__.files[appPath];
    return pathsMapping;
}

function onlyAppFiles(filePath) {
    return /\/base\/dist\/(?!.*\.spec\.js$).*\.js$/.test(filePath);
}

function onlySpecFiles(path) {
    return /\.spec\.js$/.test(path);
}

function resolveTestFiles() {
    return Object.keys(window.__karma__.files)  // All files served by Karma.
        .filter(onlySpecFiles)
        .map(function(moduleName) {
            // loads all spec files via their global module names (e.g.
            // 'base/dist/vg-player/vg-player.spec')
            return System.import(moduleName);
        });
}

function resolveKeyPathForMapping(basePathWhereToStart, appPath) {
    var location = appPath.indexOf(basePathWhereToStart);
    if (location > -1) {
        return appPath.substring(basePathWhereToStart.length + 1);
    } else {
        return appPath;
    }
}

Karma Setup

2021-03-25T04:35:00.006-07:00

tslint.json

{
  "compilerOptions": {
    "target": "es5",
    "module": "commonjs",
    "moduleResolution": "node",
    "emitDecoratorMetadata": true,
    "experimentalDecorators": true,
    "allowSyntheticDefaultImports": true,
    "sourceMap": true,
    "noEmit": true,
    "noEmitHelpers": true,
    "importHelpers": true,
    "strictNullChecks": false,
    "lib": [
      "dom",
      "es6"
    ],
    "baseUrl": "./src",
    "paths": {
      "@angular/*": ["node_modules/@angular/*"]
    },
    "typeRoots": [
      "node_modules/@types"
    ],
    "types": [
      "jasmine",
      "node"
    ]
  },
  "exclude": [
    "node_modules",
    "dist"
  ],
  "awesomeTypescriptLoaderOptions": {
    "forkChecker": true,
    "useWebpackText": true
  },
  "compileOnSave": false,
  "buildOnSave": false,
  "atom": {
    "rewriteTsconfig": false
  }
}


base.spec.ts
import "core-js"
import "zone.js/dist/zone";
import "zone.js/dist/long-stack-trace-zone";
import "zone.js/dist/proxy";
import "zone.js/dist/sync-test";
import "zone.js/dist/jasmine-patch";
import "zone.js/dist/async-test";
import "zone.js/dist/fake-async-test";

import { TestBed } from "@angular/core/testing";
import { BrowserDynamicTestingModule, platformBrowserDynamicTesting } from "@angular/platform-browser-dynamic/testing";

TestBed.initTestEnvironment(BrowserDynamicTestingModule, platformBrowserDynamicTesting());

karma.config.js

module.exports = function(config) {
  config.set({

      frameworks: ["jasmine", "karma-typescript"],

      files: [
          { pattern: "base.spec.ts" },
          { pattern: "app/**/*.+(ts|html)" }
      ],

      preprocessors: {
          "**/*.ts": ["karma-typescript"]
      },
      sonarQubeUnitReporter : {
          sonarQubeVersion: '8.x',
          outputFile: 'reports/ut_report.xml',
          overrideTestDescription: true,
          testPath: 'app',
          testFilePattern: '.spec.ts',
          useBrowserName: false
        },
      karmaTypescriptConfig: {
          bundlerOptions: {
              entrypoints: /\.spec\.ts$/,
              transforms: [
                  require("karma-typescript-angular2-transform")
              ]
          },
          compilerOptions: {
              lib: ["ES2015", "DOM"]
          },
          reports: {
            lcovonly: {
              directory: 'coverage',
              filename: 'lcov.info'
            },
            html: 'coverage'
          }
      },

      reporters: ["progress","coverage","dots","sonarqubeUnit", "karma-typescript"],
      
        coverageReporter: {
          type: 'in-memory'
        },
      browsers: ["Chrome"],

      singleRun: false,
      plugins: [
          require('karma-sonarqube-unit-reporter'),
          require('karma-typescript'),
          require('karma-coverage'),
          require('karma-jasmine'),
          require('karma-chrome-launcher')
          
        ],
  });
};

Important Notepad++ Tips

2015-02-16T21:37:00.002-08:00

Remove All Comments from Notepad++

http://stackoverflow.com/questions/8748313/is-there-a-way-to-delete-all-comments-in-a-file-using-notepad

Remove all between brackets http://stackoverflow.com/questions/11679753/notepad-regular-expression-remove-all-text-between-curly-brackets

Remove Blank lines http://stackoverflow.com/questions/3866034/removing-empty-lines-in-notepad

const getHostnameFromRegex = (url) => {
  // run against regex
  const matches = url.match(/^https?\:\/\/([^\/?#]+)(?:[\/?#]|$)/i);
  // extract hostname (will be null if no match is found)
  return matches && matches[1];
}

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Important SQL Codes

2015-02-16T21:35:00.000-08:00

GET ROWCOUNTS FOR ALL TABLES

SELECT

[TableName] = so.name,

[RowCount] = MAX(si.rows)

FROM sysobjects so,

sysindexes si

WHERE so.xtype = 'U'

AND si.id = OBJECT_ID(so.name)

GROUP BY so.name

ORDER BY 2 DESC

GET REFERENCES OF DATABASE OBJECTS

SELECT OBJECT_NAME (referencing_id) AS referencing_object, referenced_database_name,

referenced_schema_name, referenced_entity_name

FROM sys.sql_expression_dependencies

WHERE referenced_database_name IS NOT NULL

AND is_ambiguous = 0

ORDER BY referenced_entity_name desc

SELECT DISTINCT so.name

FROM syscomments sc

INNER JOIN sysobjects so ON sc.id=so.id

WHERE sc.TEXT LIKE '%TableName%'

DETERMINE WHEN A STORED PROCEDURE WAS CREATED AND LAST ALTERED

select

SPECIFIC_NAME AS procedureName,

SPECIFIC_CATALOG AS databaseName,

CREATED AS createDate,

LAST_ALTERED as lastAlteredDate

from

information_schema.routines

where routine_name = '<Procedure Name Here>'

FIND COLUMN IN ALL TABLES

SELECT t.name AS table_name,

SCHEMA_NAME(schema_id) AS schema_name,

c.name AS column_name

FROM sys.tables AS t

INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID

WHERE c.name LIKE '%ColumnName%'

ORDER BY schema_name, table_name

UDPATE WITH JOIN

UPDATE

tbl_User

SET

sShortUserID = sui.sShortUserID

FROM

tbl_User u

JOIN

tbl_ShortUserIDs sui ON u.uSystemUserID=sui.uSystemUserID

select u.uSystemUserID,u.sShortUserID,sui.uSystemUserID,sui.sShortUserID FROM

tbl_User u

JOIN

tbl_ShortUserIDs sui ON u.uSystemUserID=sui.uSystemUserID

REPLACE IN A ROW

UPDATE dbo.tbl_UserLiveStreamPlayback

SET sPlaybackURL = REPLACE(sPlaybackURL,'SourceText','ReplaceByText')

SELECT SP CONTAINING SPECIFIC TEXT

SELECT OBJECT_NAME(id)

FROM syscomments

WHERE [text] LIKE '%TextToSearch%'

AND OBJECTPROPERTY(id, 'IsProcedure') = 1

GROUP BY OBJECT_NAME(id)

TO COUNT NUMBER OF TABLES IN A DB

SELECT [TABLECOUNT] = COUNT(OBJ.ID) FROM SYSOBJECTS OBJ WHERE XTYPE='U'

TO COUNT NUMBER OF STORED PROCEDURES IN A DB

SELECT [SPCOUNT] = COUNT(OBJ.ID) FROM SYSOBJECTS OBJ WHERE XTYPE='P'

GET LIST OF TABLES NAMES AND THEIR ROW COUNTS

SELECT [TABLENAME] = OBJ.NAME, [ROWCOUNT] = MAX(SI.ROWS) FROM SYSOBJECTS OBJ,

SYSINDEXES SI WHERE OBJ.XTYPE = 'U' AND SI.ID = OBJECT_ID(OBJ.NAME)

GROUP BY OBJ.NAME ORDER BY [ROWCOUNT] DESC

GET COLUMNS NAMES, DATA TYPES, IS NULLABLE OF A PARTICULAR TABLE

SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE + CASE ISNULL(CHARACTER_MAXIMUM_LENGTH,'')

WHEN '' THEN '' ELSE ' (' + CAST (CHARACTER_MAXIMUM_LENGTH AS VARCHAR(6)) + ')'

END AS [DATA TYPE], CASE IS_NULLABLE WHEN 'YES' THEN 'NULL' ELSE 'NOT NULL'

END AS [NULL OR NOT] FROM INFORMATION_SCHEMA.COLUMNS WHERE

TABLE_NAME = 'L_SAMPLE' ORDER BY TABLE_NAME, COLUMN_NAME

TO SEE THE DEFINITION OF A SP

EXEC SP_HELPTEXT GET_USER_DATA

GET TABLES CREATION AND MODIFIED DATES

SELECT [TABLENAME] = NAME, CREATE_DATE, MODIFY_DATE FROM SYS.OBJECTS

WHERE TYPE = 'U' --AND NAME LIKE '%L_%'

ORDER BY MODIFY_DATE DESC

GET STORED PROCEDURES CREATION AND MODIFIED DATES

SELECT [SPNAME] = NAME, CREATE_DATE, MODIFY_DATE FROM SYS.OBJECTS

WHERE TYPE = 'P' --AND NAME LIKE '%GET%'

ORDER BY MODIFY_DATE DESC

GET TABLES THAT ARE NOT USED

select t.name, sys.objects.name foundin, sys.objects.type_desc

from sys.objects t

left outer join

sys.sql_modules

inner join sys.objects on sys.objects.object_id = sys.sql_modules.object_id

on sys.sql_modules.definition like '%' + t.name + '%'

where t.type = 'U'

and sys.objects.name is null

order by t.name, type_desc, foundin

FIND MOST EXPENSIVE STORED PROCEDURE

SELECT DB_NAME(SQTX.DBID) AS [DBNAME]

,OBJECT_SCHEMA_NAME(SQTX.OBJECTID, DBID) AS [SCHEMA]

,OBJECT_NAME(SQTX.OBJECTID, DBID) AS [STORED PROC]

,MAX(CPLAN.USECOUNTS) [EXEC COUNT]

FROM SYS.DM_EXEC_CACHED_PLANS CPLAN

CROSS APPLY SYS.DM_EXEC_SQL_TEXT(CPLAN.PLAN_HANDLE) SQTX

WHERE DB_NAME(SQTX.DBID) IS NOT NULL

AND CPLAN.OBJTYPE = 'PROC'

GROUP BY CPLAN.PLAN_HANDLE

,DB_NAME(SQTX.DBID)

,OBJECT_SCHEMA_NAME(OBJECTID, SQTX.DBID)

,OBJECT_NAME(OBJECTID, SQTX.DBID)

ORDER BY MAX(CPLAN.USECOUNTS) DESC

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Apple Push Notification via Amazon SNS

2014-11-07T01:24:00.004-08:00

Hello all,

Here i come with the best way to send the push notifications to iOS devices using Amazon Simple Notification Services in C# .Net

So here is the snippet that can push the notification very easily..

string[] strTokens = txtTokens.Text.Split(','); // Get all tokens to send the code
Parallel.ForEach(strTokens , sToken =>
{
HttpContext ctx = HttpContext.Current;
new System.Threading.Thread(() =>
{
HttpContext.Current = ctx;
SendNotificationAsync(sToken , "Your Notification Message" , 0 , "default");
}).Start();
});

public void SendNotificationAsync(string sToken , string sMessage , int iBadge , string sSound)
{
try
{
string Platform = ConfigurationManager.AppSettings["Platform"];// Application Platform
string ApplicationName = ConfigurationManager.AppSettings["ApplicationName"];//Application Name configured on SNS
string PlatformApplicationArn = ConfigurationManager.AppSettings["PlatformApplicationArn"];

AmazonSimpleNotificationServiceClient objsnsClient = new AmazonSimpleNotificationServiceClient("AWSAccessKey" , "AWSSecretKey" , "Region");
var objResponse = objsnsClient.CreatePlatformEndpointExtended(new CreatePlatformEndpointRequest
{
Token = sToken ,
PlatformApplicationArn =
PlatformApplicationArn
});

Dictionary<string , string> CustomParams = new Dictionary<string , string>();
CustomParams.Add("default" , sMessage);
CustomParams.Add("" + Platform + "" , "{\"aps\":{\"alert\": \"" + sMessage + "\",\"sound\" :\"" + sSound + "\"},\"ShortUserID\":\"123456\",\"NotificationType\":\"10\"}");
objsnsClient.Publish(new PublishRequest
{
Message = JsonConvert.SerializeObject(CustomParams) ,
MessageStructure = "json" ,
TargetArn = objResponse.EndpointArn
});
}
catch (Exception ex)
{
}
}

Ravi Tuvar – IntelliMedia Networks

Technical Manager

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Concatenate rows with comma separated string

2012-11-05T23:42:00.004-08:00

Hey friends,

Here i am sharing a cool stuff for SQL Developers

Please use the following query when concatenate multiple rows with a single comma separated string(row)

 DECLARE @iXml xml;
 
    SELECT @iXml = (
      SELECT ProductName + ','
      FROM Northwind.dbo.Products
      FOR XML PATH);
 
    SELECT @iXml.value('.','nvarchar(max)');

or the other way is

 SELECT STUFF((SELECT ',' + RTRIM(ProductName ) FROM Products FOR XML PATH('')),1,1,'') AS 'Products'



Now this block will return a string with comma separated rows..

If you want to get the distinct values with comma separated row..

Then do this

 DECLARE @iXml xml;
 
    SELECT @iXml = (
      SELECT distinct ProductName + ','
      FROM Northwind.dbo.Products
      FOR XML PATH);
 
    SELECT @iXml.value('.','nvarchar(max)');

OR:

 SELECT STUFF((SELECT Distinct ',' + RTRIM(ProductName ) FROM Products FOR XML PATH('')),1,1,'') AS 'Products'

Thanks

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Still india is a 3rd world country why?

2012-09-16T21:46:00.004-07:00

Still India is a 3rd World Country, Why?

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Ten hidden controls of the iPhone headphones

2012-08-20T22:41:00.000-07:00

It's never too late to discover that those boring, all-white headphones Apple threw in with your iPhone can do a lot more than adjust the volume.

In fact, any headphones that include a remote (or have a remote adapter attached) can be used to control your iPhone, iPad, or iPod Touch in up to 10 ways.

Thanks to this post by Business Insider, here are all the ways you can use your headphones as a remote controller, allowing you to perform useful functions without taking your iDevice out of your pocket.

If you're listening to music, toggle pause or play by tapping the center button once.
To fast-forward a song, tap the center button twice and long-press on the second tap.
To rewind a song, tap three times and long-press on the third tap.
To skip a song, double tap.
To go to the previous song, triple tap.
If you have an incoming call, tap the center button once to answer. Tap again to hang up.
To ignore an incoming call, long-press the center button. You'll hear two beeps to confirm that the caller was sent to voice mail.
If you're on the phone and you get a new call, tap the center button once to switch calls. To end that new call, hold the center button down for 2 seconds.
You can achieve supersteady shots by using your headphones as a shutter release. Tap the volume-up button to capture a photo.
For iPhone 4S owners: prompt Siri by long-pressing the center button.

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Test Sort Function

2012-06-08T08:13:00.001-07:00

function naturalSort(a, b) {
   a = a.path.toLowerCase();
   b = b.path.toLowerCase();
   var re = /(^-?[0-9]+(\.?[0-9]*)[df]?e?[0-9]?$|^0x[0-9a-f]+$|[0-9]+)/gi,
  sre = /(^[ ]*|[ ]*|[_]*$)/g,
  dre = /(^([\w ]+,?[\w ]+)?[\w ]+,?[\w ]+\d+:\d+(:\d+)?[\w ]?|^\d{1,4}[\/\-]\d{1,4}[\/\-]\d{1,4}|^\w+, \w+ \d+, \d{4})/,
  hre = /^0x[0-9a-f]+$/i,
  ore = /^0/,
   // convert all to strings and trim()
  x = a.toString().replace(sre, '') || '',
  y = b.toString().replace(sre, '') || '',
   // chunk/tokenize
  xN = x.replace(re, '\0$1\0').replace(/\0$/, '').replace(/^\0/, '').split('\0'),
  yN = y.replace(re, '\0$1\0').replace(/\0$/, '').replace(/^\0/, '').split('\0'),
   // numeric, hex or date detection
  xD = parseInt(x.match(hre)) || (xN.length != 1 && x.match(dre) && Date.parse(x)),
  yD = parseInt(y.match(hre)) || xD && y.match(dre) && Date.parse(y) || null;
   // first try and sort Hex codes or Dates
   if (yD)
    if (xD < yD) return -1;
    else if (xD > yD) return 1;
   // natural sorting through split numeric strings and default strings
   for (var cLoc = 0, numS = Math.max(xN.length, yN.length); cLoc < numS; cLoc++) {
    // find floats not starting with '0', string or 0 if not defined (Clint Priest)
    oFxNcL = !(xN[cLoc] || '').match(ore) && parseFloat(xN[cLoc]) || xN[cLoc] || 0;
    oFyNcL = !(yN[cLoc] || '').match(ore) && parseFloat(yN[cLoc]) || yN[cLoc] || 0;
    // handle numeric vs string comparison - number < string - (Kyle Adams)
    if (isNaN(oFxNcL) !== isNaN(oFyNcL)) return (isNaN(oFxNcL)) ? -1 : 1;
    // rely on string comparison if different types - i.e. '02' < 2 != '02' < '2'
    else if (typeof oFxNcL !== typeof oFyNcL) {
     oFxNcL += '';
     oFyNcL += '';
    }
    if (oFxNcL <= oFyNcL) return -1;
    if (oFxNcL >= oFyNcL) return 1;
   }
   return 0;
  }

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Clear data in dropdown list using jQuery

2012-05-04T04:15:00.002-07:00

Hey friends so many times we need to clear the data in a dropdown list or list box...

So here is the way to remove all data frop dropdown list..!

$('#selectlist option').each(function(i, option){ $(option).remove(); });

Hope you enjoyed...

" There are two ways of constructing a software design: One way is to make it so simple that there are obviously no deficiencies and the other way is to make it so complicated that there are no obvious deficiencies. "

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Superb Advice from Father ...!!

2012-04-30T21:20:00.006-07:00

Following is a letter to his son from a renowned Hong Kong TV broadcaster cum Child Psychologist.

The words are actually applicable to all of us, young or old, children or

parents.!

I am writing this to you because of 3 reasons

1. Life, fortune and mishaps are unpredictable, nobody knows how long he

lives. Some words are better said early.

2. I am your father, and if I don't tell you these, no one else will.

3. What is written is my own personal bitter experiences that perhaps

could save you a lot of unnecessary heartaches.

Remember the following as you go through life

1. Do not bear grudge towards those who are not good to you. No one has

the responsibility of treating you well, except your mother and I.

To those who are good to you, you have to treasure it and be thankful, and

ALSO you have to be cautious, because, everyone has a motive for every

move.

When a person is good to you, it does not mean he really likes you. You

have to be careful, don't hastily regard him as a real friend.

2. No one is indispensable, nothing in the world that you must possess.

Once you understand this idea, it would be easier for you to go through

life when people around you don't want you anymore, or when you lose

what/who you love most.

3. Life is short. When you waste your life today, tomorrow you would find

that life is leaving you. The earlier you treasure your life, the better

you enjoy life.

4. Love is but a transient feeling, and this feeling would fade with time

and with one's mood.

If your so called loved one leaves you, be patient, time will wash away

your aches and sadness. Don't over exaggerate the beauty and sweetness of

love, and don't over exaggerate the sadness of falling out of love.

5. A lot of successful people did not receive a good education, that does

not mean that you can be successful by not studying hard!

Whatever knowledge you gain is your weapon in life. One can go from rags

to riches, but one has to start from some rags!

6. I do not expect you to financially support me when I am old, neither

would I financially support your whole life.

My responsibility as a supporter ends when you are grown up.

After that, you decide whether you want to travel in a public transport or

in your limousine, whether rich or poor.

7. You honour your words, but don't expect others to be so.

You can be good to people, but don't expect people to be good to you. If

you don't understand this, you would end up with unnecessary troubles.

8. I have bought lotteries for umpteen years, but I never strike any

prize.

That shows if you want to be rich, you have to work hard!

There is no free lunch!

9. No matter how much time I have with you, let's treasure the time we

have together. We do not know if we would meet again in our next life .

Your Ever loving Dad.

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Code Assistant Blog stats....

2012-03-29T22:28:00.000-07:00

Dear friends,

Here is the worldwide audience statistics for CodeAssistant

Thanks all for your best response...!
It inspire me to go ahead with the best posts ever..!

Thank you,

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Derivations Of Words..

2012-03-29T22:22:00.002-07:00

[1] NEWS - refers to information from Four directions N, E, W and S.

[2] POP MUSIC - is 'Popular Music' shortened.

[3] TIPS - come from 'To Insure Prompt Service'. In olden days to get Prompt service from servants in an inn, travelers used to drop coins in a Box on which was written 'To Insure Prompt Service'. This gave rise to the custom of Tips.

[4] MOPED - is the short term for 'Motorized Pedaling'.

[5] BUS - is the short term for 'Omnibus' that means everybody.

[6] FORTNIGHT - comes from 'Fourteen Nights' (Two Weeks).

[7] DRAWING ROOM - was actually a 'withdrawing room' where people withdrew after Dinner. Later the prefix 'with' was dropped.

[8] AG-MARK, - which some products bear, stems from 'Agricultural Marketing'.

[9] JOURNAL - is a diary that tells about 'Journey for a day' during each Day's business.

[10] QUEUE - comes from 'Queen's Quest'. Long back a long row of people as waiting to see the Queen. Someone made the comment Queen's Quest.

[11] JEEP - is a vehicle with unique Gear system. It was invented during World War II (1939-1945). It was named 'General Purpose Vehicle (GP)'. GP was changed into JEEP later.

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Its You-Inspiration

2012-03-29T22:21:00.003-07:00

One day not too long ago the employees of a large company in St. Louis , Missouri returned from their lunch break and were greeted with a sign on the front door.

The sign said: "Yesterday the person who has been hindering your growth in this company passed away. We invite you to join the funeral in the room that has been prepared in the gym."

At first everyone was sad to hear that one of their colleagues had died, but after a while they started getting curious about who this person might be. The excitement grew as the employees arrived at the gym to pay their last respects.

Everyone wondered: "Who is this person who was hindering my progress? Well, at least he’s no longer here!"

One by one the employees got closer to the coffin and when they looked inside it they suddenly became speechless. They stood over the coffin, shocked and in silence, as if someone had touched the deepest part of their soul.

There was a mirror inside the coffin: everyone who looked inside it could see himself. There was also a sign next to the mirror that said:

"There is only one person who is capable to set limits to your growth: it is YOU."

YOU are the only person who can revolutionize your life.

YOU are the only person who can influence your happiness, your realization and your success.

YOU are the only person who can help yourself.

Your life does not change when your boss changes, when your friends change, when your parents change, when your company changes.

Your life changes when YOU change, when you go beyond your limiting beliefs, when you realize that YOU ARE the only one responsible for your life.

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Learn from this guy.. A legend..!

2012-03-29T06:55:00.001-07:00

Get the text here..! Njoy

Ravi Tuvar – IntelliMedia Networks

Software Developer

Cell: (+91) 73837-94530

Email: ravituvar@yahoo.com

Browser showing white block

2012-03-29T05:04:00.002-07:00

Hi friends so many time we found that while browsing video or other objects the white or black box sticks on the screen.

After googling this on internet and in my mind as well i found this workout..

This issue basically found in iframe or div objects so whenever it seems on your browser the following tip can solve your problem.

<html>
<iframe id="iFrameId">
</iframe>
<script>
   
window.onbeforeunload = function() {
          document.getElementById("iframeordivID").style.visibility = "hidden";
    }
</script>
</html>







Happy javaScripting...!

Thanks to all..!

2012-03-28T23:42:00.001-07:00

Hello friends 4,471 clicks so far and not its going to sky nowadays..so this post is specially to thank all visitors..

Thanks keep visiting..!

Some words by Buffet

2012-03-26T23:27:00.000-07:00

Longest Word: Which Is Biggest In English Language?

2012-03-26T22:30:00.002-07:00

Allow on numbers onKeyDown event in javascript

2012-03-22T03:47:00.002-07:00

So here is the function to to validate the Numbers only in the input box.

function ValidatePort(event) {
if (event.keyCode == 46 || event.keyCode == 8 || event.keyCode == 9 || event.keyCode == 27 ||
// Allow: Ctrl+A
(event.keyCode == 65 && event.ctrlKey === true) ||
// Allow: home, end, left, right
(event.keyCode >= 35 && event.keyCode <= 39)) {
// let it happen, don't do anything
return;
}
else {
// Ensure that it is a number and stop the keypress
if ((event.keyCode < 48 || event.keyCode > 57) && (event.keyCode < 96 || event.keyCode > 105)) {
event.preventDefault();
}
}
}

declaring this method in Script part assign it to the control..like this and ur done..!

<input type="text" class="input" id="txtPortRA" onkeydown="ValidatePort(event)" />

NJoyyyyy..!!!!

Validate IP Address in javacript or jquery

2012-03-22T03:45:00.001-07:00

Hi friends here is the best way to check that the input IPAddress is valid or not..!

so use this method to check it out..!
Write this method in the Script area and follow the steps..!
function verifyIP(IPvalue) {
errorString = "";
theName = "IPaddress";

var ipPattern = /^(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})$/;
var ipArray = IPvalue.match(ipPattern);

if (IPvalue == "0.0.0.0")
errorString = errorString + theName + ': ' + IPvalue + ' is a special IP address and cannot be used here.';
else if (IPvalue == "255.255.255.255")
errorString = errorString + theName + ': ' + IPvalue + ' is a special IP address and cannot be used here.';
if (ipArray == null)
errorString = errorString + theName + ': ' + IPvalue + ' is not a valid IP address.';
else {
for (i = 0; i < 5; i++) {
thisSegment = ipArray[i];
if (thisSegment > 255) {
errorString = errorString + theName + ': ' + IPvalue + ' is not a valid IP address.';
i = 4;
}
if ((i == 0) && (thisSegment > 255)) {
errorString = errorString + theName + ': ' + IPvalue + ' is a special IP address and cannot be used here.';
i = 4;
}
}
}
extensionLength = 3;
if (errorString == "") {
//jAlert("That is a valid IP address.");
//jAlert('That is a valid IP address.', 'VBrick');
return true
}
else {
jAlert(errorString, 'VBrick');
return false
}
}

-> isValidIp = verifyIP(ipAddress)

-> now check whether the ipaddress is valid or not using the isValidIP..

if the isValidIp == true then the address is correct otherwise its false..!

Facebook Connect Test

2012-03-21T00:58:00.001-07:00

Hi friends this is the test post to check whether the post is connected to the facebook ot not...?

Learning...

2012-03-20T23:22:00.000-07:00

Hi friends,

Nowadays the learning sessions are going on and the technologies are jQuery, WCF Services, JSON, Linq and the web services..so coming with new techKnowledge posts..!

hope you'll enjoy it.....hhuuuuuuuaaaaaaaaaah

Not In SQL, with multiple columns

2012-03-01T05:06:00.002-08:00

The following pseudoquery is ANSI SQL, but will not work in
MS SQL because I could not use multiple columns in a NOT IN subquery.
How can I get this result set using Transact-SQL? I keep getting
lost trying to figure it out.

SELECT Field1, Field2, Field3, Field4
FROM Table1
WHERE
Field5 = 'Param1'
AND Field1, Field2
NOT IN
(SELECT Field1, Field2
FROM Table2
WHERE Field6 = 'Param2')

So here is the way how can we do this in SQL..

Solution:

select Field1, Field2, Field3, Field4from Table1 T1
where not exists (
SELECT Field1, Field2
FROM Table2 T2
where T2.Field1 = T1. Field1 and T2 .Field2 = T1 .Field2
)

Code Assistant

systemjs

test

Karma Setup

Important Notepad++ Tips

Important SQL Codes

Apple Push Notification via Amazon SNS

Concatenate rows with comma separated string

Hey friends,

or the other way is

SELECT STUFF((SELECT ',' + RTRIM(ProductName ) FROM Products FOR XML PATH('')),1,1,'') AS 'Products' Now this block will return a string with comma separated rows..

Now this block will return a string with comma separated rows..

If you want to get the distinct values with comma separated row..

Then do this

DECLARE @iXml xml; SELECT @iXml = ( SELECT distinct ProductName + ',' FROM Northwind.dbo.Products FOR XML PATH); SELECT @iXml.value('.','nvarchar(max)'); OR: SELECT STUFF((SELECT Distinct ',' + RTRIM(ProductName ) FROM Products FOR XML PATH('')),1,1,'') AS 'Products' Thanks

Still india is a 3rd world country why?

Ten hidden controls of the iPhone headphones

Test Sort Function

Clear data in dropdown list using jQuery

Superb Advice from Father ...!!

Code Assistant Blog stats....

Derivations Of Words..

Its You-Inspiration

Learn from this guy.. A legend..!

Browser showing white block

Thanks to all..!

Some words by Buffet

Longest Word: Which Is Biggest In English Language?

Allow on numbers onKeyDown event in javascript

Validate IP Address in javacript or jquery

Facebook Connect Test

Learning...

Not In SQL, with multiple columns

SELECT STUFF((SELECT ',' + RTRIM(ProductName ) FROM Products FOR XML PATH('')),1,1,'') AS 'Products'

Now this block will return a string with comma separated rows..

DECLARE @iXml xml; SELECT @iXml = ( SELECT distinct ProductName + ',' FROM Northwind.dbo.Products FOR XML PATH); SELECT @iXml.value('.','nvarchar(max)');

OR:

SELECT STUFF((SELECT Distinct ',' + RTRIM(ProductName ) FROM Products FOR XML PATH('')),1,1,'') AS 'Products'

Thanks