private void button_repaired_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(textBox_price.Text))
{
MessageBox.Show("Wpisz poniesiony koszt na naprawę", "Error check", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
int row = dataGridView_cars_on_service.CurrentCell.RowIndex;
int car_id = (int)dataGridView_cars_on_service.Rows[row].Cells[0].Value;
int service_id = (int)dataGridView_cars_on_service.Rows[row].Cells[1].Value;
Care_serviceSet care = db.Care_serviceSets.Where(p => p.ServiceSet.service_id == service_id).First();
care.data_to = DateTime.Today;
Check_vehicleSet check = db.Check_vehicleSets.Where(p => p.Vehicle_vehicle_id == car_id).First();
ServiceSet service = db.ServiceSets.Where(p => p.service_id == service_id).First();
service.is_repair = true;
VehicleSet veh = db.VehicleSets.Where(p => p.vehicle_id == car_id).First();
veh.available = "yes";
if (service.name == "Wymiana oleju + filtry")
{
check.oil_change_mileage += 15000;
}
else if (service.name == "Wymiana rozrzadu")
{
check.timing_gear_mileage += 15000;
}
else if (service.name == "Przegląd")
{
check.tech_review.AddYears(1);
}
care.price = Convert.ToDouble(textBox_price.Text);
db.SubmitChanges();
fillDataGridView();
fillDataGridView2();
textBox_price.Clear();
}
catch (Exception)
{
MessageBox.Show("Zaznacz samochód, który został naprawiony", "Error check", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void button_add_car_Click(object sender, EventArgs e)
{
double consump = 0;
bool confirm = false;
try
{
if (textBox_avg_fuel.Text.Contains("."))
{
consump = Convert.ToDouble(textBox_avg_fuel.Text.Replace('.', ','));
}
else
{
consump = Convert.ToDouble(textBox_avg_fuel.Text);
}
}
catch {
MessageBox.Show("Bład dodania auta", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
using (DataBaseDataContext db = new DataBaseDataContext())
{
string plate = textBox_license.Text;
string plateV1 = plate.ToUpper();
try
{
VehicleSet car = new VehicleSet()
{
brand = textBox_brand.Text,
model = textBox_model.Text,
version = comboBox_car_version.Text,
equipment = "",
licence_plate = plateV1,
fuel_type = comboBox_type_of_fuel.Text,
avg_consumption = Convert.ToDouble(consump),
available = "yes",
mileage = Convert.ToInt32(textBox_mileage.Text)
};
db.VehicleSets.InsertOnSubmit(car);
db.SubmitChanges();
VehicleSet newcar = db.VehicleSets.OrderByDescending(p => p.vehicle_id).First();
Check_vehicleSet check = new Check_vehicleSet()
{
tech_review = dateTimePicker_date_tech.Value,
oil_change = dateTimePicker_oil_date.Value,
oil_change_mileage = Convert.ToInt32(textBox_oil_km.Text),
timing_gear = dateTimePicker_gear_date.Value,
timing_gear_mileage = Convert.ToInt32(textBox_gear_km.Text),
Vehicle_vehicle_id = newcar.vehicle_id,
};
db.Check_vehicleSets.InsertOnSubmit(check);
db.SubmitChanges();
confirm = true;
}
catch
{
MessageBox.Show("Bład dodania auta", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (confirm)
{
MessageBox.Show("Dodano auto", "Potwierdzenie", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
textBox_age.Clear();
textBox_avg_fuel.Clear();
textBox_brand.Clear();
textBox_license.Clear();
textBox_mileage.Clear();
textBox_model.Clear();
textBox_oil_km.Clear();
textBox_gear_km.Clear();
}
}
}
