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