// clear all entry boxes
private void ClearBoxes()
{
ActiveStateCbo.SelectedIndex = 0;
CompanyNameBox.Clear();
StaffingFirmBox.Clear();
JobTitleBox.Clear();
JobStatusCbo.SelectedIndex = 0;
JobBoardCbo.SelectedIndex = 0;
JobIDBox.Clear();
NameBox.Clear();
ContactTitleBox.Clear();
ContactPhoneBox.Clear();
ContactEmailBox.Clear();
AddressBox.Clear();
JobLocationBox.Clear();
CompanyPhoneBox.Clear();
CompanyWebsiteBox.Clear();
CommentsBox.Clear();
ContactDatePkr.Value = DateTime.Now;
InterviewDateTimeBox.Clear();
idSelected = 0;
DWSChk.Checked = false;
RecruiterChk.Checked = false;
JobTypeCbo.SelectedIndex = 0;
}
//Clear Input boxes
private void clear_Click(object sender, EventArgs e)
{
jobClientEmailBox.Clear();
jobContractorEmailBox.Clear();
jobDescriptionBox.Clear();
jobDateBox.Refresh();
JobLocationBox.Clear();
}
private void clear_Click(object sender, EventArgs e)
{
jobDescriptionBox.Clear();
jobDateBox.Refresh();
JobLocationBox.Clear();
jobTimeBox.Clear();
jobPriorityBox.Refresh();
}
private void save_Click(object sender, EventArgs e)
{
//checks if boxes are not empty
if (jobDescriptionBox.Text != "" & JobLocationBox.Text != "" & jobTimeBox.Text != "")
{
//opens sql connection
con.Open();
//puts the input data into a readable sql query
string query = "Insert into job (Description,Location,Date,Time,Priority) Values('" + jobDescriptionBox.Text + "','" + JobLocationBox.Text + "','" + jobDateBox.Text + "','" + jobTimeBox.Text + "','" + jobPriorityBox.Text + "')";
SqlCommand cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();
con.Close();
//displays that data has been saved
MessageBox.Show("Data is successful saved");
//clears the input fields
jobDescriptionBox.Clear();
jobDateBox.Refresh();
JobLocationBox.Clear();
jobTimeBox.Clear();
jobPriorityBox.ResetText();
diaplay_data();
}
}
