private void button1_Click(object sender, EventArgs e)
{
var conString = ConfigurationManager.ConnectionStrings["DefaultContext"].ConnectionString;
using (SqlConnection connection = new SqlConnection(conString))
{
var cars = connection.Query <CarModel>(@"SELECT *
FROM [dbo].[Vehicle] AS v
JOIN Car AS c on v.[Vin_Number] = c.[Vin_Number]").ToList();
var trucks = connection.Query <TruckModel>(@" SELECT *
FROM [dbo].[Vehicle] AS v
JOIN Truck AS t on v.[Vin_Number] = t.[Vin_Number]").ToList();
CarGridView.DataSource = cars;
TruckGridView.DataSource = trucks;
CarGridView.CommitEdit(DataGridViewDataErrorContexts.Commit);
CarGridView.CellValueChanged -= CarGridView_CellValueChanged;
CarGridView.CellValueChanged += CarGridView_CellValueChanged;
TruckGridView.CommitEdit(DataGridViewDataErrorContexts.Commit);
TruckGridView.CellValueChanged -= TruckGridViewGridView_CellValueChanged;
TruckGridView.CellValueChanged += TruckGridViewGridView_CellValueChanged;
}
}
private void LoadCarList()
{
string connectionString = "Data Source=(local);Initial Catalog=Demo;Integrated Security=True";
string query = "Select id,name,availability from Cars";
CarGridView.DataSource = GetData(connectionString, query);
CarGridView.DataBind();
}
protected void FilterButton_Click(object sender, EventArgs e)
{
if (IsValid)
{
var startDate = DateTime.Parse(StartDateFilter.Text);
var endDate = DateTime.Parse(EndDateFilter.Text);
var type = TypeFilter.Text;
var price = PriceFilter.Text;
var cars = carRepository.GetAvailableCars();
var filterCar = cars.Where(car =>
{
foreach (var booking in car.Bookings)
{
if ((booking.StartDate >= startDate && booking.StartDate < endDate) ||
(booking.StartDate <= startDate && booking.EndDate >= startDate) &&
booking.Status == nameof(BookingStatus.Booked))
{
return(false);
}
}
return(true);
});
if (!string.IsNullOrEmpty(type))
{
filterCar = filterCar.Where(car => car.Type == type);
}
if (price == "Increasing")
{
filterCar = filterCar.OrderBy(car => car.Price);
}
else if (price == "Decreasing")
{
filterCar = filterCar.OrderByDescending(car => car.Price);
}
CarGridView.DataSource = filterCar;
CarGridView.DataBind();
}
}
