// 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); }