JavaScript

• QA1: Save The form data in text[^]
• QA2: Save the form data in text file[^]
• This forum: http://www.codeproject.com/Messages/4764925/Store-form-page-in-csv-format.aspx[^]

function foo() {
   // do foo
  var counter = 0;
  bar(counter);
}
function bar(var myParam) {
  // do something with myParam
  var somethingElse = myParam;
}

function a() { 
   var b=0; 
   a(b); 
}
function a(var b) { 
   var c=b;
}

(function () {
    var b = window,
        f = "chrome",
        g = "jstiming",
        k = "tick";
    (function () {
        function d(a) {
            this.t = {};
            this.tick = function (a, d, c) {
                var e = void 0 != c ? c : (new Date).getTime();
                this.t[a] = [e, d];
                if (void 0 == c) try {
                    b.console.timeStamp("CSI/" + a)
                } catch (h) {}
            };
            this[k]("start", null, a)
        }
        var a;
        b.performance && (a = b.performance.timing);
        var n = a ? new d(a.responseStart) : new d;
        b.jstiming = {
            Timer: d,
            load: n
        };
        if (a) {
            var c = a.navigationStart,
                h = a.responseStart;
            0 < c && h >= c && (b[g].srt = h - c)
        }
        if (a) {
            var e = b[g].load;
            0 < c && h >= c && (e[k]("_wtsrt", void 0, c), e[k]("wtsrt_", "_wtsrt", h), e[k]("tbsd_", "wtsrt_"))
        }
        try {
            a = null,
            b[f] && b[f].csi && (a = Math.floor(b[f].csi().pageT), e && 0 < c && (e[k]("_tbnd", void 0, b[f].csi().startE), e[k]("tbnd_", "_tbnd", c))), null == a && b.gtbExternal && (a = b.gtbExternal.pageT()), null == a && b.external && (a = b.external.pageT, e && 0 < c && (e[k]("_tbnd", void 0, b.external.startE), e[k]("tbnd_", "_tbnd", c))), a && (b[g].pt = a)
        } catch (p) {}
    })();
    b.tickAboveFold = function (d) {
        var a = 0;
        if (d.offsetParent) {
            do a += d.offsetTop; while (d = d.offsetParent)
        }
        d = a;
        750 >= d && b[g].load[k]("aft")
    };
    var l = !1;

    function m() {
        l || (l = !0, b[g].load[k]("firstScrollTime"))
    }
    b.addEventListener ? b.addEventListener("scroll", m, !1) : b.attachEvent("onscroll", m);
})();

google.load('visualization', '1.0', {'packages':['corechart','controls']});
google.setOnLoadCallback(function(){
    drawVisualization(...);
});

<pre lang="c#"> protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
         
            
           JavaScriptSerializer jss = new JavaScriptSerializer();

           ClientScript.RegisterStartupScript(this.GetType(), "TestInitPageScript",
               string.Format("<script type=\"text/javascript\">drawVisualization({0},'{1}','{2}');</script>",
               jss.Serialize(GetData()),
                "Text Example",
                "Name,type,"));

        }
    }

    [WebMethod]
    public static List<Data> GetData()
    {
        SqlConnection conn = new SqlConnection("Data Source=84.18.208.130;Initial Catalog=cdw;Persist Security Info=True;User ID=cdwadmin;Password=remote8313");                                                                                                  
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        conn.Open();
        string cmdstr = "select top 100 Name, [Decimal price],Cover from [dbo].[database_BWICs]";
        SqlCommand cmd = new SqlCommand(cmdstr, conn);
        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        adp.Fill(ds);
        dt = ds.Tables[0];
        List<Data> dataList = new List<Data>();
        string cat="";
        float val=0;
        string typ = "";
        
        foreach (DataRow dr in dt.Rows)
        {
            try
            {
                cat = dr[0].ToString();

                val = Convert.ToInt32(dr[1]);

                typ = dr[2].ToString();

            }
            catch
            {
            }
            dataList.Add(new Data(cat, val, typ));
        }
        return dataList;
    }

ClientScript.RegisterStartupScript(this.GetType(), "TestInitPageScript",
    string.Format("<script type=\"text/javascript\">google.load('visualization','1.0',{'packages':['corechart','controls']});google.setOnLoadCallback(function(){drawVisualization({0},'{1}','{2}');});</script>",
    jss.Serialize(GetData()),
    "Text Example",
    "Name,type,"));

public class test
{
    public string ColumnName = "";
    public float Value = 0;
    public string Type = "";
    public DateTime Date = DateTime.Now;

    public test(string columnName, float value, string type, DateTime date)
    {
        ColumnName = columnName;
        Value = value;
        Type = type;
        Date = date;
    }

    var yesterday = DateTime.Today.AddDays(-1);
    string cmdstr = "select top 500 Name, [Decimal price],Cover, UploadDate from [dbo].[database]";
    SqlCommand cmd = new SqlCommand(cmdstr, conn);
    SqlDataAdapter adp = new SqlDataAdapter(cmd);
    adp.Fill(ds);
    dt = ds.Tables[0];
    List<test> dataList = new List<test>();
    string cat = "";
    float val = 0;
    string typ = "";
    DateTime dat = DateTime.Now;

    //dat.ToString("ddmmYYYY", System.Globalization.CultureInfo.InvariantCulture);

    foreach (DataRow dr in dt.Rows)
    {
        try
        {
            cat = dr[0].ToString();

            val = Convert.ToInt32(dr[1]);

            typ = dr[2].ToString();

            dat = (DateTime)dr[3];

        }
        catch
        {
        }
        dataList.Add(new test(cat, val, typ, dat));
    }
    return dataList;
}

function drawVisualization(dataValues, chartTitle, columnNames, categoryCaption) {
        if (dataValues.length < 1)
            return;

        var data = new google.visualization.DataTable();
        data.addColumn('string', columnNames.split(',')[0]);
        data.addColumn('number', columnNames.split(',')[1]);
        data.addColumn('string', columnNames.split(',')[2]);
        data.addColumn('datetime', columnNames.split(',')[3]);

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

            //var dateTimeString = "\/Date(1358294400000)\/";
            //var dateTime = new Date(parseInt(dateTimeString.split("/"[\(\)]/)[3]));

            var date = new Date(parseInt(dataValues[i].Date.substr(6), 10));

           // var dateString = dataValues[i].Date.substr(6);
            //var currentTime = new Date(parseInt(dateString));
          //  var date = new Date(parseInt(dateString));
            //var month = currentTime.getMonth() + 1;
           // var day = currentTime.getDate();
           // var year = currentTime.getFullYear();
           // var date = day + "/" + month + "/" + year;

           
            //var date = new Date(parseInt(jsonDate.substr(6)));
            //var date = new Date(new Number(jsonDate.replace(/(^.*\()|([+-].*$)/g, '')));
            //var date = eval(jsonDate.replace(/\/Date\((\d+)\)\//gi, "new Date($1)"));
            alert(date);

            data.addRow([dataValues[i].ColumnName, dataValues[i].Value, dataValues[i].Type, date]);
            
        }

        // Define a Pie chart
        var pie = new google.visualization.ChartWrapper({
            'chartType': 'LineChart',
            'containerId': 'PieChartContainer',
            'options': {
                'width': 950,
                'height': 450,
                'legend': 'right',
                'hAxis': {
                 'format': "dd-MMM-yyyy",
                 'maxValue': date (2013, 01, 16), 'minValue': date (2013, 01, 17), 'viewWindow':{'max': date (2013, 01, 17)}},
                'title': chartTitle,
                'chartArea': { 'left': 100, 'top': 100, 'right': 0, 'bottom': 100 },
                'pieSliceText': 'label',
                'tooltip': { 'text': 'percentage' }
            },
            'view': { 'columns': [3, 1] }
        });