public static IList<MapSearchRequestHistoryVM> GetMapSearchRequestsHistory(Func<MapRequest,object> orderBy = null) { IList<MapSearchRequestHistoryVM> result = new List<MapSearchRequestHistoryVM>(); using (MediatelModel context = new MediatelModel()) { IList<MapRequest> mapRequests = null; if (orderBy == null) { mapRequests = context.MapRequests.Include("MapSearchResult").OrderBy(m => m.DateCreated).ToList(); mapRequests = mapRequests.Reverse().ToList(); } else { mapRequests = context.MapRequests.Include("MapSearchResult").OrderBy(orderBy).ToList(); } foreach (MapRequest mapRequest in mapRequests) { var mapSerReqHis = new MapSearchRequestHistoryVM(); mapSerReqHis.ResultCode = mapRequest.MapSearchResult.ResultCode; mapSerReqHis.City = mapRequest.MapSearchResult.City; mapSerReqHis.Country = mapRequest.MapSearchResult.Country; mapSerReqHis.DateCreated = mapRequest.DateCreated; mapSerReqHis.Email = mapRequest.Email; mapSerReqHis.HouseNumber = mapRequest.MapSearchResult.HouseNumber; mapSerReqHis.Latitude = mapRequest.Latitude; mapSerReqHis.Longitude = mapRequest.Longitude; mapSerReqHis.PostCode = mapRequest.MapSearchResult.PostCode; result.Add(mapSerReqHis); } } return result; }
private static MapRequest CreateMapRequest(MapRequestAVM mapRequestAVM) { var mapRequest = new MapRequest(mapRequestAVM.Email, mapRequestAVM.Latitude.Value, mapRequestAVM.Longitude.Value,DateTime.Now); using (MediatelModel context = new MediatelModel()) { context.MapRequests.Add(mapRequest); context.SaveChanges(); } return mapRequest; }
private static MapRequest CreateMapRequest(MapRequestVM mapRequestVM) { double latitude = MapRequestsHelper.ConvertLatitude(mapRequestVM.LatDegrees, mapRequestVM.LatMinutes, mapRequestVM.LatSeconds, mapRequestVM.LatDirection); double longitude = MapRequestsHelper.ConvertLongitude(mapRequestVM.LonDegrees, mapRequestVM.LonMinutes, mapRequestVM.LonSeconds, mapRequestVM.LonDirection); var mapRequest = new MapRequest(mapRequestVM.Email, latitude, longitude,DateTime.Now); using (MediatelModel context = new MediatelModel()) { context.MapRequests.Add(mapRequest); context.SaveChanges(); } return mapRequest; }
private static MapSearchResult CreateMapSearchResult(MapSearchResultVM mapSearchResultVM, int mapRequestId) { MapSearchResult mapSearchResult = new MapSearchResult(); mapSearchResult.City = mapSearchResultVM.City; mapSearchResult.Country = mapSearchResultVM.Country; mapSearchResult.DateCreate = DateTime.Now; mapSearchResult.HouseNumber = mapSearchResultVM.HouseNumber; mapSearchResult.MapRequestId = mapRequestId; mapSearchResult.PostCode = mapSearchResultVM.PostCode; mapSearchResult.ResultCode = mapSearchResultVM.ResultCode; using (MediatelModel context = new MediatelModel()) { context.MapSearchResults.Add(mapSearchResult); context.SaveChanges(); } return mapSearchResult; }