ASP.NET MVC USING JQUERY AJAX CALL(CRUD)

Question

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<byte> howManyAddress { get; set; }

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

public virtual ICollection<personAddress> 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<int> sequenceNo { get; set; }

public string country { get; set; }

public string city { get; set; }

public string addressStreet { get; set; }

[ForeignKey("personId")]

public Nullable<int> 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<person> people { get; set; }

public virtual DbSet<personAddress> personAddresses { get; set; }

}

}

 

 

 

//INDEX.CSHTML

 

 

 

<table cellpadding="10" cellspacing="10">

<tr><td>Person Name</td><td>:</td><td><input type="text" id="personName" required /></td></tr>

<tr><td>Mobile Number</td><td>:</td><td><input type="text" id="mobileNo" maxlength="10" required /></td></tr>

</table>

How many Addresses ? :<select id="ddl" required>

<option value="Select">Select</option>

<option value="1">1</option>

<option value="2">2</option>

<option value="3">3</option>

<option value="4">4</option>

</select>

<br />

<br />

<table id="tabEmp" border="1" cellpadding="10" cellspacing="10" width="100"></table>

<br />

<br />

<input type="button" id="btnSave" value="Save" onclick="Save()" disabled />

<script src="~/Scripts/jquery-1.10.2.min.js">

</script>

<script>

$(document).ready(function () {

$("#personName").focusout(function () {

debugger

if ($(this).val() == "") {

alert("please enter the name");

}

});

$("#mobileNo").keyup(function () {

debugger

$("#errorNumeric").hide();

var inputVal = $(this).val();

var numericVerify = /^(\d*[0-9])?$/;;

debugger;

if (!numericVerify.test(inputVal)) {

debugger;

$(this).after('<span id="errorNumeric">"please enter numeric values only!"</span>');

}

});

$("#mobileNo").focusout(function () {

if ($(this).val().length != 10) {

alert("please enter 10 digit valid mobile number");

}

});

if ($("#ddl").change(function () {

debugger

$("#tabEmp").empty();

$("#tabEmp").append("<tr><td>Sequence No</td><td>Country</td><td>City</td><td>Address/Street</td></tr>");

if ($("#ddl").val() == "Select") {

$("#tabEmp").empty();

$("#btnSave").prop('disabled', true)

}

else {

$("#btnSave").prop('disabled', false);

var NoofAddress = $("#ddl").val();

for (var i = 0; i < NoofAddress; i++) {

var markup = '<tr><td><input type="text" id=sequenceNo' + i + '></td><td><input type="text" id=country' + i + '></td><td><input type="text" id=city' + i + '></td><td><input type="text" id=address' + i + '></td></tr>';

$("#tabEmp").append(markup);

markup = "";

if ($("#ddl").val() == "Select") {

$("#tabEmp").append(markup);

}

}

};

}));

$("#btnSave").click(function () {

var array = [];

var noofaddresses = $("#ddl").val();

var pName = $("#personName").val();

var mNo = $("#mobileNo").val();

for (var i = 0; i < noofaddresses; i++) {

array.push({

"sequenceNo": $("#sequenceNo" + i).val(),

"country": $("#country" + i).val(),

"city": $("#city" + i).val(),

"addressStreet": $("#address" + i).val()

})

}

$.ajax({

method: "POST",

url: '@Url.Action("getJson")',

contentType: "application/json",

data: JSON.stringify({                                //CAN ANYONE PLEASE TELL ME HOW TO PASS                                                                         //THESE JSON VALUES TO DATABASE (SQL                                                                                                  //USING   //CONTROLLER)//FOR SAVING                                                                         //VALUES TO DATABASE

personName: pName,

mobileNumber: mNo,

personAddresses:array

}),

dataType: "json",

success: function (result) {

alert("success")

},

error: function (result) {

alert("data not inserted")

},

});

});

});

</script>

//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();

}

}

}