protected internal void BindData(Victim thisPerson) { PhoneNumbersRepeater.DataSource = thisPerson.PhoneNumbers; PhoneNumbersRepeater.DataBind(); AddressesRepeater.DataSource = thisPerson.Addresses; AddressesRepeater.DataBind(); GuardiansRepeater.DataSource = thisPerson.Guardians; GuardiansRepeater.DataBind(); CasesRepeater.DataSource = thisPerson.GetCases(); CasesRepeater.DataBind(); }
protected internal void LoadHeader(Victim thisPerson) { HeaderRelationship.Visible = false; 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(); MainContainer.Visible = true; GuardiansPanel.Visible = true; }
internal void DeleteVictim(Victim victim) { string sql = @" DELETE FROM Case_File WHERE Case_ID = @CaseID AND Person_ID = @PersonID"; using (SqlConnection conn = new SqlConnection(Constants.DSN)) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("CaseID", CaseID); cmd.Parameters.AddWithValue("PersonID", victim.PersonID); cmd.ExecuteNonQuery(); } }
internal void AddVictim(Victim victim) { string sql = @" INSERT INTO Case_File (Case_ID, Person_ID) VALUES (@CaseID, @PersonID)"; using (SqlConnection conn = new SqlConnection(Constants.DSN)) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("CaseID", CaseID); cmd.Parameters.AddWithValue("PersonID", victim.PersonID); cmd.ExecuteNonQuery(); } }
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; }