public Training GetTraining(int IdTraining) { ExerciseDAL exerciseDAL = new ExerciseDAL(configuration); Training result = new Training(); string TrainingQuery = "SELECT * FROM [dbo].[Treningi] WHERE ID_Treningi = @ParamID"; try { using (SqlConnection con = new SqlConnection(_connectionString)) { con.Open(); SqlCommand cmd = new SqlCommand(TrainingQuery, con); cmd.Parameters.AddWithValue("@ParamID", IdTraining); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { result.Id = Convert.ToInt32(rdr[0]); result.Duration = Convert.ToInt32(rdr[1]); result.Name = rdr[2].ToString(); result.Exercises = exerciseDAL.GetTrainingExercises(IdTraining); } } } catch (Exception ex) { throw ex; } return(result); }
public List <Training> GetList() { ExerciseDAL exerciseDAL = new ExerciseDAL(configuration); var listTraining = new List <Training>(); string trainingQuery = "SELECT * FROM [dbo].[Treningi]"; try { using (SqlConnection con = new SqlConnection(_connectionString)) { SqlCommand cmd = new SqlCommand(trainingQuery, con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { listTraining.Add(new Training { Id = Convert.ToInt32(rdr[0]), Exercises = exerciseDAL.GetTrainingExercises(Convert.ToInt32(rdr[0])), Duration = Convert.ToInt32(rdr[1]), Name = rdr[2].ToString() }); } } } catch (Exception ex) { throw ex; } return(listTraining); }