public static List <PatientAtFoodPlace> CreatePatientAtFoodPlaces(int userinput) { WpfWebClient.ServiceReferenceEHEC.ServiceClient client = new WpfWebClient.ServiceReferenceEHEC.ServiceClient(); List <WpfWebClient.ServiceReferenceEHEC.FoodPlace> foodPlaces = new List <ServiceReferenceEHEC.FoodPlace>(client.GetFoodPlaces()); List <WpfWebClient.ServiceReferenceEHEC.Person> patients = new List <ServiceReferenceEHEC.Person>(client.GetPersons()); int i = 0; do { PatientAtFoodPlace patfgen = new PatientAtFoodPlace(); int randnumFP = random.Next(0, foodPlaces.Count()); FoodPlace foodpl = foodPlaces[randnumFP]; int randnumP = random.Next(0, patients.Count()); Person patient = patients[randnumP]; patfgen.FoodPlace = foodpl; patfgen.Patient = patient; patfgen.VistingDate = new DateTime(2005, 12, 20); PatientsAtFoodPlaces.Add(patfgen); i++; } while (i < userinput); client.Close(); return(PatientsAtFoodPlaces); }
public bool CreateFoodPlace(FoodPlace foodplace) { try { using (Context ctx = new Context()) { var city = ctx.Cities.FirstOrDefault(c => c.CityID == foodplace.City.CityID); var country = ctx.Countries.FirstOrDefault(c => c.CountryID == foodplace.City.Country.CountryID); ctx.Cities.Attach(city); ctx.Countries.Attach(country); foodplace.City = city; ctx.FoodPlaces.Add(foodplace); ctx.SaveChanges(); } return(true); } catch (Exception e) { System.Diagnostics.Trace.WriteLine(e); return(false); } }
public IActionResult Index() { List <string> foodPlaceList = new List <string>(); foreach (FoodPlace fp in FoodPlace.GetFoodPlaces()) { foodPlaceList.Add(string.Format($"#{fp.Rank}: Name: {fp.Name} Favorite: {fp.Fave} Address: {fp.Address} Link: {fp.WebLink}")); } return(View(foodPlaceList)); }
private void btnAddFoodPlace_Click(object sender, RoutedEventArgs e) { WpfWebClient.ServiceReferenceEHEC.ServiceClient client = new WpfWebClient.ServiceReferenceEHEC.ServiceClient(); // create new foodplace from user input FoodPlace fp = new FoodPlace(); // check if any box is empty if (ComboBoxFPCities.SelectedIndex == -1) { System.Windows.MessageBox.Show("Please select a city", "INFO", MessageBoxButton.OK, MessageBoxImage.Information); } if (txtFoodPlaceName.Text == null) { System.Windows.MessageBox.Show("Please enter a name for the food place", "INFO", MessageBoxButton.OK, MessageBoxImage.Information); } if (txtFoodPlaceHouseNumber.Text == null) { System.Windows.MessageBox.Show("Please enter a house number", "INFO", MessageBoxButton.OK, MessageBoxImage.Information); } if (txtFoodPlaceStreetName.Text == null) { System.Windows.MessageBox.Show("Please enter a street name", "INFO", MessageBoxButton.OK, MessageBoxImage.Information); } else { fp.Streetname = txtFoodPlaceStreetName.Text; fp.Streetnumber = txtFoodPlaceHouseNumber.Text; fp.Name = txtFoodPlaceName.Text; fp.Description = txtFoodPlaceDescription.Text; fp.City = (City)ComboBoxFPCities.SelectedValue; client.WriteFoodPlace(fp); // Show success msgbox System.Windows.MessageBox.Show("Success", "INFO", MessageBoxButton.OK, MessageBoxImage.Information); } client.Close(); }
public bool DeleteFoodPlace(FoodPlace foodplace) { try { using (Context ctx = new Context()) { ctx.FoodPlaces.Attach(foodplace); ctx.FoodPlaces.Remove(foodplace); ctx.SaveChanges(); } return(true); } catch (Exception e) { System.Diagnostics.Trace.WriteLine(e); return(false); } }
public bool UpdateFoodPlace(FoodPlace foodplace) { try { using (Context ctx = new Context()) { ctx.FoodPlaces.Attach(foodplace); ctx.Entry(foodplace).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); } return(true); } catch (Exception e) { System.Diagnostics.Trace.WriteLine(e); return(false); } }
public static List <FoodPlace> CreateFoodPlaces() { WpfWebClient.ServiceReferenceEHEC.ServiceClient client = new WpfWebClient.ServiceReferenceEHEC.ServiceClient(); List <WpfWebClient.ServiceReferenceEHEC.City> cities = new List <ServiceReferenceEHEC.City>(client.GetCities()); int FirstPartLength = FoodPlaceNameFirstPart.Count(); int SecondPartLength = FoodPlaceNameSecondPart.Count(); int Counter = FirstPartLength * SecondPartLength; int i = 1; while (i < 20) { int FirstPart = random.Next(1, FirstPartLength); int SecondPart = random.Next(1, SecondPartLength); int Description = random.Next(FoodPlaceDescription.Count); string FoodPlaceDescr = FoodPlaceDescription[Description]; int StreetName = random.Next(FoodPlaceStreetName.Count); string FoodPlacesn = FoodPlaceStreetName[StreetName]; string FoodPlaceName = FoodPlaceNameFirstPart[FirstPart] + FoodPlaceNameSecondPart[SecondPart]; string streetname = FoodPlacesn; string fpdescr = FoodPlaceDescr; int StreetNumber = random.Next(1, 100); int CityID = random.Next(1, cities.Count()); City city = cities[CityID]; FoodPlace NewFoodPlace = new FoodPlace(); NewFoodPlace.Name = FoodPlaceName; NewFoodPlace.Streetname = streetname; NewFoodPlace.Streetnumber = StreetNumber.ToString(); NewFoodPlace.Description = fpdescr; NewFoodPlace.City = city; Foodplaces.Add(NewFoodPlace); i++; } client.Close(); return(Foodplaces); }
public void WriteFoodPlace(FoodPlace foodplace) { FoodPlaceDB dataaccess = new FoodPlaceDB(); dataaccess.CreateFoodPlace(foodplace); }