public DistanceModel GetPopularDistances() { DistanceTable popular = DB.DistanceTables.OrderByDescending(d => d.hits).FirstOrDefault(); DistanceModel model = DistanceConverter.EntityToModel(popular); //List<DistanceTable> popList = DB.DistanceTables.OrderByDescending(d => d.hits).Take(10).ToList(); return(model); }
public void CreateDistance(DistanceModel model) { DistanceTable distance = DistanceConverter.ModelToEntity(model); DB.DistanceTables.Add(new DistanceTable { source = distance.source, destination = distance.destination, distance = distance.distance, hits = 1 }); DB.SaveChanges(); }