public bool Insert(Membership membership)
{
using (MembershipDataAdapter adapter = new MembershipDataAdapter())
{
return adapter.InsertMembership(membership.Username, membership.Password,
membership.Authorization, membership.EmployeeId);
}
}
public bool IsMembershipExist(int id)
{
bool exist = false;
using (IDataReader dr = new MembershipDataAdapter().GetMembershipById(id))
{
if (dr.Read())
exist = true;
dr.Close();
}
return exist;
}
public Membership GetMembershipByUsername(string username)
{
Membership membership = new Membership();
using (MembershipDataAdapter adapter = new MembershipDataAdapter())
{
IDataReader dr = adapter.GetMembershipByUsername(username);
if (dr.Read())
{
membership = PopulateReader(dr);
adapter.Dispose();
}
return membership;
}
}
public Membership GetMembershipById(int id)
{
Membership membership = new Membership();
using (MembershipDataAdapter adapter = new MembershipDataAdapter())
{
IDataReader dr = adapter.GetMembershipById(id);
if (dr.Read())
{
membership = PopulateReader(dr);
adapter.Dispose();
}
return membership;
}
}
