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;
}
