public async Task <IActionResult> GetBySearch() { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"SELECT Id, LocationName, LocationAddress FROM ShopLocation"; SqlDataReader reader = await cmd.ExecuteReaderAsync(); List <ShopLocation> shopLocations = new List <ShopLocation>(); while (reader.Read()) { ShopLocation shopLocation = new ShopLocation { Id = reader.GetInt32(reader.GetOrdinal("Id")), LocationName = reader.GetString(reader.GetOrdinal("LocationName")), LocationAddress = reader.GetString(reader.GetOrdinal("LocationAddress")) }; shopLocations.Add(shopLocation); } reader.Close(); return(Ok(shopLocations)); } } }
public Product(Guid id, string name, string category, ShopLocation storeLocation) { Id = id; Name = name; Category = category; StoreLocation = storeLocation; }
public ActionResult DeleteConfirmed(int id) { ShopLocation shopLocation = db.Locations.Find(id); db.Locations.Remove(shopLocation); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ShopLocationID,OpeningHour,ClosingHour,Phone,EMail,City,FullAddress,PostalCode")] ShopLocation shopLocation) { if (ModelState.IsValid) { db.Entry(shopLocation).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View("~/Views/Admin/ShopLocation/Index.cshtml", shopLocation)); }
public static ShopLocationModel ToModel(this ShopLocation aShopLocation) { return(new ShopLocationModel() { LocationId = aShopLocation.LocationId, LocCode = aShopLocation.LocCode, Description = aShopLocation.Description, AreaId = aShopLocation.AreaId, LocationTypeId = aShopLocation.LocationTypeId }); }
private static void LocationSelectionMenu() { System.Console.WriteLine("Step-1: Choose Order Location: "); DisplayShopLocation(ShopLocationDataRetriever.GetInstance().ShopLocationList); System.Console.Write("Location Choice: "); int locationChoice = Convert.ToInt32(Console.ReadLine()); CurrentShopLocation = new ShopLocation (ShopLocationDataRetriever.GetInstance().ShopLocationList[locationChoice - 1].ShopAddress, ShopLocationDataRetriever.GetInstance().ShopLocationList[locationChoice - 1].ShopID); }
private List <ShopLocation> InitializeShopLocationList() { List <ShopLocation> locationList = new List <ShopLocation>(); foreach (var location in _dbConnection.PizzaShopLocation.Include("Address").ToList()) { ShopLocation l = new ShopLocation(new Address(location.Address.StreetName, location.Address.City , location.Address.StateProvince, location.Address.Zipcode), location.LocationId); locationList.Add(l); } return(locationList); }
public ActionResult Create([Bind(Include = "ShopLocationID,OpeningHour,ClosingHour,Phone,EMail,City,FullAddress,PostalCode")] ShopLocation shopLocation) { if (ModelState.IsValid) { shopLocation.OpeningHour = new DateTime(1990, 1, 1, 8, 0, 0); shopLocation.ClosingHour = new DateTime(1990, 1, 1, 18, 0, 0); db.Locations.Add(shopLocation); db.SaveChanges(); return(RedirectToAction("Index")); } return(View("~/Views/Admin/ShopLocation/Index.cshtml", shopLocation)); }
// GET: ShopLocations/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ShopLocation shopLocation = db.Locations.Find(id); if (shopLocation == null) { return(HttpNotFound()); } return(View("~/Views/Admin/ShopLocation/Delete.cshtml", shopLocation)); }
public async Task <IActionResult> GetById([FromRoute] int id) { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"SELECT Id, LocationName, LocationAddress FROM ShopLocation WHERE Id = @Id"; cmd.Parameters.Add(new SqlParameter("@id", id)); SqlDataReader reader = await cmd.ExecuteReaderAsync(); ShopLocation shopLocation = null; if (reader.Read()) { shopLocation = new ShopLocation { Id = reader.GetInt32(reader.GetOrdinal("Id")), LocationName = reader.GetString(reader.GetOrdinal("LocationName")), LocationAddress = reader.GetString(reader.GetOrdinal("LocationAddress")), }; } reader.Close(); if (shopLocation == null) { return(NotFound($"No shop location found with the Id of {id}")); } return(Ok(shopLocation)); } } }
public IActionResult Post([System.Web.Http.FromUri] string coordinates, [System.Web.Http.FromUri] string distance) { string template = "https://maps.googleapis.com/maps/api/place/nearbysearch/json?location={0}&radius={1}&type=supermarket&keyword=bingo&fields=formatted_address,name&key={2}"; string request = string.Format(template, coordinates, distance, API_KEY); WebClient webpage = new WebClient(); string[] crrdns = coordinates.Split(','); var response = webpage.DownloadString(request); RootObject model = JsonConvert.DeserializeObject <RootObject>(response); if (model.status != "OK") { return(BadRequest()); } _db.Database.ExecuteSqlCommand("TRUNCATE TABLE [ShopLocations]"); foreach (var result in model.results) { ShopLocation shop = new ShopLocation { Name = result.name, Address = result.vicinity, GeoCoordinates = result.geometry.location.lat + "," + result.geometry.location.lng, DistanceInKm = MathHelp.GetDistanceFromLatLonInKm(double.Parse(crrdns[0], CultureInfo.InvariantCulture), double.Parse(crrdns[1], CultureInfo.InvariantCulture), result.geometry.location.lat, result.geometry.location.lng).ToString() + "km" }; _db.ShopLocations.Add(shop); } _db.SaveChanges(); var sh = new JsonResult(_db.ShopLocations.ToList()); sh.ContentType = "application/json"; sh.StatusCode = 200; return(new JsonResult(sh)); }