private void CreateExercises(IEnumerable <RoutineExerciseRequest> sets)
{
if (!sets.Any(s => s.ExerciseId == null))
{
return;
}
var exercises = new List <Exercise>();
exercises.AddRange(trainingRepository.SearchUserExercises(CurrentUserId, DateTimeOffset.Now));
foreach (var set in sets.Where(s => s.ExerciseId == null && !string.IsNullOrWhiteSpace(s.ExerciseName)))
{
var exercise = exercises.FirstOrDefault(e => e.Name.Equals(set.ExerciseName, StringComparison.CurrentCultureIgnoreCase));
if (exercise != null)
{
set.ExerciseId = exercise.Id;
}
else
{
var newExercise = new ExerciseDetails
{
UserId = CurrentUserId,
Name = char.ToUpper(set.ExerciseName[0]) + set.ExerciseName.Substring(1).ToLower()
};
trainingRepository.CreateExercise(newExercise);
exercises.Add(newExercise);
set.ExerciseId = newExercise.Id;
}
}
}
private IEnumerable <Exercise> CreateExercises(IEnumerable <WorkoutSetRequest> sets)
{
var exerciseIds = sets.Where(s => s.ExerciseId.HasValue).Select(s => s.ExerciseId.Value);
var exercises = new List <Exercise>();
exercises.AddRange(trainingRepository.GetExercises(sets.Where(s => s.ExerciseId.HasValue).Select(s => s.ExerciseId.Value), CurrentUserId, DateTimeOffset.Now.AddMonths(-1)));
exercises.AddRange(trainingRepository.SearchUserExercises(CurrentUserId, DateTimeOffset.MinValue));
foreach (var set in sets.Where(s => s.ExerciseId == null && !string.IsNullOrWhiteSpace(s.ExerciseName)))
{
var exercise = exercises.FirstOrDefault(e => e.Name.Equals(set.ExerciseName, StringComparison.CurrentCultureIgnoreCase));
if (exercise != null)
{
set.ExerciseId = exercise.Id;
}
else
{
var newExercise = new ExerciseDetails
{
UserId = CurrentUserId,
Name = char.ToUpper(set.ExerciseName[0]) + set.ExerciseName.Substring(1).ToLower()
};
trainingRepository.CreateExercise(newExercise);
exercises.Add(newExercise);
set.ExerciseId = newExercise.Id;
}
}
return(exercises);
}
public ActionResult ChooseGoal()
{
TempData["msg"] = "";
// Establishing the connection wata database
// Connection by server name and database name
string mycon = ConfigurationManager.ConnectionStrings["FitnesspointDatabase"].ConnectionString;
String myquery = "Select * from exercisedetail";
SqlConnection con = new SqlConnection(mycon);
SqlCommand cmd = new SqlCommand(myquery, con);
//cmd.CommandText = myquery;
//cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
//da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
ExerciseDetails pd1 = new ExerciseDetails();
List <ExerciseDetails> productlist = new List <ExerciseDetails>();
// one bye one coulmn is being retrive
// storing into class object
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ExerciseDetails pd = new ExerciseDetails();
pd.Exerciseid = Convert.ToInt32(ds.Tables[0].Rows[i]["exerciseid"].ToString());
pd.Exercisetype = ds.Tables[0].Rows[i]["exercisetype"].ToString();
pd.Exercisefor = ds.Tables[0].Rows[i]["exercisefor"].ToString();
pd.Totalset = Convert.ToInt32(ds.Tables[0].Rows[i]["totalset"].ToString());;
pd.Rest = ds.Tables[0].Rows[i]["rest"].ToString();
pd.Focus = ds.Tables[0].Rows[i]["focus"].ToString();
pd.Equipement = ds.Tables[0].Rows[i]["equipement"].ToString();
pd.Time = ds.Tables[0].Rows[i]["time"].ToString();
pd.Exercisename = ds.Tables[0].Rows[i]["exercisename"].ToString();
// a list to receive the data from class object
productlist.Add(pd);
}
// stred all the data
// closing the connection
pd1.Productlist = productlist;
con.Close();
DataTable dt1 = new DataTable();
dt1 = (DataTable)Session["buyitems"];
if (dt1 != null)
{
ViewBag.cartnumber = dt1.Rows.Count.ToString();
}
else
{
ViewBag.cartnumber = "0";
}
// returning view of all rceords
return(View(pd1));
}
public static void InitializeDatabaseSeed(DataBaseContext database)
{
if (!database.TrainingDay.Any())
{
var TrainingDayList = new TrainingDay[]
{
new TrainingDay {
DateOfTraining = DateTime.Now
}
};
foreach (TrainingDay i in TrainingDayList)
{
database.TrainingDay.Add(i);
}
database.SaveChanges();
}
if (!database.ExercisePerTrainingDay.Any())
{
var ExercisePerTrainingDayList = new ExercisePerTrainingDay[] {
new ExercisePerTrainingDay {
Name = "Squat", TrainingDayId = 1
}
};
foreach (ExercisePerTrainingDay i in ExercisePerTrainingDayList)
{
database.ExercisePerTrainingDay.Add(i);
}
database.SaveChanges();
}
if (!database.ExerciseDetail.Any())
{
var ExerciseDetails = new ExerciseDetails[] {
new ExerciseDetails {
Weight = 20, Reps = 5, SetNumber = 1, ExercisePerTrainingDayId = 1
}
};
foreach (ExerciseDetails i in ExerciseDetails)
{
database.ExerciseDetail.Add(i);
}
database.SaveChanges();
}
else
{
//then give each exercise their details according to whether it is squat deadlift or bench
return;
}
}
public ExerciseDetailsResponse(ExerciseDetails exercise)
{
Id = exercise.Id;
Eccentric = exercise.Eccentric;
EccentricPause = exercise.EccentricPause;
Concetric = exercise.Concetric;
ConcetricPause = exercise.ConcetricPause;
Series = exercise.Series;
Repeats = exercise.Repeats;
}
public ServiceResponse <ExerciseDetailsResponse> Add(AddExerciseDetailsRequest exerciseRequest)
{
using (DiaryContext db = new DiaryContext())
{
var exerciseDetails = new ExerciseDetails
{
Eccentric = exerciseRequest.Eccentric,
EccentricPause = exerciseRequest.EccentricPause,
Concetric = exerciseRequest.Concetric,
ConcetricPause = exerciseRequest.ConcetricPause,
Repeats = exerciseRequest.Repeats,
Series = exerciseRequest.Series
};
ExerciseDetails _exercise = db.ExercisesDetails.Add(exerciseDetails);
db.SaveChanges();
return(new ServiceResponse <ExerciseDetailsResponse>(new ExerciseDetailsResponse(_exercise), HttpStatusCode.OK, "Exercise added succesfully!"));
}
}
public static Task <byte[]> DownloadSubmissionAsync(TMCContext context, ExerciseDetails exercise) => GetAsync <byte[]>(context, $"/core/exercises/{exercise.Id}/download");
public static Task <CoreExercise> GetExerciseInformationAsync(TMCContext context, ExerciseDetails exercise) => GetAsync <CoreExercise>(context, $"/core/exercises/{exercise.Id}");