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 AddCarWindow()
{
InitializeComponent();
//sett todays date in datapicker
acceptanceDateCB.SelectedDate = DateTime.Today;
//populate car brand combobox
DataBaseReader DBreader = new DataBaseReader {
CommandText = "SELECT Brand FROM CarBrands"
};
DBreader.execCommand();
while (DBreader.SQLiteDataReader.Read())
{
makeCB.Items.Add(DBreader.SQLiteDataReader.GetString(0));
}
DBreader.closeConnection();
//populate fuel type combo box
DBreader = new DataBaseReader {
CommandText = "SELECT FuelType FROM FuelType"
};
DBreader.execCommand();
while (DBreader.SQLiteDataReader.Read())
{
fuelTypeCB.Items.Add(DBreader.SQLiteDataReader.GetString(0));
}
DBreader.closeConnection();
}
public FinishCarWindow(CarData carData)
{
InitializeComponent();
localCarData = carData;
//populate car brand combobox
DataBaseReader DBreader = new DataBaseReader {
CommandText = "SELECT Brand FROM CarBrands"
};
DBreader.execCommand();
while (DBreader.SQLiteDataReader.Read())
{
makeCB.Items.Add(DBreader.SQLiteDataReader.GetString(0));
}
DBreader.closeConnection();
//populate fuel type combo box
DBreader = new DataBaseReader {
CommandText = "SELECT FuelType FROM FuelType"
};
DBreader.execCommand();
while (DBreader.SQLiteDataReader.Read())
{
fuelTypeCB.Items.Add(DBreader.SQLiteDataReader.GetString(0));
}
DBreader.closeConnection();
nameTB.Text = localCarData.ClientName;
surnameTB.Text = localCarData.ClientSurname;
phoneTB.Text = localCarData.ClientPhone;
modelTB.Text = localCarData.CarModel;
carNRTB.Text = localCarData.CarNR;
carIDTB.Text = localCarData.CarID;
enginePowerTB.Text = localCarData.EnginePower.ToString(); //fix this not showing properly
makeCB.SelectedIndex = localCarData.CarMake - 1;
fuelTypeCB.SelectedIndex = localCarData.FuelType - 1;
enginePowerTB.Text = localCarData.EnginePower.ToString();
engineVolumeCB.Text = localCarData.EngineVol.ToString();
DateTime dtDateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0, DateTimeKind.Utc);
acceptanceDateCB.SelectedDate = dtDateTime.AddSeconds(localCarData.TimeAdded).ToLocalTime();
}
private void deleteOrder(CarData carData)
{
try {
DataBaseReader DBreader = new DataBaseReader();
DBreader.SQLiteCommand = DBreader.SQLiteConnection.CreateCommand();
DBreader.SQLiteCommand.CommandText = "DELETE FROM StartedCarRepairRecords where id=@id";
DBreader.SQLiteCommand.Parameters.AddWithValue("@id", carData.DBId);
DBreader.SQLiteCommand.Prepare();
DBreader.SQLiteCommand.ExecuteNonQuery();
DBreader.closeConnection();
}
catch (Exception) {
throw;
}
}
//TODO: finish vars to make universal
public void formatData()
{
//carmakestring
try {
DataBaseReader DBreader = new DataBaseReader();
DBreader.SQLiteCommand = DBreader.SQLiteConnection.CreateCommand();
DBreader.SQLiteCommand.CommandText = "SELECT Brand from CarBrands WHERE ID=@id";
DBreader.SQLiteCommand.Parameters.AddWithValue("@id", this.CarMake);
DBreader.SQLiteCommand.Prepare();
DBreader.SQLiteDataReader = DBreader.SQLiteCommand.ExecuteReader();
DBreader.SQLiteDataReader.Read();
this.CarMakeString = DBreader.SQLiteDataReader.GetString(0);
DBreader.closeConnection();
int i = 0;
Console.WriteLine(i++);
}
catch (Exception ex) {
throw new Exception(ex.Message);
}
//Fueltypestring
try {
DataBaseReader DBreader = new DataBaseReader();
DBreader.SQLiteCommand = DBreader.SQLiteConnection.CreateCommand();
DBreader.SQLiteCommand.CommandText = "SELECT FuelType from FuelType WHERE ID=@id";
DBreader.SQLiteCommand.Parameters.AddWithValue("@id", this.FuelType);
DBreader.SQLiteCommand.Prepare();
DBreader.SQLiteDataReader = DBreader.SQLiteCommand.ExecuteReader();
DBreader.SQLiteDataReader.Read();
this.FuelTypeString = DBreader.SQLiteDataReader.GetString(0);
}
catch (Exception ex) {
throw new Exception(ex.Message);
}
//format date time
DateTime dtDateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0, DateTimeKind.Utc);
this.TimeAddedFormatted = dtDateTime.AddSeconds(this.TimeAdded).ToLocalTime();
}
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;
}