public void Insert(TextBox name, TextBox adress, TextBox email, TextBox user, TextBox password, Label date)
{
ctrl(user);
if (state == true)
{
SqlCommand komut = new SqlCommand("Insert into Customer (Name,Adress,Email,Username,Password,Register_Time) Values(@name,@address,@email,@user, @pass,@time)", baglan);
komut.Parameters.AddWithValue("@name", name.Text);
komut.Parameters.AddWithValue("@address", adress.Text);
komut.Parameters.AddWithValue("@email", email.Text);
komut.Parameters.AddWithValue("@User", user.Text);
komut.Parameters.AddWithValue("@pass", password.Text.ToString());
komut.Parameters.AddWithValue("@time", Convert.ToDateTime(date.Text));
if (baglan.State == System.Data.ConnectionState.Closed)
{
baglan.Open();
}
komut.ExecuteNonQuery();
baglan.Close();
MessageBox.Show("Successful Registration");
name.Text = "";
adress.Text = "";
email.Text = "";
user.Text = "";
password.Text = "";
Customer_Page cstmr = new Customer_Page();
cstmr.Show();
SignUp_Page sign = new SignUp_Page();
sign.Hide();
}
else
{
MessageBox.Show("There is another user with the same username", "Warning !", MessageBoxButtons.OK, MessageBoxIcon.Warning);
baglan.Close();
}
}
public void Login(TextBox user, TextBox pass, Form frm)
{
SqlCommand cmd = new SqlCommand(sorgu, baglan);
cmd.Parameters.AddWithValue("@kullaniciadi", user.Text);
cmd.Parameters.AddWithValue("@sifre", pass.Text);
baglan.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr["Access"].ToString() == "1")
{
Customer_Page customer = new Customer_Page();
Customer_Page.usr = user.Text;
customer.Show();
}
else
{
Admin_Page admin = new Admin_Page();
Admin_Page.usr = user.Text;
admin.Show();
frm.Hide();
}
}
else
{
MessageBox.Show("Incorrect username or password", "ERROR !", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
baglan.Close();
}
