public List <SinglePerfPhrase> get_all_phrases_()
{
List <SinglePerfPhrase> result = new List <SinglePerfPhrase>();
string sql = "SELECT * FROM single_perf_phrase;";
MySqlCommand command = new MySqlCommand(sql, connection);
//connection.Open();
// выполняем запрос и получаем ответ
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string id_single_perf_phrase = reader["idsingle_perf_phrase"].ToString();
int num_in_perf_ = (int)reader["num_in_perf"];
string text_russian = reader["text_russian"].ToString();
string text_english = reader["text_english"].ToString();
int performance_idperformance = (int)reader["performance_idperformance"];
string actor_name = reader["actor_name"].ToString();
string animation_idanimation = reader["animation_idanimation"].ToString();
int animation_idanimation_ = 0;
try
{
animation_idanimation_ = Int32.Parse(animation_idanimation);
}
catch
{
}
SinglePerfPhrase single_perf_phrase = new SinglePerfPhrase(Int32.Parse(id_single_perf_phrase), num_in_perf_, text_russian, text_english, performance_idperformance, actor_name, animation_idanimation_);
result.Add(single_perf_phrase);
}
reader.Close();
//SinglePerfPhrase result_ = result[0];
foreach (SinglePerfPhrase res in result)
{
string sql1 = "SELECT CONVERT(text_russian USING utf8) FROM single_perf_phrase WHERE idsingle_perf_phrase = '" + res.id_single_perf_phrase.ToString() + "';";
MySqlCommand command1 = new MySqlCommand(sql1, connection);
res.text_russian = command1.ExecuteScalar().ToString();
}
return(result);
}
private void get_current_phrase()
{
single_perf_phrase = native_connect.get_current_phrase(phrase_index, 1);
//MessageBox.Show(single_perf_phrase.id_single_perf_phrase.ToString());
richTextBox1.Text = single_perf_phrase.text_russian;
textBox1.Text = single_perf_phrase.actor_name;
textBox3.Text = anim_connect.get_animation_name(single_perf_phrase.animation_idanimation);
max_id = Math.Max(single_perf_phrase.id_single_perf_phrase, max_id);
single_perf_phrases = native_connect.get_all_phrases(max_id);
listView1.Items.Clear();
foreach (SinglePerfPhrase spf in single_perf_phrases)
{
ListViewItem newitem = new ListViewItem(spf.text_russian);
newitem.SubItems.Add(anim_connect.get_animation_name(spf.animation_idanimation));
listView1.Items.Add(newitem);
}
}
