public AdresseModel GetHomeAdresse(int addressId)
{
SqlDataReader sqlDataReader = null;
AdresseModel adresseModel = null;
try
{
string command = "select * from Adresse where AdresseId = #adresseId";
SqlCommand cmd = new SqlCommand(command.Replace("#adresseId", addressId.ToString()), conn);
conn.Open();
sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
adresseModel = new AdresseModel(
Convert.ToInt32(sqlDataReader["AdresseId"]),
sqlDataReader["Vejnavn"].ToString(),
Convert.ToInt32(sqlDataReader["HusNr"]),
Convert.ToInt32(sqlDataReader["PostNr"]),
sqlDataReader["Bynavn"].ToString(),
sqlDataReader["Type"].ToString());
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
if (conn != null)
{
conn.Close();
}
}
return(adresseModel);
}
public List <AdresseModel> GetAllAdressesForPerson(int personId)
{
SqlDataReader rdr = null;
List <AdresseModel> list = new List <AdresseModel>();
SqlConnection secondConn = new SqlConnection(conn.ConnectionString); //nød til at have en ekstra, da conn bliver åbnet i getHomeAdress
try
{
string cmdString = "select * from HarAdresse where (PersonId = #personId)";
cmdString = cmdString.Replace("#personId", personId.ToString());
SqlCommand cmd = new SqlCommand(cmdString, secondConn);
secondConn.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
AdresseModel adresse = GetHomeAdresse(Convert.ToInt32(rdr["AdresseId"]));
list.Add(adresse);
}
}
finally
{
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
if (secondConn != null)
{
secondConn.Close();
}
}
return(list);
}
public List <AdresseModel> GetAdresses()
{
SqlDataReader sqlDataReader = null;
List <AdresseModel> list = new List <AdresseModel>();
try
{
SqlCommand cmd = new SqlCommand("select * from Adresse", conn);
conn.Open();
sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
AdresseModel adresse = new AdresseModel(
Convert.ToInt32(sqlDataReader["AdresseId"]),
sqlDataReader["Vejnavn"].ToString(),
Convert.ToInt32(sqlDataReader["HusNr"]),
Convert.ToInt32(sqlDataReader["PostNr"]),
sqlDataReader["Bynavn"].ToString(),
sqlDataReader["Type"].ToString());
list.Add(adresse);
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
if (conn != null)
{
conn.Close();
}
}
return(list);
}