private void pictureBox4_Click(object sender, EventArgs e)
{
HomerBidder homeBidder = new HomerBidder();
homeBidder.Show();
this.Hide();
}
private void loginbtn_Click(object sender, EventArgs e)
{
using (con = new OracleConnection(ordb))
{
con.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText = "select USER_ID from users where E_MAIL =:email and PASSWORD = :pw";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("email", emailtxt.Text.Trim().ToString());
cmd.Parameters.Add("pw", passwordtxt.Text.Trim().ToString());
OracleDataReader dr = cmd.ExecuteReader();
int id = 0;
while (dr.Read())
{
id = Convert.ToInt32(dr[0]);
}
if (id == 0)
{
MessageBox.Show("Invalid E-Mail Or Password !! ");
}
else
{
GlobalID.ID = id;
cmd.CommandText = "select USER_ID from sellers where USER_ID = " + id;
cmd.CommandType = CommandType.Text;
dr = cmd.ExecuteReader();
if (dr.Read())
{
HomeSeller hs = new HomeSeller();
hs.Show();
this.Hide();
}
else
{
HomerBidder hb = new HomerBidder();
hb.Show();
this.Hide();
}
}
}
}
