public ExerciseDTO(Guid exerciseID, string name, Guid userID, ExerciseTypeDTO exerciseType)
{
ExerciseID = exerciseID;
Name = name;
UserID = userID;
ExerciseType = exerciseType;
}
public ExerciseDTO GetExerciseDTOByName(string exerciseName)
{
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("SELECT * FROM Exercises WHERE Name = @Name", connection);
cmd.Parameters.AddWithValue("@Name", exerciseName);
string path = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None).FilePath;
connection.Open();
ExerciseTypeDTO exerciseTypeDTO = ExerciseTypeDTO.Bodyweight;
string exerciseID = null;
Guid userID = Guid.Empty;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
exerciseTypeDTO = (ExerciseTypeDTO)Enum.Parse(typeof(ExerciseTypeDTO), reader["ExerciseType"].ToString());
exerciseID = reader["ExerciseID"].ToString();
userID = Guid.Parse(reader["UserID"].ToString());
}
ExerciseDTO exerciseDTO = new ExerciseDTO(Guid.Parse(exerciseID), exerciseName, userID, exerciseTypeDTO);
return(exerciseDTO);
}
}
}
private ExerciseTypeDTO MapExerciseType(ExerciseType model)
{
var modelDTO = new ExerciseTypeDTO
{
Id = model.Id,
Name = model.Name,
IsFavorite = model.IsFavorite,
ApplicationUser = model.ApplicationUser
};
return(modelDTO);
}
private ExerciseTypeListViewModel MapExerciseTypeDTO(ExerciseTypeDTO model)
{
var viewModel = new ExerciseTypeListViewModel
{
Id = model.Id,
Name = model.Name,
IsFavorite = model.IsFavorite,
ApplicationUser = model.ApplicationUser
};
return(viewModel);
}
public ExerciseDTO GetExerciseDTO(string exerciseID)
{
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("SELECT * FROM Exercises WHERE ExerciseID = @ExerciseID", connection);
cmd.Parameters.AddWithValue("@ExerciseID", exerciseID);
connection.Open();
ExerciseTypeDTO exerciseType = ExerciseTypeDTO.Bodyweight;
string name = null;
Guid userID = Guid.Empty;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
exerciseType = (ExerciseTypeDTO)Enum.Parse(typeof(ExerciseTypeDTO), reader["ExerciseType"].ToString());
name = reader["Name"].ToString();
userID = Guid.Parse(reader["UserID"].ToString());
}
ExerciseDTO exerciseDTO = new ExerciseDTO(Guid.Parse(exerciseID), name, userID, exerciseType);
return(exerciseDTO);
}
}
}
public List <ExerciseDTO> GetAllExerciseDTOs()
{
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
List <ExerciseDTO> exerciseDTOs = new List <ExerciseDTO>();
SqlCommand cmd = new SqlCommand("SELECT * FROM Exercises", connection);
connection.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Guid exerciseID = Guid.Parse(reader["ExerciseID"].ToString());
Guid userID = Guid.Parse(reader["UserID"].ToString());
ExerciseTypeDTO exerciseType = (ExerciseTypeDTO)Convert.ToInt32(reader["ExerciseType"]);
string name = reader["Name"].ToString();
ExerciseDTO exerciseDTO = new ExerciseDTO(exerciseID, name, userID, exerciseType);
exerciseDTOs.Add(exerciseDTO);
}
return(exerciseDTOs);
}
}
}
public ExerciseDTO(string name, Guid userID, ExerciseTypeDTO exerciseType)
{
Name = name;
UserID = userID;
ExerciseType = exerciseType;
}
