Kasa Defteri Takip Programı C#

Kasa Defteri 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;
using System.Xml;

namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
public Form2 frm2;
public Form3 frm3;
public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm2.frm1 = this;
frm3.frm1 = this;
}
private string usdAlis;
private string usdSatis;
private string euAlis;
private string euSatis;

private void ExchangeAll()
{
try
{
XmlTextReader xmlReader = new XmlTextReader("http://www.tcmb.gov.tr/kurlar/today.xml");
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.Load(xmlReader);
XmlNode topNode = xmlDocument.DocumentElement;
XmlNode dolarAlis = xmlDocument.SelectSingleNode("//Tarih_Date//Currency[Kod=’USD’]|//ForexBuying");
XmlNode dolarSatis = xmlDocument.SelectSingleNode("//Tarih_Date//Currency[Kod=’USD’]|//ForexSelling");
XmlNode euroAlis = topNode.SelectSingleNode("Currency[CurrencyName=’EURO’]");
usdAlis = dolarAlis.InnerText;
usdSatis = dolarSatis.InnerText;
euAlis = euroAlis.ChildNodes[3].InnerText;
euSatis = euroAlis.ChildNodes[4].InnerText;
}
catch
{
MessageBox.Show("internet bağlantınızı kontrol edin");
}
}
public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=kasa.mdb");
public OleDbCommand kmt = new OleDbCommand();
public OleDbDataAdapter adtr = new OleDbDataAdapter();
public DataSet dtst = new DataSet();
public int satir;
public Boolean durum = false;
public string silinecek;
public void listele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kasa ", bag);
adtr.Fill(dtst, "kasa");
dataGridView1.DataSource = dtst.Tables["kasa"];
adtr.Dispose();
bag.Close();
}
public void combo1()
{
int durum;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select tur,birim from kasa";
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());
}
bag.Close();
oku.Dispose();
}
public void combo2()
{
int durum;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select tur,birim from kasa";
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 ıdkontrol()
{
durum = false;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select ıd from kasa";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{

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

}
bag.Close();
oku.Dispose();
}
private void Form1_Load(object sender, EventArgs e)
{
ExchangeAll();
label11.Text=usdAlis;
label12.Text=usdSatis;
label13.Text=euAlis;
label14.Text=euSatis;
System.Windows.Forms.ToolTip ToolTip1 = new System.Windows.Forms.ToolTip();
ToolTip1.SetToolTip(this.button1, "Yazdır");
ToolTip1.SetToolTip(this.button2, "Ekle");
ToolTip1.SetToolTip(this.button3, "Sil");
ToolTip1.SetToolTip(this.button4, "Düzenle");
listele();
dataGridView1.Columns[0].HeaderText = "ID";
dataGridView1.Columns[1].HeaderText = "Tarih";
dataGridView1.Columns[2].HeaderText = "Tür";
dataGridView1.Columns[3].HeaderText = "Açıklama";
dataGridView1.Columns[4].HeaderText = "Miktar";
dataGridView1.Columns[5].HeaderText = "Birim";
dataGridView1.Columns[0].Width = 40;
dataGridView1.Columns[1].Width = 80;
dataGridView1.Columns[2].Width = 70;
dataGridView1.Columns[3].Width = 120;
dataGridView1.Columns[4].Width = 60;
dataGridView1.Columns[5].Width = 40;
}

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

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

private void button3_Click(object sender, EventArgs e)
{
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)
{
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)
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "DELETE from kasa WHERE ıd=’" + silinecek + "’";
kmt.ExecuteNonQuery();
kmt.Dispose();
bag.Close();
dtst.Tables["kasa"].Clear();
listele();
}
}
catch
{ ;}
}

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

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

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

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

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

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

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

}
}

[/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.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication2
{
public partial class Form2 : Form
{
public Form1 frm1;
public Form2()
{
InitializeComponent();
}

private void Form2_Load(object sender, EventArgs e)
{
this.Text = string.Format("{0:d}", DateTime.Now);
frm1.combo1();
frm1.combo2();
}

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

private void button1_Click(object sender, EventArgs e)
{
frm1.ıdkontrol();
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 != "" )
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO kasa(ıd,tarih,tur,acıklama,miktar,birim) VALUES (‘" + textBox1.Text + "’,’" + dateTimePicker1.Text + "’,’" + comboBox1.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + comboBox2.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["kasa"].Clear();
frm1.listele();
frm1.combo1();
MessageBox.Show("Kayıt işlemi tamamlandı !");
}
else MessageBox.Show("Boş alanları doldurunuz !");
}
else MessageBox.Show("Girmiş olduğunuz Id No kullanılmış");
}
}
}

[/code]

FORM3 İçerisine Yazılacak Kodlar…

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

namespace WindowsFormsApplication2
{
public partial class Form3 : Form
{
public Form1 frm1;
public Form3()
{
InitializeComponent();
}

private void Form3_Load(object sender, EventArgs e)
{
this.Text = string.Format("{0:d}", DateTime.Now);
frm1.combo2();
}

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

private void button1_Click(object sender, EventArgs e)
{
try
{
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 != "")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "UPDATE kasa SET tarih=’" + dateTimePicker1.Text + "’,tur=’" + comboBox1.Text + "’,acıklama=’" + textBox2.Text + "’,miktar=’" + textBox3.Text + "’,birim=’" +comboBox2.Text + "’ WHERE ıd=’" + textBox1.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Tables["kasa"].Clear();
frm1.listele();
frm1.combo2();
this.Close();
}
else
MessageBox.Show("Bilgileriniz Güncellenmiştir !");
}
catch
{

;
}
}
}
}

[/code]

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

Projeyi İNDİR