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;
}
}
