public void LogUserQuery(int UserId, string Query, int QuestionId, UsersActionsTypes QueryType)
{
_conn.Open();
SqlCommand command = new SqlCommand("insert into USERS_ACTIONS (US_ID, USA_DESCRIPTION, EXQ_ID, USAT_ID, USA_CREATED_DATE) VALUES (@UserId, @Query, @QuestionId, @ActionTypeId, GETDATE())", _conn);
command.Parameters.AddWithValue("UserId", UserId);
command.Parameters.AddWithValue("Query", Query);
command.Parameters.AddWithValue("QuestionId", QuestionId);
command.Parameters.AddWithValue("ActionTypeId", (int)QueryType);
command.ExecuteNonQuery();
_conn.Close();
}
public void LogUserQuery(int UserId, string Query, int QuestionId, UsersActionsTypes QueryType)
{
using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.DatabaseConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand("insert into USERS_ACTIONS (US_ID, USA_DESCRIPTION, EXQ_ID, USAT_ID, USA_CREATED_DATE) VALUES (@UserId, @Query, @QuestionId, @ActionTypeId, GETDATE())", conn))
{
command.Parameters.AddWithValue("UserId", UserId);
command.Parameters.AddWithValue("Query", Query);
command.Parameters.AddWithValue("QuestionId", QuestionId);
command.Parameters.AddWithValue("ActionTypeId", (int)QueryType);
command.ExecuteNonQuery();
}
}
}
