protected void SaveBtn_Click(object sender, EventArgs e)
        {
            bool isOK = true;

            if (string.IsNullOrEmpty(DateTextBox.Text)) isOK = false;
            if (string.IsNullOrEmpty(StartTimeTextBox.Text)) isOK = false;
            if (string.IsNullOrEmpty(FinishTimeTextBox.Text)) isOK = false;
            if (string.IsNullOrEmpty(NoCastCrewTextBox.Text)) isOK = false;
            if (string.IsNullOrEmpty(AgreedDayRateTextBox.Text)) isOK = false;
            //         if (string.IsNullOrEmpty(NotesTextBox.Text)) isOK = false;
               //         if (string.IsNullOrEmpty(BookingDateID.Value)) isOK = false;
               //         if (string.IsNullOrEmpty(BookingID.Value)) isOK = false;

            UK_Film_Location_Class.BookingDates objDate = new UK_Film_Location_Class.BookingDates();

            if (isOK)
            {
                if (!string.IsNullOrEmpty(BookingDateID.Value))
                {
                    objDate.getBookedDate(BookingDateID.Value);
                }

                objDate.BookingID = BookingID.Value;
                objDate.BookingDate = DateTime.Parse( DateTextBox.Text);
                objDate.StartTime = StartTimeTextBox.Text;
                objDate.EndTime = FinishTimeTextBox.Text;
                objDate.Notes = NotesTextBox.Text;
                objDate.NoCrew = Convert.ToInt32(NoCastCrewTextBox.Text);
                objDate.AgreedDayRate = double.Parse(AgreedDayRateTextBox.Text);

                objDate.Save();

                Response.Redirect("/BookLocation.aspx?BookingID=" + objDate.BookingID);
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                UK_Film_Location_Class.BookingDetails objBooking = new UK_Film_Location_Class.BookingDetails();
                UK_Film_Location_Class.BookingDates objDate = new UK_Film_Location_Class.BookingDates();

                UK_Film_Location_Class.OpportunityDetails objOpportunity = new UK_Film_Location_Class.OpportunityDetails();
                UK_Film_Location_Class.ProjectDetails objProject = new UK_Film_Location_Class.ProjectDetails();

                objBooking.BookingID = Request.QueryString["BookingID"];
                objDate.BookingDateID = Request.QueryString["BookingDateID"];

                BookingID.Value = objBooking.BookingID;
                objDate.BookingID = objBooking.BookingID;

                if (!string.IsNullOrEmpty(objDate.BookingDateID))
                {
                    objDate.getBookedDate(objDate.BookingDateID);
                    BookingDateID.Value = objDate.BookingDateID;
                    BookingID.Value = objDate.BookingID;
                }
                else
                {
                    objBooking.getBooking(objBooking.BookingID);
                    objOpportunity.getOpportunity(objBooking.OpportunityID);
                    objProject.getProjectDetails(objOpportunity.ProjectID);

                    objDate.BookingDate = DateTime.Now;
                    objDate.StartTime = "09:00";
                    objDate.EndTime = "17:00";

                    objDate.AgreedDayRate = objOpportunity.LocationRate;
                    try
                    {
                        objDate.NoCrew = Convert.ToInt32(objOpportunity.NoCrew);
                    }
                    catch
                    {
                    }
                }

              //          ErrorLabel.Text = "BookingID : " + BookingID.Value;

                DateTextBox.Text = objDate.BookingDate.ToShortDateString();
                StartTimeTextBox.Text = objDate.StartTime;
                FinishTimeTextBox.Text = objDate.EndTime;
                NotesTextBox.Text = objDate.Notes;
                DateTextBox.Text = UK_Film_Location_Class.UKFilmLocation.makeSQLShortDate(objDate.BookingDate.ToString());
                NoCastCrewTextBox.Text = objDate.NoCrew.ToString();
                AgreedDayRateTextBox.Text = objDate.AgreedDayRate.ToString("0.00");
            }
        }
        protected void SaveBtn_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(StartDateTextBox.Text) && !string.IsNullOrEmpty(NoDaysTextBox.Text) && !string.IsNullOrEmpty(StartTimeTextBox.Text) && !string.IsNullOrEmpty(FinishTimeTextBox.Text))
            {

                string UserEmail = "";

                HttpCookie myTestCookie = new HttpCookie("UKFilmLocationAdmin");
                myTestCookie = Request.Cookies["UKFilmLocationAdmin"];

                // Read the cookie information and display it.
                if (myTestCookie != null)
                {
                    // User details collected

                    UserEmail = myTestCookie.Value;

                }

                UK_Film_Location_Class.UserDetails objUser = new UK_Film_Location_Class.UserDetails();

                objUser.getUserFromEmail(UserEmail);

                // Save Booking Data

                UK_Film_Location_Class.BookingDetails objBooking = new UK_Film_Location_Class.BookingDetails();

                if (!string.IsNullOrEmpty(BookingID.Value))
                {
                    objBooking.getBooking(BookingID.Value);
                }
                else
                {
                    objBooking.DateBooked = DateTime.Now;
                    objBooking.OpportunityID = Request.QueryString["OpportunityID"];
                    objBooking.UserID = objUser.RecordID.ToString();

                }

                objBooking.saveBooking();

                // From the start date

                DateTime thisDate = DateTime.Parse(StartDateTextBox.Text);
                int thisNoDays = Convert.ToInt32(NoDaysTextBox.Text);

                UK_Film_Location_Class.OpportunityDetails objOpportunity = new UK_Film_Location_Class.OpportunityDetails();
                objOpportunity.getOpportunity(objBooking.OpportunityID);

                int i = 0;

                for (i = 0; i < thisNoDays; i++)
                {
                    // Create Booked Days ready for editing!

                    UK_Film_Location_Class.BookingDates objDate = new UK_Film_Location_Class.BookingDates();

                    objDate.BookingDate = thisDate;
                    objDate.BookingID = objBooking.BookingID;
                    objDate.StartTime = StartTimeTextBox.Text;
                    objDate.EndTime = FinishTimeTextBox.Text;
                    objDate.AgreedDayRate = objOpportunity.LocationRate;
                    try
                    {
                        objDate.NoCrew = Convert.ToInt32(objOpportunity.NoCrew);
                    }
                    catch
                    {
                    }

                    objDate.Save();

                    thisDate = thisDate.AddDays(1);
                }

                string thisPath = Server.MapPath("~/Bookings/") + "/" + objBooking.BookingID;

                if (!System.IO.Directory.Exists(thisPath))
                {
                    System.IO.Directory.CreateDirectory(thisPath);
                }

                Response.Redirect("/BookLocation.aspx?BookingID=" + objBooking.BookingID);

            }
        }