Exemplo n.º 1
0
        private void btnSenet_Click(object sender, EventArgs e)
        {
            Senet frmSenet = new Senet();

            frmSenet.Show();
        }
Exemplo n.º 2
0
        public void Duzenle()
        {
            Nakit nkt   = new Nakit();
            Cek   cek   = new Cek();
            Senet senet = new Senet();

            if (this.dataGridView1.CurrentRow.Cells[2].Value.ToString().Trim() == "Nakit")
            {
                int index = nkt.cbFirma.FindString(this.dataGridView1.CurrentRow.Cells[3].Value.ToString().Trim());
                nkt.dtTarih.Text     = this.dataGridView1.CurrentRow.Cells[1].Value.ToString().Trim();
                nkt.txtTutar.Text    = this.dataGridView1.CurrentRow.Cells[4].Value.ToString().Trim();
                nkt.txtAciklama.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString().Trim();

                nkt.cbFirma.SelectedIndex = index;

                nkt.lblGuncelle.Text = "guncelle";
                nkt.lblNakitid.Text  = this.dataGridView1.CurrentRow.Cells[0].Value.ToString().Trim();

                nkt.Show();
            }
            else if (this.dataGridView1.CurrentRow.Cells[2].Value.ToString().Trim() == "Çek")
            {
                SqlConnection conn = new SqlConnection(gnl.baglan);
                conn.Open();

                SqlCommand cmd2 = new SqlCommand("SELECT id FROM firma WHERE firmaadi=@firmaadi", conn);
                cmd2.Parameters.AddWithValue("@firmaadi", cbFirmaAdi.Text);
                SqlDataAdapter da = new SqlDataAdapter(cmd2);
                DataTable      dt = new DataTable();
                da.Fill(dt);

                int id = Convert.ToInt32(dt.Rows[0][0]);

                int cekid = Convert.ToInt32(this.dataGridView1.CurrentRow.Cells[0].Value.ToString().Trim());

                string     sorgu = "SELECT cek.id,cek.tarih,cek.cekno,cek.vade,cek.odemeyeri,cek.banka,cek.sube,cek.hno, cek.tutar,cek.aciklama,firma.firmaadi FROM cek INNER JOIN firma ON firma.id=cek.firma_id WHERE firma_id = @id AND cek.id=@cekid";
                SqlCommand cmd3  = new SqlCommand(sorgu, conn);
                cmd3.Parameters.AddWithValue("@id", id);
                cmd3.Parameters.AddWithValue("@cekid", cekid);
                SqlDataAdapter da3 = new SqlDataAdapter(cmd3);
                DataTable      dt3 = new DataTable();
                da3.Fill(dt3);

                int index = cek.cbFirma.FindString(this.dataGridView1.CurrentRow.Cells[3].Value.ToString().Trim());

                cek.cbFirma.SelectedIndex = index;
                cek.dtTarih.Text          = dt3.Rows[0][1].ToString();
                cek.txtCekno.Text         = dt3.Rows[0][2].ToString();
                cek.dtVade.Text           = dt3.Rows[0][3].ToString();
                cek.txtOdemeyeri.Text     = dt3.Rows[0][4].ToString();
                cek.txtBanka.Text         = dt3.Rows[0][5].ToString();
                cek.txtSube.Text          = dt3.Rows[0][6].ToString();
                cek.txtHesapno.Text       = dt3.Rows[0][7].ToString();
                cek.txtTutar.Text         = dt3.Rows[0][8].ToString();
                cek.txtAciklama.Text      = dt3.Rows[0][9].ToString();


                cek.lblGuncelle.Text = "guncelle";
                cek.lblid.Text       = this.dataGridView1.CurrentRow.Cells[0].Value.ToString().Trim();


                cek.Show();
            }

            else if (this.dataGridView1.CurrentRow.Cells[2].Value.ToString().Trim() == "Senet")
            {
                SqlConnection conn = new SqlConnection(gnl.baglan);
                conn.Open();

                SqlCommand cmd2 = new SqlCommand("SELECT id FROM firma WHERE firmaadi=@firmaadi", conn);
                cmd2.Parameters.AddWithValue("@firmaadi", cbFirmaAdi.Text);
                SqlDataAdapter da = new SqlDataAdapter(cmd2);
                DataTable      dt = new DataTable();
                da.Fill(dt);

                int id = Convert.ToInt32(dt.Rows[0][0]);

                int senetid = Convert.ToInt32(this.dataGridView1.CurrentRow.Cells[0].Value.ToString().Trim());


                string     sorgu = "SELECT senet.id,senet.tarih,senet.senetno,senet.vade,senet.odemeyeri,senet.kefil,senet.tutar,senet.aciklama,firma.firmaadi FROM senet INNER JOIN firma ON firma.id=senet.firma_id WHERE firma_id = @id AND senet.id=@senetid";
                SqlCommand cmd3  = new SqlCommand(sorgu, conn);
                cmd3.Parameters.AddWithValue("@id", id);
                cmd3.Parameters.AddWithValue("@senetid", senetid);
                SqlDataAdapter da3 = new SqlDataAdapter(cmd3);
                DataTable      dt3 = new DataTable();
                da3.Fill(dt3);

                int index = cek.cbFirma.FindString(this.dataGridView1.CurrentRow.Cells[3].Value.ToString().Trim());

                senet.cbFirma.SelectedIndex = index;
                senet.dtTarih.Text          = dt3.Rows[0][1].ToString();
                senet.txtSenetno.Text       = dt3.Rows[0][2].ToString();
                senet.dtVade.Text           = dt3.Rows[0][3].ToString();
                senet.txtOdemeyeri.Text     = dt3.Rows[0][4].ToString();
                senet.txtKefil.Text         = dt3.Rows[0][5].ToString();
                senet.txtTutar.Text         = dt3.Rows[0][6].ToString();
                senet.txtAciklama.Text      = dt3.Rows[0][7].ToString();


                senet.lblGuncelle.Text = "guncelle";
                senet.lblid.Text       = this.dataGridView1.CurrentRow.Cells[0].Value.ToString().Trim();


                senet.Show();
            }
        }