public MembersDataset GetMembers()
{
//Load a list of Member selections
MembersDataset ds = new MembersDataset();
MembershipUserCollection members = Membership.GetAllUsers();
foreach (MembershipUser member in members)
{
MembersDataset.MembershipTableRow row = ds.MembershipTable.NewMembershipTableRow();
row.UserName = member.UserName;
row.Password = "";
row.Email = member.Email;
row.IsApproved = member.IsApproved;
row.IsLockedOut = member.IsLockedOut;
row.CreateDate = member.CreationDate;
row.LastLoginDate = member.LastLoginDate;
row.Comment = member.Comment;
row.IsOnline = member.IsOnline;
row.LastActivityDate = member.LastActivityDate;
row.ClientID = GetMemberProfile(member.UserName).ClientID;
ds.MembershipTable.AddMembershipTableRow(row);
}
ds.AcceptChanges();
return(ds);
}
public MembersDataset GetMembers()
{
//Load a list of Member selections
MembersDataset ds = new MembersDataset();
MembershipUserCollection members = Membership.GetAllUsers();
foreach (MembershipUser member in members)
{
MembersDataset.MembershipTableRow row = ds.MembershipTable.NewMembershipTableRow();
row.Comment = member.Comment;
row.CreateDate = member.CreationDate;
row.Email = member.Email;
row.IsApproved = member.IsApproved;
row.IsLockedOut = member.IsLockedOut;
row.IsOnline = member.IsOnline;
row.LastActivityDate = member.LastActivityDate;
row.LastLockoutDate = member.LastLockoutDate;
row.LastLoginDate = member.LastLoginDate;
row.LastPasswordChangedDate = member.LastPasswordChangedDate;
row.PasswordQuestion = member.PasswordQuestion;
row.UserName = member.UserName;
ProfileCommon profile = new ProfileCommon().GetProfile(member.UserName);
row.UserFullName = profile.UserFullName;
row.Company = profile.Company;
ds.MembershipTable.AddMembershipTableRow(row);
}
ds.AcceptChanges();
return(ds);
}
private void MemberReport_Load(object sender, EventArgs e)
{
RptMembers Report1 = new RptMembers();
MembersDataset dsMembers = GetData();
Report1.SetDataSource(dsMembers);
this.crystalReportViewer1.ReportSource = Report1;
this.crystalReportViewer1.RefreshReport();
}
private void ContributionReport_Load(object sender, EventArgs e)
{
RptContributions Report1 = new RptContributions();
MembersDataset dsContr = GetData();
Report1.SetDataSource(dsContr);
this.crystalReportViewer1.ReportSource = Report1;
this.crystalReportViewer1.RefreshReport();
}
private MembersDataset GetData()
{
string constr = @"Data Source=DESKTOP-V5221FL\SQLEXPRESS;Initial Catalog=SACCO;Integrated Security=True";
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT TOP 20 * FROM Members"))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (MembersDataset dsCustomers = new MembersDataset())
{
sda.Fill(dsCustomers, "Members");
return(dsCustomers);
}
}
}
}
}
