Exemplo n.º 1
0
        public TransportForm Map(DbDataReader dbDataReader)
        {
            AdministrativeEmployeeRepository administrativeEmployeeRepository = new AdministrativeEmployeeRepository(dbConnection);
            AdministrativeEmployee           dispatcher = administrativeEmployeeRepository.Search(dbDataReader.GetString(8), true);
            VehicleRepository vehicleRepository         = new VehicleRepository(dbConnection);
            Vehicle           vehicle         = vehicleRepository.Search(dbDataReader.GetString(6));
            RouteRepository   routeRepository = new RouteRepository(dbConnection);
            Route             route           = routeRepository.Search(dbDataReader.GetString(7));

            if (dispatcher is null || vehicle is null || route is null)
            {
                return(null);
            }

            string   transport_form_number = dbDataReader.GetString(0);
            bool     state = dbDataReader.GetBoolean(1);
            DateTime startDate, depatureTime;

            startDate = dbDataReader.GetDateTime(2);

            depatureTime = dbDataReader.GetDateTime(3);

            TransportForm transportForm = new TransportForm(transport_form_number, route, vehicle, dispatcher, startDate, depatureTime, state);


            transportForm.AddFinalcialInformation(ReplacementFund, dbDataReader.GetDecimal(9));
            transportForm.AddFinalcialInformation(SocialContribution, dbDataReader.GetDecimal(10));
            transportForm.AddFinalcialInformation(TireService, dbDataReader.GetDecimal(11));
            transportForm.AddFinalcialInformation(VehicleFixService, dbDataReader.GetDecimal(12));
            transportForm.AddFinalcialInformation(NonContractualSecureService, dbDataReader.GetDecimal(13));
            transportForm.AddFinalcialInformation(ConstactInsuranceService, dbDataReader.GetDecimal(14));
            transportForm.AddFinalcialInformation(SocialProtection, dbDataReader.GetDecimal(15));
            transportForm.AddFinalcialInformation(ExtraordinaryProtection, dbDataReader.GetDecimal(16));
            transportForm.AddFinalcialInformation(Administration, dbDataReader.GetDecimal(17));
            transportForm.AddFinalcialInformation(Others, dbDataReader.GetDecimal(18));

            using (DbCommand ticketCommand = CreateCommand())
            {
                ticketCommand.CommandText = "SELECT seats, ticket_date, passenger FROM tickets WHERE transport_form_number = @transport_form_number";

                ticketCommand.Parameters.Add(CreateDbParameter(ticketCommand, "@transport_form_number", transportForm.Number));

                DbDataReader     ticketDataReader = ticketCommand.ExecuteReader();
                PersonRepository personRepository = new PersonRepository(dbConnection);

                while (ticketDataReader.Read())
                {
                    if (!(personRepository.Search(ticketDataReader.GetString(2)) is Person passenger))
                    {
                        continue;
                    }

                    transportForm.AddTicket(passenger.ToPassenger(), ticketDataReader.GetInt16(0), ticketDataReader.GetDateTime(1));
                }
            }

            transportForm.UpdateTotalValue();

            return(transportForm);
        }
Exemplo n.º 2
0
        private void LoginSucces(AdministrativeEmployee administrativeEmployee)
        {
            WindowState            = WindowState.Maximized;
            AdministrativeEmployee = administrativeEmployee;

            if (AdministrativeEmployee.User.IsDispatcher())
            {
                SetMainPanel(new DispatcherMainPanel(LogOutAction));
            }
            else
            {
                SetMainPanel(new MainPanel(LogOutAction));
            }

            LoadCurrentTransportForm();
        }
Exemplo n.º 3
0
        public Commend Map(DbDataReader dbDataReader)
        {
            Person           sender, receiver;
            PersonRepository personRepository = new PersonRepository(dbConnection);

            sender   = personRepository.Search(dbDataReader.GetString(4));
            receiver = personRepository.Search(dbDataReader.GetString(5));

            if (sender is null || receiver is null)
            {
                return(null);
            }

            AdministrativeEmployeeRepository administrativeEmployee = new AdministrativeEmployeeRepository(dbConnection);
            VehicleRepository      vehicleRepository = new VehicleRepository(dbConnection);
            AdministrativeEmployee dispatcher        = administrativeEmployee.Search(dbDataReader.GetString(6), true);
            Vehicle vehicle = vehicleRepository.Search(dbDataReader.GetString(7));

            if (dispatcher is null || vehicle is null)
            {
                return(null);
            }

            string   delivery_number, destination, description;
            DateTime delivery_date;
            decimal  freightValue, agreement;
            State    state;

            delivery_number = dbDataReader.GetString(0);
            delivery_date   = dbDataReader.GetDateTime(1);
            description     = dbDataReader.GetString(10);
            destination     = dbDataReader.GetString(2);

            freightValue = dbDataReader.GetDecimal(8);
            agreement    = dbDataReader.GetDecimal(9);

            string stateStr = dbDataReader.GetString(3);

            state = (stateStr == "D") ? State.Delivered : (stateStr == "C") ? State.Cancel : State.Active;

            return(new Commend(delivery_number, delivery_date, sender, receiver, dispatcher, destination, description, freightValue, agreement, vehicle, state));
        }
Exemplo n.º 4
0
        public BankDraft Map(DbDataReader dbDataReader)
        {
            Person           sender, receiver;
            PersonRepository personRepository = new PersonRepository(dbConnection);

            sender   = personRepository.Search(dbDataReader.GetString(4));
            receiver = personRepository.Search(dbDataReader.GetString(5));

            if (sender is null || receiver is null)
            {
                return(null);
            }

            AdministrativeEmployeeRepository administrativeEmployeeRepository = new AdministrativeEmployeeRepository(dbConnection);
            AdministrativeEmployee           dispatcher = administrativeEmployeeRepository.Search(dbDataReader.GetString(6), true);

            if (dispatcher is null)
            {
                return(null);
            }

            string   delivery_number, destination;
            DateTime delivery_date;
            decimal  valueToSend, cost;
            State    state;

            delivery_number = dbDataReader.GetString(0);
            delivery_date   = dbDataReader.GetDateTime(1);
            destination     = dbDataReader.GetString(2);

            valueToSend = dbDataReader.GetDecimal(7);
            cost        = dbDataReader.GetDecimal(8);

            string stateStr = dbDataReader.GetString(3);

            state = (stateStr == "D") ? State.Delivered : (stateStr == "C") ? State.Cancel : State.Active;

            return(new BankDraft(delivery_number, delivery_date, sender, receiver, dispatcher, destination, valueToSend, cost, state));
        }