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