public IHttpActionResult ValidateUser(string User, string Password)
        {
            var        dt         = blLogin.ValidateUser(User, Password);
            LoginModel loginModel = new LoginModel();

            loginModel.user.id             = int.Parse(dt.Rows[0]["id"].ToString());
            loginModel.user.roles_id       = int.Parse(dt.Rows[0]["roles_id"].ToString());
            loginModel.user.description    = dt.Rows[0]["description"].ToString();
            loginModel.user.persons_id     = int.Parse(dt.Rows[0]["persons_id"].ToString());
            loginModel.user.name           = dt.Rows[0]["name"].ToString();
            loginModel.user.password       = dt.Rows[0]["password"].ToString();
            loginModel.user.names          = dt.Rows[0]["names"].ToString();
            loginModel.user.lastnames      = dt.Rows[0]["lastnames"].ToString();
            loginModel.user.address        = dt.Rows[0]["address"].ToString();
            loginModel.user.phone          = dt.Rows[0]["phone"].ToString();
            loginModel.user.email          = dt.Rows[0]["email"].ToString();
            loginModel.user.documentnumber = dt.Rows[0]["documentnumber"].ToString();
            loginModel.user.ruc            = dt.Rows[0]["ruc"].ToString();
            loginModel.user.type           = dt.Rows[0]["type"].ToString();
            loginModel.user.bussinessname  = dt.Rows[0]["bussinessname"].ToString();
            loginModel.user.doctornumber   = dt.Rows[0]["doctornumber"].ToString();
            loginModel.user.speciality     = dt.Rows[0]["speciality"].ToString();

            if (dt == null)
            {
                throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
            }

            return(Json(loginModel));
        }
        private async void RegisterCommandExecuted()
        {
            try
            {
                if (!string.IsNullOrWhiteSpace(Email) && Validator.ValidateEmail(Email))
                {
                    if (!string.IsNullOrWhiteSpace(User) && Validator.ValidateLegth(User))
                    {
                        if (!string.IsNullOrWhiteSpace(Password) && Validator.ValidatePassword(Password) && !string.IsNullOrWhiteSpace(ConfirmPassword))
                        {
                            if (Password == ConfirmPassword)
                            {
                                if (!string.IsNullOrWhiteSpace(SelectedPicker))
                                {
                                    var response = await login.ValidateUser(User, Email);

                                    if (response)
                                    {
                                        await snack.SnackError("Hay un usuario registrado con esos datos");
                                    }
                                    else
                                    {
                                        var user = new UserModel();
                                        user.DateCreated = DateTime.Now;
                                        user.Email       = Email;
                                        user.Password    = Password;
                                        user.Sex         = SelectedPicker;
                                        user.Status      = true;
                                        user.User        = User;
                                        var result = await login.Insert(user);

                                        if (result)
                                        {
                                            App.Current.MainPage = new NavigationPage(new Views.Principal.HomePage());
                                        }
                                        else
                                        {
                                            await snack.SnackError("Ocurrio un error");
                                        }
                                    }
                                }
                                else
                                {
                                    await snack.SnackError("Seleccione un genero");
                                }
                            }
                            else
                            {
                                await snack.SnackError("Las contraseñas no coinciden");
                            }
                        }
                        else
                        {
                            await snack.SnackError("ingrese una contraseña valida");
                        }
                    }
                    else
                    {
                        await snack.SnackError("Ingrese un usuario valido");
                    }
                }
                else
                {
                    await snack.SnackError("Ingrese un email valido");
                }
            }
            catch (Exception ex)
            {
            }
        }
        private async void RegisterCommandExecuted()
        {
            try
            {
                if (!string.IsNullOrWhiteSpace(Email) && Validator.ValidateEmail(Email))
                {
                    if (!string.IsNullOrWhiteSpace(User) && Validator.ValidateLegth(User))
                    {
                        if (!string.IsNullOrWhiteSpace(Password) && Validator.ValidatePassword(Password) && !string.IsNullOrWhiteSpace(ConfirmPassword))
                        {
                            if (Password == ConfirmPassword)
                            {
                                if (!string.IsNullOrWhiteSpace(SelectedPicker))
                                {
                                    var response = await login.ValidateUser(User, Email);

                                    if (response)
                                    {
                                        await snack.SnackError("Hay un usuario registrado con esos datos");
                                    }
                                    else
                                    {
                                        var user = new UserModel();
                                        user.DateCreated = DateTime.Now;
                                        user.Email       = Email;
                                        user.Password    = Password;
                                        user.Sex         = SelectedPicker;
                                        user.Status      = true;
                                        user.User        = User;
                                        var result = await login.Insert(user);

                                        if (result)
                                        {
                                            await snack.SnackSuccess("se registro correctamente");

                                            await PopupNavigation.PopAsync();

                                            MessagingCenter.Send <AddUserPopupViewModel>(this, "sendAdd");
                                        }
                                        else
                                        {
                                            await snack.SnackError("Ocurrio un error");
                                        }
                                    }
                                }
                                else
                                {
                                    await snack.SnackError("Seleccione un genero");
                                }
                            }
                            else
                            {
                                await snack.SnackError("Las contraseñas no coinciden");
                            }
                        }
                        else
                        {
                            await snack.SnackError("ingrese una contraseña valida");
                        }
                    }
                    else
                    {
                        await snack.SnackError("Ingrese un usuario valido");
                    }
                }
                else
                {
                    await snack.SnackError("Ingrese un email valido");
                }
            }
            catch (Exception ex)
            {
            }
        }