private void checkNewJob()
{
if ((txtEmployer.Text != Employer || txtJob.Text != Job) && txtJob.Text != "")
{
clsDB objDB = new clsDB(strDB);
clsFormat objFormat = new clsFormat();
string strInsert = "Insert Into Job(Title, Description, Employer, Address,City, Zip,PlacementDate,Consumer_ID)";
string strValues = " Values('" + txtJob.Text + "','" + objFormat.removeApostrophe(txtDescription.Text) + "','" + objFormat.removeApostrophe(txtEmployer.Text) + "','" + txtAddress.Text + "'";
strValues = strValues + ",'" + txtCity.Text + "','" + objFormat.formatZip(txtZip.Text) + "'," + objFormat.formatDate(txtPlacement.Text) + "," + ID + ")";
objDB.assignJob(strInsert + strValues);
// logic to email Kristen.
clsEmail objEmail = new clsEmail();
objEmail.MailInfo("*****@*****.**", txtConsumer.Text);
}
}
