i am having form with multiple fields and a table.
now i want to pass the form data to contoller to save in database,
i am using ajax to do the same.
What I have tried:
view code
function sumbit() {
var empFirstName = document.getElementById('txtFirstName').value;
var empLastName = document.getElementById('txtLastName').value;
var empEmail = document.getElementById('txtEmail').value;
var empNumber = document.getElementById('txtNumber').value;
var empAddLine1 = document.getElementById('txtAddLine1').value;
var empAddLine2 = document.getElementById('txtAddLine2').value;
var game = new Array();
$('#empTable tr').each(function (row, tr) {
game[row] = {
"Game": $(tr).find('td').eq(1).text(),
"Player Category": $(tr).find('td').eq(2).text(),
"Player Sub Category": $(tr).find('td').eq(3).text(),
"Player Achievement": $(tr).find('td').eq(4).text()
}
});
var formData = new FormData();
formData.append("FirstName", empFirstName);
formData.append("LastName", empLastName);
formData.append("Email", empEmail);
formData.append("Number", empNumber);
formData.append("AddLine1", empAddLine1);
formData.append("AddLine2", empAddLine2);
formData.append("Game", JSON.stringify(game));
$.ajax({
url: "/Home/Submit",
type: "POST",
contentType: false,
processData: false,
dataType: "JSON",
data: formData,
success: function (r) {
alert(r + " record(s) inserted.");
}
});
}
controller
[HttpPost]
public ActionResult Submit(FormCollection formCode)
{
string i,j;
string FirstName = formCode["FirstName"].ToString();
string LastName = formCode["LastName"].ToString();
string Email = formCode["Email"].ToString();
string Number = formCode["Number"].ToString();
string AddLine1 = formCode["AddLine1"].ToString();
string empId = formCode["AddLine2"].ToString();
string Game= formCode["Game"].ToString();
return View();
}
and i have tried below code also
Submit(string FirstName,string LastName,string Email,string Number,string AddLine1,string AddLine2,string[] Game)
data is coming in all the field, but problem is that value in game is single
[{"Game":"","Player Category":"","Player Sub Category":"","Player Achievement":""},{"Game":"qq","Player Category":"aa","Player Sub Category":"cc","Player Achievement":"zz"},{"Game":"qq","Player Category":"aa","Player Sub Category":"cc","Player Achievement":"zz"}]
I have to save the data of table in database row wise, so it difficult to handle.
i want to pass as array , so i can save easily.