/// <summary>
        /// Creates the forms authentication ticket
        /// </summary>
        /// <param name="customerID">The customer ID</param>
        /// <returns>Whether or not the ticket was created successfully.</returns>
        public bool CreateFormsAuthenticationTicket(int customerID)
        {
            var command = new SqlHelper();
            var row = command.GetRow(@"
                    SELECT
                        c.CustomerID,
                        c.FirstName,
                        c.LastName,
                        c.Company,
                        c.MainCountry,
                        c.EnrollerID,
                        c.SponsorID,
                        c.LanguageID,
                        c.CustomerTypeID,
                        c.CustomerStatusID,
                        c.DefaultWarehouseID,
                        c.CurrencyCode,
                        c.CreatedDate
                    FROM
                        Customers c
                    WHERE
                        c.CustomerID = {0}
                ", customerID);

            FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1,
                customerID.ToString(),
                DateTime.Now,
                DateTime.Now.AddMinutes(GlobalSettings.Backoffice.SessionTimeoutInMinutes),
                false,
                string.Format("{0}|{1}|{2}|{3}|{4}|{5}|{6}|{7}|{8}|{9}|{10}|{11}|{12}|{13}",
                    customerID,
                    row["FirstName"].ToString(),
                    row["LastName"].ToString(),
                    row["Company"].ToString(),
                    row["MainCountry"].ToString(),

                    (!Convert.IsDBNull(row["EnrollerID"])) ? Convert.ToInt32(row["EnrollerID"]) : 0,
                    (!Convert.IsDBNull(row["SponsorID"])) ? Convert.ToInt32(row["SponsorID"]) : 0,

                    Convert.ToInt32(row["LanguageID"]),
                    Convert.ToInt32(row["CustomerTypeID"]),
                    Convert.ToInt32(row["CustomerStatusID"]),
                    Convert.ToInt32(row["DefaultWarehouseID"]),
                    "",
                    row["CurrencyCode"].ToString(),
                    Convert.ToDateTime(row["CreatedDate"]).ToShortDateString()));

            // encrypt the ticket
            string encTicket = FormsAuthentication.Encrypt(ticket);

            // create the cookie.
            HttpCookie cookie = HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName]; //saved user
            if (cookie == null)
            {
                HttpContext.Current.Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, encTicket));
            }
            else
            {
                cookie.Value = encTicket;
                HttpContext.Current.Response.Cookies.Set(cookie);
            }

            return true;
        }
        /// <summary>
        /// Creates the forms authentication ticket
        /// </summary>
        /// <param name="customerID">The customer ID</param>
        /// <returns>Whether or not the ticket was created successfully.</returns>
        public bool CreateFormsAuthenticationTicket(int customerID)
        {
            var command = new SqlHelper();
            var row     = command.GetRow(@"
                    SELECT 
                        c.CustomerID,
                        c.FirstName,
                        c.LastName,
                        c.Company,
                        c.MainCountry,
                        c.EnrollerID,
                        c.SponsorID,
                        c.LanguageID,
                        c.CustomerTypeID,
                        c.CustomerStatusID,
                        c.DefaultWarehouseID,
                        c.CurrencyCode,
                        c.CreatedDate
                    FROM 
                        Customers c
                    WHERE 
                        c.CustomerID = {0}
                ", customerID);


            FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1,
                                                                             customerID.ToString(),
                                                                             DateTime.Now,
                                                                             DateTime.Now.AddMinutes(GlobalSettings.Backoffice.SessionTimeoutInMinutes),
                                                                             false,
                                                                             string.Format("{0}|{1}|{2}|{3}|{4}|{5}|{6}|{7}|{8}|{9}|{10}|{11}|{12}|{13}",
                                                                                           customerID,
                                                                                           row["FirstName"].ToString(),
                                                                                           row["LastName"].ToString(),
                                                                                           row["Company"].ToString(),
                                                                                           row["MainCountry"].ToString(),

                                                                                           (!Convert.IsDBNull(row["EnrollerID"])) ? Convert.ToInt32(row["EnrollerID"]) : 0,
                                                                                           (!Convert.IsDBNull(row["SponsorID"])) ? Convert.ToInt32(row["SponsorID"]) : 0,

                                                                                           Convert.ToInt32(row["LanguageID"]),
                                                                                           Convert.ToInt32(row["CustomerTypeID"]),
                                                                                           Convert.ToInt32(row["CustomerStatusID"]),
                                                                                           Convert.ToInt32(row["DefaultWarehouseID"]),
                                                                                           "",
                                                                                           row["CurrencyCode"].ToString(),
                                                                                           Convert.ToDateTime(row["CreatedDate"]).ToShortDateString()));

            // encrypt the ticket
            string encTicket = FormsAuthentication.Encrypt(ticket);

            // create the cookie.
            HttpCookie cookie = HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName]; //saved user

            if (cookie == null)
            {
                HttpContext.Current.Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, encTicket));
            }
            else
            {
                cookie.Value = encTicket;
                HttpContext.Current.Response.Cookies.Set(cookie);
            }

            return(true);
        }