.NET Diary

January 21, 2009

DateTime Validation using Javascript

Filed under: All, ASP.NET, Javascript — leoullas @ 10:51 am

function Check()

    {

        doOnOff(‘off’);

        var dtStart = document.getElementById(‘<%=txtStartDate.ClientID%>’).value;

           var dtEnd = document.getElementById(‘<%=txtEndDate.ClientID%>’).value;

 

 

           var pos1=dtStart.indexOf(dtCh)

           var strDay1=dtStart.substring(pos1)

           var pos2=dtEnd.indexOf(dtCh)

           var strDay2=dtEnd.substring(pos2)

               if(pos1>2)

               {

                     alert(“The date format should be : mm/dd/yyyy”);

                      return false;

               }

            else if (strDay1.length>8 )

               {

                      alert(“The date format should be : mm/dd/yyyy”);

                      return false;

               }

               else if(pos2>2 )

               {

                     alert(“The date format should be : mm/dd/yyyy”);

                      return false;

               }

            else if (strDay2.length>8 )

               {

                      alert(“The date format should be : mm/dd/yyyy”);

                      return false;

               }

              

               else if (dtEnd.length>10)

               {

                   alert(“The date format should be : mm/dd/yyyy”);

                   return false;

               }

               else if (isDate(dtStart)==false)

               {

            document.getElementById(‘<%=txtStartDate.ClientID%>’).focus();

            return false;

               }

               else if (isDate(dtEnd)==false)

               {

                document.getElementById(‘<%=txtEndDate.ClientID%>’).focus();

                return false;

               }

            else

            {    

                   //check bigger

                   if(Date.parse(dtStart)>0 && Date.parse(dtEnd)>0)

                           {

                         

                       if (Date.parse(dtStart) > Date.parse(dtEnd))    

                            { 

                               alert(‘<%=ShellUtility.GetMessageDetails(“1028”)%>’);                    

                               return false;

                              }

                           else

                                   { 

                                   var diff_date = Date.parse(dtEnd) – Date.parse(dtStart);

                                   if(diff_date > 2592000000)

                                   {

                                       alert(‘<%=ShellUtility.GetMessageDetails(“1027”)%>’);

                                       return false;

                                    }

                                else

                                    {

                                        return true;

                                    }           

                                   }

                           }

                      else

                           {

                            alert(‘<%=ShellUtility.GetMessageDetails(“5027”)%>’);

                            return false;

                           }

                  }

    }

//This Part is to check Date formattings

    var dtCh= “/”;   

//     var constMinYear = 1900;

//  var constMaxYear = 2020;

 

    function isInteger(s){

           var i;

        for (i = 0; i < s.length; i++){  

            // Check that current character is number.

            var c = s.charAt(i);

            if (((c < “0”) || (c > “9”))) return false;

        }

        // All characters are numbers.

        return true;

    }

 

    function stripCharsInBag(s, bag){

           var i;

        var returnString = “”;

        // Search through string’s characters one by one.

        // If character is not in bag, append to returnString.

        for (i = 0; i < s.length; i++){  

            var c = s.charAt(i);

            if (bag.indexOf(c) == -1) returnString += c;

        }

        return returnString;

    }

 

    function daysInFebruary (year){

        // February has 29 days in any year evenly divisible by four,

        // EXCEPT for centurial years which are not also divisible by 400.

        return (((year % 4 == 0) && ( (!(year % 100 == 0)) || (year % 400 == 0))) ? 29 : 28 );

    }

    function DaysArray(n) {

           for (var i = 1; i <= n; i++) {

                  this[i] = 31;

                  if (i==4 || i==6 || i==9 || i==11) {this[i] = 30;}

                  if (i==2) {this[i] = 29;}

       }

       return this;

    }

 

    function isDate(dtStr){

           var daysInMonth = DaysArray(12)

           var pos1=dtStr.indexOf(dtCh)

           var pos2=dtStr.indexOf(dtCh,pos1+1)

           var strMonth=dtStr.substring(0,pos1)

           var strDay=dtStr.substring(pos1+1,pos2)

           var strYear=dtStr.substring(pos2+1)

           strYr=strYear

           if (strDay.charAt(0)==“0” && strDay.length>1) strDay=strDay.substring(1);

           if (strMonth.charAt(0)==“0” && strMonth.length>1) strMonth=strMonth.substring(1);

           for (var i = 1; i <= 3; i++) {

                  if (strYr.charAt(0)==“0” && strYr.length>1) strYr=strYr.substring(1);

           }

           month=parseInt(strMonth);

           day=parseInt(strDay);

           year=parseInt(strYr);

           if (pos1==-1 || pos2==-1){

                  alert(“The date format should be : mm/dd/yyyy”);

                  return false;

           }

           if (strMonth.length<1 || month<1 || month>12){

                  alert(“Please enter a valid month”);

                  return false;

           }

           if (strDay.length<1 || day<1 || day>31 || (month==2 && day>daysInFebruary(year)) || day > daysInMonth[month]){

                  alert(“Please enter a valid day”);

                  return false;

           }

           if (strYear.length != 4 || year==0 || year<constMinYear || year>constMaxYear){

                  alert(“Please enter a valid 4 digit year between “+constMinYear+” and “+constMaxYear);

                  return false;

           }

           if (dtStr.indexOf(dtCh,pos2+1)!=-1 || isInteger(stripCharsInBag(dtStr, dtCh))==false){

                  alert(“Please enter a valid date”);

                  return false;

           }

    return true;

    }

Advertisements

ERROR : Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

Filed under: All, ASP.NET — leoullas @ 10:42 am

failed-to-enable-constraints-one-or-more-rows-contain-values-violating-non-null-unique-or-foreign-key-constraints-2

failed-to-enable-constraints-one-or-more-rows-contain-values-violating-non-null-unique-or-foreign-key-constraints-2

1. Chek NULL in database-table and use ISNULL .

2. If there is some column in DataCarrier where AllowDBNull is False, always select that column from SP level whether it is required or not.

failed-to-enable-constraints-one-or-more-rows-contain-values-violating-non-null-unique-or-foreign-key-constraints

failed-to-enable-constraints-one-or-more-rows-contain-values-violating-non-null-unique-or-foreign-key-constraints

SQL error : Conversion failed when converting datetime from character string

Filed under: All, SQL — leoullas @ 10:29 am

 

sql-error-conversion-failed-when-converting-datetime-from-character-string

sql-error-conversion-failed-when-converting-datetime-from-character-string

In case of two THEN conditions of the CASE statement reference expressions of different data types. In this case, SQL Server implicitly converts the data type for the entire CASE expression to the data type in the THEN clause that has the highest order of data-type precedence. (See the SQL Server Books Online (BOL) topic “Data Type Precedence.”)

BEFORE:

declare @SortExpression varchar(20)

set @SortExpression =‘OverSpeed’

 

SELECT        Journey_Id,

                     Drv_ID,

                     Journey_Start_Dt AS ‘StartDateTime’,

                     Journey_End_Dt AS ‘EndDateTime’,

                     Journey_Time_Sec AS ‘TotalTime’,

                     Journey_Dest_Miles AS ‘TotalDistance’,

                     Max_Speed_Mph AS ‘MAXSpeed’,

                     Brake_Flg AS ‘AggDriving’,

                     OverSpeed_Flg AS ‘OverSpeed’

FROM         DRIVER_JOURNEY_INFO AS td

WHERE     (Company_Id = 9003) AND (Drv_ID = 2017) AND (Journey_Start_Dt BETWEEN ’08/01/2008′ AND ’09/30/2008′) AND

                      (Journey_End_Dt BETWEEN ’08/01/2008′ AND ’09/30/2008′)

ORDER BY

              CASE

                     WHEN @SortExpression = ‘Journey_Id’ THEN Journey_Id

                     WHEN @SortExpression = ‘StartDateTime’ THEN Journey_Start_Dt

                     WHEN @SortExpression = ‘EndDateTime’ THEN Journey_End_Dt

                     WHEN @SortExpression = ‘TotalTime’ THEN Journey_Time_Sec

                     WHEN @SortExpression = ‘TotalDistance’ THEN Journey_Dest_Miles

                     WHEN @SortExpression = ‘MAXSpeed’ THEN Max_Speed_Mph

                     WHEN @SortExpression = ‘AggDriving’ THEN Brake_Flg

                     WHEN @SortExpression = ‘OverSpeed’ THEN OverSpeed_Flg

              ELSE Journey_Id

              END

DESC

CORRECTED:

 

 

ORDER BY

CASE

       WHEN @SortExpression = ‘Journey_Id’ THEN Journey_Id 

       WHEN @SortExpression = ‘StartDateTime’ THEN Journey_Start_Dt 

       WHEN @SortExpression = ‘EndDateTime’ THEN Journey_End_Dt 

       WHEN @SortExpression = ‘TotalTime’ THEN Journey_Time_Sec 

       WHEN @SortExpression = ‘TotalDistance’ THEN Journey_Dest_Miles                                         WHEN @SortExpression = ‘MAXSpeed’ THEN Max_Speed_Mph

       WHEN @SortExpression = ‘TAII’ THEN (CAST(TAI_Time_Sec AS DECIMAL(18,2))/Journey_Time_Sec)*10

       WHEN @SortExpression = ‘TIP’ THEN (CAST(TI_Time_Sec AS DECIMAL(18,2))/Journey_Time_Sec)*100

       WHEN @SortExpression = THEN Journey_Id

       END 

       DESC,

       CASE WHEN @SortExpression = ‘AggDriving’ THEN Brake_Flg END  DESC,

   CASE WHEN @SortExpression = ‘OverSpeed’ THEN OverSpeed_Flg END  DESC

Web environment: use ViewState instead of global variable

Filed under: All, ASP.NET — leoullas @ 10:19 am

A small piece of code…

protected void Page_Load(object sender, EventArgs e)

    {      

        QueryStringHandler.EnsureURLNotTampered(Request.QueryString);

        if (!this.IsPostBack)

        {

            ViewState[“firstTimeLoad”] = “No”;//CR 140 Map message

            Page.Validate();//

            this._presenter.OnViewInitialized();

            InitialLoad();

            ViewState[“firstTimeLoad”] = “Yes”;//CR 140 Map message

        }

        if (gvDriver.HeaderRow != null)

            ShellUtility.GridViewHeadertemplate(gvDriver, gvDriver.HeaderRow, SortExpression, SortOrder);

        this._presenter.OnViewLoaded();

}

While calling

            if (ViewState[“firstTimeLoad”].Equals(“Yes”))//CR 140 Map message

            {

                ShellUtility.GridViewHeadertemplate(gvDriver, e.Row, SortExpression, SortOrder);

         }//CR 140 Map message

Textbox getting emptied (Passwords etc) while button clicking: Solution

Filed under: All, ASP.NET, C# — leoullas @ 10:10 am

 Put the following piece of code in your aspx.cs file where the pwd-text is getting emptied.

        if (txtPassword.Text != string.Empty)

        {

            txtPassword.Attributes.Add(“value”, txtPassword.Text);

        }

        if (txtConfirmPwd.Text != string.Empty)

        {

            txtConfirmPwd.Attributes.Add(“value”, txtConfirmPwd.Text);

        }

Trim() in Javascript()

Filed under: All, Javascript — leoullas @ 10:07 am

 

function trim(str, chars) {

              return ltrim(rtrim(str, chars), chars);

}

 

function ltrim(str, chars) {

              chars = chars || “\\s”;

              return str.replace(new RegExp(“^[“ + chars + “]+”, “g”), “”);

}

 

function rtrim(str, chars) {

              chars = chars || “\\s”;

              return str.replace(new RegExp(“[“ + chars + “]+$”, “g”), “”);

}

Syntax error in TextHeader of StoredProcedure

Filed under: All, Javascript, SQL — leoullas @ 8:46 am

Microsoft SQL Server Management Studio get this error when trying to modify script the above stored procedure

    

syntax-error-in-textheader-of-storedprocedure1
syntax-error-in-textheader-of-storedprocedure1

Script failed for StoredProcedure ‘dbo.usp_Edit_User’.  (Microsoft.SqlServer.Smo)

Syntax error in TextHeader of StoredProcedure ‘usp_Edit_User’. (Microsoft.SqlServer.Smo)

 Solve:

You have nested comments before your ALTER PROC, which is not possible in TSQL.  Change your header.

BEFORE:

/*

exec usp_Edit_User @Company_Id=N’9003′, @User_Id=N’WWWWWWWWWWWWWWWWWWWW’,/* @Password=N’dris#12345′,*/ @User_Name=N’cWWWWWW’, @Role_Id =N’1′, @Branch_Id=N’13001′, @Is_Locked=N’True’, @Active_Flg=N’Y’, @Modified_By=N’Test_001′, @UserTimeStamp=N’106060′

*/

CORRECTED:

 

exec usp_Edit_User @Company_Id=N’9003′, @User_Id=N’WWWWWWWWWWWWWWWWWWWW’, @User_Name=N’cWWWWWW’, @Role_Id =N’1′, @Branch_Id=N’13001′,@Is_Locked=N’True’,@Active_Flg=N’Y’, @Modified_By=N’Test_001′, @UserTimeStamp=N’106060′

Calling Javascript Alert from aspx.cs file

Filed under: All, ASP.NET — leoullas @ 8:44 am

 

ScriptManager.RegisterStartupScript(this, typeof(UpdatePanel), “Myscript”, “alert(‘Can not delete logged in user.’);”, true);

//string  myscript = “function Hello() { alert(‘Hi’);}”;

//Page.ClientScript.RegisterClientScriptBlock(this.GetType(), “MyScript”, myscript, true);          

//ScriptManager.RegisterClientScriptBlock(this, typeof(Page), “Myscript”, myscript, true);

Update Panel Demo

Filed under: All, ASP.NET — leoullas @ 8:41 am

<form id=”form1″ runat=”server”>
        <asp:ScriptManager ID=”ScriptManager1″ runat=”server”>
        </asp:ScriptManager>
    <div>
        Label outside the Update Panel Refreshed at:
        <asp:Label ID=”Label2″ runat=”Server”></asp:Label>
        <br />
        <br />
        <asp:Button ID=”Button1″ runat=”Server” Text=”Refresh” OnClick=”Button1_Click” />
        <br />
        <br />
        <asp:UpdatePanel ID=”UpdatePanel1″ runat=”Server” UpdateMode=”conditional”>
        <ContentTemplate>
            Label within the Update Panel Refreshed at:
            <asp:Label ID=”Label1″ runat=”server”></asp:Label>       
        </ContentTemplate>
        <Triggers>
            <%–<asp: PostBackTrigger ControlID=”Button1″ />–%>
            <asp:AsyncPostBackTrigger ControlID=”Button1″ EventName=”Click” />
        </Triggers>      
        </asp:UpdatePanel>   
    </div>
    </form>

 

Code behind

 protected void Page_Load(object sender, EventArgs e)
    {
        Label1.Text = System.DateTime.Now.ToString();
        Label2.Text = System.DateTime.Now.ToString();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
       
    }

Trim White Spaces within words

Filed under: All, ASP.NET — leoullas @ 8:37 am

using System.Text.RegularExpressions;
private string RemoveSpaces(string str)
{

string result = “”;

Regex regulEx = new Regex(@”[\s]+”);

result = regulEx.Replace(str,” “);

return result;
}
The above function receives a string and trims all the occurances of extra white spaces between words.
So, an input of “Hey   this       is     a     Word” will return the output as “Hey this is a Word

Older Posts »

Create a free website or blog at WordPress.com.

%d bloggers like this: