public async Task Add([FromBody] Models.Rsvp obj)
{
var bll_r = rsvpBusiness;
var user = HttpContext.Items["EndUser"] as EF.EndUser;
obj.MemberId = obj.MemberId == 0 ? user.MemberId : obj.MemberId;
var r = await bll_r.Get(new EF.Rsvp {
EventId = obj.EventId, MemberId = obj.MemberId
});
if (r == null)
{
await bll_r.Add(new EF.Rsvp {
EventId = obj.EventId, MemberId = obj.MemberId, IsGoing = obj.IsGoing
});
}
else
{
await bll_r.Update(new EF.Rsvp {
EventId = obj.EventId, MemberId = obj.MemberId, IsGoing = obj.IsGoing
});
}
}
public async Task Delete([FromBody] Models.Rsvp obj)
{
var bll_r = rsvpBusiness;
var user = HttpContext.Items["EndUser"] as EF.EndUser;
obj.MemberId = obj.MemberId == 0 ? user.Member.Id : obj.MemberId;
await bll_r.Delete(new EF.Rsvp {
EventId = obj.EventId, MemberId = obj.MemberId
});
}
public void Create(Models.Rsvp rsvp)
{
using (var uow = _db.GetTransaction())
{
_db.Insert(rsvp);
foreach (var response in rsvp.Responses)
{
_db.Insert(response);
}
_db.Execute(@"UPDATE core.Guests
SET HasSentRsvp = 1
WHERE Id IN (@0)",
rsvp.Responses.Select(x => x.GuestId));
uow.Complete();
}
}
public async Task <IActionResult> Find([FromBody] Models.Rsvp obj)
{
var bll_r = rsvpBusiness;
var user = HttpContext.Items["EndUser"] as EF.EndUser;
obj.MemberId = obj.MemberId == 0 ? user.Member.Id : obj.MemberId;
var res = from r in await bll_r.Find(obj.Member, obj.EventId, obj.IsGoing).ToListAsync()
select new
{
r.EventId,
r.MemberId,
Member = r.Member.Name,
r.IsGoing,
DateTimeResponded = r.DateModified
};
return(Json(res));
}