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