public void InsertJobFair(JobFair jobFair)
        {
            string str_command = "" +
                                 "INSERT INTO TestJobFairs" +
                                 "(" +
                                 "Title, " +
                                 "Description, " +
                                 "StartDate, " +
                                 "EndDate, " +
                                 "VenueID, " +
                                 "Website, " +
                                 "Phone " +
                                 ")" +
                                 "Values " +
                                 "(" +
                                 "'" + jobFair.Title + "'," +
                                 "'" + jobFair.Description + "'," +
                                 "'" + jobFair.StartDate + "'," +
                                 "'" + jobFair.EndDate + "'," +
                                 "'" + jobFair.VenueID + "'," +
                                 "'" + jobFair.Website + "'," +
                                 "'" + jobFair.PhoneNumber + "'" +
                                 ")";

            ExecuteCommand(str_command);
        }
Exemple #2
0
        public Frm_JobFair(JobFair jobFair)
        {
            InitializeComponent();

            this.jobFair = jobFair;

            datePick_start.Value = DateTime.Today;
            datePick_end.Value   = DateTime.Today;
        }
        public Frm_Master()
        {
            InitializeComponent();

            jobFair = new JobFair();
            person  = new Person();
            venue   = new Venue();


            frm_jobFair = new Frm_JobFair(jobFair);
            frm_people  = new Frm_People(person);
            frm_venue   = new Frm_Venue(venue);

            database = new Database("Data Source=JOESMAC-WINDOWS;Initial Catalog=JobFair;Integrated Security=True");
        }