private void onEditarTipoExtrasClick(object sender, RoutedEventArgs e)
{
if (ListBoxTipoExtras.SelectedItem == null)
{
return;
}
TipoExtra tipoExtraActual = ListBoxTipoExtras.SelectedItem as TipoExtra;
if (tipoExtraActual == null)
{
return;
}
EditarTipoExtraDialog tipoExtraDialog = new EditarTipoExtraDialog(new TipoExtra()
{
Nome = tipoExtraActual.Nome
});
tipoExtraDialog.Title = "Editar Tipo Jato";
if (tipoExtraDialog.ShowDialog() == true && tipoExtraDialog.TipoExtra != tipoExtraActual)
{
tipoExtraActual.Nome = tipoExtraDialog.TipoExtra.Nome;
App.AirUberDB.EditarTipoExtra(tipoExtraActual);
}
}
public void EditarTipoExtra(TipoExtra tipoExtra)
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
string sql = "UPDATE [TipoExtra] SET [Nome] ='" +
tipoExtra.Nome + "' WHERE ([TipoExtraId] = " +
tipoExtra.TipoExtraId.ToString() + ")";
cmd.CommandText = sql;
int regs = 0;
try
{
con.Open();
regs = cmd.ExecuteNonQuery();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
finally
{
con.Close();
}
//MessageBox.Show(regs + " tipo de extra actualizado");
}
/// Extras
public int InserirTipoExtra(TipoExtra tipoExtra)
{
int newId = -1;
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
string sqlInsert = "INSERT INTO [TipoExtra] ([Nome]) VALUES ('" + tipoExtra.Nome + "')";
cmd.CommandText = sqlInsert;
//string sqlSelect = "SELECT [Nome] FROM TipoJato WHERE (TipoJatoId = SCOPE_IDENTITY())";
int regs = 0;
try
{
con.Open();
regs = cmd.ExecuteNonQuery();
/*SqlDataReader dr;
* cmd.CommandText = sqlSelect;
* dr = cmd.ExecuteReader();
*
* if (dr.Read())
* newId = (int)dr["TipoJatoId"];
*/
}
catch (Exception exc)
{
//MessageBox.Show(exc.Message);
}
finally
{
con.Close();
}
//MessageBox.Show(regs + " tipo de jato adicionado (" + newId + ")");
return(newId);
}
public ObservableCollection <TipoExtra> GetTipoExtras()
{
ObservableCollection <TipoExtra> tipoExtras = new ObservableCollection <TipoExtra>();
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
string sql = "SELECT * FROM TipoExtra";
cmd.CommandText = sql;
try
{
con.Open();
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
TipoExtra tipoExtra = new TipoExtra();
tipoExtra.TipoExtraId = (int)dr["TipoExtraId"];
tipoExtra.Nome = (string)dr["Nome"];
tipoExtras.Add(tipoExtra);
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
finally
{
con.Close();
}
return(tipoExtras);
}
private void onEliminarTipoExtrasClick(object sender, RoutedEventArgs e)
{
if (ListBoxTipoExtras.SelectedItem == null)
{
return;
}
TipoExtra tipoExtraActual = ListBoxTipoExtras.SelectedItem as TipoExtra;
if (tipoExtraActual == null)
{
return;
}
if (MessageBox.Show("Quer apagar o tipoExtraActual?", "Apagar tipo de extra?", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
App.AirUberDB.EliminarTipoExtra(tipoExtraActual.TipoExtraId);
ListBoxTipoExtras.Items.MoveCurrentToFirst();
onVerTipoExtrasClick(null, null);
}
}
public ObservableCollection <Extra> GetExtras()
{
ObservableCollection <Extra> extras = new ObservableCollection <Extra>();
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
string sql = "SELECT e.ExtraId AS 'ExtraId', e.Nome AS 'NomeExtra', e.Valor AS 'Valor', " +
"te.TipoExtraId AS 'TipoExtraId', te.Nome AS 'TipoExtraNome', " +
"c.CompanhiaId AS 'CompId', c.Nome AS 'NomeComp' " +
"FROM Extra e " +
"JOIN TipoExtra te ON e.TipoExtraId = te.TipoExtraId " +
"JOIN Companhia c ON e.CompanhiaId = c.CompanhiaId";
cmd.CommandText = sql;
try
{
con.Open();
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
Extra extra = new Extra();
extra.ExtraId = (int)dr["ExtraId"];
extra.Nome = (string)dr["NomeExtra"];
extra.Valor = (decimal)dr["Valor"];
TipoExtra tipoExtra = new TipoExtra();
tipoExtra.TipoExtraId = (int)dr["TipoExtraId"];
tipoExtra.Nome = (string)dr["TipoExtraNome"];
extra.TipoExtraId = (int)dr["TipoExtraId"];
extra.TipoExtra = tipoExtra;
Companhia companhia = new Companhia();
companhia.CompanhiaId = (int)dr["CompId"];
companhia.Nome = (string)dr["NomeComp"];
extra.CompanhiaId = (int)dr["CompId"];
extra.Companhia = companhia;
extras.Add(extra);
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
finally
{
con.Close();
}
return(extras);
}
