public ActionResult Index()
{
using (var context = new SeminarDbContext())
{
return(Json(context.Courses.AsEnumerable().Select(x => _courseMapper.MapToView(x)).ToList(), JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> Create(CreateCourseParticipantViewModel courseParticipant) // todo ViewModel CourseId should be GET param.
{
if (!ModelState.IsValid)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var context = new SeminarDbContext())
{
var courseModel = await context.Courses.FindAsync(courseParticipant.CourseId);
if (courseModel == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound));
}
context.CourseParticipants.Add(new CourseParticipant
{
Name = courseParticipant.Name,
Email = courseParticipant.Email,
Course = courseModel
});
await context.SaveChangesAsync();
}
return(new HttpStatusCodeResult(HttpStatusCode.Created));
}
public void SeminarDbContextTests_CreateDatabase_Success()
{
// Act
using (var ctx = new SeminarDbContext())
{
// Assert
Assert.IsTrue(ctx.Database.Exists());
}
}
public void BeforeTest(TestDetails testDetails)
{
Database.SetInitializer(new DropCreateAndMigrateDatabaseInitializer <SeminarDbContext, SeminarDbMigrationsConfiguration>());
using (var ctx = new SeminarDbContext())
{
ctx.Database.Initialize(true);
}
}
public ActionResult Login(Zaposlenik model)
{
using (var context = new SeminarDbContext())
{
bool isValid = context.Zaposlenik.Any(x => x.KorisnickoIme == model.KorisnickoIme && x.Password == model.Password);
if (isValid)
{
FormsAuthentication.SetAuthCookie(model.KorisnickoIme, false);
return(RedirectToAction("Index", "Predbiljezba"));
}
ModelState.AddModelError("", "Krivo korisničko ime ili lozinka!");
return(View());
}
}
public void CourseTests_AddCourseParticipant_Success()
{
// Act
using (var ctx = new SeminarDbContext())
{
ctx.CourseParticipants.Add(new CourseParticipant());
ctx.SaveChanges();
}
// Assert
using (var ctx = new SeminarDbContext())
{
Assert.AreEqual(1, ctx.CourseParticipants.Count());
}
}
public async Task <ActionResult> Create([Bind(Exclude = "Id")] CourseViewModel course)
{
if (!ModelState.IsValid)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var context = new SeminarDbContext())
{
var model = _courseMapper.MapToModel(course);
context.Courses.Add(model);
await context.SaveChangesAsync();
}
return(new HttpStatusCodeResult(HttpStatusCode.Created));
}
public void CourseTests_AddCourse_Success()
{
// Act
using (var ctx = new SeminarDbContext())
{
ctx.Courses.Add(new Course("Name", "Test", "Test", DateTime.Now, DateTime.Now.AddDays(1)));
ctx.SaveChanges();
}
// Assert
using (var ctx = new SeminarDbContext())
{
Assert.AreEqual(1, ctx.Courses.Count());
Assert.AreEqual("Name", ctx.Courses.First().Name);
}
}
public async Task <ActionResult> Get(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var context = new SeminarDbContext())
{
var course = await context.Courses.FindAsync(id);
if (course == null)
{
return(HttpNotFound());
}
return(Json(_courseMapper.MapToView(course), JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> Get(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound));
}
using (var context = new SeminarDbContext())
{
var course = await context.Courses.Include("Participants").SingleAsync(x => x.Id == id);
if (course == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound));
}
return(Json(
course.Participants.Select(x => _courseParticipantMapper.MapToView(x)).ToList(),
JsonRequestBehavior.AllowGet));
}
}
public CoursesControllerTests()
{
// Initialize DbContext in memory
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseInMemoryDatabase();
_context = new MyDbContext(optionsBuilder.Options);
// Seed data
_context.People.Add(new Person()
{
FirstName = "John",
LastName = "Doe"
});
_context.People.Add(new Person()
{
FirstName = "Sally",
LastName = "Doe"
});
_context.SaveChanges();
// Create test subject
_controller = new HomeController(_context);
}
public SeminarService()
{
_dbContext = new SeminarDbContext();
}
public UserRepository(SeminarDbContext dbContext) : base(dbContext)
{
}
public TagRepository(SeminarDbContext dbContext) : base(dbContext)
{
}
public LocationService()
{
_dbContext = new SeminarDbContext();
}
public TrackService()
{
_dbContext = new SeminarDbContext();
}
public SeminarUow(SeminarDbContext context)
{
InitialiseDbContext(context);
}
public SchoolRepository(SeminarDbContext dbContext) : base(dbContext)
{
}
public CommonRepository(SeminarDbContext dbContext)
{
DbContext = dbContext;
}
public LevelService()
{
_dbContext = new SeminarDbContext();
}
