public void Save(Member member) { if (member.ID > 0) { DataTier.ExecuteNonQuery("UPDATE MemberDirectory_Members SET MemberFirstName = {0}, MemberLastName = {1}, MemberTitle = {2}, MemberEmail = {3} WHERE MemberID = {4}", member.FirstName, member.LastName, member.Title, member.Email, member.ID); } else { DataTier.ExecuteNonQuery("INSERT INTO MemberDirectory_Members (MemberFirstName,MemberLastName,MemberTitle,MemberEmail) VALUES ({0},{1},{2},{3})", member.FirstName, member.LastName, member.Title, member.Email); } }
public Member LoadByID(int ID) { DataTable dt = DataTier.GetDataTable("SELECT TOP 1 * FROM MemberDirectory_Members WHERE MemberID = {0}", ID); if (dt.Rows.Count > 0) { return(new Member((int)dt.Rows[0]["MemberID"], dt.Rows[0]["MemberFirstName"].ToString(), dt.Rows[0]["MemberLastName"].ToString(), dt.Rows[0]["MemberTitle"].ToString(), dt.Rows[0]["MemberEmail"].ToString() )); } return(new Member()); }
public List <Member> GetAll() { List <Member> members = new List <Member>(); foreach (DataRow row in DataTier.GetDataTable("SELECT * FROM MemberDirectory_Members").Rows) { members.Add(new Member( (int)row["MemberID"], row["MemberFirstName"].ToString(), row["MemberLastName"].ToString(), row["MemberTitle"].ToString(), row["MemberEmail"].ToString() )); } return(members); }