// Return Stroke Object of specific ID
public WorkoutStroke getStrokes(int strokeId)
{
WorkoutStroke stroke;
try
{
string connString = ConfigurationManager.ConnectionStrings["SwimDBConnectionString"].ConnectionString;
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SwimDBConnectionString"].ConnectionString);
conn.Open();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "getStroke";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", strokeId);
reader = cmd.ExecuteReader();
if (reader.Read())
{
stroke = new WorkoutStroke(int.Parse(reader["id"].ToString()), reader["Name"].ToString(), reader["Description"].ToString());
}
else
{
throw new DataException("multiple rows returned from query");
}
conn.Close();
return(stroke);
}
catch (Exception e)
{
return(null);
}
}
}//end of getWorkOutPlanIds method
public WorkoutPlan getWorkOutPlan(int id)
{
WorkoutPlan workoutplan = new WorkoutPlan();
List <WorkoutSet> listOfSets = new List <WorkoutSet>();
try{
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SwimDBConnectionString"].ConnectionString);
conn.Open();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "getworkoutplan";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@workoutplanID", id);
reader = cmd.ExecuteReader();
workoutplan.ID = id;
while (reader.Read())
{
if (workoutplan.Date == null || workoutplan.Date == "")
{
workoutplan.Date = reader["planDate"].ToString();
}
WorkoutSet WOSet = new WorkoutSet();
WorkoutStroke stroke = new WorkoutStroke();
WOSet.ID = Convert.ToInt32(reader["Set_Id"]);
stroke.ID = Convert.ToInt32(reader["Stroke_Id"]);
stroke.Name = reader["Name"].ToString();
stroke.Description = reader["Stroke_Desc"].ToString();
//listOfValues.Add("Member_Id", reader["Member_Id"].ToString());
WOSet.OrderNum = Convert.ToInt32(reader["memberOrder"]);
// listOfValues.Add("planDate",reader["planDate"].ToString());
WOSet.Repeats = Convert.ToInt32(reader["repeats"]);
WOSet.WorkoutSetDistance = Convert.ToInt32(reader["distance"]);
WOSet.Description = reader["Set_Desc"].ToString();
WOSet.PaceTime = Convert.ToInt32(reader["paceTime"]);
WOSet.RestPeriod = Convert.ToInt32(reader["restPeriod"]);
WOSet.Stroke = stroke;
WOSet.E1 = Convert.ToInt32(reader["E1"]);
WOSet.E2 = Convert.ToInt32(reader["E2"]);
WOSet.E3 = Convert.ToInt32(reader["E3"]);
WOSet.S1 = Convert.ToInt32(reader["S1"]);
WOSet.S2 = Convert.ToInt32(reader["S2"]);
WOSet.S3 = Convert.ToInt32(reader["S3"]);
WOSet.REC = Convert.ToInt32(reader["REC"]);
WOSet.SingleDuration = Convert.ToInt32(reader["duration"]);
listOfSets.Add(WOSet);
}
workoutplan.WorkoutSet = listOfSets;
conn.Close();
}
catch (Exception)
{
// List<string> listOfValues = new List<string>();
// listOfValues.Add("Error");
// listOfSets.Add();
return(null);
}
return(workoutplan);
}
