using System.Collections.Generic;
using System.IO;
using System.Xml;

namespace CostpointWebServiceTest
{
    public class POLN : SQLiteTable
    {
        public POLN(string XMLfilename) : base(XMLfilename)
        {
            XMLroot = "POMMAIN_POLN";
            Columns = new List<string>()
            {
                "PO_ID",
                "PO_RLSE_NO",
                "S_PO_STATUS_TYPE",
                "VEND_ID",
                "ITEM_ID",
                "ITEM_RVSN_ID",
                "ITEM_KEY",
                "ORD_QTY",
                "ORIG_DUE_DT",
                "DESIRED_DT",
                "DUE_DT",
                "INVT_ABBRV_CD",
                "ORD_DT",
                "PO_LN_NO",
                "PO_LN_UM_CD",
                "S_LN_STATUS_TYPE",
                "QC_REQD_FL",
                "RECVD_QTY",
            };
            GetRows(XMLfilenameToLoad);
        }

        public override void GetRows(string XmlPath)
        {
            XmlDocument WICresponse = new XmlDocument();
            WICresponse.LoadXml(File.ReadAllText(XmlPath));

            XmlNodeList nodes = WICresponse.GetElementsByTagName(XMLroot);
            foreach (XmlNode node in nodes)
            {
                Rows.Add(new List<string>()
                {
                    node.ParentNode["PO_ID"]?.InnerText,
                    node.ParentNode["PO_RLSE_NO"]?.InnerText,
                    node.ParentNode["S_PO_STATUS_TYPE"]?.InnerText,
                    node.ParentNode["VEND_ID"]?.InnerText,
                    node["ITEM_ID"]?.InnerText,
                    node["ITEM_RVSN_ID"]?.InnerText,
                    node["ITEM_KEY"]?.InnerText,
                    node["ORD_QTY"]?.InnerText,
                    node["ORIG_DUE_DT"]?.InnerText,
                    node["POMMAIN_POLN_DESIRED_DT"]?.InnerText,
                    node["POMMAIN_POLN_DUE_DT"]?.InnerText,
                    node["POMMAIN_POLN_INVT_ABBRV_CD"]?.InnerText,
                    node["POMMAIN_POLN_ORD_DT"]?.InnerText,
                    node["PO_LN_NO"]?.InnerText,
                    node["PO_LN_UM_CD"]?.InnerText,
                    node["S_LN_STATUS_TYPE"]?.InnerText,
                    node["QC_REQD_FL"]?.InnerText,
                    node["RECVD_QTY"]?.InnerText,
                });
            }
        }
    }
}