public static EntityVize VizeListeleTek(int deger)
{
SqlCommand komut = new SqlCommand("VizeListesiTek", SqlBaglantisi.Baglanti);
komut.CommandType = CommandType.StoredProcedure;
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
komut.Parameters.AddWithValue("AracId", deger);
SqlDataReader dr = komut.ExecuteReader();
EntityVize ent = new EntityVize();
while (dr.Read())
{
ent.Id = Convert.ToInt32(dr["id"]);
ent.Baslangic = Convert.ToDateTime(dr["Baslangic"]);
ent.Bitis = Convert.ToDateTime(dr["Bitis"]);
ent.Tutar = Convert.ToDecimal(dr["Tutar"]);
ent.Plaka = dr["Plaka"].ToString();
}
dr.Close();
return(ent);
}
public static List <EntityVize> VizeListele()
{
List <EntityVize> degerler = new List <EntityVize>();
SqlCommand komut = new SqlCommand("VizeListesi", SqlBaglantisi.Baglanti);
komut.CommandType = CommandType.StoredProcedure;
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityVize ent = new EntityVize();
ent.Id = Convert.ToInt32(dr["id"]);
ent.Baslangic = Convert.ToDateTime(dr["Baslangic"]);
ent.Bitis = Convert.ToDateTime(dr["Bitis"]);
ent.Tutar = Convert.ToDecimal(dr["Tutar"]);
ent.Plaka = dr["Plaka"].ToString();
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static bool Guncelle(EntityVize deger)
{
if (deger.Baslangic != null && deger.Bitis != null && deger.Tutar != null)
{
return(FacadeVize.Guncelle(deger));
}
return(false);
}
public static int Ekle(EntityVize deger)
{
if (deger.Baslangic != null && deger.Bitis != null && deger.Tutar != null)
{
return(FacadeVize.Ekle(deger));
}
return(-1);
}
private void BtnGuncelle_Click(object sender, EventArgs e)
{
EntityVize ent = new EntityVize();
ent.Baslangic = Convert.ToDateTime(DateTimeBaslangicGnc.Text);
ent.Bitis = Convert.ToDateTime(DataTimeBitisGnc.Text);
ent.Tutar = Convert.ToDecimal(TxtTutarGnc.Text);
ent.AracId = Convert.ToInt32(CmbPlkGncl.SelectedValue);
BLLVize.Guncelle(ent);
MessageBox.Show("Vize Guncelleme Islemi Basari Ile Sonuclandi");
VizeListesi();
}
private void button1_Click(object sender, EventArgs e)
{
EntityVize ent = new EntityVize();
ent.Baslangic = Convert.ToDateTime(DateTimeBaslangic.Text);
ent.Bitis = Convert.ToDateTime(DateTimeBitis.Text);
ent.Tutar = Convert.ToInt32(TxtTutar.Text);;
ent.AracId = Convert.ToInt32(CmbPlaka.SelectedValue);
BLLVize.Ekle(ent);
MessageBox.Show("Vize Ekleme Islemi Basari Ile Sonuclandi");
VizeListesi();
}
public static bool Guncelle(EntityVize deger)
{
SqlCommand komut = new SqlCommand("VizeGuncelle", SqlBaglantisi.Baglanti);
komut.CommandType = CommandType.StoredProcedure;
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
komut.Parameters.AddWithValue("Baslangic", deger.Baslangic);
komut.Parameters.AddWithValue("Bitis", deger.Bitis);
komut.Parameters.AddWithValue("Tutar", deger.Tutar);
komut.Parameters.AddWithValue("Id", deger.AracId);
return(komut.ExecuteNonQuery() > 0);
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
int secilen = dataGridView1.SelectedCells[0].RowIndex;
EntityVize VizeLstTek = BLLVize.ListeleTek(Convert.ToInt32(dataGridView1.Rows[secilen].Cells[0].Value));
if (VizeLstTek.Bitis.ToString("dd.MM.yyyy") == "01.01.0001" && VizeLstTek.Baslangic.ToString("dd.MM.yyyy") == "01.01.0001" && VizeLstTek.Tutar == 0)
{
VBIT.Text = "---";
VBT.Text = "---";
VTUT.Text = "---";
}
else
{
VBIT.Text = VizeLstTek.Bitis.ToString("dd.MM.yyyy");
VBIT.Visible = true;
VBT.Text = VizeLstTek.Baslangic.ToString("dd.MM.yyyy");
VBT.Visible = true;
VTUT.Text = VizeLstTek.Tutar.ToString();
VTUT.Visible = true;
}
EntitySigorta SigortaLstTek = BLLSigorta.ListeleTek(Convert.ToInt32(dataGridView1.Rows[secilen].Cells[0].Value));
if (SigortaLstTek.Bitis.ToString("dd.MM.yyyy") == "01.01.0001" && SigortaLstTek.Baslangic.ToString("dd.MM.yyyy") == "01.01.0001" && SigortaLstTek.Tutar == 0)
{
SBIT.Text = "---";
SBT.Text = "---";
STUT.Text = "---";
}
else
{
SBIT.Text = SigortaLstTek.Bitis.ToString("dd.MM.yyyy");
SBIT.Visible = true;
SBT.Text = SigortaLstTek.Baslangic.ToString("dd.MM.yyyy");
SBT.Visible = true;
STUT.Text = SigortaLstTek.Tutar.ToString();
STUT.Visible = true;
}
EntityKasko KaskoLstTek = BLLKasko.ListeleTek(Convert.ToInt32(dataGridView1.Rows[secilen].Cells[0].Value));
if (KaskoLstTek.Bitis.ToString("dd.MM.yyyy") == "01.01.0001" && KaskoLstTek.Baslangic.ToString("dd.MM.yyyy") == "01.01.0001" && KaskoLstTek.Tutar == 0)
{
KBIT.Text = "---";
KBT.Text = "---";
KTUT.Text = "---";
}
else
{
KBIT.Text = KaskoLstTek.Bitis.ToString("dd.MM.yyyy");
KBIT.Visible = true;
KBT.Text = KaskoLstTek.Baslangic.ToString("dd.MM.yyyy");
KBT.Visible = true;
KTUT.Text = KaskoLstTek.Tutar.ToString();
KTUT.Visible = true;
}
List <EntityCeza> ArcCeza = BLLCeza.ListeleTek(Convert.ToInt32(dataGridView1.Rows[secilen].Cells[0].Value));
dataGridView4.DataSource = ArcCeza;
List <EntityBakim> BakimLstTek = BLLBakim.ListeleTek(Convert.ToInt32(dataGridView1.Rows[secilen].Cells[0].Value));
dataGridView5.DataSource = BakimLstTek;
}
