// method to get Users' RSVPed weddings
public List <Wedding> getRSVPedWeddings(int UserId)
{
List <Wedding> weddings = new List <Wedding>();
weddings = Weddings.Include(w => w.GuestList)
.ThenInclude(r => r.User)
.ToList();
for (var i = weddings.Count - 1; i >= 0; i--)
{
Wedding currentWedding = weddings[i];
bool UserAttendingWedding = false;
for (var j = 0; j < currentWedding.GuestCount; j++)
{
if (currentWedding.GuestList[j].UserId == UserId)
{
UserAttendingWedding = true;
break;
}
}
//we should know if they're attending or not
if (!UserAttendingWedding)
{
weddings.Remove(currentWedding);
}
}
return(weddings);
}
public Wedding GetWedding(int wid)
{
var weddings = Weddings.Include(wp => wp.WeddingParty)
.Include(v => v.Vendors)
.Include(u => u.Planner)
.FirstOrDefault(w => w.WeddingId == wid);
return(weddings);
}
public List <Wedding> GetAllWeddings()
{
var weddings = Weddings.Include(w => w.GuestList).ThenInclude(gw => gw.User).ToList();
weddings.RemoveAll(w => w.WeddingDate < DateTime.Now);
SaveChanges();
return(weddings);
}
public bool LeaveWedding(int weddingId, int userId)
{
var wedding = Weddings.Include(w => w.GuestList)
.ThenInclude(gw => gw.User)
.FirstOrDefault(w => w.WeddingId == weddingId);
if (wedding != null)
{
wedding.GuestList.RemoveAll(gw => gw.WeddingId == weddingId && gw.UserId == userId);
SaveChanges();
return(true);
}
return(false);
}
public void AddNewVendor(Vendor vendor, int wid)
{
var wedding = Weddings.FirstOrDefault(w => w.WeddingId == wid);
if (wedding != null)
{
if (wedding.Vendors == null)
{
wedding.Vendors = new List <Vendor>();
System.Console.WriteLine("initializing vendor list");
}
wedding.Vendors.Add(vendor);
SaveChanges();
}
}
public bool DeleteWedding(int weddingId, int userId)
{
var wedding = Weddings.Include(w => w.GuestList)
.SingleOrDefault(w => w.WeddingId == weddingId && w.UserId == userId);
if (wedding != null)
{
GuestWeddings.RemoveRange(wedding.GuestList);
Weddings.Remove(wedding);
SaveChanges();
return(true);
}
else
{
return(false);
}
}
public bool JoinWeddingGuests(int weddingId, int userId)
{
var wedding = Weddings.Include(w => w.GuestList)
.ThenInclude(gw => gw.User)
.FirstOrDefault(w => w.WeddingId == weddingId);
if (wedding != null)
{
wedding.GuestList.Add(new GuestWedding()
{
UserId = userId,
WeddingId = weddingId
});
SaveChanges();
return(true);
}
return(false);
}
public List <Wedding> GetWeddings(int uid)
{
var weddings = Weddings.Where(u => u.UserId == uid).OrderBy(u => u.WeddingDate);
return(weddings.ToList());
}
public Wedding GetWeddingById(int WeddingId)
{
return(Weddings.Where(w => w.WeddingId == WeddingId).FirstOrDefault());
}
public void Create(Wedding w)
{
Weddings.Add(w);
SaveChanges();
}
