Ejemplo n.º 1
0
        public int CreateCustomerLoginOAuth(IDbConnection db, CustomerLoginOAuth customerLoginOauth)
        {
            string sql = @"INSERT INTO customer_login_oauth
                (service, identity, customer_username)
                VALUES
                (@service, @identity, @customer_username)
                 RETURNING id";

            return db.Query<int>(sql, customerLoginOauth).FirstOrDefault();
        }
Ejemplo n.º 2
0
        public object LoginOAuth([FromBody] OauthModel param)
        {
            //prepare data
            var api = Api.Instance;
            string partnerUID = param.partner_id;
            Partner partner = api.GetPartnerById(partnerUID).Data;
            string service = !string.IsNullOrEmpty(param.service) ? param.service.ToLower() : string.Empty;
            //This token is returned from login facebook
            string token = param.token;
            string oauthAccountID = string.Empty;
            FacebookProfile fbProfile = api.IDRetriever(service, token);
            oauthAccountID = fbProfile == null
                ? token
                : fbProfile.id;
            string ip_address = !string.IsNullOrEmpty(param.ip_address)
                ? param.ip_address
                : IpHelper.GetClientIp(Request);

            ErrorCodes? message = null;
            CustomerAccount user = null;
            CustomerLoginOAuth userOAuth = null;

            if (partner == null)
                message = ErrorCodes.INVALID_PARTNER_ID;
            else if (string.IsNullOrEmpty(service) && string.IsNullOrEmpty(token))
                message = ErrorCodes.MISSING_FIELDS;
            else
            {
                userOAuth = api.GetCustomerLoginOAuthByIdentity(service, oauthAccountID).Data;
                if (userOAuth == null)
                {
                    if (fbProfile != null && !string.IsNullOrEmpty(fbProfile.email))
                    {
                        var customerAccount = api.GetUserByEmail(fbProfile.email).Data;
                        if (customerAccount != null)
                        {
                            int newId = api.CreateLoginOAuth(new CustomerLoginOAuth
                            {
                                customer_username = customerAccount.username,
                                service = service,
                                identity = fbProfile.id
                            });
                            userOAuth = new CustomerLoginOAuth()
                            {
                                customer_username = customerAccount.username
                            };
                        }
                        else
                        {
                            message = ErrorCodes.NON_EXISTING_OAUTH;
                        }
                    }
                    else
                    {
                        message = ErrorCodes.NON_EXISTING_OAUTH;
                    }
                }
                else
                {
                    user = api.GetUserByUserName(userOAuth.customer_username).Data;
                    if (user != null && (string.IsNullOrEmpty(user.country_code)))
                    {
                        IPAddress ip = IPAddress.Parse(ip_address);
                        ip.GetCountryCode(c => user.country_code = c, n => user.country_name = n);
                        api.UpdateCustomerAccount(user.id, user.country_code, user.country_name, DateTime.UtcNow);
                    }
                }
            }

            //Return result
            api.LogApi("1", "/account/login-oauth", message == null,
                Request.Headers.UserAgent != null ? Request.Headers.UserAgent.ToString() : string.Empty,
                param.partner_id, user == null ? string.Empty : user.username,
                IpHelper.GetClientIp(Request), message.ToErrorCode(), JsonConvert.SerializeObject(param));

            if (message == null)
            {
                user = api.GetUserByUserName(userOAuth.customer_username).Data;
                api.UpdateCustomerAccount(user.id, user.country_code, user.country_name, DateTime.UtcNow);

                ErrorCodes? errorInReferralCampaign = api.HandleDataReferralCampaign(user.id, user.username, param.game_id, param.device_id, user.inviter_username, ip_address, partner.identifier);
                if (errorInReferralCampaign != null)
                    api.LogApi("1", "/account/login-oauth", true,
                        Request.Headers.UserAgent != null ? Request.Headers.UserAgent.ToString() : string.Empty,
                        param.partner_id, user == null ? string.Empty : user.username,
                        IpHelper.GetClientIp(Request), errorInReferralCampaign.ToErrorCode(), errorInReferralCampaign.ToErrorMessage());
            }

            return new
            {
                success = message == null,
                message = message.ToErrorMessage(),
                error_code = message.ToErrorCode(),
                session = message == null ? api.GetAccessToken(user.id, user.username, partner) : string.Empty,
                profile = message == null ? Profile.GetFrom(user) : null
            };
        }