private void materialRaisedButton2_Click(object sender, EventArgs e) { LoginRegisterForm jpform = new LoginRegisterForm(); this.Hide(); jpform.ShowDialog(); this.Close(); }
private void Finish_addVacancy_button_Click(object sender, EventArgs e) { LoginRegisterForm jpform = new LoginRegisterForm(); this.Hide(); jpform.ShowDialog(); this.Close(); }
private void finishCV_button_Click_1(object sender, EventArgs e) { string ordb = "Data source=ORCL;User Id=scott;Password=tiger;"; OracleConnection con; con = new OracleConnection(ordb); con.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = con; //A) 3- insert cmd.CommandText = @"insert into job_seeker (jobseeker_id ,seekername , seekerpassword, email , gender , phone , city , country , education) values(:seekerId , :seekerName, :seekerPass, :seekerEmail , :seekerGender, :seekerPhone, :seekerCity, :seekerCountry, :seekerEdu)"; cmd.Parameters.Add("seekerId", LoginRegisterForm.newId); cmd.Parameters.Add("seekerName", LoginRegisterForm.providerOrSeekerName); cmd.Parameters.Add("seekerPass", LoginRegisterForm.providerOrSeekerPassword); cmd.Parameters.Add("seekerEmail", LoginRegisterForm.providerOrSeekerEmail); cmd.Parameters.Add("seekerGender", gender); cmd.Parameters.Add("seekerPhone", phone); cmd.Parameters.Add("seekerCity", city); cmd.Parameters.Add("seekerCountry", country); cmd.Parameters.Add("seekerEdu", edu); cmd.ExecuteNonQuery(); //adding experience int maxId, newId; for (int i = 0; i < companyName.Count; i++) { OracleCommand cmdID = new OracleCommand(); cmdID.Connection = con; cmdID.CommandText = "getExpId"; cmdID.CommandType = CommandType.StoredProcedure; cmdID.Parameters.Add("id", OracleDbType.Int32, ParameterDirection.Output); cmdID.ExecuteNonQuery(); try { maxId = Convert.ToInt32(cmdID.Parameters["id"].Value.ToString()); newId = maxId + 1; } catch { newId = 1; } OracleCommand cmd2 = new OracleCommand(); cmd2.Connection = con; //A) 3- insert cmd2.CommandText = @"insert into EXPERIENCE (EXPERIENCE_ID,COMPANY_NAME ,YEARS_OF_EXPERIENCE , JOBSEEKER_ID,JOB_TITLE) values(:EXPERIENCE_ID, :companyName , :yearsOfExp, :JOBSEEKER_ID, :JOB_TITLE)"; cmd2.Parameters.Add("EXPERIENCE_ID", newId); cmd2.Parameters.Add("companyName", companyName[i]); cmd2.Parameters.Add("yearsOfExp", yearsOfExp[i]); cmd2.Parameters.Add("JOBSEEKER_ID", LoginRegisterForm.newId); cmd2.Parameters.Add("JOB_TITLE", jobTitle[i]); cmd2.ExecuteNonQuery(); } //adding skills for (int i = 0; i < skills.Count; i++) { OracleCommand cmd2 = new OracleCommand(); cmd2.Connection = con; //A) 3- insert cmd2.CommandText = @"insert into JOB_SEEKER_SKILLS (SKILLS,JOBSEEKER_ID) values(:skills, :seekerid)"; cmd2.Parameters.Add("skills", skills[i]); cmd2.Parameters.Add("JOBSEEKER_ID", LoginRegisterForm.newId); cmd2.ExecuteNonQuery(); } // adding interests for (int i = 0; i < interest.Count; i++) { OracleCommand cmd2 = new OracleCommand(); cmd2.Connection = con; //A) 3- insert cmd2.CommandText = @"insert into JOB_SEEKER_INTERESTS (INTERESTS,JOBSEEKER_ID) values(:INTERESTS, :JOBSEEKER_ID)"; cmd2.Parameters.Add("INTERESTS", interest[i]); cmd2.Parameters.Add("JOBSEEKER_ID", LoginRegisterForm.newId); cmd2.ExecuteNonQuery(); } //adding courses for (int i = 0; i < courses.Count; i++) { OracleCommand cmd2 = new OracleCommand(); cmd2.Connection = con; //A) 3- insert cmd2.CommandText = @"insert into JOB_SEEKER_COURSES (COURSE,JOBSEEKER_ID) values(:COURSE, :JOBSEEKER_ID)"; cmd2.Parameters.Add("COURSE", courses[i]); cmd2.Parameters.Add("JOBSEEKER_ID", LoginRegisterForm.newId); cmd2.ExecuteNonQuery(); } //adding certificates for (int i = 0; i < certificates.Count; i++) { OracleCommand cmd2 = new OracleCommand(); cmd2.Connection = con; //A) 3- insert cmd2.CommandText = @"insert into JOB_SEEKER_CERTIFICATES (CERTIFICATE,JOBSEEKER_ID) values(:CERTIFICATE, :JOBSEEKER_ID)"; cmd2.Parameters.Add("CERTIFICATE", certificates[i]); cmd2.Parameters.Add("JOBSEEKER_ID", LoginRegisterForm.newId); cmd2.ExecuteNonQuery(); } //adding projects for (int i = 0; i < startDate.Count; i++) { OracleCommand cmdIDProject = new OracleCommand(); cmdIDProject.Connection = con; cmdIDProject.CommandText = "getProjectrId"; cmdIDProject.CommandType = CommandType.StoredProcedure; cmdIDProject.Parameters.Add("id", OracleDbType.Int32, ParameterDirection.Output); cmdIDProject.ExecuteNonQuery(); try { maxId = Convert.ToInt32(cmdIDProject.Parameters["id"].Value.ToString()); newId = maxId + 1; } catch { newId = 1; } OracleCommand cmd2 = new OracleCommand(); cmd2.Connection = con; //A) 3- insert cmd2.CommandText = @"insert into PROJECT_JS (PROJECT_ID,START_DATE ,END_DATE , JOBSEEKER_ID) values(:PROJECT_ID, :START_DATE , :END_DATE, :JOBSEEKER_ID)"; cmd2.Parameters.Add("PROJECT_ID", newId); cmd2.Parameters.Add("START_DATE", startDate[i]); cmd2.Parameters.Add("END_DATE", endDate[i]); cmd2.Parameters.Add("JOBSEEKER_ID", LoginRegisterForm.newId); cmd2.ExecuteNonQuery(); for (int j = 0; j < technology[i].Length; j++) { OracleCommand cmd3 = new OracleCommand(); cmd3.Connection = con; //A) 3- insert cmd3.CommandText = @"insert into PROJECT_JS_TECHNOLOGY (TECHNOLOGY,PROJECT_ID ) values(:TECHNOLOGY, :PROJECT_ID)"; cmd3.Parameters.Add("TECHNOLOGY", technology[i][j]); cmd3.Parameters.Add("PROJECT_ID", newId); cmd3.ExecuteNonQuery(); } } LoginRegisterForm loginform = new LoginRegisterForm(); this.Hide(); loginform.ShowDialog(); this.Close(); }