public void Guncelle(HurdaAracı m)
{
try
{
cmd.CommandText = "Update Hurda SET Cikisaati='" + m.Cikisaati + "' Where Tarih='" + m.Tarih + "'and Adisoyadi='" + m.Adisoyadi + "' and Plaka='" + m.Plaka + "' and Girisaati='" + m.Girisaati + "'and Firma='" + m.Firma + "'and ID='" + m.ID + "'and Cikisaati='ÇIKIŞ YAPILMADI'";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void Ekle(HurdaAracı m)
{
try
{
cmd.CommandText = "INSERT INTO Hurda (Tarih,Adisoyadi,Plaka,Ekbilgi,Girisaati,Firma,Cikisaati) VALUES('" + m.Tarih + "','" + m.Adisoyadi + "','" + m.Plaka + "','" + m.Ekbilgi + "','" + m.Girisaati + "','" + m.Firma + "','" + m.Cikisaati + "')";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void Sil(HurdaAracı m)
{
try
{
cmd.CommandText = "DELETE FROM Hurda WHERE ID='" + m.ID + "'";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public List <HurdaAracı> Listele()
{
try
{
List <HurdaAracı> HurdaAraciListesi = new List <HurdaAracı>();
cmd.CommandText = "SELECT * FROM Hurda WHERE Cikisaati ='ÇIKIŞ YAPILMADI' ";
cmd.CommandType = CommandType.Text;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
HurdaAracı m = new HurdaAracı();
m.ID = Convert.ToInt32(reader[0]);
m.Tarih = reader[1].ToString();
m.Adisoyadi = reader[2].ToString();
m.Plaka = reader[3].ToString();
m.Ekbilgi = reader[4].ToString();
m.Girisaati = reader[5].ToString();
m.Cikisaati = reader[6].ToString();
m.Firma = reader[7].ToString();
HurdaAraciListesi.Add(m);
}
return(HurdaAraciListesi);
}
catch
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public List <HurdaAracı> Listele10(string a, string b, string c)
{
try
{
List <HurdaAracı> Hurdacikti = new List <HurdaAracı>();
cmd.CommandText = "select* from hurdacikisf('" + a + "','" + b + "','" + c + "') Order by Convert(INT,REPLACE(GİRİŞSAATI,':','0')) asc";
cmd.CommandType = CommandType.Text;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
HurdaAracı s = new HurdaAracı();
s.Tarih = reader[0].ToString();
s.Plaka = reader[1].ToString();
s.Adisoyadi = reader[2].ToString();
s.Firma = reader[3].ToString();
s.Ekbilgi = reader[4].ToString();
s.Girisaati = reader[5].ToString();
s.Cikisaati = reader[6].ToString();
Hurdacikti.Add(s);
}
return(Hurdacikti);
}
catch
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
