//STORE MESSAGE in table with name of chatName
public async Task <string> DBStoreMessage(string text, string nickname, string chatName)
{
CloudTable cloudTable = tableClient.GetTableReference(chatName);
//await CreateNewTableAsync(cloudTable);
MessageTable messageTable = new MessageTable();
messageTable.Time = DateTime.UtcNow.ToLongTimeString();
messageTable.AuthorNickName = nickname;
messageTable.Body = text;
messageTable.AssignPartitionKey();
messageTable.AssignRowKey();
TableOperation tableOperation = TableOperation.Insert(messageTable);
await cloudTable.ExecuteAsync(tableOperation);
return("Record inserted");
}
public static async Task InsertRecordToTableAsync(CloudTable table, string time, string nickname, string value)
{
MessageTable message = new MessageTable();
message.Time = time;
message.AuthorNickName = nickname;
message.Body = value;
Message mess = await RetrieveRecordAsync(table, time, nickname);
if (mess == null)
{
TableOperation tableOperation = TableOperation.Insert(message);
await table.ExecuteAsync(tableOperation);
//Console.WriteLine("Record inserted");
}
else
{
//Console.WriteLine("Record exists");
}
}
//TESTTING
public Message GetLastMessageTest(string chatName, int count)
{
Message message = new Message();
try
{
var table = tableClient.GetTableReference(chatName);
TableContinuationToken token = null;
var queryResult = table.ExecuteQuerySegmentedAsync(new TableQuery <MessageTable>(), token);
var entities = new List <MessageTable>();
entities.AddRange(queryResult.Result);
MessageTable messageTable = entities[count];
message.body = messageTable.Body;
message.time = messageTable.Time;
message.authorNickName = messageTable.AuthorNickName;
}
catch
{
}
return(message);
}
