/// <summary> /// gets user name from model id /// </summary> /// <param name="model_id"></param> /// <returns></returns> private string GetUserName(int model_id) { int userId = ws.GetCreatorUserId(model_id); SqlConnection sqlConnection = new SqlConnection(resources.ResourceManager.GetString("Connection_String")); if (sqlConnection.State != System.Data.ConnectionState.Open) { sqlConnection.Open(); } string query = "SELECT username FROM [Users] Where Id = @user_id;"; SqlCommand sqlCmd = new SqlCommand(query, sqlConnection); sqlCmd.Parameters.AddWithValue("@user_id", userId); SqlDataReader reader = sqlCmd.ExecuteReader(); string username = ""; if (reader.Read()) { username = reader.GetString(0); } return(username); }