private void button3_Click(object sender, EventArgs e)
{
Hide();
var f = new LogInAlumni();
f.Show();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show(@"Please enter your name.", @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var r1 = new Regex(@"^[\p{L} \.'\-]+$");
if (!r1.IsMatch(textBox1.Text.Trim()))
{
MessageBox.Show(@"Name can only have alphabets and space in between.", @"Warning", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
return;
}
if (textBox2.Text.Trim() == "")
{
MessageBox.Show(@"ID can not be empty", @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var r = new Regex(@"\D");
if (r.IsMatch(textBox2.Text.Trim()))
{
MessageBox.Show(@"ID must be a number. Can not contain alphabet, white space or any special character.",
@"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (textBox2.Text.Trim().Length != 9)
{
MessageBox.Show(@"ID can have 9 digits only", @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (textBox3.Text.Trim() == "")
{
MessageBox.Show(@"Password can not be empty.", @"Warning", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
return;
}
var choice = MessageBox.Show(@"Confirm?", @"Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (choice == DialogResult.Yes)
{
var alumni = textBox1.Text.Trim();
var formattedAlumni = new StringBuilder();
for (var i = 0; i < alumni.Length; i++)
{
if (i == 0)
{
formattedAlumni.Append(char.ToUpper(alumni[0]));
}
else
{
if (alumni[i - 1] == ' ')
{
if (alumni[i] == ' ')
{
continue;
}
formattedAlumni.Append(char.ToUpper(alumni[i]));
}
else
{
formattedAlumni.Append(char.ToLower(alumni[i]));
}
}
}
var con = new MySqlConnection("server=localhost;user id=root;database=kys");
con.Open();
var dt = new DataTable();
var selectQuery = "insert into" +
" alumni(id, name)" +
" values ('" +
textBox2.Text + "', '" +
formattedAlumni +
"')";
try
{
var sda = new MySqlDataAdapter(selectQuery, con);
sda.Fill(dt);
MessageBox.Show(@"Registration Completed!", @"Successful", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception)
{
MessageBox.Show(@"ID already exists", @"Failed", MessageBoxButtons.RetryCancel,
MessageBoxIcon.Information);
con.Close();
return;
}
con.Close();
var con2 = new MySqlConnection("server=localhost;user id=root;database=kys");
MySqlDataAdapter sda2;
con2.Open();
var dt2 = new DataTable();
var selectQuery2 = "insert into" +
" login_alumni(id, password)" +
" values ('" +
textBox2.Text + "', '" +
textBox3.Text +
"')";
try
{
sda2 = new MySqlDataAdapter(selectQuery2, con2);
sda2.Fill(dt2);
}
catch (Exception)
{
// ignored
}
con2.Close();
Close();
var f = new LogInAlumni();
f.Show();
}
}