Example #1
0
        private void btnGiris_Click(object sender, EventArgs e)
        {
            anapanel = new Anapanel();
            if (Convert.ToInt32(lblDeneme.Text) > 0)
            {
                try
                {
                    con.Open();
                    SqlParameter prm1 = new SqlParameter("@kadi", txtKadi.Text);
                    SqlParameter prm2 = new SqlParameter("@sifre", txtSifre.Text);
                    string       sql  = "select * from KULLANICILAR where Kad=@kadi and Ksifre=@sifre";
                    SqlCommand   cmd  = new SqlCommand(sql, con);
                    cmd.Parameters.Add(prm1);
                    cmd.Parameters.Add(prm2);
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    DataTable      dt = new DataTable();
                    da.Fill(dt);
                    con.Close();
                    if (dt.Rows.Count > 0 && txtGuvenlik.Text == lblGuvenlik.Text)
                    {
                        if (txtKadi.Text == "admin")
                        {
                            flag = 1;
                        }

                        MessageBox.Show("Giriş Yapıldı!");
                        this.Hide();
                        anapanel.Show();
                    }
                    else
                    {
                        MessageBox.Show("Malesef, birşeyler yolunda gitmedi!");
                        lblDeneme.Text = (Convert.ToInt32(lblDeneme.Text) - 1).ToString();
                        SifreOlustur();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
            if (Convert.ToInt32(lblDeneme.Text) == 0)
            {
                MessageBox.Show("Giriş yapma hakkınız kalmamıştır, Program kapanıyor!");
                Application.Exit();
            }
        }
Example #2
0
        private void btnIptal_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("Server=desktop-2knss9k\\sql_2014;Database=oto_teknik_servis_PROJE;Integrated Security=true");

            try
            {
                con.Open();
                String     str = "delete from FATURA where Fid=(select MAX(Fid) from FATURA)";
                SqlCommand cmd = new SqlCommand(str, con);
                cmd.ExecuteNonQuery();
                con.Close();
                MessageBox.Show("Satış İptal Edildi..!");
                anapanel = new Anapanel();
                anapanel.Show();
                this.Hide();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Example #3
0
 private void btnOnay_Click(object sender, EventArgs e)
 {
     anapanel = new Anapanel();
     if (txtMiktar.Text != "" && cbUrunTip.Text != "" && cbMarka.Text != "" && cbModel.Text != "" && dataGridView1.RowCount == 2)
     {
         if ((int.Parse(dataGridView1.Rows[0].Cells[4].Value.ToString())) >= (int.Parse(txtMiktar.Text)))
         {
             SqlConnection con = new SqlConnection("Server=desktop-2knss9k\\sql_2014;Database=oto_teknik_servis_PROJE;Integrated Security=true");
             try
             {
                 con.Open();
                 String str = "insert into FATURA_SATIS (Fid,Uid,FSmiktar,FSfiyat,Tarih) "
                              + "values((select MAX(Fid) from FATURA),@uid,@fsdmiktar,@fsdfiyat,@tarih)";
                 SqlCommand cmd = new SqlCommand(str, con);
                 cmd.Parameters.Add(new SqlParameter("@fsdfiyat", lblTutar.Text));
                 cmd.Parameters.Add(new SqlParameter("@fsdmiktar", txtMiktar.Text));
                 cmd.Parameters.Add(new SqlParameter("@tarih", DateTime.Now.ToShortDateString()));
                 cmd.Parameters.Add(new SqlParameter("@uid", dataGridView1.Rows[0].Cells[0].Value.ToString()));
                 cmd.ExecuteNonQuery();
                 con.Close();
                 MessageBox.Show("Satış başarılı..");
                 anapanel.Show();
                 this.Hide();
             }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.Message);
             }
         }
         else
         {
             MessageBox.Show("Stok miktarı yeterli değil..!");
         }
     }
     else
     {
         MessageBox.Show("Ürün seçimini eksik ya da hatalı yaptınız..!");
     }
 }
Example #4
0
 private void btnOnay_Click(object sender, EventArgs e)
 {
     anapanel = new Anapanel();
     if (txtIslem.Text != "") //&& txtUcret.Text != ""
     {
         if (((dataGridView1.SelectedRows[0].Cells[0].Value.ToString())) != "")
         {
             SqlConnection con = new SqlConnection("Server=desktop-2knss9k\\sql_2014;Database=oto_teknik_servis_PROJE;Integrated Security=true");
             try
             {
                 con.Open();
                 String     str = "update FATURA_TAMIR set Fid=@fid,Islem=@islem,Ucret=@ucret,TeslimTarih=@tarih where FTid='" + dataGridView1.SelectedRows[0].Cells[6].Value.ToString() + "'";
                 SqlCommand cmd = new SqlCommand(str, con);
                 cmd.Parameters.Add(new SqlParameter("@fid", dataGridView1.SelectedRows[0].Cells[7].Value.ToString()));
                 cmd.Parameters.Add(new SqlParameter("@islem", txtIslem.Text));
                 cmd.Parameters.Add(new SqlParameter("@tarih", DateTime.Now.ToShortDateString()));
                 cmd.Parameters.Add(new SqlParameter("@ucret", txtUcret.Text));
                 cmd.ExecuteNonQuery();
                 con.Close();
                 MessageBox.Show("Güncelleme başarılı..");
                 anapanel.Show();
                 this.Hide();
             }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.Message);
             }
         }
         else
         {
             MessageBox.Show("Tablodan seçim yapınız..!");
         }
     }
     else
     {
         MessageBox.Show("Yapılan İşlem Boş Geçilemez..!");
     }
 }
Example #5
0
 private void btnIptal_Click(object sender, EventArgs e)
 {
     anapanel = new Anapanel();
     anapanel.Show();
     this.Hide();
 }