Introduction To ASP.NET MVC

@model IEnumerable<WebApplication8.Models.Medicine> @{ ViewBag.Title = "View"; Layout = "~/Views/Shared/_Layout.cshtml"; //WebGrid grid = new WebGrid(Model, rowsPerPage: 5); <script src="~/Scripts/jquery-1.10.2.min.js"></script> <script> $(document).ready(function () { //Call EmpDetails jsonResult Method $.getJSON("/Home/grid", function (json) { var tr; //Append each row to html table for (var i = 0; i < json.length; i++) { tr = $('<tr/>'); tr.append("<td>" + json[i].Medicinename + "</td>"); tr.append("<td>" + json[i].Brand + "</td>"); tr.append("<td>" + new Date((json[i].ExpiryDate).substring(6, 19)) + "</td>"); tr.append("<td>" + json[i].Price + "</td>"); tr.append("<td>" + json[i].Quantity + "</td>"); tr.append("<td>" + json[i].Notes + "</td>"); $('table').append(tr); } }); }); //$(document).ready(function () { // getDateFromAspNetFormat(date: string): number { // const re = /-?\d+/; // const m = re.exec(date); // return parseInt(m[0], 10); // } //} </script> } <h2>View</h2> <p> @Html.ActionLink("Create New", "Create") </p> <style type="text/css"> .table { margin: 4px; border-collapse: collapse; width: 300px; } .header { background-color: gray; font-weight: bold; color: #fff; } .table th, .table td { border: 1px solid black; padding: 5px; } </style> @*@grid.GetHtml( tableStyle: "table", // applying style on grid fillEmptyRows: true, //show empty row when there is only one record on page to it will display all empty rows there. headerStyle: "header", //applying style. footerStyle: "grid-footer", //applying style. mode: WebGridPagerModes.All, //paging to grid firstText: "<< First", previousText: "< Prev", nextText: "Next >", lastText: "Last >>", columns: new[] // colums in grid { grid.Column("Medicinename"), //the model fields to display grid.Column("Brand" ), grid.Column("ExpiryDate"), grid.Column("Price"), grid.Column("Quantity"), grid.Column("Notes"), })*@ <table class="table table-bordered table-condensed table-hover table-striped"> <thead> <tr> <th>Medicinename</th> <th>Brand</th> <th>ExpiryDate</th> <th>Price</th> <th>Quantity</th> <th>Notes</th> </tr> </thead> <tbody></tbody> </table> @*<p> @Html.ActionLink("Create New", "Create") </p> <table class="table"> <tr> <th> @Html.DisplayNameFor(model => model.Medicinename) </th> <th> @Html.DisplayNameFor(model => model.Brand) </th> <th> @Html.DisplayNameFor(model => model.ExpiryDate) </th> <th> @Html.DisplayNameFor(model => model.Price) </th> <th> @Html.DisplayNameFor(model => model.Quantity) </th> <th> @Html.DisplayNameFor(model => model.Notes) </th> <th></th> </tr> @foreach (var item in Model) { <tr> <td> @Html.DisplayFor(modelItem => item.Medicinename) </td> <td> @Html.DisplayFor(modelItem => item.Brand) </td> <td> @Html.DisplayFor(modelItem => item.ExpiryDate) </td> <td> @Html.DisplayFor(modelItem => item.Price) </td> <td> @Html.DisplayFor(modelItem => item.Quantity) </td> <td> @Html.DisplayFor(modelItem => item.Notes) </td> <td> @Html.ActionLink("Edit", "Edit", new { /* id=item.PrimaryKey */ }) | @Html.ActionLink("Details", "Details", new { /* id=item.PrimaryKey */ }) | @Html.ActionLink("Delete", "Delete", new { /* id=item.PrimaryKey */ }) </td> </tr> } </table>*@

Using System;using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using WebApplication8.Models; using Newtonsoft.Json.Linq; using System.IO; using Newtonsoft.Json.Converters; using Newtonsoft.Json; using System.Net.Http; using System.Threading.Tasks; namespace WebApplication8.Controllers { public class HomeController : Controller { private string jsonFile = @"C:\Users\p\source\repos\WebApplication8\WebApplication8\bin\JSONFile.json"; public ActionResult Index() { ViewBag.Title = "Home Page"; return View("Index"); } [HttpGet] //public ActionResult grid() public async Task<JsonResult> grid() { using (HttpClient httpclntobj = new HttpClient()) { string result = string.Empty; httpclntobj.BaseAddress = new Uri("http://localhost:55242/"); HttpResponseMessage rspnsemessage = await httpclntobj.GetAsync("api/values/5"); //var res = rspnsemessage.Result; //var rspnsemessage = new HttpResponseMessage(); if (rspnsemessage.IsSuccessStatusCode == true) { var empresponse = rspnsemessage.Content.ReadAsAsync<int>().Result; } } List<Medicine> lmd = new List<Medicine>(); // creating list of model. var json = System.IO.File.ReadAllText(jsonFile); var jObject = JArray.Parse(json); string jsonstring = Convert.ToString(jObject); //JArray jObjectArray = (JArray)jObject[""]; if (jObject.Count > 0) { lmd = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Medicine>>(jsonstring, new JsonSerializerSettings { DateFormatHandling = DateFormatHandling.MicrosoftDateFormat }); //foreach (Medicine lm in lmd) //{ // lm.ExpiryDate = //} //lmd.Add(new Medicine //{ // Medicinename = jObject["Medicinename"].ToString(), // adding data from dataset row in to list<modeldata> // Brand = jObject["Brand"].ToString(), // ExpiryDate = jObject["ExpiryDate"].ToString(), // Price = Convert.ToDouble(jObject["Price"]), // Quantity = Convert.ToInt16(jObject["Quantity"]), // Notes = (jObject["Notes"]).ToString(), //}); } //DataSet ds = new DataSet(); //Connection.Connection con = new Connection.Connection(); // connection to getdata. //ds = con.mydata(); // fill dataset //foreach (DataRow dr in ds.Tables[0].Rows) // loop for adding add from dataset to list<modeldata> //{ //lmd.Add(new Medicine //{ // Medicinename = "MedicineName", // adding data from dataset row in to list<modeldata> // Brand = "BrandName", // ExpiryDate = "21-06-1988", // Price = 12.12, // Quantity = 12, // Notes = "Notes" //}); //} //return View("Index", lmd); return Json(lmd, JsonRequestBehavior.AllowGet); } public ActionResult Create() { return View("CreateMedicine"); } [HttpPost] public ActionResult Create(Medicine newRecord) { List<Medicine> lmd = new List<Medicine>(); var json = System.IO.File.ReadAllText(jsonFile); var jObject = JArray.Parse(json); string jsonstring = Convert.ToString(jObject); lmd = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Medicine>>(jsonstring); if (ModelState.IsValid) { lmd.Add(new Medicine { Medicinename = newRecord.Medicinename, // adding data from dataset row in to list<modeldata> Brand = newRecord.Brand, ExpiryDate = newRecord.ExpiryDate, Price = newRecord.Price, Quantity = newRecord.Quantity, Notes = newRecord.Notes }); String jsonContent = Newtonsoft.Json.JsonConvert.SerializeObject(lmd, new IsoDateTimeConverter { DateTimeFormat = "MM/dd/yyyy" }); System.IO.File.WriteAllText(jsonFile, jsonContent); return RedirectToAction("Index"); //return View("Index"); } else { return View("Index"); } } } }

Really helpfull akshaysir

Thanks for sharing.

Good share

Thankyou EveryOne :)

Nice Article..

Nice..

Nice one..

Good One..

Nice

Nice share

Nice explain..

Nice one....

Nice...

Good one