Insert record and Update existing record if Exists in XML file using C# and VB.Net

zeeshanp...

SOLVED CLOSED ACTIVE ANSWERED
User: zeeshanpas
Posted: on May 23, 2022 10:58 PM
Forum: ASP.Net Web Forms
Answer: 2
Views: 2925
Sample Code: Download

How to update XML file, if WB_SESSION_ID exists need to update else need to insert.

Inserting part already done need to differentiate insert and update code.

public string GetPriorityRecordingSessionsbeta()
{
    var checkoracle = CheckConnection();

    DateTime utc1 = this.objDTC.ConvertLocalTimeToUTC(Convert.ToDateTime(this.d_1.ToShortDateString()), ConfigurationManager.AppSettings["TimeZone"].ToString());
    DateTime utc2 = this.objDTC.ConvertLocalTimeToUTC(Convert.ToDateTime(this.d_2.ToShortDateString()), ConfigurationManager.AppSettings["TimeZone"].ToString());
    ELBASEDAL elbasedal = new ELBASEDAL();
    try
    {
        if (checkoracle)
        {
            OracleParameter[] parameters = new OracleParameter[3]
            {
                elbasedal.CreateInParameter("ifromdate", OracleType.VarChar, "5/01/2022 6:30:00 PM"),
                elbasedal.CreateInParameter("itodate", OracleType.VarChar, "5/18/2022 6:30:00 PM"),
                elbasedal.CreateOutParameter("cursor_s", OracleType.Cursor)
            };
            DataTable tableStoreProcedure = elbasedal.GetDataTableStoreProcedure("DAILY_REPORTS_PACKAGE.getPriorityRecDetails", parameters);

            if (tableStoreProcedure.Rows.Count > 0)
            {
                try
                {
                    foreach (DataRow row in (InternalDataCollectionBase)tableStoreProcedure.Rows)
                    {
                        XMLSessiondetailsLogger("session details logged successfully", row["SESSION_ID"].ToString(), row["WB_SESSION_ID"].ToString(), row["recording_priority"].ToString(), row["Subject_Name"].ToString(), row["Topic_Name"].ToString(), row["Question"].ToString(), row["Student_Name"].ToString(), row["Tutor_Name"].ToString(), row["Franchise_Name"].ToString(), row["Project_Name"].ToString(), row["rec_url"].ToString());
                    }
                    InsertDataTosql();
                }
                catch (Exception ex)
                {
                    this.objerr.WriteXMLErrorLog(ex);
                }
            }
        }
        else
        {
            Console.WriteLine("Failed to start pre-processing. so il sleep task for every 05 min {0}", loop);
            //repeat 4 times every 05min
            if (loop < 4)
            {
                // 5 min task sleep
                Thread.Sleep(300000);
                loop++;
                GetPriorityRecordingSessionsbeta();
            }
            else
            {
                xmlStatusLogger("fetching Session details from database Failed");
                FailuremailSender();
                result = "Fail";
            }
        }
    }
    catch (Exception ex)
    {
        this.objerr.WriteXMLErrorLog(ex);
    }

    return result;
}

public void XMLSessiondetailsLogger(string msg, string msg1, string msg2, string msg3, string msg4, string msg5, string msg6, string msg7, string msg8, string msg9, string msg10, string msg11)
{
    string xmlpath;
    try
    {
        _datet = DateTime.Now;
        xmlpath = AppDomain.CurrentDomain.BaseDirectory + "XmlEvents";
        xmlpath += "\\" + _datet.ToString("dd MMMM yyyy") + "\\SessionDetails";
        if (!Directory.Exists(xmlpath))
        {
            DirectoryInfo di = Directory.CreateDirectory(xmlpath);
        }
        XmlDocument xmlErrorLogDoc = null;

        xmlErrorLogDoc = new XmlDocument();
        String xmlErrorLogFileName = xmlpath + "\\" + DateTime.Now.ToString("yyyyMMdd") + ".xml";

        if (!File.Exists(xmlErrorLogFileName))
        {
            XmlTextWriter myXmlTextWriter = new XmlTextWriter(xmlErrorLogFileName, Encoding.UTF8);
            myXmlTextWriter.Formatting = Formatting.Indented;
            myXmlTextWriter.WriteStartDocument(false);
            myXmlTextWriter.WriteStartElement("Root");
            myXmlTextWriter.WriteStartElement("SessionDetails");
            myXmlTextWriter.WriteElementString("TIME", DateTime.UtcNow.ToString());
            myXmlTextWriter.WriteElementString("Status", msg);
            myXmlTextWriter.WriteElementString("SESSION_ID", msg1);
            myXmlTextWriter.WriteElementString("WB_SESSION_ID", msg2);
            myXmlTextWriter.WriteElementString("recording_priority", msg3);
            myXmlTextWriter.WriteElementString("Subject_Name", msg4);
            myXmlTextWriter.WriteElementString("Topic_Name", msg5);
            myXmlTextWriter.WriteElementString("Question", msg6);
            myXmlTextWriter.WriteElementString("Student_Name", msg7);
            myXmlTextWriter.WriteElementString("Tutor_Name", msg8);
            myXmlTextWriter.WriteElementString("Franchise_Name", msg9);
            myXmlTextWriter.WriteElementString("Project_Name", msg10);
            myXmlTextWriter.WriteElementString("rec_url", msg11);

            myXmlTextWriter.WriteEndElement();
            myXmlTextWriter.WriteEndElement();
            myXmlTextWriter.Flush();
            myXmlTextWriter.Close();
        }
        else
        {
            xmlErrorLogDoc.Load(xmlErrorLogFileName);
            XmlNode xmlNodeObj = xmlErrorLogDoc.DocumentElement;
            XmlElement childElement1 = xmlErrorLogDoc.CreateElement("SessionDetails");
            XmlElement childElement2 = xmlErrorLogDoc.CreateElement("TIME");
            XmlElement childElement3 = xmlErrorLogDoc.CreateElement("Status");
            XmlElement childElement4 = xmlErrorLogDoc.CreateElement("SESSION_ID");
            XmlElement childElement5 = xmlErrorLogDoc.CreateElement("WB_SESSION_ID");
            XmlElement childElement6 = xmlErrorLogDoc.CreateElement("recording_priority");
            XmlElement childElement7 = xmlErrorLogDoc.CreateElement("Subject_Name");
            XmlElement childElement8 = xmlErrorLogDoc.CreateElement("Topic_Name");
            XmlElement childElement9 = xmlErrorLogDoc.CreateElement("Question");
            XmlElement childElement10 = xmlErrorLogDoc.CreateElement("Student_Name");
            XmlElement childElement11 = xmlErrorLogDoc.CreateElement("Tutor_Name");
            XmlElement childElement12 = xmlErrorLogDoc.CreateElement("Franchise_Name");
            XmlElement childElement13 = xmlErrorLogDoc.CreateElement("Project_Name");
            XmlElement childElement14 = xmlErrorLogDoc.CreateElement("rec_url");
            childElement2.InnerText = DateTime.UtcNow.ToString();
            childElement3.InnerText = msg;
            childElement4.InnerText = msg1;
            childElement5.InnerText = msg2;
            childElement6.InnerText = msg3;
            childElement7.InnerText = msg4;
            childElement8.InnerText = msg5;
            childElement9.InnerText = msg6;
            childElement10.InnerText = msg7;
            childElement11.InnerText = msg8;
            childElement12.InnerText = msg9;
            childElement13.InnerText = msg10;
            childElement14.InnerText = msg11;

            xmlNodeObj.AppendChild(childElement1);
            childElement1.AppendChild(childElement2);
            childElement1.AppendChild(childElement3);
            childElement1.AppendChild(childElement4);
            childElement1.AppendChild(childElement5);
            childElement1.AppendChild(childElement6);
            childElement1.AppendChild(childElement7);
            childElement1.AppendChild(childElement8);
            childElement1.AppendChild(childElement9);
            childElement1.AppendChild(childElement10);
            childElement1.AppendChild(childElement11);
            childElement1.AppendChild(childElement12);
            childElement1.AppendChild(childElement13);
            childElement1.AppendChild(childElement14);

            xmlErrorLogDoc.Save(xmlErrorLogFileName);
        }
    }

    catch (Exception ex)
    {
        // objex.WriteXMLErrorLog(ex, "XmlCreater", "XMLMailLogger", "", "");
    }
}

Below code what i tried for updating so could you please help me in that https://ibb.co/r001yJH in this link i attached my xml file.

XDocument xxdoc = XDocument.Load(xmlErrorLogFileName);  ////Update
var target = (from details in xxdoc.Descendants("Root").Descendants("SessionDetails")
                where details.Descendants("WB_SESSION_ID").FirstOrDefault().Value.Trim() == msg2
                select new { WB_SESSION_ID = details.Element("WB_SESSION_ID").Value }).ToList();

if (target != null)
{

}

Download FREE API for Word, Excel and PDF in ASP.Net

arjunv

0 2

Reply
ANSWER
User: arjunv
Replied: on May 24, 2022 01:05 AM
Report

Hi zeeshanpas,

Please refer below sample.

XML

<?xml version="1.0" encoding="utf-8"?>
<Customers>
  <Customer>
    <CustomerId>1</CustomerId>
    <Name>John Hammond</Name>
    <Country>United States</Country>
  </Customer>
  <Customer>
    <CustomerId>2</CustomerId>
    <Name>Mudassar Khan</Name>
    <Country>India</Country>
  </Customer>
</Customers>

HTML

<table>
    <tr>
        <th>CustomerId:</th>
        <th>Name:</th>
        <th>Country:</th>
    </tr>
    <tr>
        <td><asp:TextBox ID="txtId" runat="server" /></td>
        <td><asp:TextBox ID="txtName" runat="server" /></td>
        <td><asp:TextBox ID="txtCountry" runat="server" /></td>
    </tr>
    <tr>
        <td colspan="3" style="text-align: center">
            <asp:Button Text="Save" ID="btnSave" runat="server" OnClick="Save" /></td>
    </tr>
</table>

Code

protected void Save(object sender, EventArgs e)
{
    XDocument xmlDoc = XDocument.Load(Server.MapPath("~/CustomersXMLFile.xml"));

    XElement target = (from details in xmlDoc.Descendants("Customers").Descendants("Customer")
                        where details.Descendants("CustomerId").FirstOrDefault().Value.Trim() == txtId.Text
                        select details).FirstOrDefault();
    if (target != null)
    {
        target.Element("Name").Value = txtName.Text;
        target.Element("Country").Value = txtCountry.Text;
    }
    else
    {
        target = new XElement("Customer");
        target.Add(new XElement("CustomerId", txtId.Text));
        target.Add(new XElement("Name", txtName.Text));
        target.Add(new XElement("Country", txtCountry.Text));
        xmlDoc.Element("Customers").Add(target);
    }
    xmlDoc.Save(Server.MapPath("~/CustomersXMLFile.xml"));
}

VB.Net

Protected Sub Save(ByVal sender As Object, ByVal e As EventArgs)
    Dim xmlDoc As XDocument = XDocument.Load(Server.MapPath("~/CustomersXMLFile.xml"))
    Dim target As XElement = (From details In xmlDoc.Descendants("Customers").Descendants("Customer") Where details.Descendants("CustomerId").FirstOrDefault().Value.Trim() = txtId.Text Select details).FirstOrDefault()

    If target IsNot Nothing Then
        target.Element("Name").Value = txtName.Text
        target.Element("Country").Value = txtCountry.Text
    Else
        target = New XElement("Customer")
        target.Add(New XElement("CustomerId", txtId.Text))
        target.Add(New XElement("Name", txtName.Text))
        target.Add(New XElement("Country", txtCountry.Text))
        xmlDoc.Element("Customers").Add(target)
    End If

    xmlDoc.Save(Server.MapPath("~/CustomersXMLFile.xml"))
End Sub

Screenshot

UpdatedXML(Output)

<?xml version="1.0" encoding="utf-8"?>
<Customers>
  <Customer>
    <CustomerId>1</CustomerId>
    <Name>John</Name>
    <Country>USA</Country>
  </Customer>
  <Customer>
    <CustomerId>2</CustomerId>
    <Name>Mudassar Khan</Name>
    <Country>India</Country>
  </Customer>
</Customers>

arjunv

0 8

Reply
ANSWER
User: arjunv
Replied: on May 25, 2022 01:52 AM
Report

Please refer below modified code.

Code

public void XMLSessiondetailsLogger(string msg, string msg1, string msg2, string msg3, string msg4, string msg5, string msg6, string msg7, string msg8, string msg9, string msg10, string msg11)
{
    string xmlpath;
    try
    {
        _datet = DateTime.Now;
        xmlpath = AppDomain.CurrentDomain.BaseDirectory + "XmlEvents";
        xmlpath += "\\" + _datet.ToString("dd MMMM yyyy") + "\\SessionDetails";
        if (!Directory.Exists(xmlpath))
        {
            DirectoryInfo di = Directory.CreateDirectory(xmlpath);
        }
        XmlDocument xmlErrorLogDoc = null;

        xmlErrorLogDoc = new XmlDocument();
        String xmlErrorLogFileName = xmlpath + "\\" + DateTime.Now.ToString("yyyyMMdd") + ".xml";

        if (!File.Exists(xmlErrorLogFileName))
        {
            XmlTextWriter myXmlTextWriter = new XmlTextWriter(xmlErrorLogFileName, Encoding.UTF8);
            myXmlTextWriter.Formatting = Formatting.Indented;
            myXmlTextWriter.WriteStartDocument(false);
            myXmlTextWriter.WriteStartElement("Root");
            myXmlTextWriter.WriteStartElement("SessionDetails");
            myXmlTextWriter.WriteElementString("TIME", DateTime.UtcNow.ToString());
            myXmlTextWriter.WriteElementString("Status", msg);
            myXmlTextWriter.WriteElementString("SESSION_ID", msg1);
            myXmlTextWriter.WriteElementString("WB_SESSION_ID", msg2);
            myXmlTextWriter.WriteElementString("recording_priority", msg3);
            myXmlTextWriter.WriteElementString("Subject_Name", msg4);
            myXmlTextWriter.WriteElementString("Topic_Name", msg5);
            myXmlTextWriter.WriteElementString("Question", msg6);
            myXmlTextWriter.WriteElementString("Student_Name", msg7);
            myXmlTextWriter.WriteElementString("Tutor_Name", msg8);
            myXmlTextWriter.WriteElementString("Franchise_Name", msg9);
            myXmlTextWriter.WriteElementString("Project_Name", msg10);
            myXmlTextWriter.WriteElementString("rec_url", msg11);

            myXmlTextWriter.WriteEndElement();
            myXmlTextWriter.WriteEndElement();
            myXmlTextWriter.Flush();
            myXmlTextWriter.Close();
        }
        else
        {
            XDocument xxdoc = XDocument.Load(xmlErrorLogFileName);
            XElement target = (from details in xxdoc.Descendants("Root").Descendants("SessionDetails")
                                where details.Descendants("WB_SESSION_ID").FirstOrDefault().Value.Trim() == msg2
                                select details).FirstOrDefault();
            if (target != null)
            {
                target.Element("TIME").Value = DateTime.UtcNow.ToString();
                target.Element("Status").Value = msg;
                target.Element("SESSION_ID").Value = msg1;
                target.Element("WB_SESSION_ID").Value = msg2;
                target.Element("recording_priority").Value = msg3;
                target.Element("Subject_Name").Value = msg4;
                target.Element("Topic_Name").Value = msg5;
                target.Element("Question").Value = msg6;
                target.Element("Student_Name").Value = msg7;
                target.Element("Tutor_Name").Value = msg8;
                target.Element("Franchise_Name").Value = msg9;
                target.Element("Project_Name").Value = msg10;
                target.Element("rec_url").Value = msg11;
            }
            else
            {
                target = new XElement("SessionDetails");
                target.Add(new XElement("TIME", DateTime.UtcNow.ToString()));
                target.Add(new XElement("Status", msg));
                target.Add(new XElement("SESSION_ID", msg1));
                target.Add(new XElement("WB_SESSION_ID", msg2));
                target.Add(new XElement("recording_priority", msg3));
                target.Add(new XElement("Subject_Name", msg4));
                target.Add(new XElement("Topic_Name", msg5));
                target.Add(new XElement("Question", msg6));
                target.Add(new XElement("Student_Name", msg7));
                target.Add(new XElement("Tutor_Name", msg8));
                target.Add(new XElement("Franchise_Name", msg9));
                target.Add(new XElement("Project_Name", msg10));
                target.Add(new XElement("rec_url", msg11));
                xxdoc.Element("Root").Add(target);
            }
            xxdoc.Save(Server.MapPath("~/CustomersXMLFile.xml"));
        }
    }

    catch (Exception ex)
    {
        // objex.WriteXMLErrorLog(ex, "XmlCreater", "XMLMailLogger", "", "");
    }
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Insert record and Update existing record if Exists in XML file using C# and VB.Net

Company

Explore

Follow us

Contact Us