public void addingExercise(exerciseDAO addExercise) { try { //create a connection to a database using our connection string variable using (SqlConnection _connection = new SqlConnection(connectionStrings)) { using (SqlCommand _command = new SqlCommand("sp_addExercise", _connection)) { // specify whay type of command is to be used _command.CommandType = CommandType.StoredProcedure; //where the values are sent to the command _command.Parameters.AddWithValue("@exerciseName", addExercise.exerciseName); _command.Parameters.AddWithValue("@exerciseDescription", addExercise.exerciseDescription); _command.Parameters.AddWithValue("@FK_bodyPart", addExercise.FK_bodyPart); // this is where the connection is open _connection.Open(); // this is where we will execute the command _command.ExecuteNonQuery(); } } } catch (Exception _error) { // putting error into a file _logger.logError(_error); } }
// mapping data back to exercise DAO public exerciseModel map(exerciseDAO _exerciseMod) { // making new instance of exercise model exerciseModel _exerciseRetMod = new exerciseModel(); _exerciseRetMod.exerciseID = _exerciseMod.exerciseID; _exerciseRetMod.exerciseName = _exerciseMod.exerciseName; _exerciseRetMod.exerciseDescription = _exerciseMod.exerciseDescription; _exerciseRetMod.FK_bodyPart = _exerciseMod.FK_bodyPart; return(_exerciseRetMod); }
public List <exerciseDAO> bodyPartExercise(int FK_bodyPart) { // making a new instance of the list List <exerciseDAO> _exerciseList = new List <exerciseDAO>(); try { using (SqlConnection _connection = new SqlConnection(connectionStrings)) { using (SqlCommand _command = new SqlCommand("sp_viewExercise", _connection)) { // specify what type of command is to be used _command.CommandType = CommandType.StoredProcedure; //where the values are sent to the command _command.Parameters.AddWithValue("@FK_bodyPart", FK_bodyPart); _connection.Open(); using (SqlDataReader _reader = _command.ExecuteReader()) { // checking if the _reader has rows if (_reader.HasRows) { // loop to go through the columns while (_reader.Read()) { // new instance of to store all the values into persontolist. exerciseDAO exerciseToList = new exerciseDAO(); exerciseToList.exerciseID = _reader.GetInt32(_reader.GetOrdinal("exerciseID")); exerciseToList.exerciseName = (string)_reader["exerciseName"]; exerciseToList.exerciseDescription = (string)_reader["exerciseDescription"]; // adding values to varibale _personList.add _exerciseList.Add(exerciseToList); } } else { // showing error if no data found Console.WriteLine("No data found"); } } } } } catch (Exception _error) { _logger.logError(_error); } // returning exercise list return(_exerciseList); }