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