Javascript validate date time [safest way]

<script type="text/javascript" language="javascript">

 

        function isLeapYear() {

            return (year % 4 != 0 ? false :

                ( year % 100 != 0? true:

                ( year % 1000 != 0? false : true)));

        }

 

        function isValidDate(date_string) {

            var days = [0,31,28,31,30,31,30,31,31,30,31,30,31];

            var year, month, day, date_parts = null;

            var rtrn = false;

            var format = 'mm/dd/yyyy';

            var decisionTree = {

                'm/d/y':{

                    're':/^(\d{1,2})[./-](\d{1,2})[./-](\d{2}|\d{4})$/,

                    'month': 1,'day': 2, year: 3

                },

                'mm/dd/yy':{

                    're':/^(\d{1,2})[./-](\d{1,2})[./-](\d{2})$/,

                    'month': 1,'day': 2, year: 3

                },

                'mm/dd/yyyy':{

                    're':/^(\d{1,2})[./-](\d{1,2})[./-](\d{4})$/,

                    'month': 1,'day': 2, year: 3

                },

                'y/m/d':{

                    're':/^(\d{2}|\d{4})[./-](\d{1,2})[./-](\d{1,2})$/,

                    'month': 2,'day': 3, year: 1

                },

                'yy/mm/dd':{

                    're':/^(\d{1,2})[./-](\d{1,2})[./-](\d{1,2})$/,

                    'month': 2,'day': 3, year: 1

                },

                'yyyy/mm/dd':{

                    're':/^(\d{4})[./-](\d{1,2})[./-](\d{1,2})$/,

                    'month': 2,'day': 3, year: 1

                }

            };

            var test = decisionTree[format];

            if (test) {

                date_parts = date_string.match(test.re);

                if (date_parts) {

                    year = date_parts[test.year] * 1;

                    month = date_parts[test.month] * 1;

                    day = date_parts[test.day] * 1;

 

                    test = (month == 2 &&

                            isLeapYear() &&

                            29 ||

                            days[month] || 0);

 

                    rtrn = 1 <= day && day <= test;

                }

            }

            return rtrn;

        }

    </script>

 

 

Javascript Popup with dataentry

HTML Markup :

 

<asp:Button ID="btnCOBDC" runat="server" Text="COBD Close" OnClick="COBD_Click" OnClientClick="return show_COBDprompt();" />

<asp:HiddenField ID="hdnCOBDValue" runat="server" />

<asp:HiddenField ID="hdnExpectedCOBD" runat="server" />

 

 

Javascript to Handle prompt and input value [limitation : only one input value] [for multiple value input use div]

 

<script type="text/javascript" language="javascript">

 

        function isLeapYear() {

            return (year % 4 != 0 ? false :

                ( year % 100 != 0? true:

                ( year % 1000 != 0? false : true)));

        }

 

        function isValidDate(date_string) {

            var days = [0,31,28,31,30,31,30,31,31,30,31,30,31];

            var year, month, day, date_parts = null;

            var rtrn = false;

            var format = 'mm/dd/yyyy';

            var decisionTree = {

                'm/d/y':{

                    're':/^(\d{1,2})[./-](\d{1,2})[./-](\d{2}|\d{4})$/,

                    'month': 1,'day': 2, year: 3

                },

                'mm/dd/yy':{

                    're':/^(\d{1,2})[./-](\d{1,2})[./-](\d{2})$/,

                    'month': 1,'day': 2, year: 3

                },

                'mm/dd/yyyy':{

                    're':/^(\d{1,2})[./-](\d{1,2})[./-](\d{4})$/,

                    'month': 1,'day': 2, year: 3

                },

                'y/m/d':{

                    're':/^(\d{2}|\d{4})[./-](\d{1,2})[./-](\d{1,2})$/,

                    'month': 2,'day': 3, year: 1

                },

                'yy/mm/dd':{

                    're':/^(\d{1,2})[./-](\d{1,2})[./-](\d{1,2})$/,

                    'month': 2,'day': 3, year: 1

                },

                'yyyy/mm/dd':{

                    're':/^(\d{4})[./-](\d{1,2})[./-](\d{1,2})$/,

                    'month': 2,'day': 3, year: 1

                }

            };

            var test = decisionTree[format];

            if (test) {

                date_parts = date_string.match(test.re);

                if (date_parts) {

                    year = date_parts[test.year] * 1;

                    month = date_parts[test.month] * 1;

                    day = date_parts[test.day] * 1;

 

                    test = (month == 2 &&

                            isLeapYear() &&

                            29 ||

                            days[month] || 0);

 

                    rtrn = 1 <= day && day <= test;

                }

            }

            return rtrn;

        }

 

        function show_COBDprompt() {

            var expectedCOBD = document.getElementById('hdnExpectedCOBD').value;

            var cobd = prompt("Please enter COB Date [mm/dd/yyyy] :", expectedCOBD);

            if (cobd != null && cobd != "") {

                if(!isValidDate(cobd)){ alert('Please enter the date in correct format i.e. mm/dd/yyyy'); return false; }

                document.getElementById('hdnCOBDValue').value = cobd;

                return true;

            }

            return false;

        }

    </script>

 

Microsoft Chart Tool 3.5 guide

To display a chart similar to the one below

 

 

Three easy steps to do the chart:

1. Create a DataTable with columns equal to number of bars needed for each week and a column for week itself. Populate table data.
2. Create a chart with series based on the datatable columns as below

for (int i = 1; i < chartData.Columns.Count; i++)

        {

            if (isFirstColumn)

            {

                Chart1.Series[0].XValueMember = chartData.Columns[0].ToString();

                Chart1.Series[0].YValueMembers = chartData.Columns[i].ToString();

                isFirstColumn = false;

            }

            else

            {

                Chart1.Series.Add(Convert.ToString(i));

                Chart1.Series[Convert.ToString(i)].XValueMember = chartData.Columns[0].ToString();

                Chart1.Series[Convert.ToString(i)].YValueMembers = chartData.Columns[i].ToString();

            }

        }

3. Your are done, just bind the chart with the datatable

 

 

Reference : http://www.skill-guru.com/blog/2009/11/29/advanced-features-of-net-chart-control/

 

LINQ -- how to pivot data usefull for charting

Extend Dictionary for var to have access to the extention function

 

using System;

using System.Collections.Generic;

using System.Linq;

 

namespace ReflectionIT.Training {

 

    public static class LinqExtenions {

 

        public static Dictionary<TFirstKey, Dictionary<TSecondKey, TValue>> Pivot<TSource, TFirstKey, TSecondKey, TValue>(this IEnumerable<TSource> source, Func<TSource, TFirstKey> firstKeySelector, Func<TSource, TSecondKey> secondKeySelector, Func<IEnumerable<TSource>, TValue> aggregate) {

            var retVal = new Dictionary<TFirstKey, Dictionary<TSecondKey, TValue>>();

 

            var l = source.ToLookup(firstKeySelector);

            foreach (var item in l) {

                var dict = new Dictionary<TSecondKey, TValue>();

                retVal.Add(item.Key, dict);

                var subdict = item.ToLookup(secondKeySelector);

                foreach (var subitem in subdict) {

                    dict.Add(subitem.Key, aggregate(subitem));

                }

            }

 

            return retVal;

        }

 

    }

}

 

Use any ‘var’ typed variable [L in this case] with your resultset

 

var result1 = L.Pivot(emp => emp.Department, emp2 => emp2.Function, lst => lst.Sum(emp => emp.Salary));

 

        foreach (var row in result1) {

            Console.WriteLine(row.Key);

            foreach (var column in row.Value) {

                Console.WriteLine("  " + column.Key + "\t" + column.Value);

 

            }

        }

 

        Console.WriteLine("----");

 

        var result2 = l.Pivot(emp => emp.Function, emp2 => emp2.Department, lst => lst.Count());

 

        foreach (var row in result2) {

            Console.WriteLine(row.Key);

            foreach (var column in row.Value) {

                Console.WriteLine("  " + column.Key + "\t" + column.Value);

 

            }

        }

 

Reference : http://www.extensionmethod.net/Details.aspx?ID=147#