protected internal void BindData(Guardian thisPerson)
{
PhoneNumbersRepeater.DataSource = thisPerson.PhoneNumbers;
PhoneNumbersRepeater.DataBind();
AddressesRepeater.DataSource = thisPerson.Addresses;
AddressesRepeater.DataBind();
CasesRepeater.DataSource = thisPerson.GetCases();
CasesRepeater.DataBind();
}
protected internal void LoadHeader(Guardian thisPerson)
{
HeaderRelationship.Visible = true;
HeaderPassword.Visible = false;
HeaderUserType.Visible = false;
HeaderOffenderNumber.Visible = false;
PersonID.Text = thisPerson.PersonID.ToString();
FirstName.Text = thisPerson.FirstName.ToString();
LastName.Text = thisPerson.LastName.ToString();
DateOfBirth.Text = (thisPerson.DateOfBirth == default(DateTime) ? "" : thisPerson.DateOfBirth.ToString("MM/dd/yyyy"));
Gender.Text = thisPerson.Gender.ToString();
Email.Text = thisPerson.Email.ToString();
Race.Text = thisPerson.Race.ToString();
Relationship.Text = thisPerson.Relationship;
MainContainer.Visible = true;
GuardiansRepeater.Visible = false;
}
internal void DeleteGuardian(Guardian oldGuardian)
{
string sql = "DELETE FROM Guardian_List WHERE Person_ID = @PersonID AND Guardian_ID = @GuardianID";
using (SqlConnection conn = new SqlConnection(Constants.DSN))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("PersonID", PersonID);
cmd.Parameters.AddWithValue("GuardianID", oldGuardian.GuardianID);
cmd.ExecuteNonQuery();
}
}
internal void AddGuardian(Guardian newGuardian)
{
string sql = "INSERT INTO Guardian_List (Person_ID, Guardian_ID) VALUES (@PersonID, @GuardianID)";
using (SqlConnection conn = new SqlConnection(Constants.DSN))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("PersonID", PersonID);
cmd.Parameters.AddWithValue("GuardianID", newGuardian.GuardianID);
cmd.ExecuteNonQuery();
}
}
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;
}
