private void CbxPais_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e) { selectedPais = CbxPais.SelectedItem as Pais; CbxEstado.DataContext = selectedPais.Estados; CbxEstado.SelectedItem = estado; }
/// <summary> /// Obtiene el listado de paises capturados en el sistema /// </summary> /// <returns></returns> public ObservableCollection<Pais> GetPaises() { ObservableCollection<Pais> catalogoPaises = new ObservableCollection<Pais>(); string sqlCadena = "SELECT * FROM C_Pais ORDER BY PaisMay"; OleDbConnection connection = new OleDbConnection(connectionString); OleDbCommand cmd = null; OleDbDataReader reader = null; try { connection.Open(); cmd = new OleDbCommand(sqlCadena, connection); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Pais pais = new Pais(); pais.IdPais = Convert.ToInt32(reader["IdPais"]); pais.PaisDesc = reader["Pais"].ToString(); pais.PaisStr = reader["PaisMay"].ToString(); catalogoPaises.Add(pais); } } cmd.Dispose(); reader.Close(); catalogoPaises.Add(dummyPais); } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,PaisEstadoModel", "PadronApi"); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,PaisEstadoModel", "PadronApi"); } finally { connection.Close(); } return catalogoPaises; }
/// <summary> /// Obtiene el país al que pertenece un estado /// </summary> /// <param name="idEstado">Estado del cual se quiere conocer el país</param> /// <returns></returns> public Pais GetPaises(int idEstado) { Pais pais = new Pais(); string sqlCadena = "SELECT P.* FROM C_Pais P INNER JOIN C_Estado E ON P.IdPais = E.IdPais WHERE IdEstado = @IdEstado ORDER BY PaisMay"; OleDbConnection connection = new OleDbConnection(connectionString); OleDbCommand cmd = null; OleDbDataReader reader = null; try { connection.Open(); cmd = new OleDbCommand(sqlCadena, connection); cmd.Parameters.AddWithValue("@IdEstado", idEstado); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { pais.IdPais = Convert.ToInt32(reader["IdPais"]); pais.PaisDesc = reader["Pais"].ToString(); pais.PaisStr = reader["PaisMay"].ToString(); } } cmd.Dispose(); reader.Close(); } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,PaisEstadoModel", "PadronApi"); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,PaisEstadoModel", "PadronApi"); } finally { connection.Close(); } return pais; }
public bool InsertaPais(Pais pais) { OleDbConnection connection = new OleDbConnection(connectionString); bool insertCompleted = false; pais.IdPais = DataBaseUtilities.GetNextIdForUse("C_Pais", "IdPais", connection); try { connection.Open(); string sqlQuery = "INSERT INTO C_Pais(IdPais,Pais,PaisMay)" + "VALUES (@IdPais,@Pais,@PaisMay)"; OleDbCommand cmd = new OleDbCommand(sqlQuery, connection); cmd.Parameters.AddWithValue("@IdPais", pais.IdPais); cmd.Parameters.AddWithValue("@Pais", pais.PaisDesc); cmd.Parameters.AddWithValue("@PaisMay", StringUtilities.PrepareToAlphabeticalOrder(pais.PaisDesc)); cmd.ExecuteNonQuery(); cmd.Dispose(); insertCompleted = true; } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,PaisEstadoModel", "PadronApi"); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,PaisEstadoModel", "PadronApi"); } finally { connection.Close(); } return insertCompleted; }
public PaisEstadoWin(Pais pais,bool isUpdating) { InitializeComponent(); this.pais = pais; this.isUpdating = isUpdating; }
private void CbxPais_SelectionChanged(object sender, SelectionChangedEventArgs e) { selectedPais = CbxPais.SelectedItem as Pais; if (selectedPais.IdPais == 999999999) { Pais newPais = new Pais(); PaisEstadoWin addPais = new PaisEstadoWin(newPais, false); addPais.Owner = this; addPais.ShowDialog(); if (addPais.DialogResult == true) { PaisesSingleton.Paises.Insert(0, newPais); CbxPais.SelectedItem = newPais; } else { CbxPais.SelectedValue = 39; } } else { if (selectedPais.Estados == null) selectedPais.Estados = new PaisEstadoModel().GetEstados(selectedPais.IdPais); } CbxEstado.DataContext = selectedPais.Estados; CbxEstado.IsEnabled = true; }