private void SignUpButton_Click_1(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=OLA\SQLSERVER;Initial Catalog=ApplicantTrackingSystem;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False"); con.Open(); bool Reg, UsedUsername; if (!string.IsNullOrEmpty(MailBox.Text) && !(MailBox.Text == "E-mail") && !string.IsNullOrEmpty(UsernameBox.Text) && !(UsernameBox.Text == "Username") && !string.IsNullOrEmpty(PasswordBox.Text) && !(PasswordBox.Text == "Password") && !(CareerLevelBox.Text == "Career Level") && !string.IsNullOrEmpty(CareerLevelBox.Text) && !(EducationalLevelBox.Text == "Educational Level") && !string.IsNullOrEmpty(EducationalLevelBox.Text) && !(YearsOfExperience.Text == "Years of Experience") && !string.IsNullOrEmpty(YearsOfExperience.Text) && !(FirstName.Text == "First Name") && !string.IsNullOrEmpty(FirstName.Text) && !(LastName.Text == "Last Name") && !string.IsNullOrEmpty(LastName.Text) && !(CountryBox.Text == "Country") && !string.IsNullOrEmpty(CountryBox.Text) && !(CityBox.Text == "City") && !string.IsNullOrEmpty(CityBox.Text) && !(AreaBox.Text == "Area") && !string.IsNullOrEmpty(AreaBox.Text) && !(MobileBox.Text == "Mobile Number") && !string.IsNullOrEmpty(MobileBox.Text) ) { SqlCommand cmd = new SqlCommand("select Username, Mail from [Candidate]", con); SqlDataReader rdr = cmd.ExecuteReader(); Reg = false; UsedUsername = false; while (rdr.Read()) { string Mail = (string)rdr["Mail"]; if (Mail != MailBox.Text) { Reg = false; } else { Reg = true; MessageBox.Show("You already have an account! You can log in."); Form form = new UserLogin(); form.Show(); this.Hide(); break; } string UserName = (string)rdr["Username"]; if (UserName == UsernameBox.Text) { UsedUsername = true; MessageBox.Show("This Usename already used, Please write another one."); UsernameBox.Clear(); break; } } rdr.Close(); if (!Reg && !UsedUsername) { string CandidateInsertCommand = "INSERT INTO [Candidate](Username,Mail , Password)VALUES (@Username,@Mail , @Password)"; SqlCommand CandidateInsert = new SqlCommand(CandidateInsertCommand, con); CandidateInsert.Parameters.AddWithValue("@Mail", MailBox.Text); CandidateInsert.Parameters.AddWithValue("@Username", UsernameBox.Text); CandidateInsert.Parameters.AddWithValue("@Password", PasswordBox.Text); CandidateInsert.ExecuteNonQuery(); string PersonalInfoInsertCommand = "INSERT INTO [PersonalInformation](Username,FirstName,LastName,Birthdate,Country,City,Area,MobileNumber) VALUES (@Username,@FirstName,@LastName,@Birthdate,@Country,@City,@Area,@MobileNumber)"; SqlCommand PersonalInfoInsert = new SqlCommand(PersonalInfoInsertCommand, con); //Username,FirstName,LastName,Birthdate,Country,City,Area,MobileNumber PersonalInfoInsert.Parameters.AddWithValue("@Username", UsernameBox.Text); PersonalInfoInsert.Parameters.AddWithValue("@FirstName", FirstName.Text); PersonalInfoInsert.Parameters.AddWithValue("@LastName", LastName.Text); PersonalInfoInsert.Parameters.AddWithValue("@Birthdate", Birthdate.Value.Date.ToString("yyyyMMdd")); PersonalInfoInsert.Parameters.AddWithValue("@Country", CountryBox.Text); PersonalInfoInsert.Parameters.AddWithValue("@City", CityBox.Text); PersonalInfoInsert.Parameters.AddWithValue("@Area", AreaBox.Text); PersonalInfoInsert.Parameters.AddWithValue("@MobileNumber", MobileBox.Text); PersonalInfoInsert.ExecuteNonQuery(); string CareerInsertCommand = "INSERT INTO [CareerInterests](Username,EducationLevel,CareerLevel,ExperienceYears) VALUES (@Username,@EducationLevel,@CareerLevel,@ExperienceYears)"; SqlCommand CareerInsert = new SqlCommand(CareerInsertCommand, con); //EducationalLevel,CareerLevel,ExperienceYears CareerInsert.Parameters.AddWithValue("@Username", UsernameBox.Text); CareerInsert.Parameters.AddWithValue("@EducationLevel", EducationalLevelBox.Text); CareerInsert.Parameters.AddWithValue("@CareerLevel", CareerLevelBox.Text); CareerInsert.Parameters.AddWithValue("@ExperienceYears", Convert.ToInt64(YearsOfExperience.Text)); CareerInsert.ExecuteNonQuery(); MessageBox.Show("Registration Completed, Now you have an account and you can log in."); Form form = new UserLogin(); form.Show(); this.Hide(); } } else { MessageBox.Show("Please Fill the Empty Boxes"); } con.Close(); }
private void SignUpButton_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=OLA\SQLSERVER;Initial Catalog=ApplicantTrackingSystem;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False"); con.Open(); bool Reg, UsedUsername; if (!string.IsNullOrEmpty(MailBox.Text) && !string.IsNullOrEmpty(CompanyBox.Text) && !string.IsNullOrEmpty(PasswordBox.Text) && !(MailBox.Text == "E-mail") && !(CompanyBox.Text == "Username") && !(PasswordBox.Text == "Password")) { SqlCommand cmd = new SqlCommand("select Username, Mail from [Account]", con); SqlDataReader rdr = cmd.ExecuteReader(); Reg = false; UsedUsername = false; while (rdr.Read()) { string Mail = (string)rdr["Mail"]; if (Mail != MailBox.Text) { Reg = false; } else { Reg = true; MessageBox.Show("You already have an account! You can log in."); Form form = new UserLogin(); form.Show(); this.Hide(); break; } string UserName = (string)rdr["Username"]; if (UserName == CompanyBox.Text) { UsedUsername = true; MessageBox.Show("This Company already Exist"); CompanyBox.Clear(); break; } } rdr.Close(); if (!Reg && !UsedUsername) { string AccountInsertCommand = "INSERT INTO [Account]VALUES (@Mail, @Username, @Password,@Type)"; SqlCommand AccountInsert = new SqlCommand(AccountInsertCommand, con); AccountInsert.Parameters.AddWithValue("@Mail", MailBox.Text); AccountInsert.Parameters.AddWithValue("@Username", CompanyBox.Text); AccountInsert.Parameters.AddWithValue("@Password", Convert.ToInt64(PasswordBox.Text)); AccountInsert.Parameters.AddWithValue("@Type", 1); AccountInsert.ExecuteNonQuery(); MessageBox.Show("Registration Completed, Now you have an account and you can log in."); } } else { MessageBox.Show("Please Fill the Empty Boxes"); } con.Close(); }