private void AddWorkoutToListButton_Click(object sender, EventArgs e)
{
if (ValidateForm())
{
PlannedTrainingModel plannedTrainingModel = new PlannedTrainingModel((TrainingModel)selectWorkoutDropDown.SelectedItem, workoutDateTimePicker.Value);
plannedWorkouts.Add(plannedTrainingModel);
WireUpList();
}
}
private void LoadPlannedWorkoutButton_Click(object sender, EventArgs e)
{
if ((PlannedTrainingModel)plannedWorkoutListBox.SelectedItem != null)
{
PlannedTrainingModel plannedTraining = (PlannedTrainingModel)plannedWorkoutListBox.SelectedItem;
LoadViewerForm(plannedTraining.Training);
}
else
{
MessageBox.Show("Select planned workout.");
}
}
public List <PlannedTrainingModel> GetPlannedTrainings_All()
{
List <PlannedTrainingModel> output = new List <PlannedTrainingModel>();
List <TrainingModel> trainings = GetTraining_All();
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(db)))
{
foreach (TrainingModel training in trainings)
{
DateTime[] dates;
DateTime[] times;
int[] ids;
var p = new DynamicParameters();
p.Add("@TrainingId", training.Id);
dates = connection.Query <DateTime>("dbo.spPlannedTrainingsDate_GetByTraining", p, commandType: CommandType.StoredProcedure).ToArray();
times = connection.Query <DateTime>("dbo.spPlannedTrainingsTime_GetByTraining", p, commandType: CommandType.StoredProcedure).ToArray();
ids = connection.Query <int>("dbo.spPlannedTrainingsId_GetByTraining", p, commandType: CommandType.StoredProcedure).ToArray();
if (dates.Length > 0 && times.Length > 0)
{
for (int i = 0; i < dates.Length; i++)
{
PlannedTrainingModel plannedTraining = new PlannedTrainingModel();
DateTime dateTime = new DateTime(dates[i].Year, dates[i].Month, dates[i].Day, times[i].Hour, times[i].Minute, 0);
plannedTraining.Id = ids[i];
plannedTraining.Training = training;
plannedTraining.TrainingDateAndTime = dateTime;
output.Add(plannedTraining);
}
}
}
}
return(output);
}
public static List <PlannedTrainingModel> ConvertToPlannedTrainingModel(this List <string> lines)
{
List <PlannedTrainingModel> output = new List <PlannedTrainingModel>();
List <TrainingModel> trainings = GlobalConfig.TrainingFile.FullFilePath().LoadFile().ConvertToTrainingModel();
foreach (string line in lines)
{
string[] cols = line.Split(',');
PlannedTrainingModel plannedTraining = new PlannedTrainingModel();
plannedTraining.Training = trainings.Find(x => x.Id == int.Parse(cols[0]));
string[] dateAndTime = cols[1].Split('|');
DateTime dateTime = new DateTime(int.Parse(dateAndTime[0]), int.Parse(dateAndTime[1]), int.Parse(dateAndTime[2]), int.Parse(dateAndTime[3]), int.Parse(dateAndTime[4]), 0);
plannedTraining.TrainingDateAndTime = dateTime;
output.Add(plannedTraining);
}
return(output);
}
