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