private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
arcekle ekle = new arcekle();
ekle.gncid.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();
ekle.ruhno.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();
ekle.marka.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();
ekle.seri.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();
ekle.model.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();
ekle.yil.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString();
ekle.cmbyakit.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString();
ekle.cmbvites.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString();
ekle.km.Text = dataGridView1.CurrentRow.Cells[8].Value.ToString();
ekle.kasatipi.Text = dataGridView1.CurrentRow.Cells[9].Value.ToString();
ekle.mhacim.Text = dataGridView1.CurrentRow.Cells[10].Value.ToString();
ekle.mguc.Text = dataGridView1.CurrentRow.Cells[11].Value.ToString();
ekle.cmbcekis.Text = dataGridView1.CurrentRow.Cells[12].Value.ToString();
ekle.renk.Text = dataGridView1.CurrentRow.Cells[13].Value.ToString();
ekle.cmbgaranti.Text = dataGridView1.CurrentRow.Cells[14].Value.ToString();
ekle.cmbuyruk.Text = dataGridView1.CurrentRow.Cells[15].Value.ToString();
ekle.plakano.Text = dataGridView1.CurrentRow.Cells[16].Value.ToString();
ekle.cmbkimden.Text = dataGridView1.CurrentRow.Cells[17].Value.ToString();
ekle.cmbtakas.Text = dataGridView1.CurrentRow.Cells[18].Value.ToString();
ekle.cmbdurum.Text = dataGridView1.CurrentRow.Cells[19].Value.ToString();
ekle.rsmpth.Text = dataGridView1.CurrentRow.Cells[20].Value.ToString();
ekle.rprpth.Text = dataGridView1.CurrentRow.Cells[21].Value.ToString();
ekle.fiyat.Text = dataGridView1.CurrentRow.Cells[22].Value.ToString();
ekle.kcncshp.Text = dataGridView1.CurrentRow.Cells[23].Value.ToString();
ekle.Show();
this.Hide();
}
private void sat_Click(object sender, EventArgs e)
{
try
{
arcekle ekle = new arcekle();
if (stcid.Text == "")
{
MessageBox.Show("Lütfen Aracın ID'sini Giriniz! \nNot : Aracın ID'sini Araçları Listele Kısmından Öğrenebilirsiniz !");
}
else
{
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BuySellDB.accdb");
cmd = new OleDbCommand();
con.Open();
da = new OleDbDataAdapter("Select *From satilanaraclar", con);
cmd.Connection = con;
cmd.CommandText = "insert into satilanaraclar (ruhsatno,marka,seri,model,yil,yakit,vites,km,kasatipi,motorhacmi,motorgucu,cekis,renk,garanti,plakauyruk,plakano,kimden,takas,durumu,satistarihi,satansahis,mustis,mustsoyis,musttc,musttel,mustadr,goruntupath,raporpath,fiyat,kacincisahip) values ('" + ruhno.Text + "','" + marka.Text + "','" + seri.Text + "','" + model.Text + "','" + yil.Text + "','" + cmbyakit.Text + "','" + cmbvites.Text + "','" + km.Text + "','" + kasatipi.Text + "','" + mhacim.Text + "','" + mguc.Text + "','" + cmbcekis.Text + "','" + renk.Text + "','" + cmbgaranti.Text + "','" + cmbuyruk.Text + "','" + plakano.Text + "','" + cmbkimden.Text + "','" + cmbtakas.Text + "','" + cmbdurum.Text + "','" + tarih.Text + "','" + stnshs.Text + "','" + muisim.Text + "','" + musoyisim.Text + "','" + mutc.Text + "','" + mutel.Text + "','" + muadr.Text + "','" + rsmpth.Text + "','" + rprpth.Text + "','" + fiyat.Text + "','" + kcncshp.Text + "')";
cmd.ExecuteNonQuery();
con.Close();
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BuySellDB.accdb");
cmd = new OleDbCommand();
con.Open();
cmd.Connection = con;
cmd.CommandText = "delete from araceklevegoruntule where arackimlik=" + stcid.Text + "";
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Aracınız Satış Veri Tabanına Eklendi !", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information);
ruhno.Clear();
marka.Clear();
seri.Clear();
model.Clear();
yil.Clear();
cmbyakit.SelectedIndex = 0;
cmbvites.SelectedIndex = 0;
km.Clear();
kasatipi.Clear();
mhacim.Clear();
mguc.Clear();
cmbcekis.SelectedIndex = 0;
renk.Clear();
cmbgaranti.SelectedIndex = 0;
cmbuyruk.SelectedIndex = 0;
plakano.Clear();
cmbkimden.SelectedIndex = 0;
cmbtakas.SelectedIndex = 0;
cmbdurum.SelectedIndex = 0;
kcncshp.Clear();
rsmpth.Clear();
rprpth.Clear();
fiyat.Clear();
muisim.Clear();
musoyisim.Clear();
mutc.Clear();
mutel.Clear();
muadr.Clear();
stcid.Clear();
stnshs.Clear();
}
}
catch
{
MessageBox.Show("Aracınız Satış Veri Tabanına Eklenemedi !", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void arceklcik_Click(object sender, EventArgs e)
{
arcekle aracekle = new arcekle();
aracekle.Show();
}
