public bool BireyselKirala(cKira bk)
{
int a = 0;
SqlConnection conn = new SqlConnection(cGenel.connStr);
SqlCommand comm3 = new SqlCommand("select KiraDetayID from KiraDetay", conn);
if (conn.State == ConnectionState.Closed) conn.Open();
SqlDataReader dr;
try
{
dr = comm3.ExecuteReader();
while (dr.Read())
{
a = Convert.ToInt32(dr[0]);
}
}
catch (SqlException ex)
{
string hata = ex.Message;
}
conn.Close();
a++;
SqlCommand comm1 = new SqlCommand("Insert into KiraDetay (ToplamTutar,KiraDetayID) values(@ToplamTutar,@KiraDetayID)", conn);
comm1.Parameters.Add("@ToplamTutar", SqlDbType.Int).Value = bk._tutar;
comm1.Parameters.Add("@KiraDetayID", SqlDbType.Int).Value = a;
if (conn.State == ConnectionState.Closed) conn.Open();
comm1.ExecuteNonQuery();
conn.Close();
SqlCommand comm2 = new SqlCommand("select KiraDetayID from KiraDetay", conn);
if (conn.State == ConnectionState.Closed) conn.Open();
SqlDataReader dr1;
try
{
dr1 = comm2.ExecuteReader();
while (dr1.Read())
{
bk._kiraDetayID = Convert.ToInt32(dr1[0]);
}
}
catch (SqlException ex)
{
string hata = ex.Message;
}
conn.Close();
SqlCommand comm = new SqlCommand("Insert into Kiralama (MusteriNo,AracNo,KirayaGidisTarihi,KiradanDonusTarihi,Tutar,KiraDetayID) values(@MusteriNo,@AracNo,@KirayaGidisTarihi,@KiradanDonusTarihi,@Tutar,@KiraDetayID)", conn);
comm.Parameters.Add("@MusteriNo", SqlDbType.Int).Value = bk._musteriNo;
comm.Parameters.Add("@AracNo", SqlDbType.Int).Value = bk._aracNo;
comm.Parameters.Add("@KirayaGidisTarihi", SqlDbType.DateTime).Value = bk._kirayaGidisTarihi;
comm.Parameters.Add("@KiradanDonusTarihi", SqlDbType.DateTime).Value = bk._kiradanDonusTarihi;
comm.Parameters.Add("@Tutar", SqlDbType.Int).Value = bk._tutar;
comm.Parameters.Add("@KiraDetayID", SqlDbType.Int).Value = bk._kiraDetayID;
if (conn.State == ConnectionState.Closed) conn.Open();
bool Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery());
conn.Close();
return Sonuc;
}
private void dgvKiralama_DoubleClick(object sender, EventArgs e)
{
cArac a = new cArac();
cKira b = new cKira();
btnSonlandir.Enabled = true;
if (rbBireysel.Checked == true)
{
a.AracGetirKiraSonlandir(dgvKiralama, a);
txtAracID1.Text = a.AracID.ToString();
}
if (rbKurumsal.Checked == true)
{
int i = 1;
List<cKira> list = new List<cKira>();
b.AracDetayIDGetir(dgvKiralama, b);
txtKiraDetayID.Text = b.KiraDetayID.ToString();
list = b.KiralananGetirKurumsalByKiraDetayID(b);
foreach (var item in list)
{
if(i==1)
(txtAracID1).Text = item.AracNo.ToString();
if(i==2)
(txtAracID2).Text = item.AracNo.ToString();
if(i==3)
(txtAracID3).Text = item.AracNo.ToString();
i++;
}
}
}
private void btnSonlandir_Click(object sender, EventArgs e)
{
cArac a = new cArac();
cKira b = new cKira();
if (rbBireysel.Checked == true)
{
a.AracGuncelleKiralanabilir(a.AracID);
}
else if (rbKurumsal.Checked == true)
{
a.AracGuncelleKiralanabilir(Convert.ToInt32(txtAracID1.Text));
if (txtAracID2.Text != "")
{
a.AracGuncelleKiralanabilir(Convert.ToInt32(txtAracID2.Text));
}
if (txtAracID3.Text != "")
{
a.AracGuncelleKiralanabilir(Convert.ToInt32(txtAracID3.Text));
}
}
}
public void AracDetayIDGetir(DataGridView dgv, cKira k)
{
k._kiraDetayID = Convert.ToInt32(dgv.SelectedRows[0].Cells[7].Value);
}
public void KurumsalKirala(cKira kk)
{
SqlConnection conn = new SqlConnection(cGenel.connStr);
SqlCommand comm1 = new SqlCommand("Insert into KiraDetay (ToplamTutar,KiraDetayID) values(@ToplamTutar,@KiraDetayID)", conn);
comm1.Parameters.Add("@ToplamTutar", SqlDbType.Int).Value = kk._tutar;
comm1.Parameters.Add("@KiraDetayID", SqlDbType.Int).Value = cGenel.KiraDetayKurumsal;
if (conn.State == ConnectionState.Closed) conn.Open();
comm1.ExecuteNonQuery();
conn.Close();
SqlCommand comm2 = new SqlCommand();
comm2.Connection = conn;
comm2.CommandText = "Insert into Kiralama (FirmaNo,AracNo,KirayaGidisTarihi,KiradanDonusTarihi,Tutar,KiraDetayID) values (@FirmaNo,@AracNo,@KirayaGidisTarihi,@KiradanDonusTarihi,@Tutar,@KiraDetayID)";
comm2.Parameters.Add("@FirmaNo", SqlDbType.Int).Value = kk._firmaNo;
comm2.Parameters.Add("@AracNo", SqlDbType.Int).Value = kk._aracNo;
comm2.Parameters.Add("@KirayaGidisTarihi", SqlDbType.DateTime).Value = kk._kirayaGidisTarihi;
comm2.Parameters.Add("@KiradanDonusTarihi", SqlDbType.DateTime).Value = kk._kiradanDonusTarihi;
comm2.Parameters.Add("@Tutar", SqlDbType.Int).Value = kk._tutar;
comm2.Parameters.Add("@KiraDetayID", SqlDbType.Int).Value = cGenel.KiraDetayKurumsal;
if (conn.State == ConnectionState.Closed) conn.Open();
comm2.ExecuteNonQuery();
conn.Close();
}
public List<cKira> KiralananGetirKurumsalByKiraDetayID(cKira k)
{
List<cKira> list = new List<cKira>();
SqlConnection conn = new SqlConnection(cGenel.connStr);
SqlCommand comm = new SqlCommand("Select * from Kiralama where KiraDetayID=@KiraDetayID and FirmaNo not like 'NULL'", conn);
comm.Parameters.Add("@KiraDetayID", SqlDbType.Int).Value = k._kiraDetayID;
if (conn.State == ConnectionState.Closed) conn.Open();
SqlDataReader dr;
try
{
dr = comm.ExecuteReader();
while (dr.Read())
{
cKira a = new cKira();
a._aracNo = Convert.ToInt32(dr["AracNo"]);
list.Add(a);
}
}
catch (SqlException ex)
{
string hata = ex.Message;
}
return list;
}
public List<cKira> KiralananGetirKurumsal()
{
List<cKira> list = new List<cKira>();
SqlConnection conn = new SqlConnection(cGenel.connStr);
SqlCommand comm = new SqlCommand("Select * from Kiralama where Silindi=0 and FirmaNo not like 'NULL'", conn);
if (conn.State == ConnectionState.Closed) conn.Open();
SqlDataReader dr;
try
{
dr = comm.ExecuteReader();
while (dr.Read())
{
cKira a = new cKira();
a._kiraID = Convert.ToInt32(dr["KiraID"]);
a._firmaNo = Convert.ToInt32(dr["FirmaNo"]);
a._aracNo = Convert.ToInt32(dr["AracNo"]);
a._kirayaGidisTarihi = Convert.ToDateTime(dr["KirayaGidisTarihi"]);
a._kiradanDonusTarihi = Convert.ToDateTime(dr["KiradanDonusTarihi"]);
a._tutar = Convert.ToInt32(dr["Tutar"]);
a._kiraDetayID = Convert.ToInt32(dr["KiraDetayID"]);
list.Add(a);
}
for (int i = 0; i < cGenel.AracEkle; i++)
{
}
}
catch (SqlException ex)
{
string hata = ex.Message;
}
return list;
}
private void rbBireysel_CheckedChanged(object sender, EventArgs e)
{
if (rbBireysel.Checked == true)
{
cKira k = new cKira();
dgvKiralama.DataSource = k.KiralananGetirBireysel();
dgvKiralama.Columns["FirmaNo"].Visible = false;
dgvKiralama.Columns["MusteriNo"].Visible = true;
}
}
private void rbKurumsal_CheckedChanged(object sender, EventArgs e)
{
if (rbKurumsal.Checked == true)
{
cKira k = new cKira();
List<cKira> list = new List<cKira>();
list= k.KiralananGetirKurumsal();
dgvKiralama.DataSource = list;
dgvKiralama.Columns["MusteriNo"].Visible = false;
dgvKiralama.Columns["FirmaNo"].Visible = true;
}
}
private void btnKirala_Click(object sender, EventArgs e)
{
cArac a = new cArac();
if (cbMusteriTipi.SelectedIndex == 0)
{
cKira k = new cKira();
List<cArac> list1 = new List<cArac>();
list1 = a.AraclariGetirByAracID(Convert.ToInt32(txtAracID.Text), a);
foreach (var item in list1)
{
lvAraclar.Items.Add(txtAracID.Text);
lvAraclar.Items[i].SubItems.Add(a.Marka);
lvAraclar.Items[i].SubItems.Add(a.Model);
lvAraclar.Items[i].SubItems.Add(a.Yil.ToString());
lvAraclar.Items[i].SubItems.Add(a.GunlukUcret.ToString());
lvAraclar.Items[i].SubItems.Add(a.Km.ToString());
lvAraclar.Items[i].SubItems.Add(txtGidis.Text);
lvAraclar.Items[i].SubItems.Add(txtDonus.Text);
lvAraclar.Items[i].SubItems.Add(txtTutar.Text);
i++;
}
try
{
k.MusteriNo = Convert.ToInt32(txtMusteriID.Text);
k.AracNo = Convert.ToInt32(txtAracID.Text);
k.KirayaGidisTarihi = Convert.ToDateTime(txtGidis.Text);
k.KiradanDonusTarihi = Convert.ToDateTime(txtDonus.Text);
k.KiraDetayID = cGenel.KiraDetayKurumsal - 1;
k.Tutar = Convert.ToInt32(txtTutar.Text);
k.BireyselKirala(k);
a.AracGuncelleKiralanamaz(k.AracNo);
dgvKiralama.DataSource = k.KiralananGetirBireysel();
dgvKiralama.Columns["FirmaNo"].Visible = false;
MessageBox.Show("Kiralama Bilgileri Kayıt Edildi.");
if (MessageBox.Show(txtMusteriAd.Text + " adlı/ünvanlı müşteri için fatura dökümü istiyor musunuz?", "FATURA", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
Yazdir();
}
else this.Close();
}
catch (Exception)
{
frmAracKiralama.ActiveForm.Activate();
MessageBox.Show("Eksik Bilgi Var, Tekrar Kontrol Edin ");
btnYazdir.Enabled = false;
}
}
else if (cbMusteriTipi.SelectedIndex == 1)
{
cGenel.KiraDetayKurumsal = k.KiraDetayIDGetir();
try
{
for (int i = 0; i < lvAraclar.Items.Count; i++)
{
k.FirmaNo = Convert.ToInt32(txtMusteriID.Text);
k.AracNo = Convert.ToInt32(lvAraclar.Items[i].Text);
k.KirayaGidisTarihi = Convert.ToDateTime(lvAraclar.Items[i].SubItems[6].Text);
k.KiradanDonusTarihi = Convert.ToDateTime(lvAraclar.Items[i].SubItems[7].Text);
k.Tutar = Convert.ToInt32(lvAraclar.Items[i].SubItems[8].Text);
k.KiraDetayID = cGenel.KiraDetayKurumsal;
k.KurumsalKirala(k);
a.AracGuncelleKiralanamaz(k.AracNo);
}
dgvKiralama.DataSource = k.KiralananGetirKurumsal();
dgvKiralama.Columns["MusteriNo"].Visible = false;
MessageBox.Show("Kiralama Bilgileri Kayıt Edildi.");
if (MessageBox.Show(txtMusteriAd.Text + " adlı/ünvanlı müşteri için fatura dökümü istiyor musunuz?", "FATURA", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
Yazdir();
}
else this.Close();
}
catch (Exception)
{
frmAracKiralama.ActiveForm.Activate();
MessageBox.Show("Eksik Bilgi Var, Tekrar Kontrol Edin ");
btnYazdir.Enabled = false;
}
}
cGenel.aracid[1] = 0;
cGenel.aracid[2] = 0;
cGenel.aracid[3] = 0;
cGenel.aracid[4] = 0;
cGenel.aracid[5] = 0;
cGenel.aracid[6] = 0;
}