예제 #1
0
        private void CbxPais_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e)
        {
            selectedPais = CbxPais.SelectedItem as Pais;

            CbxEstado.DataContext = selectedPais.Estados;
            CbxEstado.SelectedItem = estado;
        }
예제 #2
0
        /// <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;
        }
예제 #3
0
        /// <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;
        }
예제 #4
0
        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;
        }
예제 #5
0
 public PaisEstadoWin(Pais pais,bool isUpdating)
 {
     InitializeComponent();
     this.pais = pais;
     this.isUpdating = isUpdating;
 }
예제 #6
0
        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;
        }