with cte
as
(
select *, row_number() over (partition by userid order by id desc) RowNumber from emp_leavehistory
)
select * from cte where RowNumber =1
.net engine
Friday 8 March 2013
Saturday 1 December 2012
email validation in mvc from server side
/// <summary>
/// No Metadata Documentation available.
/// </summary>
[MetadataType(typeof(MM_User_Validation))]
[EdmEntityTypeAttribute(NamespaceName="ModelsPointModel", Name="MM_User")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class MM_User : EntityObject
{
#region Factory Method
/// <summary>
/// No Metadata Documentation available.
/// </summary>
///
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String EmailId
{
get
{
return _EmailId;
}
set
{
OnEmailIdChanging(value);
ReportPropertyChanging("EmailId");
_EmailId = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("EmailId");
OnEmailIdChanged();
}
}
private global::System.String _EmailId;
partial void OnEmailIdChanging(global::System.String value);
partial void OnEmailIdChanged();
}
#endregion
}
///<summary>
///Meta Class
/// </summary>
public class MM_User_Validation
{
[Required(ErrorMessage= "Error Message")]
[RegularExpression("^a[a-z0-9_\\+-]+(\\.[a-z0-9_\\+-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*\\.([a-z]{2,4})$",ErrorMessage="Invalid email Address")]
public string EmailId{get;set;}
}
/// No Metadata Documentation available.
/// </summary>
[MetadataType(typeof(MM_User_Validation))]
[EdmEntityTypeAttribute(NamespaceName="ModelsPointModel", Name="MM_User")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class MM_User : EntityObject
{
#region Factory Method
/// <summary>
/// No Metadata Documentation available.
/// </summary>
///
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
[DataMemberAttribute()]
public global::System.String EmailId
{
get
{
return _EmailId;
}
set
{
OnEmailIdChanging(value);
ReportPropertyChanging("EmailId");
_EmailId = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("EmailId");
OnEmailIdChanged();
}
}
private global::System.String _EmailId;
partial void OnEmailIdChanging(global::System.String value);
partial void OnEmailIdChanged();
}
#endregion
}
///<summary>
///Meta Class
/// </summary>
public class MM_User_Validation
{
[Required(ErrorMessage= "Error Message")]
[RegularExpression("^a[a-z0-9_\\+-]+(\\.[a-z0-9_\\+-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*\\.([a-z]{2,4})$",ErrorMessage="Invalid email Address")]
public string EmailId{get;set;}
}
Friday 19 October 2012
compare two date type variable in asp .net
DateTime.Compare(_currentdate, _dt1)<0 // dt1>currentdate
DateTime.Compare(_currentdate, _dt1)>0 // dt1<currentdate
DateTime.Compare(_currentdate, _dt1)=0 // dt1=>currentdate
DateTime.Compare(_currentdate, _dt1)>0 // dt1<currentdate
DateTime.Compare(_currentdate, _dt1)=0 // dt1=>currentdate
Wednesday 3 October 2012
read xml node using jquery
<script language="javascript" type="text/javascript">
var xmlDoc;
// try {
//
// xmlDoc=new ActiveXObject("Msxml2.DOMDocument.6.0");
// xmlDoc.async=false;
// xmlDoc.load("./mydata/Catalog.xml");
// }
// catch(e)
// {
// alert(e);
// }
function loadXMLDoc(dname) {
if (window.XMLHttpRequest) {
xhttp = new XMLHttpRequest();
}
else {
xhttp = new ActiveXObject("Msxml2.DOMDocument.6.0");
}
xhttp.open("GET", dname, false);
xhttp.send("");
return xhttp.responseXML;
}
xmlDoc = loadXMLDoc("./mydata/Catalog.xml");//path of xml file
function RunQuery()
{
var s="";
var i;
var query=document.f1.t1.value;
alert(query);
// var nodes=xmlDoc.selectNodes(query);
// s+="<br/><b>"+nodes[0].nodeName+"</b><br/><hr/>";
//
// for(i=0;i<nodes.length;i++)
// {
// s+="<Li>"+nodes[i].childNodes[0].nodeValue+"<Li><br/>";
// }
path = "/catalog/cd/" + query;
if (window.ActiveXObject) {
var nodes = xmlDoc.selectNodes(path);
for (i = 0; i < nodes.length; i++) {
document.write(nodes[i].childNodes[0].nodeValue);
document.write("<br />"); }
}
else if (document.implementation && document.implementation.createDocument) {
var nodes = xmlDoc.evaluate(path, xmlDoc, null, XPathResult.ANY_TYPE, null);
var result = nodes.iterateNext();
alert(result);
while (result) {
document.write(result.childNodes[0].nodeValue);
document.write("<br />");
result = nodes.iterateNext();
}
document.getElementById("msg").innerHTML = result;
}
}
</script>
<form id="f1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Names="Times New Roman"
Font-Size="X-Large" Text="Enter Your Query : "></asp:Label>
<input id="t1" style="width: 291px" type="text" /><br />
<br />
<input id="Button1" type="button" value="Run" onClick="RunQuery()" /></div>
<div id="msg">
</div>
</form>
var xmlDoc;
// try {
//
// xmlDoc=new ActiveXObject("Msxml2.DOMDocument.6.0");
// xmlDoc.async=false;
// xmlDoc.load("./mydata/Catalog.xml");
// }
// catch(e)
// {
// alert(e);
// }
function loadXMLDoc(dname) {
if (window.XMLHttpRequest) {
xhttp = new XMLHttpRequest();
}
else {
xhttp = new ActiveXObject("Msxml2.DOMDocument.6.0");
}
xhttp.open("GET", dname, false);
xhttp.send("");
return xhttp.responseXML;
}
xmlDoc = loadXMLDoc("./mydata/Catalog.xml");//path of xml file
function RunQuery()
{
var s="";
var i;
var query=document.f1.t1.value;
alert(query);
// var nodes=xmlDoc.selectNodes(query);
// s+="<br/><b>"+nodes[0].nodeName+"</b><br/><hr/>";
//
// for(i=0;i<nodes.length;i++)
// {
// s+="<Li>"+nodes[i].childNodes[0].nodeValue+"<Li><br/>";
// }
path = "/catalog/cd/" + query;
if (window.ActiveXObject) {
var nodes = xmlDoc.selectNodes(path);
for (i = 0; i < nodes.length; i++) {
document.write(nodes[i].childNodes[0].nodeValue);
document.write("<br />"); }
}
else if (document.implementation && document.implementation.createDocument) {
var nodes = xmlDoc.evaluate(path, xmlDoc, null, XPathResult.ANY_TYPE, null);
var result = nodes.iterateNext();
alert(result);
while (result) {
document.write(result.childNodes[0].nodeValue);
document.write("<br />");
result = nodes.iterateNext();
}
document.getElementById("msg").innerHTML = result;
}
}
</script>
<form id="f1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Names="Times New Roman"
Font-Size="X-Large" Text="Enter Your Query : "></asp:Label>
<input id="t1" style="width: 291px" type="text" /><br />
<br />
<input id="Button1" type="button" value="Run" onClick="RunQuery()" /></div>
<div id="msg">
</div>
</form>
Tuesday 2 October 2012
how to filter data in generic list in asp .net
List<_tbl> _objuser = new List<_tbl>();
var newobj = _objuser.FindAll(delegate(_tbl p) {
return (DateTime.Compare(p.RequestDate.Value.Date, dt1.Date) >= 0) && (DateTime.Compare(dt2.Date,p.RequestDate.Value.Date) >= 0);
}
);
var newobj = _objuser.FindAll(delegate(_tbl p) {
return (DateTime.Compare(p.RequestDate.Value.Date, dt1.Date) >= 0) && (DateTime.Compare(dt2.Date,p.RequestDate.Value.Date) >= 0);
}
);
convert dd/MM/yyyy into MM/dd/yyyy in asp .net
DateTime dt1 = Convert.ToDateTime((DateTime.ParseExact(txtRequestFromDate.Text, "dd/MM/yyyy", null).ToString("MM/dd/yyyy")));
Friday 26 August 2011
Subscribe to:
Posts (Atom)