public static List <EntityAraclar> AracListele()
{
List <EntityAraclar> degerler = new List <EntityAraclar>();
SqlCommand komut = new SqlCommand("AracListesi", SqlBaglantisi.Baglanti);
komut.CommandType = CommandType.StoredProcedure;
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityAraclar ent = new EntityAraclar();
ent.Id = Convert.ToInt32(dr["id"]);
ent.Plaka = dr["Plaka"].ToString();
ent.Marka = dr["Marka"].ToString();
ent.Model = dr["Model"].ToString();
ent.Km = Convert.ToInt32(dr["Km"]);
ent.Renk = dr["Renk"].ToString();
ent.Vites = dr["Vites"].ToString();
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static bool Guncelle(EntityAraclar deger)
{
if (deger.Plaka != null && deger.Marka != null && deger.Model != null && deger.Km > 0)
{
return(FacadeAraclar.Guncelle(deger));
}
return(false);
}
public static int Ekle(EntityAraclar deger)
{
if (deger.Plaka != null && deger.Marka != null && deger.Model != null && deger.Km > 0)
{
return(FacadeAraclar.Ekle(deger));
}
return(-1);
}
private void button1_Click(object sender, EventArgs e)
{
EntityAraclar ent = new EntityAraclar();
ent.Plaka = TxtPlaka.Text;
ent.Marka = TxtMarka.Text;
ent.Model = TxtModel.Text;
ent.Renk = TxtRenk.Text;
ent.Km = Convert.ToInt32(TxtKm.Text);
ent.Vites = CmbVites.Text;
ent.Id = Convert.ToInt32(CmbPlaka.SelectedValue);
BLLAraclar.Guncelle(ent);
MessageBox.Show("Arac Guncelleme Islemi Basari Ile Sonuclandi");
AracListesi();
}
private void button1_Click(object sender, EventArgs e)
{
EntityAraclar ent = new EntityAraclar();
ent.Plaka = TxtPlaka.Text;
ent.Marka = TxtMarka.Text;
ent.Model = TxtModel.Text;
ent.Renk = TxtRenk.Text;
ent.Km = Convert.ToInt32(TxtKm.Text);
ent.Vites = CmbVites.Text;
BLLAraclar.Ekle(ent);
MessageBox.Show("Arac Ekleme Islemi Basari Ile Sonuclandi");
this.Close();
Araclar goster = new Araclar();
goster.Show();
}
public static int Ekle(EntityAraclar deger)
{
SqlCommand komut = new SqlCommand("AracEkle", SqlBaglantisi.Baglanti);
komut.CommandType = CommandType.StoredProcedure;
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
komut.Parameters.AddWithValue("Plaka", deger.Plaka);
komut.Parameters.AddWithValue("Marka", deger.Marka);
komut.Parameters.AddWithValue("Model", deger.Model);
komut.Parameters.AddWithValue("Renk", deger.Renk);
komut.Parameters.AddWithValue("Km", deger.Km);
komut.Parameters.AddWithValue("Vites", deger.Vites);
return(komut.ExecuteNonQuery());
}