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);
        }
Beispiel #2
0
        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);
 }
Beispiel #4
0
        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;
        }
Beispiel #6
0
        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);
        }
Beispiel #8
0
        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);
                }
            }
        }
Beispiel #11
0
        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);
        }