private void button3_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string cekme = "SELECT Count(URUN_ID) FROM Product";
SqlDataAdapter da = new SqlDataAdapter(cekme, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
label10.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();
MyConnection.Close();
SqlConnection My = new SqlConnection();
My.ConnectionString = ConnectionClass.Connection_Path();
My.Open();
string sqlim = "SELECT * FROM PRODUCT";
SqlDataAdapter d = new SqlDataAdapter(sqlim, MyConnection);
DataTable dte = new DataTable();
d.Fill(dte);
dataGridView1.DataSource = dte;
MyConnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
SqlCommand komut = new SqlCommand("SELECT * FROM KULLANICI WHERE USERNAME= '******' AND PASSWORD= '******'");
SqlDataReader dr;
komut.Connection = MyConnection;
dr = komut.ExecuteReader();
int count = 0;
while (dr.Read())
{
count += 1;
}
if (!checkBox1.Checked)
{
Button btn = sender as Button;
textBox1.Enabled = false;
textBox2.Enabled = false;
if (btn == button1)
{
MisafirKullanici mu = new MisafirKullanici();
mu.Show();
this.Hide();
}
}
if (count == 1 && checkBox1.Checked)
{
MainMenu du = new MainMenu();
UserLogin.ActiveForm.Visible = false;
du.Show();
}
else if (count == 0 && checkBox1.Checked && textBox1.Text != "" && textBox2.Text != "")
{
MessageBox.Show("Lütfen kullanıcı adınız veya şifreniz hatalı!", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBox1.Clear();
textBox2.Clear();
}
else if (checkBox1.Checked && textBox1.Text == "" && textBox2.Text == "")
{
MessageBox.Show("Lütfen kullanıcı adınızı ve şifrenizi giriniz.", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
textBox1.Clear();
textBox2.Clear();
}
else if (checkBox1.Checked && textBox1.Text == "")
{
MessageBox.Show("Kullanıcı adınızı giriniz.", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (checkBox1.Checked && textBox2.Text == "")
{
MessageBox.Show("Lütfen şifrenizi giriniz.", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
AutoCompleteStringCollection urun = new AutoCompleteStringCollection();
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
SqlCommand cmd = MyConnection.CreateCommand();
cmd.CommandText = "SELECT A.URUN_ADI FROM PRODUCT AS A";
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{
while (dr.Read())
{
urun.Add(dr["URUN_ADI"].ToString());
}
}
else
{
//MessageBox.Show("");
}
textBox2.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox2.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox2.AutoCompleteCustomSource = urun;
}
public static void Update(string somut)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
SqlDataAdapter da = new SqlDataAdapter(somut, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
MyConnection.Close();
}
public static DataTable BilgiGetir(string komut)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
SqlDataAdapter da = new SqlDataAdapter(komut, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
MyConnection.Close();
return(dt);
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string somut = "SELECT A.ID,A.USERNAME FROM KULLANICI AS A ";
SqlDataAdapter da = new SqlDataAdapter(somut, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
MyConnection.Close();
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string sqlim = "SELECT A.CUSTOMER_ADI AS Adı, A.CUSTOMER_SOYADI AS Soyadı FROM CUSTOMER AS A";
SqlDataAdapter da = new SqlDataAdapter(sqlim, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
MyConnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string sqlim = "SELECT * FROM product";
SqlDataAdapter da = new SqlDataAdapter(sqlim, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
MyConnection.Close();
}
private void button2_Click(object sender, EventArgs e)
{
button1.Enabled = true;
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string sqlim = "SELECT A.CUSTOMER_ID AS ID,A.CUSTOMER_ADI AS ADI,CUSTOMER_SOYADI AS SOYADI,B.RANDEVU_GUNU AS RANDEVUSU FROM CUSTOMER AS A,RANDEVU AS B WHERE A.CUSTOMER_ID=B.CUSTOMER_ID";
SqlDataAdapter da = new SqlDataAdapter(sqlim, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
MyConnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string somut = "select a.username from KULLANICI AS A ";
SqlDataAdapter da = new SqlDataAdapter(somut, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
label1.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString();
MyConnection.Close();
}
