Auto generated Numbers in SQL Query

Auto generated Numbers in SQL Query

create table CountryMaster
(
id int identity(1,1),
cityname varchar(50),
countryname varchar(50)
)

select * from CountryMaster

insert into CountryMaster values('New Delhi','India')
insert into CountryMaster values('Mumbai','India')
insert into CountryMaster values('Kolkata','India')
insert into CountryMaster values('Chennai','India')

insert into CountryMaster values('London','UK')
insert into CountryMaster values('Amsterdam','UK')
insert into CountryMaster values('Southampton','UK')

insert into CountryMaster values('Washington','US')
insert into CountryMaster values('New York','US')
insert into CountryMaster values('Chicago','US')

insert into CountryMaster values('Canberra','Australia')
insert into CountryMaster values('NSW','Australia')
insert into CountryMaster values('Melbourn','Australia')

insert into CountryMaster values('Islamabad','Pakistan')
insert into CountryMaster values('Karachi','Pakistan')
insert into CountryMaster values('Hyderabad','Pakistan')

select id, cityname, countryname,
ROW_NUMBER() OVER (PARTITION BY [countryName] ORDER BY id) AS Seq
from CountryMaster


Result
-------
.............................................
id cityname countryname Seq
.............................................
27 Canberra Australia 1
28 NSW Australia 2
29 Melbourn Australia 3

17 New Delhi India 1
18 Mumbai India 2
19 Kolkata India 3
20 Chennai India 4

30 Islamabad Pakistan 1
31 Karachi Pakistan 2
32 Hyderabad Pakistan 3

21 London UK 1
22 Amsterdam UK 2
23 Southampton UK 3

24 Washington US 1
25 New York US 2
26 Chicago US 3
.............................................

select id, cityname, countryname,
ROW_NUMBER() OVER (ORDER BY id) AS Seq
from CountryMaster

Result
-------
.............................................
id cityname countryname Seq
.............................................
17 New Delhi India 1
18 Mumbai India 2
19 Kolkata India 3
20 Chennai India 4
21 London UK 5
22 Amsterdam UK 6
23 Southampton UK 7
24 Washington US 8
25 New York US 9
26 Chicago US 10
27 Canberra Australia 11
28 NSW Australia 12
29 Melbourn Australia 13
30 Islamabad Pakistan 14
31 Karachi Pakistan 15
32 Hyderabad Pakistan 16
.............................................


select id, cityname, countryname,
ROW_NUMBER() OVER(order by id) AS Seq
from CountryMaster order by cityname

List of few CMMi level 5 companies in HYD, BLR, Pune

---
HYD
---
TCS
WIPRO
MAHINDRA SATYAM
INFOSYS
HCL
COGNIZANT
UHG
WELLSFARGO FINANCE COMPANY
SIERRA ATLANTIC
INTELLIGROUP
SEMANTICSPACE
IGATE
KEANE
INFOTECH

DELL
ORACLE
ADP
CGI
DELOITTE
VIRTUSA
CSC
CONVERGYS
ACCENTURE
CAPGEMNI
POLARIS
SONATA
JDA
NCR
KENEXA

----
BLR
----
ITC INFOTECH
TESCO
HP
MPHASIS
L & T INFOTECH
COVANSYS
INTEL
ABB
MCAFEE
FIC
SASKEN
LOGICA
SAPIENT
THOMSON REUTERS
PHILIPS

IBM
HONEYWELL
PEROT SYSTEMS
MINDTREE
JP MORGAN

-----
PUNE
-----
TECH MAHINDRA
SYNTEL
BLUE STAR INFOTECH
MASTEK
HEXAWARE
3I INFOTECH (ICICI)

Google maps - code to display image from URL

protected void Page_Load(object sender, EventArgs e)

{

if (!(Page.IsPostBack))

{

// to get the image stream

//http://www.greywyvern.com/code/php/binary2base64

// google maps image

// http://code.google.com/apis/maps/documentation/staticmaps/

//// working url

////string GoogleURL = "http://maps.google.com/maps/api/staticmap?sensor=false&zoom=0&size=320x169&maptype=roadmap";

///////// ++++++++++++++++++++++++++++++++++++++

// working

//string GoogleURL = "http://maps.google.com/maps/api/staticmap?sensor=false&zoom=12&size=480x313&maptype=roadmap¢er=52.4871716,1.7153936&markers=52.4871716,1.7153936";

// not working

//string GoogleURL = "http://maps.google.com/maps/api/staticmap?sensor=false&zoom=12&size=480x313&maptype=roadmap¢er=51.5017821,-0.1154330&markers=51.5017821,-0.1154330";

// old

//string GoogleURL = "http://maps.google.com/maps/api/staticmap?sensor=false&zoom=0&size=320x169&maptype=roadmap";

string GoogleURL = "http://maps.google.com/maps/api/staticmap?sensor=false&zoom=12&size=480x313&maptype=roadmap¢er=-33.8389280,151.2085890&markers=-33.8389280,151.2085890&format=jpg";


/////////////////////////////////////string GoogleURL1 = HttpUtility.UrlDecode("http%3a%2f%2fmaps.google.com%2fmaps%2fapi%2fstaticmap%3fsensor%3dfalse%26zoom%3d0%26size%3d320x169%26maptype%3droadmap");

string strResponse = string.Empty;


WebRequest objWebRequest;

objWebRequest = WebRequest.Create(GoogleURL);

WebProxy proxy = new WebProxy();

objWebRequest.Proxy = proxy;

objWebRequest.UseDefaultCredentials = true;

objWebRequest.Proxy.Credentials = CredentialCache.DefaultCredentials;

objWebRequest.ContentType = "Content-Type: image/png";

StreamReader loResponseStream = new StreamReader(objWebRequest.GetResponse().GetResponseStream(), Encoding.UTF8);

var bytes = default(byte[]);

using (var memstream = new MemoryStream())

{

var buffer = new byte[512];

var bytesRead = default(int);

while ((bytesRead = loResponseStream.BaseStream.Read(buffer, 0, buffer.Length)) > 0)

{

memstream.Write(buffer, 0, bytesRead);

}

bytes = memstream.ToArray();

}

image1.Attributes["src"] = "data:image/png;base64," + Convert.ToBase64String(bytes);

//Response.Clear();

//Response.ContentType = "Image/png";

//Response.BinaryWrite(bytes);

}

}

LINQ SQL Injection

http://msdn.microsoft.com/en-us/library/bb399403.aspx

http://csharp-codesamples.com/2009/05/preventing-sql-injection-using-linq/

reading data through Excel

private DataTable ReadExcelData(string strFilePath, string strFileType)

{

DataTable dt = new DataTable();

try

{

if (strFileType.ToLower().Contains("xls") || strFileType.ToLower().Contains("xlsx"))

{

OleDbCommand excelCommand = new OleDbCommand();

OleDbDataAdapter excelDataAdapter = new OleDbDataAdapter();

// for office 2003 and prior versions

//////////string excelConnStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + strFilePath + "; Extended Properties =Excel 8.0;";

/////// for office 2007 onwards and prior versions

string excelConnStr = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + strFilePath + "; Extended Properties =Excel 12.0;";

// Microsoft.Jet.OLEDB.4.0 driver is only for uploading Microsoft-Excel 2003 and earlier versions.

OleDbConnection excelConn = new OleDbConnection(excelConnStr);

excelConn.Open();

DataTable dtSheetName = excelConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

if (dtSheetName != null && dtSheetName.Rows.Count > 0)

{

string strSheetName = dtSheetName.Rows[0]["TABLE_NAME"].ToString();//gives first sheetname in the excel

excelCommand = new OleDbCommand("SELECT * FROM [" + strSheetName + "]", excelConn);//excelCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", excelConn);

excelDataAdapter.SelectCommand = excelCommand;

excelDataAdapter.Fill(dt);

}

excelConn.Close();

}

}

catch (Exception objEx)

{

throw objEx;

}

finally

{

//Delete the saved file from server path after reading the data from the path.Because it is uploaded from client machine to database.We are saving to server to avoid errors.After process we are deleting here.

if (File.Exists(strFilePath))

File.Delete(strFilePath);

}

return dt;

}

shivprasad koirala URLS on WCF

http://www.codeproject.com/KB/WCF/WCFTransactions.aspx

http://www.codeproject.com/KB/WCF/WCFFAQPart5.aspx

http://www.codeproject.com/KB/aspnet/WCF.aspx

http://www.codeproject.com/KB/aspnet/WCFPart2.aspx

http://www.codeproject.com/KB/WCF/WCFFAQPart3.aspx

http://www.codeproject.com/KB/WCF/WCFTracingFAQ.aspx

sending emails through c# asp.net

web.config entry

<system.net>
<mailSettings>
<smtp from="yoursenderemail@corporate.com">
<network host="hostname" port="25" password="Password"
userName="PASSPORT2" defaultCredentials="false" /> </smtp>
</mailSettings>
</system.net>

Note: 1) Make sure from address domain name
2) IP address, port number should be valid

c# code

SmtpSection mailSettings = ConfigurationManager.GetSection("system.net/mailSettings/smtp") as SmtpSection;
MailMessage MyMessage = new MailMessage();

string sendTo = this.txtEmailHard.Text;
string sendFrom = mailSettings.From;
string sendMessage = "hello now the time is : " + DateTime.Now.ToLongDateString();
MyMessage.To.Add(sendTo);
MyMessage.From = new MailAddress(sendFrom);
MyMessage.Subject = "Hi Welcome to eProfile";
MyMessage.Body = sendMessage;
MyMessage.IsBodyHtml = true;

this.lblComment.Text = mailSettings.Network.Host + " " + mailSettings.Network.Port;

SmtpClient emailClient = new SmtpClient(mailSettings.Network.Host, mailSettings.Network.Port);
if (mailSettings.Network.DefaultCredentials)
{
emailClient.UseDefaultCredentials = true;
}
else
{
emailClient.Credentials = new System.Net.NetworkCredential(mailSettings.Network.UserName, mailSettings.Network.Password);
}

emailClient.DeliveryMethod = SmtpDeliveryMethod.Network;
try
{
emailClient.Send(MyMessage);
return;
}
catch (SmtpException smtpx)
{
throw smtpx;
}
catch (Exception ex)
{
throw ex;
}

sending emails through c# asp.net code

web.config entry




userName="PASSPORT2" defaultCredentials="false" />




Note: 1) Make sure from address domain name
2) IP address, port number should be valid

c# code

SmtpSection mailSettings = ConfigurationManager.GetSection("system.net/mailSettings/smtp") as SmtpSection;
MailMessage MyMessage = new MailMessage();

string sendTo = this.txtEmailHard.Text;
string sendFrom = mailSettings.From;
string sendMessage = "hello now the time is : " + DateTime.Now.ToLongDateString();
MyMessage.To.Add(sendTo);
MyMessage.From = new MailAddress(sendFrom);
MyMessage.Subject = "Hi Welcome to eProfile";
MyMessage.Body = sendMessage;
MyMessage.IsBodyHtml = true;

this.lblComment.Text = mailSettings.Network.Host + " " + mailSettings.Network.Port;

SmtpClient emailClient = new SmtpClient(mailSettings.Network.Host, mailSettings.Network.Port);
if (mailSettings.Network.DefaultCredentials)
{
emailClient.UseDefaultCredentials = true;
}
else
{
emailClient.Credentials = new System.Net.NetworkCredential(mailSettings.Network.UserName, mailSettings.Network.Password);
}

emailClient.DeliveryMethod = SmtpDeliveryMethod.Network;
try
{
emailClient.Send(MyMessage);
return;
}
catch (SmtpException smtpx)
{
throw smtpx;
}
catch (Exception ex)
{
throw ex;
}

multiple end points scenario

---------------
Project Manager
---------------
Method 1
Method 2
Method 3
Method 4

---------------
Project Leader
---------------
Method 5
Method 6
Method 7

---------
Developer
---------
Method 8
Method 9
Method 10


End points - PMEndPoint - A B C
End points - PLEndPoint
End points - DevEndPoint

Address - http://localhost/MobileApps/Service1.svc
Binding - WSHttpBinding
Contract - IPMService

Address - http://localhost/MobileApps/Service1.svc
Binding - WSHttpBinding
Contract - IPLService

Address - http://localhost/MobileApps/Service1.svc
Binding - WSHttpBinding
Contract - IDevService

public interface IPMService
{

Method 1
Method 2
Method 3
Method 4

}

public interface IPLService
{

Method 5
Method 6
Method 7

}

public interface IDevService
{

Method 8
Method 9
Method 10

}

what is data center

A data center is a facility used to house computer systems and associated components, such as telecommunications and storage systems. It generally includes redundant or backup power supplies, redundant data communications connections, environmental controls (e.g., air conditioning, fire suppression) and security devices.

Tier Level 1 - 99.671% availability
Tier Level 2 - 99.741% availability
Tier Level 3 - 99.982% availability
Tier Level 4 - 99.995% availability

IT operations are a crucial aspect of most organizational operations. One of the main concerns is business continuity; companies rely on their information systems to run their operations.

The boom of data centers came during the dot-com bubble. Companies needed fast Internet connectivity and nonstop operation to deploy systems and establish a presence on the Internet.

Installing such equipment was not viable for many smaller companies. Many companies started building very large facilities, called Internet data centers (IDCs), which provide businesses with a range of solutions for systems deployment and operation.

New technologies and practices were designed to handle the scale and the operational requirements of such large-scale operations. These practices eventually migrated toward the private data centers, and were adopted largely because of their practical results.

WCF Instance

WCF instance dictates how the objects are created while WCF concurrency dictates how many requests can be handled by the WCF objects.


WCF instancing - per call, per session and single
WCF concurrency - single , multiple, reentrant


Single: -
==============
1) A single request has access to the WCF service object at a given moment of time.
2) So only one request will be processed at any given moment of time. The other requests have to wait until the request processed by the WCF service is not completed.

Multiple: -
==============
1) In this scenario multiple requests can be handled by the WCF service object at any given moment of time.
2) In other words request are processed at the same time by spawning multiple threads on the WCF server object. So you have great a throughput here but you need to ensure concurrency issues related to WCF server objects.

Reentrant: -
==============
1) A single request thread has access to the WCF service object,
2) but the thread can exit the WCF service to call another WCF service or can also call WCF client through callback and reenter without deadlock.

Note: By default WCF services are 'Single' concurrency and instancing mode ‘per call’.



Per call
==============

• You want a stateless services
• Your service hold intensive resources like connection object and huge memory objects.
• Scalability is a prime requirement. You would like to have scale out architecture.
• Your WCF functions are called in a single threaded model.

Per session
==============

• You want to maintain states between WCF calls.
• You want ok with a Scale up architecture.
• Light resource references

Single
==============

• You want share global data through your WCF service.
• Scalability is not a concern.

site to encode xml, html code

http://centricle.com/tools/html-entities/

JQuery Notes 12Jan12

------------------
Point 1
------------------
<script>
//hide all divs on the page
jQuery('div').hide();
//update the text contained inside of all divs
jQuery('div').text('new content added here');
//add css stylesheet to all div tags
jQuery('div').addClass("updatedContent");
//show all divs on the page
jQuery('div').show();
//add css stylesheet to all input tags
jQuery('input').addClass("updatedContent");
//hide all input tags on the page
jQuery('input').hide();

// all inputs with css1 stylesheets
jQuery('input.css1').hide();

</script>

------------------
Point 2
------------------

jQuery methods - hide(), text(), addClass(), show()

------------------
Point 3
------------------

alert('Page contains ' + jQuery('a').length + ' <a> elements!');
jQuery('a').attr("href", "http://www.google.co.in");
$('a').attr("href", "http://www.google.com");

------------------
Point 4
------------------

<form>
<div>murali</div>
</form>

<form>
<div>murali 100</div>
</form>

<div>murali 200</div>

<script>
jQuery('div').text('new content added here - with out form tag');
jQuery('div',$('form')).text('new content added here - with form tag');
</script>


------------------
Point 5
------------------
<style type="text/css">
.external
{
}
</style>

<div class='external'>1000</div>
<div class='external'>1001</div>
<div>1002</div>
<div>1003</div>
<div class='external'>1004</div>

jQuery('div').filter(".external").text("Hello Maccha");

------------------
Point 6
------------------
$('div').css('font-size','24px');
$('div').css('color','Black');
$('div').css('font-family','Roman');

------------------
Point 7
------------------
<ul>
<li><a href="#">Google</a></li>
<li><a href="#">Yahoo</a></li>
<li><a href="#">Gmail</a></li>
<li><a href="#">Telugu People</a></li>
<li><a href="#">Andhra Vilas</a></li>
<li><a href="#">Great Andhra</a></li>
</ul>


$('li:eq(0)').find('a').attr("href", "http://www.google.co.in");
$('li:eq(0)').next().find('a').attr("href", "http://www.yahoomail.com");
$('li:eq(1)').next().text("sajfklasdj fklsjd fklsjd fklsdj jkl");

$('li:eq(2)').nextAll().find('a').attr("href", "http://www.telugu.greatandhra.com");
$('li:eq(2)').nextAll().find('a').text("Great Andhra");



------------------
Point 8
------------------
<div id="first">This is the first statement.</div>
<div id="second">This is the second statement.</div>
<div id="third">This is the third statement.</div>

<ul id="empno">
<li>1</li>
<li>2</li>
<li>3</li>
</ul>

$('a').filter('.css').remove();
$('a').remove('.css100');

$('#first').replaceWith('<p><b>Murali</b></p>');

$('ul#empno li').text('Employee Number : 1');

// adding multiple attributes
$('#company').attr({'class':'murali','title':'company information'}).text('Value Labs, Hyderabad');

// adding html text
$('#comp').html('<strong>Hello World</strong>');

------------------
Point 9
------------------
<a href="/category">Category</a>
<ul id="nav">
<li><a href="#anchor1">Anchor 1</a></li>
<li><a href="#anchor2">Anchor 2</a></li>
<li><span><a href="#anchor3">Anchor 3</a></span></li>
</ul>

$('#nav li').find('a').attr("href","http://www.google.com"); all a
$('#nav li a').attr("href","http://www.google.com"); all a
$('#nav li > a').attr("href","http://www.google.com"); only immediate a

------------------
Point 10
------------------
//$('h1 + h2').text('Murali'); // h2 follows h1. h2 is updated
//$('h2 + h1').text('Murali'); // h1 follows h2. h1 is updated
//$('h1').siblings('h2,h3,p').text('Murali');

$('li.selected').nextAll('li').css('background-color','red');
$('li.selected').prevAll('li').css('background-color','green');
$('li.selected').next('li').css('background-color','red');
$('li.selected').next().css('background-color','red');

------------------
Point 11
------------------

<table id="tblEmpDetails">
<thead><td>Emp Number</td><td>Name</td></thead>
<tr><td>Employee Number : 0</td><td>even - Murali Krishna V</td></tr>
<tr><td>Employee Number : 1</td><td>odd - Dasari Subrahmanyam</td></tr>
<tr><td>Employee Number : 2</td><td>even - Rakesh Mupparam</td></tr>
<tr><td>Employee Number : 3</td><td>odd - Suresh M</td></tr>
<tr><td>Employee Number : 4</td><td>even - Lakshman A</td></tr>
</table>


$('#tblEmpDetails tr:even').css('background-color','red');
$('#tblEmpDetails tr:odd').css('background-color','green');

<table id="Table1">
<thead><td>Emp Number</td><td>Name</td></thead>
<tr><td>Employee Number : 0</td><td>even - Murali Krishna V</td></tr>
</table>


$('tr:even').css('background-color','yellow');
$('tr:odd').css('background-color','cyan');

------------------
Point 12
------------------
<span>Hello Bob!</span>
// Select all SPANs with 'Bob' in:
jQuery('span:contains("Bob")');

jQuery('div:has(p a)');

------------------
Point 13
------------------
<div id="Menu">
<a href="#">Destinations</a><br />
<a href="#">Risk Assessments</a><br />
<a href="#">About Us</a><br />
<a href="#">Contact Us</a><br />
</div>

<script type="text/javascript">
$(function ()
{
$("div#Menu a").mouseover(function () { $(this).addClass("highlightRow"); })
.mouseout(function () { $(this).removeClass("highlightRow"); }
);
})

$("div#Menu a").click(function ()
{
alert( $(this).text() );
});

</script>

------------------
Point 14 - Chapter 3
------------------
Looping Concepts


<div id="Menu">
<a href="www.google.co.in">Destinations</a><br />
<a href="www.google.com">Risk Assessments</a><br />
<a href="www.yahoomail.com">About Us</a><br />
<a href="www.facebook.com">Contact Us</a><br />
</div>


var urls = [];
$("div#Menu a[href]").each(function(i) {
urls[i] = $(this).attr('href');
$(this).attr("href","http://www.murali.com").text("www.murali.com");
});

alert( urls.join(","));

WRONG CODE
--------------
$("div#Menu a[href]")(function()
{
$(this).attr("href","http://www.murali.com").text("www.murali.com");
});


------------------
Point 15
------------------
<ul id="names">
<li>Ralph</li>
<li>Hope</li>
<li>Brandon</li>
<li>Jordan</li>
<li>Ralphie</li>
</ul>

$("ul > li").eq(7).css("border-bottom", "1px solid #000000");
$("ul > li").css("border-bottom", "1px solid red").eq(7).css("border-bottom", "1px solid #000000");
$("ul > li:first").css("border-top", "5px solid green");
$("ul > li:last").css("border-top", "5px solid green");
$("ul > li:eq(5)").css("border-top", "5px solid green");

(function($){
$(document).ready(function() {
$("ul > li").each(function(i) {
if (i % 2 == 1)
{
$(this).css("border", "2px solid red")
}
else
{
$(this).css("border", "3px solid green")
}
});
});
})(jQuery);


------------------
Point 16
------------------
<h2>Value Labs - Employees</h2>
<div>
<ul id="names">
<li>Murali</li>
<li>Krishna</li>
<li>Rakesh</li>
<li>Subbu</li>
<li>Lakshman</li>
<li>Vara</li>
<li>Shiva</li>
<li>Suresh</li>
<li>Mitesh</li>
<li>Vishnu</li>
</ul>
</div>


(function($)
{
$(document).ready(function()
{
var lis = $("ul li").get().reverse();
//$("ul").empty();

$.each(lis, function(i)
{
$(this).css("color", "white");
});

$("ul").append("<li>+++++++++++++++++++++++++</li>");

$.each(lis, function(i)
{
$("ul").append("<li class='reverseCss'>" + lis[i].innerHTML + "</li>");
});

$("li").filter(".reverseCss").css("color", "gold");
});
})(jQuery);

$("h2").addClass("Emp");
$("div").addClass("divEmp");

------------------
Point 17
------------------
(function($)
{
$(document).ready(function()
{
$("div").click(function()
{
alert("You clicked on div with an index of " + $("div").index(this) );
alert("You clicked on div with an index of " + $(this).text() );
});
});
})(jQuery);

------------------
Point 18
------------------
<div>
<br />
<p>Murali Krishna - p element</p> <br />
<p>Murali - p element</p> <br />
<p>Krishna - p element</p> <br />
<input type="text" id="txt1" /> <br />
<a href="#">Google 1</a><br />
<a href="#">Google 2</a><br />
<a href="#">Google 3</a><br />
<b>India</b><br />
<strong>India</strong><br />
<br />
</div>

<div>
<p>Raju</p>
</div>

<div>
<p>Rakesh + Raju</p>
</div>


$("div").each(function(i)
{
if ($('div').index(this) % 2 == 0)
{
$(this).text('I am ' + $(this).text() );
}
else
{
$(this).text('You Are : ' + $(this).text() );
}
});

------------------
Point 19
------------------
<h1>jQuery Cookbook Authors</h1>
<ol>
<li>John Resig</li>
<li>Cody Lindley</li>
<li>James Padolsey</li>
<li>Ralph Whitbeck</li>
</ol>

(function($)
{
$(document).ready(function()
{
$.each( $("li") , function(i)
{
alert( $(this).text() );
});
});
})(jQuery);


------------------
Point 20
------------------
Note:- jQuery utility method $.map(), which will transform an existing array into another array of items.

(function($)
{
$(document).ready(function()
{
var arr = $.map([100,200,300], function(item, index)
{
alert( item + 1 );
});
});
})(jQuery);

------------------
Point 21
------------------

(function($)
{
$(document).ready(function()
{
var arr = $.map($("li"), function(item, index)
{
while (index < 3)
{
return $(item).html();
}
return null;
});

$(document.body).append("<span>The first three authors are: " + arr.join(", ") + "</span>");
});
})(jQuery);


------------------
Point 22
------------------

<ul>
<li>fskdjf</li>
<li>fskdjf</li>
<li>fskdjf</li>
<li>fskdjf</li>
<li>fskdjf</li>
<li>fskdjf</li>
</ul>

$("li").slice(1,2).wrap("<b><i></i></b>").css('color','red').css('background-color','gold').css('width','200px');

------------------
Point 23 - Chapter 4
------------------
<a href="#">Broken Links</a><br />
<a href="http://www.google.co.in">www.google.co.in</a><br />
<a href="http://abc.com">abc</a><br />
<a href="#">Broken Links</a><br />
<a href="http://xyz.com">xyz</a><br />
<a href="#">Broken Links</a><br />


(function($)
{
$(document).ready(function()
{
$('a').filter(function()
{
if ( $(this).attr('href') == "#" )
{
$(this).attr('href',"http://telugu.greatandhra.com");
$(this).text('Great Andhra');
}
}).click(function() {
});
});
})(jQuery);


------------------
Point 24
------------------
<a href="#">Broken Links</a><br />
<a href="h:/www.google.co.in">www.google.co.in</a><br />
<a href="http://abc.com">abc</a><br />
<a href="#">Broken Links</a><br />
<a href="hp://xyz.com">xyz</a><br />
<a href="#">Broken Links</a><br />


(function($)
{
$(document).ready(function()
{
$('a').filter(function()
{
if ( $(this).attr('href') == "#" )
{
$(this).attr('href',"http://telugu.greatandhra.com");
$(this).text('Great Andhra');
}
else
{
var myVariable = $(this).attr('href');
if(myVariable == 'http://abc.com')
{

}
else
{
$(this).attr('href',"http://andhravilas.com");
$(this).text('Andhra Vilas');
}
}
}).click(function() {
});
});
})(jQuery);

------------------
Point 25
------------------
<h1>Months</h1>
<ol id="months"></ol>

<br />

<h1>Weekdays</h1>
<ol id="weekday"></ol>


(function($)
{
$(document).ready(function()
{
var months = [ 'January', 'February', 'March', 'April', 'May',
'June', 'July', 'August', 'September', 'October',
'November', 'December'];

$.each(months, function(index, value)
{
$('#months').append('<li>' + value + '</li>');
});

var days = { Sunday: 0, Monday: 1, Tuesday: 2, Wednesday: 3,
Thursday: 4, Friday: 5, Saturday: 6 };

$.each(days, function(key, value)
{
$('#weekday').append("<li>" + key + ' (' + value + ')</li>');
});
});
})(jQuery);
------------------
Point 26
------------------
(function($)
{
$(document).ready(function()
{
var months = [ 'January', 'February', 'March', 'April', 'May',
'June', 'July', 'August', 'September', 'October',
'November', 'December'];

var months = $.grep(months, function(value, i)
{
return ( value.indexOf('A') == 0 );
});
$('#months').html( '<li>' + months.join('</li><li>') + '</li>' );
});
})(jQuery);

it can be written as below as well using map utility

var monthsNew = $.map(months, function(value, i)
{
return ( value.indexOf('J') == 0 ? value : null );
});
$('#months').html( '<li>' + monthsNew.join('</li><li>') + '</li>' );
------------------
Point 27
------------------
(function($)
{
$(document).ready(function()
{
var months = [ 'January', 'February', 'March', 'April', 'May',
'June', 'July', 'August', 'September', 'October',
'November', 'December'];

months = $.map(months, function(value, i)
{
var monthname = value.substr(0,3);
switch(monthname)
{
case "Jan" :
case "Mar" :
case "May" :
case "Jul" :
case "Aug" :
case "Oct" :
case "Dec" :
return value + " - 31";
break;
case "Feb" :
return value + " - 28";
break;
case "Apr" :
case "Jun" :
case "Sep" :
case "Nov" :
return value + " - 30";
break;
default: return "";
}

});
$('#months').html( '<li>' + months.join('</li><li>') + '</li>' );
});
})(jQuery);

------------------
Point 28
------------------
Merging two arrays sets

$('#months').html( '<li>' + $.merge(months,monthsNew).join('</li><li>') + '</li>' );


------------------
Point 29
------------------



------------------
Point 30
------------------


------------------
Point 31
------------------



------------------
Point 32
------------------

JQuery Notes 10Jan2012

------------------
Point 1
------------------


------------------
Point 2
------------------

jQuery methods - hide(), text(), addClass(), show()

------------------
Point 3
------------------

alert('Page contains ' + jQuery('a').length + ' elements!');
jQuery('a').attr("href", "http://www.google.co.in");
$('a').attr("href", "http://www.google.com");

------------------
Point 4
------------------

murali

murali 100

murali 200

------------------
Point 5
------------------

1000

1001

1002

1003

1004

jQuery('div').filter(".external").text("Hello Maccha");

------------------
Point 6
------------------
$('div').css('font-size','24px');
$('div').css('color','Black');
$('div').css('font-family','Roman');

------------------
Point 7
------------------

• Google


• Yahoo


• Gmail


• Telugu People


• Andhra Vilas


• Great Andhra

$('li:eq(0)').find('a').attr("href", "http://www.google.co.in");
$('li:eq(0)').next().find('a').attr("href", "http://www.yahoomail.com");
$('li:eq(1)').next().text("sajfklasdj fklsjd fklsjd fklsdj jkl");

$('li:eq(2)').nextAll().find('a').attr("href", "http://www.telugu.greatandhra.com");
$('li:eq(2)').nextAll().find('a').text("Great Andhra");



------------------
Point 8
------------------

This is the first statement.

This is the second statement.

This is the third statement.

• 1


• 2


• 3

$('a').filter('.css').remove();
$('a').remove('.css100');

$('#first').replaceWith('

Murali

');

$('ul#empno li').text('Employee Number : 1');

// adding multiple attributes
$('#company').attr({'class':'murali','title':'company information'}).text('Value Labs, Hyderabad');

// adding html text
$('#comp').html('Hello World');

------------------
Point 9
------------------
Category

• Anchor 1


• Anchor 2


• Anchor 3

$('#nav li').find('a').attr("href","http://www.google.com"); all a
$('#nav li a').attr("href","http://www.google.com"); all a
$('#nav li > a').attr("href","http://www.google.com"); only immediate a

------------------
Point 10
------------------
//$('h1 + h2').text('Murali'); // h2 follows h1. h2 is updated
//$('h2 + h1').text('Murali'); // h1 follows h2. h1 is updated
//$('h1').siblings('h2,h3,p').text('Murali');

$('li.selected').nextAll('li').css('background-color','red');
$('li.selected').prevAll('li').css('background-color','green');
$('li.selected').next('li').css('background-color','red');
$('li.selected').next().css('background-color','red');

------------------
Point 11
------------------

Emp Number	Name
Employee Number : 0	even - Murali Krishna V
Employee Number : 1	odd - Dasari Subrahmanyam
Employee Number : 2	even - Rakesh Mupparam
Employee Number : 3	odd - Suresh M
Employee Number : 4	even - Lakshman A

$('#tblEmpDetails tr:even').css('background-color','red');
$('#tblEmpDetails tr:odd').css('background-color','green');

Emp Number	Name
Employee Number : 0	even - Murali Krishna V

$('tr:even').css('background-color','yellow');
$('tr:odd').css('background-color','cyan');

------------------
Point 12
------------------
Hello Bob!
// Select all SPANs with 'Bob' in:
jQuery('span:contains("Bob")');

jQuery('div:has(p a)');

------------------
Point 13
------------------

Destinations

Risk Assessments

About Us

Contact Us

------------------
Point 14 - Chapter 3
------------------
Looping Concepts

Destinations

Risk Assessments

About Us

Contact Us

var urls = [];
$("div#Menu a[href]").each(function(i) {
urls[i] = $(this).attr('href');
$(this).attr("href","http://www.murali.com").text("www.murali.com");
});

alert( urls.join(","));

WRONG CODE
--------------
$("div#Menu a[href]")(function()
{
$(this).attr("href","http://www.murali.com").text("www.murali.com");
});


------------------
Point 15
------------------

• Ralph


• Hope


• Brandon


• Jordan


• Ralphie

$("ul > li").eq(7).css("border-bottom", "1px solid #000000");
$("ul > li").css("border-bottom", "1px solid red").eq(7).css("border-bottom", "1px solid #000000");
$("ul > li:first").css("border-top", "5px solid green");
$("ul > li:last").css("border-top", "5px solid green");
$("ul > li:eq(5)").css("border-top", "5px solid green");

(function($){
$(document).ready(function() {
$("ul > li").each(function(i) {
if (i % 2 == 1)
{
$(this).css("border", "2px solid red")
}
else
{
$(this).css("border", "3px solid green")
}
});
});
})(jQuery);


------------------
Point 16
------------------

Value Labs - Employees

• Murali


• Krishna


• Rakesh


• Subbu


• Lakshman


• Vara


• Shiva


• Suresh


• Mitesh


• Vishnu

(function($)
{
$(document).ready(function()
{
var lis = $("ul li").get().reverse();
//$("ul").empty();

$.each(lis, function(i)
{
$(this).css("color", "white");
});

$("ul").append("

+++++++++++++++++++++++++

");

$.each(lis, function(i)
{
$("ul").append("

" + lis[i].innerHTML + "

");
});

$("li").filter(".reverseCss").css("color", "gold");
});
})(jQuery);

$("h2").addClass("Emp");
$("div").addClass("divEmp");

------------------
Point 17
------------------
(function($)
{
$(document).ready(function()
{
$("div").click(function()
{
alert("You clicked on div with an index of " + $("div").index(this) );
alert("You clicked on div with an index of " + $(this).text() );
});
});
})(jQuery);

------------------
Point 18
------------------

Murali Krishna - p element

Murali - p element

Krishna - p element

Google 1

Google 2

Google 3

India

India

Raju

Rakesh + Raju

$("div").each(function(i)
{
if ($('div').index(this) % 2 == 0)
{
$(this).text('I am ' + $(this).text() );
}
else
{
$(this).text('You Are : ' + $(this).text() );
}
});

------------------
Point 19
------------------

jQuery Cookbook Authors

1. John Resig


2. Cody Lindley


3. James Padolsey


4. Ralph Whitbeck

(function($)
{
$(document).ready(function()
{
$.each( $("li") , function(i)
{
alert( $(this).text() );
});
});
})(jQuery);


------------------
Point 20
------------------
Note:- jQuery utility method $.map(), which will transform an existing array into another array of items.

(function($)
{
$(document).ready(function()
{
var arr = $.map([100,200,300], function(item, index)
{
alert( item + 1 );
});
});
})(jQuery);

------------------
Point 21
------------------

(function($)
{
$(document).ready(function()
{
var arr = $.map($("li"), function(item, index)
{
while (index < 3)
{
return $(item).html();
}
return null;
});

$(document.body).append("The first three authors are: " + arr.join(", ") + "");
});
})(jQuery);


------------------
Point 22
------------------

• fskdjf


• fskdjf


• fskdjf


• fskdjf


• fskdjf


• fskdjf

$("li").slice(1,2).wrap("").css('color','red').css('background-color','gold').css('width','200px');

------------------
Point 23 - Chapter 4
------------------
Broken Links

www.google.co.in

abc

Broken Links

xyz

Broken Links



(function($)
{
$(document).ready(function()
{
$('a').filter(function()
{
if ( $(this).attr('href') == "#" )
{
$(this).attr('href',"http://telugu.greatandhra.com");
$(this).text('Great Andhra');
}
}).click(function() {
});
});
})(jQuery);


------------------
Point 24
------------------
Broken Links

www.google.co.in

abc

Broken Links

xyz

Broken Links



(function($)
{
$(document).ready(function()
{
$('a').filter(function()
{
if ( $(this).attr('href') == "#" )
{
$(this).attr('href',"http://telugu.greatandhra.com");
$(this).text('Great Andhra');
}
else
{
var myVariable = $(this).attr('href');
if(myVariable == 'http://abc.com')
{

}
else
{
$(this).attr('href',"http://andhravilas.com");
$(this).text('Andhra Vilas');
}
}
}).click(function() {
});
});
})(jQuery);

------------------
Point 25
------------------

Months

Weekdays

(function($)
{
$(document).ready(function()
{
var months = [ 'January', 'February', 'March', 'April', 'May',
'June', 'July', 'August', 'September', 'October',
'November', 'December'];

$.each(months, function(index, value)
{
$('#months').append('

' + value + '

');
});

var days = { Sunday: 0, Monday: 1, Tuesday: 2, Wednesday: 3,
Thursday: 4, Friday: 5, Saturday: 6 };

$.each(days, function(key, value)
{
$('#weekday').append("

" + key + ' (' + value + ')

');
});
});
})(jQuery);
------------------
Point 26
------------------
(function($)
{
$(document).ready(function()
{
var months = [ 'January', 'February', 'March', 'April', 'May',
'June', 'July', 'August', 'September', 'October',
'November', 'December'];

var months = $.grep(months, function(value, i)
{
return ( value.indexOf('A') == 0 );
});
$('#months').html( '

' + months.join('

') + '

' );
});
})(jQuery);

it can be written as below as well using map utility

var monthsNew = $.map(months, function(value, i)
{
return ( value.indexOf('J') == 0 ? value : null );
});
$('#months').html( '

' + monthsNew.join('

') + '

' );
------------------
Point 27
------------------
(function($)
{
$(document).ready(function()
{
var months = [ 'January', 'February', 'March', 'April', 'May',
'June', 'July', 'August', 'September', 'October',
'November', 'December'];

months = $.map(months, function(value, i)
{
var monthname = value.substr(0,3);
switch(monthname)
{
case "Jan" :
case "Mar" :
case "May" :
case "Jul" :
case "Aug" :
case "Oct" :
case "Dec" :
return value + " - 31";
break;
case "Feb" :
return value + " - 28";
break;
case "Apr" :
case "Jun" :
case "Sep" :
case "Nov" :
return value + " - 30";
break;
default: return "";
}

});
$('#months').html( '

' + months.join('

') + '

' );
});
})(jQuery);

------------------
Point 28
------------------
Merging two arrays sets

$('#months').html( '

' + $.merge(months,monthsNew).join('

') + '

' );


------------------
Point 29
------------------



------------------
Point 30
------------------


------------------
Point 31
------------------



------------------
Point 32
------------------

Working with Ajax toolkit

1. find AjaxControlToolkit.dll. and place it in your bin folder

2. add the following tag in aspx page

< % @ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajax" % >

3. try the following code

< asp: Panel ID="pnlShowXMLElements" runat="server" CssClass="XMLPopupModalBG" ScrollBars="Vertical" >
< table >
< tr >
< td align="center" style="width:600px">

< /td>
< /tr>
< tr>
< td>

< /td>
< /tr>
< tr id="tr1">
< td>
AutoGenerateDataBindings="true"
OnSelectedNodeChanged="treeSource_SelectionChanged" />
< /td>
< /tr>
< /table>
< /asp:Panel>

< ajax: ModalPopupExtender ID="modalpopup" runat="server" DropShadow="true"
CancelControlID="btnCancelPopup"
TargetControlID="btnOpenTreeView" PopupControlID="pnlShowXMLElements" / >

4. create css class files

5. debug and test

Jquery1

<br /><br /><br /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br /><br /><html><br /><br /><head><br /><br /><meta equiv="Content-Type" content="text/html; charset=UTF-8"><br /><br /><style type="text/css"><br /><br />.even { background-color: red; }<br /><br />.even1 { background-color: green; }<br /><br />.odd { background-color: blue; }<br /><br /></style><br /><br /></head><br /><br /><body><br /><br /><br /><br /><span>Hello Bob India!</span><br /><br /><span>Hello Bobby!</span><br /><br /><br /><br /></br> Name : <input type="text"><br /><br /></br> Gender : <input type="radio">Male</input> <input type="radio">Female</input> <br /><br /></br> Password : <input type="password"><br /><br /></br> Employee ? <input type="checkbox">Yes/No</input><br /><br /></br> Private Company ? <input type="checkbox">Yes/No</input><br /><br /><br /><br /><h2>Family Members</h2><br /><br /><ul><br /><br /><li>Murali</li><br /><br /><li>Swathi</li><br /><br /><li>Prasad</li><br /><br /><li>Vani</li><br /><br /><li>Sridhar</li><br /><br /><li>Veni</li><br /><br /></ul><br /><br /><br /><br /><script type="text/JavaScript" src="D:\Murali V\JQuery\jquery-1.4.2.min.js"></script><br /><br /><script type="text/JavaScript"><br /><br /><br /><br />(function($)<br /><br />{<br /><br /> $(document).ready(function() <br /><br /> {<br /><br /> $("ul > li").each(function(i) {<br /><br /> if (i % 3 == 0)<br /><br /> {<br /><br /> $(this).addClass("odd");<br /><br /> }<br /><br /> else if (i % 3 == 1)<br /><br /> {<br /><br /> $(this).addClass("even");<br /><br /> }<br /><br /> else if (i % 3 == 2)<br /><br /> {<br /><br /> $(this).addClass("even1");<br /><br /> }<br /><br /> });<br /><br />});<br /><br />})(jQuery);<br /><br /><br /><br />/*<br /><br />$("ul > li:odd").addClass("odd");<br /><br />$("ul > li:even").addClass("even");<br /><br />*/<br /><br /><br /><br />/*<br /><br />alert($('span:contains("Bob India")').length); //it’s case sensitive, <br /><br /><br /><br />$('*').filter(function(){<br /><br />return $(this).css('display') == 'none'<br /><br />&& $(this).css('visibility') != 'hidden';<br /><br />});<br /><br /><br /><br />alert($(':radio').length); <br /><br />alert($(':text').length); <br /><br />alert($(':password').length); <br /><br />alert($(':checkbox').length); <br /><br />*/<br /><br /><br /><br /></script><br /><br /></body><br /><br /></html><br /><br /><br /><br />

LINQ Coding

LINQ coding
-------------------------------
//from c in MurSapeliCovers
//join o in MurCompCustomers on new { cid = c.CustomerId, coid=c.CoverId} equals new
//{ cid = o.CustId, coid=o.CoverId} into g
//from o in g.DefaultIfEmpty()
//select new {Cover = c.Cover,
// compNumber = o == null ? 0 : o.CompNumber
// }


from p in MurCompApplications
join o in MurCompCustomers on p.CompNumber equals o.CompNumber
join c in MurSapeliCovers on new { cid = o.CustId, coid=o.CoverId} equals new
{ c.CustomerId = cid, CoverId=coid} into g
from c in g.DefaultIfEmpty()
select new {Cover = c.Cover,
compNumber = o == null ? 0 : o.CompNumber
}

from c in MurSapeliCovers
join o in ( from cu in MurCompCustomers join ca in MurCompApplications
on cu.CompNumber equals ca.CompNumber
select new { CustId = cu.CustId, CoverId = cu.CoverId, CompNumber=ca.CompNumber } )
on new { cid = c.CustomerId, coid=c.CoverId} equals new
{ cid = o.CustId, coid=o.CoverId} into g
from o in g.DefaultIfEmpty()
select new {Cover = c.Cover,
compNumber = o == null ? 0 : o.CompNumber
}


from p in MurCompApplications
join q in MurCompCustomers on p.CompNumber equals q.CompNumber
select new
{
coverid = q.CoverId, compNumber = p.CompNumber
}
///////////////////////////////////
from p in MurCompApplications
join q in MurCompCustomers on p.CompNumber equals q.CompNumber into g
from q in g.DefaultIfEmpty()
select new
{
coverid = q == null ? 0 : q.CoverId,
compNumber = p.CompNumber
}
///////////////////////////////////
from c in MurSapeliCovers
join o in MurCompCustomers on new { cid = c.CustomerId, coid=c.CoverId} equals new
{ cid = o.CustId, coid=o.CoverId} into g
from o in g.DefaultIfEmpty()
select new {Cover = c.Cover,
compNumber = o == null ? 0 : o.CompNumber
}
///////////////////////////////////

from c in MurSapeliCovers
join o in ( from cu in MurCompCustomers join ca in MurCompApplications
on cu.CompNumber equals ca.CompNumber
select new { CustId = cu.CustId, CoverId = cu.CoverId, CompNumber=ca.CompNumber } )
on new { cid = c.CustomerId, coid=c.CoverId} equals new
{ cid = o.CustId, coid=o.CoverId} into g
from o in g.DefaultIfEmpty()
select new {Cover = c.Cover,
compNumber = o == null ? 0 : o.CompNumber
}
from sapelicovers in TblCoverWithCustomerDetails
join compData in
(
from compCust in Comp_Customers
join compApp in Comp_Applications
on compCust.CompNumber equals compApp.Comp_CompNumber.CompNumber
where compApp.Active == true
&& compApp.Comp_TypeDetails.TypeId == 1
&& compApp.Comp_TypeDetails.Code == 1
select new
{
CompNumber = compCust.CompNumber,
CustId = compCust.CustId,
CoverId = compCust.CoverId,
IncidentDate = compApp.IncidentDate,
Active = compApp.Active,
CompTypeId = compApp.Comp_TypeDetails.TypeId,
CompTypeCode = compApp.Comp_TypeDetails.Code
}
)
on
new { coverno = sapelicovers.CoverNo , custid = sapelicovers.CustomerNo }
equals new { coverno = compData.CoverId , custid = compData.CustId }
into outer
from compData in outer.DefaultIfEmpty()
where sapelicovers.CustomerNo == 1
select new
{
Cover = sapelicovers.Cover,
InsuranceNumber = sapelicovers.InsuranceNo,
CompensationNumber = compData == null ? 0 : compData.CompNumber,
StatusCode = sapelicovers.CoverStatus,
EvaluationDate = compData.IncidentDate,
ExpiryReason = sapelicovers.ExpiryReason,
ValidFromDate = sapelicovers.CoverStartDate,
ValidToDate = sapelicovers.CoverEndDate,
SumInsured = sapelicovers.SumInsured,
Bonus = sapelicovers.BonusType,
Benificiary = sapelicovers.BeneficiaryCode
}

from sapelicover in TblCoverWithCustomerDetails
join o in
(
from p in Comp_Customers
join q in Comp_Applications
on p.CompNumber equals q.Comp_CompNumber.CompNumber
where q.Comp_TypeDetails.TypeId == 1
&& q.Comp_TypeDetails.Code == 1
&& p.CompNumber == 10005
&& q.Active == false
select new
{
coverid = p.CoverId,
CompNumber = p.CompNumber,
AddInfoReceivedDate = q.AddInfoReceivedDate,
AppReceivedDate = q.AppReceivedDate,
AddiInfo = q.Comments,
IncidentDate = q.IncidentDate,
CustId = p.CustId,
InsuranceNumber = p.InsuranceId
}
)
on new { coverid = sapelicover.CoverNo, custid = sapelicover.CustomerNo }
equals new { coverid = o.coverid, custid = o.CustId } into outer
from o in outer.DefaultIfEmpty()
where
sapelicover.Active == true
&& sapelicover.CustomerNo == 1
&& sapelicover.CoverNo == 1
select new
{
sapelicover, o
}














C# Expression
-------------
from p in Comp_Applications select p
from p in Comp_Applications select p.CompNumber
from p in Comp_Applications select new{p.RowId,p.CompNumber}
from p in Comp_Applications select new{Comp_Number=p.CompNumber}
from p in Comp_Applications select new{ rowid= p.RowId, comp_number= p.CompNumber}
from p in Comp_Applications where p.RowId > 10 select p
from p in Comp_Applications where p.CompNumber==10011 select p
from p in Comp_Applications where p.RowId > 10 && p.CompNumber==10011 select p
from p in Comp_Applications where p.RowId > 10 || p.CompNumber==10011 select p
from p in Comp_Applications orderby p.CreatedBy,p.CompNumber select p
from p in Comp_Applications group p by p.CreatedBy into g select new{ crea=g.Key}
from p in Comp_Applications group p by p.CreatedBy into g select new{ crea=g.Key, count=g.Count()}


var one = from p in Comp_Applications select p;
var two = from p in Comp_Applications select new{ rowid = p.RowId , compNumber = p.CompNumber };
one.Dump();
two.Dump();

from p in Comp_Applications
select new { p.CompNumber, CompeNumber = p.CompNumber > 10005 && p.CompNumber < 10008 ? 1 :
p.CompNumber > 10009 && p.CompNumber < 10020 ? 0:
p.CompNumber,
recDate = p.AppReceivedDate
}


outer join example:-
============================

create table MurCustomer
(
keyId int, customerName varchar(50)
)
create table MurOrder
(
keyId int, OrderNumber varchar(50)
)
insert into MurCustomer values(1,'xx');
insert into MurCustomer values(2,'yy');
insert into MurCustomer values(3,'zz');
insert into MurCustomer values(4,'aa');
insert into MurCustomer values(5,'bb');

insert into MurOrder values(1,'pppp');
insert into MurOrder values(1,'qqqq');
insert into MurOrder values(4,'rrrr');
insert into MurOrder values(5,'ssss');
insert into MurOrder values(5,'tttt');

select * from MurOrder;
select * from MurCustomer;


from c in MurCustomers
join o in MurOrders on c.KeyId equals o.KeyId into g
from o in g.DefaultIfEmpty()
select new {customerNameDisplay = c.CustomerName,
OrderNumber = o == null ? "(no orders)" : o.OrderNumber}


another example:-
===================
create table MurSapeliCover
(
CustomerId int, CoverId int, Cover varchar(50)
)
create table MurCompApplication
(
CompNumber int
)
create table MurCompCustomer
(
CompNumber int, CustId int, CoverId int
)

insert into MurSapeliCover values(1,1,'First cust 1st Cover');
insert into MurSapeliCover values(1,2,'First cust 2nd Cover');
insert into MurSapeliCover values(1,3,'First cust 3rd Cover');
insert into MurSapeliCover values(1,4,'First cust 4th Cover');

insert into MurSapeliCover values(2,1,'Second cust 1st Cover');
insert into MurSapeliCover values(2,5,'Second cust 2nd Cover');
insert into MurSapeliCover values(3,6,'Third cust 1st Cover');
insert into MurSapeliCover values(4,7,'Fourth cust 1st Cover');

insert into MurCompApplication values(1);
insert into MurCompApplication values(2);
insert into MurCompApplication values(3);

insert into MurCompCustomer values(1,1,1);
insert into MurCompCustomer values(2,1,2);
insert into MurCompCustomer values(3,2,1);


select * from MurSapeliCover;
select * from MurCompCustomer;
select * from MurCompApplication;

from c in MurSapeliCovers
join o in MurCompCustomers on new { cid = c.CustomerId, coid=c.CoverId} equals new
{ cid = o.CustId, coid=o.CoverId} into g
from o in g.DefaultIfEmpty()
select new {Cover = c.Cover,
compNumber = o == null ? 0 : o.CompNumber
}


from c in MurSapeliCovers
join o in ( from cu in MurCompCustomers join ca in MurCompApplications
on cu.CompNumber equals ca.CompNumber
select new { CustId = cu.CustId, CoverId = cu.CoverId, CompNumber=ca.CompNumber } )
on new { cid = c.CustomerId, coid=c.CoverId} equals new
{ cid = o.CustId, coid=o.CoverId} into g
from o in g.DefaultIfEmpty()
select new {Cover = c.Cover,
compNumber = o == null ? 0 : o.CompNumber
}

from p in Comp_Customers where p.CustId == 100
select new { p, p.CompNumber, p.CustId }


ClaimsCRUD.GetCustomerSapeliCovers(request);
*/

Sample LINQ Methods

public void SampleMethod()
{
DTOServices.Claims.Address FromAddress = new Sapeli.DTOServices.Claims.Address();
FromAddress.AddressKey = Guid.NewGuid();
FromAddress.City = "Bangalore";
FromAddress.Country = "India";
FromAddress.PAddress = "Mainroad, Marathahalli";
FromAddress.PostalCode = "560037";


DTOServices.Claims.Address ToAddress = new Sapeli.DTOServices.Claims.Address();

PropertyInfo[] propFrom = FromAddress.GetType().GetProperties();
PropertyInfo[] propTo = ToAddress.GetType().GetProperties();

foreach (PropertyInfo p in propFrom)
{
object value = p.GetValue(FromAddress, new object[] { });
//propTo.SetValue(value, 1);

}


//using (InsuranceEntities ctx = new InsuranceEntities())
//{
// var qry = from efcover in ctx.BeneficiaryItem.Include("Beneficiary").Include("Beneficiary.Cover").Include("BeneficiaryTable")
// where efcover.Beneficiary.Cover.ID == new Guid("") && (efcover.RowStatus == 600 || efcover.RowStatus == 900) &&
// efcover.Beneficiary.OrderInsuredIn == 1
// select efcover;

// var qry1 = from p in ctx.BeneficiaryItem.Include("Beneficiary")
// where p.Beneficiary.Cover.ID == new Guid("") select p;

//}

//using (SapeliPrintEntities ctx = new SapeliPrintEntities())
//{
// var qry = from p in ctx.CaseType.Include("Case")
// where p.Case
//}

//using (SapeliPrintEntities insurancePrint = new SapeliPrintEntities())
//{
// CaseType casetype;


//casetype = (from p in insurancePrint.CaseType.Include("Case")
// where p.ID == new Guid("F471F3AA-6804-4871-9B5F-88237234BF42")
// && p.Case.SelectMany( o => o.CaseCreated.Value.Day < 10)
// select p).FirstOrDefault();

//if (casetype != null)
//{
// //casetype.Case.Where(o => o.CaseCreated.Value.Day < 10);
// //casetype.Case.Load();

// //casetype.Case.Attach( casetype.Case.CreateSourceQuery().Where(o=> o.CaseCreated.Value.Day < 10 ));

// //casetype.CoverItem.Attach(cover.CoverItem.CreateSourceQuery().Where(o => o.RowStatus == 600));
//}


//var roles = from role in ctx.InsuranceRole.Include("InsuranceRoleItem")
// where role.RowStatus == 600 &&
// role.fk_Covers == coverid
// select role;

//foreach (InsuranceRole role in roles)
//{
// role.RowStatus = 900;
// foreach (InsuranceRoleItem item in role.InsuranceRoleItem.Where(o => o.RowStatus == 600))
// {
// item.RowStatus = 900;
// }
//}

//using (Sapeli_InvoiceEntities ctx = new Sapeli_InvoiceEntities())
//{
// IEnumerable invoices = ctx.CreateQuery(query).ToList().DefaultIfEmpty();
// return invoices.ToList();
//}

//var invoice = ctx.Invoice.Include("InvoiceAmount")
// .Where(i => i.InsuranceNo == insuranceNo)
// .Where(i => i.InvoiceStartDate < searchDate)
// .Where(i => i.InvoiceEndDate > searchDate).ToList().DefaultIfEmpty();


//var qry = insurancePrint.CaseType.Where(p => p.CaseCode != "");

//IEnumerable
//objCaseCollection = from p in insurancePrint.CaseType.Include("Case") //.Include("CaseType")
// select p;
//foreach (CaseType objCase in objCaseCollection)
//{

//}

//var qry1 = (from p in insurancePrint.CaseType select p).FirstOrDefault();
//qry1.Case.Load();
//foreach (CaseType obj in objCaseCollection)
//{

//}

//// IEnumerable results = ctx.CreateQuery ("SELECT * FROM [Sapeli_Invoice].[dbo].[Invoice]");

// var qry = from p in insurancePrint.CaseType select p;

// //IEnumerable objFilter = objCaseCollection.Where(p => p.CaseCode == "703");



// //IEnumerable
// //objCaseCollection = from p in insurancePrint.MasterInsurance.Include("InsuranceRole").Include("InsuranceRole.InsuranceRoleItem").Include("InsuranceRole.InsuranceRoleContactInfo")
// // select p;

// foreach (CaseType objCase in objCaseCollection)
//{

//}
//}
}

LINQ terminology

Lazy Loading (or) Deferred Loading
----------------------------------

Refer to : http://dotnetslackers.com/articles/csharp/Load-Lazy-in-LINQ-to-SQL.aspx

Lazy loading indicates the DAL’s ability to load only a portion of the object graph based on some rules. When you add this capability to your DAL, you have implemented the “Lazy Load” pattern (LL).

Lazy loading describes the behavior of an object that doesn’t hold all the data it needs. The object, though, does know how to retrieve missing data on demand. When you load an instance of, say, a Customer entity in a lazy loading model only essential data is loaded—for example, only personal information. Later, when some piece of code needs to go through orders associated with the customer, missing information is located and loaded.


How to disable lazy loading:
----------------------------

NorthwindDataContext ctx = new NorthwindDataContext();
ctx.DeferredLoadingEnabled = false;


Advantage of O/RM (object/relational mapper) tools :
-------------------------

O/RM tools are powerful instruments that save developers a lot of work and are becoming a necessary tool every day. However, you cannot blindly delegate tools the generation of the database code. Make sure you cross-check any T-SQL code and use the SQL profiler extensively during development. If you don’t like the database code being generated, change it. Sometimes you can do better by simply tweaking the O/RM configuration; sometimes you need to manually rewrite the T-SQL code.

Refer to : http://blogs.msdn.com/gblock/archive/2006/10/26/ten-advantages-of-an-orm.aspx


Ten advantages of an ORM (Object Relational Mapper) :
-----------------------------------------------------

1. Facilitates implementing the Domain Model pattern (Thanks Udi). This one reason supercedes all others. In short using this pattern means that you model entities based on real business concepts rather than based on your database structure. ORM tools provide this functionality through mapping between the logical business model and the physical storage model.

2. Huge reduction in code. ORM tools provide a host of services thereby allowing developers to focus on the business logic of the application rather than repetitive CRUD (Create Read Update Delete) logic.

3. Changes to the object model are made in one place. One you update your object definitions, the ORM will automatically use the updated structure for retrievals and updates. There are no SQL Update, Delete and Insert statements strewn throughout different layers of the application that need modification.

4. Rich query capability. ORM tools provide an object oriented query language. This allows application developers to focus on the object model and not to have to be concerned with the database structure or SQL semantics. The ORM tool itself will translate the query language into the appropriate syntax for the database.

5. Navigation. You can navigate object relationships transparently. Related objects are automatically loaded as needed. For example if you load a PO and you want to access it's Customer, you can simply access PO.Customer and the ORM will take care of loading the data for you without any effort on your part.

6. Data loads are completely configurable allowing you to load the data appropriate for each scenario. For example in one scenario you might want to load a list of POs without any of it's child / related objects, while in other scenarious you can specify to load a PO, with all it's child LineItems, etc.

7. Concurrency support. Support for multiple users updating the same data simultaneously.

8. Cache managment. Entities are cached in memory thereby reducing load on the database.

9. Transaction management and Isolation. All object changes occur scoped to a transaction. The entire transaction can either be committed or rolled back. Multiple transactions can be active in memory in the same time, and each transactions changes are isolated form on another.

10. Key Management. Identifiers and surrogate keys are automatically propogated and managed.


If your developing short lifespan applications then it really doesn't matter.

If you're developing long standing enterprise level applications there should be a separation of concerns. The business model should not be running CRUD operations. There should also be persistence ignorance which means loose coupling between ui/model and data access. Why? What happens when MS decides to come out with the next grand data access framework in 4-5 years and linq to sql becomes deprecated? You have to rewrite your most of your app just to use the new framework. If you google the underlined phrases you'll find a lot of information on these subjects.

C Programs 1

program 11:
#include
#include
void main()
{
int a,b;

clrscr();

a = 10; b = 20;
printf("Addition is : %d",a+b);

printf("%s\n","any key is ok for me, Press");
getch();
}


Program 12 :
#include
#include
void main()
{
int first, second;
int add_result;
int multi_result;
int div_result;
int subtract_result;

clrscr();
printf("%s","Enter First Value : "); scanf("%d",&first);
printf("%s","Enter Second Value : "); scanf("%d",&second);

add_result = first + second;
multi_result = first * second;
div_result = first / second;
subtract_result = first - second;

printf("First Value : %d\n",first);
printf("Second Value : %d\n",second);

printf("%s\n","---------------------------------");
printf("Addition result : %d\n",add_result);
printf("Division result : %d\n",div_result);
printf("Subtract result : %d\n",subtract_result);
printf("Multiplication result : %d\n",multi_result);
printf("%s\n","---------------------------------");

printf("%s\n","any key is ok for me, Press");
getch();
}


Program 13 :
#include
#include
void main()
{
int EmpNo = 121;
float Salary = 25000;

clrscr();

printf("%s","Values entered by you are : ");
printf("Employee Number : %d\n",EmpNo);
printf("Salary : %f\n",Salary);

printf("%s\n","any key is ok for me, Press");
getch();
}

Program 14 :
#include
#include
void main()
{
int EmpNo;
float Salary;

clrscr();

printf("%s\n","Enter the following details : ");
printf("%s","Employee Number : "); scanf("%d\n",&EmpNo);
printf("%s","Salary : "); scanf("%f\n",&Salary);

printf("%s","Values entered by you are : ");
printf("%s","Employee Number : "); printf("%d\n",EmpNo);
printf("%s","Salary : "); printf("%f\n",Salary);

printf("%s\n","any key is ok for me, Press");
getch();
}


Program 15 :
#include
#include
void main()
{
int AdmissionNo = 1234;
char[20] StudentName = "Swathi";
int Maths, Physics, Chemistry;
int TotalMarks;

Maths = 87; Physics = 95; Chemistry = 92;
TotalMarks = Maths + Physics + Chemistry;

clrscr();

printf("%s\n","-----------------------------------------------");
printf("%s\n","SRI Y.N.COLLEGE, NARSAPUR, WG DT.");
printf("%s\n","-----------------------------------------------");
printf("Student Admission Number : %s\n",AdmissionNo);
printf("Student Name : %s\n",StudentName);
printf("Maths : %d\n",Maths);
printf("Physics : %d\n",Physics);
printf("Chemistry : %d\n",chemistry);
printf("Total : %d\n",TotalMarks);
printf("%s","-----------------------------------------------");

printf("%s\n","Press any key to back to the application");
getch();
}

Program 16 :
#include
#include
void main()
{
int AdmissionNo;
char[20] StudentName = "Swathi";
int Maths, Physics, Chemistry;
int TotalMarks;
float Percentage;

clrscr();

printf("%s","Enter Student Admission Number "); scanf("%d",&AdmissionNo);
printf("%s","Enter Maths Marks : "); scanf("%d",&Maths);
printf("%s","Enter Physics Marks : "); scanf("%d",&Physics);
printf("%s","Enter Chemistry Marks : "); scanf("%d",&Chemistry);

TotalMarks = Maths + Physics + Chemistry;
Percentage = TotalMarks / 3;

printf("%s\n","-----------------------------------------------");
printf("%s\n","SRI Y.N.COLLEGE, NARSAPUR, WG DT.");
printf("%s\n","-----------------------------------------------");
printf("Student Admission Number : %s\n",AdmissionNo);
printf("Student Name : %s\n",StudentName);
printf("Maths : %d\n",Maths);
printf("Physics : %d\n",Physics);
printf("Chemistry : %d\n",chemistry);
printf("Total : %d\n",TotalMarks);
printf("Percent : %f\n",Percentage);
printf("%s","-----------------------------------------------");

printf("%s\n","Press any key to back to the application");
getch();
}


Program 17 :
#include
#include
void main()
{
int EmpNo;
char[20] EmpName = "Swathi";
float Basic;
float DA;
float HRA;
float SplAllow;
float IncomeTax;
float NetSalary

clrscr();

printf("%s\n","Enter the following details : ");
printf("%s","Employee Number : "); scanf("%d\n",&EmpNo);
printf("%s","Basic Salary : "); scanf("%f\n",&Basic);

DA = Basic * 0.01;
HRA = Basic * 0.01;
SplAllow = Basic * 0.02;
IncomeTax = Basic * 0.05;

NetSalary = (Basic + DA + HRA + SplAllow) - IncomeTax;

printf("%s","-----------------------------------------------");
printf("%s","Values entered by you are : ");
printf("%s","-----------------------------------------------");
printf("%s","Employee Number : "); printf("%d\n",EmpNo);
printf("%s","Employee Name : "); printf("%s\n",EmpName);
printf("%s","Basic Salary : "); printf("%f\n",Basic);
printf("%s","DA : "); printf("%f\n",DA);
printf("%s","HRA : "); printf("%f\n",HRA);
printf("%s","Special Allow : "); printf("%f\n",SplAllow);
printf("%s","Income Tax : "); printf("%f\n",IncomeTax);
printf("%s","-----------------------------------------------");
printf("%s","Net Salary : "); printf("%f\n",NetSalary);
printf("%s","-----------------------------------------------");

printf("%s\n","Press any key to back to the application");
getch();
}



Program 18 :
#include
#include
void main()
{
int radius;

clrscr();

printf("%s","Enter circle radius: "); scanf("%d",&radius);

// perimeter formula is 2 * pi * radius
printf("%s","circle perimeter: "); printf("%d\n",2 * 3.14 * radius);

// area formula is pi * radius * radius
printf("%s","circle Area : "); printf("%d\n", 3.14 * radius * radius);

printf("%s\n","any key is ok for me, Press");
getch();
}

Program 19 :
#include
#include
void main()
{
int radius;
int area, perimeter;
float PI = 3.14; // this is called as a constant value.

clrscr();

printf("%s","Enter circle radius: "); scanf("%d",&radius);

perimeter = 2 * PI * radius;
area = PI * radius * radius

printf("%s","circle perimeter : "); printf("%d\n",perimeter);
printf("%s","circle Area : "); printf("%d\n", area);

printf("%s\n","any key is ok for me, Press");
getch();
}


Program 20 :
#include
#include
void main()
{
int maths;

clrscr();

printf("%s","Enter Mathematics Marks : "); scanf("%d",&maths);

if( maths >= 35)
{
printf("%s\n","Student passed in maths exam")
}
else
{
printf("%s\n","Student failed !!")
}

printf("%s\n","any key is ok for me, Press");
getch();
}

Program 21 :
#include
#include
void main()
{
int percentage;

clrscr();

printf("%s","Enter marks percentage : "); scanf("%d",&percentage);

if( percentage >= 60)
{
printf("%s","Student got first class, He is excellent");
}
else if( percentage >= 50)
{
printf("%s","Student got second class, He is good");
}
else if( percentage >= 35)
{
printf("%s","Student just pass the exam, He is ok");
}
else if( percentage < 35)
{
printf("%s","Student failed the exam, Better luck next time");
}


printf("%s\n","any key is ok for me, Press");
getch();
}