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;
}
