private static FacebookAccountInfo ToFacebookAccountInfo(object[] row)
{
FacebookAccountInfo accountInfo = new FacebookAccountInfo
{
AccessToken = Convert.ToString(row[0]),
UserID = Convert.ToString(row[1]),
AssociatedID = ToGuid(row[2]),
UserName = Convert.ToString(row[3])
};
return(accountInfo);
}
private static FacebookAccountInfo ToFacebookAccountInfo(object[] row)
{
FacebookAccountInfo accountInfo = new FacebookAccountInfo
{
AccessToken = Convert.ToString(row[0]),
UserID = Convert.ToString(row[1]),
AssociatedID = ToGuid(row[2]),
UserName = Convert.ToString(row[3])
};
return accountInfo;
}
public void CreateNewAccountInfo(FacebookAccountInfo accountInfo)
{
using (var tx = DbManager.BeginTransaction())
{
DeleteAccountInfo(accountInfo.AssociatedID);
SqlInsert cmdInsert = Insert("sm_facebookaccounts")
.ReplaceExists(true)
.InColumnValue("access_token", accountInfo.AccessToken)
.InColumnValue("user_id", accountInfo.UserID)
.InColumnValue("associated_id", accountInfo.AssociatedID)
.InColumnValue("user_name", accountInfo.UserName);
DbManager.ExecuteNonQuery(cmdInsert);
tx.Commit();
}
}
public void CreateNewAccountInfo(FacebookAccountInfo accountInfo)
{
using (var tx = DbManager.BeginTransaction())
{
DeleteAccountInfo(accountInfo.AssociatedID);
SqlInsert cmdInsert = Insert("sm_facebookaccounts")
.ReplaceExists(true)
.InColumnValue("access_token", accountInfo.AccessToken)
.InColumnValue("user_id", accountInfo.UserID)
.InColumnValue("associated_id", accountInfo.AssociatedID)
.InColumnValue("user_name", accountInfo.UserName);
DbManager.ExecuteNonQuery(cmdInsert);
tx.Commit();
}
}
