public void Insert( ) { muscle_log.framework.Models.MuscleLogContext ctx = new muscle_log.framework.Models.MuscleLogContext("metadata=res://*/Models.MuscleLogModel.csdl|res://*/Models.MuscleLogModel.ssdl|res://*/Models.MuscleLogModel.msl;provider=System.Data.SqlClient;provider connection string='data source=MAX-PC;Initial Catalog=muscle-log;User ID=Max-PC;integrated security=SSPI;multipleactiveresultsets=True;application name=EntityFramework'"); var unitOfWork = new EFContextUnitOfWork(ctx); var repo = new Repository<ml_ForumThread>(unitOfWork); ForumThreadService service = new ForumThreadService(repo); int countBefore = service.ListThreads(muscle_log.framework.Util.Enum.Forums.Meta).Count(); ForumThreadViewModel input = new ForumThreadViewModel( ); input.ID = -1; input.UserID = 7; input.Title = "Testeintrag"; input.Body = "Das ist ein Testeintrag. ~*</fsd !§$(%)=&??``´´'<<<><>>>@fsdf%%<%=fds"; input.Forum = muscle_log.framework.Util.Enum.Forums.Meta; service.Save( input ); int countAfter = service.ListThreads(muscle_log.framework.Util.Enum.Forums.Meta).Count(); // there must be one more thread than before Assert.AreEqual( countAfter, ( countBefore + 1 ) ); // the id of the new thread must be bigger than 0 Assert.Greater( input.ID, 0 ); // the members of the input object and the output object must be equal var output = repo.Get(input.ID); Assert.AreNotEqual( input, output ); Assert.AreEqual( input.Title, output.Title ); Assert.AreEqual( input.Body, output.Body ); Assert.AreEqual( input.Forum, output.Forum ); Assert.AreEqual( input.UserID, output.UserID ); unitOfWork.Dispose(); }
/// <summary> /// lists the latest 10 forum threads /// </summary> /// <returns></returns> public ActionResult ListForumThreads( ) { using (var unitOfWork = new EFContextUnitOfWork(new MuscleLogContext())) { var service = new ForumThreadService(new Repository<ml_ForumThread>(unitOfWork)); return PartialView("_ListForumThreads", service.ListLatestThreads(10)); } }
/// <summary> /// displays the recent activities /// </summary> /// <returns></returns> public ActionResult ListActivities( ) { using (var unitOfWork = new EFContextUnitOfWork(new MuscleLogContext())) { var service = new ActivitiesService(new ActivityRepository(unitOfWork)); return PartialView("_ListActivities", service.List()); } }
/// <summary> /// returns the description of an exercise as a JSON result /// </summary> /// <param name="exerciseID">ID of the exercise</param> /// <returns>JSON object of the exercise description</returns> public ActionResult GetExerciseDescription(int id) { ml_ExerciseLibrary exercise = null; using (var unitOfWork = new EFContextUnitOfWork(new MuscleLogContext())) { var service = new ExerciseLibraryService(new ExerciseRepository(unitOfWork)); exercise = service.GetExercise(id); } return Json(exercise, JsonRequestBehavior.AllowGet); }
/// <summary> /// lists all exercises /// </summary> /// <returns></returns> public ActionResult Index() { var context = new MuscleLogContext(); using(var unitOfWork = new EFContextUnitOfWork(context)) { var userService = new UserService(new Repository<ml_User>(unitOfWork)); var exerciseService = new ExerciseLibraryService(new ExerciseRepository(unitOfWork)); ViewData["UserCanEdit"] = userService.ExerciseAccess(CurrentUser, Convert.ToInt32(ConfigurationManager.AppSettings["EditExerciseRequiredLevel"])); return View(exerciseService.GetMuscleGroups()); } }
public ActionResult Report( BugreportItemViewModel model ) { if ( ModelState.IsValid ) { using (var unitOfWork = new EFContextUnitOfWork(new MuscleLogContext())) { var service = new BugreportService(new Repository<ml_Bugreport>(unitOfWork)); service.Save(model); TempData[ "successMessage" ] = "Vielen Dank für dein Feedback! Deine Rückmeldung wurde erfolgreich gespeichert."; } } return View( ); }
/// <summary> /// saves or creates a new exercise library item. /// </summary> /// <param name="model">ExerciseModel object to be saved</param> /// <returns>1 for success, 0 for error</returns> public JsonResult SaveExercise(string exerciseID, string exerciseDescription, string exerciseExecution) { int eID = -1; if(!Int32.TryParse(exerciseID, out eID) || eID == -1) return Json(0); ml_ExerciseLibrary exercise = new ml_ExerciseLibrary(); exercise.ID = eID; exercise.ExerciseDescription = exerciseDescription; exercise.ExerciseExecution = exerciseExecution; using (var unitOfWork = new EFContextUnitOfWork(new MuscleLogContext())) { var service = new ExerciseLibraryService(new ExerciseRepository(unitOfWork)); service.SaveExercise(exercise); } return Json(1); }
public void Update( ) { muscle_log.framework.Models.MuscleLogContext ctx = new muscle_log.framework.Models.MuscleLogContext("metadata=res://*/Models.MuscleLogModel.csdl|res://*/Models.MuscleLogModel.ssdl|res://*/Models.MuscleLogModel.msl;provider=System.Data.SqlClient;provider connection string='data source=MAX-PC;Initial Catalog=muscle-log;User ID=Max-PC;integrated security=SSPI;multipleactiveresultsets=True;application name=EntityFramework'"); var unitOfWork = new EFContextUnitOfWork(ctx); var repo = new Repository<ml_ForumThread>(unitOfWork); ForumThreadService service = new ForumThreadService(repo); ml_ForumThread model = service.GetThread(6); int beforeTraining = service.ListThreads(muscle_log.framework.Util.Enum.Forums.Training).Count(); int beforeMeta = service.ListThreads(muscle_log.framework.Util.Enum.Forums.Meta).Count(); model.Forum = muscle_log.framework.Util.Enum.Forums.Training.ToString(); service.Save(model); ml_ForumThread modelAfterChange = repo.Get(model.ID); int afterTraining = service.ListThreads(muscle_log.framework.Util.Enum.Forums.Training).Count(); int afterMeta = service.ListThreads(muscle_log.framework.Util.Enum.Forums.Meta).Count(); Assert.AreNotEqual(afterTraining, beforeTraining); Assert.AreNotEqual(afterMeta, beforeMeta); Assert.AreNotEqual(model.LUDT, modelAfterChange.LUDT); unitOfWork.Dispose(); }
public void Setup() { _context = new MuscleLogContext("metadata=res://*/Models.MuscleLogModel.csdl|res://*/Models.MuscleLogModel.ssdl|res://*/Models.MuscleLogModel.msl;provider=System.Data.SqlClient;provider connection string='data source=MAX-PC;Initial Catalog=muscle-log;User ID=Max-PC;integrated security=SSPI;multipleactiveresultsets=True;application name=EntityFramework'"); _unitOfWork = new EFContextUnitOfWork(_context); _repository = new Repository<ml_Bugreport>(_unitOfWork); _addedEntities = new List<ml_Bugreport>(); _deletedEntities = new List<ml_Bugreport>(); _updatedEntities = new List<ml_Bugreport>(); }
public ActivityRepository(EFContextUnitOfWork unitOfWork) { _unitOfWork = unitOfWork; }