public static MembersList LoadMembers()
{
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MembersList target = new MembersList();
var memb =
from p in db.Players
orderby p.Name
select p;
_count = 0;
foreach (var item in memb)
{
MrMember newMember = new MrMember()
{
pID = item.PlayerID,
name = item.Name,
fname = item.FName,
lname = item.LName,
gender = item.Sex,
hcp = item.Hcp,
memberNumber = item.MemberID,
title = item.Title,
hdate = item.HDate,
del = item.Delete
};
newMember.active = SignupList.CountPlayersActiveSignupEntries(item.PlayerID);
target.Members.Add(newMember);
_count++;
}
Count = _count;
return(target);
}
public static int DeleteMember(int playerID)
{
int err = 1; // set result to not deleted
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
var pl = db.Players.Single(p => p.PlayerID == playerID);
_MembersName = pl.Name;
if (SignupList.CountPlayersActiveSignupEntries(playerID) == 0) // delete is active records is zero
{
db.Players.DeleteOnSubmit(pl);
var deleteSignupEntries =
from SignupEntries in db.PlayersList
where SignupEntries.PlayerID == playerID
select SignupEntries;
if (deleteSignupEntries != null)
{
foreach (var SignupEntry in deleteSignupEntries)
{
// delete all signup records for this member
db.PlayersList.DeleteOnSubmit(SignupEntry);
}
db.SubmitChanges();
err = 0; // set result to deleted
}
}
return(err);
}
protected void Member_ItemCommand(Object Sender, RepeaterCommandEventArgs e)
{
Label2.Text = "The " + ((Button)e.CommandSource).Text + " button has just been clicked; <br />";
playerID = Convert.ToInt32(e.CommandArgument);
Label3.Text = string.Format(@"Player ID ""{0}"" has been selected.", playerID);
// lblKey.Text = pkey.Trim();
// lblChangeDate.Text = etzNow.ToString();
//
// write method to get all member information and load UpdatePanel1 controls with data
//
ActiveSignups = SignupList.CountPlayersActiveSignupEntries(playerID);
Session["ActiveSignups"] = ActiveSignups.ToString();
Session["PlayerID"] = playerID.ToString();
if (ActiveSignups > 0)
{
btnDelete.Enabled = false;
}
DisplayMemberInfo(playerID);
DisplayPanel.Visible = false;
UpdatePanel1.Visible = true;
}