public List <Entity.MemberType> GetAll()
{
string query = "SELECT MemberTypeID, MemberTypeName FROM MemberType";
SqlDataReader reader = DataAccess.GetData(query);
Entity.MemberType memberType = null;
List <Entity.MemberType> memberTypeList = new List <Entity.MemberType>();
while (reader.Read())
{
memberType = new Entity.MemberType(reader["MemberTypeID"].ToString());
memberType.MemberTypeName = reader["MemberTypeName"].ToString();
memberTypeList.Add(memberType);
}
return(memberTypeList);
}
public Entity.MemberType GetMemberTypeName(string id)
{
string query = string.Format("SELECT MemberType.MemberTypeID, MemberType.MemberTypeName FROM MemberType INNER JOIN Membership on MemberType.MemberTypeID = Membership.MemberTypeID AND Membership.MembershipID = '{0}'", id);
SqlDataReader reader = DataAccess.GetData(query);
reader.Read();
Entity.MemberType memberType = null;
if (reader.HasRows)
{
memberType = new Entity.MemberType(reader["MemberTypeID"].ToString());
memberType.MemberTypeName = reader["MemberTypeName"].ToString();
}
else
{
MessageBox.Show("Member Not Found!");
}
return(memberType);
}
public int Edit(Entity.MemberType memberType)
{
string query = "UPDATE Account SET MemberTypeName='" + memberType.MemberTypeName + "' WHERE MemberTypeID=" + memberType.MemberTypeID;
return(DataAccess.ExecuteQuery(query));
}
public int Add(Entity.MemberType memberType)
{
string query = string.Format("INSERT INTO MemberType(MemberTypeID, MemberTypeName) VALUES('{0}', '{1}')", memberType.MemberTypeID, memberType.MemberTypeName);
return(DataAccess.ExecuteQuery(query));
}
public int Edit(Entity.MemberType memberType)
{
return(MemberTypeService.memberTypeDataAccess.Edit(memberType));
}
public int Add(Entity.MemberType memberType)
{
return(MemberTypeService.memberTypeDataAccess.Add(memberType));
}
