private void btnUpload_Click(object sender, RoutedEventArgs e)
{
CarData d = new CarData(comboBox.SelectedValue.ToString(),
Convert.ToInt32(futottkm_text.Text), Convert.ToInt32(kmallas_text.Text),
Convert.ToInt32(fogyasztas_text.Text), szerviz_text.Text.ToString(),
Convert.ToInt32(ar_text.Text));
database.AddCarData(comboBox.SelectedValue.ToString(), d);
dataGrid.DataContext = database.GetCarData(comboBox.SelectedValue.ToString());
}
public void AddCarData(string carname, CarData car)
{
string sql = "INSERT INTO data ([autoid], [futottkm], [kmallas], [fogyasztas], [szerviz], [ar]) VALUES ([@Autoid], [@Futottkm], [@Kmallas], [@Fogyasztas], [@Szerviz], [@Ar])";
using (OleDbConnection cn = new OleDbConnection
(@"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = 'db.mdb'"))
using (OleDbCommand cmd = new OleDbCommand(sql, cn))
{
cn.Open();
cmd.Parameters.AddWithValue("@Autoid", GetAutoID(carname));
cmd.Parameters.AddWithValue("@Futottkm", car.futottkm);
cmd.Parameters.AddWithValue("@Kmallas", car.kmallas);
cmd.Parameters.AddWithValue("@Fogyasztas", car.fogyasztas);
cmd.Parameters.AddWithValue("@Szerviz", car.szerviz);
cmd.Parameters.AddWithValue("@Ar", car.ar);
cmd.ExecuteNonQuery();
cn.Close();
}
}
public List <CarData> GetCarDataList(string carname)
{
List <CarData> l = new List <CarData>();
CarData d;
string sql = "SELECT nev, futottkm, kmallas, fogyasztas, szerviz, ar FROM data INNER JOIN cars ON data.autoid = cars.id WHERE autoid=" + GetAutoID(carname);
OleDbCommand command = con.CreateCommand();
command.CommandText = sql;
command.CommandType = CommandType.Text;
try
{
con.Open();
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
d = new CarData(reader["nev"].ToString(), Convert.ToInt32(reader["futottkm"]), Convert.ToInt32(reader["kmallas"]), Convert.ToInt32(reader["fogyasztas"]), reader["szerviz"].ToString(), Convert.ToInt32(reader["ar"]));
l.Add(d);
}
return(l);
}
catch (Exception ex)
{
MessageBox.Show("Ellenőrizd az adatbázis kapcsolat meglétét!");
}
finally
{
if (con != null)
{
con.Close();
}
}
return(null);
}
