public Spartane.Core.Classes.Estatus_Paciente.Estatus_PacientePagingModel ListaSelAll(int startRowIndex, int maximumRows, string Where, string Order)
        {
            var padstartRowIndex = _dataProvider.GetParameter();
            padstartRowIndex.ParameterName = "startRowIndex";
            padstartRowIndex.DbType = DbType.Int32;
            padstartRowIndex.Value = startRowIndex;

            var padmaximumRows = _dataProvider.GetParameter();
            padmaximumRows.ParameterName = "maximumRows";
            padmaximumRows.DbType = DbType.Int32;
            padmaximumRows.Value = maximumRows;

            var padWhere = _dataProvider.GetParameter();
            padWhere.ParameterName = "Where";
            padWhere.DbType = DbType.String;
            padWhere.Value = Where;

            var padOrder = _dataProvider.GetParameter();
            padOrder.ParameterName = "Order";
            padOrder.DbType = DbType.String;
            padOrder.Value = Order;

            var data = _dbContext.ExecuteStoredProcedureList<Spartane.Core.Classes.StoredProcedure.SpListSelAllEstatus_Paciente>("sp_ListSelAll_Estatus_Paciente", padWhere, padOrder, padstartRowIndex, padmaximumRows);

            Estatus_PacientePagingModel result = null;

            if (data != null)
            {
                result = new Estatus_PacientePagingModel
                {
                    Estatus_Pacientes =
                        data.Select(m => new Spartane.Core.Classes.Estatus_Paciente.Estatus_Paciente
                {
                    Clave = m.Estatus_Paciente_Clave
                    ,Descripcion = m.Estatus_Paciente_Descripcion

                    //,Id = m.Id
                }).ToList()
                };
            }
            return result;

        }
        public Spartane.Core.Domain.Estatus_Paciente.Estatus_PacientePagingModel ListaSelAll(int startRowIndex, int maximumRows, string Where, string Order)
        {
            Estatus_PacientePagingModel result = null;

            return(result);
        }