public void generateUserWorkout()
{
try
{
/* List<int> userIDList = dbConfig.getUserIDs();
* int randomIndex = rnd.Next(userIDList.Count);
* int randomUserID = userIDList[randomIndex];
*
* List<int> workoutIDList = dbConfig.getWorkoutIDs();
* randomIndex = rnd.Next(workoutIDList.Count);
* int randomWorkoutID = workoutIDList[randomIndex]; random seçilme senaryosu şimdilik yorum*/
generateUser();
generateWorkout();
List <int> workoutList = dbConfig.getWorkoutIDs();
int workoutID = workoutList.Max();
List <int> userList = dbConfig.getUserIDs();
int userID = userList.Max();
Console.WriteLine("User Id:" + userID + "\nWorkout Id:" + workoutID);
TimeSpan start = TimeSpan.FromHours(9);
TimeSpan end = TimeSpan.FromHours(22);
int maxMinutes = (int)((end - start).TotalMinutes);
int minutes = rnd.Next(maxMinutes);
TimeSpan workoutStartTime = start.Add(TimeSpan.FromMinutes(minutes));
String randomStartDate = beginningDay + " " + workoutStartTime.ToString();
Console.WriteLine("Start Date: " + randomStartDate + "\n");
UserWorkout userWorkout = new UserWorkout();
userWorkout.workoutID = workoutID;
userWorkout.userID = userID;
userWorkout.startDate = randomStartDate;
userWorkout.startTime = workoutStartTime;
dbConfig.connectToDB();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbConfig.con;
string query = "INSERT INTO USERWORKOUTS (user,workout,start_date) VALUES ("
+ userWorkout.userID.ToString() + "," + userWorkout.workoutID.ToString()
+ ",'" + userWorkout.startDate + "');";
cmd.CommandText = query;
cmd.ExecuteNonQuery();
dbConfig.breakConnection();
generateWorkoutExercises(userWorkout);
}
catch (NullReferenceException)
{
Console.WriteLine("Null Reference Exception occured.");
}
}
public void generateWorkoutExercises(UserWorkout userWorkout)
{
List <int> exerciseIDList = dbConfig.getExerciseIDs();
TimeSpan time = userWorkout.startTime;
int order = 1;
dbConfig.connectToDB();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = dbConfig.con;
for (int i = 0; i < 5; i++)
{
int randomIndex = rnd.Next(exerciseIDList.Count);
int randomExerciseID = exerciseIDList[randomIndex];
WorkoutExercise workoutExercise = new WorkoutExercise();
workoutExercise.exerciseID = randomExerciseID;
workoutExercise.workoutID = userWorkout.workoutID;
workoutExercise.startDate = beginningDay + " " + time.ToString();
workoutExercise.startTime = time;
workoutExercise.endTime = time
+ calculateExerciseTime(WorkoutExercise.setNumber, WorkoutExercise.setTime);
workoutExercise.endDate = beginningDay + " " + workoutExercise.endTime.ToString();
workoutExercise.exerciseOrder = order;
order++;
exerciseIDList.Remove(randomExerciseID);
time = workoutExercise.endTime + WorkoutExercise.restTime;
string query = "INSERT INTO WORKOUTEXERCISES" + " (workout,exercise,exercise_order,"
+ "set_number,set_time,"
+ "start_date,end_date) VALUES ("
+ workoutExercise.workoutID + "," + workoutExercise.exerciseID + "," + workoutExercise.exerciseOrder
+ "," + WorkoutExercise.setNumber + "," + WorkoutExercise.setTimeSeconds + ",'" + workoutExercise.startDate
+ "','" + workoutExercise.endDate + "');";
cmd.CommandText = query;
cmd.ExecuteNonQuery();
}
dbConfig.breakConnection();
}
