public List <ShelterInfo> getShelterInformationByRestrictions(string genderOrAgeRange)
{
try {
List <ShelterInfo> shelterInformation = new List <ShelterInfo>();
ShelterInfo subList = new ShelterInfo();
using (SqlConnection conn = new SqlConnection(
"Data Source=tcp:shelterme.database.windows.net,1433;Initial Catalog=ShelterMe;User ID=Harsh_Jain;Password=Nadiad1998")) {
SqlDataReader rdr = null;
conn.Open();
SqlCommand command = new SqlCommand($"SELECT * FROM SHELTER_INFORMATION WHERE RESTRICTIONS LIKE '%{genderOrAgeRange}%'", conn);
rdr = command.ExecuteReader();
while (rdr.Read())
{
subList = new ShelterInfo();
subList.UniqueKey = Convert.ToInt32(rdr[0]);
subList.ShelterName = (rdr[1].ToString());
subList.Capacity = Convert.ToInt32(rdr[2]);
subList.Restrictions = (rdr[3].ToString());
subList.Longitude = (float)Convert.ToDouble(rdr[4]);
subList.Latitude = (float)Convert.ToDouble(rdr[5]);
subList.Address = (rdr[6].ToString());
subList.PhoneNumber = (rdr[7].ToString());
shelterInformation.Add(subList);
}
conn.Close();
}
return(shelterInformation);
} catch (Exception) {
return(null);
}
}
public ShelterInfo getFilteredSheltersByName(string shelterName)
{
ShelterInfoData filteredSheltersByName = new ShelterInfoData();
ShelterInfo filteredShelterByNameList = new ShelterInfo();
filteredShelterByNameList = filteredSheltersByName.getShelterInformation(shelterName);
return(filteredShelterByNameList);
}
public ShelterInfo getShelterInformation(string shelterName)
{
ShelterInfoData shelterInfo = new ShelterInfoData();
ShelterInfo shelterData = new ShelterInfo();
shelterData = shelterInfo.getShelterInformation(shelterName);
return(shelterData);
}
private void Pets(petfinderPetRecordList petList)
{
List <String> shelterIds = new List <string>();
List <PetInfo> pets = new List <PetInfo>();
List <ShelterInfo> shelters = new List <ShelterInfo>();
foreach (var pet in petList.pet)
{
Dictionary <string, string> data = new Dictionary <string, string>();
if (!shelterIds.Contains(pet.shelterId))
{
string shelterData = GetShelter(pet.shelterId);
petfinder shelter = GetData(shelterData);
petfinderShelterRecord shelterRecord = (petfinderShelterRecord)shelter.Item;
if (shelterRecord != null)
{
ShelterInfo record = new ShelterInfo
{
shelterName = shelterRecord.name,
shelterIdField = shelterRecord.id,
address1Field = shelterRecord.address1,
address2Field = shelterRecord.address2,
cityField = shelterRecord.city,
stateField = shelterRecord.state,
latitudeField = (double)shelterRecord.latitude,
longitudeField = (double)shelterRecord.longitude,
phoneField = shelterRecord.phone
};
shelters.Add(record);
}
shelterIds.Add(pet.shelterId);
}
var item = shelters.FirstOrDefault(d => d.shelterIdField == pet.shelterId);
data.Add("Breed", string.Join(", ", pet.breeds.breed.ToList()));
data.Add("Age", pet.age.ToString());
data.Add("Sex", pet.sex.ToString());
data.Add("Shelter", pet.contact.name);
if (item != null)
{
data.Add("Address", item.address1Field + "\n" + item.address2Field + "\n" + item.cityField + ", " + item.stateField);
}
data.Add("Phone", pet.contact.phone);
data.Add("Fax", pet.contact.fax);
data.Add("Email", pet.contact.email);
PetInfo info = new PetInfo
{
nameField = pet.name,
mediaField = pet.media,
shelterIdField = pet.shelterId,
petData = data
};
pets.Add(info);
}
petInfo = pets;
shelterInfo = shelters;
}
public void UpdateShelterInfo()
{
ShelterInfo.UpdateInfo();
MessageBox.Show("Aktualizováno");
}
