public ActionResult Create([Bind(Include = "CourseId,CourseName,Credits,DepartmentId")] Course course)
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Department, "Id", "Id", course.DepartmentId);
return(View(course));
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,AdmissionTermCode,DateOfBirth,MajorId")] Students students)
{
if (ModelState.IsValid)
{
db.Students.Add(students);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AdmissionTermCode = new SelectList(db.Admission, "TermCode", "TermCode", students.AdmissionTermCode);
ViewBag.MajorId = new SelectList(db.Major, "Id", "Id", students.MajorId);
return(View(students));
}
public ActionResult Create([Bind(Include = "SectionID,CourseID,CourseName,ClassStartTime,ClassEndTime,CourseStartDate,CourseEndDate,CourseHours")] Course course)
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
}
return(View(course));
}
public ActionResult Create([Bind(Include = "StudentsId,CourseId,MajorId,AdmissionTermCode,Grade,EnrolledIndicator,PaymentIndicator")] Enrollment enrollment)
{
if (ModelState.IsValid)
{
db.Enrollment.Add(enrollment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AdmissionTermCode = new SelectList(db.Admission, "TermCode", "TermCode", enrollment.AdmissionTermCode);
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName", enrollment.CourseId);
ViewBag.MajorId = new SelectList(db.Major, "Id", "Id", enrollment.MajorId);
return(View(enrollment));
}
public static void Execute(CoursesDbContext context)
{
context.Courses.AddRange(Courses);
context.Chapters.AddRange(Chapters);
context.Lessons.AddRange(Lessons);
context.Users.AddRange(Users);
context.Achievements.AddRange(Achievements);
context.SaveChanges();
}
public static void Create(CoursesDbContext context)
{
try
{
context.Courses.AddRange(Courses);
context.Chapters.AddRange(Chapters);
context.Lessons.AddRange(Lessons);
context.Users.AddRange(Users);
context.Achievements.AddRange(Achievements);
context.SaveChanges();
} catch (InvalidOperationException)
{
//ignore, xunit multi threading inmemory db makes it tricky to initialize sample data.
}
catch (ArgumentException)
{
//ignore, xunit multi threading inmemory db makes it tricky to initialize sample data.
}
}
public void ReturnCourses()
{
var options = new DbContextOptionsBuilder <CoursesDbContext>()
.UseInMemoryDatabase(databaseName: "CoursesMEM")
.Options;
using (var context = new CoursesDbContext(options))
{
context.Courses.Add(new Course {
Title = "Test Course"
});
context.Courses.Add(new Course {
Title = "Another Silly Course"
});
context.SaveChanges();
}
using (var context = new CoursesDbContext(options))
{
var sut = new CoursesController(context);
var result = sut.GetCourses();
Assert.Equal(2, result.Count());
}
}
public void CreateCourse(Course course)
{
_db.Courses.Add(course);
_db.SaveChanges();
}
//public List<Book> Sort(int id)
//{
// return context.Books.Where(x=>x.AuthorId==id).ToList();
//}
public void Create(TEntity model)
{
_dbSet.Add(model);
context.SaveChanges();
}
