public List <BiddersOfNotice> FindBiddersOfTender(string tenderId) { DbConnection.Open(); MySqlCommand command = DbConnection.CreateCommand(); command.CommandText = "select * from bid left join bidder on bid.owner = bidder.username where noticeid =@value"; command.Parameters.AddWithValue("@value", tenderId); MySqlDataReader reader = command.ExecuteReader(); List <BiddersOfNotice> biderList = new List <BiddersOfNotice>(); while (reader.Read()) { BiddersOfNotice bidder = new BiddersOfNotice(); bidder.userName = reader.GetString("userName"); bidder.BidId = reader.GetInt32("BidId"); bidder.Name = reader.GetString("name"); bidder.Address = reader.GetString("address"); bidder.tpNo = reader.GetString("tpNo"); biderList.Add(bidder); } DbConnection.Close(); return(biderList); }
public List<BiddersOfNotice> FindBiddersOfTender(string tenderId) { DbConnection.Open(); MySqlCommand command = DbConnection.CreateCommand(); command.CommandText = "select * from bid left join bidder on bid.owner = bidder.username where noticeid =@value"; command.Parameters.AddWithValue("@value", tenderId); MySqlDataReader reader = command.ExecuteReader(); List<BiddersOfNotice> biderList = new List<BiddersOfNotice>(); while (reader.Read()) { BiddersOfNotice bidder = new BiddersOfNotice(); bidder.userName = reader.GetString("userName"); bidder.BidId = reader.GetInt32("BidId"); bidder.Name = reader.GetString("name"); bidder.Address = reader.GetString("address"); bidder.tpNo = reader.GetString("tpNo"); biderList.Add(bidder); } DbConnection.Close(); return biderList; }