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); }