private static TwitterAccountInfo ToTwitterAccountInfo(object[] row) { TwitterAccountInfo accountInfo = new TwitterAccountInfo { AccessToken = Convert.ToString(row[0]), AccessTokenSecret = Convert.ToString(row[1]), ScreenName = Convert.ToString(row[2]), UserID = Convert.ToDecimal(row[3]), AssociatedID = ToGuid(row[4]), UserName = (row[5] != null && row[5] != DBNull.Value) ? Convert.ToString(row[5]) : null }; return(accountInfo); }
private static TwitterAccountInfo ToTwitterAccountInfo(object[] row) { TwitterAccountInfo accountInfo = new TwitterAccountInfo { AccessToken = Convert.ToString(row[0]), AccessTokenSecret = Convert.ToString(row[1]), ScreenName = Convert.ToString(row[2]), UserID = Convert.ToDecimal(row[3]), AssociatedID = ToGuid(row[4]), UserName = (row[5] != null && row[5] != DBNull.Value) ? Convert.ToString(row[5]) : null }; return accountInfo; }
public void CreateNewAccountInfo(TwitterAccountInfo accountInfo) { using (var tx = DbManager.BeginTransaction()) { DeleteAccountInfo(accountInfo.AssociatedID); SqlInsert cmdInsert = Insert("sm_twitteraccounts") .ReplaceExists(true) .InColumnValue("access_token", accountInfo.AccessToken) .InColumnValue("access_token_secret", accountInfo.AccessTokenSecret) .InColumnValue("screen_name", accountInfo.ScreenName) .InColumnValue("user_id", accountInfo.UserID) .InColumnValue("associated_id", accountInfo.AssociatedID) .InColumnValue("user_name", accountInfo.UserName); DbManager.ExecuteNonQuery(cmdInsert); tx.Commit(); } }