public SeleccionVueloForm()
{
InitializeComponent();
string queryCiudades = "SELECT Ciudad_Cod, Ciudad_Nombre FROM TS.Ciudad WHERE Ciudad_Borrada = 0";
DbComunicator db = new DbComunicator();
origenComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryCiudades, "Ciudad_Cod", "Ciudad_Nombre"), null);
origenComboBox.DisplayMember = "Value";
origenComboBox.ValueMember = "Key";
origenComboBox.DropDownStyle = ComboBoxStyle.DropDownList;
destinoComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryCiudades, "Ciudad_Cod", "Ciudad_Nombre"), null);
destinoComboBox.DisplayMember = "Value";
destinoComboBox.ValueMember = "Key";
destinoComboBox.DropDownStyle = ComboBoxStyle.DropDownList;
}
public Llegada()
{
InitializeComponent();
string queryCiudades = "SELECT Ciudad_Nombre, Ciudad_Cod FROM TS.Ciudad";
DbComunicator db = new DbComunicator();
origenComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryCiudades, "Ciudad_Nombre", "Ciudad_Cod"), null);
origenComboBox.DisplayMember = "Key";
origenComboBox.ValueMember = "Value";
origenComboBox.DropDownStyle = ComboBoxStyle.DropDownList;
llegadaComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryCiudades, "Ciudad_Nombre", "Ciudad_Cod"), null);
llegadaComboBox.DisplayMember = "Key";
llegadaComboBox.ValueMember = "Value";
llegadaComboBox.DropDownStyle = ComboBoxStyle.DropDownList;
}
public CanjeForm()
{
InitializeComponent();
this.validator = new Commons.Validator();
quantityTextBox.KeyPress += this.InputNumField_KeyPress;
string queryClientes = "SELECT Cli_DNI + ' Nombre: ' + Cli_Nombre Cli_Detalle, Cli_Cod FROM TS.Cliente ";
DbComunicator db = new DbComunicator();
clienteComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryClientes, "Cli_Detalle", "Cli_Cod"), null);
clienteComboBox.DisplayMember = "Key";
clienteComboBox.ValueMember = "Value";
clienteComboBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
clienteComboBox.AutoCompleteSource = AutoCompleteSource.ListItems;
string queryProductos = "SELECT Prod_Nombre + ' (' + CAST (Prod_Valor AS nvarchar(255)) + ')' Prod_Detalle, Prod_Cod FROM TS.Producto";
productoComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryProductos, "Prod_Detalle", "Prod_Cod"), null);
productoComboBox.DisplayMember = "Key";
productoComboBox.ValueMember = "Value";
productoComboBox.DropDownStyle = ComboBoxStyle.DropDownList;
db.CerrarConexion();
}
public ConsultaForm()
{
InitializeComponent();
DbComunicator db = new DbComunicator();
string queryClientes = "SELECT Cli_DNI + ' Nombre: ' + Cli_Nombre Cli_Detalle, Cli_Cod FROM TS.Cliente ";
dniComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryClientes, "Cli_Detalle", "Cli_Cod"), null);
db.CerrarConexion();
dniComboBox.DisplayMember = "Key";
dniComboBox.ValueMember = "Value";
dniComboBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
dniComboBox.AutoCompleteSource = AutoCompleteSource.ListItems;
db.CerrarConexion();
}
public TarjetaBaseForm()
{
InitializeComponent();
this.validator = new Commons.Validator();
cardDateTextBox.KeyPress += InputNumField_KeyPress;
cardCodeTextBox.KeyPress += InputNumField_KeyPress;
cardNumberTextBoxt.KeyPress += InputNumField_KeyPress;
string queryCiudades = "SELECT TipoTar_Nombre, TipoTar_Cod FROM TS.Tipo_Tarjeta";
DbComunicator db = new DbComunicator();
cardEmitterComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryCiudades, "TipoTar_Nombre", "TipoTar_Cod"), null);
cardEmitterComboBox.DisplayMember = "Key";
cardEmitterComboBox.ValueMember = "Value";
cardEmitterComboBox.DropDownStyle = ComboBoxStyle.DropDownList;
db.CerrarConexion();
}
public DatosBuscadorForm()
{
InitializeComponent();
DbComunicator db = new DbComunicator();
string queryClientes = "SELECT Cli_DNI + ' Nombre: ' + Cli_Nombre Cli_Detalle, Cli_Cod FROM TS.Cliente ";
dniComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryClientes, "Cli_Detalle", "Cli_Cod"), null);
db.CerrarConexion();
dniComboBox.DisplayMember = "Key";
dniComboBox.ValueMember = "Value";
dniComboBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
dniComboBox.AutoCompleteSource = AutoCompleteSource.ListItems;
dniComboBox.SelectedValueChanged += dniComboBox_SelectedValueChanged;
dniComboBox.TextChanged += dniComboBox_TextChanged;
fullNameTextBox.Enabled = false;
addressTextBox.Enabled = false;
phoneTextBox.Enabled = false;
bornDateTimePicker.Enabled = false;
mailTextBox.Enabled = false;
cliCod = "";
editClientButton.Enabled = false;
}
public DatosPasajeForm(int viajCod, DataGridView pasajeGridView, List<int> butacasReservadas)
{
// TODO: Complete member initialization
InitializeComponent();
this.pasajeGridView = pasajeGridView;
this.butacaReservada = 0;
this.viajCod = viajCod;
acceptButton.Enabled = false;
string butacasR = "";
butacaComboBox.DropDownStyle = ComboBoxStyle.DropDownList;
DbComunicator db = new DbComunicator();
SqlCommand storeProcedure = db.GetStoreProcedure("TS.fnGetPrecioPasaje");
SqlParameter returnParameter = storeProcedure.Parameters.Add("RetVal", SqlDbType.Decimal);
returnParameter.Direction = ParameterDirection.ReturnValue;
storeProcedure.Parameters.Add(new SqlParameter("@Viaj_Cod", viajCod));
storeProcedure.ExecuteNonQuery();
db.CerrarConexion();
precioTextBox.Text = Convert.ToDecimal(returnParameter.Value).ToString();
foreach (var butaca in butacasReservadas)
{
butacasR += " AND B.But_Cod != " + butaca + " ";
}
string queryButacas = "SELECT B.But_Cod, CAST (B.But_Piso AS nvarchar(255)) + ' ' + CAST (B.But_Numero AS nvarchar(255)) + ' ' + B.But_Tipo But_Label FROM TS.Butaca as B, TS.Viaje as V ";
queryButacas += "WHERE B.But_Cod NOT IN (SELECT But_Cod FROM TS.Pasaje as P WHERE P.Can_Cod IS NULL AND P.Viaj_Cod = "+ viajCod + ") ";
queryButacas += "AND B.Aero_Num = V.Aero_Num AND V.Viaj_Cod = " + viajCod + " " + butacasR;
queryButacas += "ORDER BY B.But_Piso ASC, B.But_Numero ASC";
DbComunicator db2 = new DbComunicator();
butacaComboBox.DataSource = new BindingSource(db2.GetQueryDictionary(queryButacas, "But_Cod", "But_Label"), null);
butacaComboBox.DisplayMember = "Value";
butacaComboBox.ValueMember = "Key";
db2.CerrarConexion();
}
public override void foundCliCod(string cliCod)
{
DbComunicator db1 = new DbComunicator();
cardNumberTextBox.SelectedValueChanged -= this.cardNumberTextBoxt_valueChanged;
string queryCuentas = "SELECT Tar_Numero FROM TS.Tarjeta WHERE Cli_Cod = " + this.cliCod;
cardNumberTextBox.DataSource = new BindingSource(db1.GetQueryDictionary(queryCuentas, "Tar_Numero", "Tar_Numero"), null);
cardNumberTextBox.DisplayMember = "Value";
cardNumberTextBox.ValueMember = "Key";
cardNumberTextBox.Enabled = true;
addCreditCardButton.Enabled = true;
cardNumberTextBox.SelectedValueChanged += this.cardNumberTextBoxt_valueChanged;
cardNumberTextBox.DropDownStyle = ComboBoxStyle.DropDownList;
cardNumberDuesComboBox.DropDownStyle = ComboBoxStyle.DropDownList;
this.Cli_Cod = Convert.ToDouble(this.cliCod);
this.clientLoaded();
db1.CerrarConexion();
}
private void addClientButton_Click(object sender, EventArgs e)
{
ClienteAgregarForm ca = new ClienteAgregarForm();
ca.ShowDialog();
DbComunicator db = new DbComunicator();
string queryClientes = "SELECT Cli_DNI + ' Nombre: ' + Cli_Nombre Cli_Detalle, Cli_Cod FROM TS.Cliente ";
dniComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryClientes, "Cli_Detalle", "Cli_Cod"), null);
db.CerrarConexion();
fillInputs();
}
private void editClientButton_Click(object sender, EventArgs e)
{
string cliDni = "";
DbComunicator db1 = new DbComunicator();
db1.EjecutarQuery("SELECT Cli_DNI FROM TS.Cliente WHERE Cli_Cod = " + this.cliCod);
db1.getLector().Read();
cliDni = db1.getLector()["Cli_DNI"].ToString();
db1.CerrarConexion();
ClienteEditarForm ce = new ClienteEditarForm(cliCod, cliDni ,fullNameTextBox.Text, addressTextBox.Text, phoneTextBox.Text, mailTextBox.Text, bornDateTimePicker.Value);
ce.ShowDialog();
DbComunicator db = new DbComunicator();
string queryClientes = "SELECT Cli_DNI + ' Nombre: ' + Cli_Nombre Cli_Detalle, Cli_Cod FROM TS.Cliente ";
dniComboBox.DataSource = new BindingSource(db.GetQueryDictionary(queryClientes, "Cli_Detalle", "Cli_Cod"), null);
db.CerrarConexion();
fillInputs();
}