Friday 8 March 2013

how to get non duplicated records in sql server

with cte
as
(
select *, row_number() over (partition by userid order by id desc) RowNumber from emp_leavehistory
)

select * from cte where RowNumber =1

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;}
   
      }

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

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>&nbsp;
        <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);
                }
                );

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")));