public static ConfirmationResult ProcessConfirmation(string guid, int relationType)
        {
            ConfirmationResult result = ConfirmationResult.ConfirmationFailed;

            string emailRequested = string.Empty;
            string emailRequesting = string.Empty;
            ClientInfo requestingClientInfo = null;
            ClientInfo requestedClientInfo = null;

            using (Database db = new MySqlDatabase())
            {
                result = db.ProcessConfirmation(guid, relationType, out emailRequested, out emailRequesting);

                long requestedUserId = db.GetUserIdByEmail(emailRequested);
                long requestingUserId = db.GetUserIdByEmail(emailRequesting);

                requestingClientInfo = db.GetClientInfo(requestingUserId);
                requestedClientInfo = db.GetClientInfo(requestedUserId);
            }

            if (result == ConfirmationResult.Success)
            {
                string _template = string.Empty;

                if (relationType == 1)
                    _template = Resources.Resource.ConfirmRequestorTemplate;
                else
                    _template = Resources.Resource.TemplateConfirmrelationcreate;

                using (TextReader rdr = new StreamReader(HttpContext.Current.Server.MapPath(_template)))
                {
                    string body = rdr.ReadToEnd();

                    body = body.Replace("{%EmailHeaderLogo%}", ConfigurationManager.AppSettings["EmailHeaderLogo"]);
                    body = body.Replace("{%EmailmailToLink%}", ConfigurationManager.AppSettings["EmailmailToLink"]);
                    body = body.Replace("{%SiteNavigationLink%}", ConfigurationManager.AppSettings["SiteNavigationLink"]);
                    body = body.Replace("{%EmailFooterLogo%}", ConfigurationManager.AppSettings["EmailFooterLogo"]);
                    body = body.Replace("{%EmailFBlink%}", ConfigurationManager.AppSettings["EmailFBlink"]);
                    body = body.Replace("{%EmailFBLogo%}", ConfigurationManager.AppSettings["EmailFBLogo"]);
                    body = body.Replace("{%EmailTwitterLink%}", ConfigurationManager.AppSettings["EmailTwitterLink"]);
                    body = body.Replace("{%EmailTwitterLogo%}", ConfigurationManager.AppSettings["EmailTwitterLogo"]);
                    body = body.Replace("{%EmailSoundCloudLink%}", ConfigurationManager.AppSettings["EmailSoundCloudLink"]);
                    body = body.Replace("{%EmailSoundCloudLogo%}", ConfigurationManager.AppSettings["EmailSoundCloudLogo"]);

                    body = body.Replace("{%receivingRelation%}", requestingClientInfo.GetFullName());
                    body = body.Replace("{%firstname%}", requestedClientInfo.FirstName);
                    body = body.Replace("{%lastname%}", requestedClientInfo.LastName);
                    body = body.Replace("{%firstname_invitee%}", requestedClientInfo.FirstName);
                    body = body.Replace("{%firstname_invitor%}", requestingClientInfo.FirstName);
                    body = body.Replace("{%lastname_invitor%}", requestingClientInfo.LastName);
                    body = body.Replace("{%FAQ%}", ConfigurationManager.AppSettings["SiteNavigationLink"] + "/FAQ.aspx");

                    try
                    {
                        Util.SendEmail(new string[] { emailRequesting }, "*****@*****.**",
                                       Resources.Resource.ConfirmationManagedMusician, body, null, 0);
                    }
                    catch (Exception ex)
                    {
                        Logger.Instance.Write(LogLevel.Error, ex, "[ProcessConfirmation]");
                    }
                }
            }
            return result;
        }