public void CreateCourse(Course course) { _trainingContext.Add(course); //_trainingContext.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Teachers ON"); _trainingContext.SaveChanges(); //_trainingContext.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Teachers OFF"); }
static void CreateData(TrainingContext db) { Teacher t1 = new Teacher { Name = "Miss Anderson" }; Teacher t2 = new Teacher { Name = "Miss Bingham" }; Classroom r1 = new Classroom { Number = "R101" }; Classroom r2 = new Classroom { Number = "R202" }; Course c1 = new Course { Title = "Introduction to EF Core", Author = t1, Editor = t2 }; Course c2 = new Course { Title = "Basic Car Maintenance", Author = t2, Editor = t1 }; Student s1 = new Student { Name = "Jenny Jones", Classroom = r1 }; Student s2 = new Student { Name = "Kenny Kent", Classroom = r1 }; Student s3 = new Student { Name = "Lucy Locket", Classroom = r1 }; Student s4 = new Student { Name = "Micky Most", Classroom = r2 }; Student s5 = new Student { Name = "Nelly Norton", Classroom = r2 }; Student s6 = new Student { Name = "Ozzy Osborne", Classroom = r2 }; c1.Students = new Student[] { s1, s2, s3, s4 }; c2.Students = new Student[] { s3, s4, s5, s6 }; db.Add(c1); db.Add(c2); db.SaveChanges(); }
public Operation Create(Operation operation) { operation.Id = Guid.NewGuid(); _context.Add(operation); _context.SaveChanges(); return(operation); }
public Inspection Create(Inspection inspection) { inspection.Id = Guid.NewGuid(); _context.Add(inspection); _context.SaveChanges(); return(inspection); }
public async Task <IActionResult> Create([Bind("CourseID,Credits,Title")] Course course) { _context.Add(course); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); }
public Contract Create(Contract contract) { contract.Id = Guid.NewGuid(); _context.Add(contract); _context.SaveChanges(); return(contract); }
public ResponseMessage InsertTraining(Training training) { var message = new ResponseMessage(); if (training == null) { message.SetErrorMessage("Invalid data"); } var value = _dbContext.Add(training); var insertedCount = Save(); if (insertedCount > 0) { message.SetSuccessMessage("Request sent successfully!"); } else { message.SetErrorMessage("Error sending request"); } return(message); }
public async void DeleteTraining_removes_record_from_database() { //Arrange int idToDelete = 3; var sampleTraining1 = new Training() { Id = idToDelete, StartDate = new DateTime(2019, 09, 19), EndDate = new DateTime(2019, 09, 22), TrainingName = "C# Training" }; context.Add(sampleTraining1); context.SaveChanges(); var expectedType = typeof(NotFoundResult); //Act var taskResult = await myController.DeleteTraining(idToDelete); var getResult = await myController.GetTraining(idToDelete); //Assert Assert.Equal(taskResult.Value.TrainingName, sampleTraining1.TrainingName); Assert.IsType(expectedType, getResult.Result); }
public async Task <bool> Add <T>(T entity) where T : class { _context.Add(entity); return(await _context.SaveChangesAsync() > 0); }
public void CreateTeacher(Teacher teacher) { _trainingContext.Add(teacher); _trainingContext.SaveChanges(); }