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>

posted about 3 years ago

CC BY-SA 4.0

gzi98‭

69 reputation 4 0 13 1