public IProfileTypeDto GetProfileTypeById(int id)
{
SqlConnection conn = webShopContext.GetConnection();
IProfileTypeDto profileType = null;
try
{
conn.Open();
string sql = "SELECT profile_type_id, profile_type_name FROM profiletype WHERE profile_type_id = @id;";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
profileType = new ProfileTypeDto()
{
ProfileTypeID = rdr.GetInt32(0),
ProfileTypeName = rdr.GetString(1),
};
}
rdr.Close();
}
catch (Exception e)
{
throw e;
}
conn.Close();
return(profileType);
}
private IProfileType ProfileTypeDtoToProfileType(IProfileTypeDto profileTypeDto)
{
return(new ProfileType()
{
ProfileTypeID = profileTypeDto.ProfileTypeID,
ProfileTypeName = profileTypeDto.ProfileTypeName,
});
}
