private void refreshDataGrid() { dataGrid.ItemsSource = null; carDatas.Clear(); DataBaseReader DBreader = new DataBaseReader(); DBreader.CommandText = "SELECT * FROM StartedCarRepairRecords"; DBreader.execCommand(); while (DBreader.SQLiteDataReader.Read()) { CarData carData = new CarData(); carData.DBId = DBreader.SQLiteDataReader.GetInt32(0); carData.ClientName = DBreader.SQLiteDataReader.GetString(1); carData.ClientSurname = DBreader.SQLiteDataReader.GetString(2); carData.ClientPhone = DBreader.SQLiteDataReader.GetString(3); carData.TimeAdded = DBreader.SQLiteDataReader.GetInt32(4); carData.CarMake = DBreader.SQLiteDataReader.GetInt32(5); carData.CarModel = DBreader.SQLiteDataReader.GetString(6); carData.CarNR = DBreader.SQLiteDataReader.GetString(7); carData.CarID = DBreader.SQLiteDataReader.GetString(8); carData.EngineVol = DBreader.SQLiteDataReader.GetInt32(9); carData.EnginePower = DBreader.SQLiteDataReader.GetInt32(10); carData.FuelType = DBreader.SQLiteDataReader.GetInt32(11); carData.formatData(); carDatas.Add(carData); } DBreader.closeConnection(); dataGrid.ItemsSource = carDatas; }
public FinishedCarBrowser() { InitializeComponent(); finishedCarDatas.Clear(); DataBaseReader DBreader = new DataBaseReader(); DBreader.CommandText = "SELECT * FROM FinishedCarRepairRecords"; DBreader.execCommand(); while (DBreader.SQLiteDataReader.Read()) { CarData carData = new CarData(); carData.DBId = DBreader.SQLiteDataReader.GetInt32(0); carData.ClientName = DBreader.SQLiteDataReader.GetString(1); carData.ClientSurname = DBreader.SQLiteDataReader.GetString(2); carData.ClientPhone = DBreader.SQLiteDataReader.GetString(3); carData.TimeAdded = DBreader.SQLiteDataReader.GetInt32(4); //change formatting carData.CarMake = DBreader.SQLiteDataReader.GetInt32(5); //change formatting carData.CarModel = DBreader.SQLiteDataReader.GetString(6); carData.CarNR = DBreader.SQLiteDataReader.GetString(7); carData.CarID = DBreader.SQLiteDataReader.GetString(8); carData.EngineVol = DBreader.SQLiteDataReader.GetInt32(9); carData.EnginePower = DBreader.SQLiteDataReader.GetInt32(10); carData.FuelType = DBreader.SQLiteDataReader.GetInt32(11); //chage formatting carData.WorkDescription = DBreader.SQLiteDataReader.GetString(12); carData.WorkPrice = DBreader.SQLiteDataReader.GetFloat(13); carData.formatData(); finishedCarDatas.Add(carData); } DBreader.closeConnection(); dataGrid.ItemsSource = finishedCarDatas; }