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>
  4. @{
  6. ViewBag.Title = "Index";
  8. }
  11. <style type="text/css">
  13. .topDiv
  15. {
  17. width: 50%;
  19. margin: 10px auto;
  21. background-color: #f2f2f2;
  23. text-align: left;
  25. padding: 2%;
  27. }
  29. </style>
  30. <div class="topDiv">
  31. <fieldset style="margin: 2% auto; width: 90%; background-color: #FFEBCD; text-align: center">
  32. <h4>
  34. @Html.ActionLink("Add New project", "AddEditProject")
  36. </h4>
  37. </fieldset>
  38. <fieldset>
  39. <table style="margin: 2% auto; padding: 5px; width: 90%">
  40. <tr style="background-color: #FFFACD">
  41. <th>
  43. ProjectName
  45. </th>
  46. <th>
  48. Location
  50. </th>
  51. <th>
  53. Manage
  55. </th>
  56. </tr>
  58. @{
  60. foreach (var item in Model)
  62. {
  65. <tr style="background-color: #FFFFF0">
  66. <td>
  68. @item.ProjectName
  70. </td>
  71. <td>
  73. @item.Location
  75. </td>
  76. <td>
  78. @Html.ActionLink("Edit", "AddEditProject", new { id = @item.Id }) / @Html.ActionLink("Delete", "Delete", new { id = @item.Id })
  80. @* /@Html.ActionLink("Details", "ProjectDetails", new { basePath = @item.basePath })*@
  82. </td>
  83. </tr>
  85. }
  87. }
  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
  3. @{
  5. ViewBag.Title = "AddEditProject";
  7. }
  10. <style type="text/css">
  12. .topDiv
  14. {
  16. width: 50%;
  18. margin: 10px auto;
  20. background-color: #f2f2f2;
  22. text-align: center;
  24. padding: 2%;
  26. }
  29. .innerDiv
  31. {
  33. margin: 0 auto;
  35. padding: 1%;
  37. color: Gray;
  39. }
  42. </style>
  44. @using (Html.BeginForm())
  46. {
  50. <div class="topDiv">
  51. <table>
  52. <tr>
  53. <h2>Add/Edit User</h2>
  54. </tr>
  55. <tr>
  56. <td>
  58. @Html.LabelFor(m => m.ProjectName) :
  60. </td>
  61. <td>
  62. <div class="innerDiv">
  64. @Html.TextBoxFor(m => m.ProjectName)
  66. @Html.ValidationMessageFor(m => m.ProjectName)
  68. </div>
  69. </td>
  70. </tr>
  71. <tr>
  72. <td>
  74. @Html.LabelFor(m => m.Location) :
  76. </td>
  77. <td>
  78. <div class="innerDiv">
  80. @Html.TextBoxFor(m => m.Location)
  82. @Html.ValidationMessageFor(m => m.ProjectName)
  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)
  92. {
  93. <text>Update</text>}
  95. else
  97. {
  98. <text>Add</text>}" style=" width:75px" />
  99. </div>
  100. </td>
  101. </tr>
  102. </table>
  103. </div>
  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.