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