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