private void SetCookie(HttpResponseBase response, User user)
 {
     FormsAuthentication.SetAuthCookie(user.Email, true);
     var userData = _serializer.Serialize(user);
     var ticket = new FormsAuthenticationTicket(1, user.Email, DateTime.Now, DateTime.Now.AddDays(30), true, userData, FormsAuthentication.FormsCookiePath);
     var encryptedTicket = FormsAuthentication.Encrypt(ticket);
     response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket)
         {
             Expires = DateTime.Now.AddYears(10)
         });
 }
 public void UpdateUser(User user)
 {
     using (var connection = new SqlConnection(_connectionString))
     {
         const string updateSql = @"UPDATE [User] SET Forename = @Forename, Surname = @Surname WHERE UserId = @UserId";
         connection.Execute(updateSql, user);
     }
 }