private void ListScores(List <Score> userScores) { ClubBAIST cb = new ClubBAIST(); foreach (Score sc in userScores) { Reservation r = cb.ReadReservation(sc.ReservationID); Course course = cb.ReadCourse(r.CourseID); //use sc to get score info, total score TableRow tr = new TableRow(); TableCell c = new TableCell(); c.Text = cb.MakeHumanFriendlyDate(r.ReservedTime); tr.Cells.Add(c); c = new TableCell(); c.Text = r.ReservedTime.TimeOfDay.ToString(); tr.Cells.Add(c); c = new TableCell(); c.Text = course.CourseName; tr.Cells.Add(c); c = new TableCell(); c.Text = sc.RoundTotal.ToString(); tr.Cells.Add(c); c = new TableCell(); c.Text = sc.HandicapDifferential.ToString(); tr.Cells.Add(c); ScoresTable.Rows.Add(tr); //button to view whole score breakdown? } }
private void FillForm() { ClubBAIST cb = new ClubBAIST(); Reservation r = cb.ReadReservation(int.Parse(Request.QueryString["r"])); Calendar.SelectedDate = r.ReservedTime.Date; NumberHolesDD.SelectedValue = r.NumberHoles.ToString(); NumberCartsDD.SelectedValue = r.NumberCarts.ToString(); CourseDD.SelectedValue = r.CourseID.ToString(); Player2TB.Text = r.Player2; Player3TB.Text = r.Player3; Player4TB.Text = r.Player4; }
protected void SubmitButton_Click(object sender, EventArgs e) { ClubBAIST cb = new ClubBAIST(); Reservation r = cb.ReadReservation(int.Parse(Request.QueryString["r"])); bool b = cb.UpdateReservation(int.Parse(Request.QueryString["r"]), r.UserID, int.Parse(CourseDD.SelectedValue), DateTime.Parse(TeeTimesDD.SelectedValue), int.Parse(NumberHolesDD.SelectedValue), int.Parse(NumberCartsDD.SelectedValue), Player2TB.Text, Player3TB.Text, Player4TB.Text); if (!b) { //Response.Write("Something went wrong."); } else { Response.Redirect("ViewReservations.aspx?r=" + r.UserID); } }
private void AdminStuff() { ClubBAIST cb = new ClubBAIST(); if (Request.QueryString["u"] != null) { PageControls.Controls.Remove(SelectUserTable); User u = cb.ReadUserByID(int.Parse(Request.QueryString["u"])); ListReservationsForUser(u.UserID); } else { if (Request.QueryString["r"] != null) { //fill UsersOnReservationDD with players on the reservation Reservation r = cb.ReadReservation(int.Parse(Request.QueryString["r"])); User u = cb.ReadUserByID(r.UserID); ListItem li = new ListItem(); li.Text = u.FirstName + " " + u.LastName; li.Value = u.Email; UsersOnReservationDD.Items.Add(li); if (r.Player2 != null && r.Player2.Trim() != "") { u = cb.ReadUser(r.Player2); li = new ListItem(); li.Text = u.FirstName + " " + u.LastName; li.Value = u.Email; UsersOnReservationDD.Items.Add(li); } if (r.Player3 != null && r.Player3.Trim() != "") { u = cb.ReadUser(r.Player3); li = new ListItem(); li.Text = u.FirstName + " " + u.LastName; li.Value = u.Email; UsersOnReservationDD.Items.Add(li); } if (r.Player4 != null && r.Player4.Trim() != "") { u = cb.ReadUser(r.Player4); li = new ListItem(); li.Text = u.FirstName + " " + u.LastName; li.Value = u.Email; UsersOnReservationDD.Items.Add(li); } } } }
private bool ScoreExists(string email) { ClubBAIST cb = new ClubBAIST(); Reservation r = cb.ReadReservation(int.Parse(Request.QueryString["r"])); User u = cb.ReadUser(email); bool exists = false; if (u.Email != null) { List <Score> scoresForThisReservation = cb.ReadScoresForReservation(r.ReservationID); foreach (Score s in scoresForThisReservation) { if (s.UserEmail == u.Email || s.UserEmail == r.Player2 || s.UserEmail == r.Player3 || s.UserEmail == r.Player4) { exists = true; } } } return(exists); }
private void NotAdminStuff() { PageControls.Controls.Remove(FoundUsersTableLabel); PageControls.Controls.Remove(FoundUsersTable); PageControls.Controls.Remove(SearchTable); PageControls.Controls.Remove(SelectUserTable); ClubBAIST cb = new ClubBAIST(); User u = cb.ReadUser(HttpContext.Current.User.Identity.Name); if (Request.QueryString["r"] != null) { Reservation r = cb.ReadReservation(int.Parse(Request.QueryString["r"])); if (u.UserID != r.UserID && u.Email != r.Player2 && u.Email != r.Player3 && u.Email != r.Player4) { Response.Redirect("SubmitScore.aspx"); } } else { ListReservationsForUser(u.UserID); } }
protected void DaySelected(object sender, EventArgs e) { DateTime selectedDay = Calendar.SelectedDate; ClubBAIST cb = new ClubBAIST(); Reservation thisR = cb.ReadReservation(int.Parse(Request.QueryString["r"])); List <Reservation> TeeTimesForDay = cb.ReadReservationBatchByTimeFrame(selectedDay, selectedDay.AddDays(1)); TeeTimesDD.Items.Clear(); DateTime bufferDateTime = selectedDay.AddHours(7.00); bool offset = true; while (bufferDateTime <= selectedDay.AddHours(18)) { ListItem li = new ListItem(); li.Text = bufferDateTime.TimeOfDay.ToString(); li.Value = MakeFormattedDate(bufferDateTime); foreach (Reservation r in TeeTimesForDay) { if (r.ReservedTime == bufferDateTime && r.ReservationID != thisR.ReservationID) { li.Attributes.Add("disabled", "true"); } } TeeTimesDD.Items.Add(li); if (offset) { bufferDateTime = bufferDateTime.AddMinutes(7.00); offset = false; } else { bufferDateTime = bufferDateTime.AddMinutes(8.00); offset = true; } } TeeTimesDD.SelectedValue = MakeFormattedDate(thisR.ReservedTime); }
protected void Page_Load(object sender, EventArgs e) { Authenticate(); MessageBox.Visible = false; ClubBAIST cb = new ClubBAIST(); if (Request.QueryString["r"] != null) { if (ScoreExists(HttpContext.Current.User.Identity.Name)) { MessageBox.Visible = true; } else { MessageBox.Visible = false; } int reservationID = int.Parse(Request.QueryString["r"]); Reservation r = cb.ReadReservation(reservationID); User u = cb.ReadUserByID(r.UserID); Course c = cb.ReadCourse(r.CourseID); TableRow row = new TableRow(); TableCell cell = new TableCell(); cell.Text = r.ReservedTime.ToString(); row.Cells.Add(cell); cell = new TableCell(); cell.Text = u.FirstName + " " + u.LastName; if (ScoreExists(u.Email)) { cell.Attributes.Add("style", "background-color:#a0ff6d;"); } row.Cells.Add(cell); cell = new TableCell(); cell.Text = c.CourseName.ToString(); row.Cells.Add(cell); cell = new TableCell(); cell.Text = r.NumberCarts.ToString(); row.Cells.Add(cell); cell = new TableCell(); cell.Text = cb.GetHolesReservationDescription(r.NumberHoles); row.Cells.Add(cell); cell = new TableCell(); cell.Text = String.Format(r.Player2); if (r.Player2.Trim() != "" && r.Player2 != null) { if (ScoreExists(r.Player2)) { cell.Attributes.Add("style", "background-color:#a0ff6d;"); } } row.Cells.Add(cell); cell = new TableCell(); cell.Text = String.Format(r.Player3); if (r.Player3.Trim() != "" && r.Player3 != null) { if (ScoreExists(r.Player3)) { cell.Attributes.Add("style", "background-color:#a0ff6d;"); } } row.Cells.Add(cell); cell = new TableCell(); cell.Text = String.Format(r.Player4); if (r.Player4.Trim() != "" && r.Player4 != null) { if (ScoreExists(r.Player2)) { cell.Attributes.Add("style", "background-color:#a0ff6d;"); } } row.Cells.Add(cell); ThisReservation.Rows.Add(row); PageControls.Controls.Remove(FoundUsersTable); PageControls.Controls.Remove(FoundUsersTableLabel); PageControls.Controls.Remove(ReservationsTable); PageControls.Controls.Remove(ReservationsTableLabel); PageControls.Controls.Remove(FoundUsersTableLabel); PageControls.Controls.Remove(FoundUsersTable); PageControls.Controls.Remove(SearchTable); DisableUnusedHoles(r.NumberHoles); } else { PageControls.Controls.Remove(ThisReservation); PageControls.Controls.Remove(ThisReservationTableLabel); PageControls.Controls.Remove(HoleScoresTableLabel); PageControls.Controls.Remove(HoleScoresTable); PageControls.Controls.Remove(SubmitButton); SelectUserTable.Visible = false; if (Request.QueryString["u"] != null) { FoundUsersTableLabel.Visible = false; } else { ReservationsTableLabel.Visible = false; } } }