public static List <Donor> Find(string bloodType) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM donors WHERE bloodType = (@searchBloodType);"; MySqlParameter searchBloodType = new MySqlParameter(); searchBloodType.ParameterName = "@searchBloodType"; searchBloodType.Value = bloodType; cmd.Parameters.Add(searchBloodType); var rdr = cmd.ExecuteReader() as MySqlDataReader; int donorId = 0; string donorName = ""; string donorContact = ""; string donorDateOfBirth = ""; string donorBloodType = ""; string donorMedicalRecord = ""; List <Donor> donors = new List <Donor> { }; while (rdr.Read()) { donorId = rdr.GetInt32(0); donorName = rdr.GetString(1); donorContact = rdr.GetString(2); donorDateOfBirth = rdr.GetString(3); donorBloodType = rdr.GetString(4); donorMedicalRecord = rdr.GetString(5); Donor newDonor = new Donor(donorName, donorContact, donorDateOfBirth, donorBloodType, donorMedicalRecord, donorId); donors.Add(newDonor); } conn.Close(); if (conn != null) { conn.Dispose(); } return(donors); }
public override bool Equals(System.Object otherDonor) { if (!(otherDonor is Donor)) { return(false); } else { Donor newDonor = (Donor)otherDonor; bool idEquality = this.GetId() == newDonor.GetId(); bool nameEquality = this.GetName() == newDonor.GetName(); bool contactEquality = this.GetContact() == newDonor.GetContact(); bool dateOfBirthEquality = this.GetDateOfBirth() == newDonor.GetDateOfBirth(); bool bloodTypeEquality = this.GetBloodType() == newDonor.GetBloodType(); bool medicalRecordEquality = this.GetMedicalRecord() == newDonor.GetMedicalRecord(); return(idEquality && nameEquality && contactEquality && dateOfBirthEquality && bloodTypeEquality && medicalRecordEquality); } }
public List <Donor> GetDonors() { MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT donors.* FROM blood_banks JOIN donors_bloodBanks ON (blood_banks.id = donors_bloodBanks.bloodBank_id) JOIN donors ON (donors_bloodBanks.donor_id = donors.id) WHERE blood_banks.id = @BloodBankId;"; MySqlParameter bloodBankIdParameter = new MySqlParameter(); bloodBankIdParameter.ParameterName = "@BloodBankId"; bloodBankIdParameter.Value = _id; cmd.Parameters.Add(bloodBankIdParameter); MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; List <Donor> donors = new List <Donor> { }; while (rdr.Read()) { int donorId = rdr.GetInt32(0); string donorName = rdr.GetString(1); string donorContact = rdr.GetString(2); string donorDateOfBirth = rdr.GetString(3); string donorBloodType = rdr.GetString(4); string donorMedicalRecord = rdr.GetString(5); Donor newDonor = new Donor(donorName, donorContact, donorDateOfBirth, donorBloodType, donorMedicalRecord, donorId); donors.Add(newDonor); } conn.Close(); if (conn != null) { conn.Dispose(); } return(donors); }