private void button2_Click(object sender, RoutedEventArgs e)
{
InsEditWindow.Close();
}
private void button1_Click(object sender, RoutedEventArgs e)
{
try
{
switch (tableName)
{
case "Conference":
{
if (textBox1.Text == "" || datePicker1.SelectedDate.ToString() == "" || datePicker2.SelectedDate.ToString() == "")
{
MessageBox.Show("Заполнены не все поля");
}
else
{
dbConn.Open();
if ((int)Tag == 0)
{
sqlCmd = new NpgsqlCommand($"CALL INSERT_INTO_CONFERENCE('{textBox1.Text}', '{datePicker1.SelectedDate}', '{datePicker2.SelectedDate}')", dbConn);
}
else
{
sqlCmd = new NpgsqlCommand($"CALL UPDATE_CONFERENCE({currentDataRow[0]}, '{textBox1.Text}', '{datePicker1.SelectedDate}', '{datePicker2.SelectedDate}')", dbConn);
}
sqlCmd.ExecuteNonQuery();
InsEditWindow.Close();
dbConn.Close();
}
break;
}
case "SectionLeaders":
{
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
{
MessageBox.Show("Заполнены не все поля");
}
else
{
dbConn.Open();
if ((int)Tag == 0)
{
sqlCmd = new NpgsqlCommand($"CALL INSERT_INTO_SECTION_LEADER('{textBox1.Text}', '{textBox2.Text}', '{textBox3.Text}')", dbConn);
}
else
{
sqlCmd = new NpgsqlCommand($"CALL UPDATE_SECTION_LEADER({currentDataRow[0]}, '{textBox1.Text}', '{textBox2.Text}', '{textBox3.Text}')", dbConn);
}
sqlCmd.ExecuteNonQuery();
InsEditWindow.Close();
dbConn.Close();
}
break;
}
case "Section":
{
if (textBox1.Text == "" || datePicker1.SelectedDate.ToString() == "" || datePicker2.SelectedDate.ToString() == "" || comboBox1.SelectedItem == null || comboBox2.SelectedItem == null)
{
MessageBox.Show("Заполнены не все поля");
}
else
{
dbConn.Open();
if ((int)Tag == 0)
{
sqlCmd = new NpgsqlCommand($"CALL INSERT_INTO_SECTION('{textBox1.Text}', '{datePicker1.SelectedDate}', '{datePicker2.SelectedDate}', '{comboBox1.SelectedValue}', '{comboBox2.SelectedValue}')", dbConn);
}
else
{
sqlCmd = new NpgsqlCommand($"CALL UPDATE_SECTION({currentDataRow[0]}, '{textBox1.Text}', '{datePicker1.SelectedDate}', '{datePicker2.SelectedDate}', '{comboBox1.SelectedValue}', '{comboBox2.SelectedValue}')", dbConn);
}
sqlCmd.ExecuteNonQuery();
InsEditWindow.Close();
dbConn.Close();
}
break;
}
case "Member":
{
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "")
{
MessageBox.Show("Заполнены не все поля");
}
else
{
dbConn.Open();
if ((int)Tag == 0)
{
sqlCmd = new NpgsqlCommand($"CALL INSERT_INTO_MEMBER('{textBox1.Text}', '{textBox2.Text}', '{textBox3.Text}', '{textBox4.Text}', '{textBox5.Text}', '{textBox6.Text}')", dbConn);
}
else
{
sqlCmd = new NpgsqlCommand($"CALL UPDATE_MEMBER({currentDataRow[0]}, '{textBox1.Text}', '{textBox2.Text}', '{textBox3.Text}', '{textBox4.Text}', '{textBox5.Text}', '{textBox6.Text}')", dbConn);
}
sqlCmd.ExecuteNonQuery();
InsEditWindow.Close();
dbConn.Close();
}
break;
}
case "Lecture":
{
if (textBox1.Text == "" || datePicker1.SelectedDate.ToString() == "" || comboBox1.SelectedItem == null || comboBox2.SelectedItem == null)
{
MessageBox.Show("Заполнены не все поля");
}
else
{
dbConn.Open();
if ((int)Tag == 0)
{
sqlCmd = new NpgsqlCommand($"CALL INSERT_INTO_LECTURE('{textBox1.Text}', '{datePicker1.SelectedDate}', '{comboBox1.SelectedValue}', '{comboBox2.SelectedValue}')", dbConn);
}
else
{
sqlCmd = new NpgsqlCommand($"CALL UPDATE_LECTURE({currentDataRow[0]}, '{textBox1.Text}', '{datePicker1.SelectedDate}', '{comboBox1.SelectedValue}', '{comboBox2.SelectedValue}')", dbConn);
}
sqlCmd.ExecuteNonQuery();
InsEditWindow.Close();
dbConn.Close();
}
break;
}
}
}
catch (NpgsqlException ex)
{
MessageBox.Show($"Ошибка: {ex.Message}", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
Close();
}
}