public JsonResult LoadAreaGuide(string areaID) { List <AreaGuide> results = new List <AreaGuide>(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBAreaGuide"].ConnectionString)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = String.Format("SELECT AreaID,Type,AvgPrice,Rating,Notes FROM dbo.AreaGuide WHERE AreaID = '{0}'", areaID); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { AreaGuide ag = new AreaGuide(); ag.AreaID = reader["AreaID"].ToString(); ag.Type = reader["Type"].ToString(); ag.AvgPrice = Decimal.Parse(reader["AvgPrice"].ToString()); ag.Rating = Byte.Parse(reader["Rating"].ToString()); ag.Notes = reader["Notes"].ToString(); results.Add(ag); } reader.Dispose(); } cmd.Dispose(); } conn.Close(); conn.Dispose(); } return(Json(results, JsonRequestBehavior.AllowGet)); }
private void addToNextGenForFollowUp(RunItem <PositionData, ActionData, CheckPointType> item) { //var category = PositionCategorizer.Categorize(item.Position); var area = AreaGuide.PositionAreaId(item.Position.Data); //item.PreSolution.CategoryPath.Add(category); item.Position.CategoryPath.Add(area); if (item.HasMoved && !Fingerprints.ContainsKey(item.Position.Data.Fingerprint) && !(Targets.All(t => t.ReachTarget(item.Position) || t.IsOptional) && CancelCriteria == CancelCriteria.TargetsReached) && !(CancelCriteria == CancelCriteria.MaxSteps && item.Position.Depth >= TargetOptCenterParams.MaxSearchDepth)) { //item.Score = item.Position.Data.NextCheckPoint.Score(item.Position.Data); item.PreSolution.Score = AreaGuide.Score(item.Position.Data) + random.NextDouble() * 0.00001; var nextGen = CheckPoints.FirstOrDefault(ng => ng.CategoryNr == area); if (nextGen == null) { nextGen = new LocalCheckPoint(); nextGen.CategoryNr = area; CheckPoints.Add(nextGen); } //if (nextGen.Positions.All(rI => AreaGuide.CanOvercome(item.Position.Data, rI.Position.Data))) { nextGen.Positions.SortedInsert(item.PreSolution, TargetOptCenterParams.NextGenerationSize, (c) => c.Score); Fingerprints.Add(item.Position.Data.Fingerprint, item); } } else { } }
public IHttpActionResult PutAreaGuide(int id, AreaGuide areaGuide) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != areaGuide.ID) { return(BadRequest()); } db.Entry(areaGuide).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!AreaGuideExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(int id) { AreaGuide areaGuide = db.AreaGuides.Find(id); db.AreaGuides.Remove(areaGuide); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "AreaID,Type,AvgPrice,Rating,Notes,ID")] AreaGuide areaGuide) { if (ModelState.IsValid) { db.Entry(areaGuide).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(areaGuide)); }
public ActionResult Create([Bind(Include = "AreaID,Type,AvgPrice,Rating,Notes,ID")] AreaGuide areaGuide) { if (ModelState.IsValid) { db.AreaGuides.Add(areaGuide); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(areaGuide)); }
public IHttpActionResult GetByAreaID(string areaID) { AreaGuide areaGuide = db.AreaGuides.First <AreaGuide>(a => a.AreaID == areaID); if (areaGuide == null) { return(NotFound()); } return(Ok(areaGuide)); }
public IHttpActionResult GetAreaGuide(int id) { AreaGuide areaGuide = db.AreaGuides.Find(id); if (areaGuide == null) { return(NotFound()); } return(Ok(areaGuide)); }
public IHttpActionResult PostAreaGuide(AreaGuide areaGuide) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.AreaGuides.Add(areaGuide); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = areaGuide.ID }, areaGuide)); }
// GET: AreaGuides/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AreaGuide areaGuide = db.AreaGuides.Find(id); if (areaGuide == null) { return(HttpNotFound()); } return(View(areaGuide)); }
public IHttpActionResult DeleteAreaGuide(int id) { AreaGuide areaGuide = db.AreaGuides.Find(id); if (areaGuide == null) { return(NotFound()); } db.AreaGuides.Remove(areaGuide); db.SaveChanges(); return(Ok(areaGuide)); }