finance_teacher
asked on
simple "SAVE" -- C# ASP.net MVC4 ?
Below runs, but does not insert the two new records.
How can I fix ?
Steps
1. go to http://localhost:63802/C21/MAINT_WORK_REQ/test1
2. below code runs
3. refresh database
4. below new records do NOT appear
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --
using System;
using System.Collections.Generic ;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MWR.Models;
namespace MWR.Areas.C21.Controllers
{
public class MAINT_WORK_REQController : Controller
{
private MVC_testEntities db = new MVC_testEntities();
public ActionResult test1()
{
//create First Record
MAINT_WORK_REQ mwr1 = new MAINT_WORK_REQ();
mwr1.ProgramID = "1";
mwr1.ProjectID = "1";
mwr1.CreatedBy = "1";
mwr1.LastModifiedBy = "1";
mwr1.HSS_FWD = true;
mwr1.HSS_INB = false;
mwr1.HSS_OUTB = true;
mwr1.BODYSTA_FWD = true;
mwr1.BODYSTA_BOT = true;
mwr1.BODYSTA_TOP = true;
mwr1.EngineerRequired = true;
//create Second Record
MAINT_WORK_REQ mwr2 = new MAINT_WORK_REQ();
mwr2.ProgramID = "1";
mwr2.ProjectID = "1";
mwr2.CreatedBy = "1";
mwr2.LastModifiedBy = "1";
mwr2.HSS_FWD = true;
mwr2.HSS_INB = false;
mwr2.HSS_OUTB = true;
mwr2.BODYSTA_FWD = true;
mwr2.BODYSTA_BOT = true;
mwr2.BODYSTA_TOP = true;
mwr2.EngineerRequired = true;
//add both records
db.SaveChanges();
return View(db.MAINT_WORK_REQ.ToL ist());
}
How can I fix ?
Steps
1. go to http://localhost:63802/C21/MAINT_WORK_REQ/test1
2. below code runs
3. refresh database
4. below new records do NOT appear
--------------------------
using System;
using System.Collections.Generic
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MWR.Models;
namespace MWR.Areas.C21.Controllers
{
public class MAINT_WORK_REQController : Controller
{
private MVC_testEntities db = new MVC_testEntities();
public ActionResult test1()
{
//create First Record
MAINT_WORK_REQ mwr1 = new MAINT_WORK_REQ();
mwr1.ProgramID = "1";
mwr1.ProjectID = "1";
mwr1.CreatedBy = "1";
mwr1.LastModifiedBy = "1";
mwr1.HSS_FWD = true;
mwr1.HSS_INB = false;
mwr1.HSS_OUTB = true;
mwr1.BODYSTA_FWD = true;
mwr1.BODYSTA_BOT = true;
mwr1.BODYSTA_TOP = true;
mwr1.EngineerRequired = true;
//create Second Record
MAINT_WORK_REQ mwr2 = new MAINT_WORK_REQ();
mwr2.ProgramID = "1";
mwr2.ProjectID = "1";
mwr2.CreatedBy = "1";
mwr2.LastModifiedBy = "1";
mwr2.HSS_FWD = true;
mwr2.HSS_INB = false;
mwr2.HSS_OUTB = true;
mwr2.BODYSTA_FWD = true;
mwr2.BODYSTA_BOT = true;
mwr2.BODYSTA_TOP = true;
mwr2.EngineerRequired = true;
//add both records
db.SaveChanges();
return View(db.MAINT_WORK_REQ.ToL
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
public ActionResult test1()
{
//create First Record
MAINT_WORK_REQ mwr1 = new MAINT_WORK_REQ();
mwr1.ProgramID = "1";
mwr1.ProjectID = "1";
mwr1.CreatedBy = "1";
mwr1.LastModifiedBy = "1";
mwr1.HSS_FWD = true;
mwr1.HSS_INB = false;
mwr1.HSS_OUTB = true;
mwr1.BODYSTA_FWD = true;
mwr1.BODYSTA_BOT = true;
mwr1.BODYSTA_TOP = true;
mwr1.EngineerRequired = true;
db.MAINT_WORK_REQ.Add(mwr1
db.SaveChanges();
//create Second Record
MAINT_WORK_REQ mwr2 = new MAINT_WORK_REQ();
mwr2.ProgramID = "1";
mwr2.ProjectID = "1";
mwr2.CreatedBy = "1";
mwr2.LastModifiedBy = "1";
mwr2.HSS_FWD = true;
mwr2.HSS_INB = false;
mwr2.HSS_OUTB = true;
mwr2.BODYSTA_FWD = true;
mwr2.BODYSTA_BOT = true;
mwr2.BODYSTA_TOP = true;
mwr2.EngineerRequired = true;
db.MAINT_WORK_REQ.Add(mwr2
db.SaveChanges();
return View(db.MAINT_WORK_REQ.ToL
}