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