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; }