private void metroButton2_MouseClick(object sender, MouseEventArgs e)
{
this.Hide();
ADBMS_PROJ special = new ADBMS_PROJ();
special.ShowDialog();
this.Close();
}
private void metroButton1_MouseClick(object sender, MouseEventArgs e)
{
int k = 0;
String user = metroTextBox1.Text;
String pass = metroTextBox2.Text;
String name = metroTextBox3.Text;
String email = metroTextBox5.Text;
if (metroTextBox1.Text == "" || metroTextBox2.Text == "" || metroTextBox5.Text == "")
{
MessageBox.Show("SOME FIELD IS MISSING, PLEASE ENTER CORRECT VALUES");
}
else
{
try
{
string connstring = "Data Source = (DESCRIPTION = " +
"(ADDRESS = (PROTOCOL = TCP)(HOST = IceFrog-PC)(PORT = 1521))" +
"(CONNECT_DATA =" +
"(SERVER = DEDICATED)" +
"(SERVICE_NAME = XE)" +
")" +
");User Id = icefrog; password = 123four;";
OracleConnection cc = new OracleConnection(connstring);
string ssqqll = "select * from users";
OracleDataAdapter adapter = new OracleDataAdapter(ssqqll, cc);
DataTable dt = new DataTable();
adapter.Fill(dt);
cc.Close();
int rowcount = dt.Rows.Count;
for (int i = 0; i < rowcount; i++)
{
if (dt.Rows[i]["uname"].ToString().Equals(user))
{
k = 1;
}
}
if (k == 1)
{
MessageBox.Show("USERNAME ALREADY EXISTS!"); k = 0;
}
else
{
string sql = "insert into users values('" + user + "','" + pass + "','" + name + "','" + email + "')";
c.ExecuteQuery(sql);
MessageBox.Show("REGISTRATION SUCCESSFUL!");
this.Hide();
ADBMS_PROJ special = new ADBMS_PROJ();
special.ShowDialog();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
