public TelefonModel GetHomeTelefon(int personId) { SqlDataReader rdr = null; TelefonModel phone; try { // Open connection conn.Open(); string cmdString = "select * from TelefonNr where (PersonId = #personId) AND (Type = 'Hjem')"; // Instantiate a new command SqlCommand cmd = new SqlCommand(cmdString.Replace("#personId", personId.ToString()), conn); // Send command rdr = cmd.ExecuteReader(); rdr.Read(); phone = new TelefonModel( Convert.ToInt32(rdr["TelefonId"]), rdr["Type"].ToString(), rdr["Nummer"].ToString(), Convert.ToInt32(rdr["PersonId"])); } finally { // Close connection rdr?.Close(); conn?.Close(); } return(phone); }
public List <TelefonModel> GetTelefons(int personId) { SqlDataReader rdr = null; List <TelefonModel> list = new List <TelefonModel>(); try { // Open connection conn.Open(); string cmdString = "select * from TelefonNr where (PersonId = #personId)"; // Instantiate a new command SqlCommand cmd = new SqlCommand(cmdString.Replace("#personId", personId.ToString()), conn); // Send command rdr = cmd.ExecuteReader(); while (rdr.Read()) { TelefonModel phone = new TelefonModel( Convert.ToInt32(rdr["TelefonId"]), rdr["Type"].ToString(), rdr["Nummer"].ToString(), Convert.ToInt32(rdr["PersonId"])); list.Add(phone); } } finally { // Close connection rdr?.Close(); conn?.Close(); } return(list); }