//Details
public IActionResult Details(int id)
{
if (id == 0)
{
return(NotFound());
}
ListVisitModel visitor = repository.GetVisitorById(id);
if (visitor == null)
{
return(NotFound());
}
return(PartialView("DetailsPopUp", visitor));
}
//Gets all the Visit List for Admin
public List <ListVisitModel> GetVisits()
{
context = new VisitorManagementContext();
var list = context.VisitDetail.ToList();
List <ListVisitModel> listVisitModel = new List <ListVisitModel>();
foreach (var item in list)
{
ListVisitModel visit = new ListVisitModel();
visit.VisitorId = item.VisitorId;
var Visit = context.Visitor.FirstOrDefault(x => x.VisitorId == item.VisitorId);
visit.VisitorName = Visit.VisitorName;
visit.Company = Visit.Company;
visit.Designation = Visit.Designation;
visit.EmailAddress = Visit.EmailAddress;
visit.StartTime = item.StartTime;
visit.EndTime = item.EndTime;
visit.IsDeleted = item.IsDeleted;
visit.PhotoUrl = ImageReader(Visit.PhotoUrl);
visit.VisitDetailId = item.VisitDetailId;
visit.ActualTimeIn = item.ActualTimeIn;
visit.ActualTimeOut = item.ActualTimeOut;
if (context.VisitParticipant.Where(r => r.VisitDetailId == item.VisitDetailId && r.IsPrimary == true).Count() > 0)
{
int contactPersonId = context.VisitParticipant.Where(r => r.VisitDetailId == item.VisitDetailId && r.IsPrimary == true).FirstOrDefault().ParticipantId;
visit.ContactPerson = context.User.Where(r => r.UserID == contactPersonId).FirstOrDefault().FirstName;
}
visit.IsOwner = true;
listVisitModel.Add(visit);
}
return(listVisitModel);
}
public HashSet <ListVisitModel> UserVisits(int uID)
{
context = new VisitorManagementContext();
HashSet <ListVisitModel> listVisitModel = new HashSet <ListVisitModel>();
var participentsRes = context.VisitParticipant.Where(x => x.ParticipantId == uID).ToList();
var res = context.VisitDetail.Where(x => x.CreatedBy == uID).ToList();
foreach (var item1 in res)
{
if (item1.CreatedBy == uID)
{
if (participentsRes.Where(r => r.VisitDetailId == item1.VisitDetailId).Count() > 0)
{
var list = participentsRes.Where(r => r.VisitDetailId == item1.VisitDetailId).ToList();
foreach (VisitParticipant visitParticipant in list)
{
participentsRes.Remove(visitParticipant);
}
}
ListVisitModel visit = new ListVisitModel();
visit.VisitDetailId = item1.VisitDetailId;
visit.VisitorId = item1.VisitorId;
var Visit = context.Visitor.FirstOrDefault(x => x.VisitorId == item1.VisitorId);
visit.VisitorName = Visit.VisitorName;
visit.Company = Visit.Company;
visit.Designation = Visit.Designation;
visit.EmailAddress = Visit.EmailAddress;
visit.StartTime = item1.StartTime;
visit.EndTime = item1.EndTime;
visit.IsDeleted = item1.IsDeleted;
visit.PhotoUrl = ImageReader(Visit.PhotoUrl);
visit.VisitDetailId = item1.VisitDetailId;
visit.ActualTimeIn = item1.ActualTimeIn;
visit.ActualTimeOut = item1.ActualTimeOut;
visit.IsOwner = true;
if (context.VisitParticipant.Where(r => r.VisitDetailId == item1.VisitDetailId && r.IsPrimary == true).Count() > 0)
{
int contactPersonId = context.VisitParticipant.Where(r => r.VisitDetailId == item1.VisitDetailId && r.IsPrimary == true).FirstOrDefault().ParticipantId;
visit.ContactPerson = context.User.Where(r => r.UserID == contactPersonId).FirstOrDefault().FirstName;
}
listVisitModel.Add(visit);
}
}
foreach (var item in participentsRes)
{
ListVisitModel visit1 = new ListVisitModel();
visit1.VisitDetailId = item.VisitDetailId;
var visitDetail = context.VisitDetail.FirstOrDefault(x => x.VisitDetailId == item.VisitDetailId);
visit1.VisitorId = visitDetail.VisitorId;
var Visit = context.Visitor.FirstOrDefault(x => x.VisitorId == visitDetail.VisitorId);
visit1.VisitorName = Visit.VisitorName;
visit1.Company = Visit.Company;
visit1.Designation = Visit.Designation;
visit1.EmailAddress = Visit.EmailAddress;
visit1.StartTime = visitDetail.StartTime;
visit1.EndTime = visitDetail.EndTime;
visit1.PhotoUrl = ImageReader(Visit.PhotoUrl);
visit1.VisitDetailId = item.VisitDetailId;
visit1.ActualTimeIn = visitDetail.ActualTimeIn;
if (context.VisitParticipant.Where(r => r.VisitDetailId == item.VisitDetailId && r.IsPrimary == true).Count() > 0)
{
int contactPersonId = context.VisitParticipant.Where(r => r.VisitDetailId == item.VisitDetailId && r.IsPrimary == true).FirstOrDefault().ParticipantId;
visit1.ContactPerson = context.User.Where(r => r.UserID == contactPersonId).FirstOrDefault().FirstName;
}
visit1.IsOwner = false;
listVisitModel.Add(visit1);
}
return(listVisitModel);
}
