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);
}
public static SignupList LoadPlayersListDB()
{
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
SignupList target = new SignupList();
var slist =
from pl in db.PlayersList
orderby pl.TransDate
select pl;
int seqNo = 0;
foreach (var item in slist)
{
seqNo++;
SignupEntry entry = new SignupEntry()
{
SeqNo = seqNo,
STDate = item.TransDate,
SeventId = item.EventID,
SPlayerID = item.PlayerID,
Saction = item.Action,
Scarpool = item.Carpool,
Smarked = item.Marked,
SspecialRule = item.SpecialRule,
SGuest = item.GuestID,
SSelected = false,
SDelete = false
};
entry.Splayer = GetPlayerName(item.PlayerID);
target.entries.Add(entry);
}
return(target);
}
protected void getPlayersList(string eid)
{
this.sl = SignupList.LoadFromPlayersListDB(eid); // load Signup entries from PlayersLists for the selected Event ID
this.PlayersListRepeater.DataSource = new SignupList[] { this.sl };
this.PlayersListRepeater.DataBind();
this.GuestListRepeater.DataSource = new SignupList[] { this.sl };
this.GuestListRepeater.DataBind();
}
public static SignupList LoadFromPlayersListDB(string EventID)
{
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
SignupList target = new SignupList();
var slist =
from pl in db.PlayersList
join pn in db.Players on pl.PlayerID equals pn.PlayerID
where pl.EventID == EventID && pl.Marked == 0
orderby pl.TransDate
select new { pl.TransDate, pl.EventID, pl.PlayerID, pn.Name, pn.Sex, pn.Hcp, pl.Action, pl.Carpool, pl.Marked, pl.SpecialRule, pl.GuestID };
int seqNo = 0;
foreach (var item in slist)
{
seqNo++;
SignupEntry entry = new SignupEntry()
{
SeqNo = seqNo,
STDate = item.TransDate,
SeventId = item.EventID,
SPlayerID = item.PlayerID,
Splayer = item.Name,
Shcp = item.Hcp,
Saction = item.Action,
Scarpool = item.Carpool,
Smarked = item.Marked,
SspecialRule = item.SpecialRule,
SGuest = item.GuestID,
SSelected = false,
SDelete = false
};
entry.Ssex = "";
if ((int)item.Sex == 2)
{
entry.Ssex = "[F]";
}
if (item.GuestID == 0)
{
entry.SGuest = 0;
}
else
{
// MRParams param = db.MRParams.FirstOrDefault(p => p.Key == keyPlayers);
Guest guest = db.Guest.FirstOrDefault(g => g.GuestID == item.GuestID);
entry.SGuestName = guest.GuestName;
entry.SgHcp = guest.gHcp;
entry.SgSex = "";
if (guest.gSex == 2)
{
entry.SgSex = "[F]";
}
}
target.entries.Add(entry);
}
return(target);
}
public void ShowPlayersListDB()
{
this.sl = SignupList.LoadPlayersListDB();
this.PlayersListRepeater.DataSource = new SignupList[] { this.sl };
this.PlayersListRepeater.DataBind();
// int dbCount = this.sl.Entries.Count;
// DBCount = dbCount==0 ? "No": dbCount.ToString();
DBCount = this.sl.Entries.Count;
}
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;
}
protected void LoadButton_Click(object sender, EventArgs e)
{
string eid = DropDownList1.SelectedValue;
ShowEvent(eid);
// sourceTo.Text = "*****@*****.**";
// sourceFrom.Text = "*****@*****.**";
sourceSubject.Text = literalOrg.Text + " Player's List for MISGA Mixer on " + evDate;
this.sl = SignupList.LoadFromPlayersListDB(eid); // load Signup entries from PlayersLists for the selected Event ID
this.PlayersListRepeater.DataSource = new SignupList[] { this.sl };
this.PlayersListRepeater.DataBind();
playerCount = sl.Entries.Count;
lblCount.Text = "Player Limit = " + evPlayerLimit.ToString("##0") + ": ";
if (sl.Entries.Count == 1)
{
lblCount.Text += "There is 1 player for this event.";
}
else
{
if (sl.Entries.Count == 0)
{
lblCount.Text += "There are no players for this event.";
}
else
{
lblCount.Text += string.Format("There are {0} players for this event.", sl.Entries.Count.ToString());
}
}
LoadEmailBody(eid);
ShowControls(true);
}
protected void Page_Load(object sender, EventArgs e)
{
lblMarkedCount.Text = String.Format("There are {0:##,##0} marked records in the Signup (PlayersList) Database.", SignupList.MarkedEntryCount());
}
protected void btnClear_Click(object sender, EventArgs e)
{
SignupList.PurgeMarkedEntries();
lblPurgeCount.Text = "Entries purged = " + SignupList.EntriesPurged.ToString("##,##0");
}
