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