ASP.NET  

XML CRUD (Create Read Update Delete) Operation Using MVC

Step 1. Creating an MVC Application

  • Open Visual Studio
  • File à New Project…
  • Select ASP.NET MVC3/4 Web Application.
  • Enter the name of Application as "CodeFirstDemo".
  • Click OK.

Step 2. Creating the Model

Right click on the Models folder and create a model with the name of "ProjectModels" and create properties, as shown in the code, given below:


ProjectModels.cs

  1. namespace MvcXML.Models   
  2. {  
  3.     public class ProjectModels {  
  4.         public int Id {  
  5.             get;  
  6.             set;  
  7.         }  
  8.         [Required]  
  9.         public string ProjectName {  
  10.             get;  
  11.             set;  
  12.         }  
  13.         [Required]  
  14.         public string Location {  
  15.             get;  
  16.             set;  
  17.         }  
  18.         public bool IsEdit {  
  19.             get;  
  20.             set;  
  21.         }  
  22.     }  
  23. }  

Step 3. Create a XML File

Create a folder with the name of XML, as shown in the following picture, and create an XML file with the name of "ProjectList.XML", using Add a New Item by right clicking on XML folder. Write the code as follows in XML file.


ProjectList.xml

  1. <?xml version="1.0" encoding="utf-8"?>  
  2. <Projects>  
  3.     <Project>  
  4.         <Id>1</Id>  
  5.         <ProjectName>The Primus</ProjectName>  
  6.         <Location>Gurgaon</Location>  
  7.     </Project>  
  8.     <Project>  
  9.         <Id>2</Id>  
  10.         <ProjectName>DLF</ProjectName>  
  11.         <Location>Gudgoan</Location>  
  12.     </Project>  
  13.     <Project>  
  14.         <Id>4</Id>  
  15.         <ProjectName>Dev Builders</ProjectName>  
  16.         <Location>Grater Noida</Location>  
  17.     </Project>  
  18. </Projects>  

Step 4 : Create a Controller.

Right click on the Controller folder and create a controller with the name of "AdminController", as shown in the picture below. Write the code given below in Admincontroller within an Index Action.


AdminController.cs

  1. public class AdminController: Controller {  
  2.     //  
  3.     // GET: /Admin/  
  4.     public ActionResult Index() {  
  5.         List < ProjectModels > lstProject = new List < ProjectModels > ();  
  6.         DataSet ds = new DataSet();  
  7.         ds.ReadXml(Server.MapPath("~/XML/ProjectList.xml"));  
  8.         DataView dvPrograms;  
  9.         dvPrograms = ds.Tables[0].DefaultView;  
  10.         dvPrograms.Sort = "Id";  
  11.         foreach(DataRowView dr in dvPrograms) {  
  12.             ProjectModels model = new ProjectModels();  
  13.             model.Id = Convert.ToInt32(dr[0]);  
  14.             model.ProjectName = Convert.ToString(dr[1]);  
  15.             model.Location = Convert.ToString(dr[2]);  
  16.             lstProject.Add(model);  
  17.         }  
  18.         if (lstProject.Count > 0) {  
  19.             return View(lstProject);  
  20.         }  
  21.         return View();  
  22.         return View();  
  23.     }  
  24.     ProjectModels model = new ProjectModels();  
  25.     public ActionResult AddEditProject(int ? id) {  
  26.             int Id = Convert.ToInt32(id);  
  27.             if (Id > 0) {  
  28.                 GetDetailsById(Id);  
  29.                 model.IsEdit = true;  
  30.                 return View(model);  
  31.             } else {  
  32.                 model.IsEdit = false;  
  33.                 return View(model);  
  34.             }  
  35.         }  
  36.         [HttpPost]  
  37.     public ActionResult AddEditProject(ProjectModels mdl) {  
  38.         if (mdl.Id > 0) {  
  39.             XDocument xmlDoc = XDocument.Load(Server.MapPath("~/XML/ProjectList.xml"));  
  40.             var items = (from item in xmlDoc.Descendants("Project") select item).ToList();  
  41.             XElement selected = items.Where(p => p.Element("Id").Value == mdl.Id.ToString()).FirstOrDefault();  
  42.             selected.Remove();  
  43.             xmlDoc.Save(Server.MapPath("~/XML/ProjectList.xml"));  
  44.             xmlDoc.Element("Projects").Add(new XElement("Project", new XElement("Id", mdl.Id), new XElement("ProjectName", mdl.ProjectName), new XElement("Location", mdl.Location)));  
  45.             xmlDoc.Save(Server.MapPath("~/XML/ProjectList.xml"));  
  46.             return RedirectToAction("Index", "Admin");  
  47.         } else {  
  48.             XmlDocument oXmlDocument = new XmlDocument();  
  49.             oXmlDocument.Load(Server.MapPath("~/XML/ProjectList.xml"));  
  50.             XmlNodeList nodelist = oXmlDocument.GetElementsByTagName("Project");  
  51.             var x = oXmlDocument.GetElementsByTagName("Id");  
  52.             int Max = 0;  
  53.             foreach(XmlElement item in x) {  
  54.                 int EId = Convert.ToInt32(item.InnerText.ToString());  
  55.                 if (EId > Max) {  
  56.                     Max = EId;  
  57.                 }  
  58.             }  
  59.             Max = Max + 1;  
  60.             XDocument xmlDoc = XDocument.Load(Server.MapPath("~/XML/ProjectList.xml"));  
  61.             xmlDoc.Element("Projects").Add(new XElement("Project", new XElement("Id", Max), new XElement("ProjectName", mdl.ProjectName), new XElement("Location", mdl.Location)));  
  62.             xmlDoc.Save(Server.MapPath("~/XML/ProjectList.xml"));  
  63.             return RedirectToAction("Index", "Admin");  
  64.         }  
  65.     }  
  66.     public ActionResult Delete(int Id) {  
  67.         if (Id > 0) {  
  68.             XDocument xmlDoc = XDocument.Load(Server.MapPath("~/XML/ProjectList.xml"));  
  69.             var items = (from item in xmlDoc.Descendants("Project") select item).ToList();  
  70.             XElement selected = items.Where(p => p.Element("Id").Value == Id.ToString()).FirstOrDefault();  
  71.             selected.Remove();  
  72.             xmlDoc.Save(Server.MapPath("~/XML/ProjectList.xml"));  
  73.         }  
  74.         return RedirectToAction("Index", "Admin");  
  75.     }  
  76.     public void GetDetailsById(int Id) {  
  77.         XDocument oXmlDocument = XDocument.Load(Server.MapPath("~/XML/ProjectList.xml"));  
  78.         var items = (from item in oXmlDocument.Descendants("Project") where Convert.ToInt32(item.Element("Id").Value) == Id select new projectItems {  
  79.             Id = Convert.ToInt32(item.Element("Id").Value),  
  80.                 ProjectName = item.Element("ProjectName").Value,  
  81.                 Location = item.Element("Location").Value,  
  82.         }).SingleOrDefault();  
  83.         if (items != null) {  
  84.             model.Id = items.Id;  
  85.             model.ProjectName = items.ProjectName;  
  86.             model.Location = items.Location;  
  87.         }  
  88.     }  
  89.     public class projectItems {  
  90.         public int Id {  
  91.             get;  
  92.             set;  
  93.         }  
  94.         public string ProjectName {  
  95.             get;  
  96.             set;  
  97.         }  
  98.         public string Location {  
  99.             get;  
  100.             set;  
  101.         }  
  102.         public projectItems() {}  
  103.     }  
  104. }  

Now, create a View for the action, using right click on the controller's action and write the code as follows for the Index and AddEditProject respectively.

Index.cshtml file.

  1. @model IEnumerable   
  2. <MvcXML.Models.ProjectModels>  
  3.   
  4. @{  
  5.   
  6. ViewBag.Title = "Index";  
  7.   
  8. }  
  9.   
  10.   
  11.     <style type="text/css">  
  12.   
  13. .topDiv  
  14.   
  15. {  
  16.   
  17. width: 50%;  
  18.   
  19. margin: 10px auto;  
  20.   
  21. background-color: #f2f2f2;  
  22.   
  23. text-align: left;  
  24.   
  25. padding: 2%;  
  26.   
  27. }  
  28.   
  29. </style>  
  30.     <div class="topDiv">  
  31.         <fieldset style="margin: 2% auto; width: 90%; background-color: #FFEBCD; text-align: center">  
  32.             <h4>  
  33.   
  34. @Html.ActionLink("Add New project", "AddEditProject")  
  35.   
  36. </h4>  
  37.         </fieldset>  
  38.         <fieldset>  
  39.             <table style="margin: 2% auto; padding: 5px; width: 90%">  
  40.                 <tr style="background-color: #FFFACD">  
  41.                     <th>  
  42.   
  43. ProjectName  
  44.   
  45. </th>  
  46.                     <th>  
  47.   
  48. Location  
  49.   
  50. </th>  
  51.                     <th>  
  52.   
  53. Manage  
  54.   
  55. </th>  
  56.                 </tr>  
  57.   
  58. @{  
  59.   
  60. foreach (var item in Model)  
  61.   
  62. {  
  63.   
  64.   
  65.                 <tr style="background-color: #FFFFF0">  
  66.                     <td>  
  67.   
  68. @item.ProjectName  
  69.   
  70. </td>  
  71.                     <td>  
  72.   
  73. @item.Location  
  74.   
  75. </td>  
  76.                     <td>  
  77.   
  78. @Html.ActionLink("Edit", "AddEditProject", new { id = @item.Id }) / @Html.ActionLink("Delete", "Delete", new { id = @item.Id })  
  79.   
  80. @* /@Html.ActionLink("Details", "ProjectDetails", new { basePath = @item.basePath })*@  
  81.   
  82. </td>  
  83.                 </tr>  
  84.   
  85. }  
  86.   
  87. }  
  88.   
  89.   
  90.             </table>  
  91.         </fieldset>  
  92.     </div>  

Now, again go to AdminController and create new view for AddEditProject action with a right click and write the following code:

AddEditProject.cshtml

  1. @model MvcXML.Models.ProjectModels  
  2.   
  3. @{  
  4.   
  5. ViewBag.Title = "AddEditProject";  
  6.   
  7. }  
  8.   
  9.   
  10. <style type="text/css">  
  11.   
  12. .topDiv  
  13.   
  14. {  
  15.   
  16. width: 50%;  
  17.   
  18. margin: 10px auto;  
  19.   
  20. background-color: #f2f2f2;  
  21.   
  22. text-align: center;  
  23.   
  24. padding: 2%;  
  25.   
  26. }  
  27.   
  28.   
  29. .innerDiv  
  30.   
  31. {  
  32.   
  33. margin: 0 auto;  
  34.   
  35. padding: 1%;  
  36.   
  37. color: Gray;  
  38.   
  39. }  
  40.   
  41.   
  42. </style>  
  43.   
  44. @using (Html.BeginForm())  
  45.   
  46. {  
  47.   
  48.   
  49.   
  50. <div class="topDiv">  
  51.     <table>  
  52.         <tr>  
  53.             <h2>Add/Edit User</h2>  
  54.         </tr>  
  55.         <tr>  
  56.             <td>  
  57.   
  58. @Html.LabelFor(m => m.ProjectName) :  
  59.   
  60. </td>  
  61.             <td>  
  62.                 <div class="innerDiv">  
  63.   
  64. @Html.TextBoxFor(m => m.ProjectName)  
  65.   
  66. @Html.ValidationMessageFor(m => m.ProjectName)  
  67.   
  68. </div>  
  69.             </td>  
  70.         </tr>  
  71.         <tr>  
  72.             <td>  
  73.   
  74. @Html.LabelFor(m => m.Location) :  
  75.   
  76. </td>  
  77.             <td>  
  78.                 <div class="innerDiv">  
  79.   
  80. @Html.TextBoxFor(m => m.Location)  
  81.   
  82. @Html.ValidationMessageFor(m => m.ProjectName)  
  83.   
  84. </div>  
  85.             </td>  
  86.         </tr>  
  87.         <tr>  
  88.             <td colspan="2">  
  89.                 <div class="innerDiv">  
  90.                     <input id="btnAdd" type="submit" value="@if (Model.IsEdit)  
  91.   
  92. {  
  93.                         <text>Update</text>}  
  94.   
  95. else  
  96.   
  97. {  
  98.                         <text>Add</text>}" style=" width:75px" />  
  99.                     </div>  
  100.                 </td>  
  101.             </tr>  
  102.         </table>  
  103.     </div>  
  104.   
  105. }  

Now, press F5 to run the Application,

I hope your browser will look as shown below:


After clicking Add New Project and Edit link, your view will be as shown below:


Summary

In this walkthrough, we looked at the development for XML CRUD operation, using MVC. We defined XML class and use the class for CRUD operations.


Get Started

You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.

Become a sharper developer and jumpstart your career.

Basic

$0

$

. 00

monthly

Sign-Up Now

For Basic members:

  • Standard Profile
  • Access learning courses
  • Access free e-books
  • 1x point
Premium

$20

$

. 00

monthly

Sign-Up Now

For Premium members:

  • Earn 2x reward points
  • Premium profile with Verified check
  • Premium Avatar with status update
  • Learning courses
  • Unlimited Certifications and badges on profile
  • Unlimited Book downloads
  • Access to Premium content
  • Online Training
  • Unlimited PDF conversions and downloads
  • Professional Resume Writing
  • Interview Preparations Guide
  • 25 messages per month
  • 1 "Kodzu" avatar, basic
Elite

$45

$

. 00

monthly

Sign-Up Now

For Elite members:

  • Bundle E-books
  • Access to all Learn Series
  • Unlimited Apply Jobs