Share XML file within local network to read/update

Question

Share XML file within local network to read/update

Kran2022 406

Hi All: I need your advice thanks in advance.

I need to develop a app to record/store number of enquiry emails, this app will be used by a few users within the company network.

No database & i cant have a server either, so i'm thinking about saving into xml file using WPF.

How can i share the xml file within the network among a few users to read, update & save data?

Contact Person: ( textbox)
Shop Name: ( textbox)
Adresse : ( textbox)
Product Type : ( textbox)
Nature of call: ( textbox)
Status : (Combobox)

Hui Liu-MSFT 48,676 Reputation points Microsoft External Staff

2023-02-21T09:45:09.12+00:00

You could try to see if the solutions here and here are helpful for you.

Kran2022 406

@Hui Liu-MSFT Hi There, thanks for your the links,

How can i handle if t2 users tried to access the file at a time for read/write (curd)?

Lets say if the file is being used by another user, as per below example then save the file local. Then what? How can i update the local file contents to the main file?

thanks again for your feedback.

 private void Process xml(string xmlInput)
    {
            var xmlDocument = XDocument.Parse(xmlInput);
            var filename = $"{Guid.NewGuid()}.xml";
            var filePath = Path.Combine(_outputFolder, filename);

            if (filePath.StartsWith("\\"))
            {
                SaveOnNetworkShare(xmlDocument, filePath);
            }
            else
            {
                SaveLocally(xmlDocument, filePath);
            }

    }

    private void SaveLocally(XmlDocument xml, string filePath)
    {
        xml.Save(filePath);
    }

    private void SaveOnNetworkShare(XmlDocument xml, string filePath)
    {
        try
        {
            Impersonation.RunAsUser(_credentials, LogonType.Network, () =>
            {
                xml.Save(filePath);
            });
        }
        catch (ImpersonationException ex)
        {
            _logger.LogError(new EventId(-1, "Error saving file"), ex, $"Could not save file to filepath {filePath}");
        }
    }

Kran2022 406 Reputation points

2023-02-21T10:17:15.4233333+00:00

@Hui Liu-MSFT Hello there:

Accepted answer

0 additional answers

Your answer

Hui Liu-MSFT 48,676 Reputation points Microsoft External Staff

2023-02-21T09:45:09.12+00:00

You could try to see if the solutions here and here are helpful for you.
Kran2022 406 Reputation points

2023-02-21T09:54:54.0266667+00:00

@Hui Liu-MSFT Hi There, thanks for your the links,

How can i handle if t2 users tried to access the file at a time for read/write (curd)?

Lets say if the file is being used by another user, as per below example then save the file local. Then what? How can i update the local file contents to the main file?

thanks again for your feedback.

private void Process xml(string xmlInput) { var xmlDocument = XDocument.Parse(xmlInput); var filename = $"{Guid.NewGuid()}.xml"; var filePath = Path.Combine(_outputFolder, filename); if (filePath.StartsWith("\\")) { SaveOnNetworkShare(xmlDocument, filePath); } else { SaveLocally(xmlDocument, filePath); } } private void SaveLocally(XmlDocument xml, string filePath) { xml.Save(filePath); } private void SaveOnNetworkShare(XmlDocument xml, string filePath) { try { Impersonation.RunAsUser(_credentials, LogonType.Network, () => { xml.Save(filePath); }); } catch (ImpersonationException ex) { _logger.LogError(new EventId(-1, "Error saving file"), ex, $"Could not save file to filepath {filePath}"); } }
Kran2022 406 Reputation points

2023-02-21T10:17:15.4233333+00:00

@Hui Liu-MSFT Hello there:

Answer 1

Bruce (SqlWork.com) 77,686 Volunteer Moderator

you have two issues to solve.

file sharing. read and close file. to write open read/write not shared, so only one process can access at a time.
conflict resolution. user one read file and makes changes. user two reads files, makes a change and saves. user one saves file. before the user one save it needs to re-read the file and make any changes made by user two. then apply the user one changes and save.

Kran2022 406 Reputation points

2023-02-22T08:09:48.2466667+00:00

@Bruce (SqlWork.com) Thanks for your feebback. I'll save the fiel lcoally then ask each user to merge entries to the network file manaully.. i should avoid duplicate entries as well. Thanks

Share via

Share XML file within local network to read/update

0 additional answers

Your answer