public bool Add(WorkoutLogDetailDTO entity) { WorkoutLog workoutLog = new WorkoutLog(); workoutLog.MemberID = (int)entity.MemberID; workoutLog.WorkoutID = (int)entity.WorkoutID; workoutLog.EditTime = entity.EditTime; //workoutLog.Workout.Name = entity.WorkoutName; workoutLog.WorkoutHours = entity.WorkoutHours; return(dao.Add(workoutLog)); }
public void UpDate(WorkoutLogDetailDTO entity) { WorkoutLog workoutLog = new WorkoutLog(); workoutLog.ID = entity.ID; workoutLog.MemberID = (int)entity.MemberID; workoutLog.WorkoutID = (int)entity.WorkoutID; workoutLog.EditTime = entity.EditTime; //workoutLog.Workout.Name = entity.WorkoutName; workoutLog.WorkoutHours = entity.WorkoutHours; dao.Update(workoutLog); }
internal List <WorkoutLogDetailDTO> GetWorkoutLogs(DateTime starttime, DateTime end) { List <WorkoutLog> workoutLogs = db.WorkoutLogs.Where(x => x.EditTime >= starttime && x.EditTime <= end).ToList(); List <WorkoutLogDetailDTO> logDTOlist = new List <WorkoutLogDetailDTO>(); foreach (var item in workoutLogs) { WorkoutLogDetailDTO dto = new WorkoutLogDetailDTO(); dto.MemberID = item.MemberID; dto.MemberName = item.Member.Name; dto.WorkoutName = item.Workout.Name; dto.WorkoutHours = item.WorkoutHours; dto.Calories = Math.Round(item.Workout.Calories * item.WorkoutHours, 2); logDTOlist.Add(dto); } return(logDTOlist); }
internal List <WorkoutLogDetailDTO> GetWorkoutLogs() { List <WorkoutLog> workoutLogs = db.WorkoutLogs.ToList(); List <WorkoutLogDetailDTO> logDTOlist = new List <WorkoutLogDetailDTO>(); foreach (var item in workoutLogs) { WorkoutLogDetailDTO dto = new WorkoutLogDetailDTO(); dto.ID = item.ID; dto.MemberID = item.MemberID; dto.MemberName = item.Member.Name; dto.WorkoutID = item.WorkoutID; dto.WorkoutName = item.Workout.Name; dto.WorkoutHours = item.WorkoutHours; dto.Calories = Math.Round(item.Workout.Calories * item.WorkoutHours, 2); dto.EditTime = item.EditTime; logDTOlist.Add(dto); } return(logDTOlist); }
internal List <WorkoutLogDetailDTO> GetWorkoutLogs(string keyword) { List <WorkoutLog> workoutLogs = db.WorkoutLogs.Where(x => x.Workout.Name.Contains(keyword) || x.Member.Name.Contains(keyword) || x.ID.ToString().Contains(keyword) || x.MemberID.ToString().Contains(keyword) || x.WorkoutID.ToString().Contains(keyword) || x.EditTime.ToString().Contains(keyword) ).ToList(); List <WorkoutLogDetailDTO> logDTOlist = new List <WorkoutLogDetailDTO>(); foreach (var item in workoutLogs) { WorkoutLogDetailDTO dto = new WorkoutLogDetailDTO(); dto.ID = item.ID; dto.MemberID = item.MemberID; dto.MemberName = item.Member.Name; dto.WorkoutName = item.Workout.Name; dto.WorkoutHours = item.WorkoutHours; dto.Calories = Math.Round(item.Workout.Calories * item.WorkoutHours, 2); logDTOlist.Add(dto); } return(logDTOlist); }