Fatura Takip Programı — Csharp

Fatura Takip Programı — Csharp

Not :

Fatura son ödeme tarihine 3 günden az kaldıysa satırı kırmızı ,2-6 arasında gün kaldıysa sarı yapıyor.Ayrıca Kaydet,Sil,Güncelle,Ara özellikleri mevcuttur.

[code lang=”csharp”]

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;//www.gorselprogramlama.com

using System.Text;

using System.Windows.Forms;

using System.Data.OleDb;

namespace fatura_takip

{

public partial class Form2 : Form

{

public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.ace.Oledb.12.0;Data Source=data.accdb");

public OleDbCommand kmt = new OleDbCommand();

//www.gorselprogramlama.com

public OleDbDataAdapter adtr = new OleDbDataAdapter();

public DataTable tablo = new DataTable();

public Form2()

{

InitializeComponent();//www.gorselprogramlama.com

}

public void listele()

{

tablo.Clear();

OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kisibil ", bag);

adtr.Fill(tablo);

dataGridView1.DataSource = tablo;

}

TimeSpan fark;

double farkGun;//www.gorselprogramlama.com

void renklendir()

{

for (int i = 0; i < dataGridView1.Rows.Count – 1; i++)

{

fark = Convert.ToDateTime(dataGridView1.Rows[i].Cells["sonOdemeTarihi"].Value.ToString()) – Convert.ToDateTime(DateTime.Now.ToShortDateString());

farkGun = fark.TotalDays;

if ( farkGun < 3) dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.Red;

else if (farkGun > 2 && farkGun < 6) dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;

}

}

private void btnKaydet_Click(object sender, EventArgs e)

{

bag.Open();

kmt.Connection = bag;

kmt.CommandText = "INSERT INTO kisibil(adi,soyadi,cinsi,faturaTarihi,sonOdemeTarihi,miktar,tutar) VALUES (@adi,@soyadi,@cinsi,@faturaTarihi,@sonOdemeTarihi,@miktar,@tutar) ";

kmt.Parameters.AddWithValue("@adi", textBox1.Text);

kmt.Parameters.AddWithValue("@soyadi", textBox2.Text);

kmt.Parameters.AddWithValue("@cinsi", textBox3.Text);

kmt.Parameters.AddWithValue("@faturaTarihi", dateTimePicker1.Text);

kmt.Parameters.AddWithValue("@sonOdemeTarihi", dateTimePicker2.Text);

kmt.Parameters.AddWithValue("@miktar", textBox4.Text);

kmt.Parameters.AddWithValue("@tutar", textBox5.Text);

kmt.ExecuteNonQuery();

kmt.Dispose();//www.gorselprogramlama.com

bag.Close();

//www.gorselprogramlama.com

for (int i = 0; i <= this.Controls.Count – 1; i++)

{

if (this.Controls[i] is TextBox)

{

this.Controls[i].Text = "";

}

}

listele();

renklendir();

MessageBox.Show("Kayıt işlemi tamamlandı !");

}

private void Form2_Load(object sender, EventArgs e)

{

listele();

dataGridView1.Columns[0].Visible = false;

renklendir();

dataGridView1.Columns[1].HeaderText = "Kişi Adı";

dataGridView1.Columns[2].HeaderText = "Kişi Soyadı";

dataGridView1.Columns[3].HeaderText = "Fatura Cinsi";

dataGridView1.Columns[4].HeaderText = "Fatura Tarihi";

dataGridView1.Columns[5].HeaderText = "Son Ödeme Tarihi";

dataGridView1.Columns[6].HeaderText = "Miktar";

dataGridView1.Columns[7].HeaderText = "Tutar";

}

private void btnSil_Click(object sender, EventArgs e)

{

bag.Open();

kmt.Connection = bag;

kmt.CommandText = "DELETE from kisibil WHERE id=@id";

kmt.Parameters.AddWithValue("@id", dataGridView1.CurrentRow.Cells[0].Value);

kmt.ExecuteNonQuery();

kmt.Dispose();

bag.Close();

listele();//www.gorselprogramlama.com

renklendir();

}

private void btnGuncelle_Click(object sender, EventArgs e)

{

bag.Open();

kmt.Connection = bag;

kmt.CommandText = "UPDATE kisibil SET adi=@adi,soyadi=@soyadi,cinsi=@cinsi,faturaTarihi=@faturaTarihi,sonOdemeTarihi=@sonOdemeTarihi,miktar=@miktar,tutar=@tutar WHERE id=@id";

kmt.Parameters.AddWithValue("@adi", textBox1.Text);

kmt.Parameters.AddWithValue("@soyadi", textBox2.Text);

kmt.Parameters.AddWithValue("@cinsi", textBox3.Text);

kmt.Parameters.AddWithValue("@faturaTarihi", dateTimePicker1.Text);

kmt.Parameters.AddWithValue("@sonOdemeTarihi", dateTimePicker2.Text);

kmt.Parameters.AddWithValue("@miktar", textBox4.Text);

kmt.Parameters.AddWithValue("@tutar", textBox5.Text);

kmt.Parameters.AddWithValue("@id", dataGridView1.CurrentRow.Cells[0].Value);

kmt.ExecuteNonQuery();//www.gorselprogramlama.com

bag.Close();

kmt.Parameters.Clear();

listele();

renklendir();

}

private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)

{

textBox1.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();

textBox2.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();

textBox3.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();

dateTimePicker1.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();

dateTimePicker2.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString();

textBox4.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString();

textBox5.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString();

}

private void btnAra_Click(object sender, EventArgs e)

{

OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kisibil", bag);

string alan = "";

if (comboBox1.Text == "Adı")

{

alan = "adi";

}

else if (comboBox1.Text == "Soyadı")

{

alan = "soyadi";

}

else if (comboBox1.Text == "Cinsi")

{

alan = "cinsi";

}

else if (comboBox1.Text == "Fatura Tarihi")

{

alan = "faturaTarihi";

}

else if (comboBox1.Text == "Son Ödeme Tarihi")

{

alan = "sonOdemeTarihi";

}

else if (comboBox1.Text == "Tutar")

{ //www.gorselprogramlama.com

alan = "tutar";

}

if (comboBox1.Text == "Tümü")

{

bag.Open();

tablo.Clear();

kmt.Connection = bag;

kmt.CommandText = "Select * from kisibil";

adtr.SelectCommand = kmt;

adtr.Fill(tablo);

//www.gorselprogramlama.com

bag.Close();

}

if (alan!="")

{

bag.Open();

adtr.SelectCommand.CommandText = (" Select * From kisibil" + " where(" + alan + " like ‘%") + textBox6.Text + "%’ )";

tablo.Clear();

adtr.Fill(tablo);

bag.Close();

}

kmt.Dispose();

renklendir();

}//www.gorselprogramlama.com

}

}

[/code]

Projeyi İNDİR