public static List <BloodBank> GetAll()
{
List <BloodBank> allBloodBanks = new List <BloodBank> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM blood_banks;";
var rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int bloodbankId = rdr.GetInt32(0);
string bloodbankName = rdr.GetString(1);
string bloodbankAddress = rdr.GetString(2);
string bloodbankContact = rdr.GetString(3);
BloodBank newBloodBank = new BloodBank(bloodbankName, bloodbankAddress, bloodbankContact, bloodbankId);
allBloodBanks.Add(newBloodBank);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allBloodBanks);
}
public void AddBloodBank(BloodBank newBloodBank)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"INSERT INTO donors_bloodbanks (bloodBank_id, donor_id) VALUES (@BloodBankId, @DonorId);";
MySqlParameter bloodBank_id = new MySqlParameter();
bloodBank_id.ParameterName = "@BloodBankId";
bloodBank_id.Value = newBloodBank.GetId();
cmd.Parameters.Add(bloodBank_id);
MySqlParameter donor_id = new MySqlParameter();
donor_id.ParameterName = "@DonorId";
donor_id.Value = _id;
cmd.Parameters.Add(donor_id);
cmd.ExecuteNonQuery();
conn.Close();
if (conn != null)
{
conn.Dispose();
}
}
public override bool Equals(System.Object otherBloodBank)
{
if (!(otherBloodBank is BloodBank))
{
return(false);
}
else
{
BloodBank newBloodBank = (BloodBank)otherBloodBank;
bool idEquality = this.GetId() == newBloodBank.GetId();
bool nameEquality = this.GetName() == newBloodBank.GetName();
bool contactEquality = this.GetContact() == newBloodBank.GetContact();
bool addressEquality = this.GetAddress() == newBloodBank.GetAddress();
return(idEquality && nameEquality && contactEquality && addressEquality);
}
}
public static BloodBank Find(int id)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM blood_banks WHERE id = (@searchId);";
MySqlParameter searchId = new MySqlParameter();
searchId.ParameterName = "@searchId";
searchId.Value = id;
cmd.Parameters.Add(searchId);
var rdr = cmd.ExecuteReader() as MySqlDataReader;
int bloodbankId = 0;
string bloodbankName = "";
string bloodbankContact = "";
string bloodbankAddress = "";
while (rdr.Read())
{
bloodbankId = rdr.GetInt32(0);
bloodbankName = rdr.GetString(1);
bloodbankAddress = rdr.GetString(2);
bloodbankContact = rdr.GetString(3);
}
BloodBank newBloodBank = new BloodBank(bloodbankName, bloodbankAddress, bloodbankContact, bloodbankId);
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(newBloodBank);
}
public List <BloodBank> GetBloodBanks()
{
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT blood_banks.* FROM donors
JOIN donors_bloodBanks ON (donors.id = donors_bloodBanks.donor_id)
JOIN blood_banks ON (donors_bloodBanks.bloodBank_id = blood_banks.id)
WHERE donors.id = @DonorId;";
MySqlParameter donorIdParameter = new MySqlParameter();
donorIdParameter.ParameterName = "@DonorId";
donorIdParameter.Value = _id;
cmd.Parameters.Add(donorIdParameter);
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
List <BloodBank> bloodBanks = new List <BloodBank> {
};
while (rdr.Read())
{
int bloodBankId = rdr.GetInt32(0);
string bloodBankName = rdr.GetString(1);
string bloodBankAddress = rdr.GetString(3);
string bloodBankContact = rdr.GetString(2);
BloodBank newBloodBank = new BloodBank(bloodBankName, bloodBankAddress, bloodBankContact, bloodBankId);
bloodBanks.Add(newBloodBank);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(bloodBanks);
}
