| | |
| | | using (IDbConnection connection = new MySqlConnection(connectionString)) |
| | | { |
| | | string sqlUpdateQuestion = $"UPDATE agentdata SET questionno = COALESCE(questionno, 0) + 1 WHERE id = {AgentId}"; |
| | | string sqlCount = $"SELECT COUNT(*) FROM chathistorydata WHERE userid = {UserId}"; |
| | | string sqlCount = $"SELECT COUNT(*) FROM chathistorydata WHERE userid = {UserId} and agentid={AgentId}"; |
| | | string sqlUpdateUser = $"UPDATE agentdata SET userno = COALESCE(userno, 0) + 1 WHERE id = {AgentId}"; |
| | | int count = 0; |
| | | connection.Open(); |