private ExerciseModel ParseExerciseFromReader(SqlDataReader reader)
{
ExerciseModel exercise = new ExerciseModel();
exercise.Summary = (String)reader["EX_SUMMARY"];
exercise.Name = (String)reader["EX_NAME"];
exercise.Description = (String)reader["EX_DESCRIPTION"];
exercise.ExerciseId = (int)reader["EX_ID"];
exercise.DataSourceId = (int)reader["DS_ID"];
exercise.Published = DAHelpers.BooleanFromReader(reader, "EX_PUBLISHED");
exercise.PublishedDate = DAHelpers.DateTimeFromReader(reader, "EX_PUBLISHED_DATE");
exercise.SectionName = (String)reader["EX_SECTION_NAME"];
exercise.Order = (int)reader["EX_ORDER"];
exercise.ShowQueryBuilder = DAHelpers.BooleanFromReader(reader, "EX_SHOW_QUERY_BUILDER");
exercise.ExerciseIdGuid = (Guid)reader["EX_ID_GUID"];
exercise.CreatedDate = DAHelpers.DateTimeFromReader(reader, "EX_CREATED_DATE");
exercise.CreatedBy = DAHelpers.StringFromReader(reader, "EX_CREATED_BY");
exercise.UpdatedDate = DAHelpers.NullableDateTimeFromReader(reader, "EX_UPDATED_DATE");
exercise.UpdatedBy = DAHelpers.NullableStringFromReader(reader, "EX_UPDATED_BY");
return(exercise);
}
public UserModel GetUser(UserModel user, Boolean checkPassword = true)
{
// Check that the user model has been populated
if (String.IsNullOrEmpty(user.Email) || (String.IsNullOrEmpty(user.HashedPassword) && checkPassword))
{
throw new Exception("Email or Hashed Password not provided to DA.GetUser");
}
String query = "select * from users where us_email_address = @EmailAddress";
if (checkPassword)
{
query += " and us_password = @Password";
}
try
{
using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.DatabaseConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(query, conn))
{
command.Parameters.AddWithValue("EmailAddress", user.Email);
command.Parameters.AddWithValue("Password", user.HashedPassword);
SqlDataReader reader = command.ExecuteReader();
reader.Read();
user.UserId = (int)reader["US_ID"];
user.FirstName = (String)reader["US_FIRST_NAME"];
user.LastName = (String)reader["US_LAST_NAME"];
user.IsAdmin = DAHelpers.BooleanFromReader(reader, "US_ADMIN_ACCESS");
}
}
}
catch (Exception ex)
{
throw new Exception(String.Format("Error getting user {0} - {1}", user.Email, ex.Message));
}
return(user);
}