Example #1
0
        protected void wizAddReservation_NextButtonClick(object sender, WizardNavigationEventArgs e)
        {
            if (wizAddReservation.ActiveStepIndex == 0) //Checks to make sure that the current step is the first step
            {
                //ClubBaistSystem system = new ClubBaistSystem();

                loc = system.GetHours(Convert.ToInt16(ddlLocations.Text), DateTime.Now); //loc now contains location hours and any althours

                //Now need to get any current reservations
                reservationList = new List <Reservation>();
                reservationList = system.GetReservations(Convert.ToInt16(ddlLocations.Text), DateTime.Now);

                //Use that data to fill the calendar control and drop down control
                GenerateDisabledDays();
            }
        }
        public void SearchRes()
        {
            OutputTable.Rows.Clear();
            List <int> reserveIDs = new List <int>();

            ddlReservations.DataSource = reserveIDs;
            ddlReservations.DataBind();
            ClubBaistSystem system            = new ClubBaistSystem();
            DataTable       ReservationsTable = system.GetReservations(tbUser.Text, Convert.ToInt16(ddlLocations.SelectedValue), calStartDate.SelectedDate, calEndDate.SelectedDate);

            TableHeaderRow  headRow  = new TableHeaderRow();
            TableHeaderCell headCell = new TableHeaderCell();
            TableRow        row      = new TableRow();
            TableCell       cell     = new TableCell();

            for (int y = 0; y < ReservationsTable.Rows.Count; y++)
            {
                row = new TableRow();
                for (int x = 0; x < ReservationsTable.Columns.Count; x++)
                {
                    cell = new TableCell();
                    if (OutputTable.Rows.Count == 0)
                    {
                        headCell      = new TableHeaderCell();
                        headCell.Text = ReservationsTable.Columns[x].ToString();
                        headRow.Cells.Add(headCell);
                    }
                    cell.Text = ReservationsTable.Rows[y][x].ToString();
                    try
                    {
                        if (x == 0)                                     //Make sure to look at the first column only
                        {
                            reserveIDs.Add(Convert.ToInt32(cell.Text)); //This will throw an exception on the header row, so we try catch all
                        }
                    }
                    catch { }
                    row.Cells.Add(cell);
                }

                if (OutputTable.Rows.Count == 0)
                {
                    OutputTable.Rows.Add(headRow);
                }

                OutputTable.Rows.Add(row);
            }
            ddlReservations.DataSource = reserveIDs;
            ddlReservations.DataBind();
            labReservationID.Visible     = true;
            ddlReservations.Visible      = true;
            butDelete.Visible            = true;
            wizSearchReservation.Visible = false;
        }
Example #3
0
        public void SearchRes()
        {
            OutputTable.Rows.Clear();
            ClubBaistSystem system            = new ClubBaistSystem();
            DataTable       ReservationsTable = system.GetReservations(tbUser.Text, Convert.ToInt16(ddlLocations.SelectedValue), calStartDate.SelectedDate, calEndDate.SelectedDate);

            TableHeaderRow  headRow  = new TableHeaderRow();
            TableHeaderCell headCell = new TableHeaderCell();
            TableRow        row      = new TableRow();
            TableCell       cell     = new TableCell();

            for (int y = 0; y < ReservationsTable.Rows.Count; y++)
            {
                row = new TableRow();
                for (int x = 0; x < ReservationsTable.Columns.Count; x++)
                {
                    cell = new TableCell();
                    if (OutputTable.Rows.Count == 0)
                    {
                        headCell      = new TableHeaderCell();
                        headCell.Text = ReservationsTable.Columns[x].ToString();
                        headRow.Cells.Add(headCell);
                    }
                    cell.Text = ReservationsTable.Rows[y][x].ToString();
                    row.Cells.Add(cell);
                }

                if (OutputTable.Rows.Count == 0)
                {
                    OutputTable.Rows.Add(headRow);
                }
                OutputTable.Rows.Add(row);
            }

            if (OutputTable.Rows.Count <= 0)
            {
                labMessage.ForeColor = System.Drawing.Color.Red;
                labMessage.Text      = "No Reservations found for that time period!";
            }
        }