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