public async Task <bool> IsValidRestaurantAsync(RatingandReviewDetails ratingEntity, int UserId, string UserToken) { //HttpClient client = new HttpClient(); //client.BaseAddress = new Uri("http://localhost:10603/"); //HttpResponseMessage httpResponseMessage = await client.GetAsync("api/ResturantDetail?RestaurantID=" + ratingEntity.TblRestaurantId); //if(httpResponseMessage.IsSuccessStatusCode) //{ // string json = await httpResponseMessage.Content.ReadAsStringAsync(); // RestaurantInformation restaurantInformation = JsonConvert.DeserializeObject<RestaurantInformation>(json); // if(restaurantInformation!=null) // { // return true; // } //} //return false; using (HttpClient httpClient = WebAPIClient.GetClient(UserToken, UserId, "http://localhost:10603/")) { HttpResponseMessage httpResponseMessage = await httpClient.GetAsync("api/ResturantDetail?RestaurantID=" + ratingEntity.TblRestaurantId); if (httpResponseMessage.IsSuccessStatusCode) { string json = await httpResponseMessage.Content.ReadAsStringAsync(); RestaurantInformation restaurantInformation = JsonConvert.DeserializeObject <RestaurantInformation>(json); if (restaurantInformation != null) { return(true); } } } return(false); }
public IQueryable <RestaurantInformation> SearchForRestaurantWithHigherRatingsFirst() { try { List <RestaurantInformation> restaurantInformationList = new List <RestaurantInformation>(); IQueryable <RestaurantSearchDetails> searchedRestaurants = search_Repository.SearchForRestaurantWithHigherRatingsFirst(); if (searchedRestaurants != null) { foreach (var restaurant in searchedRestaurants) { RestaurantInformation restaurantDetails = new RestaurantInformation { restaurant_ID = restaurant.restauran_ID, restaurant_Name = restaurant.restaurant_Name, restaurant_Address = restaurant.restaurant_Address, restaurant_ContactNo = restaurant.restaurant_PhoneNumber, website = restaurant.restraurant_Website, opening_Time = restaurant.opening_Time, closing_Time = restaurant.closing_Time, xaxis = restaurant.xaxis, yaxis = restaurant.yaxis }; restaurantInformationList.Add(restaurantDetails); } } return(restaurantInformationList.AsQueryable()); } catch (Exception ex) { throw ex; } }
public void Write(RestaurantInformation objectToList, string fileName) { SocialTapContext db = new SocialTapContext(); db.RestaurantInformationTable.Add(objectToList); db.SaveChanges(); }
public static List <RestaurantInformation> GetRestaurantDate() { RestaurantInformation dataEntry = new RestaurantInformation(); var dataEntryList = new List <RestaurantInformation>(); DataSet ds = new DataSet(); //2nd assignment //ds = RestaurantDbAccess.GetDataUsingDB(); //3rd assignment var service = new RestaurantService.RestaurantServiceClient(); ds = service.GetDataUsingDB(); if (ds.Tables.Count > 0) { dataEntryList = ds.Tables[0].AsEnumerable().Select(m => new RestaurantInformation { Name = Convert.ToString(m["Name"]), Country = Convert.ToString(m["Country"]), City = Convert.ToString(m["City"]), AwardedSince = Convert.ToString(m["AwardedSince"]) }).ToList(); } return(dataEntryList); }
private async void GetMap() { GoogleStaticMapApiData nearbyPlacesData = new GoogleStaticMapApiData(); string type = cmbType.Text; string zoom = cmdZoom.Text; try { Bitmap map = await nearbyPlacesData.GetMapResponseDataAsync(type, zoom); TblNearbyLocation.Rows.Clear(); ImageBoxMap.Image = map; lblImageError.Text = ""; for (int i = 0; i < 5; i++) { RestaurantInformation restaurantInfo = new RestaurantInformation(); restaurantInfo.Name = nearbyPlacesData.placesList[i].Name; restaurantInfo.Address = nearbyPlacesData.placesList[i].Address; RestaurantAverageOfPercentage restaurantAverageOfPercentage = new RestaurantAverageOfPercentage(); TblNearbyLocation.Rows.Add(i + 1, restaurantInfo.Name, restaurantInfo.Address, restaurantAverageOfPercentage.GetAverageOfLiquid(restaurantInfo)); } } catch (ArgumentOutOfRangeException) { TblNearbyLocation.Rows.Clear(); ImageBoxMap.Image = null; lblImageError.Text = "Cannot load information"; } }
public RestaurantInformation GetResturantDetails(int restaurantID) { try { TblRestaurant restaurant = new TblRestaurant(); restaurant = search_Repository.GetResturantDetails(restaurantID); RestaurantInformation resturant_Information = new RestaurantInformation { restaurant_ID = restaurant.Id, restaurant_Name = restaurant.Name, restaurant_Address = restaurant.Address, restaurant_ContactNo = restaurant.ContactNo, closing_Time = restaurant.CloseTime, opening_Time = restaurant.OpeningTime, website = restaurant.Website, xaxis = (double)restaurant.TblLocation.X, yaxis = (double)restaurant.TblLocation.Y }; return(resturant_Information); } catch (Exception ex) { throw ex; } }
public RestaurantInformation GetResturantDetail([FromQuery] int RestaurantID) { RestaurantInformation resturantInformation = new RestaurantInformation(); resturantInformation = business_Repo.GetResturantDetails(RestaurantID); return(resturantInformation); }
public IQueryable <RestaurantInformation> SearchForRestaurants(SearchForRestaurant searchDetails) { try { DataLayer.DataEntity.LocationDetails location_Details = new DataLayer.DataEntity.LocationDetails { distance = searchDetails.location.distance, restaurant_Name = searchDetails.location.restaurant_Name, xaxis = searchDetails.location.xaxis, yaxis = searchDetails.location.yaxis }; DataLayer.DataEntity.AddtitionalFeatureForSearch searchForRestaurant = new DataLayer.DataEntity.AddtitionalFeatureForSearch { cuisine = (string.IsNullOrEmpty(searchDetails.search.cuisine) ? "" : searchDetails.search.cuisine), Menu = (string.IsNullOrEmpty(searchDetails.search.Menu) ? "" : searchDetails.search.Menu), rating = (searchDetails.search.rating != null && searchDetails.search.rating > 0) ? searchDetails.search.rating : 0 }; DataLayer.DataEntity.SearchForRestautrant restaurant = new DataLayer.DataEntity.SearchForRestautrant { location = location_Details, search = searchForRestaurant }; List <RestaurantInformation> restaurant_Info = new List <RestaurantInformation>(); IQueryable <RestaurantSearchDetails> searched_Restaurant; searched_Restaurant = search_Repository.SearchForRestaurants(restaurant); //Result if (searched_Restaurant != null) { foreach (var restaurants in searched_Restaurant) { RestaurantInformation restaurant_Details = new RestaurantInformation { restaurant_ID = restaurants.restauran_ID, restaurant_Name = restaurants.restaurant_Name, restaurant_Address = restaurants.restaurant_Address, restaurant_ContactNo = restaurants.restaurant_PhoneNumber, closing_Time = restaurants.closing_Time, opening_Time = restaurants.opening_Time, website = restaurants.restraurant_Website, xaxis = restaurants.xaxis, yaxis = restaurants.yaxis }; restaurant_Info.Add(restaurant_Details); } } return(restaurant_Info.AsQueryable()); } catch (Exception ex) { throw ex; } }
public void Write(RestaurantInformation glassInformation) { ReadingFromFile <RestaurantInformation> readingFromFile = new ReadingFromFile <RestaurantInformation>(); List <RestaurantInformation> listofGlass = readingFromFile.Read(); BinaryFormatter binaryFormatter = new BinaryFormatter(); FileStream fileStream = new FileStream("C:\\data.bin", FileMode.OpenOrCreate, FileAccess.Write, FileShare.None); listofGlass.Add(glassInformation); binaryFormatter.Serialize(fileStream, listofGlass); fileStream.Flush(); fileStream.Close(); }
public IQueryable <RestaurantInformation> GetRestaurantsBasedOnOrderRating() { try { BusinessEntities.LocationDetails locationDetails = new BusinessEntities.LocationDetails(); List <RestaurantInformation> restaurant_Info = new List <RestaurantInformation>(); IQueryable <RestaurantSearchDetails> searched_Restaurant; //DataLayer.DataEntity.AddtitionalFeatureForSearch searchCritera = new DataLayer.DataEntity.AddtitionalFeatureForSearch //{ // rating = (additionalFeatureForSearch.rating != null && additionalFeatureForSearch.rating > 0) ? additionalFeatureForSearch.rating : 0 //}; //DataLayer.DataEntity.LocationDetails location_Details = new DataLayer.DataEntity.LocationDetails //{ // //distance = locationDetails.distance, // //restaurant_Name = locationDetails.restaurant_Name, // xaxis = searchDetails.location.xaxis, // yaxis = searchDetails.location.yaxis //}; // DataLayer.DataEntity.SearchForRestautrant searchCritera = new DataLayer.DataEntity.SearchForRestautrant //{ // location = location_Details //}; searched_Restaurant = search_Repository.GetRestaurantsBasedOnRatingOrder(); if (searched_Restaurant != null) { foreach (var restaurants in searched_Restaurant) { RestaurantInformation restaurant_Details = new RestaurantInformation { restaurant_ID = restaurants.restauran_ID, restaurant_Name = restaurants.restaurant_Name, restaurant_Address = restaurants.restaurant_Address, restaurant_ContactNo = restaurants.restaurant_PhoneNumber, closing_Time = restaurants.closing_Time, opening_Time = restaurants.opening_Time, website = restaurants.restraurant_Website, xaxis = restaurants.xaxis, yaxis = restaurants.yaxis }; restaurant_Info.Add(restaurant_Details); } } return(restaurant_Info.AsQueryable()); } catch (Exception ex) { throw ex; } }
public IQueryable <RestaurantInformation> SearchForRestaurant(SearchForRestaurant searchDetails) { try { List <RestaurantInformation> restaurantInformationList = new List <RestaurantInformation>(); DataLayer.DataEntity.LocationDetails locationDetails = new DataLayer.DataEntity.LocationDetails() { restaurant_Name = searchDetails.location.restaurant_Name, distance = searchDetails.location.distance, xaxis = searchDetails.location.xaxis, yaxis = searchDetails.location.yaxis }; DataLayer.DataEntity.AddtitionalFeatureForSearch addtitionalFeatureForSearch = new AddtitionalFeatureForSearch() { cuisine = searchDetails.search.cuisine, Menu = searchDetails.search.Menu, rating = searchDetails.search.rating }; DataLayer.DataEntity.SearchForRestautrant searchForRestautrant = new SearchForRestautrant() { location = locationDetails, search = addtitionalFeatureForSearch }; IQueryable <RestaurantSearchDetails> searchedRestaurants = search_Repository.SearchForRestaurant(searchForRestautrant); if (searchedRestaurants != null) { foreach (var restaurant in searchedRestaurants) { RestaurantInformation restaurantDetails = new RestaurantInformation { restaurant_ID = restaurant.restauran_ID, restaurant_Name = restaurant.restaurant_Name, restaurant_Address = restaurant.restaurant_Address, restaurant_ContactNo = restaurant.restaurant_PhoneNumber, website = restaurant.restraurant_Website, opening_Time = restaurant.opening_Time, closing_Time = restaurant.closing_Time, xaxis = restaurant.xaxis, yaxis = restaurant.yaxis }; restaurantInformationList.Add(restaurantDetails); } } return(restaurantInformationList.AsQueryable()); } catch (Exception ex) { throw ex; } }
public static string getAverageOfLiquid(RestaurantInformation restaurantInformation) { ReadingFromFile <RestaurantInformation> listFile = new ReadingFromFile <RestaurantInformation>(); RestaurantInformationPecentageAverage restaurant = new RestaurantInformationPecentageAverage(); List <RestaurantInformationAverage> listRestaurants = restaurant.GetListWithPercentageAverage(listFile.Read()); foreach (RestaurantInformationAverage restaurantsInformation in listRestaurants) { if (restaurantsInformation.Name.Equals(restaurantInformation.Name) && restaurantsInformation.Address.Equals(restaurantInformation.Address)) { return(restaurantsInformation.AverageOfPercentage.ToString()); } } return("-"); }
public string GetAverageOfLiquid(RestaurantInformation restaurantInformation) { ReadingFromFileDeserialize <RestaurantInformation> restaurantListInFile = new ReadingFromFileDeserialize <RestaurantInformation>(); DistictRestaurantsWithAverageOfPercentage distictRestaurantsWithAverage = new DistictRestaurantsWithAverageOfPercentage(); List <RestaurantInformationAverage> restaurantsListWithAverage = distictRestaurantsWithAverage.GetListWithAverageOfPercentage(restaurantListInFile.Read(fileName: ConfigurationManager.AppSettings["FileName"])); foreach (RestaurantInformationAverage restaurantInformationAveraged in restaurantsListWithAverage) { if (restaurantInformationAveraged.Name.Equals(restaurantInformation.Name) && restaurantInformationAveraged.Address.Equals(restaurantInformation.Address)) { return(restaurantInformationAveraged.AverageOfPercentage.ToString()); } } return("-"); }
public IQueryable <RestaurantInformation> SearchForRestaurant(SearchForRestaurant searchDetails) { List <RestaurantInformation> restaurant_Info = new List <RestaurantInformation>(); try { DataLayer.DataEntity.SearchForRestautrant searchParms = new SearchForRestautrant() { location = new DataLayer.DataEntity.LocationDetails() { distance = searchDetails.location.distance, xaxis = searchDetails.location.xaxis, yaxis = searchDetails.location.yaxis, restaurant_Name = searchDetails.location.restaurant_Name }, search = new DataLayer.DataEntity.AddtitionalFeatureForSearch() { rating = searchDetails.search.rating, cuisine = searchDetails.search.cuisine, Menu = searchDetails.search.Menu } }; var searchResult = search_Repository.SearchForRestaurant(searchParms); if (searchResult != null) { foreach (var restaurants in searchResult) { RestaurantInformation restaurant_Details = new RestaurantInformation { restaurant_ID = restaurants.restauran_ID, restaurant_Name = restaurants.restaurant_Name, restaurant_Address = restaurants.restaurant_Address, restaurant_ContactNo = restaurants.restaurant_PhoneNumber, closing_Time = restaurants.closing_Time, opening_Time = restaurants.opening_Time, website = restaurants.restraurant_Website, xaxis = restaurants.xaxis, yaxis = restaurants.yaxis, Rating = restaurants.Rating }; restaurant_Info.Add(restaurant_Details); } } return(restaurant_Info.AsQueryable()); } catch (Exception ex) { return(restaurant_Info.AsQueryable()); } }
public async Task <bool> IsValidRestaurantAsync(AddToCartEntity cartEntity, int UserId, string UserToken) { using (HttpClient httpClient = WebAPIClient.GetClient(UserToken, UserId, _connectionStrings.Value.RestaurantApiUrl)) { HttpResponseMessage httpResponseMessage = await httpClient.GetAsync("api/ResturantDetail?RestaurantID=" + cartEntity.RestaurantId); if (httpResponseMessage.IsSuccessStatusCode) { string json = await httpResponseMessage.Content.ReadAsStringAsync(); RestaurantInformation restaurantInformation = JsonConvert.DeserializeObject <RestaurantInformation>(json); if (restaurantInformation != null) { return(true); } } } return(false); }
public IQueryable <RestaurantInformation> GetRestaurantsBasedOnMenu(AdditionalFeatureForSearch additionalFeatureForSearch) { try { List <RestaurantInformation> restaurant_Info = new List <RestaurantInformation>(); IQueryable <RestaurantSearchDetails> searched_Restaurant; DataLayer.DataEntity.AddtitionalFeatureForSearch searchCritera = new DataLayer.DataEntity.AddtitionalFeatureForSearch { cuisine = (string.IsNullOrEmpty(additionalFeatureForSearch.cuisine) ? "" : additionalFeatureForSearch.cuisine), Menu = (string.IsNullOrEmpty(additionalFeatureForSearch.Menu) ? "" : additionalFeatureForSearch.Menu), rating = (additionalFeatureForSearch.rating != null && additionalFeatureForSearch.rating > 0) ? additionalFeatureForSearch.rating : 0 }; searched_Restaurant = search_Repository.GetRestaurantsBasedOnMenu(searchCritera); if (searched_Restaurant != null) { foreach (var restaurants in searched_Restaurant) { RestaurantInformation restaurant_Details = new RestaurantInformation { restaurant_ID = restaurants.restauran_ID, restaurant_Name = restaurants.restaurant_Name, restaurant_Address = restaurants.restaurant_Address, restaurant_ContactNo = restaurants.restaurant_PhoneNumber, closing_Time = restaurants.closing_Time, opening_Time = restaurants.opening_Time, website = restaurants.restraurant_Website, xaxis = restaurants.xaxis, yaxis = restaurants.yaxis }; restaurant_Info.Add(restaurant_Details); } } return(restaurant_Info.AsQueryable()); } catch (Exception ex) { throw ex; } }
public async Task <bool> IsOrderItemInStock(OrderEntity orderEntity, int UserId, string UserToken) { //using (HttpClient httpClient = WebAPIClient.GetClient(UserToken, UserId, _connectionStrings.Value.RestaurantApiUrl)) using (HttpClient httpClient = new HttpClient()) { HttpResponseMessage httpResponseMessage = await httpClient.GetAsync("http://localhost:10601/api/OrderDetail?RestaurantID=" + orderEntity.RestaurantId); if (httpResponseMessage.IsSuccessStatusCode) { string json = await httpResponseMessage.Content.ReadAsStringAsync(); RestaurantInformation restaurantInformation = JsonConvert.DeserializeObject <RestaurantInformation>(json); if (restaurantInformation != null) { return(true); } } } return(false); }
public IQueryable <RestaurantInformation> SearchRestaurantByLocation(BusinessEntities.LocationDetails locationDetails) { try { List <RestaurantInformation> restaurant_Info = new List <RestaurantInformation>(); IQueryable <RestaurantSearchDetails> searched_Restaurant; DataLayer.DataEntity.LocationDetails location_Details = new DataLayer.DataEntity.LocationDetails { distance = locationDetails.distance, restaurant_Name = locationDetails.restaurant_Name, xaxis = locationDetails.xaxis, yaxis = locationDetails.yaxis }; searched_Restaurant = search_Repository.GetRestaurantsBasedOnLocation(location_Details); foreach (var restaurants in searched_Restaurant) { RestaurantInformation restaurant_Details = new RestaurantInformation { restaurant_ID = restaurants.restauran_ID, restaurant_Name = restaurants.restaurant_Name, restaurant_Address = restaurants.restaurant_Address, restaurant_ContactNo = restaurants.restaurant_PhoneNumber, closing_Time = restaurants.closing_Time, opening_Time = restaurants.opening_Time, website = restaurants.restraurant_Website, xaxis = restaurants.xaxis, yaxis = restaurants.yaxis }; restaurant_Info.Add(restaurant_Details); } return(restaurant_Info.AsQueryable()); } catch (Exception ex) { throw ex; } }
public IQueryable <RestaurantInformation> SearchForRestaurantBasedOnMultipleFeactures(BusinessEntities.MultipleSearchFeature multiplesearchDetails) { try { List <RestaurantInformation> restaurant_Info = new List <RestaurantInformation>(); IQueryable <RestaurantSearchDetails> searched_Restaurant; DataLayer.DataEntity.MultipleSearchFeature searchCritera = new DataLayer.DataEntity.MultipleSearchFeature { cuisine = (string.IsNullOrEmpty(multiplesearchDetails.cuisine) ? "" : multiplesearchDetails.cuisine), Menu = (string.IsNullOrEmpty(multiplesearchDetails.Menu) ? "" : multiplesearchDetails.Menu), rating = (multiplesearchDetails.rating != null && multiplesearchDetails.rating > 0) ? multiplesearchDetails.rating : 0, RestaurantName = (string.IsNullOrEmpty(multiplesearchDetails.RestaurantName) ? "" : multiplesearchDetails.RestaurantName) }; searched_Restaurant = search_Repository.SearchForRestaurantBasedOnMultipleFeactures(searchCritera); foreach (var restaurants in searched_Restaurant) { RestaurantInformation restaurant_Details = new RestaurantInformation { restaurant_ID = restaurants.restauran_ID, restaurant_Name = restaurants.restaurant_Name, restaurant_Address = restaurants.restaurant_Address, restaurant_ContactNo = restaurants.restaurant_PhoneNumber, closing_Time = restaurants.closing_Time, opening_Time = restaurants.opening_Time, website = restaurants.restraurant_Website, xaxis = restaurants.xaxis, yaxis = restaurants.yaxis }; restaurant_Info.Add(restaurant_Details); } return(restaurant_Info.AsQueryable()); } catch (Exception ex) { throw ex; } }
/// <summary> /// 跳转到餐厅信息页面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void canting_Press(object sender, EventArgs e) { RestaurantInformation restaurantInformation = new RestaurantInformation(); Show(restaurantInformation); }