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