private ReservationSearchRequest GetSearchRequest()
{
ReservationSearchRequest searchRequest = new ReservationSearchRequest();
searchRequest = ApplyDefaultSearchValues(searchRequest) as ReservationSearchRequest;
searchRequest.PageIndex = pagination.PageIndex;
searchRequest.CustomerFullName = txtCustomer.Text;
searchRequest.Movie = txtMovie.Text;
if (!_dateFilterCleared)
{
searchRequest.CreatedAt = dtpDateAdded.Value.ToUniversalTime();
}
else
{
searchRequest.CreatedAt = null;
}
Enum.TryParse(cmbStatus.SelectedValue.ToString(), out ReservationStatus timingStatus);
searchRequest.Status = timingStatus;
AddIncludes(ref searchRequest);
if (int.TryParse(txtReservationId.Text, out int searchReservationId))
{
searchRequest.ReservationId = searchReservationId;
}
if (int.TryParse(txtPrice.Text, out int searchPrice))
{
searchRequest.Price = searchPrice;
}
return(searchRequest);
}
private async void SearchButton_Click(object sender, EventArgs e)
{
//var textBoxes = filterPanel.Controls.OfType<TextBox>().ToArray();
//if (!textBoxes.Any(_ => string.IsNullOrEmpty(_.Text)) || string.IsNullOrEmpty(mtxtBox_FromDate.Text)) return;
var request = new ReservationSearchRequest();
request.FromDate = (mtxtBox_FromDate.Text != " - -") ? DateTime.Parse(mtxtBox_FromDate.Text) : DateTime.MinValue;
request.ToDate = (mTxtBox_ToDate.Text != " - -") ? DateTime.Parse(mTxtBox_ToDate.Text) : DateTime.MinValue;
//request.DateReserved = (mtxtBox_FromDate.Text != " - -") ? DateTime.Parse(mtxtBox_FromDate.Text) : DateTime.MinValue;
request.Canceled = txtBox_Canceled.Text == "YES" ? true : false;
request.FromDays = !string.IsNullOrEmpty(txtBox_FromDays.Text) ? int.Parse(txtBox_FromDays.Text) : 0;
request.ToDays = !string.IsNullOrEmpty(txtBox_ToDays.Text) ? int.Parse(txtBox_ToDays.Text) : 0;
request.FromPersons = !string.IsNullOrEmpty(txtBox_FromPersons.Text) ? int.Parse(txtBox_FromPersons.Text) : 0;
request.ToPersons = !string.IsNullOrEmpty(txtBox_ToPersons.Text) ? int.Parse(txtBox_ToPersons.Text) : 0;
request.FromPrice = !string.IsNullOrEmpty(txtBox_FromPrice.Text) ? float.Parse(txtBox_FromPrice.Text) : 0;
request.ToPrice = !string.IsNullOrEmpty(txtBox_ToPrice.Text) ? float.Parse(txtBox_ToPrice.Text) : 0;
var result = await _service.Get <List <ReservationDTO> >(request);
BindingSource source = new BindingSource(result, null);
reservationGrid.DataSource = source;
reservationGrid.Columns[0].Visible = false;
reservationGrid.Columns[1].Visible = false;
reservationGrid.Columns[2].Visible = false;
reservationGrid.Columns[3].Visible = false;
}
private static ReservationSearchRequest AddIncludes(ref ReservationSearchRequest searchRequest)
{
searchRequest.Includes.Add("User");
searchRequest.Includes.Add("Invoice");
searchRequest.Includes.Add("Screening.Movie");
return(searchRequest);
}
private async Task LoadReservations(int vehicleManufacturerId = 0, int year = 0)
{
var vehicleList = await _vehicleService.Get <List <Model.VehicleModel> >(null);
var vehicleManufacturerList = await _vehicleManufacturerService.Get <List <VehicleManufacturerModel> >(null);
var vehicleModelList = await _vehicleModelService.Get <List <Model.VehicleModelModel> >(null);
if (vehicleManufacturerId != 0 || year != 0)
{
var request = new ReservationSearchRequest();
if (vehicleManufacturerId != 0)
{
request.VehicleManufacturerId = vehicleManufacturerId;
}
if (year != 0)
{
request.ReservationYear = year;
}
var reservationsList = await _reservationService.Get <List <ReservationModel> >(request);
var result = GenerateResult(reservationsList, vehicleList, vehicleManufacturerList, vehicleModelList);
foreach (var x in result)
{
foreach (var y in result)
{
if (x.ReservationYear == y.ReservationYear)
{
x.TotalPrice += y.ReservationPrice;
}
}
}
dgvDisplay.AutoGenerateColumns = false;
dgvDisplay.DataSource = result;
}
else
{
var reservationsList = await _reservationService.Get <List <ReservationModel> >(null);
var result = GenerateResult(reservationsList, vehicleList, vehicleManufacturerList, vehicleModelList);
foreach (var x in result)
{
foreach (var y in result)
{
if (x.ReservationYear == y.ReservationYear)
{
x.TotalPrice += y.ReservationPrice;
}
}
}
dgvDisplay.AutoGenerateColumns = false;
dgvDisplay.DataSource = result;
}
}
private async Task LoadReservations(ReservationSearchRequest searchRequest)
{
var result = await _reservationsApi.Get <PagedList <ReservationDto> >(searchRequest);
grdReservationsList.AutoGenerateColumns = false;
grdReservationsList.DataSource = result.Data;
SetReservationCancelationButtons();
pagination.PageIndex = result.PageIndex;
pagination.TotalPages = result.TotalPages;
}
public async Task <IPagedList <ReservationDto> > GetPagedAsync(ReservationSearchRequest search)
{
var list = await _reservationRepo.GetPagedAsync(search, search.ReservationId, search.Movie, search.CustomerFullName, search.Price, search.CreatedAt, search.Status);
var dtoList = PagedList <ReservationDto> .Map <Reservation>(_mapper, list);
foreach (var reservation in dtoList.Data)
{
reservation.Status = GetReservationStatus(reservation);
}
return(dtoList);
}
private async void grdReservationsList_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridViewColumn clickedColumn = grdReservationsList.Columns[e.ColumnIndex];
string clickedColumnName = clickedColumn.Name;
ChangeSorting(clickedColumnName);
ReservationSearchRequest searchRequest = GetSearchRequest();
searchRequest.SortColumn = CurrentSortPropertyName;
searchRequest.SortOrder = CurrentSortOrder;
await LoadReservations(searchRequest);
}
private async Task LoadReservations(int vehicleId = 0, int insuranceId = 0)
{
var vehicleList = await _vehicleService.Get <List <OpenRoads.Model.VehicleModel> >(null);
var insuranceList = await _insuranceService.Get <List <InsuranceModel> >(null);
var clientList = await _clientService.Get <List <ClientModel> >(null);
var personList = await _personService.Get <List <PersonModel> >(null);
var modelList = await _vehicleModelService.Get <List <VehicleModelModel> >(null);
var manufacturerList = await _vehicleManufacturerService.Get <List <VehicleManufacturerModel> >(null);
if (vehicleId != 0 || insuranceId != 0)
{
var request = new ReservationSearchRequest();
if (vehicleId != 0)
{
request.VehicleId = vehicleId;
}
if (insuranceId != 0)
{
request.InsuranceId = insuranceId;
}
var reservations = await _reservationService.Get <List <ReservationModel> >(request);
var result = GenerateResult(reservations, vehicleList, insuranceList, clientList, personList, modelList,
manufacturerList);
dgvReservations.AutoGenerateColumns = false;
dgvReservations.DataSource = result;
}
else
{
var reservations = await _reservationService.Get <List <ReservationModel> >(null);
var result = GenerateResult(reservations, vehicleList, insuranceList, clientList, personList, modelList,
manufacturerList);
dgvReservations.AutoGenerateColumns = false;
dgvReservations.DataSource = result;
}
}
private async void FormReservationList_Load(object sender, EventArgs e)
{
this.grdReservationsList.DoubleBuffered(true);
ReservationSearchRequest searchRequest = new ReservationSearchRequest();
AddIncludes(ref searchRequest);
searchRequest = ApplyDefaultSearchValues(searchRequest) as ReservationSearchRequest;
cmbStatus.DataSource = Enum.GetValues(typeof(ReservationStatus));
cmbStatus.SelectedItem = ReservationStatus.PAID;
/* The handler is added code-first in order to prevent the SearchChanged method being triggered
* in the value initialisation for status above.*/
cmbStatus.SelectedIndexChanged += new EventHandler(SearchChanged);
await LoadReservations(searchRequest);
}
private async void grdReservationsList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn &&
e.RowIndex >= 0)
{
var clickedRow = senderGrid.Rows[e.RowIndex];
int.TryParse(clickedRow.Cells["id"].Value.ToString(), out int reservationId);
bool success = await _reservationsApi.Update <bool>(reservationId, null, "status");
if (success)
{
ReservationSearchRequest searchRequest = GetSearchRequest();
await LoadReservations(searchRequest);
}
}
}
private async Task LoadReservations()
{
try
{
var client = await _clientService.GetById <ClientModel>(APIService.LoggedUserId);
var request = new ReservationSearchRequest();
request.ClientId = client.ClientId;
var reservations = await _reservationService.Get <List <ReservationModel> >(request);
var vehicleList = await _vehicleService.Get <List <OpenRoads.Model.VehicleModel> >(null);
var vehicleModelList = await _vehicleModelService.Get <List <OpenRoads.Model.VehicleModelModel> >(null);
var vehicleManufacturersList =
await _vehicleManufacturerService.Get <List <VehicleManufacturerModel> >(null);
//Loop through client reservations
foreach (var reservation in reservations)
{
//If canceled don't consider it
if (!reservation.Canceled)
{
//Check if finished else it's active
if (reservation.DateTo < DateTime.Now)
{
ReservationToDisplay newFinishedRes = new ReservationToDisplay
{
ReservationId = reservation.ReservationId,
ClientId = client.ClientId,
Active = reservation.Active,
CreationDate = reservation.CreationDate.ToString("dd.MM.yyyy"),
DateFrom = reservation.DateFrom.ToString("dd.MM.yyyy"),
DateTo = reservation.DateTo.ToString("dd.MM.yyyy"),
Price = reservation.Price + "KM"
};
AddVehicleAttrs(newFinishedRes, vehicleList, vehicleModelList, vehicleManufacturersList, reservation.VehicleId);
ReservationFinishedList.Add(newFinishedRes);
}
else
{
ReservationToDisplay newActiveRes = new ReservationToDisplay
{
ReservationId = reservation.ReservationId,
ClientId = client.ClientId,
Active = reservation.Active,
CreationDate = reservation.CreationDate.ToString("dd.MM.yyyy"),
DateFrom = reservation.DateFrom.ToString("dd.MM.yyyy"),
DateTo = reservation.DateTo.ToString("dd.MM.yyyy"),
Price = reservation.Price + "KM"
};
AddVehicleAttrs(newActiveRes, vehicleList, vehicleModelList, vehicleManufacturersList, reservation.VehicleId);
ReservationActiveList.Add(newActiveRes);
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
private async void SearchChanged(object sender, EventArgs e)
{
ReservationSearchRequest searchRequest = GetSearchRequest();
await LoadReservations(searchRequest);
}
