public static Guardian Get(int personID) { string dsn = ConfigurationManager.ConnectionStrings["RJLouEntities"].ToString(); string sql = @" SELECT g.Person_ID, Guardian_ID, First_Name, Last_Name, Date_Of_Birth, Gender, Email, Race, Relationship FROM Guardian g INNER JOIN Person p ON g.Person_ID = p.Person_ID WHERE g.Person_ID = @PersonID"; using (SqlConnection conn = new SqlConnection(dsn)) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("PersonID", personID); SqlDataReader read = cmd.ExecuteReader(); if (read.Read()) { Guardian result = new Guardian() { PersonID = Convert.ToInt32(read["Person_ID"]), FirstName = read["First_Name"].ToString(), LastName = read["Last_Name"].ToString(), DateOfBirth = Convert.ToDateTime(read["Date_Of_Birth"]), Gender = read["Gender"].ToString(), Race = read["Race"].ToString(), Email = read["Email"].ToString(), Relationship = read["Relationship"].ToString(), GuardianID = Convert.ToInt32(read["Guardian_ID"]) }; result.GetPhoneNumbers(); result.GetAddresses(); return result; } } return null; }
public static List<Guardian> GetGuardians() { string dsn = ConfigurationManager.ConnectionStrings["RJLouEntities"].ToString(); string sql = @" SELECT g.Person_ID, Guardian_ID, First_Name, Last_Name, Date_Of_Birth, Gender, Email, Race, Relationship FROM Guardian g INNER JOIN Person p ON g.Person_ID = p.Person_ID"; List<Guardian> results = new List<Guardian>(); using (SqlConnection conn = new SqlConnection(dsn)) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.CommandType = CommandType.Text; SqlDataReader read = cmd.ExecuteReader(); while (read.Read()) { Guardian newGuardian = new Guardian() { PersonID = Convert.ToInt32(read["Person_ID"]), FirstName = read["First_Name"].ToString(), LastName = read["Last_Name"].ToString(), DateOfBirth = Convert.ToDateTime(read["Date_Of_Birth"]), Gender = read["Gender"].ToString(), Race = read["Race"].ToString(), Email = read["Email"].ToString(), Relationship = read["Relationship"].ToString(), GuardianID = Convert.ToInt32(read["Guardian_ID"]) }; newGuardian.GetPhoneNumbers(); newGuardian.GetAddresses(); results.Add(newGuardian); } } return results; }