public int nextId()
{
this.connection.openConnection();
MySqlCommand cmd = new MySqlCommand(SELECT_MAX_ID, this.connection.conn);
MySqlDataReader rdr = cmd.ExecuteReader();
VendaEntity entity = new VendaEntity();
while (rdr.Read())
{
entity.id = rdr.GetInt32(rdr.GetOrdinal("ID"));
}
this.connection.closeConnection();
return(entity.id + 1);
}
public List <VendaEntity> busca()
{
this.connection.openConnection();
List <VendaEntity> vendaList = new List <VendaEntity>();
MySqlCommand cmd = new MySqlCommand(SELECT_ALL, this.connection.conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
VendaEntity entity = new VendaEntity();
entity.id = rdr.GetInt32(rdr.GetOrdinal("ID"));
entity.codBar = rdr.GetInt32(rdr.GetOrdinal("COD_BAR"));
entity.quant = rdr.GetDouble(rdr.GetOrdinal("QUANT"));
entity.vrDesc = rdr.GetDouble(rdr.GetOrdinal("VR_DESC"));
entity.vrTot = rdr.GetDouble(rdr.GetOrdinal("VR_TOT"));
vendaList.Add(entity);
}
this.connection.closeConnection();
return(vendaList);
}
