public static Victim Get(int personID)
{
string dsn = ConfigurationManager.ConnectionStrings["RJLouEntities"].ToString();
string sql = @"
SELECT v.Person_ID,
First_Name,
Last_Name,
Date_Of_Birth,
Gender,
Email,
Race
FROM Victim v
INNER JOIN Person p ON v.Person_ID = p.Person_ID
WHERE v.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())
{
Victim result = new Victim()
{
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(),
Email = read["Email"].ToString(),
Race = read["Race"].ToString()
};
result.GetPhoneNumbers();
result.GetAddresses();
result.GetGuardians();
return result;
}
}
return null;
}
public static List<Victim> GetVictims()
{
string dsn = ConfigurationManager.ConnectionStrings["RJLouEntities"].ToString();
string sql = @"
SELECT v.Person_ID,
First_Name,
Last_Name,
Date_Of_Birth,
Gender,
Email,
Race
FROM Victim v
INNER JOIN Person p ON v.Person_ID = p.Person_ID";
List<Victim> results = new List<Victim>();
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())
{
Victim newVictim = new Victim()
{
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(),
Email = read["Email"].ToString(),
Race = read["Race"].ToString()
};
newVictim.GetPhoneNumbers();
newVictim.GetAddresses();
newVictim.GetGuardians();
results.Add(newVictim);
}
}
return results;
}