private void Button1_Click(object sender, EventArgs e)
{
String name = companyNameTxtBox.Text;
string services = "";
foreach (object itemChecked in checkedListBox1.CheckedIndices)
{
services = services + itemChecked.ToString() + ",";
}
services = services.Remove(services.Length - 1, 1);
string username = textBox1.Text;
string password = textBox2.Text;
String phoneNumber = phoneNumberTxtBox.Text;
String companyEmail = companyEmailTxtBox.Text;
String remittanceAddress = addressTxtBox.Text;
String bank = bankTxtBox.Text;
String accountNum = accountNumTxtBox.Text;
String routingNum = routingNumTxtBox.Text;
String loginPIN = loginPinTxtBox.Text;
DBMng.insertIntohsp(name, services, username, password, companyEmail, phoneNumber, remittanceAddress, bank, accountNum, routingNum, loginPIN);
int id = DBMng.validateHSPWithPin(loginPIN);
this.Hide();
HSPinfoGUI info = new HSPinfoGUI(id);
info.ShowDialog();
}
