private void BtDelete_Click(object sender, RoutedEventArgs e)
{
string connectionString;
connectionString = Properties.Settings.Default.CazareDBConnectionString;
string quary;
quary = "DELETE FROM Turisti WHERE ziuaP = @ziua and lunaP = @luna and anulP = @anul or codT = @cod";
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
dataGrid.ItemsSource = null;
int ziua;
int luna;
int anul;
if (tbZiua.Text == "" || tbLuna.Text == "" || tbAnul.Text == "")
{
ziua = 0;
luna = 0;
anul = 0;
}
else
{
ziua = int.Parse(tbZiua.Text);
luna = int.Parse(tbLuna.Text);
anul = int.Parse(tbAnul.Text);
}
SqlCommand command = new SqlCommand(quary, conn);
command.Parameters.AddWithValue("@ziua", ziua);
command.Parameters.AddWithValue("@luna", luna);
command.Parameters.AddWithValue("@anul", anul);
command.Parameters.AddWithValue("@cod", tbCod.Text);
conn.Open();
command.ExecuteNonQuery();
tbZiua.Text = "";
tbLuna.Text = "";
tbAnul.Text = "";
tbCod.Text = "";
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM Turisti", conn);
DataTable dt = new DataTable();
adapter.Fill(dt);
dataGrid.ItemsSource = dt.DefaultView;
conn.Close();
}
}
catch (Exception)
{
MessageBox.Show("Eroare! Incorect formatul de date.");
scoate = new scoateEvidenta();
this.Close();
scoate.Show();
}
}
private void btnScEvidenta_Click(object sender, RoutedEventArgs e)
{
scoateEvidenta = new scoateEvidenta();
scoateEvidenta.Show();
this.Close();
}