private void AddButton_Click(object sender, EventArgs e)
{
if (
!(JobTitleBox.Text == "Job Title") && !string.IsNullOrEmpty(JobTitleBox.Text) &&
!(JobRoleBox.Text == "Job Role") && !string.IsNullOrEmpty(JobRoleBox.Text) &&
!(ExperienceTypeBox.Text == "Experience Type") && !string.IsNullOrEmpty(ExperienceTypeBox.Text) &&
!(CompanyNameBox.Text == "Company Name") && !string.IsNullOrEmpty(CompanyNameBox.Text)
)
{
SqlConnection con = new SqlConnection(@"Data Source=OLA\SQLSERVER;Initial Catalog=ApplicantTrackingSystem;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False");
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO [ExperienceWork](Username,JobTitle,JobRole,CompanyName,ExperienceType,StartDate,EndDate) VALUES (@Username,@JobTitle,@JobRole,@CompanyName,@ExperienceType,@StartDate,@EndDate)", con);
//Username,JobTitle,JobRole,CompanyName,ExperienceType,StartDate,EndDate
cmd.Parameters.AddWithValue("@Username", UserID);
cmd.Parameters.AddWithValue("@JobTitle", JobTitleBox.Text);
cmd.Parameters.AddWithValue("@JobRole", JobRoleBox.Text);
cmd.Parameters.AddWithValue("@CompanyName", CompanyNameBox.Text);
cmd.Parameters.AddWithValue("@ExperienceType", ExperienceTypeBox.Text);
cmd.Parameters.AddWithValue("@StartDate", StartDate.Value.Date.ToString("yyyyMMdd"));
cmd.Parameters.AddWithValue("@EndDate", EndDate.Value.Date.ToString("yyyyMMdd"));
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Work Experience has been added successfully");
ViewExperiencesPanel.Show();
AddExperiencePanel.Hide();
}
else
{
MessageBox.Show("Please Fill the Empty Boxes");
}
}
private void CareerInterestsTab_Click(object sender, EventArgs e)
{
CareerPanel.Show();
PersonalInfoPanel.Hide();
ViewSkillsPanel.Hide();
ViewExperiencesPanel.Hide();
ResumePanel.Hide();
}
private void resumeToolStripMenuItem_Click(object sender, EventArgs e)
{
ResumePanel.Show();
ViewExperiencesPanel.Hide();
PersonalInfoPanel.Hide();
CareerPanel.Hide();
ViewSkillsPanel.Hide();
}
private void ViewExperiences_Click(object sender, EventArgs e)
{
ViewExperiencesPanel.Show();
JobRoleBox.Hide();
AddExperiencePanel.Hide();
}
