Datagrid load list of items for particular columns

Question

Hi All, Morning:

I'm reading a xml file to display it in the datagridview then save it back to the file after editing. My issue here, that i have a 3 list string properties From, Price & ServiceFee see below products class code, where i couldnt read these 3 list properties from the xml file and save it back to the xml file.

How can i read those 3 list properties read, display & save it back to the file? without creating a new class. Thanks for your help/time.

View Method:

 
case "ReadPricing": //to read local pricing file
ProductPriceList = GetProductsPriceList();
View = CollectionViewSource.GetDefaultView(ProductPriceList);
View.Filter = Filter;
View.Refresh();
return;


private ObservableCollection productpricelist;

public ObservableCollection ProductPriceList
{
	get { return productpricelist; }
	set
	{
		productpricelist = value;
		OnPropertyChanged("ProductPriceList");
	}
}

Method to read XML content: got stuck how to read lsit of FromQuantity, Price & ServiceFee

 private ObservableCollection GetProductsPriceList() //to read xml file contents 
        {
            var products = new ObservableCollection();
          
            using (Stream str = new FileStream(FilePath, FileMode.Open))
            {
                XElement xe0 = XElement.Load(str);
                foreach (var xe1 in xe0.Descendants("Products").Elements())
                {

                    var p = new Products
                    {
                        SysId = xe1.Attribute("Sys_Oid").Value,
                        Mainproduct = xe1.Name.ToString(),
                        Name = xe1.Attribute("Name").Value,
                        Visible = xe1.Descendants("ProductVisibility").FirstOrDefault().Attribute("Visible").Value,
                        Price = xe1.Descendants("ProductPrice").FirstOrDefault().Attribute("Price").Value,  
                        From = xe1.Descendants("ProductPrice").FirstOrDefault().Attribute("FromQuantity").Value,
                        ServiceFee = xe1.Descendants("ProductPrice").FirstOrDefault().Attribute("ServiceFee").Value,
                        NameIcon = xe1.Attribute("DefaultIconName")?.Value
                       
                    };

                    products.Add(p);

                    
                }
            }
            return products;
        }

Method to save XML content: got stuck how to update the list of FromQuantity, Price & ServiceFee

private void Execute(object parm) // method to save back to xml file from datagrid 
{

	XmlDocument doc = new XmlDocument();
	doc.Load(@"C:\xmltest\26112023.txt");
	foreach (Products pp in productpricelist)
	{
		pp.Name = RenameToCentiMeters(pp.Name); //put it back to cm to store in the file
		OnPropertyChanged(nameof(ProductPriceList));

		string replacecomma = pp.Price;
		pp.Price = replacecomma.Replace(",", "."); //put it back to dot instead of comma
		OnPropertyChanged(nameof(ProductPriceList));

		foreach (XmlElement pn in doc.SelectNodes("/Data/Products/*"))
		{
			
			if (pp.SysId == pn.GetAttribute("Sys_Oid").ToString()) //reference id comparison 
			 {
				
				foreach (XmlNode visibility in pn.SelectNodes("Visibilities"))
				{
					foreach (XmlNode productVisibilty in visibility.SelectNodes("ProductVisibility"))
					{
						productVisibilty.Attributes["Visible"].InnerText = pp.Visible;

						foreach (XmlNode price in productVisibilty.SelectNodes("Prices"))
						{
							foreach (XmlNode productPrice in price.SelectNodes("ProductPrice"))
							{
								productPrice.Attributes["FromQuantity"].InnerText = pp.From;
								productPrice.Attributes["Price"].InnerText = pp.Price;
								productPrice.Attributes["ServiceFee"].InnerText = pp.ServiceFee;
							}
						}

					}

				}
			 }
		}
	}
	doc.Save(@"C:\xmltest\26112023_.txt");
   

}

Class Products:


 public class Products
    {

        string sysid;
        string mainproduct;
        string name;
        string visible;
        string nameicon;


        public string SysId
        {
            get { return sysid; }
            set { sysid = value; }
        }

        public string Mainproduct
        {
            get { return mainproduct; }
            set { mainproduct = value; }
        }
		
        public string Name
        {
            get { return name; }
            set { name = value; }
        }

          public string Visible
        {
            get { return visible; }
            set 
            { 
                visible = value;
               
            }
        }

        private List fromqty = new List();
        public List FromQuantity
        {
            get { return fromqty; }
            set { fromqty = value; }
        }

        private List price = new List();
        public List Price
        {
            get { return price; }
            set { price = value; }
        }

        private List servicefee = new List();
        public List ServiceFee
        {
            get { return servicefee; }
            set { servicefee = value; }
        }



   
        public string NameIcon
        {
            get { return nameicon; }
            set { nameicon = value; }
        }
    }

Renametoinches method:

      public static string RenameToCentiMeters(string inches)
        {
            var dic = GetInchesToCentimetersPairs();
            foreach (var pair in dic.OrderByDescending(x => x.Key.Length))
            {
                inches = inches.Replace(pair.Key, pair.Value);
            }
            return inches;
        }

       private static Dictionary GetInchesToCentimetersPairs()
        {
            var dic = new Dictionary();
            dic.Add("2x4", "5x10");
            dic.Add("2x4/8", "5x10/20"); 
           
            return dic;
        }

Datagridview:

Accepted Answer

Hi,
please, try my demo with your data. Please, for additional, new or extended questions use new thread!

using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.ComponentModel;
using System.Linq;
using System.Runtime.CompilerServices;
using System.Windows;
using System.Windows.Data;
using System.Windows.Input;
using System.Xml;
using System.Xml.Linq;

namespace WpfApp042
{
	class ProductPriceViewModel : INotifyPropertyChanged
	{

		// ctor
		public ProductPriceViewModel() => ProductPriceList = new ObservableCollection();

		// Path of xml file
		public string FilePath { get; set; } = @"Window041XML.txt";

		// View member
		private CollectionViewSource cvs = new CollectionViewSource();
		public ICollectionView View { get => cvs.View; }

		private ObservableCollection _productPriceList;
		private ObservableCollection ProductPriceList
		{
			get => this._productPriceList;
			set
			{
				this._productPriceList = value;
				cvs.Source = value;
				OnPropertyChanged(nameof(View));
			}
		}

		// Commands
		public ICommand Cmd { get => new RelayCommand(executemethod, canexecutemethod); }

		private void executemethod(object obj)
		{
			switch (obj.ToString())
			{
				case "Save":
					SaveProductsPriceList();
					break;
				case "Clear":
					ProductPriceList.Clear();
					break;
				case "Load":
					ProductPriceList = GetProductsPriceList();
					break;
				default:
					break;
			}
		}
		private static bool canexecutemethod(object obj) => true;

		private XmlDocument productDoc;

#pragma warning disable CS8601 // Dereference of a possibly null reference.
#pragma warning disable CS8602 // Dereference of a possibly null reference.
		private ObservableCollection GetProductsPriceList() //to read xml file contents 
		{
			var products = new ObservableCollection();
			productDoc = new XmlDocument();
			productDoc.Load(FilePath);
			XElement xe0 = XElement.Parse(productDoc.InnerXml);
			foreach (var xe1 in xe0.Descendants("Products").Elements())
			{
				var p = new Products
				{
					SysId = xe1.Attribute("Sys_Oid")?.Value,
					Mainproduct = xe1.Name.ToString(),
					Name = xe1.Attribute("Name")?.Value,
					Visible = xe1.Descendants("ProductVisibility")?.FirstOrDefault().Attribute("Visible")?.Value,
					NameIcon = xe1.Attribute("DefaultIconName")?.Value
				};
				foreach (XElement xe2 in xe1.Descendants("ProductPrice"))
				{
					p.Prices.Add(new PriceDetail()
					{
						Sys_Oid = xe2.Attribute("Sys_Oid")?.Value,
						Price = xe2.Attribute("Price")?.Value,
						FromQuantity = xe2.Attribute("FromQuantity")?.Value,
						ServiceFee = xe2.Attribute("ServiceFee").Value
					});
				}
				products.Add(p);
			}
			return products;
		}

		private void SaveProductsPriceList() //to save xml fiel contents 
		{
			foreach (XmlElement pn in productDoc.SelectNodes("/Data/Products/*"))
			{
				Products pp = ProductPriceList.Where(p => p.SysId == pn.GetAttribute("Sys_Oid")?.ToString()).FirstOrDefault();
				if (pp != null)
				{
					foreach (XmlNode visibility in pn.SelectNodes("Visibilities"))
					{
						foreach (XmlNode productVisibilty in visibility.SelectNodes("ProductVisibility"))
						{
							productVisibilty.Attributes["Visible"].InnerText = pp.Visible;
							foreach (XmlNode price in productVisibilty.SelectNodes("Prices"))
							{
								foreach (XmlNode productPrice in price.SelectNodes("ProductPrice"))
								{
									PriceDetail pd = pp.Prices.Where(p => p.Sys_Oid == productPrice.Attributes["Sys_Oid"]?.Value.ToString()).FirstOrDefault();
									if (pd != null)
									{
										productPrice.Attributes["FromQuantity"].InnerText = pd.FromQuantity;
										productPrice.Attributes["Price"].InnerText = pd.Price;
										productPrice.Attributes["ServiceFee"].InnerText = pd.ServiceFee;
									}
								}
							}

						}
					}
				}
			}
			productDoc.Save(FilePath);
		}

		public static string RenameToCentiMeters(string inches)
		{
			var dic = GetInchesToCentimetersPairs();
			foreach (var pair in dic.OrderByDescending(x => x.Key.Length))
				inches = inches.Replace(pair.Key, pair.Value);
			return inches;
		}

		private static Dictionary GetInchesToCentimetersPairs()
		{
			var dic = new Dictionary();
			dic.Add("2x4", "5x10");
			dic.Add("2x4/8", "5x10/20");
			return dic;
		}

		// INotifyPropertyChanged
#pragma warning disable CS8612 // Nullability of reference types in type doesn't match implicitly implemented member.
		public event PropertyChangedEventHandler PropertyChanged;
		public void OnPropertyChanged([CallerMemberName] string info = "") =>
				PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(info));
	}

	//#pragma warning disable CS8603 // Dereference of a possibly null reference.
	public class Products
	{
		public string SysId { get; set; }
		public string Mainproduct { get; set; }
		public string Name { get; set; }
		public string Visible { get; set; }
		public string From { get; set; }
		public List Prices { get; set; } = new List();
		public string NameIcon { get; set; }
	}

	public class PriceDetail
	{
		public string Sys_Oid { get; set; }
		public string FromQuantity { get; set; }
		public string Price { get; set; }
		public string ServiceFee { get; set; }
	}

#pragma warning disable CS8767 // Nullability of reference types in type of parameter doesn't match implicitly implemented member (possibly because of nullability attributes).
#pragma warning disable CS8625 // Cannot convert null literal to non-nullable reference type.
	public class RelayCommand : ICommand
	{
		private readonly Predicate

Answer

Hi,
your posted code is inconsistent. I changed your code a little bis and it works correct:

And classes:

using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.ComponentModel;
using System.Linq;
using System.Windows;
using System.Windows.Data;
using System.Windows.Input;
using System.Xml;
using System.Xml.Linq;

namespace WpfApp041
{
	class ProductPriceViewModel : INotifyPropertyChanged
	{

		// ctor
		public ProductPriceViewModel() => ProductPriceList = new ObservableCollection();

		// Path of xml file
		public string FilePath { get; set; } = @"Window040XML.txt";

		// View member
		private CollectionViewSource cvs = new CollectionViewSource();
		public ICollectionView View { get => cvs.View; }

		private ObservableCollection _productPriceList;
		private ObservableCollection ProductPriceList
		{
			get => this._productPriceList;
			set
			{
				this._productPriceList = value;
				cvs.Source = value;
				OnPropertyChanged(nameof(View));
			}
		}

		// Commands
		public ICommand Cmd { get => new RelayCommand(executemethod, canexecutemethod); }

		private void executemethod(object obj)
		{
			switch (obj.ToString())
			{
				case "Save":
					SaveProductsPriceList();
					break;
				case "Clear":
					ProductPriceList.Clear();
					break;
				case "Load":
					ProductPriceList = GetProductsPriceList();
					break;
				default:
					break;
			}
		}
		private static bool canexecutemethod(object obj) => true;

		private XmlDocument productDoc;

#pragma warning disable CS8601 // Dereference of a possibly null reference.
#pragma warning disable CS8602 // Dereference of a possibly null reference.
		private ObservableCollection GetProductsPriceList() //to read xml file contents 
		{
			var products = new ObservableCollection();
			productDoc = new XmlDocument();
			productDoc.Load(FilePath);
			XElement xe0 = XElement.Parse(productDoc.InnerXml);
			foreach (var xe1 in xe0.Descendants("Products").Elements())
			{
				var p = new Products
				{
					SysId = xe1.Attribute("Sys_Oid")?.Value,
					Mainproduct = xe1.Name.ToString(),
					Name = xe1.Attribute("Name")?.Value,
					Visible = xe1.Descendants("ProductVisibility")?.FirstOrDefault().Attribute("Visible")?.Value,
					Price = xe1.Descendants("ProductPrice")?.FirstOrDefault().Attribute("Price")?.Value,
					From = xe1.Descendants("ProductPrice")?.FirstOrDefault().Attribute("FromQuantity")?.Value,
					ServiceFee = xe1.Descendants("ProductPrice").FirstOrDefault().Attribute("ServiceFee").Value,
					NameIcon = xe1.Attribute("DefaultIconName")?.Value
				};
				products.Add(p);
			}
			return products;
		}

		private void SaveProductsPriceList() //to save xml fiel contents 
		{
			foreach (XmlElement pn in productDoc.SelectNodes("/Data/Products/*"))
			{
				Products pp = ProductPriceList.Where(p => p.SysId == pn.GetAttribute("Sys_Oid")?.ToString()).FirstOrDefault();
				if (pp != null)
				{
					foreach (XmlNode visibility in pn.SelectNodes("Visibilities"))
					{
						foreach (XmlNode productVisibilty in visibility.SelectNodes("ProductVisibility"))
						{
							productVisibilty.Attributes["Visible"].InnerText = pp.Visible;

							foreach (XmlNode price in productVisibilty.SelectNodes("Prices"))
							{
								foreach (XmlNode productPrice in price.SelectNodes("ProductPrice"))
								{
									productPrice.Attributes["FromQuantity"].InnerText = pp.From;
									productPrice.Attributes["Price"].InnerText = pp.Price;
									productPrice.Attributes["ServiceFee"].InnerText = pp.ServiceFee;
								}
							}

						}

					}
				}
			}
			productDoc.Save(FilePath);
		}

		public static string RenameToCentiMeters(string inches)
		{
			var dic = GetInchesToCentimetersPairs();
			foreach (var pair in dic.OrderByDescending(x => x.Key.Length))
				inches = inches.Replace(pair.Key, pair.Value);
			return inches;
		}

		private static Dictionary GetInchesToCentimetersPairs()
		{
			var dic = new Dictionary();
			dic.Add("2x4", "5x10");
			dic.Add("2x4/8", "5x10/20");
			return dic;
		}

		// INotifyPropertyChanged
#pragma warning disable CS8612 // Nullability of reference types in type doesn't match implicitly implemented member.
		public event PropertyChangedEventHandler PropertyChanged;
		public void OnPropertyChanged(String info) =>
				PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(info));
	}

	//#pragma warning disable CS8603 // Dereference of a possibly null reference.
	public class Products
	{
		public string SysId { get; set; }
		public string Mainproduct { get; set; }
		public string Name { get; set; }
		public string Visible { get; set; }
		public string From { get; set; }
		public string FromQuantity { get; set; }
		public string Price { get; set; }
		public string ServiceFee { get; set; }
		//public List FromQuantity { get; set; }= new List();
		//public List Price { get; set; } = new List();
		//public List ServiceFee { get; set; } = new List();
		public string NameIcon { get; set; }
	}

#pragma warning disable CS8767 // Nullability of reference types in type of parameter doesn't match implicitly implemented member (possibly because of nullability attributes).
#pragma warning disable CS8625 // Cannot convert null literal to non-nullable reference type.
	public class RelayCommand : ICommand
	{
		private readonly Predicate

Datagrid load list of items for particular columns

1 additional answer