public static EntityKasko KaskoListeleTek(int deger) { SqlCommand komut = new SqlCommand("KaskoListesiTek", SqlBaglantisi.Baglanti); komut.CommandType = CommandType.StoredProcedure; if (komut.Connection.State != ConnectionState.Open) { komut.Connection.Open(); } komut.Parameters.AddWithValue("AracId", deger); SqlDataReader dr = komut.ExecuteReader(); EntityKasko ent = new EntityKasko(); 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 <EntityKasko> KaskoListele() { List <EntityKasko> degerler = new List <EntityKasko>(); SqlCommand komut = new SqlCommand("KaskoListesi", SqlBaglantisi.Baglanti); komut.CommandType = CommandType.StoredProcedure; if (komut.Connection.State != ConnectionState.Open) { komut.Connection.Open(); } SqlDataReader dr = komut.ExecuteReader(); while (dr.Read()) { EntityKasko ent = new EntityKasko(); 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(EntityKasko deger) { if (deger.Baslangic != null && deger.Bitis != null && deger.Tutar != null) { return(FacadeKasko.Guncelle(deger)); } return(false); }
public static int Ekle(EntityKasko deger) { if (deger.Baslangic != null && deger.Bitis != null && deger.Tutar != null) { return(FacadeKasko.Ekle(deger)); } return(-1); }
private void BtnGuncelle_Click(object sender, EventArgs e) { EntityKasko ent = new EntityKasko(); ent.Baslangic = Convert.ToDateTime(DateTimeBaslangicGnc.Text); ent.Bitis = Convert.ToDateTime(DataTimeBitisGnc.Text); ent.Tutar = Convert.ToDecimal(TxtTutarGnc.Text); ent.AracId = Convert.ToInt32(CmbPlkGncl.SelectedValue); BLLKasko.Guncelle(ent); MessageBox.Show("Aigorta Guncelleme Islemi Basari Ile Sonuclandi"); KaskoListesi(); }
private void BtnKydt_Click(object sender, EventArgs e) { EntityKasko ent = new EntityKasko(); ent.Baslangic = Convert.ToDateTime(DateTimeBaslangic.Text); ent.Bitis = Convert.ToDateTime(DateTimeBitis.Text); ent.Tutar = Convert.ToInt32(TxtTutar.Text);; ent.AracId = Convert.ToInt32(CmbPlaka.SelectedValue); BLLKasko.Ekle(ent); MessageBox.Show("Sigorta Ekleme Islemi Basari Ile Sonuclandi"); KaskoListesi(); }
public static bool Guncelle(EntityKasko deger) { SqlCommand komut = new SqlCommand("KaskoGuncelle", 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; }