public override async Task <ProcessingResult> SaveOrUpdate(ISession session, string username) { var extraCode = GetValue("ExtraCode"); if (string.IsNullOrWhiteSpace(extraCode)) { return(new ProcessingResult(false, "Extra code is mandatory")); } var dbUser = session.QueryOver <User>().Where(x => x.UserName == username).SingleOrDefault(); var userInfo = session.QueryOver <UserExtraInfo>().Where(x => x.User.Id == dbUser.Id).SingleOrDefault(); if (userInfo == null) { userInfo = new UserExtraInfo() { User = dbUser }; } userInfo.ExtraCode = extraCode; DataService.SaveOrUpdate(session, userInfo); return(new ProcessingResult(true)); }
public override void OpenPanel() { base.OpenPanel(); clearTextValue(); try { agConnectUser = AGConnectAuth.getInstance().getCurrentUser(); if (agConnectUser != null) { UserNikeName.text = agConnectUser.getDisplayName(); UserEmail.text = agConnectUser.getEmail(); UserPhoneNumber.text = agConnectUser.getPhone(); photoUrl.text = agConnectUser.getPhotoUrl(); UserId.text = agConnectUser.getUid(); UserProviderId.text = agConnectUser.getProviderId(); UserProviderInfo.text = transferProviderInfo(agConnectUser.getProviderInfo()); agConnectUser.getToken(false).addOnSuccessListener(new HuaweiOnsuccessListener <TokenResult>( (result) => { UnityMainThread.instance.AddJob(() => { UserToken.text = result.getToken() + " " + result.getExpirePeriod(); }); } )); agConnectUser.getUserExtra().addOnSuccessListener(new HuaweiOnsuccessListener <AGConnectUserExtra>( (UserExtraInfo) => { UnityMainThread.instance.AddJob(() => { UserExtra.text = UserExtraInfo.getCreateTime() + " " + UserExtraInfo.getLastSignInTime(); }); })); isAnonymous.text = agConnectUser.isAnonymous() ? "true" : "false" + " " + agConnectUser.getEmailVerified() + " " + agConnectUser.getPasswordSetted(); } } catch (System.Exception e) { Error error = new Error(); error.message = e.Message; Debug.Log("this error is " + error.message); PanelController.popupinstance.ShowError(error); } }
public static void SetUserExtraInfo(string userId, UserExtraInfo userInfo) { SqlConnection dbConn = new SqlConnection(connectionString); SqlCommand sqlComm = new SqlCommand( @"UPDATE site_User_Extra_Info SET UserFullName = @UserFullName, UserGender = @UserGender, UserBirthDate = @UserBirthDate, UserCountry = @UserCountry, UserCity = @UserCity, UserDescription = @UserDescription WHERE UserId = @UserId", dbConn); sqlComm.Parameters.AddWithValue("UserFullName", userInfo.RealName); sqlComm.Parameters.AddWithValue("UserGender", userInfo.Gender); sqlComm.Parameters.AddWithValue("UserBirthDate", userInfo.BirthDate); sqlComm.Parameters.AddWithValue("UserCountry", userInfo.Country); sqlComm.Parameters.AddWithValue("UserCity", userInfo.City); sqlComm.Parameters.AddWithValue("UserDescription", userInfo.Description); sqlComm.Parameters.AddWithValue("UserId", userId); dbConn.Open(); sqlComm.ExecuteNonQuery(); dbConn.Close(); }
public static UserExtraInfo GetUserExtraInfo(string userId) { SqlConnection dbConn = new SqlConnection(connectionString); SqlCommand sqlComm = new SqlCommand( @"SELECT UserFullName, UserGender, UserBirthDate, UserCountry, UserCity, UserDescription FROM site_User_Extra_Info WHERE (UserId = @user_id)", dbConn); sqlComm.Parameters.AddWithValue("user_id", userId); dbConn.Open(); UserExtraInfo retVal = null; using (SqlDataReader sqlDr = sqlComm.ExecuteReader(CommandBehavior.CloseConnection)) { sqlDr.Read(); try { retVal = new UserExtraInfo(sqlDr.GetString(0), sqlDr.GetBoolean(1), sqlDr.GetDateTime(2), sqlDr.GetString(3), sqlDr.GetString(4), sqlDr.GetString(5)); } catch (Exception ex) { retVal = null; } sqlDr.Close(); } return retVal; }