private void GetDropMarca()
{
try
{
MARCAProvider MARCAP = new MARCAProvider();
MARCACollection MarcaColl = new MARCACollection();
MarcaColl = MARCAP.ReadCollectionByParameter(null, "NOME");
cbMarca.DisplayMember = "NOME";
cbMarca.ValueMember = "IDMARCA";
MARCAEntity MARCATy = new MARCAEntity();
MARCATy.NOME = ConfigMessage.Default.MsgDrop;
MARCATy.IDMARCA = -1;
MarcaColl.Add(MARCATy);
Phydeaux.Utilities.DynamicComparer <MARCAEntity> comparer = new Phydeaux.Utilities.DynamicComparer <MARCAEntity>(cbMarca.DisplayMember);
MarcaColl.Sort(comparer.Comparer);
cbMarca.DataSource = MarcaColl;
cbMarca.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("Erro técnico: " + ex.Message);
}
}
private static MARCACollection ExecuteReader(ref MARCACollection collection, ref FbDataReader dataReader, FbCommand dbCommand)
{
using (dataReader = dbCommand.ExecuteReader())
{
collection = new MARCACollection();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
collection.Add(FillEntityObject(ref dataReader));
}
}
if (!(dataReader.IsClosed))
{
dataReader.Close();
}
dataReader.Dispose();
}
return(collection);
}