protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                if (Session["USER_ID"] == null)
                {
                    Response.Redirect("~/View/Home/index.aspx", false);
                }
                else
                {
                    ConsultStateCommand consultState = new ConsultStateCommand();

                    try
                    {
                        consultState.execute();
                        stateConsultList = consultState.getAnswer();

                        foreach (Place _place1 in stateConsultList)
                        {
                            state1.Items.Add(_place1._Name);
                            String test = _place1._Name;
                        }
                    }
                    catch (Exception stateEx)
                    {
                        throw stateEx;
                    }


                    String idPatient = Request.QueryString["patiendID"];

                    int idInt = Convert.ToInt32(idPatient);

                    consult = new Patient(idInt);

                    ConsultPatientInformationCommand command = new ConsultPatientInformationCommand(consult);

                    try
                    {
                        command.execute();
                        consulted = command.getAnswer();

                        nameTXT.Text          = consulted._Name;
                        surnameTXT.Text       = consulted._Surname;
                        ageTXT.Text           = consulted._Age.ToString();
                        career1.SelectedValue = consulted._Career;

                        foreach (Place _searchState in stateConsultList)
                        {
                            if (_searchState._Name == consulted._State)
                            {
                                state1.SelectedValue = consulted._State;
                            }
                        }

                        //MUNICIPIOS

                        String nameState = consulted._State;

                        Place consultstateID = new Place(nameState);

                        ConsultStateIDCommand consultIDState = new ConsultStateIDCommand(consultstateID);

                        try
                        {
                            consultIDState.execute();
                            _state  = consultIDState.getAnswer();
                            idState = _state._ID;

                            test2 = idState;

                            ConsultMunicipalityCommand cmd = new ConsultMunicipalityCommand(_state);

                            cmd.execute();
                            municipalityConsultList = cmd.getAnswer();

                            foreach (Place _municipality in municipalityConsultList)
                            {
                                municipality1.Items.Add(_municipality._Name);
                                _probando = _municipality;
                            }

                            foreach (Place _searchMunicipality in municipalityConsultList)
                            {
                                if (_searchMunicipality._Name == consulted._Municipality)
                                {
                                    municipality1.SelectedValue = consulted._Municipality;
                                }
                            }
                        }
                        catch (Exception stateEx)
                        {
                            throw stateEx;
                        }

                        //PARROQUIAS

                        String nameMunicipality = consulted._Municipality;

                        Place consultmunicipalityID = new Place(nameMunicipality);

                        ConsultMunicipalityIDCommand consultIDMunicipality = new ConsultMunicipalityIDCommand(consultmunicipalityID);

                        try
                        {
                            consultIDMunicipality.execute();
                            _municipality  = consultIDMunicipality.getAnswer();
                            idMunicipality = _municipality._ID;

                            ConsultParishCommand cmd = new ConsultParishCommand(_municipality);

                            cmd.execute();
                            parishConsultList = cmd.getAnswer();

                            foreach (Place _parish in parishConsultList)
                            {
                                parish1.Items.Add(_parish._Name);
                            }

                            foreach (Place _searchParish in parishConsultList)
                            {
                                if (_searchParish._Name == consulted._Parish)
                                {
                                    parish1.SelectedValue = consulted._Parish;
                                }
                            }
                        }
                        catch (Exception municipalityEx)
                        {
                            throw municipalityEx;
                        }
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                }
            }
        }
        protected void State_SelectedIndex(object sender, EventArgs e)
        {
            //PARROQUIA
            municipality1.Items.Clear();
            parish1.Items.Clear();

            String nameState = state1.SelectedItem.Text;

            Place consultstateID = new Place(nameState);

            ConsultStateIDCommand consultIDState = new ConsultStateIDCommand(consultstateID);

            try
            {
                consultIDState.execute();
                _state  = consultIDState.getAnswer();
                idState = _state._ID;

                test2 = idState;

                ConsultMunicipalityCommand cmdMunicipality = new ConsultMunicipalityCommand(_state);

                cmdMunicipality.execute();
                municipalityConsultList = cmdMunicipality.getAnswer();

                foreach (Place _municipality in municipalityConsultList)
                {
                    municipality1.Items.Add(_municipality._Name);
                }


                //MUNICIPIO

                String nameMunicipality = municipality1.Items[0].Text;

                Place consultmunicipalityID = new Place(nameMunicipality);

                ConsultMunicipalityIDCommand consultIDMunicipality = new ConsultMunicipalityIDCommand(consultmunicipalityID);

                try
                {
                    consultIDMunicipality.execute();
                    _municipality  = consultIDMunicipality.getAnswer();
                    idMunicipality = _municipality._ID;

                    ConsultParishCommand cmdParish = new ConsultParishCommand(_municipality);

                    cmdParish.execute();
                    parishConsultList = cmdParish.getAnswer();

                    foreach (Place _parish in parishConsultList)
                    {
                        parish1.Items.Add(_parish._Name);
                    }
                }
                catch (Exception municipalityEx)
                {
                    throw municipalityEx;
                }
            }
            catch (Exception stateEx)
            {
                throw stateEx;
            }
        }