public void confirmBtn(object sender, EventArgs e)
{
signupWarning.Visible = false;
if (credsCheck())
{
//check for email in use
DataTable DT_EMAILCHECK = SQL.SQLcommand(@"Select * from users");
foreach (DataRow row in DT_EMAILCHECK.Rows)
{
if (email.Text == row[1].ToString()) //already used email
{
signupWarning.Visible = true;
return;
}
}
//add user
SQL.add_to_db(@"Select add_user('" + email.Text + "'," + "'" + password.Text + "'," +
storeOwner.Checked + ");");
if (!storeOwner.Checked) //load user page
{
UserPage up = new UserPage();
up.UserEmail = email.Text;
up.Location = this.Location;
up.StartPosition = FormStartPosition.CenterScreen;
this.Hide();
up.Show();
return;
}
else
{
SQL.add_to_db(string.Format(@"insert into owner values (0.00,'{0}')", email.Text));
OwnerPage op = new OwnerPage(email.Text);
op.Location = this.Location;
op.StartPosition = FormStartPosition.CenterScreen;
this.Hide();
op.Show();
}
}
else
{
signupWarning.Visible = true;
return;
}
}
public void login(object sender, EventArgs e)
{
//clear bad login warning
loginWarning.Visible = false;
//get data
DataTable dt = SQL.SQLcommand(@"Select * from logins");
//check if there is data
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
if (email.Text == row[0].ToString() && password.Text == row[1].ToString()) //good login
{
if (!(bool)row[2]) //user page
{
UserPage up = new UserPage();
up.UserEmail = email.Text;
up.Location = this.Location;
up.StartPosition = FormStartPosition.CenterScreen;
this.Hide();
up.Show();
}
else //owner page
{
//show owner page
OwnerPage op = new OwnerPage(email.Text);
op.Location = this.Location;
op.StartPosition = FormStartPosition.CenterScreen;
this.Hide();
op.Show();
}
return;
}
}
loginWarning.Visible = true;
return;
}
}