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"); }