Post History

How to filter data from the view using MVVM Pattern?

I am trying to filter data in the DataGrid using the texboxes using the MVVM pattern. Just not sure how to do it. Would appreciate any guidance.

My current code:

**Model**

    public class Technical_BestBeforeDates_Model
    {
        public int Id { get; private set; }
        public string ProductCode { get; private set; }
        public string ProductDescription { get; private set; }
    }


**ViewModel**

    public class Technical_BestBeforeDates_ViewModel : BaseViewModel
    {
        // Properties
        public int Id { get; set; }
        public string ProductCode { get; set; }
        public string ProductDescription { get; set; }

        // Private model
        private Technical_BestBeforeDates_Model Technical_BestBeforeDates_Model;

        // Update Method
        public void GetValuesFromModel()
        {
            Id = Technical_BestBeforeDates_Model.Id;
            ProductCode = Technical_BestBeforeDates_Model.ProductCode;
            ProductDescription = Technical_BestBeforeDates_Model.ProductDescription;
        }

        public Technical_BestBeforeDates_ViewModel(Technical_BestBeforeDates_Model model)
        {
            Technical_BestBeforeDates_Model = model;

            GetValuesFromModel();
        }
    }

**RecordViewModel**

    public class Technical_BestBeforeDates_Record_ViewModel : BaseViewModel
    {
        // Hold list of view models
        public List<Technical_BestBeforeDates_ViewModel> VMs { get; set; }

        // Recieve data from View Model
        public Technical_BestBeforeDates_Record_ViewModel()
        {
            var records = GetDataFromDatabase();

            VMs = new List<Technical_BestBeforeDates_ViewModel>();

            foreach (Technical_BestBeforeDates_Model model in records)
            {
                VMs.Add(new Technical_BestBeforeDates_ViewModel(model));
            }
        }

        // Get data using dapper
        public List<Technical_BestBeforeDates_Model> GetDataFromDatabase()
        {
            string query = @"SELECT 
                                b.id AS ID, 
                                ProductCode, 
                                ProductDescription
                            FROM technical_bestbeforedates b";

            using (var conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString))
            {
                conn.Open();

                // Using dapper to fill the model
                var Records = conn.Query<Technical_BestBeforeDates_Model>(query).ToList();

                return Records;
            }
        }
    }

**View**

            <DockPanel>
                <DataGrid ItemsSource="{Binding VMs}"
                          AutoGenerateColumns="False"
                          IsReadOnly="True"
                          ColumnWidth="auto">
                    <DataGrid.Columns>
                        <DataGridTextColumn Binding="{Binding Id}" Header="Id" />
                        <DataGridTextColumn Binding="{Binding ProductCode}" Header="Product Code" />
                        <DataGridTextColumn Binding="{Binding ProductDescription}" Header="Product Description" />
                    </DataGrid.Columns>
                </DataGrid>
            </DockPanel>