public static int GetPlayerID(string lName, string fName, int sex)
{
keyName = Proper(lName.Trim()) + ", " + Proper(fName.Trim());
MrTimeZone tz = new MrTimeZone();
int pid = 0;
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
var query =
from p in db.Players
where p.Name == keyName
select p;
Players player = query.FirstOrDefault(); // Lookup Player in Players Datbase
if (player != null)
{
pid = player.PlayerID;
}
else
{
Players pl = new Players()
{
Name = keyName,
LName = Proper(lName.Trim()),
FName = Proper(fName.Trim()),
Hcp = "NONE",
MemberID = "",
Sex = sex,
Title = "",
HDate = tz.eastTimeNow(),
Delete = 0
};
MRParams param = db.MRParams.FirstOrDefault(p => p.Key == keyPlayers);
if (param != null)
{
pid = Convert.ToInt32(param.Value);
pid += 1;
pl.PlayerID = pid;
db.Players.InsertOnSubmit(pl);
param.Value = pid.ToString();
param.ChangeDate = tz.eastTimeNow();
}
else
{
MRParams par = new MRParams();
par.Key = keyPlayers;
par.Value = "1";
par.ChangeDate = tz.eastTimeNow();
db.MRParams.InsertOnSubmit(par);
pid = 1;
pl.PlayerID = pid;
db.Players.InsertOnSubmit(pl);
}
}
db.SubmitChanges();
return(pid);
}
protected void loadLastDate()
{
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MRParams entry = db.MRParams.FirstOrDefault(p => p.Key.Trim() == keyLastDate);
if (entry != null)
{
LastDate = Convert.ToDateTime((string)entry.Value);
changeDate = (DateTime)entry.ChangeDate;
}
else
{
int curyear = etz.eastTimeNow().Year;
LastDate = new DateTime(curyear, 3, 1, 23, 59, 59, System.Globalization.CultureInfo.InvariantCulture.Calendar);
changeDate = etz.eastTimeNow();
MRParams newParm = new MRParams();
newParm.Key = keyLastDate;
newParm.Value = LastDate.ToString();
newParm.ChangeDate = changeDate;
db.MRParams.InsertOnSubmit(newParm);
db.SubmitChanges();
}
lblDateLastChanged.Text = "Date Last Changed: " + changeDate.ToString();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
lblUpdateCount.Text = " ";
lblUpdateCount.ForeColor = System.Drawing.Color.Green;
// load handicaps.txt file from host server in handicap list
int updateCount = 0;
int countOfPlayers = 0;
// MrResources mr = new MrResources();
// path = Server.MapPath(mr.Root);
try
{
hcpDate = Convert.ToDateTime(tbHcpDate.Text);
List <Handicap> hc = Handicap.LoadHandicaps(filename, hcpDate);
// update sql Players with handicaps from text file
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MRParams entry = db.MRParams.FirstOrDefault(p => p.Key == "Players");
if (entry == null)
{
PlayersCount = 0;
}
else
{
PlayersCount = Convert.ToInt32(entry.Value);
for (int i = 0; i <= PlayersCount; ++i)
{
var m = db.Players.FirstOrDefault(h => h.PlayerID == i);
if (m != null)
{
countOfPlayers++;
foreach (var hcp in hc)
{
if (m.MemberID.Trim() == hcp.ID.Trim())
{
m.Hcp = hcp.Index;
m.HDate = hcp.Date;
db.SubmitChanges();
updateCount++;
}
}
}
}
}
ShowMembers();
lblUpdateCount.Text = string.Format("{0} of {1} Handicaps Updated", updateCount, countOfPlayers);
}
catch (FormatException)
{
lblUpdateCount.Text = "Invalid Handicap Date";
lblUpdateCount.ForeColor = System.Drawing.Color.Red;
}
}
protected void deleteParam(string k)
{
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MRParams rec = db.MRParams.FirstOrDefault(c => c.Key == k);
if (rec != null)
{
db.MRParams.DeleteOnSubmit(rec);
}
db.SubmitChanges();
}
protected void AddParameter(string key, string value)
{
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MRParams prm = new MRParams();
prm.Key = key;
prm.Value = value;
prm.ChangeDate = new MrTimeZone().eastTimeNow();
db.MRParams.InsertOnSubmit(prm);
db.SubmitChanges();
}
public DateTime getDisplayDate()
{
MrTimeZone ETZ = new MrTimeZone();
sysToday = ETZ.eastTimeNow();
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MRParams entry = db.MRParams.FirstOrDefault(p => p.Key == keyLastDate);
if (entry != null)
{
LastDate = Convert.ToDateTime((string)entry.Value);
changeDate = (DateTime)entry.ChangeDate;
}
else
{
LastDate = new DateTime(2012, 4, 12, 23, 59, 59, System.Globalization.CultureInfo.InvariantCulture.Calendar);
changeDate = ETZ.eastTimeNow();
MRParams newParm = new MRParams();
newParm.Key = keyLastDate;
newParm.Value = LastDate.ToString();
newParm.ChangeDate = changeDate;
db.MRParams.InsertOnSubmit(newParm);
db.SubmitChanges();
}
MRParams edts = db.MRParams.FirstOrDefault(p => p.Key == keyDaysToShow);
daysToShow = defaultDisplayDays;
if (edts != null)
{
daysToShow = Convert.ToInt32((string)edts.Value);
}
else
{
changeDate = ETZ.eastTimeNow();
MRParams newParm = new MRParams();
newParm.Key = keyDaysToShow;
newParm.Value = daysToShow.ToString();
newParm.ChangeDate = changeDate;
db.MRParams.InsertOnSubmit(newParm);
db.SubmitChanges();
}
displayDate = ETZ.eastTimeNow().AddDays(daysToShow);
if (LastDate < displayDate)
{
displayDate = LastDate;
}
return(displayDate);
}
protected static bool IsSignupAllowed(MRParams p)
{
if (p == null)
{
return(true); // Allowed if nothing in MRParams file
}
if (p.Value.ToUpper() == "YES")
{
return(true); // Allowed if YES
}
if ((p.Value.Length > 5) && (p.Value.Substring(0, 6).ToUpper() == "ENABLE"))
{
return(true);
}
return(false); // disallow if anything else
}
protected void updateParams()
{
DateTime lDate = Convert.ToDateTime(newLastDate);
LastDate = new DateTime(lDate.Year, lDate.Month, lDate.Day, 23, 59, 59);
// MrTimeZone tmz = new MrTimeZone();
DateTime fDate = Convert.ToDateTime(newFirstDate);
FirstDate = new DateTime(fDate.Year, fDate.Month, fDate.Day, 0, 0, 1);
changeDate = etz.eastTimeNow();
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MRParams param = db.MRParams.FirstOrDefault(p => p.Key == keyLastDate);
if (param != null)
{
param.Value = (string)LastDate.ToString();
param.ChangeDate = changeDate;
}
else
{
MRParams newParam = new MRParams();
newParam.Key = keyLastDate;
newParam.Value = (string)LastDate.ToString();
newParam.ChangeDate = changeDate;
db.MRParams.InsertOnSubmit(newParam);
}
MRParams xparam = db.MRParams.FirstOrDefault(p => p.Key.Trim() == keyFirstDate);
if (xparam != null)
{
xparam.Value = (string)FirstDate.ToString();
xparam.ChangeDate = changeDate;
}
else
{
MRParams newParam = new MRParams();
newParam.Key = keyFirstDate;
newParam.Value = (string)FirstDate.ToString();
newParam.ChangeDate = changeDate;
db.MRParams.InsertOnSubmit(newParam);
}
db.SubmitChanges();
lblDateChanged.Text = "Last Date Changed Successfully: " + changeDate.ToString();
}
protected bool loadDDL()
{
string closed = "";
string keyLastDate = "LastDate";
string keyShowDays = "DaysToShow";
int daysToShow;
MrTimeZone etz = new MrTimeZone();
DateTime date1 = new DateTime(2012, 1, 8, 0, 0, 0);
DateTime date2 = new DateTime(2012, 1, 1, 0, 0, 0);
TimeSpan oneWeek = date1.Subtract(date2);
DateTime nowDate = etz.eastTimeNow();
DateTime startDate = nowDate; // .Subtract(oneWeek);
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MRParams dts = db.MRParams.FirstOrDefault(p => p.Key == keyShowDays);
daysToShow = 365;
if (ConfigurationManager.AppSettings[keyShowDays] != null)
{
daysToShow = Convert.ToInt32(ConfigurationManager.AppSettings[keyShowDays]);
}
if (dts != null)
{
daysToShow = Convert.ToInt32((string)dts.Value);
}
DateTime endDate = nowDate.AddDays(daysToShow);
DateTime lastDate = endDate;
MRParams entry = db.MRParams.FirstOrDefault(p => p.Key == keyLastDate);
if (entry != null)
{
lastDate = Convert.ToDateTime((string)entry.Value);
}
if (lastDate < endDate)
{
endDate = lastDate;
}
var query =
(from ev in db.Events
// join pl in db.PlayersList on ev.EventID equals pl.EventID
// (from pl in db.PlayersList
// join ev in db.Events on pl.EventID equals ev.EventID
// where (pl.Marked == 0)
where ((ev.Date > startDate) && (ev.Date < endDate))
orderby ev.EventID
select new { ev.EventID, ev.Date, ev.Type, ev.Title, ev.Deadline }).Distinct();
foreach (var item in query)
{
closed = "";
if (item.Type.Trim() != "MISGA")
{
if (item.Deadline <= nowDate)
{
closed = " | CLOSED ";
}
string tx = item.EventID.Trim() + " | " + item.Date.ToShortDateString() + " | " + item.Type.Trim() + " | " + item.Title.Trim() + closed;
DropDownList1.Items.Add(new ListItem(tx, item.EventID));
}
}
return(DropDownList1.Items.Count > 0);
}
protected void Page_Load(object sender, EventArgs e)
{
eventID = Request.QueryString["ID"];
litOrg1.Text = ConfigurationManager.AppSettings["Org"];
litOrg2.Text = ConfigurationManager.AppSettings["Org"];
offset = ConfigurationManager.AppSettings["SignupOffset"];
IsAccessControlOn = false;
if ((ConfigurationManager.AppSettings["AccessControl"] != null) &&
(ConfigurationManager.AppSettings["AccessControl"].ToLower().Trim() == "on"))
{
IsAccessControlOn = true;
}
if (!IsAccessControlOn)
{
lblAccessCode.Visible = false;
tbAccessCode.Visible = false;
}
signupOffset = 0;
if (offset != null)
{
if (offset.Trim() != "")
{
signupOffset = Convert.ToInt32(offset);
}
}
MrTimeZone tz = new MrTimeZone();
deadline = tz.eastTimeNow();
postDate = tz.eastTimeNow();
playerLimit = 1;
hostClubPhone = "";
// linkbuttonSR.Visible = false;
enableSignups = false;
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MRParams param = db.MRParams.FirstOrDefault(p => p.Key == keySignups);
if (IsSignupAllowed(param))
{
enableSignups = true;
}
if (!IsPostBack)
{
NormalPanel.Visible = true;
SignupPanel.Visible = true;
ClosedPanel.Visible = false;
GuestListPanel.Visible = false;
SpecialRulePanel.Visible = false;
GuestOption = false;
// cbSpecialRule.Checked = false;
SRCBLPanel.Visible = false;
SRCBKL.Visible = false;
SRCBKL.Items.Clear();
cbGuestRule.Checked = false;
tbGFN.Text = "";
tbGLN.Text = "";
tbGHcp.Text = "";
GetCookieUserInfo();
}
var mixer = db.Events.FirstOrDefault(ev => ev.EventID == eventID);
if (mixer != null)
{
if (mixer.Type.Trim() == "Home")
{
Page.Title = string.Format("{0} {1} Sign-up", mixer.Date.ToString("MMM d"), ConfigurationManager.AppSettings["Org"]);
}
else
{
Page.Title = string.Format("{0} {1} Sign-up", mixer.Date.ToString("MMM d"), mixer.Title);
}
deadline = mixer.Deadline;
playerLimit = mixer.PlayerLimit;
hostClubPhone = GetHostPhone(mixer.HostID);
postDate = mixer.PostDate;
if (playerLimit == maxLimit)
{
lblPlayerLimit.Text = "(Player Limit: Unlimited)";
}
else
{
lblPlayerLimit.Text = "(Player Limit: " + playerLimit.ToString("##0") + "*)";
}
if (mixer.SpecialRule != null)
{
sRule = mixer.SpecialRule.Trim();
sRuleChoices = sRule.Split(delimiterChars);
}
if ((mixer.Guest != null) && (mixer.Guest.Trim()) == Guest)
{
GuestOption = true;;
}
}
postDate = tz.eastTimeNow().AddDays(-signupOffset); // temporary for testing
enableSignups = (tz.eastTimeNow() >= postDate) && enableSignups;
//
// load mixer details from text file
//
path = Server.MapPath("");
MrLoadMixerInfo mixerInfo = new MrLoadMixerInfo(path, eventID);
LoadMixerInfo(mixerInfo.MixerLines());
btnSubmit.Enabled = mixerInfo.PageFileExists;
lblEventID.Text = eventID;
//
// Get the mixer from the events db
//
MRParams entry = db.MRParams.FirstOrDefault(p => p.Key == keySignupLimit);
if (entry != null)
{
maxLimit = Convert.ToInt32((string)entry.Value);
}
getPlayersList(eventID);
//
// Check for deadline already passed
//
if (MrSignup.IsClosed(deadline))
{
// Deadline is in the past }
lblClosed.Text = @"<span class=""closed"">Contact ";
// lblSignupForm.Text += "the<br />Host Club at<br />";
// lblSignupForm.Text += hostClubPhone;
// lblClosed.Text += "your <br />MISGA Rep, <br >";
lblClosed.Text += ConfigurationManager.AppSettings["Contact"] + " at<br />";
string cp = ConfigurationManager.AppSettings["ContactPhone"];
if (cp == "")
{
cp = hostClubPhone;
}
lblClosed.Text += cp;
lblClosed.Text += "<br />to see if you can be added to the list.</span>";
/* rblAction.Items[0].Selected = false;
* rblAction.Items[1].Selected = true;
* rblAction.Items[0].Enabled = false;
* rblAction.Items[1].Enabled = true;
* */
SignupPanel.Visible = false;
ClosedPanel.Visible = true;
ClosedMessagePanel.Visible = true;
tblGenderPool.Visible = false;
rblAction.Visible = false;
cbCarpool.Visible = false;
lblgender.Visible = false;
rblgender.Visible = false;
PlayerPanel.Visible = false;
// lblFN.Visible = false;
// lblLN.Visible = false;
// FirstNameTextBox.Visible = false;
// LastNameTextBox.Visible = false;
// cbCarpool.Visible = false;
// LinkButton1.Visible = false;
SpecialRulePanel.Visible = false;
SRCBLPanel.Visible = false;
SRCBKL.Visible = false;
SRCBKL.Items.Clear();
linkbuttonSR.Visible = false;
cbGuestRule.Visible = false;
// cbSpecialRule.Visible = false;
GuestPanel.Visible = false;
if (GuestOption)
{
GuestListPanel.Visible = true;
NormalPanel.Visible = false;
}
enableSignups = false;
}
else
{
// enable signup page to accomodate special rule
if (!IsPostBack)
{
if ((sRuleChoices.Length > 0) && (sRuleChoices[0] != ""))
{
SRCBKL.Items.Add("Default");
foreach (string choice in sRuleChoices)
{
if (choice != "")
{
SRCBKL.Items.Add(choice);
}
}
srCount = 0;
if (SRCBKL.Items.Count > 0)
{
SpecialRulePanel.Visible = true;
linkbuttonSR.Visible = true;
SRCBKL.Visible = true;
SRCBLPanel.Visible = true;
prevSRSelection = -1;
prevSRItem = "";
}
}
}
/* if (sRule != "")
* {
* cbSpecialRule.Text = sRule;
* SpecialRulePanel.Visible = true;
* cbSpecialRule.Visible = true;
* linkbuttonSR.Visible = true;
*
* } */
if (GuestOption)
{
SpecialRulePanel.Visible = true;
cbGuestRule.Text = "Partner";
cbGuestRule.Visible = true;
GuestPanel.Visible = true;
GuestListPanel.Visible = true;
NormalPanel.Visible = false;
}
}
btnSubmit.Enabled = (mixerInfo.PageFileExists && enableSignups);
SubmitPanel.Visible = (mixerInfo.PageFileExists && enableSignups);
// btnSubmit.Enabled = (mixerInfo.PageFileExists);
}
public static MrSchedule LoadFromCsv(string fileName)
{
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MRParams item = db.MRParams.FirstOrDefault(p => p.Key == keyMinDate);
if ((item == null))
{
MinDate = new DateTime(2000, 1, 1, 1, 0, 0);
}
else
{
MinDate = Convert.ToDateTime(item.Value);
}
MrSchedule target = new MrSchedule();
target.FileName = fileName;
target.CreateTime = System.IO.File.GetLastWriteTime(fileName);
string[] lines = System.IO.File.ReadAllLines(fileName);
foreach (String line in lines)
{
if (line.Trim() == "")
{
// Ignore this line
}
else if (line.Substring(0, 1) == "/")
{
// Ignore comment line
}
else
{
string[] fields = line.Split(delimiterChars);
if (fields.Length != 12)
// if (fields.Length != 11)
{
throw new InvalidOperationException("DERP: Incorrect number of fields in schedule.txt");
}
SysEvent e = new SysEvent()
{
Id = fields[0],
EDate = Convert.ToDateTime(fields[1]),
EType = fields[2],
ETitle = fields[3],
ECost = fields[4],
ETime = fields[5],
EDeadline = Convert.ToDateTime(fields[6]),
EHostPhone = fields[7],
ESpecialRule = fields[9],
EGuest = fields[10],
EHostID = fields[0].Substring(11, 3)
};
if (string.IsNullOrEmpty(fields[11]))
{
e.EPostDate = MinDate;
}
else
{
e.EPostDate = Convert.ToDateTime(fields[11]);
}
if (fields[8] == "")
{
e.EPlayerLimit = 6;
}
else
{
e.EPlayerLimit = Convert.ToInt32(fields[8]);
}
target.Events.Add(e);
Events ev = db.Events.FirstOrDefault(p => p.EventID == e.Id);
if (ev == null)
{
Events newEvent = new Events()
{
EventID = e.Id,
Date = e.EDate,
Type = e.EType,
Title = e.ETitle,
Cost = e.ECost,
Time = e.ETime,
Deadline = e.EDeadline,
HostID = e.EHostID,
SpecialRule = e.ESpecialRule,
PlayerLimit = e.EPlayerLimit,
Guest = e.EGuest,
HostPhone = e.EHostPhone,
PostDate = e.EPostDate
};
db.Events.InsertOnSubmit(newEvent);
}
else
{
ev.Date = e.EDate;
ev.Type = e.EType;
ev.Title = e.ETitle;
ev.Cost = e.ECost;
ev.Time = e.ETime;
ev.Deadline = e.EDeadline;
ev.HostID = e.EHostID;
ev.Guest = e.EGuest;
ev.PlayerLimit = e.EPlayerLimit;
ev.SpecialRule = e.ESpecialRule;
ev.HostPhone = e.EHostPhone;
ev.PostDate = e.EPostDate;
}
db.SubmitChanges();
}
}
return(target);
}
