public async Task <bool> Delete(int id) { try { var status = await _context.EventStatusType.Where(i => i.StatusName == "Pending").FirstOrDefaultAsync(); Db.Event obj = await _context.Event.Where(i => i.EventId == id).FirstOrDefaultAsync(); obj.IsDeleted = true; _context.SaveChanges(); var eventDetails = await _context.EventDetails.Where(i => i.EventId == id).ToListAsync(); if (eventDetails != null && eventDetails.Count > 0) { foreach (var itm in eventDetails) { Db.EventDetails eventDetail = await _context.EventDetails.Where(i => i.EventDetailsId == itm.EventDetailsId).FirstOrDefaultAsync(); eventDetail.IsDeleted = true; _context.SaveChanges(); } } return(await Task.Run(() => true)); } catch (Exception ex) { throw ex; } }
public async Task <bool> SaveEventDetails(EventViewModelPost modal) { try { var status = await _context.EventStatusType.Where(i => i.StatusName == "Pending").FirstOrDefaultAsync(); Db.Event obj = new Db.Event(); obj.CreatedBy = (modal.CorporateId != null && modal.CorporateId > 0) ? modal.CorporateId : (int?)null; obj.CreatedOn = DateTime.Now; obj.StatusId = (status != null) ? status.StatusId : (int?)null; obj.Name = modal.Name; obj.EmployeeRange = modal.EmployeeRange; obj.ExpectedToConduct = modal.ExpectedToConduct; obj.IsDeleted = false; obj.Location = modal.Location; obj.ScheduleTypeId = (modal.ScheduleTypeId != null && modal.ScheduleTypeId > 0) ? modal.ScheduleTypeId : (int?)null; var savedData = _context.Event.Add(obj); if (modal.EventDetails != null && modal.EventDetails.Count > 0) { foreach (var itm in modal.EventDetails) { Db.EventDetails eventD = new Db.EventDetails(); eventD.EventId = obj.EventId; eventD.EventTypeId = (itm.EventTypeId != null && itm.EventTypeId > 0) ? itm.EventTypeId : (int?)null; eventD.EventSubTypeId = (itm.EventSubTypeId != null && itm.EventSubTypeId > 0) ? itm.EventSubTypeId : (int?)null; eventD.SurfaceTypeId = itm.SurfaceTypeId; eventD.ScheduleTypeId = (itm.ScheduleTypeId != null && itm.ScheduleTypeId > 0) ? itm.ScheduleTypeId : (int?)null; eventD.Location = itm.Location; eventD.EmployeeRange = itm.EmployeeRange; eventD.ExpectedToConduct = itm.ExpectedToConduct; eventD.IsDeleted = false; obj.CreatedOn = DateTime.Now; _context.EventDetails.Add(eventD); } } _context.SaveChanges(); return(await Task.Run(() => true)); } catch (Exception ex) { throw ex; } }
public async Task <bool> AssingnVendorsToEvent(List <VendorInvitation> modal) { try { if (modal != null && modal.Count > 0) { foreach (var itm in modal) { var item = await _context.VendorInvitation.Where(i => i.EventDetailsId == itm.EventDetailsId && i.VendorId == itm.VendorId && i.IsDeleted == false).FirstOrDefaultAsync(); if (item == null) { Db.VendorInvitation eventD = new Db.VendorInvitation(); eventD.VendorId = itm.VendorId; eventD.EventDetailsId = itm.EventDetailsId; eventD.StatusId = itm.StatusId; eventD.AdminComment = itm.AdminComment; eventD.VendorComment = itm.VendorComment; eventD.Amount = itm.Amount; eventD.IsDeleted = false; eventD.CreatedBy = itm.CreatedBy; eventD.CreatedOn = System.DateTime.Now; _context.VendorInvitation.Add(eventD); var eventId = await _context.EventDetails.Where(x => x.EventDetailsId == itm.EventDetailsId).FirstOrDefaultAsync(); Db.Event _data = _context.Event.Find(eventId.EventId); _data.StatusId = 7; _context.SaveChanges(); } else { await UpdateVendorsInvitationStatus(itm); } } } _context.SaveChanges(); return(await Task.Run(() => true)); } catch (Exception ex) { throw ex; } }
public async Task <bool> UpdateEventDetails(EventViewModelPost modal) { try { var status = await _context.EventStatusType.Where(i => i.StatusName == "Pending").FirstOrDefaultAsync(); Db.Event obj = await _context.Event.Where(i => i.EventId == modal.EventID).FirstOrDefaultAsync(); obj.StatusId = (status != null) ? status.StatusId : (int?)null; obj.Name = modal.Name; obj.EmployeeRange = modal.EmployeeRange; obj.ExpectedToConduct = modal.ExpectedToConduct; obj.Location = modal.Location; obj.ScheduleTypeId = (modal.ScheduleTypeId != null && modal.ScheduleTypeId > 0) ? modal.ScheduleTypeId : (int?)null; _context.SaveChanges(); if (modal.EventDetails != null && modal.EventDetails.Count > 0) { foreach (var itm in modal.EventDetails) { Db.EventDetails eventD = await _context.EventDetails.Where(i => i.EventDetailsId == itm.EventDetailsID).FirstOrDefaultAsync(); eventD.EventTypeId = (itm.EventTypeId != null && itm.EventTypeId > 0) ? itm.EventTypeId : (int?)null; eventD.EventSubTypeId = (itm.EventSubTypeId != null && itm.EventSubTypeId > 0) ? itm.EventSubTypeId : (int?)null; eventD.SurfaceTypeId = itm.SurfaceTypeId; eventD.ScheduleTypeId = (itm.ScheduleTypeId != null && itm.ScheduleTypeId > 0) ? itm.ScheduleTypeId : (int?)null; eventD.Location = itm.Location; eventD.EmployeeRange = itm.EmployeeRange; eventD.ExpectedToConduct = itm.ExpectedToConduct; _context.SaveChanges(); } } return(await Task.Run(() => true)); } catch (Exception ex) { throw ex; } }
public async Task <bool> UpdateEventStatus(AssignVendorEventPUT modal) { try { Db.Event obj = _context.Event.Find(modal.EventId); if (obj == null) { throw new Exception("Requested event empty"); } obj.StatusId = modal.StatusId; obj.ModifiedBy = modal.ModifiedBy; obj.ModifiedOn = DateTime.Now; _context.SaveChanges(); return(await Task.Run(() => true)); } catch (Exception ex) { throw ex; } }
public async Task <bool> UpdateVendorsInvitationStatus(VendorInvitation modal) { try { if (modal != null) { Db.VendorInvitation eventD = await _context.VendorInvitation.Where(x => x.EventDetailsId == modal.EventDetailsId && x.VendorId == modal.VendorId).FirstOrDefaultAsync(); eventD.StatusId = modal.StatusId; if (modal.AdminComment != null) { eventD.AdminComment = modal.AdminComment; } if (modal.VendorComment != null) { eventD.VendorComment = modal.VendorComment; } if (modal.Amount != null) { eventD.Amount = modal.Amount; } if (modal.AdminAmount != null) { eventD.AdminAmount = modal.AdminAmount; eventD.AdminPerc = modal.AdminPerc; } _context.SaveChanges(); if (modal.StatusId == 3) { var data = await _context.VendorInvitation.Where(x => x.EventDetailsId == modal.EventDetailsId).ToListAsync(); bool _result = false; if (data != null) { foreach (var itm in data) { if (itm.StatusId == 3) { _result = true; break; } else { _result = false; } } } if (_result == true) { var eventId = await _context.EventDetails.Where(x => x.EventDetailsId == modal.EventDetailsId).FirstOrDefaultAsync(); Db.Event _data = _context.Event.Find(eventId.EventId); _data.StatusId = 3; _context.SaveChanges(); } } if (modal.StatusId == 7) { var eventId = await _context.EventDetails.Where(x => x.EventDetailsId == modal.EventDetailsId).FirstOrDefaultAsync(); Db.Event _data = _context.Event.Find(eventId.EventId); _data.StatusId = 7; _context.SaveChanges(); } if (modal.StatusId == 9) { var eventId = await _context.EventDetails.Where(x => x.EventDetailsId == modal.EventDetailsId).FirstOrDefaultAsync(); Db.Event _data = _context.Event.Find(eventId.EventId); _data.StatusId = 9; _context.SaveChanges(); } } return(await Task.Run(() => true)); } catch (Exception ex) { throw ex; } }