private void AddShopElement(PlacesModel model) { var pin = new ServicePointViewModel(model, "ShopRadioButtonStyle"); //pin.Click += pin_Click; MapSourceHandler.ServicePoints.Add(pin); }
private void AddServiceElement(PlacesModel model) { var pin = new ServicePointViewModel(model); //pin.Click += pin_Click; MapSourceHandler.ServicePoints.Add(pin); }
public ActionResult CreateItinPartial(ItineraryModel newItinerary) { PlacesDAL dal = new PlacesDAL(); PlacesModel p = new PlacesModel(); if (!ModelState.IsValid) { return(RedirectToAction("UserDashboard")); } else { p = dal.GetSinglePlace(newItinerary.StartingLocationId); newItinerary.StartLocationLat = p.Latitude.ToString(); newItinerary.StartLocationLong = p.Longitude.ToString(); UserModel user = Session["user"] as UserModel; newItinerary.UserId = user.UserId; ItineraryDAL idal = new ItineraryDAL(); idal.CreateNewItinerary(newItinerary); int neededIdNumber = idal.GetMostRecentlyCreatedItinerary(user.UserId); idal.AddPlaceToItinerary(neededIdNumber, newItinerary.StartingLocationId); return(RedirectToAction("UserDashboard")); } }
public IActionResult Edit(int id, PlacesModel datosUpdate) { try { var lugarDB = _context.Lugares.Find(id); if (lugarDB != null) { lugarDB.name = datosUpdate.name; lugarDB.email = datosUpdate.email; lugarDB.cellphone = datosUpdate.cellphone; lugarDB.Id = datosUpdate.Id; lugarDB.addressStreet = datosUpdate.addressStreet; lugarDB.addressNumber1 = datosUpdate.addressNumber1; lugarDB.addressNumber2 = datosUpdate.addressNumber2; lugarDB.addressNumber3 = datosUpdate.addressNumber3; lugarDB.addressLocation = datosUpdate.addressLocation; datosUpdate.address = datosUpdate.addressStreet + " " + datosUpdate.addressNumber1 + " # " + datosUpdate.addressNumber2 + " - " + datosUpdate.addressNumber3 + " " + datosUpdate.addressLocation; //userDB.address = userDB.addressStreet + " " + userDB.addressNumber1 + " # " + userDB.addressNumber2 + " - " + userDB.addressNumber3 + " " + userDB.addressLocation; lugarDB.address = datosUpdate.address; _context.SaveChanges(); return(RedirectToAction(nameof(Index))); } else { return(NotFound()); } // TODO: Add update logic here } catch { return(View()); } }
public async Task <List <PlacesModel> > GetPlacesPredictions(string input) { HttpClient client = new HttpClient(); PredictionsModel predictionsModel = new PredictionsModel(); HttpResponseMessage placesResponse; strPlacesAPI = strPlacesAPI.Replace("{{pred}}", input); placesResponse = client.GetAsync(strPlacesAPI).Result; if (placesResponse.IsSuccessStatusCode) { predictionsModel = await placesResponse.Content.ReadAsAsync <PredictionsModel>(); } PlacesModel placesModel; List <PlacesModel> placesList = new List <PlacesModel>(); foreach (Prediction p in predictionsModel.predictions) { placesModel = new PlacesModel(); placesModel.description = p.description; placesList.Add(placesModel); } return(placesList); }
public IActionResult Create(PlacesViewModel lugar) { try { var lugarDB = new PlacesModel(); lugarDB.name = lugar.name; lugarDB.email = lugar.email; lugarDB.cellphone = lugar.cellphone; lugarDB.Id = lugar.Id; lugarDB.addressStreet = lugar.addressStreet; lugarDB.addressNumber1 = lugar.addressNumber1; lugarDB.addressNumber2 = lugar.addressNumber2; lugarDB.addressNumber3 = lugar.addressNumber3; lugarDB.addressLocation = lugar.addressLocation; lugarDB.address = lugar.addressStreet + " " + lugar.addressNumber1 + " # " + lugar.addressNumber2 + " - " + lugar.addressNumber3 + " " + lugar.addressLocation; //TODO: Add insert logic here _context.Lugares.Add(lugarDB); _context.SaveChanges(); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
private void AddWashElement(PlacesModel model) { var pin = new ServicePointViewModel(model, "WashRadioButtonStyle"); //pin.Click += pin_Click; DataSource.ServicePoints.Add(pin); }
public List <PlacesModel> GetAllPlaces() { List <PlacesModel> places = new List <PlacesModel>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_GetAllPlaces, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { PlacesModel place = new PlacesModel(); if ((reader["googleID"] == DBNull.Value)) { place.Id = Convert.ToInt32(reader["id"]); place.StreetAddress = Convert.ToString(reader["streetAddress"]); place.City = Convert.ToString(reader["city"]); place.State = Convert.ToString(reader["state"]); place.Latitude = Convert.ToDecimal(reader["latitude"]); place.Longitude = Convert.ToDecimal(reader["longitude"]); place.Detail = Convert.ToString(reader["detail"]); place.PlaceName = Convert.ToString(reader["placeName"]); place.Category = Convert.ToString(reader["category"]); place.Zip = Convert.ToInt32(reader["zip"]); places.Add(place); } else { place.Id = Convert.ToInt32(reader["id"]); place.StreetAddress = Convert.ToString(reader["streetAddress"]); place.City = Convert.ToString(reader["city"]); place.State = Convert.ToString(reader["state"]); place.Latitude = Convert.ToDecimal(reader["latitude"]); place.Longitude = Convert.ToDecimal(reader["longitude"]); place.GoogleID = null; place.Detail = Convert.ToString(reader["detail"]); place.PlaceName = Convert.ToString(reader["placeName"]); place.Category = Convert.ToString(reader["category"]); place.Zip = Convert.ToInt32(reader["zip"]); places.Add(place); } } } return(places); } catch (SqlException ex) { throw; } }
public async void UpdatePlace(object sender, SelectedItemChangedEventArgs a) { (sender as ListView).SelectedItem = null; if (a.SelectedItem != null) { PlacesModel subpageData = a.SelectedItem as PlacesModel; appointmentRequest.Place = subpageData; SelectedLocation.Text = appointmentRequest.Place.PlaceDetail; await Navigation.PopAsync(); } }
public int CreatePlaceForUser(PlacesModel place) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_InsertUserPlace, conn); if (place.GoogleID == null) { cmd.Parameters.AddWithValue("@streetAddress", place.StreetAddress); cmd.Parameters.AddWithValue("@city", place.City); cmd.Parameters.AddWithValue("@state", place.State); cmd.Parameters.AddWithValue("@latitude", place.Latitude); cmd.Parameters.AddWithValue("@longitude", place.Longitude); cmd.Parameters.AddWithValue("@googleID", DBNull.Value); cmd.Parameters.AddWithValue("@detail", DBNull.Value); cmd.Parameters.AddWithValue("@placeName", place.PlaceName); cmd.Parameters.AddWithValue("@Category", place.Category); cmd.Parameters.AddWithValue("@zip", place.Zip); cmd.Parameters.AddWithValue("@userId", place.UserId); int rowsAffectedOne = cmd.ExecuteNonQuery(); cmd = new SqlCommand("SELECT Max(Id) from places;", conn); int newlyAddedPlaceIdOne = (int)(cmd.ExecuteScalar()); return(newlyAddedPlaceIdOne); } cmd.Parameters.AddWithValue("@streetAddress", place.StreetAddress); cmd.Parameters.AddWithValue("@city", place.City); cmd.Parameters.AddWithValue("@state", place.State); cmd.Parameters.AddWithValue("@latitude", place.Latitude); cmd.Parameters.AddWithValue("@longitude", place.Longitude); cmd.Parameters.AddWithValue("@googleID", place.GoogleID); cmd.Parameters.AddWithValue("@detail", DBNull.Value); cmd.Parameters.AddWithValue("@placeName", place.PlaceName); cmd.Parameters.AddWithValue("@Category", place.Category); cmd.Parameters.AddWithValue("@zip", place.Zip); cmd.Parameters.AddWithValue("@userId", place.UserId); int rowsAffected = cmd.ExecuteNonQuery(); cmd = new SqlCommand("SELECT Max(Id) from places;", conn); int newlyAddedPlaceId = (int)(cmd.ExecuteScalar()); return(newlyAddedPlaceId); } } catch (SqlException ex) { throw; } }
public ServicePointViewModel(PlacesModel model, string style) { Model = model; Location = new Geopoint(new BasicGeoposition { Altitude = 0, Latitude = model.Latitude / 10000.0, Longitude = model.Longitude / 10000.0 }); NAP = new Point(0, 1); StylePoint = Application.Current.Resources[style] as Style; }
public ActionResult UpdateThePlace(PlacesModel places) { if (!ModelState.IsValid) { return(View("Update")); } else { SqlPojo.updatePlace(places.id, places.name, places.isPrime, places.description, places.image_url, places.price, places.days); return(RedirectToAction("getTheDashboard")); } }
public ActionResult InsertTheShow(PlacesModel place) { //System.Diagnostics.Debug.WriteLine($"{m.name} {m.year} {m.image_url}"); if (!ModelState.IsValid) { return(View("Insert")); } else { SqlPojo.insertAPlace(place.name, place.description, place.isPrime, place.image_url, place.price, place.days); return(RedirectToAction("getTheDashboard")); } }
public PlacesModel GetSinglePlace(int id) { try { PlacesModel place = new PlacesModel(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_GetSinglePlace, conn); cmd.Parameters.AddWithValue("@id", id); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if ((reader["googleID"] == DBNull.Value)) { place.Id = Convert.ToInt32(reader["id"]); place.StreetAddress = Convert.ToString(reader["streetAddress"]); place.City = Convert.ToString(reader["city"]); place.State = Convert.ToString(reader["state"]); place.Latitude = Convert.ToDecimal(reader["latitude"]); place.Longitude = Convert.ToDecimal(reader["longitude"]); place.Detail = Convert.ToString(reader["detail"]); place.PlaceName = Convert.ToString(reader["placeName"]); place.Category = Convert.ToString(reader["category"]); place.Zip = Convert.ToInt32(reader["zip"]); return(place); } place.Id = Convert.ToInt32(reader["id"]); place.StreetAddress = Convert.ToString(reader["streetAddress"]); place.City = Convert.ToString(reader["city"]); place.State = Convert.ToString(reader["state"]); place.Latitude = Convert.ToDecimal(reader["latitude"]); place.Longitude = Convert.ToDecimal(reader["longitude"]); place.GoogleID = Convert.ToInt32(reader["googleID"]); place.Detail = Convert.ToString(reader["detail"]); place.PlaceName = Convert.ToString(reader["placeName"]); place.Category = Convert.ToString(reader["category"]); place.Zip = Convert.ToInt32(reader["zip"]); } return(place); } } catch (SqlException ex) { throw; } }
public async void AddList(object sender, FormEvent args) { var obj = args.Object as PlacesModel; var isSuccessful = await PlacesModel.AddToList(obj); if (isSuccessful) { appointmentRequest.Place = PlacesModel.PlacesList.FirstOrDefault(); await Navigation.PopAsync(); } else { await DisplayAlert("Oops", "Something went wrong", "Try again"); } }
public ActionResult SavedItinerary(PlacesModel newPlaceForUser) { if (Session["user"] != null) { PlacesDAL pdal = new PlacesDAL(); ItineraryDAL idal = new ItineraryDAL(); UserModel user = Session["user"] as UserModel; newPlaceForUser.UserId = user.UserId; List <ItineraryModel> userItinerary = idal.GetAllItinerary(user.UserId); var save = pdal.CreatePlaceForUser(newPlaceForUser); var saveToItin = idal.AddPlaceToItinerary(userItinerary[0].Id, save); return(Json(new { result = "OK" })); } return(View("LoginRegister")); }
public async void AddList(object sender, FormEvent args) { var obj = args.Object as PlacesModel; var isSuccessful = await PlacesModel.AddToList(obj); if (isSuccessful) { places.Add(new PlacesViewModel(obj)); } else { await DisplayAlert("Oops", "Something went wrong", "Try again"); } await Navigation.PopAsync(); }
public ServiceInfoViewModel() { //if (DesignMode.DesignModeEnabled) { Model = new PlacesModel { idCategory = 2, Latitude = 557600, Longitude = 376100, Adress = "Adress 4", Name = "Shop", MinPrice = 150, Score = 40 }; } StylePoint = Application.Current.Resources["ServiceContentControlStyle"] as Style; }
protected async override void OnAppearing() { base.OnAppearing(); if (!HasAppeared) { await AppointmentDashboardViewmodel.GetList(); } if (!HasAppeared) { await PlacesModel.GetList(); await DashboardViewModel.GetList(); HasAppeared = true; } }
public bool CreatePlace(PlacesModel place) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_CreatePlace, conn); if (place.GoogleID == null) { cmd.Parameters.AddWithValue("@streetAddress", place.StreetAddress); cmd.Parameters.AddWithValue("@city", place.City); cmd.Parameters.AddWithValue("@state", place.State); cmd.Parameters.AddWithValue("@latitude", place.Latitude); cmd.Parameters.AddWithValue("@longitude", place.Longitude); cmd.Parameters.AddWithValue("@googleID", DBNull.Value); cmd.Parameters.AddWithValue("@detail", place.City); cmd.Parameters.AddWithValue("@placeName", place.State); cmd.Parameters.AddWithValue("@category", place.Latitude); cmd.Parameters.AddWithValue("@zip", place.Zip); int rowsAffectedOne = cmd.ExecuteNonQuery(); return(rowsAffectedOne > 0); } cmd.Parameters.AddWithValue("@streetAddress", place.StreetAddress); cmd.Parameters.AddWithValue("@city", place.City); cmd.Parameters.AddWithValue("@state", place.State); cmd.Parameters.AddWithValue("@latitude", place.Latitude); cmd.Parameters.AddWithValue("@longitude", place.Longitude); cmd.Parameters.AddWithValue("@googleID", place.GoogleID); cmd.Parameters.AddWithValue("@detail", place.City); cmd.Parameters.AddWithValue("@placeName", place.State); cmd.Parameters.AddWithValue("@category", place.Latitude); cmd.Parameters.AddWithValue("@zip", place.Zip); int rowsAffected = cmd.ExecuteNonQuery(); return(rowsAffected > 0); } } catch (SqlException ex) { throw; } }
private async Task <PointDetailsModel> GetDetailAsync(PlacesModel model) { #region DesignMode if (DesignMode.DesignModeEnabled) { _detail = new PointDetailsModel(); _detail.Comments.Add(new PointDetailsModel.CommentModel { Date = new DateDataModel(DateTime.Now), Score = 80, Text = "Text1" }); _detail.Comments.Add(new PointDetailsModel.CommentModel { Date = new DateDataModel(DateTime.Now.AddDays(-3)), Score = 40, Text = "Text2" }); _detail.Price.Add(new PointDetailsModel.PriceModel { Name = "Service 1", Cost = 250 }); _detail.Price.Add(new PointDetailsModel.PriceModel { Name = "Service 2", Cost = 350 }); _detail.Price.Add(new PointDetailsModel.PriceModel { Name = "Service 3", Cost = 550 }); _detail.Price.Add(new PointDetailsModel.PriceModel { Name = "Service 4", Cost = 150 }); return(_detail); } #endregion var res = await TcpConnection.Send("DE" + model.ID); if (!string.IsNullOrEmpty(res.Msg)) { await Split(res.Fx, res.Msg); } return(_detail ?? new PointDetailsModel()); }
public ActionResult EditPlace(int id) { if (ManageCookie.isAdmin() == false) { return(RedirectToAction("Index", "Home")); } ViewBag.Title = "Place Edit"; //check event exist if (!PlacesModel.isPlaceExists(id)) { return(RedirectToAction("Places")); } ViewBag.placeInfo = AdminModel.getPlaceInfo(id); return(View()); }
public async void OnClick(object sender, EventArgs a) { var placename = PlaceName.Text; var streetaddress = StreetAddress.Text; var barangay = BarangayText.Text; var city = CityText.Text; var isValid = true; foreach (var field in Fields) { if (field.Text == "" || field.Text == null) { field.PlaceholderColor = Color.Red; isValid = false; } } if (!isValid) { await DisplayAlert("Invalid input", "Fields cannot be empty", "Got it"); return; } if (places != null) { places.PlaceName = placename; places.StreetName = streetaddress; places.Barangay = barangay; places.City = city; } else { places = new PlacesModel(placename, streetaddress, barangay, city); } var args = new FormEvent() { Object = places }; DataSender(sender, args); }
public PlacesForm(PlacesModel obj) { InitializeComponent(); PlaceName.Text = obj.PlaceName; StreetAddress.Text = obj.StreetName; BarangayText.Text = obj.Barangay; CityText.Text = obj.City; Send.IsVisible = false; places = obj; Fields = new List <Entry> { PlaceName, StreetAddress, BarangayText, CityText }; Barangay.IsVisible = false; City.IsVisible = false; BarangayText.IsVisible = true; CityText.IsVisible = true; PlaceName.IsEnabled = false; StreetAddress.IsEnabled = false; }
private async Task <PointDetailsModel> GetDetailAsync(PlacesModel model) { var dataUri = new Uri(DataSource.Url + "GetTemplates"); try { var request = (HttpWebRequest)WebRequest.Create(dataUri); request.Method = "GET"; //request.ContentType = "text/plain"; using (var response = await request.GetResponseAsync()) { using (var stream = response.GetResponseStream()) { } } } catch { } var res = new PointDetailsModel(); res.Comments.Add(new PointDetailsModel.CommentModel { Date = new DateDataModel(DateTime.Now), Score = 80, Text = "Text1" }); res.Comments.Add(new PointDetailsModel.CommentModel { Date = new DateDataModel(DateTime.Now.AddDays(-3)), Score = 40, Text = "Text2" }); res.Price.Add(new PointDetailsModel.PriceModel { Name = "Service 1", Cost = 250 }); res.Price.Add(new PointDetailsModel.PriceModel { Name = "Service 2", Cost = 350 }); res.Price.Add(new PointDetailsModel.PriceModel { Name = "Service 3", Cost = 550 }); res.Price.Add(new PointDetailsModel.PriceModel { Name = "Service 4", Cost = 150 }); return(res); }
private void AddElements(PlacesModel model) { switch (model.idCategory) { case 1: AddGasElement(model); break; case 2: AddWashElement(model); break; case 3: AddShopElement(model); break; case 4: AddServiceElement(model); break; } }
public ActionResult ItinPartial() { List <ItineraryPlacesModel> model = new List <ItineraryPlacesModel>(); UserModel user = Session["user"] as UserModel; ItineraryDAL itdal = new ItineraryDAL(); List <ItineraryModel> itinerary = itdal.GetAllItinerary(user.UserId); List <int> listOfPlaceIds = itdal.GetItinerary(user.UserId); foreach (var i in itinerary) { ItineraryPlacesModel singleIntinForUser = new ItineraryPlacesModel(); singleIntinForUser.Itinerary = i; List <PlacesModel> listOfPlacesInItin = new List <PlacesModel>(); foreach (var singlePlaceId in listOfPlaceIds) { PlacesModel newPlaceFromItin = new PlacesModel(); newPlaceFromItin = dal.GetSinglePlace(singlePlaceId); listOfPlacesInItin.Add(newPlaceFromItin); } singleIntinForUser.Places = listOfPlacesInItin; model.Add(singleIntinForUser); } return(View("ItinPartial", model)); }
public ServiceInfoViewModel(PlacesModel model) { Model = model; StylePoint = GetStyle(model.idCategory); }
public PlacesViewModel(PlacesModel model) { Places = model; }
public PlacesViewModel(int id, string name, string street, string barangay, string city) { Places = new PlacesModel(id, name, street, barangay, city); }