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)); }