Wednesday, September 17, 2014

Azure SQL Database Backup and Restore

First connect database server and select database which you want to backup database and right click on the database, then go to tasks =>  Export Data-tier Application as bellow one

Figure 01

When click on Export Data-tier Application "Instruction" popup window will expose, then click next button

Figure 02




 Then sql server expose "Export setting" window, there give location for save database backup using browse button. then click next button.

Figure 03







 then click finish button when summary window will populate. as bellow showing

Figure 04




Monday, September 15, 2014

Detect browser type and device type which client used

                   var userAgent = window.navigator.userAgent;
                    var browserVersion;
                    var DeviceType;

                  //Detect type of browser

                    if (userAgent.indexOf("MSIE") != -1) {

                        var browserVersionArray = userAgent.split(';');
                        browserVersion = browserVersionArray[1];
                    }
                    else if (userAgent.indexOf("Firefox") != -1) {

                        browserVersion = userAgent.split(" ").pop();
                    }
                    else if (userAgent.indexOf("Chrome") != -1) {
                        var browserVersionArray = userAgent.split(" ");
                        browserVersion = browserVersionArray[9];

                    }
                    else if (userAgent.indexOf("Safari") != -1) {
                        var browserVersionArray = userAgent.split(" ");
                        var browserSafariArray = browserVersionArray[9];
                        browserVersion = browserSafariArray.split('/')
                    }

                    var isMobile = {
                        Android: function () {

                            if (userAgent.indexOf("MSIE") != -1) {

                                browserVersion = "MSIE";
                            }
                            else if (userAgent.indexOf("Firefox") != -1) {

                                browserVersion = "Firefox";
                            }
                            else if (userAgent.indexOf("Chrome") != -1) {
                                browserVersion = "Chrome";

                            }
                            else if (userAgent.indexOf("Safari") != -1) {
                                browserVersion = "Safari";
                            }

                            return navigator.userAgent.match(/Mobile/i);
                        },
                        BlackBerry: function () {
                            if (userAgent.indexOf("MSIE") != -1) {

                                browserVersion = "MSIE";
                            }
                            else if (userAgent.indexOf("Firefox") != -1) {

                                browserVersion = "Firefox";
                            }
                            else if (userAgent.indexOf("Chrome") != -1) {
                                browserVersion = "Chrome";

                            }
                            else if (userAgent.indexOf("Safari") != -1) {
                                browserVersion = "Safari";
                            }
                            return navigator.userAgent.match(/BlackBerry/i);
                        },
                        iOS: function () {

                            if (userAgent.indexOf("MSIE") != -1) {

                                browserVersion = "MSIE";
                            }
                            else if (userAgent.indexOf("Firefox") != -1) {

                                browserVersion = "Firefox";
                            }
                            else if (userAgent.indexOf("Chrome") != -1) {
                                browserVersion = "Chrome";

                            }
                            else if (userAgent.indexOf("Safari") != -1) {
                                browserVersion = "Safari";
                            }
                            return (navigator.platform.indexOf("iPhone") != -1);
                        },
                        Opera: function () {
                            if (userAgent.indexOf("MSIE") != -1) {

                                browserVersion = "MSIE";
                            }
                            else if (userAgent.indexOf("Firefox") != -1) {

                                browserVersion = "Firefox";
                            }
                            else if (userAgent.indexOf("Chrome") != -1) {
                                browserVersion = "Chrome";

                            }
                            else if (userAgent.indexOf("Safari") != -1) {
                                browserVersion = "Safari";
                            }
                            return navigator.userAgent.match(/Opera Mini/i);
                        },
                        Windows: function () {
                            if (userAgent.indexOf("MSIE") != -1) {

                                browserVersion = "MSIE";
                            }
                            else if (userAgent.indexOf("Firefox") != -1) {

                                browserVersion = "Firefox";
                            }
                            else if (userAgent.indexOf("Chrome") != -1) {
                                browserVersion = "Chrome";

                            }
                            else if (userAgent.indexOf("Safari") != -1) {
                                browserVersion = "Safari";
                            }
                            return navigator.userAgent.match(/IEMobile/i);
                        },
                        anyMobile: function () {
                            return (isMobile.Android() || isMobile.BlackBerry() || isMobile.iOS() || isMobile.Opera() || isMobile.Windows());
                        }
                    };

                    var isTablet = {
                        Android: function () {

                            if (userAgent.indexOf("MSIE") != -1) {

                                browserVersion = "MSIE";
                            }
                            else if (userAgent.indexOf("Firefox") != -1) {

                                browserVersion = "Firefox";
                            }
                            else if (userAgent.indexOf("Chrome") != -1) {
                                browserVersion = "Chrome";

                            }
                            else if (userAgent.indexOf("Safari") != -1) {
                                browserVersion = "Safari";
                            }
                            return navigator.userAgent.match(/Android/i);

                        },

                        iOS: function () {
                            if (userAgent.indexOf("MSIE") != -1) {

                                browserVersion = "MSIE";
                            }
                            else if (userAgent.indexOf("Firefox") != -1) {

                                browserVersion = "Firefox";
                            }
                            else if (userAgent.indexOf("Chrome") != -1) {
                                browserVersion = "Chrome";

                            }
                            else if (userAgent.indexOf("Safari") != -1) {
                                browserVersion = "Safari";
                            }

                            return navigator.userAgent.match(/iPad/i) != null;
                            //navigator.userAgent.match(/iPad/i);
                        },

                        anyTablet: function () {
                            return (isTablet.Android() || isTablet.iOS());
                        }
                    };

                    if (isTablet.anyTablet()) {

                        deviceType = 'Tablet';
                    }
                    else
                        if (isMobile.anyMobile()) {

                            deviceType = 'Mobile';
                    }
                    else {

                            deviceType = 'Desktop';
                    }

Cookies implement on client side

Cookie is a small text file sent by web server and saved by web browser on client machine.

There two type of cookies
Persistent cookies:  cookies are stored on your computer hard disk.  They stay on your hard disk and can be accessed by web servers until they are deleted or have expired.

Non-persistent cookies: cookies are saved only while your web browser is running.  They can be used by a web server only until you close your browser.  They are not saved on your disk.

Implement non-persistent cookie using java script

//Check session cookie
function bswayedcheckSessionCookie() {

    var date = new Date();
    var todayDate = date.getTime();

    var cookieName = GetSessionCookie();

    if (cookieName == "") {
        var cookieName = "bSwayedSession" + todayDate;
        cookieName = SetSessionCookie(cookieName);
    }
    return cookieName;
}


//Read session cookies
function GetSessionCookie() {

    var name = "bSwayedSession";

    var cookieArray = document.cookie.split(/[\;=\s]/);

    for (var i = 0; i < cookieArray.length; i++) {
        var cookieName = $jq191.trim(cookieArray[i]);  

        if (cookieName.indexOf(name) == 0) {
            return cookieName;
        }
    }
    return "";
}

//Set cookie
function SetSessionCookie(sessionCookieName) {
    document.cookie = "BswayedSession" + "=" + sessionCookieName;
    return document.cookie;
}