public async Task <ActionResult> CorporateApprovedVendor([FromBody] AssignVendorEvent _input)
{
List <VendorInvitation> _list = new List <VendorInvitation>();
foreach (var item in _input.VIDetails)
{
VendorInvitation model = new VendorInvitation();
model.VendorId = item.UserId;
model.EventDetailsId = item.EventDetailsId;
model.StatusId = 9;
_list.Add(model);
}
var value = HttpContext.Session.GetString(SessionToken);
if (string.IsNullOrEmpty(value))
{
string token = await getToken();
HttpContext.Session.SetString(SessionToken, token);
value = HttpContext.Session.GetString(SessionToken);
}
bool _out = await _event.AssingnVendorsToEvent(value, _list);
if (_out == true)
{
return(Json(_input.EventId));
}
return(null);
}
public async Task <bool> UpdateVendorsInvitationStatus(string token, VendorInvitation _input)
{
bool result;
var requestUri = $"{HostedUri}" + "/UpdateVendorsInvitationStatus/";
var response = await HttpRequestFactory.Put(requestUri, _input, token);
Console.WriteLine($"Status: {response.StatusCode}");
result = response.ContentAsType <bool>();
return(await Task.Run(() => result));
}
public async Task <JsonResult> SaveVendorAcceptForm([FromBody] VendorInvitation model)
{
model.StatusId = 1;
var value = HttpContext.Session.GetString(SessionToken);
if (string.IsNullOrEmpty(value))
{
string token = await getToken();
HttpContext.Session.SetString(SessionToken, token);
value = HttpContext.Session.GetString(SessionToken);
}
bool _out = await _event.UpdateVendorsInvitationStatus(value, model);
return(Json(1));
}
public async Task <IActionResult> UpdateVendorsInvitationStatus([FromBody] VendorInvitation value)
{
return(Ok(await _event.UpdateVendorsInvitationStatus(value)));
}
public async Task <EventViewModel> GetVendorEvent(int Eventid, int vID)
{
try
{
var itm = _context.Event.Where(i => i.EventId == Eventid && i.IsDeleted == false).FirstOrDefault();
EventViewModel obj = new EventViewModel();
obj.EventId = itm.EventId;
obj.Name = itm.Name;
obj.StatusId = itm.StatusId;
obj.StatusName = _context.EventStatusType.Find(itm.StatusId).StatusName;
obj.CorporateId = itm.CreatedBy;
obj.CreatedUser = await GetUser(Convert.ToInt32(itm.CreatedBy));
obj.EmployeeRange = itm.EmployeeRange;
obj.ExpectedToConduct = itm.ExpectedToConduct;
obj.Location = itm.Location;
obj.CreatedOn = itm.CreatedOn;
obj.ScheduleType = (itm.ScheduleTypeId != null) ? _context.ScheduleType.Find(itm.ScheduleTypeId).ScheduleTypeName : string.Empty;
obj.ScheduleTypeId = itm.ScheduleTypeId;
List <EventDetailsViewModel> _dataList = new List <EventDetailsViewModel>();
var itm1 = await _context.EventDetails.Where(i => i.EventId == Eventid && i.IsDeleted == false).ToListAsync();
if (itm1 != null && itm1.Count > 0)
{
foreach (var k in itm1)
{
EventDetailsViewModel _data = new EventDetailsViewModel();
_data.EventDetailsId = k.EventDetailsId;
var itm2 = await _context.VendorInvitation.Where(i => i.EventDetailsId == k.EventDetailsId && i.VendorId == vID && i.IsDeleted == false).FirstOrDefaultAsync();
if (itm2 != null)
{
_data.EventSubTypeId = k.EventSubTypeId;
_data.EventSubType = (k.EventSubTypeId == null) ? string.Empty : _context.EventSubType.Find(k.EventSubTypeId).SubTypeName;
_data.EventTypeId = k.EventTypeId;
_data.EventType = (k.EventTypeId == null) ? string.Empty : _context.EventType.Find(k.EventTypeId).EventTypeName;
_data.SurfaceTypeId = k.SurfaceTypeId;
_data.SurfaceType = "";
_data.EmployeeRange = k.EmployeeRange;
_data.ExpectedToConduct = k.ExpectedToConduct;
_data.Location = k.Location;
VendorInvitation _bdta = new VendorInvitation();
_bdta.VendorInvitationId = itm2.VendorInvitationId;
_bdta.EventDetailsId = itm2.EventDetailsId;
_bdta.VendorId = itm2.VendorId;
_bdta.StatusId = itm2.StatusId;
_bdta.AdminComment = itm2.AdminComment;
_bdta.VendorComment = itm2.VendorComment;
_bdta.Amount = itm2.Amount;
_bdta.StatusName = _context.EventStatusType.Find(Convert.ToInt32(itm2.StatusId)).StatusName;
obj.VendorInvitation = _bdta;
_data.VendorInvitation = _bdta;
_dataList.Add(_data);
if (itm.StatusId == 3 && itm2.StatusId == 3)
{
obj.FinalVendorStatus = _context.EventStatusType.Find(itm.StatusId).StatusName;
}
else if (itm.StatusId == 3 && itm2.StatusId != 3)
{
obj.FinalVendorStatus = _context.EventStatusType.Find(6).StatusName;
}
else
{
obj.FinalVendorStatus = _context.EventStatusType.Find(7).StatusName;
}
}
}
obj.EventDetails = _dataList;
}
return(await Task.Run(() => obj));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <List <ModelClass.EventViewModel> > GetAllByVendorId(int Id)
{
try
{
List <ModelClass.EventViewModel> _list = new List <ModelClass.EventViewModel>();
var itm2 = await _context.VendorInvitation.Where(i => i.VendorId == Id && i.IsDeleted == false).OrderByDescending(x => x.VendorInvitationId).ToListAsync();
if (itm2 != null && itm2.Count > 0)
{
foreach (var U in itm2)
{
var itEv = await _context.EventDetails.Where(i => i.EventDetailsId == U.EventDetailsId && i.IsDeleted == false).FirstOrDefaultAsync();
var itm = _context.Event.Where(i => i.EventId == itEv.EventId && i.IsDeleted == false).FirstOrDefault();
EventViewModel obj = new EventViewModel();
obj.EventId = itm.EventId;
obj.Name = itm.Name;
obj.StatusId = itm.StatusId;
obj.StatusName = _context.EventStatusType.Find(itm.StatusId).StatusName;
obj.CorporateId = itm.CreatedBy;
obj.CreatedUser = await GetUser(Convert.ToInt32(itm.CreatedBy));
obj.EmployeeRange = itm.EmployeeRange;
obj.ExpectedToConduct = itm.ExpectedToConduct;
obj.Location = itm.Location;
obj.CreatedOn = itm.CreatedOn;
obj.ScheduleType = (itm.ScheduleTypeId != null) ? _context.ScheduleType.Find(itm.ScheduleTypeId).ScheduleTypeName : string.Empty;
obj.ScheduleTypeId = itm.ScheduleTypeId;
if (itm.StatusId == 3 && U.StatusId == 3)
{
obj.FinalVendorStatus = _context.EventStatusType.Find(itm.StatusId).StatusName;
}
else if (itm.StatusId == 3 && U.StatusId != 3)
{
obj.FinalVendorStatus = _context.EventStatusType.Find(6).StatusName;
}
else
{
obj.FinalVendorStatus = _context.EventStatusType.Find(7).StatusName;
}
VendorInvitation _bdta = new VendorInvitation();
_bdta.VendorInvitationId = U.VendorInvitationId;
_bdta.EventDetailsId = U.EventDetailsId;
_bdta.VendorId = U.VendorId;
_bdta.AdminComment = U.AdminComment;
_bdta.VendorComment = U.VendorComment;
_bdta.StatusId = U.StatusId;
_bdta.Amount = U.Amount;
_bdta.StatusName = _context.EventStatusType.Find(Convert.ToInt32(U.StatusId)).StatusName;
obj.VendorInvitation = _bdta;
List <EventDetailsViewModel> _dataList = new List <EventDetailsViewModel>();
var itm1 = await _context.EventDetails.Where(i => i.EventId == itm.EventId && i.IsDeleted == false).ToListAsync();
if (itm1 != null && itm1.Count > 0)
{
foreach (var k in itm1)
{
EventDetailsViewModel _data = new EventDetailsViewModel();
_data.EventDetailsId = k.EventDetailsId;
_data.EventSubTypeId = k.EventSubTypeId;
_data.EventSubType = (k.EventSubTypeId == null) ? string.Empty : _context.EventSubType.Find(k.EventSubTypeId).SubTypeName;
_data.EventTypeId = k.EventTypeId;
_data.EventType = (k.EventTypeId == null) ? string.Empty : _context.EventType.Find(k.EventTypeId).EventTypeName;
_data.SurfaceTypeId = k.SurfaceTypeId;
_data.SurfaceType = "";
_data.EmployeeRange = k.EmployeeRange;
_data.ExpectedToConduct = k.ExpectedToConduct;
_data.Location = k.Location;
var itm7 = await _context.VendorInvitation.Where(i => i.EventDetailsId == k.EventDetailsId && i.VendorId == Id && i.IsDeleted == false).OrderByDescending(x => x.VendorInvitationId).FirstOrDefaultAsync();
VendorInvitation _bdta1 = new VendorInvitation();
_bdta1.VendorInvitationId = itm7.VendorInvitationId;
_bdta1.EventDetailsId = itm7.EventDetailsId;
_bdta1.VendorId = itm7.VendorId;
_bdta1.AdminComment = itm7.AdminComment;
_bdta1.VendorComment = itm7.VendorComment;
_bdta1.StatusId = itm7.StatusId;
_bdta1.Amount = itm7.Amount;
_bdta1.StatusName = _context.EventStatusType.Find(Convert.ToInt32(itm7.StatusId)).StatusName;
_data.VendorInvitation = _bdta1;
_dataList.Add(_data);
}
obj.EventDetails = _dataList;
}
_list.Add(obj);
}
}
return(await Task.Run(() => _list));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <EventViewModel> GetCorporateEvent(int id)
{
try
{
var itm = _context.Event.Where(i => i.EventId == id && i.IsDeleted == false).FirstOrDefault();
EventViewModel obj = new EventViewModel();
obj.EventId = itm.EventId;
obj.Name = itm.Name;
obj.StatusId = itm.StatusId;
obj.StatusName = _context.EventStatusType.Find(itm.StatusId).StatusName;
obj.CorporateId = itm.CreatedBy;
obj.CreatedUser = await GetUser(Convert.ToInt32(itm.CreatedBy));
obj.EmployeeRange = itm.EmployeeRange;
obj.ExpectedToConduct = itm.ExpectedToConduct;
obj.Location = itm.Location;
obj.CreatedOn = itm.CreatedOn;
obj.ScheduleType = (itm.ScheduleTypeId != null) ? _context.ScheduleType.Find(itm.ScheduleTypeId).ScheduleTypeName : string.Empty;
obj.ScheduleTypeId = itm.ScheduleTypeId;
List <EventDetailsViewModel> _dataList = new List <EventDetailsViewModel>();
var itm1 = await _context.EventDetails.Where(i => i.EventId == id && i.IsDeleted == false).ToListAsync();
if (itm1 != null && itm1.Count > 0)
{
foreach (var k in itm1)
{
EventDetailsViewModel _data = new EventDetailsViewModel();
_data.EventDetailsId = k.EventDetailsId;
_data.EventSubTypeId = k.EventSubTypeId;
_data.EventSubType = (k.EventSubTypeId == null) ? string.Empty : _context.EventSubType.Find(k.EventSubTypeId).SubTypeName;
_data.EventTypeId = k.EventTypeId;
_data.EventType = (k.EventTypeId == null) ? string.Empty : _context.EventType.Find(k.EventTypeId).EventTypeName;
_data.SurfaceTypeId = k.SurfaceTypeId;
_data.SurfaceType = "";
_data.EmployeeRange = k.EmployeeRange;
_data.ExpectedToConduct = k.ExpectedToConduct;
_data.Location = k.Location;
List <User> _userList = new List <User>();
if (obj.StatusId == 3)
{
var itm2 = await _context.VendorInvitation.Where(i => i.EventDetailsId == k.EventDetailsId && i.IsDeleted == false && i.StatusId == 3).ToListAsync();
if (itm2 != null && itm2.Count > 0)
{
foreach (var U in itm2)
{
User _user = new User();
_user = await GetUser(Convert.ToInt32(U.VendorId));
VendorInvitation _bdta = new VendorInvitation();
_bdta.VendorInvitationId = U.VendorInvitationId;
_bdta.EventDetailsId = U.EventDetailsId;
_bdta.VendorId = U.VendorId;
_bdta.StatusId = U.StatusId;
_bdta.AdminComment = U.AdminComment;
_bdta.VendorComment = U.VendorComment;
_bdta.AdminAmount = U.AdminAmount;
_bdta.AdminPerc = U.AdminPerc;
_bdta.StatusName = _context.EventStatusType.Find(Convert.ToInt32(U.StatusId)).StatusName;
_user.VendorInvitation = _bdta;
_userList.Add(_user);
}
_data.Assignedser = _userList;
}
}
else
{
var itm2 = await _context.VendorInvitation.Where(i => i.EventDetailsId == k.EventDetailsId && i.IsDeleted == false && (i.StatusId == 5 || i.StatusId == 9)).ToListAsync();
if (itm2 != null && itm2.Count > 0)
{
foreach (var U in itm2)
{
User _user = new User();
_user = await GetUser(Convert.ToInt32(U.VendorId));
VendorInvitation _bdta = new VendorInvitation();
_bdta.VendorInvitationId = U.VendorInvitationId;
_bdta.EventDetailsId = U.EventDetailsId;
_bdta.VendorId = U.VendorId;
_bdta.StatusId = U.StatusId;
_bdta.AdminComment = U.AdminComment;
_bdta.VendorComment = U.VendorComment;
_bdta.AdminAmount = U.AdminAmount;
_bdta.AdminPerc = U.AdminPerc;
_bdta.StatusName = _context.EventStatusType.Find(Convert.ToInt32(U.StatusId)).StatusName;
_user.VendorInvitation = _bdta;
_userList.Add(_user);
}
_data.Assignedser = _userList;
}
}
_dataList.Add(_data);
}
obj.EventDetails = _dataList;
}
return(await Task.Run(() => obj));
}
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;
}
}
