private void button2_Click(object sender, EventArgs e) { if (radioButton1.Checked) { if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox5.Text != "" && textBox6.Text != "") { CompanyAccount Company = new CompanyAccount(); Company.Username = account.Username; Company.Password = account.Password; Company.CompanyName = textBox1.Text; Company.CompanyID = textBox2.Text; Company.EmailAddress = textBox3.Text; Company.FAX = textBox4.Text; Company.PhoneNumber = textBox5.Text; Company.Address1 = textBox6.Text; Company.Address2 = textBox7.Text; this.UseWaitCursor = true; button1.Enabled = false; button2.Enabled = false; button3.Enabled = false; Task T = new Task(() => Da.RegisterCompanyAccount(Company)); T.Start(); } else { MessageBox.Show("Some fields are left empty.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else if (radioButton2.Checked) { if (textBox1.Text != "" && textBox2.Text != "" && textBox5.Text != "" && textBox4.Text != "") { SoloAccount Person = new SoloAccount(); Person.Username = account.Username; Person.Password = account.Password; Person.Name = textBox1.Text; Person.Surname = textBox2.Text; Person.DateOfBirth = dateTimePicker.Value; Person.EmailAddress = textBox4.Text; Person.PhoneNumber = textBox5.Text; this.UseWaitCursor = true; button1.Enabled = false; button2.Enabled = false; button3.Enabled = false; Task T = new Task(() => Da.RegisterSoloAccount(Person)); T.Start(); } else { MessageBox.Show("Mandatory fields are empty.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
public void RegisterCompanyAccount(CompanyAccount Company) { try { string query = "insert into Account (Username, Password, IsAdmin, Company_idClientCompany) values (@Name, @Password, @IsAdmin, @ID)"; string query1 = "insert into Company (Name, CompanyID, PhoneNumer, EmailAddress, FAX, Address1, Address2) values (@Name, @ID, @Phone, @Email, @Fax, @Ad1, @Ad2)"; string query2 = "select idClientCompany from Company where CompanyID = @ID"; MySqlCommand comm = new MySqlCommand(query, connection); MySqlCommand comm1 = new MySqlCommand(query1, connection); MySqlCommand comm2 = new MySqlCommand(query2, connection); comm1.Parameters.AddWithValue("@Name", Company.CompanyName); comm1.Parameters.AddWithValue("@ID", Company.CompanyID); comm1.Parameters.AddWithValue("@Phone", Company.PhoneNumber); comm1.Parameters.AddWithValue("@Email", Company.EmailAddress); comm1.Parameters.AddWithValue("@Fax", Company.FAX); comm1.Parameters.AddWithValue("@Ad1", Company.Address1); comm1.Parameters.AddWithValue("@Ad2", Company.Address2); comm2.Parameters.AddWithValue("@ID", Company.CompanyID); OpenConnection(); comm1.ExecuteNonQuery(); MySqlDataReader reader = comm2.ExecuteReader(); reader.Read(); int Id = Convert.ToInt32(reader[0].ToString()); reader.Close(); comm.Parameters.AddWithValue("@Name", Company.Username); comm.Parameters.AddWithValue("@Password", Company.Password); comm.Parameters.AddWithValue("@IsAdmin", 0); comm.Parameters.AddWithValue("@ID", Id); comm.ExecuteNonQuery(); CloseConnection(); MessageBox.Show("Registration successful", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); RegResponder(); Application.Run(new LogInForm()); } catch (Exception Ex) { //Duplicate entry MessageBox.Show(Ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }