Kütüphane Takip Programı ( Kapsamlı ) C#.NET(CNET)

Kütüphane Takip Programı C#.NET(CNET)…

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

Kayıt İşlemi Buttonu’na tıkladığımız da karşımıza gelen form

Burada girilmesi zorunlu olan bilgiler var örneğin barkod numarası gibi programda kullandığımız bir yöntemle daha önceden girilmiş bir barkod numarası varsa eğer hata mesajı ile kullanıcıyı uyarmaktayız.
Anaform da bulunun Okuyucu Kayıt buttonuna tıkladığımız zaman karşımıza gelen form aşağıdaki gibidir.

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

Bu formda da girilmesi zorunlu olan bilgiler var bu bilgiler *(yıldız)’la işaretlenmiştir,boş geçilmeye çalışıldığında hata vermektedir.
Anaform da bulunun Okuyucu Liste buttonuna tıkladığımız zaman karşımıza gelen form aşağıdaki gibidir.

Burada kayıtlarımızı görmekteyiz yalan burada silme işlemi için uygulanan yöntem TextBox’ların Change özelliğine yazdığımız kodlar sayesinde oldu girilen Ad ve Soyadın bulunduğu bir bilgi var ise SİL buttonuna tıklağomız zaman direkmen silmekteyiz.
Anaform da bulunun Kitap Liste buttonuna tıkladığımız zaman karşımıza gelen form aşağıdaki gibidir.

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

Okuyucu Liste’sinde olduğu gibi aynı işlem burada da uygulanmıştır,bulunan bir Barkod numarası girildiğinde SİL buttonuna bastığımızda bilgisi silmiş oluyoruz.
Anaform da bulunun Emanet Kitaplar buttonuna tıkladığımız karşımıza gelen formda Teslim Al buttonuna tıkladığımız zaman karşımıza gelen form aşağıdaki gibidir.

Burada ise emanet alınan kitapların geri teslim durumları göz önünde bulunduruluyor okuyucu kitabı geri nasıl bırakmış onu görmekteyiz. Programımız böyle çalışmaktadır şimdi Kod satırlarına geçelim.

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 kutuphane_takip_1._0
{
public partial class Form1 : Form
{
public Form2 frm2;
public Form3 frm3;
public Form4 frm4;
public Form5 frm5;
public Form6 frm6;
public Form7 frm7;
public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm4 = new Form4();
frm5 = new Form5();
frm6 = new Form6();
frm7 = new Form7();
frm2.frm1 = this;
frm3.frm1 = this;
frm4.frm1 = this;
frm5.frm1 = this;
frm6.frm1 = this;
frm7.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 int satir;
public Boolean durum = false;
string barkodno, no, adsoyad, kitapad, kitapyazar, tarih;

public void kitaplistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil WHERE StokSayisi>0", bag);
adtr.Fill(dtst, "kitapbil");
dataGridView1.DataSource = dtst.Tables["kitapbil"];
adtr.Dispose();
bag.Close();
}
public void kitaplistele2()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", bag);
adtr.Fill(dtst, "kitapbil");
frm5.dataGridView1.DataSource = dtst.Tables["kitapbil"];
adtr.Dispose();
bag.Close();
}
public void okuyuculistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil ", bag);
adtr.Fill(dtst, "okuyucubil");
dataGridView2.DataSource = dtst.Tables["okuyucubil"];
adtr.Dispose();
bag.Close();
}
public void okuyuculistele2()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil ", bag);
adtr.Fill(dtst, "okuyucubil");
frm4.dataGridView1.DataSource = dtst.Tables["okuyucubil"];
adtr.Dispose();
bag.Close();
}
public void emanetlistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From emanetbil ", bag);
adtr.Fill(dtst, "emanetbil");
frm6.dataGridView1.DataSource = dtst.Tables["emanetbil"];
adtr.Dispose();
bag.Close();
}
public void kitapcombo()
{
int durum;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select YazarAdi,YayinEvi,KitapTuru,TeminBicimi from kitapbil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
durum = frm2.comboBox1.FindString(oku[0].ToString());
if(durum==-1 ) frm2.comboBox1.Items.Add(oku[0].ToString());
durum = frm2.comboBox2.FindString(oku[1].ToString());
if (durum == -1) frm2.comboBox2.Items.Add(oku[1].ToString());
durum = frm2.comboBox3.FindString(oku[2].ToString());
if (durum == -1) frm2.comboBox3.Items.Add(oku[2].ToString());
durum = frm2.comboBox3.FindString(oku[2].ToString());
if (durum == -1) frm2.comboBox3.Items.Add(oku[2].ToString());
durum = frm2.comboBox4.FindString(oku[3].ToString());
if (durum == -1) frm2.comboBox4.Items.Add(oku[3].ToString());
}
bag.Close();
oku.Dispose();
}
public void okuyucucombo()
{
int durum;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select Sinifi,DogumYeri from okuyucubil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
durum = frm3.comboBox1.FindString(oku[0].ToString());
if (durum == -1) frm3.comboBox1.Items.Add(oku[0].ToString());
durum = frm3.comboBox2.FindString(oku[1].ToString());
if (durum == -1) frm3.comboBox2.Items.Add(oku[1].ToString());
}
bag.Close();
oku.Dispose();
}
public void barkodkontrol()
{
durum =false;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select BarkodNo from kitapbil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{

if ( frm2.textBox1.Text==oku[0].ToString()) durum=true;

}
bag.Close();
oku.Dispose();
}
public void nokontrol()
{
durum = false;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select TcKimlik,Nosu from okuyucubil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{

if (frm3.textBox1.Text == oku[0].ToString() || frm3.textBox3.Text == oku[1].ToString()) durum = true;

}
bag.Close();
oku.Dispose();
}
private void Form1_Load(object sender, EventArgs e)
{
kitaplistele();
okuyuculistele();
dataGridView1.Columns[0].HeaderText = "Barkod No";
dataGridView1.Columns[1].HeaderText = "Kitap Adı";
dataGridView1.Columns[2].HeaderText = "Yazar Adı";
dataGridView1.Columns[3].HeaderText = "Yayın Evi";
dataGridView1.Columns[4].HeaderText = "Kitap Türü";
dataGridView1.Columns[5].HeaderText = "Temin Biçimi";
dataGridView1.Columns[6].HeaderText = "Temin Tarihi";
dataGridView1.Columns[7].HeaderText = "Stok Sayısı";
dataGridView1.Columns[0].Width = 65;
dataGridView1.Columns[1].Width = 95;
dataGridView1.Columns[2].Width = 95;
dataGridView1.Columns[3].Width = 90;
dataGridView1.Columns[4].Width = 60;
dataGridView1.Columns[5].Width = 70;
dataGridView1.Columns[6].Width = 85;
dataGridView1.Columns[7].Width = 55;
dataGridView2.Columns.RemoveAt(10);
dataGridView2.Columns.RemoveAt(9);
dataGridView2.Columns.RemoveAt(8);
dataGridView2.Columns.RemoveAt(7);
dataGridView2.Columns.RemoveAt(6);
dataGridView2.Columns.RemoveAt(5);
dataGridView2.Columns.RemoveAt(4);
dataGridView2.Columns.RemoveAt(0);
dataGridView2.Columns[0].HeaderText = "Adı Soyadı";
dataGridView2.Columns[1].HeaderText = "Sınıfı";
dataGridView2.Columns[2].HeaderText = "No";
dataGridView2.Columns[3].HeaderText = "Kitap Sayısı";
dataGridView2.Columns[4].HeaderText = "Emanet Sayısı";
dataGridView2.Columns[1].Width = 35;
dataGridView2.Columns[2].Width = 40;
dataGridView2.Columns[3].Width = 46;
dataGridView2.Columns[4].Width = 46;
}
private void btnKitapkayit_Click(object sender, EventArgs e)
{
frm2.ShowDialog();
}
private void btnOkuyucukayit_Click(object sender, EventArgs e)
{
frm3.ShowDialog();
}

private void btnOkuyuculiste_Click(object sender, EventArgs e)
{
frm4.ShowDialog();
}
private void btnKitapliste_Click(object sender, EventArgs e)
{
frm5.ShowDialog();
}
private void btnEmanetkitap_Click(object sender, EventArgs e)
{
emanetlistele();
frm6.ShowDialog();
}
private void txtAdSoyadAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil", bag);
if (txtAdSoyadAra.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from okuyucubil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "okuyucubil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From okuyucubil" +
" where(AdiSoyadi like ‘%" + txtAdSoyadAra.Text + "%’ )";
dtst.Tables["okuyucubil"].Clear();
adtr.Fill(dtst, "okuyucubil");
bag.Close();
}
private void txtOkulNoAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil", bag);
if (txtOkulNoAra.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from okuyucubil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "okuyucubil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From okuyucubil" +
" where(Nosu like ‘%" + txtOkulNoAra.Text+ "%’ )";
dtst.Tables["okuyucubil"].Clear();
adtr.Fill(dtst, "okuyucubil");
bag.Close();
}
private void txtSinifAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil", bag);
if (txtSinifAra.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from okuyucubil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "okuyucubil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From okuyucubil" +
" where(Sinifi like ‘%" + txtSinifAra.Text + "%’ )";
dtst.Tables["okuyucubil"].Clear();
adtr.Fill(dtst, "okuyucubil");
bag.Close();
}
private void txtBarkodAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", bag);
if (txtBarkodAra.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from kitapbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "kitapbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From kitapbil" +
" where(BarkodNo like ‘%" + txtBarkodAra.Text + "%’ )";
dtst.Tables["kitapbil"].Clear();
adtr.Fill(dtst, "kitapbil");
bag.Close();
}
private void txtKitapadiAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", bag);
if (txtKitapadiAra.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from kitapbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "kitapbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From kitapbil" +
" where(KitapAdi like ‘%" + txtKitapadiAra.Text + "%’ )";
dtst.Tables["kitapbil"].Clear();
adtr.Fill(dtst, "kitapbil");
bag.Close();
}
private void txtKitapyazariAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", bag);
if (txtKitapyazariAra.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from kitapbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "kitapbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From kitapbil" +
" where(YazarAdi like ‘%" + txtKitapyazariAra.Text + "%’ )";
dtst.Tables["kitapbil"].Clear();
adtr.Fill(dtst, "kitapbil");
bag.Close();
}
private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

}
private void dataGridView2_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
for (satir = 0; satir < dataGridView2.Rows.Count; satir++)
{

if (dataGridView2.Rows[satir].Cells[0].Selected == true || dataGridView2.Rows[satir].Cells[1].Selected == true || dataGridView2.Rows[satir].Cells[2].Selected == true || dataGridView2.Rows[satir].Cells[3].Selected == true || dataGridView2.Rows[satir].Cells[4].Selected == true)
{
break;

}
}
textBox2.Text = dataGridView2.Rows[satir].Cells[0].Value.ToString();
textBox3.Text = dataGridView2.Rows[satir].Cells[3].Value.ToString();
textBox4.Text = dataGridView2.Rows[satir].Cells[4].Value.ToString();
no = dataGridView2.Rows[satir].Cells[2].Value.ToString();
adsoyad = dataGridView2.Rows[satir].Cells[0].Value.ToString();

}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

}
private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
for (satir = 0; satir < dataGridView1.Rows.Count; satir++)
{

if (dataGridView1.Rows[satir].Cells[0].Selected == true || dataGridView1.Rows[satir].Cells[1].Selected == true || dataGridView1.Rows[satir].Cells[2].Selected == true || dataGridView1.Rows[satir].Cells[3].Selected == true || dataGridView1.Rows[satir].Cells[4].Selected == true || dataGridView1.Rows[satir].Cells[5].Selected == true || dataGridView1.Rows[satir].Cells[6].Selected == true || dataGridView1.Rows[satir].Cells[7].Selected == true)
{
break;

}
}
textBox1.Text = dataGridView1.Rows[satir].Cells[1].Value.ToString();
barkodno = dataGridView1.Rows[satir].Cells[0].Value.ToString();
kitapad = dataGridView1.Rows[satir].Cells[1].Value.ToString();
kitapyazar = dataGridView1.Rows[satir].Cells[2].Value.ToString();
}
private void btnEmanetKaydet_Click(object sender, EventArgs e)
{

try
{
if (textBox1.Text != "" &amp;amp;amp;&amp;amp;amp; textBox2.Text != "")
{
tarih = DateTime.Now.ToShortDateString();
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "INSERT INTO emanetbil(AdiSoyadi,Nosu,BarkodNo,KitapAdi,KitapYazari,BaslangicTarihi,BitisTarihi,EmanetDurumu) VALUES (‘" + adsoyad + "’,’" + no + "’,’" + barkodno + "’,’" + kitapad + "’,’" + kitapyazar + "’,’" + tarih + "’,’" + dateTimePicker1.Text + "’,’" + "Teslim Edilmedi" + "’) ";
kmt.ExecuteNonQuery();
kmt.CommandText = "UPDATE okuyucubil SET KitapSayisi=KitapSayisi+1,EmanetSayisi=EmanetSayisi+1 WHERE Nosu=’" + no+ "’";
kmt.ExecuteNonQuery();
kmt.CommandText = "UPDATE kitapbil SET StokSayisi=StokSayisi-1 WHERE BarkodNo=’" + barkodno + "’";
kmt.ExecuteNonQuery();
kmt.Dispose();
bag.Close();
dtst.Tables["okuyucubil"].Clear();
dtst.Tables["kitapbil"].Clear();
okuyuculistele();
kitaplistele();

MessageBox.Show("Kayıt işlemi tamamlandı !");
}
else
{
MessageBox.Show("Listeden seçim yapınız !");
}
}
catch
{
;
}
}
private void Cikis_Click(object sender, EventArgs e)
{
Application.Exit();
}
}
}

[/code]

FORM2 İçerisine Yazılacak Kodlar… 

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

[code language=”CSharp”]
namespace kutuphane_takip_1._0
{
public partial class Form2 : Form
{
public Form1 frm1;
public Form2()
{
InitializeComponent();
}

private void Form2_Load(object sender, EventArgs e)
{
frm1.kitapcombo();
}

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

private void btnKaydet_Click(object sender, EventArgs e)
{
frm1.barkodkontrol();
if (frm1.durum == false)
{
if (textBox2.Text != "" &amp;amp;amp;&amp;amp;amp; textBox2.Text != "" &amp;amp;amp;&amp;amp;amp; textBox3.Text != "" &amp;amp;amp;&amp;amp;amp; comboBox1.Text != "" &amp;amp;amp;&amp;amp;amp; comboBox2.Text != "" &amp;amp;amp;&amp;amp;amp; comboBox3.Text != "")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO kitapbil(BarkodNo,KitapAdi,YazarAdi,YayinEvi,KitapTuru,TeminBicimi,TeminTarihi,StokSayisi) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + comboBox1.Text + "’,’" + comboBox2.Text + "’,’" + comboBox3.Text + "’,’" + comboBox4.Text + "’,’" + dateTimePicker1.Text + "’,’" + textBox3.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();

for (int i = 0; i < this.Controls.Count; i++)
{
if (this.Controls[i] is TextBox) this.Controls[i].Text = "";
if (this.Controls[i] is ComboBox) this.Controls[i].Text = "";
}
frm1.dtst.Tables["kitapbil"].Clear();
frm1.kitaplistele();
frm1.kitapcombo();
MessageBox.Show("Kayıt işlemi tamamlandı !");
}
else MessageBox.Show("Boş alanları doldurunuz !");
}
else MessageBox.Show("Girmiş olduğunuz Barkod No kullanılmış");
}
}
}
[/code]

FORM3 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
namespace kutuphane_takip_1._0
{
public partial class Form3 : Form
{
public Form1 frm1;
public Form3()
{
InitializeComponent();
}

private void Form3_Load(object sender, EventArgs e)
{
frm1.okuyucucombo();
}

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

private void btnKaydet_Click(object sender, EventArgs e)
{
frm1.nokontrol();
if (frm1.durum == false)
{
if (textBox1.Text != "" &amp;amp;amp;&amp;amp;amp; textBox2.Text != "" &amp;amp;amp;&amp;amp;amp; textBox3.Text != "")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO okuyucubil(TcKimlik,AdiSoyadi,Sinifi,Nosu,DogumTarihi,DogumYeri,Telefon,Eposta,UyelikTarihi,Cinsiyet,Adres) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + comboBox1.Text + "’,’" + textBox3.Text + "’,’" + dateTimePicker1.Text + "’,’" + comboBox2.Text + "’,’" + textBox4.Text + "’,’" + textBox5.Text + "’,’" + dateTimePicker2.Text + "’,’" + comboBox3.Text + "’,’" + textBox6.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
for (int i = 0; i < this.Controls.Count; i++)
{
if (this.Controls[i] is TextBox) this.Controls[i].Text = "";
if (this.Controls[i] is ComboBox) this.Controls[i].Text = "";
}
frm1.dtst.Tables["okuyucubil"].Clear();
frm1.okuyucucombo();
frm1.okuyuculistele();
MessageBox.Show("Kayıt işlemi tamamlandı !");
}
else MessageBox.Show("Boş alanları doldurunuz !");
}
else MessageBox.Show("Kayıtlı Tc Kimlik veya Öğrenci No Girdiniz !");

}
}
}

[/code]

FORM4 İçerisine Yazılacak Kodlar…  

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

[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 kutuphane_takip_1._0
{
public partial class Form4 : Form
{
public Form1 frm1;
public Form4()
{
InitializeComponent();
}

private void Form4_Load(object sender, EventArgs e)
{
frm1.dtst.Tables["okuyucubil"].Clear();
frm1.okuyuculistele2();

}

private void btnCikis_Click(object sender, EventArgs e)
{

this.Close();

frm1.dtst.Tables["okuyucubil"].Clear();
frm1.okuyuculistele();
frm1.dataGridView2.Columns.Remove("DogumTarihi");
frm1.dataGridView2.Columns.Remove("DogumYeri");
frm1.dataGridView2.Columns.Remove("Telefon");
frm1.dataGridView2.Columns.Remove("Eposta");
frm1.dataGridView2.Columns.Remove("UyelikTarihi");
frm1.dataGridView2.Columns.Remove("Cinsiyet");
frm1.dataGridView2.Columns.Remove("Adres");

}

private void txtAdSoyadAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil",frm1.bag);
if (txtAdSoyadAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from okuyucubil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "okuyucubil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From okuyucubil" +
" where(AdiSoyadi like ‘%" + txtAdSoyadAra.Text + "%’ )";
frm1.dtst.Tables["okuyucubil"].Clear();
adtr.Fill(frm1.dtst, "okuyucubil");
frm1.bag.Close();
}

private void txtOkulNoAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil", frm1.bag);
if (txtOkulNoAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from okuyucubil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "okuyucubil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From okuyucubil" +
" where(Nosu like ‘%" + txtOkulNoAra.Text + "%’ )";
frm1.dtst.Tables["okuyucubil"].Clear();
adtr.Fill(frm1.dtst, "okuyucubil");
frm1.bag.Close();
}

private void txtSinifAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil", frm1.bag);
if (txtSinifAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from okuyucubil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "okuyucubil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From okuyucubil" +
" where(Sinifi like ‘%" + txtSinifAra.Text+ "%’ )";
frm1.dtst.Tables["okuyucubil"].Clear();
adtr.Fill(frm1.dtst, "okuyucubil");
frm1.bag.Close();
}

private void txtTcKimlikAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil", frm1.bag);
if (txtTcKimlikAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from okuyucubil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "okuyucubil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From okuyucubil" +
" where(TcKimlik like ‘%" + txtTcKimlikAra.Text + "%’ )";
frm1.dtst.Tables["okuyucubil"].Clear();
adtr.Fill(frm1.dtst, "okuyucubil");
frm1.bag.Close();
}

private void txtDogumYeriAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil", frm1.bag);
if (txtDogumYeriAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from okuyucubil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "okuyucubil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From okuyucubil" +
" where(DogumYeri like ‘%" + txtDogumYeriAra.Text+ "%’ )";
frm1.dtst.Tables["okuyucubil"].Clear();
adtr.Fill(frm1.dtst, "okuyucubil");
frm1.bag.Close();
}

private void btnSil_Click(object sender, EventArgs e)
{
string silinecek;
try
{
int row = 0;
for (row = 0; row <= dataGridView1.Rows.Count; row++)
{

if (dataGridView1.Rows[row].Cells[0].Selected == true || dataGridView1.Rows[row].Cells[1].Selected == true || dataGridView1.Rows[row].Cells[2].Selected == true || dataGridView1.Rows[row].Cells[3].Selected == true || dataGridView1.Rows[row].Cells[4].Selected == true || dataGridView1.Rows[row].Cells[5].Selected == true || dataGridView1.Rows[row].Cells[6].Selected == true || dataGridView1.Rows[row].Cells[7].Selected == true || dataGridView1.Rows[row].Cells[8].Selected == true || dataGridView1.Rows[row].Cells[9].Selected == true || dataGridView1.Rows[row].Cells[10].Selected == true || dataGridView1.Rows[row].Cells[11].Selected == true || dataGridView1.Rows[row].Cells[12].Selected == true)
{
break;

}
}
silinecek = dataGridView1.Rows[row].Cells[0].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 okuyucubil WHERE TcKimlik=’" + silinecek + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Tables["okuyucubil"].Clear();
frm1.okuyuculistele2();
}
}
catch
{ ;}
}
}
}

[/code]

FORM5 İç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 kutuphane_takip_1._0
{
public partial class Form5 : Form
{
public Form1 frm1;
public Form5()
{
InitializeComponent();
}

private void Form5_Load(object sender, EventArgs e)
{
frm1.dtst.Tables["kitapbil"].Clear();
frm1.kitaplistele2();
}

private void btnCikis_Click(object sender, EventArgs e)
{
frm1.dtst.Tables["kitapbil"].Clear();
frm1.kitaplistele();
this.Close();
}

private void txtBarkodAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", frm1.bag);
if (txtBarkodAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from kitapbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "kitapbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From kitapbil" +
" where(BarkodNo like ‘%" + txtBarkodAra.Text + "%’ )";
frm1.dtst.Tables["kitapbil"].Clear();
adtr.Fill(frm1.dtst, "kitapbil");
frm1.bag.Close();
}

private void txtKitapadiAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", frm1.bag);
if (txtKitapadiAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from kitapbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "kitapbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From kitapbil" +
" where(KitapAdi like ‘%" + txtKitapadiAra.Text + "%’ )";
frm1.dtst.Tables["kitapbil"].Clear();
adtr.Fill(frm1.dtst, "kitapbil");
frm1.bag.Close();
}

private void txtKitapyazariAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", frm1.bag);
if (txtKitapyazariAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from kitapbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "kitapbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From kitapbil" +
" where(YazarAdi like ‘%" + txtKitapyazariAra.Text + "%’ )";
frm1.dtst.Tables["kitapbil"].Clear();
adtr.Fill(frm1.dtst, "kitapbil");
frm1.bag.Close();
}

private void txtYayinEviAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", frm1.bag);
if (txtYayinEviAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from kitapbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "kitapbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From kitapbil" +
" where(YayinEvi like ‘%" + txtYayinEviAra.Text + "%’ )";
frm1.dtst.Tables["kitapbil"].Clear();
adtr.Fill(frm1.dtst, "kitapbil");
frm1.bag.Close();
}

private void txtKitapTuruAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", frm1.bag);
if (txtKitapTuruAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from kitapbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "kitapbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From kitapbil" +
" where(KitapTuru like ‘%" + txtKitapTuruAra.Text + "%’ )";
frm1.dtst.Tables["kitapbil"].Clear();
adtr.Fill(frm1.dtst, "kitapbil");
frm1.bag.Close();
}

private void txtTeminBicimiAra_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", frm1.bag);
if (txtTeminBicimiAra.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from kitapbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "kitapbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From kitapbil" +
" where(TeminBicimi like ‘%" + txtTeminBicimiAra.Text + "%’ )";
frm1.dtst.Tables["kitapbil"].Clear();
adtr.Fill(frm1.dtst, "kitapbil");
frm1.bag.Close();
}

private void btnSil_Click(object sender, EventArgs e)
{
string silinecek;
try
{
int row = 0;
for (row = 0; row <= dataGridView1.Rows.Count; row++)
{

if (dataGridView1.Rows[row].Cells[0].Selected == true || dataGridView1.Rows[row].Cells[1].Selected == true || dataGridView1.Rows[row].Cells[2].Selected == true || dataGridView1.Rows[row].Cells[3].Selected == true || dataGridView1.Rows[row].Cells[4].Selected == true || dataGridView1.Rows[row].Cells[5].Selected == true || dataGridView1.Rows[row].Cells[6].Selected == true || dataGridView1.Rows[row].Cells[7].Selected == true)
{
break;

}
}
silinecek = dataGridView1.Rows[row].Cells[0].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 kitapbil WHERE BarkodNo=’" + silinecek + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Tables["kitapbil"].Clear();
frm1.kitaplistele2();
}
}
catch
{ ;}
}
}
}

[/code]

FORM6 İç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 kutuphane_takip_1._0
{
public partial class Form6 : Form
{
public Form1 frm1;
public Form6()
{
InitializeComponent();
}
public string no,ad,kitapad,barkodno;
private void Form6_Load(object sender, EventArgs e)
{

}

private void btnCikis_Click(object sender, EventArgs e)
{
frm1.dtst.Tables["emanetbil"].Clear();
this.Close();
}

private void txtAraAdiSoyadi_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From emanetbil", frm1.bag);
if (txtAraAdiSoyadi.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from emanetbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "emanetbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From emanetbil" +
" where(AdiSoyadi like ‘%" + txtAraAdiSoyadi.Text + "%’ )";
frm1.dtst.Tables["emanetbil"].Clear();
adtr.Fill(frm1.dtst, "emanetbil");
frm1.bag.Close();
}

private void txtAraOkulNo_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From emanetbil", frm1.bag);
if (txtAraOkulNo.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from emanetbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "emanetbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From emanetbil" +
" where(Nosu like ‘%" + txtAraOkulNo.Text + "%’ )";
frm1.dtst.Tables["emanetbil"].Clear();
adtr.Fill(frm1.dtst, "emanetbil");
frm1.bag.Close();
}

private void txtaraKitapAdi_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From emanetbil", frm1.bag);
if (txtaraKitapAdi.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from emanetbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "emanetbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From emanetbil" +
" where(KitapAdi like ‘%" + txtaraKitapAdi.Text + "%’ )";
frm1.dtst.Tables["emanetbil"].Clear();
adtr.Fill(frm1.dtst, "emanetbil");
frm1.bag.Close();
}

private void txtAraYazarAdi_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From emanetbil", frm1.bag);
if (txtAraYazarAdi.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from emanetbil";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "emanetbil");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From emanetbil" +
" where(KitapYazari like ‘%" + txtAraYazarAdi.Text + "%’ )";
frm1.dtst.Tables["emanetbil"].Clear();
adtr.Fill(frm1.dtst, "emanetbil");
frm1.bag.Close();
}

private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
for (frm1.satir = 0;frm1.satir < dataGridView1.Rows.Count;frm1.satir++)
{
if (dataGridView1.Rows[frm1.satir].Cells[0].Selected == true || dataGridView1.Rows[frm1.satir].Cells[1].Selected == true || dataGridView1.Rows[frm1.satir].Cells[2].Selected == true || dataGridView1.Rows[frm1.satir].Cells[3].Selected == true || dataGridView1.Rows[frm1.satir].Cells[4].Selected == true || dataGridView1.Rows[frm1.satir].Cells[5].Selected == true || dataGridView1.Rows[frm1.satir].Cells[6].Selected == true || dataGridView1.Rows[frm1.satir].Cells[7].Selected == true || dataGridView1.Rows[frm1.satir].Cells[8].Selected == true || dataGridView1.Rows[frm1.satir].Cells[9].Selected == true)
{
break;
}
}
no = dataGridView1.Rows[frm1.satir].Cells[1].Value.ToString();
ad = dataGridView1.Rows[frm1.satir].Cells[0].Value.ToString();
kitapad = dataGridView1.Rows[frm1.satir].Cells[3].Value.ToString();
barkodno = dataGridView1.Rows[frm1.satir].Cells[2].Value.ToString();
}

private void btnTeslimAl_Click(object sender, EventArgs e)
{
frm1.frm7.ShowDialog();
}
}
}
[/code]

FORM7 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
namespace kutuphane_takip_1._0
{
public partial class Form7 : Form
{
public Form1 frm1;
public Form7()
{
InitializeComponent();
}

private void btnTamam_Click(object sender, EventArgs e)
{
string hdurum;
try
{
if (textBox1.Text != "" &amp;amp;amp;&amp;amp;amp; textBox2.Text!="")
{
hdurum = "Teslim Edildi";
if (comboBox1.Text == "Kayıp") hdurum = "";
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "UPDATE emanetbil SET TeslimTarihi=’" + dateTimePicker1.Text + "’,HasarDurumu=’" + comboBox1.Text + "’,EmanetDurumu=’" + hdurum + "’ WHERE Nosu=’" + frm1.frm6.no + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "UPDATE okuyucubil SET EmanetSayisi=EmanetSayisi-1 WHERE Nosu=’" + frm1.frm6.no + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "UPDATE kitapbil SET StokSayisi=StokSayisi+1 WHERE BarkodNo=’" + frm1.frm6.barkodno+ "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Tables["emanetbil"].Clear();
frm1.emanetlistele();
frm1.dtst.Tables["okuyucubil"].Clear();
frm1.okuyuculistele();
frm1.dtst.Tables["kitapbil"].Clear();
frm1.kitaplistele();
this.Close();
}
else
MessageBox.Show("Kitap teslimi için listeden seçim yapmalısınız !");
}
catch
{

;
}
}

private void Form7_Load(object sender, EventArgs e)
{
textBox1.Text = frm1.frm6.ad;
textBox2.Text = frm1.frm6.kitapad;
}

private void btnIptal_Click(object sender, EventArgs e)
{
this.Close();
}
}
}
[/code]

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

Projeyi İNDİR