/// <summary> /// Invitations of staff to a room only event created /// </summary> /// <param name="staff"></param> /// <param name="eventId"></param> /// <returns></returns> public bool AddStaffInvitesToEvent(List<Staff> staff, int eventId) { if (eventId != 0) { //selection of all current invites for the event created var allInvites = _dBase.StaffInvites.Where(x => x.EventId == eventId).ToList(); if (allInvites.Count > 0) { foreach (var i in allInvites) { //old invitations removed var recycledId = new RecycledId { IdRecovered = i.StaffInviteId, DateAdded = DateTime.Now.AddSeconds(1), TableName = "Staff Invite" }; _dBase.StaffInvites.Remove(i); _dBase.RecycledIds.Add(recycledId); _dBase.SaveChanges(); } } //new invitations creatde and adde to the database foreach (var s in staff) { //staff invite id generation var staffInviteId = StaffInvitesIdGeneration(); //new staff invite created var staffInvite = new StaffInvite { EventId = eventId, StaffId = s.StaffId, StaffInviteId = staffInviteId, Attending = false }; _dBase.StaffInvites.Add(staffInvite); _dBase.SaveChanges(); } return true; } return false; }
/// <summary> /// Staff invite created for staff member attendance to events that /// have been assigned a room only /// </summary> /// <param name="eventId"></param> /// <param name="staffId"></param> /// <returns></returns> public bool StaffInvite(int eventId, int staffId) { if (eventId != 0 && staffId != 0) { //id generated var inviteId = StaffInvitesIdGeneration(); //staff invite created var staffEvent = new StaffInvite { StaffInviteId = inviteId, StaffId = staffId, EventId = eventId, Attending = true }; //staff invite added to database _dBase.StaffInvites.Add(staffEvent); _dBase.SaveChanges(); return true; } return false; }