Everything is Awesome!: October 2016

Saturday, 22 October 2016

Technical Key Concepts - Good to Learn

WCF
OperationContext
MsgInspector
mexhttpbindings
how to implement transaction
instancing

SQL
CTE
covering indexes
Table hints

LINQ
Partial Methods

MVC
Viewbag(datatype req?)/ViewData
action filters/filters

General

ASP.Net latest framework, MVC, LINQ, OOPS, NUnit test case

Try and understand Structure Map, Rhino Mock, Dependency Injection

MVC

Adv. Of MVC

Routing

Validation

- Data Annotations, Custom Validations

Razor – MVC3

Filters

ActionResults Type

How to pass data in MVC between views-2-controller [expect situation question]

- Model, ViewBag, Viewdata, TempData

Helper Functions/Custom Helper Functions

Master Pages

Autohrizations

Partial View

- Html.RenderAction, Html.RenderPartial, Html.Partial, Html.Action

Security in MVC

General

tcpbindings - intranet (secure or not)

diff in 3.5 and 4.0

throw ex; throw;

what to pass in httpheaders

compression technique/viewstate removal

page events

diff. in clustered/unclustered, covering index

sql2008 -> tbl params, replacement of cursor

all diff. in func & SP

delete-truncate with logging data

cascading-referential integrity

behaviuor settings - maxmsglimit

WCF service - username/pwd based

IActionFilter & IActionSelector

What is User Story-Agile

calling code metod from JS - asmx service

SSRS - fieldexpression, caching, dynamic datasource, types of report worked on

WCF

===================================

Instance Modes -> Session

Duplex

SOA Based WCF

Message Patterns

WPF

============

MVVM pattern

Dependency Properties

INotifyPropertyChange

Routed Events

Observable Collections

Binding in WPF

User Controls

Commands

Prism

=================

Boot Strapper

Shell

Module Catelog

DI (unity/MEF)

Event Aggregator

Useful IT Blog Links

How to use Trello for Skill Management
http://buildingbettersoftware.blogspot.com/search?q=trello

Joe Eames pluralsight course content:
https://github.com/joeeames/AngularFundamentalFiles

Trello Info for Skill Matrix:
http://buildingbettersoftware.blogspot.com/search?q=trello

Javascript:
http://aaron.powell.com
http://twitter.com/slace

Technical Blogs:
WindowsCommunicationFoundation(WCF)Samples
Ido Flatow's Blog

10 Tips for Learning a New Technology

Thursday, 13 October 2016

Send Mail using Outlook and Javascript

I was developing an Internal application and need to send mail using local Outlook profile but something that allow HTML formatted contents. I ran into a easy Javascript option to do it as follows:

Prerequisite:

The Client User machine should have Outlook installed and should have an Outlook profile.

Note:

This will work only in IE (Internet Explorer) browser, So it is suitable only for Internal Application.
The Browser setting should allow ActiveX object creation or the User will be prompted to allow the access.

<html>
<script>
function SendMailVarBased(emailid, subject, htmlBody) {
try {
//get outlook and create new email
var outlook = new ActiveXObject('Outlook.Application');
var email = outlook.CreateItem(0);

//add some recipients
email.Recipients.Add(emailid).Type = 1; //1=To
//email.Recipients.Add('user2@company.com').Type = 2; //2=CC

//subject and attachments
email.Subject = subject;
//email.Attachments.Add('URL_TO_FILE', 1); //1=Add by value so outlook downloads the file from the url

// display the email (this will make the signature load so it can be extracted)
email.Display();

//use a regular expression to extract the html before and after the signature
var signatureExtractionExpression = new RegExp('/[^~]*(<BODY[^>]*>)([^~]*</BODY>)[^~]*/', 'i');
signatureExtractionExpression.exec(email.HTMLBody);
var beforeSignature = RegExp.$1;
var signature = RegExp.$2;

//set the html body of the email
email.HTMLBody = beforeSignature + htmlBody + signature;

} catch (ex) {
alert(ex.message)
}
}

SendMailVarBased('rahul8346@gmail.com', 'hi there','<html><h1>Hi there</h1></html>');
</script>
</html>

How to check a database connection connection works on the Database Server or thru any Remote Server?

How to check if any OLE DB provider is installed on the Database server or Remote Server or any machine?

The easiest way to find out what kind of database connection provider exists on any Database or thru any Remote server is as follows:

1. Create a new text file on the Database server
2. Rename the file "New Text Document.txt" as "Test.udl". (Just rename the text file extension as "*.udl")
3. Double click the file. It should open the Data Link properties. Specify the required information to test your connection works or not.

4. Also you can check the "Provider" tab and which list all of the OLE DB provider that is installed on the given Server like "OLE DB", "SQL Native", etc.

Reference Link:

https://blogs.msdn.microsoft.com/steverac/2010/12/13/test-remote-sql-connectivity-easily/

Tuesday, 11 October 2016

Angular JS - Study Guide

Here are the things to learn if you are interested in Angular JS:

Some Useful Angular Directives:

ngDisabled
ngChecked
ngMultiple
ngReadonly
ngSelected
ngForm
ngSubmit
ngHref
ngSrc
ngNonBindable
ng-pluralize

IE Restriction (Be mindful of the older IEs)

You will have to use ployfill JSON.stringify
Do not use Angular Tags (It can be used as class, tags, attribute)

Expressions:
ex; {{expression}} Not all JS Functions are supported like MATH library functions.

Filters:
Modifying Output
Formatting
Sorting Dataset
Filtering Dataset
{{ expression | filter }}

Built-In Filters
uppercase
lowercase
{{ 22/7 | number : 2 }}
{{ 100.10 | currency }}
date
json

"Used with ng-repeat"
orderBy
limitTo
filter

Is Angular filters case-sensitive?

Yes.

What happens if anything is wrong with the anyone of the directive on the page?

It breaks all the other directive bindings, resulting in showing angular tags
"{{ some expression }}" in HTML.

Writing Custom Filters
<module_name>.filter( 'name_of_the_filter', function()
{
return function('model_name_or_input_param', ['Optional_any_additional_param'])
{
return 'SomethingNew';
}
}

Ex;
myModule.filter( 'getLength', function()
{
return function(firstName)
{
return firstName.length;
}
}

Friday, 7 October 2016

Chelsea's Trip

This is the story of a girl who like to face up difficult situations and strive to win.
Her name is Chelsea. She was born in Madurai, Tamil Nadu in the southern region of India.
I understand her name is pretty different for an Indian girl.Her name was given by her father Mr. R P Sharma. He is a big .fan of the English Football Club and that's how she got her name.
Her mother she does not approve the name much but she gave it up looking at the love of the name her husband had it in his life.

Madurai a special place in South India frequently visited by the visitors all over the world. The city's skyline is dominated by the 14 colorful towers of the world famous Temple "Meenakshi Amman Temple". The temple is covered in bright carvings of the Hindu gods. She grew up in this town as liberated child with forwarding thinking and would always questions things for there validity and the sense it makes to her. She ran into couples of issues due to this attitude of her.