public async Task <IActionResult> GetMessageDetail([FromRoute] string id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
int cUserId = Convert.ToInt32(id.Split(';')[0]);
int rUserId = Convert.ToInt32(id.Split(';')[1]);
SlackChatContext slackChatContext = new SlackChatContext();
string connectionString = @"Server=(localdb)\ProjectsV13;Database=SlackChatDB;Trusted_Connection=True;";
string query = "UPDATE MessageDetails SET MsgStatus=1 WHERE " +
"UserId=" + rUserId + " AND RUserId=" + cUserId + "";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = connection.CreateCommand();
command.CommandText = query;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
return(Ok(new { Message = "Record updated Successfully!!!" }));
}
