public List <MemberCard> findAll() { List <MemberCard> list = null; String sql = "SELECT * FROM members_cards"; using (MySqlDataReader rdr = MySqlHelper.ExecuteReader(MySqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql)) { while (true) { if (list == null) { list = new List <MemberCard>(); } MemberCard card = fillMemberCard(rdr); if (card == null) { break; } list.Add(card); } } return(list); }
public MemberCard find(string no) { MemberCard card = null; String sql = String.Format("SELECT * FROM members_cards WHERE card_no = '{0}'", no); using (MySqlDataReader rdr = MySqlHelper.ExecuteReader(MySqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql)) { card = fillMemberCard(rdr); } return(card); }