using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Metadata.Edm;
using System.Data.Objects.DataClasses;

namespace NerdDinner.Models
{
    public class DinnerRepository
    {

        private NerdDinnerEntities entities = new NerdDinnerEntities();

        //
        // Query Methods

        public IQueryable<Dinner> FindAllDinners()
        {
            return entities.Dinners;
        }

        public IQueryable<Dinner> FindUpcomingDinners()
        {
            return from dinner in entities.Dinners
                   where dinner.EventDate > DateTime.Now
                   orderby dinner.EventDate
                   select dinner;
        }
        public Dinner GetDinner(int id)
        {
            return entities.Dinners.FirstOrDefault(d => d.DinnerID == id);
        }

        //
        // Insert/Delete Methods

        public void Add(Dinner dinner)
        {
            entities.AddToDinners(dinner);
        }

        public void Delete(Dinner dinner)
        {
            foreach (var rsvp in dinner.RSVPs)
            {
                entities.DeleteObject(dinner.RSVPs);
            }
            entities.DeleteObject(dinner);
        }
        
        //
        // Persistence 

        public void Save()
        {
            entities.SaveChanges();
        }

        // Helper Methods

        [EdmFunction("NerdDinnerModel.Store", "DistanceBetween")]
        public static double DistanceBetween(double lat1, double long1, double lat2, double long2)
        {
            throw new NotImplementedException("Only call through LINQ expression");
        }
    }
}

	[EdmFunction("NerdDinner.Models.Store", "DistanceBetween")]