How to save changes to db, using mutliple models in one view?

Hi team

I have multiple models in my View, the issue my form does not save to my db. I have before when used one it was saving well all changes to my db. Kindly please help me to improve my logic better and stuck.

// Controller
//GET:TrainingRegForm/Create/WebRequest.
[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult SubmitRegDetails([Bind(Include= "Id, Title, FirstName, LastName, Position, Company, StreetAddress, StreetAddressLine, City, StateProvince, ZipCode,Country,Email, CellNumber, DietaryRequirement")]TrainingRegForm eNtsaTraining)
{
this.ViewBag.SubmitRegDetails = this.SaveRegForm();
if(ModelState.IsValid)
{
eNtsaTraining.Id = Guid.NewGuid();
db.TrainingRegs.Add(eNtsaTraining);
db.SaveChanges();
return RedirectToAction("SaveRegForm");
}
// Validates when empty.
if(ModelState.IsValid)
{
return RedirectToAction("SaveRegForm");
}
return View(eNtsaTraining);
}
// Data-Access-Layer
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Entity;
using eNtsaRegistrationTraining.Models;
namespace eNtsaRegistrationTraining.DAL
{
public class eNtsaRegistration:DbContext
{
public eNtsaRegistration() : base("eNtsaRegistration")
{
} public DbSet TrainingRegs { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
}
}
}
// Models
namespace eNtsaRegistrationTraining.Models
{
public class TrainingRegForm
{
[Key]
public Guid? Id { get; set; }
public string Title { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Position { get; set; }
public string Company { get; set; }
public string StreetAddress { get; set; }
public string StreetAddressLine { get; set; }
public string City { get; set; }
public string StateProvince { get; set; }
public int ZipCode { get; set; }
public string Country { get; set; }
public string Email { get; set; }
[Required(ErrorMessage = "This field is required")]
[DataType(DataType.PhoneNumber)]
public string CellNumber { get; set; }
public string DietaryRequirement { get; set; }
}
public class RegViewAndRoleViewModel
{
public DietViewModel DietMain { get; set; }
public TrainingRegForm RegForm { get; set; }
public DropDownViewModel ListCountries { get; set; }
public RegistrationTrainingForm HomeModel { get; set; }
public RoleViewModel RoleViewModelData { get; set; }
}
// View
@using eNtsaRegistrationTraining.Models
@model RegViewAndRoleViewModel
@{
ViewBag.Title = "SubmitRegDetails";
}

Its not sending to db, but if i am using one model(TbRegistrationForm only) it does save straight to my DB with all form fields.

Hi Jignesh

I have tried using this logic on the View side, nothing. Let me show full logic of my View.cshtml.

@using (Html.BeginForm("SubmitRegDetails", "Home", FormMethod.Post))
{
class="form-horizontal">
class="form-group row">
for="Title" class="col-sm-2 col-form-label">Title
class="col-sm-3 ">
@Html.EditorFor(model => model.RegForm.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.RegForm.Title, "", new { @class = "text-danger" })

6 Replies

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

Jenith Thakkar6y ago
Accepted answer
Hi
Please marked as a answer if it works for you

Thank you
Guest User6y ago
1. public ActionResult SaveRegForm()
2. {
3. ViewBag.Message = "Details saved successfull";
4. return View(db.TrainingRegs.ToList());
5. }
8. //GET:TrainingRegForm/Submit.
9. public ActionResult SubmitRegDetails()
10. {
11. // Initialization.
12. this.ViewBag.CountryList = this.GetCountryList();
13. this.ViewBag.SaveRegForm = this.SaveRegForm();
15. RegViewAndRoleViewModel model = new RegViewAndRoleViewModel();
17. return View(model);
1. }
5. // View.cshtml
7. @using (Html.BeginForm("SaveRegForm", "Home", FormMethod.Post))
  {
  // Form properties
  }
Hi Jenith
This is what i have tried to do on the controller side to access the SaveRegForm() method be accessible for table definition. Its now complaining about the model being changed. Countrylist does not uses db schema rather its a file to access all list of countries. I have created migration and enable it to allow all changes if model is changed. Please advice mates, the logic i want to able to send all the properties from the form to my table within db.

System.InvalidOperationException
HResult=0x80131509
Message=The model backing the 'eNtsaRegistration' context has changed since the database was created. Consider using Code First Migrations to update the database (http://go.microsoft.com/fwlink/?LinkId=238269).
Source=
StackTrace: