ASP.NET MVC USING JQUERY AJAX CALL(CRUD)

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.ComponentModel.DataAnnotations.Schema;

using System.ComponentModel.DataAnnotations;

namespace crudExcel1.Models //person class

{

[Table("person")]

public class person

{

[Key]

public int personId { get; set; }

public string personName { get; set; }

public string mobileNumber { get; set; }

public Nullable howManyAddress { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]

public virtual ICollection personAddresses { get; set; }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.ComponentModel.DataAnnotations.Schema;

using System.ComponentModel.DataAnnotations;

namespace crudExcel1.Models //person ADDRESS CLASS

{

[Table("personAddress")]

public class personAddress

{

[Key]

public int addressId { get; set; }

public Nullable sequenceNo { get; set; }

public string country { get; set; }

public string city { get; set; }

public string addressStreet { get; set; }

[ForeignKey("personId")]

public Nullable personId { get; set; }

public virtual person person { get; set; }

}

//DBCONTEXT CLASS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data;

using System.Data.Entity;

namespace crudExcel1.Models

{

public class excelcrud1Entities:DbContext

{

public excelcrud1Entities()

: base("name=excelcrud1Entities")

{

}

public virtual DbSet people { get; set; }

public virtual DbSet personAddresses { get; set; }

}

//INDEX.CSHTML

Person Name	:
Mobile Number	:

How many Addresses ? :

//CONTROLLER

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data;

using System.Data.Entity;

using System.Data.SqlClient;

using System.Web.Mvc;

using crudExcel1.Models;

namespace crudExcel1.Controllers

{

public class personController : Controller

{

excelcrud1Entities db = new excelcrud1Entities();

// GET: person

public ActionResult Index()

{

return View();

}

public JsonResult getJson()

{

return Json();

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Y G10y ago
Hi @Midhun, the links you have sent are very useful, but , they are not doing any favour for my case, as I am going to store the data to two tables having a foreign key relationship between them.
Midhun Tp10y ago
Hi,

Please go through below links-
http://webcognoscere.com/post/how-to-post-a-json-object-to-a-controller-action.aspx
http://stackoverflow.com/questions/12446024/post-json-with-mvc-4-api-controller
Y G10y ago
/CAN ANYONE PLEASE TELL ME HOW TO PASS //THESE JSON VALUES TO DATABASE (SQL //USING //CONTROLLER) // FOR SAVING // VALUES TO DATABASE