/// <summary>
/// Create a button for each route in a attraction
/// </summary>
/// <param name="attraction">The attration that contain the routes</param>
public void CreateRouteMenu(Attraction attraction)
{
if (parentRoute.childCount > 0)
{
RemoveAllChild(parentRoute);
}
Dictionary<string, Element> elements = attraction.elements;
IEnumerable<Element> route = from elmt in elements.Values where elmt.type == "Parcours" select elmt;
int i = 0;
foreach (Element ele in route)
{
if (!ToolBox.Instance.settings.savedRoute || (ToolBox.Instance.settings.savedRoute && Load.IsRouteSaved(ele.id, attraction.Id)))
{
Button button = (Button)Instantiate(buttonPrefab);
button.GetComponent<MenuButton>().id = ele.id;
button.GetComponentInChildren<Text>().text = ele.title;
button.transform.SetParent(parentRoute, false);
i++;
}
}
#if LOG
Debug.Log("Number of route: " + i.ToString());
#endif
}
public AttractionBook(Attraction attr)
{
InitializeComponent();
this.attraction = attr;
foreach (Ticket tick in attraction.Ticket)
listBox1.Items.Add(tick.Name);
}
void Awake()
{
_children = new List<Element>();
_transform = transform;
_repulsion = GetComponent<Repulsion>();
_attraction = GetComponent<Attraction>();
_elementsContainer = GameObject.FindGameObjectWithTag("GameManager").GetComponent<ElementsContainer>();
_repulsion.Repulsing += Repulsing;
}
public static Dictionary<string, Attraction> Parse(string json)
{
Dictionary<string, Attraction> attractions = new Dictionary<string, Attraction>();
List<System.Object> listAttractions = Json.Deserialize(json) as List<System.Object>;
foreach (System.Object objAttraction in listAttractions)
{
Dictionary<string, System.Object> dicAttraction = objAttraction as Dictionary<string, System.Object>;
Attraction attraction = new Attraction();
attraction.Id = dicAttraction["id"] as string;
attraction.name = dicAttraction["nom"] as string;
attraction.description = dicAttraction["description"] as string;
attraction.addDate = dicAttraction["dateAjoute"] as string;
attraction.lastModificationDate = dicAttraction["dateModifie"] as string;
attraction.elements = new Dictionary<string, Element>();
List<System.Object> listElements = dicAttraction["elements"] as List<System.Object>;
foreach (System.Object objElement in listElements)
{
Dictionary<string, System.Object> dicElement = objElement as Dictionary<string, System.Object>;
Element element = new Element();
element.id = dicElement["id"] as string;
element.title = dicElement["titre"] as string;
element.description = dicElement["description"] as string;
element.type = dicElement["type"] as string;
element.latitude = dicElement["latitude"] as string;
element.longitude = dicElement["longitude"] as string;
element.elevation = dicElement["elevation"] as string;
element.orientation = dicElement["orientation"] as string;
element.transparency = dicElement["transparence"] as string;
element.ratio = dicElement["ratio"] as string;
element.fileName = dicElement["nomFichier"] as string;
element.addDate = dicElement["eDateAjoute"] as string;
element.lastModificationDate = dicElement["eDateModifie"] as string;
attraction.elements.Add(element.id, element);
}
attractions.Add(attraction.Id, attraction);
}
return attractions;
}
private async void BtnDelete_Click(object sender, RoutedEventArgs e)
{
popup.IsOpen = false;
if (LvAll.SelectedItem != null)
{
try
{
Attraction a = LvAll.SelectedItem as Attraction;
await Task.Run(() => AdminInterface.RemoveAsync(a));
}
catch (Exception ex)
{
popup = ConfigurePopup.Configure(popup, ex.Message, BtnDelete, PlacementMode.Bottom);
popup.IsOpen = true;
}
}
else
{
popup = ConfigurePopup.Configure(popup, "Select item first!", LvAll, PlacementMode.Right);
popup.IsOpen = true;
}
}
public ActionResult AddAttraction(Attraction att)
{
if (ModelState.IsValid)
{
List <Attraction> attractionList = null;
using (StreamReader r = new StreamReader(Server.MapPath("~/data.json")))
{
string json = r.ReadToEnd();
attractionList = JsonConvert.DeserializeObject <List <Attraction> >(json);
}
attractionList.Add(att);
using (StreamWriter w = new StreamWriter(Server.MapPath("~/data.json")))
{
var jsonOut = JsonConvert.SerializeObject(attractionList);
w.Write(jsonOut);
}
return(RedirectToAction("Attractions", "Home"));
}
return(View(att));
}
//[Route("update")]
public IActionResult Update(Attraction attraction)
{
var oldAttraction = _context.Attractions.FirstOrDefault(x => x.Id == attraction.Id);
if (oldAttraction == null)
{
return(NotFound());
}
_context.Entry(oldAttraction).CurrentValues.SetValues(attraction);
try
{
_context.SaveChanges();
return(Ok());
}
catch (DBConcurrencyException e)
{
Console.WriteLine(e);
throw;
}
}
public NavigationPage()
{
InitializeComponent();
gc = GameController.getInstance();
leftArrow.Source = ServerConection.URL_MEDIA + "leftArrow.jpg";
rightArrow.Source = ServerConection.URL_MEDIA + "rightArrow.jpg";
temperature.Source = ServerConection.URL_MEDIA + "thermometer.jpg";
v.Source = ServerConection.URL_MEDIA + "v.png";
odometer.Maximum = 1;
odometer.Minimum = 0;
odometer.MinimumTrackColor = Color.FromHex("#0066ff");
odometer.MaximumTrackColor = Color.FromHex("#0066ff");
odometer.Value = 0;
odometer.WidthRequest = temperature.HeightRequest;
//hintBtn.Padding = 0;
//hintBtn.WidthRequest = hintFrame.Width;
//hintBtn.Margin = new Thickness(
// leftArrow.Width + hintFrame.Margin.Left + hintFrame.Padding.Left - 5,
// 10,
// hintFrame.Margin.Right + hintFrame.Padding.Right,
// 10);
nextAttraction = gc.currentTrip.GetCurrentAttraction();
myMap = MapPage.GetInstance();
mapBtn.Source = ServerConection.URL_MEDIA + "map.png";
//mapBtn = myMap.map;
AttachHint(0);
lc = LocationController.GetInstance();
attractionLoc = new trumpeldor.SheredClasses.Point(nextAttraction.x, nextAttraction.y);
if (isFirst)
{
isFirst = false;
//Task.Run(() => TimerCheck()).ConfigureAwait(false);
//TimerCheck();
}
myMap.AddCurrlocationToMap(gc.GetUserLocation());
TimerCheck();
}
public bool AddAttraction(Attraction attraction)
{
OracleCommand cmd = new OracleCommand("insert_procedure.insert_attraction",
connection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("v_name", OracleDbType.Varchar2).Value = attraction.Name;
cmd.Parameters.Add("v_desc", OracleDbType.Varchar2).Value = attraction.Description;
cmd.Parameters.Add("v_open_time", OracleDbType.Varchar2).Value = DateTime.Parse(attraction.OpenTime.ToString());
cmd.Parameters.Add("v_close_time", OracleDbType.Varchar2).Value = DateTime.Parse(attraction.CloseTime.ToString());
cmd.Parameters.Add("v_phone_number", OracleDbType.Varchar2).Value = attraction.PhoneNumber;
cmd.Parameters.Add("v_image", OracleDbType.Varchar2).Value = attraction.ImagePath;
cmd.Parameters.Add("v_attraction_type_id", OracleDbType.Int32).Value = attraction.AttractionType.Id;
cmd.Parameters.Add("v_location_id", OracleDbType.Int32).Value = AddLocation(attraction.Location);
cmd.Parameters.Add("v_user_id", OracleDbType.Int32).Value = attraction.User.Id;
try
{
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.ToString());
return(false);
}
finally
{
DataBaseConnection.GetDbInstance().CloseDBConnection();
}
}
public List <Attraction> SelectByType(string filterType) //get same type from attraction db and put into list
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlStmt = "Select * from Attraction where attractionType = @paraType";
SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn);
da.SelectCommand.Parameters.AddWithValue("@paraType", filterType);
DataSet ds = new DataSet();
da.Fill(ds);
List <Attraction> empList = new List <Attraction>();
int rec_cnt = ds.Tables[0].Rows.Count;
for (int i = 0; i < rec_cnt; i++)
{
DataRow row = ds.Tables[0].Rows[i];
int id = int.Parse(row["attractionId"].ToString());
string name = row["attractionName"].ToString();
string image = row["attractionImage"].ToString();
string price = row["attractionPrice"].ToString();
string date = row["DateTime"].ToString();
string desc = row["attractionDesc"].ToString();
string loc = row["attractionLocation"].ToString();
decimal lat = decimal.Parse(row["attractionLatitude"].ToString());
decimal lon = decimal.Parse(row["attractionLongitude"].ToString());
string interest = row["attractionInterest"].ToString();
string type = row["attractionType"].ToString();
string transaction = row["attractionTransaction"].ToString();
Attraction obj = new Attraction(id, name, image, price, date, desc, loc, lat, lon, interest, type, transaction);
empList.Add(obj);
}
return(empList);
}
public Tuple <bool, List <Attraction> > getAttractionsByCity(City city, string begin)
{
bool result = true;
List <Attraction> attractions = new List <Attraction>();
string command = "SELECT a.attraction_code, a.name, a.city_id, a.type " +
"FROM city c join attraction a ON c.city_id = a.city_id " +
"WHERE c.name LIKE '" + begin + "%'";
if (city != null)
{
string c = "'" + city.Name + "'";
command += " AND c.name=" + c;
}
command += ";";
lock (DbConnection.Locker)
{
MySqlDataReader dr = DbConnection.ExecuteQuery(command);
if (dr != null)
{
while (dr.Read())
{
string id = dr.GetString("attraction_code");
string name = dr.GetString("name");
string city_id = dr.GetString("city_id");
string type = dr.GetString("type");
Attraction a = new Attraction(id, name, city_id, type);
attractions.Add(a);
}
dr.Close();
}
else
{
result = false;
}
}
return(new Tuple <bool, List <Attraction> >(result, attractions));
}
public ActionResult Attractions(int count)
{
Random random = new Random();
for (int i = 0; i < count; ++i)
{
int lat = random.Next(10) > 5 ? 1 : -1;
int lon = random.Next(10) > 5 ? 1 : -1;
Attraction attraction = new Attraction();
attraction.Address = new Address();
attraction.Address.City = db.Place.OrderBy(x => x.ID).Skip(random.Next(db.Place.Count() - 1)).FirstOrDefault().Name;
attraction.AttractionType = db.AttractionType.OrderBy(x => x.ID).Skip(random.Next(db.AttractionType.Count() - 1)).FirstOrDefault();
attraction.Coordinates = new Coordinates();
attraction.Coordinates.Latitude = random.NextDouble() * 90 * lat;
attraction.Coordinates.Longitude = random.NextDouble() * 180 * lon;
attraction.Country = db.Country.OrderBy(x => x.ID).Skip(random.Next(db.Country.Count() - 1)).FirstOrDefault();
attraction.Description = generateRandomText(random.Next(3, 10));
attraction.Name = "Attraction " + i.ToString();
db.Attraction.Add(attraction);
db.SaveChanges();
}
return(RedirectToAction("Index", "Attraction"));
}
public IEnumerator UpgradeAttractionWithMoney()
{
List <Vector2Int> positionList =
wcObject.GetPositionList(new Vector2Int(0, 0), BuildingTypeSO.Direction.Down);
gameManager.Money = 9999;
Building wc = Building.SpawnBuilding(Vector3.zero, new Vector2Int(0, 0), BuildingTypeSO.Direction.Down, wcObject, positionList);
yield return(new WaitForSeconds(0.1f));
Attraction help = (Attraction)wc;
GameObject empty = new GameObject();
help.brokeVisual = empty.transform;
help.BreakBuilding();
yield return(new WaitForSeconds(0.1f));
bool helpBool = gameManager.UpgradeBuilding((Attraction)(wc));
yield return(new WaitForSeconds(0.1f));
Assert.IsFalse(false);
}
public async Task <bool> AddAttractionToCity(int attractionId, int cityId)
{
City city = GetById(cityId).Result;
if (CheckIfExists(city))
{
List <Attraction> attractions = city.attractions.ToList();
Attraction attraction = await _context.Attractions.FirstOrDefaultAsync(attraction => attraction.id == attractionId);
if (attraction == null)
{
return(false);
}
attractions.Add(attraction);
city.attractions = attractions;
await Update(city);
return(true);
}
return(false);
}
public IEnumerator RepairAttractionWithMoneyButNoAvaliableMechanics()
{
test = false;
List <Vector2Int> positionList =
wcObject.GetPositionList(new Vector2Int(0, 0), BuildingTypeSO.Direction.Down);
gameManager.Money = 99999;
Building wc = Building.SpawnBuilding(Vector3.zero, new Vector2Int(0, 0), BuildingTypeSO.Direction.Down, wcObject, positionList);
yield return(new WaitForSeconds(0.1f));
Attraction help = (Attraction)wc;
GameObject empty = new GameObject();
help.brokeVisual = empty.transform;
help.BreakBuilding();
yield return(new WaitForSeconds(0.1f));
gameManager.RepairAttraction((Attraction)(wc));
yield return(new WaitForSeconds(0.1f));
Assert.AreEqual(99999, gameManager.Money);
}
public Attraction SelectById(string attId) //get the attraction info by Id
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlstmt = "Select * from Attraction where attractionId = @paraId";
SqlDataAdapter da = new SqlDataAdapter(sqlstmt, myConn);
da.SelectCommand.Parameters.AddWithValue("@paraId", attId);
DataSet ds = new DataSet();
da.Fill(ds);
int rec_cnt = ds.Tables[0].Rows.Count;
Attraction td = null;
if (rec_cnt > 0)
{
DataRow row = ds.Tables[0].Rows[0];
int id = int.Parse(row["attractionId"].ToString());
string name = row["attractionName"].ToString();
string image = row["attractionImage"].ToString();
string price = row["attractionPrice"].ToString();
string date = row["DateTime"].ToString();
string desc = row["attractionDesc"].ToString();
string loc = row["attractionLocation"].ToString();
decimal lat = decimal.Parse(row["attractionLatitude"].ToString());
decimal lon = decimal.Parse(row["attractionLongitude"].ToString());
string interest = row["attractionInterest"].ToString();
string type = row["attractionType"].ToString();
string transaction = row["attractionTransaction"].ToString();
td = new Attraction(id, name, image, price, date, desc, loc, lat, lon, interest, type, transaction);
}
return(td);
}
public ActionResult Create(Attraction attraction)
{
attraction.AttractionType = db.AttractionType.Find(attraction.AttractionType.ID);
attraction.Country = db.Country.Find(attraction.Country.ID);
attraction.AvgRating = 0.0;
//upload photos
try
{
int i = 0;
foreach (string upload in Request.Files)
{
if (Request.Files[i].ContentLength == 0)
{
continue;
}
string path = AppDomain.CurrentDomain.BaseDirectory + "Content/AttractionImages/";
string ext = Request.Files[i].FileName.Substring(Request.Files[i].FileName.LastIndexOf('.'));
AttractionImage ai = new AttractionImage {
AttractionID = attraction.ID, FileName = generateRandomString(32) + ext
};
attraction.Images.Add(ai);
Request.Files[i].SaveAs(Path.Combine(path, ai.FileName));
i++;
}
}
catch (NullReferenceException)
{
//no photo
}
//end of upload user photo
db.Attraction.Add(attraction);
db.SaveChanges();
return(RedirectToAction("Details", new { id = attraction.ID }));
}
public ITrip CreateTrip()
{
ITrip trip = travelAgency.CreateTrip();
trip.Country = "France";
IAttraction attraction;
for (int i = 0; i < trip.DaysCount; i++)
{
for (int j = 0; j < 3; j++)
{
do
{
if (tripAdvisorIterator.HasNext())
{
attraction = tripAdvisorIterator.GetCurrent();
attraction.Rating = tripAdvisorDescrambler.Handle(attraction.Rating);
attraction.Price = tripAdvisorDescrambler.Handle(attraction.Price);
}
else
{
tripAdvisorIterator.Reset();
if (!tripAdvisorIterator.HasNext())
{
attraction = new Attraction();
break;
}
attraction = tripAdvisorIterator.GetCurrent();
attraction.Rating = tripAdvisorDescrambler.Handle(attraction.Rating);
attraction.Price = tripAdvisorDescrambler.Handle(attraction.Price);
}
} while (attraction.Country != "France");
trip.Attractions[i].Add(attraction);
}
}
return(trip);
}
public SlidingPuzzlePage(SlidingPuzzle sp, Attraction attraction)
{
InitializeComponent();
this.gc = GameController.getInstance();
subtitles.Source = ServerConection.URL_MEDIA + "subtitles.jpg";
info.Source = ServerConection.URL_MEDIA + "info.jpg";
playVideo.Source = ServerConection.URL_MEDIA + "playVideo.jpg";
how.Source = ServerConection.URL_MEDIA + "how.png";
this.sp = sp;
taps = new List <Tuple <int, int> >();
tiles = new SlidingPuzzleTile[sp.width, sp.height];
emptyRow = sp.width - 1;
emptyCol = sp.height - 1;
this.attraction = attraction;
for (int row = 0; row < sp.width; row++)
{
for (int col = 0; col < sp.height; col++)
{
if (row == emptyRow && col == emptyCol)
{
break;
}
SlidingPuzzleTile tile = new SlidingPuzzleTile(row, col, sp.piecesURLS[row * sp.width + col]);
TapGestureRecognizer tapGestureRecognizer = new TapGestureRecognizer();
tapGestureRecognizer.Tapped += OnTileTapped;
tile.TileView.GestureRecognizers.Add(tapGestureRecognizer);
tiles[row, col] = tile;
absoluteLayout.Children.Add(tile.TileView);
}
}
shuffle();
}
public void DisplayDetails(Attraction building)
{
buyMenu.SetActive(false);
BuySelect.instance.SetCheck();
selectedBuilding = building;
display.gameObject.SetActive(true);
nameText.text = building.Name;
level.text = "Level: " + building.Level;
capacity.text = "Capacity: " + building.CurrentVisitorCount + "/" + building.TotalCapacity;
upkeep.text = "Upkeep: -" + Math.Round(building.DailyUpkeep, 0) + "$";
income.text = "Income: " + Math.Round(building.CurrentDailyIncome, 0) + "$";
netIncome.text = "Net Income: " + Math.Round(building.CurrentDailyIncome - building.DailyUpkeep, 0) + "$";
upgradePrice.text = Math.Round(building.UpgradePrice, 0) + "$";
repairPrice.text = Math.Round((building.Value * 0.1f), 0) + "$";
if (previewModelObject != null)
{
Destroy(previewModelObject.gameObject);
}
previewModelObject = Instantiate(building.Type.uiPrefab, previewModel);
if (!selectedBuilding.Broke)
{
repairButton.interactable = false;
}
else if (selectedBuilding.beingRepaired || GameManager.instance.availableMechanics <= 0)
{
repairButton.interactable = false;
}
else
{
repairButton.interactable = true;
}
inspectorOpen = true;
}
static void Main(string[] args)
{
int numberOfAttractions = int.Parse(Console.ReadLine());
List<Attraction> attractions = new List<Attraction>();
for (int attractionNumber = 0; attractionNumber < numberOfAttractions; attractionNumber++)
{
string[] attractionInput = Console.ReadLine().Split(' ');
Attraction attraction = new Attraction();
attraction.id = int.Parse(attractionInput[0]);
attraction.position.latitude = double.Parse(attractionInput[1], CultureInfo.InvariantCulture);
attraction.position.longitude = double.Parse(attractionInput[2], CultureInfo.InvariantCulture);
attractions.Add(attraction);
}
int testNumber = int.Parse(Console.ReadLine());
while (testNumber-- > 0)
{
Point travelerPosition = new Point();
string[] restrictions = Console.ReadLine().Split(' ');
travelerPosition.latitude = double.Parse(restrictions[0], CultureInfo.InvariantCulture);
travelerPosition.longitude = double.Parse(restrictions[1], CultureInfo.InvariantCulture);
double speed = GetSpeed(restrictions[2]);
double minutes = double.Parse(restrictions[3]);
List<Attraction> goodAttractions = new List<Attraction>();
for (int i = 0; i < attractions.Count; i++)
{
Attraction attr = attractions[i];
attr.distance = GetDistance(travelerPosition, attr.position);
if (attr.distance / speed * 60.0 <= minutes)
{
goodAttractions.Add(attr);
}
}
for (int i = 0; i < goodAttractions.Count - 1; i++)
{
for (int j = i + 1; j < goodAttractions.Count; j++)
{
if (goodAttractions[i].distance > goodAttractions[j].distance)
{
Attraction tmp = goodAttractions[i];
goodAttractions[i] = goodAttractions[j];
goodAttractions[j] = tmp;
}
}
}
for (int i = 0; i < goodAttractions.Count - 1; i++)
{
for (int j = i + 1; j < goodAttractions.Count; j++)
{
if (goodAttractions[i].distance == goodAttractions[j].distance)
{
if (goodAttractions[i].id > goodAttractions[j].id)
{
Attraction tmp = goodAttractions[i];
goodAttractions[i] = goodAttractions[j];
goodAttractions[j] = tmp;
}
}
}
}
foreach(Attraction attr in goodAttractions)
{
Console.Write(attr.id+" ");
}
Console.WriteLine();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
//Showing result when user search by bookings by booking id
lblCustomer.Visible = false;
dlCustomer.Visible = false;
lblTitle.Text = "Search Results";
gvUpcoming.Visible = false;
gvHistory.Visible = false;
//Getting current signed in user
Attraction attraction = (Attraction)Session["userAttraction"];
//Getting booked rooms from session and display them
List <ItemBooking> itemList = (List <ItemBooking>)Session["Upcoming"];
List <ItemBooking> itemList2 = (List <ItemBooking>)Session["History"];
List <ItemBooking> upcoming = new List <ItemBooking>();
List <ItemBooking> history = new List <ItemBooking>();
//Searching in upcoming bookings
if (itemList != null)
{
foreach (ItemBooking it in itemList)
{
if (tbxBookingID.Text == it.BookingID.BookingID.ToString())
{
//showing results for upcoming bookings
ItemBooking item = it;
upcoming.Add(item);
gvUpcoming.DataSource = upcoming;
gvUpcoming.DataBind();
gvUpcoming.Visible = true;
lblNoResult.Visible = false;
}
else
{
lblNoResult.Text = "Sorry! No booking is found!";
}
}
}
//Searching in past booking
if (itemList2 != null)
{
foreach (ItemBooking it in itemList2)
{
if (tbxBookingID.Text == it.BookingID.BookingID.ToString())
{
//showing results for past bookings
ItemBooking item = it;
history.Add(item);
gvHistory.DataSource = history;
gvHistory.DataBind();
lblNoResult.Text = "";
gvHistory.Visible = true;
}
else
{
lblNoResult.Text = "Sorry! No booking is found!";
}
}
}
//if booking is not found
if (itemList == null && itemList2 == null)
{
lblNoResult.Text = "Sorry! No booking is found!";
}
//if user click search without providing booking id, it will show upcoming bookings
if (tbxBookingID.Text == "")
{
lblNoResult.Text = "";
lblTitle.Text = "Upcoming Booking";
List <ItemBooking> itemList3 = (List <ItemBooking>)Session["Upcoming"];
//Showing upcoming bookings
gvUpcoming.DataSource = itemList3;
gvUpcoming.DataBind();
gvHistory.Visible = false;
gvUpcoming.Visible = true;
}
}
void SetFeedingtimeBlocks()
{
List <Animal> TempAnimalList = new List <Animal>();
Animal animal;
for (int i = AttractionDataBase.Attractions.Count - 1; i > 0; i--)
{
Attraction attraction = AttractionDataBase.Attractions[i];
if (attraction is Animal && (attraction as Animal).HasFeedingTime && (attraction as Animal).IsInSeason)
{
animal = (attraction as Animal);
TempAnimalList.Add(animal);
}
}
TempAnimalList = TempAnimalList.OrderBy(x => x.NextFeeding).ToList();
LinearLayout Scheme = FindViewById <LinearLayout>(Resource.Id.FeedingTimeSchemeLayout);
LinearLayout Text = FindViewById <LinearLayout>(Resource.Id.FeedingTimeSchemeText);
LinearLayout Root = FindViewById <LinearLayout>(Resource.Id.FeedingTimeSchemeRoot);
Random rng = new Random();
int index = 0;
foreach (Animal a in TempAnimalList)
{
View animalText = LayoutInflater.Inflate(Resource.Layout.AnimalFeedingText, Text, false);
Color[] colours = new Color[] { Color.Red, Color.Green, Color.Blue, Color.Yellow, Color.Red, Color.Green, Color.Blue, Color.Yellow, Color.Red, Color.Green, Color.Blue, Color.Yellow, Color.Red, Color.Green, Color.Blue, Color.Yellow };
LinearLayout horizontalAnimalLayout = (LinearLayout)LayoutInflater.Inflate(Resource.Layout.LinearLayout, Scheme, false);
LinearLayout.LayoutParams LL = new LinearLayout.LayoutParams(24 * 60 * 5, feedingtimeLineHeight);
horizontalAnimalLayout.Orientation = Orientation.Horizontal;
// horizontalAnimalLayout.SetBackgroundColor(colours[index]);
horizontalAnimalLayout.LayoutParameters = LL;
Scheme.AddView(horizontalAnimalLayout);
LinearLayout.LayoutParams animalTextLL = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.FillParent, feedingtimeLineHeight);
animalText.LayoutParameters = animalTextLL;
if ((animalText as ViewGroup).GetChildAt(0) is ImageView)
{
System.IO.Stream ims = Assets.Open("img/AnimalHeaders/" + (a as Animal).ImageName + "Header.png");
// load image as Drawable
Bitmap bitmap = BitmapFactory.DecodeStream(ims);
ims.Close();
((animalText as ViewGroup).GetChildAt(0) as ImageView).SetImageBitmap(bitmap);
((animalText as ViewGroup).GetChildAt(0) as ImageView).Click += delegate {
selectedAnimal = a;
PopupMenu menu = new PopupMenu(this, ((animalText as ViewGroup).GetChildAt(0) as ImageView));
menu.MenuInflater.Inflate(Resource.Layout.FeedingAlarmMenu, menu.Menu);
menu.Show();
IMenuItem item = menu.Menu.FindItem(Resource.Id.MenuReminderButton);
menu.MenuItemClick += delegate {
Console.WriteLine(selectedAnimal.Name + AttractionDataBase.animalsToWatch.Contains(selectedAnimal));
foreach (Animal an in AttractionDataBase.animalsToWatch)
{
Console.WriteLine(an.Name);
}
if (AttractionDataBase.animalsToWatch.Contains(selectedAnimal))
{
AttractionDataBase.animalsToWatch.Remove(selectedAnimal);
}
else
{
AttractionDataBase.animalsToWatch.Add(selectedAnimal);
Console.WriteLine("ADDING");
}
};
if (AttractionDataBase.animalsToWatch.Contains(selectedAnimal))
{
item.SetTitle("Fjern påmindese?");
}
else
{
item.SetTitle("Sæt påmindelse?");
}
SpannableString spanString = new SpannableString(item.TitleFormatted);
int end = spanString.Length();
spanString.SetSpan(new RelativeSizeSpan(0.8f), 0, end, SpanTypes.ExclusiveExclusive);
item.SetTitle(spanString);
};
}
if ((animalText as ViewGroup).GetChildAt(1) is LinearLayout)
{
((animalText as ViewGroup).GetChildAt(1) as LinearLayout).LayoutParameters.Height = feedingtimeLineHeight;
}
Text.AddView(animalText);
LinearLayout.LayoutParams horizontalLine = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.MatchParent, 2);
View textLine = LayoutInflater.Inflate(Resource.Layout.line, Text, false);
textLine = LayoutInflater.Inflate(Resource.Layout.line, Text, false);
textLine.LayoutParameters = horizontalLine;
textLine.SetBackgroundColor(Color.ParseColor("#000000"));
int feedingtimeCounter = 0;
foreach (FeedingTime FT in a.FeedingTimes)
{
//set the destination
View animalBlock = LayoutInflater.Inflate(Resource.Layout.AnimalFeedingBlock, (LinearLayout)Scheme.GetChildAt(index), false);
//Find the text and linearlayout children
LinearLayout.LayoutParams animalBlockParams = new LinearLayout.LayoutParams((animalBlock as LinearLayout).LayoutParameters.Width = FT.ShowLength * 5, feedingtimeLineHeight);
(animalBlock as LinearLayout).LayoutParameters = animalBlockParams;
//((animalBlock as ViewGroup).GetChildAt(i) as LinearLayout).Left = FT.TimeOfDay.Hour * 60 * 5 + FT.TimeOfDay.Second * 5;
int timeBeforeCurrentFeedingtime = 0;
for (int i = 0; i < feedingtimeCounter; i++)
{
timeBeforeCurrentFeedingtime += a.FeedingTimes[i].TimeOfDay.Hour * 60 * 5 + a.FeedingTimes[i].TimeOfDay.Minute * 5 + a.FeedingTimes[i].ShowLength * 5 + 25;
}
animalBlockParams.LeftMargin = (int)(FT.TimeOfDay.Hour * 60 + FT.TimeOfDay.Minute)
* 5 + 25 - timeBeforeCurrentFeedingtime;
(animalBlock as LinearLayout).SetBackgroundColor(Color.ParseColor("#e6e8ed"));
(animalBlock as LinearLayout).LayoutParameters.Height = feedingtimeLineHeight;
((animalBlock as ViewGroup).GetChildAt(0) as TextView).Text = (FT.TimeOfDay.Hour.ToString("00") + ":" + FT.TimeOfDay.Minute.ToString("00"));
(Scheme.GetChildAt(index) as LinearLayout).AddView(animalBlock);
feedingtimeCounter++;
}
View blockLine = LayoutInflater.Inflate(Resource.Layout.line, Scheme, false);
horizontalLine = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.MatchParent, 2);
blockLine.LayoutParameters = horizontalLine;
blockLine.SetBackgroundColor(Color.ParseColor("#000000"));
Scheme.AddView(blockLine);
index += 2;
Text.AddView(textLine);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
//get admin from database
Admin d = AdminDB.getAdminbyID(tbxEmail.Text, tbxPassword.Text);
if (d != null) //if admin is not null
{
if (d.AdminID == tbxEmail.Text) //check the admin id from database, matched or not
{
if (d.Password == tbxPassword.Text) //check the admin password from database, matched or not
{
//create a session for admin
Session["admin"] = d;
//redirect to AdminView page
Server.Transfer("AdminView.aspx");
}
}
}
else
{
lblOutput.Text = "sorry admin cannot login!"; //to show error message
}
if (ddlCustOrg.SelectedItem.Text == "Customer") //user selected on customer
{
Customer c = CustomerDB.getCustomerByEmail(tbxEmail.Text, tbxPassword.Text); //get the customer details from database
if (c != null) //if customer is not null
{
//customer email and password must matched from the databse
if (c.CustEmail == tbxEmail.Text)
{
if (c.Password == tbxPassword.Text)
{
//create session for user
Session["user"] = c;
Session["emailUser"] = c.CustEmail;
//redirect to the default page
Server.Transfer("Default.aspx");
}
else
{
lblOutput.Text = "Incorrect password"; //show error message
}
}
}
else
{
lblOutput.Text = "Incorrect email/password"; //show error message
}
}
else if (ddlCustOrg.SelectedItem.Text == "Hotel Owner") //user selected on hotel owner
{
Hotel h = HotelDB.getHotelByEmail(tbxEmail.Text, tbxPassword.Text); //get the data from database
//check the data is not null
if (h != null)
{
//email and password must matched into the database
if (h.OrgEmail == tbxEmail.Text)
{
if (h.Password == tbxPassword.Text)
{
//create session for user
Session["userHotel"] = h;
Session["hotelEmail"] = h.OrgEmail;
Session["hotelID"] = h.HotelID;
//redirect to the default page
Server.Transfer("Default.aspx");
}
else
{
lblOutput.Text = "Incorrect password"; //show error message
}
}
}
else
{
lblOutput.Text = "Incorrect email/password"; //show error message
}
}
else if (ddlCustOrg.SelectedItem.Text == "Restaurant Owner") //user selected on the restaurant owner
{
//get the data from database
Restaurant r = RestaurantDB.getRestaurantByEmail(tbxEmail.Text, tbxPassword.Text);
//check the data is not null
if (r != null)
{
//email and password must matched into database
if (r.OrgEmail == tbxEmail.Text)
{
if (r.Password == tbxPassword.Text)
{
//create session for user
Session["userRestaurant"] = r;
Session["restaurantEmail"] = r.OrgEmail;
Session["restaurantID"] = r.RestaurantID;
//redirect to the default page
Server.Transfer("Default.aspx");
}
else
{
lblOutput.Text = "Incorrect password"; //show error message
}
}
}
else
{
lblOutput.Text = "Incorrect email/password"; //show error message
}
}
else if (ddlCustOrg.SelectedItem.Text == "Attraction Owner") //user selected on the attraction owner
{
//get the data from database
Attraction a = AttractionDB.getAttractionByEmail(tbxEmail.Text, tbxPassword.Text);
//check the data if not null
if (a != null)
{
//email and password must matched into our database
if (a.OrgEmail == tbxEmail.Text)
{
if (a.Password == tbxPassword.Text)
{
//create session for user
Session["userAttraction"] = a;
Session["attractionEmail"] = a.OrgEmail;
Session["attractionID"] = a.AttractionID;
//redirect to the default page
Server.Transfer("Default.aspx");
}
else
{
lblOutput.Text = "Incorrect password"; //show error message
}
}
}
else
{
lblOutput.Text = "Incorrect email/password"; //show error message
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//initialize the random number generator
Random r = new Random();
//set the new password from random number generator
int newPw = r.Next(1, 100000);
int result = 0; //initialze the result
bool found = true; //initialize the boolean is true
if (ddlCustOrg.SelectedItem.Text == "Customer") //when user choose to reset password for customer
{
//get the customer from database
Customer c = CustomerDB.getACustomerByEmail(tbxEmail.Text);
if (c != null) //if the customer is not null
{
c.Password = newPw.ToString(); //set the new password
result = CustomerDB.updateCustomer(c); //update into customer database
}
else
{
found = false; //cannot find the customer from the database
}
}
else if (ddlCustOrg.SelectedItem.Text == "Hotel Owner") //when user choose to reset password for hotel owner
{
Hotel h = HotelDB.getAHotelByEmail(tbxEmail.Text); //get the hotel owner from database
if (h != null) //if the hotel is not null
{
h.Password = newPw.ToString(); //set the new password
result = HotelDB.updateHotel(h); //update into hotel database
}
else
{
found = false; //cannot find the hotel owner from the database
}
}
else if (ddlCustOrg.SelectedItem.Text == "Attraction Owner") //when user choose to reset password for attraction
{
Attraction a = AttractionDB.getAAttractionByEmail(tbxEmail.Text); //get the attraction owner from database
if (a != null) //if the attraction is not null
{
//set the new password
a.Password = newPw.ToString();
//update into attraction database
result = AttractionDB.updateAttraction(a);
}
else
{
found = false; //canoot find the attraction from the database
}
}
else if (ddlCustOrg.SelectedItem.Text == "Restaurant Owner") //when user choose to reset password for restaurant owner
{
Restaurant ra = RestaurantDB.getARestaurantByEmail(tbxEmail.Text); //get the restaurant owner from database
if (ra != null) //if the restaurant is not null
{
//set the new password
ra.Password = newPw.ToString();
//update into restaurant database
result = RestaurantDB.updateRestaurant(ra);
}
else
{
found = false; //cannot find the restaurant from the database
}
}
if (found) //if found
{
if (result > 0) //result cannot be zero
{
try //use try and catch to send an email to the organization and customer
{
SmtpClient client = new SmtpClient("smtp.gmail.com");
client.EnableSsl = true;
client.Credentials = new NetworkCredential("*****@*****.**", "smart-travel1005");
MailMessage msg = new MailMessage("*****@*****.**", tbxEmail.Text);
msg.Subject = "New Password";
msg.Body = "Your new password is: " + newPw.ToString() + "\r\n Please change your password again";
client.Send(msg); //send an email
lblOutput.Text = "New Password has been sent to your email";
return;
}
catch (Exception ex)
{
lblOutput.Text = "Active internet connection needed!"; //show error message when user do not have internet connection
return;
}
}
else
{
lblOutput.Text = "Fails to update the password"; //show error message when user cannot update the password
return;
}
}
lblOutput.Text = "Account with this email address does not exist. Sign up for the account"; //if the account is not exist with our website
}
static void Main(string[] args)
{
int numberOfAttractions = int.Parse(Console.ReadLine());
List <Attraction> attractions = new List <Attraction>();
for (int attractionNumber = 0; attractionNumber < numberOfAttractions; attractionNumber++)
{
string[] attractionInput = Console.ReadLine().Split(' ');
Attraction attraction = new Attraction();
attraction.id = int.Parse(attractionInput[0]);
attraction.position.latitude = double.Parse(attractionInput[1], CultureInfo.InvariantCulture);
attraction.position.longitude = double.Parse(attractionInput[2], CultureInfo.InvariantCulture);
attractions.Add(attraction);
}
int testNumber = int.Parse(Console.ReadLine());
while (testNumber-- > 0)
{
Point travelerPosition = new Point();
string[] restrictions = Console.ReadLine().Split(' ');
travelerPosition.latitude = double.Parse(restrictions[0], CultureInfo.InvariantCulture);
travelerPosition.longitude = double.Parse(restrictions[1], CultureInfo.InvariantCulture);
double speed = GetSpeed(restrictions[2]);
double minutes = double.Parse(restrictions[3]);
List <Attraction> goodAttractions = new List <Attraction>();
for (int i = 0; i < attractions.Count; i++)
{
Attraction attr = attractions[i];
attr.distance = GetDistance(travelerPosition, attr.position);
if (attr.distance / speed * 60.0 <= minutes)
{
goodAttractions.Add(attr);
}
}
for (int i = 0; i < goodAttractions.Count - 1; i++)
{
for (int j = i + 1; j < goodAttractions.Count; j++)
{
if (goodAttractions[i].distance > goodAttractions[j].distance)
{
Attraction tmp = goodAttractions[i];
goodAttractions[i] = goodAttractions[j];
goodAttractions[j] = tmp;
}
}
}
for (int i = 0; i < goodAttractions.Count - 1; i++)
{
for (int j = i + 1; j < goodAttractions.Count; j++)
{
if (goodAttractions[i].distance == goodAttractions[j].distance)
{
if (goodAttractions[i].id > goodAttractions[j].id)
{
Attraction tmp = goodAttractions[i];
goodAttractions[i] = goodAttractions[j];
goodAttractions[j] = tmp;
}
}
}
}
foreach (Attraction attr in goodAttractions)
{
Console.Write(attr.id + " ");
}
Console.WriteLine();
}
}
public void DeleteAttraction(Attraction attraction)
{
_context.Attractions.Remove(attraction);
}
public UpdateAttraction(Attraction attraction, IAdminInterface <Attraction> adminInterface)
{
InitializeComponent();
Attraction = attraction;
AdminInterface = adminInterface;
}
public void Repair(Attraction repairTarget)
{
targeted = repairTarget;
GoToBuilding(targeted);
}
public void UpdateAttractionForDestination(Attraction attraction)
{
// no code in this implementation
}
private void DG1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
objEmpToEdit = DG1.SelectedItem as Attraction;
}
public void GetDestination()
{
attractionDest = AttractionManager.Instance.GetAttraction();
}
public static void InitializeDb(ApplicationDbContext context, string adminId)
{
if (context.ParkInfo.Any())
{
return;
}
var pinfo = new ParkInfo[]
{
new ParkInfo
{
Name = "Houston Theme Park",
Country = "USA",
State = "TX",
City = "Houston",
ZipCode = "77042",
StreetNumber = "11223",
StreetName = "Grant Rd"
},
};
foreach (ParkInfo pi in pinfo)
{
context.ParkInfo.Add(pi);
}
context.SaveChanges();
var phours = new ParkHour[]
{
new ParkHour
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
FirstDayOpen = "Monday",
LastDayOpen = "Saturday",
WorkingHours = "8:00am - 10:00pm"
}
};
foreach (ParkHour ph in phours)
{
var parkHoursInDatabase = context.ParkHours.Where(s => s.ParkInfo.Id == ph.ParkInfoId).SingleOrDefault();
if (parkHoursInDatabase == null)
{
context.ParkHours.Add(ph);
}
}
context.SaveChanges();
var weather = new Weather[]
{
new Weather
{
Date = DateTime.Parse("2009-10-03"),
Rainout = false,
Temperature = 70.0m,
InchesOfRain = 0.0m
}
};
foreach (Weather w in weather)
{
context.Weathers.Add(w);
}
context.SaveChanges();
var dreports = new DailyReport[]
{
new DailyReport
{
WeatherId = weather.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id,
Date = DateTime.Parse("2009-10-03")
}
};
foreach (DailyReport dr in dreports)
{
context.DailyReports.Add(dr);
}
context.SaveChanges();
var locations = new Location[]
{
new Location {
Name = "North"
},
new Location {
Name = "East"
},
new Location {
Name = "West"
},
new Location {
Name = "South"
},
new Location {
Name = "Center"
}
};
foreach (Location l in locations)
{
context.Locaitons.Add(l);
}
context.SaveChanges();
var atypes = new AttractionType[]
{
new AttractionType {
Name = "Roller Coaster"
},
new AttractionType {
Name = "Merry go Round"
},
new AttractionType {
Name = "Farris Wheel"
},
new AttractionType {
Name = "Haunted House"
},
new AttractionType {
Name = "Water Slide"
}
};
foreach (AttractionType at in atypes)
{
context.AttractionTypes.Add(at);
}
context.SaveChanges();
var attractions = new Attraction[]
{
new Attraction
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
AttractionTypeId = atypes.Single(s => s.Name == "Haunted House").Id,
LocationId = locations.Single(s => s.Name == "North").Id,
Name = "Spooky House",
Description = "Boo!",
},
new Attraction
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
AttractionTypeId = atypes.Single(s => s.Name == "Roller Coaster").Id,
LocationId = locations.Single(s => s.Name == "East").Id,
Name = "Wild Ride",
Description = "Wee!",
},
new Attraction
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
AttractionTypeId = atypes.Single(s => s.Name == "Water Slide").Id,
LocationId = locations.Single(s => s.Name == "West").Id,
Name = "Water Snake",
Description = "Hiss!",
},
new Attraction
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
AttractionTypeId = atypes.Single(s => s.Name == "Farris Wheel").Id,
LocationId = locations.Single(s => s.Name == "South").Id,
Name = "Great View",
Description = "Ooh!",
},
new Attraction
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
AttractionTypeId = atypes.Single(s => s.Name == "Merry go Round").Id,
LocationId = locations.Single(s => s.Name == "Center").Id,
Name = "Spinner",
Description = "Woha!",
}
};
foreach (Attraction a in attractions)
{
var attractionsInDatabase = context.Attractions.Where
(s => s.ParkInfo.Id == a.ParkInfoId).SingleOrDefault();
if (attractionsInDatabase == null)
{
context.Attractions.Add(a);
}
}
context.SaveChanges();
var avisits = new AttractionVisit[]
{
new AttractionVisit {
VisitDate = DateTime.Parse("2008-01-20"), AttractionId = attractions.Single(s => s.Name == "Spinner").Id, DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new AttractionVisit {
VisitDate = DateTime.Parse("2008-01-20"), AttractionId = attractions.Single(s => s.Name == "Great View").Id, DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new AttractionVisit {
VisitDate = DateTime.Parse("2008-01-20"), AttractionId = attractions.Single(s => s.Name == "Water Snake").Id, DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new AttractionVisit {
VisitDate = DateTime.Parse("2008-01-20"), AttractionId = attractions.Single(s => s.Name == "Wild Ride").Id, DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new AttractionVisit {
VisitDate = DateTime.Parse("2008-01-20"), AttractionId = attractions.Single(s => s.Name == "Spooky House").Id, DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
}
};
foreach (AttractionVisit av in avisits)
{
var attractionVisitsInDatabase = context.AttractionVisits.Where
(s => s.Attraction.Id == av.AttractionId &&
s.DailyReport.Id == av.DailyReportId).SingleOrDefault();
if (attractionVisitsInDatabase == null)
{
context.AttractionVisits.Add(av);
}
}
context.SaveChanges();
var mrequest = new Maintenance[]
{
new Maintenance
{
AttractionId = 1,
Description = "Spooky House as a leeky pipe",
DateRecieved = DateTime.Parse("2009-10-03"),
DateResolved = DateTime.Parse("2009-10-03"),
CurrentStatus = "Still leaky",
Cost = 53.96m,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
}
};
foreach (Maintenance m in mrequest)
{
var maintenanceInDatabase = context.Maintenances.Where
(s => s.Attraction.Id == m.AttractionId &&
s.DailyReport.Id == m.DailyReportId).SingleOrDefault();
if (maintenanceInDatabase == null)
{
context.Maintenances.Add(m);
}
}
context.SaveChanges();
var departments = new Department[]
{
new Department
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
LocationId = locations.Single(s => s.Name == "Center").Id,
Name = "Management"
},
new Department
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
LocationId = locations.Single(s => s.Name == "West").Id,
Name = "Maintenance"
},
new Department
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
LocationId = locations.Single(s => s.Name == "Center").Id,
Name = "Ride Attendants"
},
new Department
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
LocationId = locations.Single(s => s.Name == "South").Id,
Name = "Vendor Employee"
}
};
foreach (Department d in departments)
{
var departmentsInDatabase = context.Departments.Where
(s => s.ParkInfo.Id == d.ParkInfoId).SingleOrDefault();
if (departmentsInDatabase == null)
{
context.Departments.Add(d);
}
}
context.SaveChanges();
var employees = new Employee[]
{
new Employee
{
FirstName = "Juan",
LastName = "Garcia",
Title = "Ride Attendant",
DepartmentId = departments.Single(s => s.Name == "Ride Attendants").Id,
HireDate = DateTime.Parse("2008-04-15"),
Salary = 10.25m
},
new Employee
{
FirstName = "John",
MiddleInitial = "H",
LastName = "Smith",
Title = "Ride Attendant",
DepartmentId = departments.Single(s => s.Name == "Ride Attendants").Id,
HireDate = DateTime.Parse("2008-06-16"),
Salary = 8.25m
},
new Employee
{
FirstName = "Sally",
LastName = "Red",
Title = "Ride Attendant",
DepartmentId = departments.Single(s => s.Name == "Ride Attendants").Id,
HireDate = DateTime.Parse("2008-05-21"),
Salary = 8.25m
},
new Employee
{
FirstName = "Nick",
LastName = "Rodger",
Title = "Maintenance Crew",
DepartmentId = departments.Single(s => s.Name == "Maintenance").Id,
HireDate = DateTime.Parse("2007-09-25"),
Salary = 18.75m
},
new Employee
{
FirstName = "David",
LastName = "Valentino",
Title = "Maintenance Crew",
DepartmentId = departments.Single(s => s.Name == "Maintenance").Id,
HireDate = DateTime.Parse("2007-09-15"),
Salary = 18.75m
},
new Employee
{
FirstName = "Leon",
LastName = "Nobody",
Title = "Vendor Cashier",
DepartmentId = departments.Single(s => s.Name == "Vendor Employee").Id,
HireDate = DateTime.Parse("2008-02-07"),
Salary = 10.25m
},
new Employee
{
FirstName = "Ashely",
LastName = "Frutiz",
Title = "Manager",
DepartmentId = departments.Single(s => s.Name == "Management").Id,
HireDate = DateTime.Parse("2006-07-09"),
Salary = 27.85m
},
};
foreach (Employee e in employees)
{
var employeeInDatabase = context.Employees.Where
(s => s.Department.Id == e.DepartmentId).SingleOrDefault();
if (employeeInDatabase == null)
{
context.Employees.Add(e);
}
}
context.SaveChanges();
var ttypes = new TicketType[]
{
new TicketType
{
Name = "Basic",
Description = "Basic, one time use ticket",
Price = 5.00m,
Uses = 1
},
new TicketType
{
Name = "30-Day",
Description = "30 day ticket, good for 30 uses",
Price = 50.00m,
Uses = 30
},
new TicketType
{
Name = "Premium",
Description = "Premium ticket, good for 180 uses",
Price = 100.00m,
Uses = 180
}
};
foreach (TicketType tt in ttypes)
{
context.TicketTypes.Add(tt);
}
context.SaveChanges();
var visitors = new Visitor[]
{
new Visitor
{
FirstName = "John",
LastName = "Hop",
Email = "*****@*****.**",
PhoneNumber = "1234567890",
DateOfBirth = DateTime.Parse("1988-04-15"),
},
new Visitor
{
FirstName = "John",
LastName = "Hope",
Email = "*****@*****.**",
PhoneNumber = "1234567890",
DateOfBirth = DateTime.Parse("1988-04-15"),
},
new Visitor
{
FirstName = "John",
LastName = "Hopee",
Email = "*****@*****.**",
PhoneNumber = "1234567890",
DateOfBirth = DateTime.Parse("1988-04-15"),
},
new Visitor
{
FirstName = "John",
LastName = "Hopeee",
Email = "*****@*****.**",
PhoneNumber = "1234567890",
DateOfBirth = DateTime.Parse("1988-04-15"),
},
new Visitor
{
FirstName = "Jeff",
LastName = "Croft",
Email = "*****@*****.**",
PhoneNumber = "1234567891",
DateOfBirth = DateTime.Parse("1989-04-15"),
},
new Visitor
{
FirstName = "Joe",
LastName = "Person",
Email = "*****@*****.**",
PhoneNumber = "1234567892",
DateOfBirth = DateTime.Parse("1990-04-15"),
},
new Visitor
{
FirstName = "Jane",
LastName = "Mot",
Email = "*****@*****.**",
PhoneNumber = "1234567893",
DateOfBirth = DateTime.Parse("1991-04-15"),
},
new Visitor
{
FirstName = "Jo",
LastName = "Zi",
Email = "*****@*****.**",
PhoneNumber = "1234567894",
DateOfBirth = DateTime.Parse("1992-04-15"),
},
new Visitor
{
FirstName = "Jello",
LastName = "Yee",
Email = "*****@*****.**",
PhoneNumber = "1234567895",
DateOfBirth = DateTime.Parse("1993-04-15"),
},
new Visitor
{
FirstName = "Jesus",
LastName = "Xo",
Email = "*****@*****.**",
PhoneNumber = "1234567896",
DateOfBirth = DateTime.Parse("1994-04-15"),
}
};
foreach (Visitor vi in visitors)
{
context.Visitors.Add(vi);
}
context.SaveChanges();
var tickets = new Ticket[]
{
new Ticket
{
DatePurchased = DateTime.Parse("2009-10-03"),
TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
VisitorId = visitors.Single(s => s.LastName == "Hop").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new Ticket
{
DatePurchased = DateTime.Parse("2009-10-03"),
TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
VisitorId = visitors.Single(s => s.LastName == "Hope").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new Ticket
{
DatePurchased = DateTime.Parse("2009-10-03"),
TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
VisitorId = visitors.Single(s => s.LastName == "Hopee").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new Ticket
{
DatePurchased = DateTime.Parse("2009-10-03"),
TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
VisitorId = visitors.Single(s => s.LastName == "Hopeee").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new Ticket
{
DatePurchased = DateTime.Parse("2009-10-03"),
TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
VisitorId = visitors.Single(s => s.LastName == "Croft").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new Ticket
{
DatePurchased = DateTime.Parse("2009-10-03"),
TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
VisitorId = visitors.Single(s => s.LastName == "Person").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new Ticket
{
DatePurchased = DateTime.Parse("2009-10-03"),
TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
VisitorId = visitors.Single(s => s.LastName == "Mot").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new Ticket
{
DatePurchased = DateTime.Parse("2009-10-03"),
TicketTypeId = ttypes.Single(s => s.Name == "30-Day").Id,
VisitorId = visitors.Single(s => s.LastName == "Zi").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new Ticket
{
DatePurchased = DateTime.Parse("2009-10-03"),
TicketTypeId = ttypes.Single(s => s.Name == "30-Day").Id,
VisitorId = visitors.Single(s => s.LastName == "Yee").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new Ticket
{
DatePurchased = DateTime.Parse("2009-10-03"),
TicketTypeId = ttypes.Single(s => s.Name == "Premium").Id,
VisitorId = visitors.Single(s => s.LastName == "Xo").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
}
};
foreach (Ticket t in tickets)
{
var ticketSalesInDatabase = context.Tickets.Where(s => s.DailyReport.Id == t.DailyReportId).SingleOrDefault();
if (ticketSalesInDatabase == null)
{
context.Tickets.Add(t);
}
}
context.SaveChanges();
var vtypes = new VendorType[]
{
new VendorType {
Name = "Stand"
},
new VendorType {
Name = "Store"
},
new VendorType {
Name = "Game"
},
};
foreach (VendorType vt in vtypes)
{
context.VendorTypes.Add(vt);
}
context.SaveChanges();
var vendors = new Vendor[]
{
new Vendor
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
Name = "Tacos to Go",
Description = "Sells tacos to people on the go",
LocationId = locations.Single(s => s.Name == "West").Id,
VendorTypeId = vtypes.Single(s => s.Name == "Stand").Id,
},
new Vendor
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
Name = "Shoot Them All",
Description = "Shoot down all the targets win prizes",
LocationId = locations.Single(s => s.Name == "East").Id,
VendorTypeId = vtypes.Single(s => s.Name == "Game").Id,
},
new Vendor
{
ParkInfoId = pinfo.Single(s => s.Name == "Houston Theme Park").Id,
Name = "Park Gifts",
Description = "Gifts for your friends who couldn't be here",
LocationId = locations.Single(s => s.Name == "Center").Id,
VendorTypeId = vtypes.Single(s => s.Name == "Store").Id,
}
};
foreach (Vendor ve in vendors)
{
var vendorsInDatabase = context.Vendors.Where
(s => s.ParkInfo.Id == ve.ParkInfoId).SingleOrDefault();
if (vendorsInDatabase == null)
{
context.Vendors.Add(ve);
}
}
context.SaveChanges();
var vsales = new VendorSale[]
{
new VendorSale
{
ReportDate = DateTime.Parse("2009-10-03"),
TotalSales = 73.85m,
SalesGoal = 100.00m,
VendorId = vendors.Single(s => s.Name == "Park Gifts").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new VendorSale
{
ReportDate = DateTime.Parse("2009-10-03"),
TotalSales = 150.00m,
SalesGoal = 75.00m,
VendorId = vendors.Single(s => s.Name == "Shoot Them All").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
},
new VendorSale
{
ReportDate = DateTime.Parse("2009-10-03"),
TotalSales = 100.00m,
SalesGoal = 50.00m,
VendorId = vendors.Single(s => s.Name == "Tacos to Go").Id,
DailyReportId = dreports.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id
}
};
foreach (VendorSale ve in vsales)
{
var vendorSalesInDatabase = context.VendorSales.Where
(s => s.Vendor.Id == ve.VendorId &&
s.DailyReport.Id == ve.DailyReportId).SingleOrDefault();
if (vendorSalesInDatabase == null)
{
context.VendorSales.Add(ve);
}
}
context.SaveChanges();
/*
* var pinfo = new ParkInfo[]
* {
* new ParkInfo
* {
* Name = "Houston Theme Park",
* Country = "USA",
* State = "TX",
* City = "Houston",
* ZipCode = "77042",
* StreetNumber = "11223",
* StreetName = "Grant Rd"
* },
* };
* foreach (ParkInfo pi in pinfo) { context.ParkInfo.Add(pi); }
* context.SaveChanges();
*/
/*
* var dreports = new DailyReport[]
* {
* new DailyReport
* {
* WeatherId = weather.Single(s => s.Date == DateTime.Parse("2009-10-03")).Id,
* Date = DateTime.Parse("2009-10-03")
* }
* };
*
* foreach (DailyReport dr in dreports) { context.DailyReports.Add(dr); }
*
* context.SaveChanges();
*/
}
public void brokenAttraction(Attraction attraction)
{
attractionObjective = attraction;
goToAttraction();
estado_trabajo = STATE_Working.DIRIGIENDOSE_ATRACCION;
}
public static async Task GetCityAttractionAsync(LatLng latLng, string attraction, string uri, Action <CityAttractions> Callback)
{
string nextPageToken = null;
// Create a temporary HttpClient connection.
using (var Client = new HttpClient())
{
try
{
// string placesApiKey = "AIzaSyAgsubmt3p8asFrV-x_x_cEInQokzf-X9s";
// https://maps.googleapis.com/maps/api/place/nearbysearch/json?location=-33.8670,151.1957&radius=500&types=food&name=cruise&key=YOUR_API_KEY
// string uri = $"https://maps.googleapis.com/maps/api/place/nearbysearch/json?location={latLng.Latitude},{latLng.Longitude}&radius=100000&types={attraction}&key={placesApiKey}";
// https://maps.googleapis.com/maps/api/place/nearbysearch/json?location=47.6101497,-122.2015159&radius=50000&types=park&rankby=prominence&key=AIzaSyAgsubmt3p8asFrV-x_x_cEInQokzf-X9s
// string uri = $"https://maps.googleapis.com/maps/api/place/nearbysearch/json?location={latLng.Latitude},{latLng.Longitude}&types={attraction}&rankby=distance&key={placesApiKey}";
// string uri = $"https://maps.googleapis.com/maps/api/place/nearbysearch/json?location={latLng.Latitude},{latLng.Longitude}&types={attraction}&radius=3200&key={placesApiKey}";
Client.BaseAddress = new Uri(uri);
HttpResponseMessage Response = await Client.GetAsync(""); // Make the actual API call.
Response.EnsureSuccessStatusCode(); // Throw error if not successful.
string StringResponse = await Response.Content.ReadAsStringAsync(); // Read in the response as a string.
JObject CityAttractionsObject = JsonConvert.DeserializeObject <JObject>(StringResponse);
// Console.WriteLine("results: " + CityAttractionsObject["results"]);
// Console.WriteLine("next_page_token: " + CityAttractionsObject["next_page_token"]);
if (CityAttractionsObject["next_page_token"] != null)
{
nextPageToken = CityAttractionsObject["next_page_token"].Value <string>();
}
JArray AttractionList = CityAttractionsObject["results"].Value <JArray>();
List <Attraction> Attractions = new List <Attraction>();
foreach (JObject AttractionObject in AttractionList)
{
Attraction newAttraction = new Attraction {
Name = AttractionObject["name"].Value <string>(),
Vicinity = AttractionObject["vicinity"].Value <string>(),
Latitude = AttractionObject["geometry"]["location"]["lat"].Value <double>(),
Longitude = AttractionObject["geometry"]["location"]["lng"].Value <double>()
};
Attractions.Add(newAttraction);
}
// Console.WriteLine("results: " + CityAttractionsObject["results"]);
// Console.WriteLine("name: " + CityAttractionsObject["results"][0]["name"]);
// Console.WriteLine("name: " + CityAttractionsObject["results"][1]["name"]);
// Console.WriteLine("name: " + CityAttractionsObject["results"][2]["name"]);
CityAttractions CityAttractions = new CityAttractions {
Attraction = attraction,
Attractions = Attractions,
NextPageToken = nextPageToken
};
// Finally, execute our callback, passing it the response we got.
// Callback(JsonResponse);
Callback(CityAttractions);
}
catch (HttpRequestException e)
{
// If something went wrong, display the error.
Console.WriteLine($"Request exception: {e.Message}");
}
}
}