public void A_CreateWorkoutTest() { var categories = workoutCategoryService.GetWorkoutCategories().FirstOrDefault(); var users = userService.GetUsers().FirstOrDefault(); workout_collection wc = new workout_collection() { workout_id = 0, workout_title = "TestServiceWorkout", workout_note = "TestServiceNote", category_id = categories.category_id, calories_burn_per_min = 50, user_id = users.user_id, user = users, workout_category = categories, workout_active = null }; var wrList = workoutCollectionService.GetWorkouts().Where(x => x.workout_title.Equals(wc.workout_title, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); if (wrList != null) { } else { workoutCollectionService.CreateWorkout(wc); var result = workoutCollectionRepository.FindBy(x => x.workout_title.Equals(wc.workout_title, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); Assert.AreNotEqual(0, result.workout_id); } }
public void A_AddWorkoutTest() { var categories = workoutCategoryRepository.GetCategories().FirstOrDefault(); var users = userRepository.GetAll().FirstOrDefault(); workout_collection wc = new workout_collection() { workout_id = 0, workout_title = "TestRepositoryWorkout", workout_note = "TestRepositoryNote", category_id = categories.category_id, calories_burn_per_min = 50, user_id = users.user_id, user = users, workout_category = categories, workout_active = null }; var usrList = wcRepository.FindBy(x => x.workout_title.Equals(wc.workout_title, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); if (usrList != null) { } else { wcRepository.AddWorkout(wc); _context.SaveChanges(); var result = wcRepository.FindBy(x => x.workout_title.Equals(wc.workout_title, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); Assert.AreNotEqual(0, result.workout_id); } }
private void GenerateWeeklyReport(workout_collection wc, DateTime fow, DateTime low, ref Report rpt) { var wa = wc.workout_active.Where(w => w.start_date.Value >= fow && w.start_date.Value <= low && w.status == true).ToList(); if (wa != null && wa.Count > 0) { for (int i = 0; i < wa.Count; i++) { GenerateWeeklyData(wa[i].start_date.Value.DayOfWeek.ToString(), wa[i].workout_collection.calories_burn_per_min, ref rpt); } } }
public void UpdateWorkout(Entities.workout_collection newobj) { using (var ctx = new WorkoutContext()) { workout_collection obj = ctx.Workout_collection.SingleOrDefault(i => i.workout_id == newobj.workout_id); obj.workout_title = newobj.workout_title; obj.Workout_category = newobj.Workout_category; obj.calories_burn_min = newobj.calories_burn_min; obj.note = newobj.note; ctx.SaveChanges(); } }
private void MapCollection(workout_collection source, ref WorkoutCollection des) { des.workout_id = source.workout_id; des.workout_title = source.workout_title; des.workout_note = source.workout_note; des.category_id = source.category_id; des.user_id = source.user_id; des.calories_burn_per_min = source.calories_burn_per_min; des.workout_category = Helper.CastObject <WorkoutCategory>(source.workout_category); des.workout_active = Helper.CastObject <IList <WorkoutActive> >(source.workout_active); des.user = Helper.CastObject <User>(source.user); }
public void H_UpdateWorkoutTest() { workout_collection wc = new workout_collection(); var workout = workoutCollectionService.GetWorkouts().Where(x => x.workout_title.Equals("TestServiceWorkout", StringComparison.InvariantCultureIgnoreCase)) .FirstOrDefault(); if (workout != null) { workout.workout_note = "TestServiceNote1"; wc = workoutCollectionService.UpdateWorkout(workout); Assert.AreNotEqual("TestServiceNote", wc.workout_note); } }
public IHttpActionResult Post(workout_collection item) { db.workout_collection.Add(item); int NoOfRowsAffected = db.SaveChanges(); if (NoOfRowsAffected > 0) { return(StatusCode(HttpStatusCode.Created)); } { return(BadRequest("Failed To add workout")); } }
public IHttpActionResult Post(workout_collection obj1) { obj.workout_collection.Add(obj1); var r = obj.SaveChanges(); if (r > 0) { return(StatusCode(HttpStatusCode.Created)); } { return(BadRequest("not exist")); } }
public void G_UpdateWorkoutTest() { workout_collection wc = new workout_collection(); var workout = wcRepository.GetAll().Where(x => x.workout_title.Equals("TestRepositoryWorkout", StringComparison.InvariantCultureIgnoreCase)) .FirstOrDefault(); if (workout != null) { workout.workout_note = "TestRepositoryNote1"; wc = wcRepository.UpdateWorkout(workout); _context.SaveChanges(); Assert.AreNotEqual("TestRepositoryNote", wc.workout_note); } }
public IHttpActionResult Put(workout_collection obj1) { obj.workout_collection.Attach(obj1); obj.Entry(obj1).State = System.Data.Entity.EntityState.Modified; var r = obj.SaveChanges(); if (r > 0) { return(StatusCode(HttpStatusCode.Accepted)); } else { return(BadRequest("not exust")); } }
public IHttpActionResult Put(workout_collection obj) { db.workout_collection.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; var NoOfRowsAffected = db.SaveChanges(); if (NoOfRowsAffected > 0) { return(StatusCode(HttpStatusCode.Accepted)); } else { return(BadRequest("Failed To Modify")); } }
private void GenerateMonthlyReport(List <DateTime> wk, workout_collection wc, DateTime fow, DateTime low, ref Report rpt) { var wa = wc.workout_active.Where(w => w.start_date.Value >= fow && w.start_date.Value <= low && w.status == true).ToList(); if (wa != null && wa.Count > 0) { for (int i = 0; i < wk.Count(); i++) { var wek = wk.ToArray(); var data = wa.Where(x => x.start_date >= wek[i].FirstOfWeek() && x.start_date <= wek[i].AddDays(7).AddSeconds(-1)).ToList(); if (data != null && data.Count > 0) { for (int j = 0; j < data.Count(); j++) { GenerateMonthlyData(data.Sum(item => item.workout_collection.calories_burn_per_min), i, ref rpt); } } } } }
public HttpResponseMessage DeleteWorkoutcollection(workout_collection obj) { dAO.DeleteWorkout(obj); return(new HttpResponseMessage()); }
public void UpdateWorkoutcollection(workout_collection obj) { dAO.UpdateWorkout(obj); }
public void AddWorkoutcollection(workout_collection obj) { dAO.SaveWorkout(obj); }