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