private void btnYeniTamam_Click(object sender, EventArgs e) { if (txbYeniKullaniciAdi.Text != "" && txbYeniSifre.Text != "" && txbYeniSifreTekrar.Text != "" && txbYeniSifre.Text == txbYeniSifreTekrar.Text) { _pekpanDal.ExecuteNonQuerySilent("insert into TARA_Kullanicilar (KullaniciAdi,Sifre,Mode) values('" + txbYeniKullaniciAdi.Text + "','" + txbYeniSifre.Text + "',2)"); listLogins(); pnlYeni.Visible = false; } else { MessageBox.Show("Lütfen kullanıcı adınızı ve şifrenizi doğru yazdığınızdan emin olun"); } }
private void btnSil_Click(object sender, EventArgs e) { DialogResult dialog = MessageBox.Show("Seçili dizayn silinecektir!\n Emin misniz?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog == DialogResult.Yes) { int designKimlik = Convert.ToInt32(_pekpanDal.ExecuteScalarStr("select ID from TARA_PalDesign where Aciklama= '" + grDesigns.CurrentRow.Cells[1].Value.ToString() + "'")); _pekpanDal.ExecuteNonQuerySilent("DELETE TARA_PalCells where DesignID =" + designKimlik); _pekpanDal.ExecuteNonQuerySilent("DELETE TARA_PalDesign where Aciklama='" + grDesigns.CurrentRow.Cells[1].Value.ToString() + "'"); _pekpanDal.ExecuteNonQuerySilent("DELETE TARA_PalMarka where DesignID =" + designKimlik); listDesigns(); } }
private void saveDesign() { _pekpanDal.ExecuteNonQuerySilent("Insert Into TARA_PalDesign(RecTime, Aciklama, XBaslangic, YBaslangic, XOffset, YOffset, PaletZ, BoyMin, BoyMax, GenislikMin, GenislikMax, Tork, Tasarlayan) Values (GETDATE(),'" + txAd.Text + "', " + udbx.Value + ", " + udby.Value + ", " + udox.Value + ", " + udoy.Value + ", " + udz.Value + ", " + udboy1.Value + ", " + udboy2.Value + ", " + udgen1.Value + ", " + udgen2.Value + ", " + udTork.Value + ", '" + _kullaniciAdi + "')"); //" + katProdCount() + ", int designID = Convert.ToInt32(_pekpanDal.ExecuteScalarStr("select ID from TARA_PalDesign where Aciklama ='" + txAd.Text + "'")); for (int i = 0; i < Convert.ToInt32(_pekpanDal.ExecuteScalarStr("select count(*) from TARA_Markalar")); i++) { if (gv.Rows[i].Cells[1].Value != null) { _pekpanDal.ExecuteNonQuerySilent("Insert Into TARA_PalMarka (DesignID,MarkaAciklama) values (" + designID + ",'" + gv.Rows[i].Cells[1].Value + "')"); } } for (int i = 1; i <= 12; i++) { CheckBox cb = ProdCheckBox(i); if (cb != null) { if (cb.Checked) { NumericUpDown ud = ProdUpDown(i); int pno = (int)ud.Value; Button bRot = ProdButton(i); int rot = Convert.ToInt32(bRot.Text); int row = i % 4; int col = 1; if ((i >= 5) && (i < 9)) { col = 2; } else if ((i >= 9) && (i < 13)) { col = 3; } else if (i >= 13) { col = 4; } _pekpanDal.ExecuteNonQuerySilent("Insert Into TARA_PalCells(DesignID, PanelNo, RowNo, ColNo, ProdNo, Rot) Values (" + designID + ", " + i + ", " + row + ", " + col + ", " + pno + ", " + rot + ")"); } } DialogResult = DialogResult.OK; } }