private void deleteBtn_Click(object sender, EventArgs e) { try { if (searchBtnWasClicked == true || addBtnWasClicked == true) { var confirmResult = MessageBox.Show("Сигурни ли сте, че искате да изтриете записа?", "Потвърждение!!", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "DELETE from ProfessionalField where ProfessionalFieldID = '" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'"; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Успешно изтрити данни!"); ProfesionalField2.Visible = false; ProfesionalField1.Clear(); Display(); } } else { MessageBox.Show("Невалидна команда!"); return; } } catch { MessageBox.Show("Невалидни данни!"); } }
private void searchBtn_Click(object sender, EventArgs e) { searchBtnWasClicked = true; con.Open(); SqlCommand search = con.CreateCommand(); search.CommandType = CommandType.Text; search.CommandText = "SELECT * from ProfessionalField where Name like '%" + ProfesionalField1.Text + "%' order by ProfessionalFieldID"; search.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(search); da.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.Columns[0].HeaderText = "Номер"; dataGridView1.Columns[1].HeaderText = "Наименование"; con.Close(); ProfesionalField1.Clear(); }
private void editBtn_Click(object sender, EventArgs e) { try { long n = 1; double m = 1.0; if (long.TryParse(ProfesionalField2.Text, out n) && double.TryParse(ProfesionalField2.Text, out m)) { MessageBox.Show("Не може да се добавят числови данни!"); return; } if (ProfesionalField1.Text == "" && ProfesionalField2.Visible == true) { MessageBox.Show("Невалидни данни!"); ProfesionalField2.Visible = false; editBtn.Visible = false; return; } if (ProfesionalField2.Visible == true) { con.Open(); SqlCommand search = con.CreateCommand(); search.CommandType = CommandType.Text; search.CommandText = "UPDATE ProfessionalField set Name = '" + ProfesionalField2.Text + "' where Name = '" + ProfesionalField1.Text + "'"; search.ExecuteNonQuery(); con.Close(); MessageBox.Show("Успешно обновяване!"); ProfesionalField2.Visible = false; editBtn.Visible = false; ProfesionalField1.Clear(); Display(); } } catch { MessageBox.Show("Не може еднa професионална област\r\n да се повтаря повече от веднъж!"); } }
private void addBtn_Click(object sender, EventArgs e) { try { if (ProfesionalField1.Text == "") { MessageBox.Show("Невалидни данни!"); return; } long n = 1; double m = 1.0; if (!long.TryParse(ProfesionalField1.Text, out n) && !double.TryParse(ProfesionalField1.Text, out m)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT into ProfessionalField values('" + ProfesionalField1.Text + "')"; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Успешно добавени данни!"); ProfesionalField2.Visible = false; ProfesionalField1.Clear(); Display(); addBtnWasClicked = true; } else { MessageBox.Show("Не може да се добавят числови данни!"); } } catch { MessageBox.Show($"{ProfesionalField1.Text} вече съществува!"); con.Close(); } }