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