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> 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; } }