public async Task SendMessage(string user, string message, DateTime time)
{
using (var connection = new SqliteConnection(@"C:\Users\StephonB\Desktop\DotNet Practice\ChatMessages.db")){
connection.Open();
var command = connection.CreateCommand();
command.CommandText =
@"
Insert INTO MESSAGE(UserName, Message, TimeSent)
Values Message($user, $message, $time)
";
command.Parameters.AddWithValue("$user", user);
command.Parameters.AddWithValue("$message", message);
command.Parameters.AddWithValue("$time", time);
command.ExecuteNonQuery();
}
var model = new WebChatModel()
{
UserName = user,
Message = message,
Time = time
};
await _hubContext.Clients.All.SendAsync("TakeMessage", model);
}
private List <WebChatModel> GetMessages()
{
var model = new List <WebChatModel>();
using (var connection = new SqliteConnection(@"Data Source=C:\Users\StephonB\Desktop\DotNet Practice\ChatMessages.db")){
connection.Open();
var command = connection.CreateCommand();
command.CommandText =
@"
SELECT UserName, Message, TimeSent
FROM MESSAGE
";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var message = new WebChatModel();
message.UserName = reader.GetString(0);
message.Message = reader.GetString(1);
message.Time = reader.GetDateTime(0);
model.Add(message);
}
}
return(model);
}
}
public async Task <ActionResult> iFramed()
{
var vm = new WebChatModel();
await vm.SetToken();
return(View(vm));
}
private Response BeforeChatApiRequest(NancyContext ctx)
{
try
{
requestChatModel = JsonConvert.DeserializeObject <WebChatModel>(RequestJson);
AirFrog.LoggerMan.Log(JsonConvert.SerializeObject(requestChatModel));
}
catch (Exception e)
{
AirFrog.LoggerMan.LogErr(e.ToString());
return(Response.AsJson(badRequestResponse, Nancy.HttpStatusCode.BadRequest));
}
return(null);
}
public ActionResult Index()
{
var connectionString = ConfigurationManager.ConnectionStrings["StorageConnectionString"].ConnectionString;
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(connectionString);
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
CloudTable table = tableClient.GetTableReference("BotStore");
string userId = Guid.NewGuid().ToString();
TableQuery <BotDataRow> query = new TableQuery <BotDataRow>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, userId));
var dataRow = table.ExecuteQuery(query).FirstOrDefault();
if (dataRow != null)
{
dataRow.Data = Newtonsoft.Json.JsonConvert.SerializeObject(new
{
UserName = "******",
Email = "*****@*****.**",
GraphAccessToken = "token",
TokenExpiryTime = DateTime.Now.AddHours(1)
});
dataRow.Timestamp = DateTimeOffset.UtcNow;
table.Execute(TableOperation.Replace(dataRow));
}
else
{
var row = new BotDataRow(userId, "userData");
row.Data = Newtonsoft.Json.JsonConvert.SerializeObject(new
{
UserName = "******",
Email = "*****@*****.**",
GraphAccessToken = "token",
TokenExpiryTime = DateTime.Now.AddHours(1)
});
row.Timestamp = DateTimeOffset.UtcNow;
table.Execute(TableOperation.Insert(row));
}
var vm = new WebChatModel();
vm.UserId = userId;
return(View(vm));
}
// GET: Bot/WebChat
public ActionResult Index()
{
var vm = new WebChatModel();
return(View(vm));
}
