Araç Servis Randevu Sistemi Takip Programı C#

Araç Servis Randevu Sistemi Takip Programı C#

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM1 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form2 frm2;
public Form3 frm3;
public Form4 frm4;
public Form5 frm5;

public Form1()
{

InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm4 = new Form4();
frm5 = new Form5();
frm2.frm1 = this;
frm3.frm1 = this;
frm4.frm1 = this;
frm5.frm1 = this;
}

public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=data.mdb");
public OleDbCommand kmt = new OleDbCommand();
public OleDbDataAdapter adtr = new OleDbDataAdapter();
public DataSet dtst = new DataSet();

public void musara()
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From musbil", bag);
if (frm2.textBox1.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from musbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "musbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From musbil" +
" where(MüsteriNo like ‘%" + frm2.textBox1.Text + "%’ )";
dtst.Clear();
adtr.Fill(dtst, "musbil");
bag.Close();
}

public void randevuara()
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From randevubil", bag);
if (frm3.textBox1.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from randevubil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "randevubil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From randevubil" +
" where(Plaka like ‘%" + frm3.textBox1.Text + "%’ )";
dtst.Clear();
adtr.Fill(dtst, "randevubil");
bag.Close();
}

public void muslistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From musbil", bag);
adtr.Fill(dtst, "musbil");
frm2.dataGridView1.DataMember = "musbil";
frm2.dataGridView1.DataSource = dtst;
adtr.Dispose();
bag.Close();
}

public void randevulistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From randevubil", bag);
adtr.Fill(dtst, "randevubil");
frm3.dataGridView1.DataMember = "randevubil";
frm3.dataGridView1.DataSource = dtst;
adtr.Dispose();
bag.Close();
}

public void combo()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from musbil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
frm5.comboBox2.Items.Add(oku[2].ToString());
frm5.comboBox3.Items.Add(oku[3].ToString());
}
bag.Close();
oku.Dispose();
frm5.comboBox1.Sorted = true;
frm5.comboBox2.Sorted = true;
frm5.comboBox3.Sorted = true;

}

private void button3_Click(object sender, EventArgs e)
{
Application.Exit();
}

private void button2_Click(object sender, EventArgs e)
{
frm2.ShowDialog();
}

private void button1_Click(object sender, EventArgs e)
{
frm3.ShowDialog();
}

private void Form1_Load(object sender, EventArgs e)
{

}
}
}

[/code]

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM2 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
public partial class Form2 : Form
{
public Form1 frm1;
string ara;
public Form2()
{
InitializeComponent();
}

private void Form2_Load(object sender, EventArgs e)
{
frm1.dtst.Clear();
frm1.muslistele();
}

private void button1_Click(object sender, EventArgs e)
{
frm1.frm4.ShowDialog();
}

private void button5_Click(object sender, EventArgs e)
{
this.Close();
}

private void button2_Click(object sender, EventArgs e)
{
try
{
foreach (DataGridViewCell hucre in dataGridView1.SelectedCells)
{
ara = hucre.Value.ToString();
}
DialogResult cevap;
cevap = MessageBox.Show("Kaydı silmek istediğinizden eminmisiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE from musbil WHERE MüsteriNo=’" + ara + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Clear();
frm1.muslistele();
}
}
catch
{
;
}
}

private void button3_Click(object sender, EventArgs e)
{
frm1.musara();
}

private void button4_Click(object sender, EventArgs e)
{
frm1.dtst.Clear();
frm1.muslistele();
}

}
}

[/code]

FORM3 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
public partial class Form3 : Form
{
public Form1 frm1;
string ara;
public Form3()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
frm1.frm5.ShowDialog();
}

private void button5_Click(object sender, EventArgs e)
{
this.Close();
}

private void Form3_Load(object sender, EventArgs e)
{
frm1.dtst.Clear();
frm1.randevulistele();
}

private void button2_Click(object sender, EventArgs e)
{
try
{
foreach (DataGridViewCell hucre in dataGridView1.SelectedCells)
{
ara = hucre.Value.ToString();

}
DialogResult cevap;
cevap = MessageBox.Show("Kaydı silmek istediğinizden eminmisiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE from randevubil WHERE Plaka=’" + ara + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Clear();
frm1.randevulistele();

}
}
catch
{
;
}
}

private void button3_Click(object sender, EventArgs e)
{
frm1.randevuara();
}

private void button4_Click(object sender, EventArgs e)
{
frm1.dtst.Clear();
frm1.randevulistele();
}

}
[/code]

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM4 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
public partial class Form4 : Form
{
public Form1 frm1;
public Form4()
{
InitializeComponent();
}

private void button2_Click(object sender, EventArgs e)
{
this.Close();
}

private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" )
{
try
{

frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO musbil(MüsteriNo,Cinsiyet,Ad,Soyad,Adres,İlce,Sehir,AdresTipi,Telefonİs,TelefonEv,GSM,E_Posta) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + textBox4.Text + "’,’" + textBox5.Text + "’,’" + textBox6.Text + "’,’" + textBox7.Text + "’,’" + textBox8.Text + "’,’" + textBox9.Text + "’,’" + textBox10.Text + "’,’" + textBox11.Text + "’,’" + textBox12.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
MessageBox.Show("Kayıt işlemi tamamlandı ! ");
frm1.dtst.Clear();
frm1.muslistele();
}
catch
{
;
}
}
else
{
MessageBox.Show("Müsteri No’yu girmelisiniz !");
}

}
}
[/code]

FORM5 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
public partial class Form5 : Form
{
public Form1 frm1;
public Form5()
{
InitializeComponent();
}

private void button2_Click(object sender, EventArgs e)
{
this.Close();
}

private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text != "")
{
try
{

frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO randevubil(RandevuTarihi,RandevuSaati,AltRanTarihi,AltRanSaati,Plaka,MüsteriAd,MüsteriSoyad,AracTipi,AracSasiNo,KilometreDurumu,ModelYili) VALUES (‘" + dateTimePicker1.Text + "’,’" + textBox1.Text + "’,’" + dateTimePicker2.Text + "’,’" + textBox2.Text + "’,’" + comboBox1.Text + "’,’" + comboBox2.Text + "’,’" + comboBox3.Text + "’,’" + textBox3.Text + "’,’" + textBox4.Text + "’,’" + textBox5.Text + "’,’" + dateTimePicker3.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
for (int i = 0; i < this.Controls.Count – 1; i++)
{
if (this.Controls[i] is TextBox) this.Controls[i].Text = "";
if (this.Controls[i] is ComboBox) this.Controls[i].Text = "";
}

MessageBox.Show("Kayıt işlemi tamamlandı ! ");
frm1.dtst.Clear();
frm1.randevulistele();
}
catch
{
;
}
}

}

private void Form5_Load(object sender, EventArgs e)
{
frm1.combo();
}

}
[/code]

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

Projeyi İNDİR