public ActionResult OnPost()
{
if (!ModelState.IsValid)
{
Persons = _cruddbcontext.Persons.ToList();
return(Page());
}
_cruddbcontext.Persons.Add(Person);
_cruddbcontext.SaveChanges();
return(Redirect("/person"));
}
public void AddAgent(AgentInfoModel Agent, int[] Flights)
{
if (Agent.AgentInfoId == 0)
{
Agent.IsDeleted = false;
_db.AgentInfoModels.Add(Agent);
_db.SaveChanges();
}
else
{
_updateAgent(Agent);
}
_addFlightByAgent(Agent.AgentInfoId, Flights);
}
public ActionResult OnPost()
{
if (!ModelState.IsValid)
{
return(Page());
}
//var per = _cruddbcontext.Persons.FirstOrDefault(person => person.PersonId==person.PersonId);
Person per = new Person();
per = _cruddbcontext.Persons.FirstOrDefault(p => p.PersonId == p.PersonId);
if (per != null)
{
per.Firstname = Person.Firstname;
per.Lastname = Person.Lastname;
per.MI = Person.MI;
per.EmailAddress = Person.EmailAddress;
per.Address = Person.Address;
per.Age = Person.Age;
per.Contact = Person.Contact;
_cruddbcontext.Update(per);
_cruddbcontext.SaveChanges();
}
return(Redirect("person"));
}
public void TestInitialize()
{
//I needed to use in-memory DbContext instead of connecting to SQL Server
var options = new DbContextOptionsBuilder <CRUDDBContext>()
.UseInMemoryDatabase("SomeRandomString")
.Options;
var _context = new CRUDDBContext(options);
//create mock data and add to in-memory db
Employees mockEmpName = new Employees {
EmployeeId = 3,
EmpName = "A fake Name"
};
employees.Add(new Employees
{
EmployeeId = 1,
Position = "Anything",
DeptId = "HumanResource",
EmpName = mockEmpName
});
employees.Add(new Employees
{
EmployeeId = 12,
Position = "Manager",
DeptId = "HumanResource",
EmpName = mockEmpName
});
foreach (var e in employees)
{
_context.Employees.Add(e);
}
_context.SaveChanges();
employeesController = new EmployeesController(_context);
}