//************************************************
public void SaveTweet(Tweet t)
{
if (t == null)
return;
try
{
// Variables for the cloud storage objects.
var StorageAccount = CloudStorageAccount.Parse(_config.StorageAccount);
// Create the blob client, which provides
// authenticated access to the Blob service.
var blobClient = StorageAccount.CreateCloudBlobClient();
// Get the container reference.
var blobContainer = blobClient.GetContainerReference(_config.ContainerName);
// Create the container if it does not exist.
blobContainer.CreateIfNotExist();
string BlobName = string.Format("{0}/{1}.txt", t.CreatedAt.ToString("yyyy-MM-dd"), t.UserName + "_" + t.CreatedAt.ToString("yyyyMMddHHmmss"));
var blob = blobContainer.GetBlockBlobReference(BlobName);
//char[] CharArray = t.RawJson.ToCharArray();
byte[] ByteArray = System.Text.Encoding.UTF8.GetBytes(t.RawJson);
MemoryStream memStream = new MemoryStream(0);
// Write the JSON String to the stream.
memStream.Write(ByteArray, 0, ByteArray.Length);
// Set the position to the beginning of the stream
memStream.Seek(0, SeekOrigin.Begin);
//blobClient.ParallelOperationThreadCount = 1;
blob.BeginUploadFromStream(memStream, ProcessComplete, memStream);
//blob.UploadFromStream(memStream);
// blob.PutBlock(BlobName, memStream);
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveTweet(Tweet t)
{
if (t == null)
return;
try
{
ExecuteNonQuery(
"sp_InsertTweetInfo",
new SqlParameter
{
ParameterName = "@TweetID",
Direction = ParameterDirection.Input,
DbType = DbType.Int64,
Value = t.ID
},
new SqlParameter
{
ParameterName = "@Sentiment",
Direction = ParameterDirection.Input,
DbType = DbType.Int32,
Size = 20,
Value = t.SentimentScore
},
new SqlParameter
{
ParameterName = "@Topic",
Direction = ParameterDirection.Input,
DbType = DbType.String,
Size = 100,
Value = t.Topic
},
new SqlParameter
{
ParameterName = "@CreatedAt",
Direction = ParameterDirection.Input,
DbType = DbType.DateTime,
Value = t.CreatedAt
});
}
catch (Exception ex)
{ throw ex; }
}