public GameObject SpawnPothole() { Vector2Int index = GetRandomRoadIndex(); PotholeType potholeType = GetRandomSizedPotholePrefab(); GameObject potholeObject = placementManager.CreateRoadObject(index.x, index.y, grid, potholeType.prefab); placementManager.AddIndicatorToPothole(potholeObject); potholeObject.transform.tag = "Pothole"; potholeObject.name = "Pothole (" + index.x + ", " + index.y + ")"; Pothole newPothole = potholeObject.AddComponent <Pothole>(); newPothole.SetPothole(this, potholeType.repairTime, potholeType.GetSize()); //Remove road from grid GameObject road = grid.GetRoadObjectFromGird(index.x, index.y); placementManager.RemoveObject(road); //Set new pothole to grid grid.PlaceRoadToGrid(index.x, index.y, potholeObject, true); //Change numbers potholeCount++; ChangePotholeCount(new Vector3Int(1, 0, 0)); return(potholeObject); }
public override void SetPothole(Pothole pothole, Action potholeWatcher) { this.pothole = pothole; this.pothole.AddCarToPothole(); this.pothole.AddListenerOnPotholeDestructionEvent(potholeWatcher); this.potholeWatcherAction = potholeWatcher; }
public ActionResult ReportPotholePost(PotholeViewModel viewModel) { if (!Request.IsAuthenticated) { return(RedirectToAction("Index")); } //Pothole pothole = new Pothole(); //pothole.UserName = userName; Pothole p = new Pothole(); p.UserName = viewModel.UserName; p.PotholeDesc = viewModel.PotholeDesc; p.Latitude = viewModel.Latitude; p.Longitude = viewModel.Longitude; p.Severity = viewModel.Severity; p.Street1 = viewModel.Street1; p.Street2 = viewModel.Street2; p.LocationDesc = viewModel.LocationDesc; p.ReportedDate = viewModel.ReportedDate; p.InspectedDate = viewModel.InspectedDate; p.RepairedDate = viewModel.RepairedDate; p.IsValidated = Convert.ToBoolean(viewModel.IsValidated); bool confirm = potholeDAL.ReportPothole(p); return(RedirectToAction("Index", "Home")); }
public Pothole ReportApothole(Pothole pothole) { pothole.Status = (PotholeStatus)1; pothole.DateAdded = DateTime.Now; string sqlQuery = "INSERT INTO Pothole([Location], DateAdded, [Description], Status) VALUES(@location, @dateAdded, @description, @status) SELECT @@IDENTITY"; try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(sqlQuery, conn); //Add all the params cmd.Parameters.AddWithValue("@location", pothole.Location); //cmd.Parameters.AddWithValue("@dateAdded", pothole.DateAdded); cmd.Parameters.AddWithValue("@dateAdded", pothole.DateAdded); cmd.Parameters.AddWithValue("@description", pothole.Description); cmd.Parameters.AddWithValue("@status", pothole.Status); pothole.Id = Convert.ToInt32(cmd.ExecuteScalar()); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(pothole); }
public void UnTrigger(Pothole potehole) { if (m_triggered == false) { return; } m_triggered = false; switch (m_type) { default: break; case EventType.GameObject: m_GO.SetActive(false); break; case EventType.Function: break; case EventType.ParticleSystem: ParticleSystem.EmissionModule em = m_particleSystem.emission; em.enabled = false; break; case EventType.Collider: m_collider.enabled = false; break; } }
public List <Pothole> GetOrderPotholes(int orderId) { List <Pothole> orderPotholes = new List <Pothole>(); try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); string query = "SELECT PotHole.PotHole_Id, PotHole.UserId, Users.UserName, PotHole.PotHoleDesc, PotHole.Lat, PotHole.Long, PotHole.Severity, PotHole.Street1, PotHole.Street2, PotHole.LocationDesc, PotHole.DateReported, PotHole.InspectedDate, PotHole.RepairDate, PotHole.IsValidated FROM PotHole JOIN Users on Users.UserId = PotHole.UserId JOIN WorkOrderPotholeUser ON PotHole.PotHole_Id = WorkOrderPotholeUser.PotHole_Id WHERE WorkOrderPotholeUser.WorkOrderId = @workOrderId GROUP BY PotHole.PotHole_Id, PotHole.UserId, Users.UserName, PotHole.PotHoleDesc, PotHole.Lat, PotHole.Long, PotHole.Severity, PotHole.Street1, PotHole.Street2, PotHole.LocationDesc, PotHole.DateReported, PotHole.InspectedDate, PotHole.RepairDate, PotHole.IsValidated;"; SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@workOrderId", orderId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Pothole p = MapRows(reader); orderPotholes.Add(p); } } } catch (SqlException ex) { throw; } return(orderPotholes); }
public PotholeViewModel SearchValidPotHoles(PotholeViewModel viewModel) { List <Pothole> allPotholes = new List <Pothole>(); try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); //string query = BuildSqlCommand(viewModel, conn); SqlCommand cmd = BuildSqlCommand(viewModel, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Pothole p = MapRows(reader); allPotholes.Add(p); } } } catch (SqlException ex) { throw; } viewModel.PotholeList = allPotholes; return(viewModel); }
void UnsetPothole() { m_currentPothole = null; m_animator.SetBool("Fixing", false); //ParticleSystem.EmissionModule em = m_hammerEffect.emission; //em.enabled = false; m_hammerEffect.Stop(true); }
public ActionResult DeletePothole(Pothole potholeDelete) { if (!Request.IsAuthenticated || User.IsInRole("citizen") || User.IsInRole("crew_member")) { return(RedirectToAction("Index")); } potholeDAL.DeletePothole(potholeDelete); return(RedirectToAction("AdminPotholeEdit")); }
void SetPothole(Collider other) { m_potholeTriggerStay = 0.0f; m_currentPothole = other.transform.parent.GetComponent <Pothole>(); m_animator.SetBool("Fixing", true); //ParticleSystem.EmissionModule em = m_hammerEffect.emission; //em.enabled = true; m_hammerEffect.Play(true); }
public void SetParams(Pothole pothole) { this.pothole = pothole; PotholeSize holeType = pothole.size; Image[] holes = potholeTypesPanel.GetComponentsInChildren <Image>(); uiHelper.SetPotholeTypeIcon(holes, holeType); Image[] workers = workersPanel.GetComponentsInChildren <Image>(); uiHelper.ChangeWorkerColor(0, workers); }
void HandlePotholeClick(RaycastHit hit) { Pothole pothole = hit.transform.gameObject.GetComponent <Pothole>(); if (pothole.status == PotholeStatus.ToDo) { uiController.OpenAssignPanel(pothole); } else if (pothole.status == PotholeStatus.InProgress) { uiController.OpenStatusPanel(pothole); } }
public ActionResult DetailHole(Pothole pothole) { if (CurrentUser == "EmptyUserName" || CurrentUser != "") { int potHoleID = potholeDAL.InsertPothole(pothole); Session["Pothole_id"] = potHoleID; return(View("DetailHole", pothole)); } else { return(RedirectToAction("Login", "User")); } }
public ActionResult AdminPotholeEdit(Pothole pothole) { if (!Request.IsAuthenticated || User.IsInRole("citizen") || User.IsInRole("crew_member")) { return(RedirectToAction("Index")); } potholeDAL.UpdatePothole(pothole); //PotholeViewModel returnModel = new PotholeViewModel(); //returnModel.PotholeList = new List<Pothole>(); //returnModel.PotholeList.Add(pothole); return(RedirectToAction("AdminPotholeEdit" /*, returnModel*/)); }
public void InsertPotholeTest() { PotholeDAL sql = new PotholeDAL(connectionString); Pothole pothole = new Pothole { Status = "Reported", Severity = 4, DateReported = DateTime.UtcNow.Date, Longitude = -83.045653M, Latitude = 39.99753999999996M, }; Assert.AreEqual(updateId + 1, sql.InsertPothole(pothole)); }
public void Trigger(Pothole potehole) { if (m_triggered) { return; } m_triggered = true; switch (m_type) { default: break; case EventType.GameObject: m_GO.SetActive(true); break; case EventType.Function: potehole.InvokeFunction(m_function); break; case EventType.ParticleSystem: ParticleSystem.EmissionModule em = m_particleSystem.emission; em.enabled = true; m_particleSystem.Play(true); break; case EventType.Collider: m_collider.enabled = true; break; } switch (m_sound) { default: case PlaySound.None: break; case PlaySound.Dig: MasterAudio.PlaySound3DAtTransformAndForget("Dig", potehole.transform); break; case PlaySound.Crack: MasterAudio.PlaySound3DAtTransformAndForget("Break", potehole.transform); break; case PlaySound.RabbitJump: MasterAudio.PlaySound3DAtTransformAndForget("RabbitJump", potehole.transform); break; } }
public List <Pothole> GetAllPotholes() { List <Pothole> potholeList = new List <Pothole>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_GetAllPotholes, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Pothole pothole = new Pothole(); pothole.PotholeID = Convert.ToInt32(reader["PotHole_ID"]); pothole.Status = Convert.ToString(reader["Status"]); pothole.Severity = Convert.ToInt32(reader["Severity"]); pothole.DateReported = Convert.ToDateTime(reader["Date_Reported"]); if (reader["Repair_Date"] is DBNull) { pothole.RepairDate = null; } else { pothole.RepairDate = Convert.ToDateTime(reader["Repair_Date"]); } if (reader["Inspect_Date"] is DBNull) { pothole.InspectDate = null; } else { pothole.InspectDate = Convert.ToDateTime(reader["Inspect_Date"]); } pothole.Longitude = Convert.ToDecimal(reader["Longitude"]); pothole.Latitude = Convert.ToDecimal(reader["Latitude"]); potholeList.Add(pothole); } } } catch (Exception ex) { throw; } return(potholeList); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Pothole = await _context.Pothole.SingleOrDefaultAsync(m => m.ID == id); if (Pothole == null) { return(NotFound()); } return(Page()); }
private void Next_imga2_Click(object sender, EventArgs e) { if (selected != null || selected != "") { string a = JsonConvert.DeserializeObject <string>(Intent.GetStringExtra("objtopass")); Pothole p = new Pothole(); p.IssueImage = a; p.waterLevel = selected; Control.DataOper.PutData <createissue4>(this, p); } else { Toast.MakeText(this, "Please select any option", ToastLength.Long).Show(); } }
public List <Pothole> GetAllValidPotholes() { List <Pothole> allPotholes = new List <Pothole>(); try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); string query = "SELECT PotHole.PotHole_Id, PotHole.UserId, Users.UserName, PotHole.PotHoleDesc, PotHole.Lat, PotHole.Long, PotHole.Severity, PotHole.Street1, PotHole.Street2, PotHole.LocationDesc, PotHole.DateReported, PotHole.InspectedDate, PotHole.RepairDate, PotHole.IsValidated FROM PotHole JOIN Users ON PotHole.UserId = Users.UserId WHERE IsValidated = 1"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { //Pothole p = new Pothole(); //p.PotholeId = Convert.ToInt32(reader["PotHole_Id"]); //p.UserId = (Guid)reader["UserId"]; //p.PotholeDesc = Convert.ToString(reader["PotHoleDesc"]); //p.Latitude = Convert.ToDouble(reader["Lat"]); //p.Longitude = Convert.ToDouble(reader["Long"]); //p.Severity = Convert.ToInt32(reader["Severity"]); //p.Street1 = Convert.ToString(reader["Street1"]); //p.Street2 = Convert.ToString(reader["Street2"]); //p.LocationDesc = Convert.ToString(reader["LocationDesc"]); //p.ReportedDate = Convert.ToDateTime(reader["DateReported"]); //p.InspectedDate = Convert.ToDateTime(reader["InspectedDate"]); //p.RepairedDate = Convert.ToDateTime(reader["RepairDate"]); //p.IsValidated = Convert.ToBoolean(reader["IsValidated"]); Pothole p = MapRows(reader); allPotholes.Add(p); } } } catch (SqlException ex) { throw; } return(allPotholes); }
public Pothole GetOnePotholes(string id) { Pothole pothole = new Pothole(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_GetSinglePothole, conn); cmd.Parameters.AddWithValue("@id", id); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { pothole.PotholeID = Convert.ToInt32(reader["PotHole_ID"]); pothole.Status = Convert.ToString(reader["Status"]); pothole.Severity = Convert.ToInt32(reader["Severity"]); pothole.DateReported = Convert.ToDateTime(reader["Date_Reported"]); if (reader["Repair_Date"] is DBNull) { pothole.RepairDate = null; } else { pothole.RepairDate = Convert.ToDateTime(reader["Repair_Date"]); } if (reader["Inspect_Date"] is DBNull) { pothole.InspectDate = null; } else { pothole.InspectDate = Convert.ToDateTime(reader["Inspect_Date"]); } pothole.Longitude = Convert.ToDecimal(reader["Longitude"]); pothole.Latitude = Convert.ToDecimal(reader["Latitude"]); } } } catch (Exception ex) { throw; } return(pothole); }
public void UpdatePotholeTest() { DateTime repair = new DateTime(2018, 5, 30); DateTime inspect = new DateTime(2018, 4, 30); PotholeDAL sql = new PotholeDAL(connectionString); Pothole pothole = new Pothole { PotholeID = updateId, Status = "Inspected", Severity = 5, RepairDate = null, InspectDate = inspect, }; Assert.AreEqual(true, sql.UpdatePothole(pothole)); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Pothole = await _context.Pothole.FindAsync(id); if (Pothole != null) { _context.Pothole.Remove(Pothole); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public ActionResult ReportPothole(Pothole pothole) { //Create an array to hold the address string[] addressSplit; //Split the address addressSplit = pothole.Location.Split(" "); //Check the array to make sure the info is in the format that is wanted if (addressSplit[0] == "" || addressSplit[1] == "" || addressSplit[2] == "" || addressSplit[3] == "" || addressSplit[4] == "" || addressSplit[5] == "" || pothole.Description == "") { return(Forbid()); } else { Pothole pothole1 = potholeDAO.ReportApothole(pothole); return(Ok()); } }
//The method that convert the data from sql data types to C# Objects private Pothole PotholeData(SqlDataReader reader) { //Location location = ParseAddress(Convert.ToString(reader["Location"])); ParseAddressModel addressModel = ParseAddress(Convert.ToString(reader["Location"])); Pothole pothole = new Pothole(); pothole.Id = Convert.ToInt32(reader["Id"]); pothole.Location = Convert.ToString(reader["Location"]); pothole.DateAdded = Convert.ToDateTime(reader["DateAdded"]); pothole.Description = Convert.ToString(reader["Description"]); pothole.Status = (PotholeStatus)Convert.ToInt32(reader["Status"]); pothole.Severity = Convert.ToInt32(reader["Severity"]); pothole.Latitude = addressModel.results[0].geometry.location.Lat; pothole.Longitude = addressModel.results[0].geometry.location.Lng; return(pothole); }
// Update is called once per frame void Update() { Pothole pothole = CheckForPotholes(); if (pothole != null) { carState.TransitionToState(stoppedByPotholeState, pothole, PotholeDone); } CharacterNavigationController otherCar = CheckForOtherCars(); if (otherCar != null) { if (otherCar.carState.StoppedByPothole()) { carState.TransitionToState(stoppedByPotholeState, otherCar.carState.GetPothole(), PotholeDone); } else { carState.TransitionToState(stoppedByCarState, otherCar); } } if (pothole == null && otherCar == null && !carState.IsMoving()) { carState.TransitionToState(movingState); } if (carState.IsMoving()) { MoveTowardsDestination(); } else { carState.TimeGoesBy(Time.deltaTime); if (carState.NeedToKillCar()) { Destroy(this.gameObject); } } }
public void FinishPothole(Pothole pothole, int workerCount) { Vector2Int gridIndex = grid.GetGridIndexByPosition(pothole.transform.position); GameObject potholeObject = grid.GetRoadObjectFromGird(gridIndex.x, gridIndex.y); if (potholeObject.GetComponent <Pothole>() == pothole) { //Create road GameObject roadObject = placementManager.CreateRoadObject(gridIndex.x, gridIndex.y, grid, roadRepository.roadModelCollection.straightRoadPrefab.prefab); //Remove Pothole from grid placementManager.RemoveObject(potholeObject); //Set the road to the grid grid.PlaceRoadToGrid(gridIndex.x, gridIndex.y, roadObject, false); //Change numbers ChangePotholeCount(new Vector3Int(0, -1, 1)); ChangeAvailableWorker(workerCount); } }
public void StartRepairPothole(Pothole pothole, int workerCount) { Vector2Int gridIndex = grid.GetGridIndexByPosition(pothole.transform.position); GameObject gridObject = grid.GetRoadObjectFromGird(gridIndex.x, gridIndex.y); if (gridObject.GetComponent <Pothole>() == pothole) { //Remove indicator GameObject indicator = pothole.gameObject.GetComponentInChildren <IconController>().gameObject; placementManager.RemoveObject(indicator); //Add canvas and particle system GameObject canvas = placementManager.AddSliderIconToPothole(pothole.gameObject); canvas.GetComponent <SliderController>().SetSolveTime(pothole.repairTime); GameObject repairParticle = placementManager.AddParticleSystemToPothole(pothole.gameObject); //Change numbers ChangePotholeCount(new Vector3Int(-1, 1, 0)); ChangeAvailableWorker(-workerCount); } }
public ActionResult UpdatePothole(Pothole updatedPothole, int?page) { potholeDAL.UpdatePothole(updatedPothole); string id = updatedPothole.PotholeID.ToString(); int pageSize = 15; int pageIndex = 1; pageIndex = page.HasValue ? Convert.ToInt32(page) : 1; IPagedList <Pothole> pagedPotholes = null; List <Pothole> potholeList = potholeDAL.GetAllPotholes(); pagedPotholes = potholeList.ToPagedList(pageIndex, pageSize); if (IsEmployee()) { return(View("ViewPotholesForEmp", pagedPotholes)); } else { return(View("ViewPotholes", pagedPotholes)); } }
public bool UpdatePothole(Pothole update) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_UpdatePothole, conn); cmd.Parameters.AddWithValue("@potholeid", update.PotholeID); cmd.Parameters.AddWithValue("@status", update.Status); cmd.Parameters.AddWithValue("@severity", update.Severity); if (update.RepairDate == null) { cmd.Parameters.AddWithValue("@repairDate", DBNull.Value).IsNullable = true; } else { cmd.Parameters.AddWithValue("@repairDate", update.RepairDate).IsNullable = true; } if (update.InspectDate == null) { cmd.Parameters.AddWithValue("@inspectDate", DBNull.Value).IsNullable = true; } else { cmd.Parameters.AddWithValue("@inspectDate", update.InspectDate).IsNullable = true; } int rowsAffected = cmd.ExecuteNonQuery(); return(rowsAffected > 0); } } catch (Exception e) { throw; } }