protected void Button2_Click(object sender, EventArgs e)
        {
            FerryEntities Db     = new FerryEntities();
            var           person = new Person();

            person.Fname = TextBox1.Text;
            person.Lname = TextBox2.Text;
            person.Sex   = Sex.SelectedItem.Value;
            person.DOB   = Convert.ToDateTime(TextBox3.Text);
            Db.People.Add(person);
            Db.SaveChanges();
            int Result = Db.SaveChanges();

            if (Result > 0)
            {
                Response.Write("</script>alert('Data inserted successfully')</script>");
            }
            else
            {
                Response.Write("</script>alert('Data not inserted successfully')</script>");
            }
            Response.Redirect("WebForm1.aspx");
        }
        protected void Button4_Click(object sender, EventArgs e)
        {
            FerryEntities Db = new FerryEntities();

            var passeneger = new Customer();

            passeneger.FirstName      = Fname.Text;
            passeneger.MiddleName     = Mname.Text;
            passeneger.LastName       = Lname.Text;
            passeneger.Sex            = Sex.SelectedItem.Value;
            passeneger.DOB            = Convert.ToDateTime(DOB.Text);
            passeneger.Nationality    = Nationality.SelectedItem.Value;
            passeneger.PassportNumber = Passport.Text;
            passeneger.DateOfIssue    = Convert.ToDateTime(DateofIssue.Text);
            passeneger.DateOfExpire   = Convert.ToDateTime(DateofExpire.Text);
            passeneger.Destination    = Destination.SelectedItem.Value;
            passeneger.EntryDate      = Convert.ToDateTime(DateofEntry.Text);
            passeneger.Period         = Period.SelectedItem.Text;
            passeneger.VoyageNumber   = Voyage.Text;
            Db.Customers.Add(passeneger);
            Db.SaveChanges();
            Response.Redirect("Passenger.aspx");
        }