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