private void button_rent_Click(object sender, EventArgs e)
{
try
{
int row = dataGridView_veh_DB.CurrentCell.RowIndex;
car_id = (int)dataGridView_veh_DB.Rows[row].Cells[0].Value;
if (comboBox_purpose_of_rent.Text == "Służbowy" || comboBox_purpose_of_rent.Text == "Prywatny" || comboBox_purpose_of_rent.Text == "Delegacja")
{
var counter_modulo = db.RentSets
.Where(x => x.Worker_worker_id == user_id &&
((x.date_from <= time_from &&
x.date_to >= time_from) ||
(x.date_from <= time_to &&
x.date_to >= time_to)) && x.mileage_end == 0)
.Select(x => x.rent_id)
.Count();
if (counter_modulo == 0)
{
try
{
ReservationSet newReserv = new ReservationSet()
{
purpose = comboBox_purpose_of_rent.Text,
date_from = time_from,
date_to = time_to,
Worker_worker_id = user_id,
Vehicle_vehicle_id = car_id
};
db.ReservationSets.InsertOnSubmit(newReserv);
db.SubmitChanges();
}
catch (Exception)
{
MessageBox.Show("Nie udało się dokonać wypożyczenia pojazdu", "Error Rent", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
var mileage_st = (from x in db.VehicleSets
where x.vehicle_id == car_id
select x.mileage)
.Single();
ReservationSet reserv = db.ReservationSets
.Where(x => x.date_to == time_to &&
x.date_from == time_from &&
x.Vehicle_vehicle_id == car_id)
.First();
RentSet newRent = new RentSet()
{
purpose = comboBox_purpose_of_rent.Text,
date_from = time_from,
date_to = time_to,
mileage_start = mileage_st,
Worker_worker_id = user_id,
Reservation_reservation_id = reserv.reservation_id,
Vehicle_vehicle_id = car_id
};
db.RentSets.InsertOnSubmit(newRent);
db.SubmitChanges();
MessageBox.Show("Wypożyczyłeś pojazd od dzisiaj do " + time_to.Date.ToShortDateString(), "Good Rent", MessageBoxButtons.OK, MessageBoxIcon.Information);
fillDataGridView();
}
catch (Exception)
{
MessageBox.Show("Nie udało się dokonać wypożyczenia pojazdu", "Error Rent", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Masz już wypożyczone auto w takim okresie", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Wybierz cel wypożyczenia", "Error Car", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception)
{
MessageBox.Show("Zaznacz auto które chcesz wypożyczyć", "Error Car", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button_rent_Click(object sender, EventArgs e)
{
try
{
if (row == -1)
{
MessageBox.Show("Zaznacz rezerwację", "Good Rent", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var time_from = Convert.ToDateTime(dataGridView_my_reservation.Rows[row].Cells[4].Value.ToString());
var time_to = Convert.ToDateTime((string)dataGridView_my_reservation.Rows[row].Cells[5].Value.ToString());
var counter_modulo = db.RentSets
.Where(x => x.Worker_worker_id == user_id &&
((x.date_from <= time_from &&
x.date_to >= time_from) ||
(x.date_from <= time_to &&
x.date_to >= time_to)))
.Select(x => x.rent_id)
.Count();
if (time_from > DateTime.Today)
{
MessageBox.Show("Jeszcze nie możesz wypożyczyć tego samochodu, możesz to zrobić: \n" + time_from.ToShortDateString(), "Good Rent", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
if (counter_modulo == 0)
{
RentSet newRent = new RentSet()
{
purpose = dataGridView_my_reservation.Rows[row].Cells[7].Value.ToString(),
date_from = Convert.ToDateTime(dataGridView_my_reservation.Rows[row].Cells[4].Value),
date_to = Convert.ToDateTime(dataGridView_my_reservation.Rows[row].Cells[5].Value),
mileage_start = Convert.ToInt32(dataGridView_my_reservation.Rows[row].Cells[8].Value),
Worker_worker_id = user_id,
Reservation_reservation_id = Convert.ToInt32(dataGridView_my_reservation.Rows[row].Cells[9].Value),
Vehicle_vehicle_id = Convert.ToInt32(dataGridView_my_reservation.Rows[row].Cells[0].Value),
mileage_end = 0
};
db.RentSets.InsertOnSubmit(newRent);
db.SubmitChanges();
MessageBox.Show("Wypożyczyłeś samochód, bezpiecznej jazdy", "Good Rent", MessageBoxButtons.OK, MessageBoxIcon.Information);
fillDataGridView();
}
else
{
MessageBox.Show("Masz już wypożyczone auto w takim okresie", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
catch (Exception)
{
MessageBox.Show("Coś się popsuło i nie było mnie słychać", "Good Rent", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
clear();
}
