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