public DataSet GetFlightByAirportANDAirline(string airport, string airline)
{
SqlDataAdapter Adapt = new SqlDataAdapter();
Adapt.TableMappings.Add("Table", "Vuelo");
SqlCommand comnd = new SqlCommand();
comnd.Connection = ConnectionClass.Connect();
comnd.CommandText = $"dbo.STP_VuelosPorAeropuertoPorAerolinea_SLT '{airport}', '{airline}'";
comnd.CommandType = CommandType.Text;
Adapt.SelectCommand = comnd;
DataSet dts = new DataSet("vuelo");
Adapt.Fill(dts);
return(dts);
}
public DataSet GetOneFlight(int ID)
{
SqlDataAdapter Adapt = new SqlDataAdapter();
Adapt.TableMappings.Add("Table", "Vuelo");
SqlCommand comnd = new SqlCommand();
comnd.Connection = ConnectionClass.Connect();
comnd.CommandText = "EXEC dbo.STP_Vuelo_SLTONE " + ID;
comnd.CommandType = CommandType.Text;
Adapt.SelectCommand = comnd;
DataSet dts = new DataSet("vuelo");
Adapt.Fill(dts);
return(dts);
}
public DataSet SeachPersonByName(string name, string lastname)
{
SqlDataAdapter Adapt = new SqlDataAdapter();
Adapt.TableMappings.Add("Table", "personal");
SqlCommand comnd = new SqlCommand();
comnd.Connection = ConnectionClass.Connect();
comnd.CommandText = $"dbo.STP_Personal_Vuelo_SLTONE '{name}', '{lastname}'";
comnd.CommandType = CommandType.Text;
Adapt.SelectCommand = comnd;
DataSet dts = new DataSet("personal");
Adapt.Fill(dts);
return(dts);
}
public DataSet GetPersonal()
{
SqlDataAdapter Adapt = new SqlDataAdapter();
Adapt.TableMappings.Add("Table", "Personal");
SqlCommand comnd = new SqlCommand();
comnd.Connection = ConnectionClass.Connect();
comnd.CommandText = "EXEC dbo.STP_Personal_Vuelo_SLTALL";
comnd.CommandType = CommandType.Text;
Adapt.SelectCommand = comnd;
DataSet dts = new DataSet("persona");
Adapt.Fill(dts);
return(dts);
}
private void btn_RemoverVuelo_Click(object sender, EventArgs e)
{
SqlConnection sql = ConnectionClass.Connect();
SqlCommand cmd = new SqlCommand("dbo.STP_Vuelo_DLT", sql);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@varIDVuelo", int.Parse(tbx_NumVuelo.Text));
int i = cmd.ExecuteNonQuery();
sql.Close();
if (i != 0)
{
MessageBox.Show(i + "Data Removed");
}
}
private void btn_AgregarAerolinea_Click(object sender, EventArgs e)
{
SqlConnection sql = ConnectionClass.Connect();
SqlCommand cmd = new SqlCommand("dbo.STP_Aerolinea_INS", sql);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@varNombre", textBox1.Text);
cmd.Parameters.AddWithValue("@varIDPais", int.Parse(textBox2.Text));
int i = cmd.ExecuteNonQuery();
sql.Close();
if (i != 0)
{
MessageBox.Show(i + " Data Saved");
}
}
private void btn_Modificar_Click(object sender, EventArgs e)
{
SqlConnection sql = ConnectionClass.Connect();
SqlCommand cmd = new SqlCommand("dbo.STP_Vuelo_UPD", sql);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@varCodigo", Tbx_CodigoVuelo.Text);
cmd.Parameters.AddWithValue("@varIDAvionNuevo", int.Parse(Tbx_Avion.Text));
cmd.Parameters.AddWithValue("@varIDAerolineaNueva", int.Parse(Tbx_Aerolinea.Text));
cmd.Parameters.AddWithValue("@varIDAeropuertoSalidaNuevo", int.Parse(Tbx_AeropuertoSalida.Text));
cmd.Parameters.AddWithValue("@varIDAeropuertoLlegadaNuevo", int.Parse(Tbx_AeropuertoLlegada.Text));
cmd.Parameters.AddWithValue("@varFechaSalidaNueva", Tbx_FechaSalida.Text);
cmd.Parameters.AddWithValue("@varFechaLlegadaNueva", Tbx_FechaEntrada.Text);
cmd.Parameters.AddWithValue("@varEstadoNuevo", Tbx_Estado.Text);
int i = cmd.ExecuteNonQuery();
sql.Close();
if (i != 0)
{
MessageBox.Show(i + " Data Saved");
}
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection sql = ConnectionClass.Connect();
SqlCommand cmd = new SqlCommand("dbo.STP_Vuelo_INS", sql);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@varCodigo", tbx_Codigo.Text);
cmd.Parameters.AddWithValue("@varID_Avion", int.Parse(Tbox_Avion.Text));
cmd.Parameters.AddWithValue("@varID_Aerolinea", int.Parse(Tbox_Aerolinea.Text));
cmd.Parameters.AddWithValue("@varIDAeropuertoSalida", int.Parse(Tbox_AeropuertoS.Text));
cmd.Parameters.AddWithValue("@varIDAeropuertoLlegada", int.Parse(Tbox_AeropuertoE.Text));
cmd.Parameters.AddWithValue("@FechaSalida", Tbox_HoraSalida.Text);
cmd.Parameters.AddWithValue("@FechaLlegada", Tbox_HoraLlegada.Text);
cmd.Parameters.AddWithValue("@Estado", tbx_Estado.Text);
int i = cmd.ExecuteNonQuery();
sql.Close();
if (i != 0)
{
MessageBox.Show(i + " Data Saved");
}
}