public ActionResult NoShowCustomer(NoShowCustomerModelFilter filter = null, int pageNumber = 1)
{
int totalRecords;
var model = _eventCustomerReportingService.GetNoShowCustomers(pageNumber, _pageSize, filter, out totalRecords);
if (model == null)
{
model = new NoShowCustomerListModel();
}
model.Filter = filter;
var currentAction = ControllerContext.RouteData.Values["action"].ToString();
Func <int, string> urlFunc =
pn => Url.Action(currentAction, new
{
pageNumber = pn,
filter.FromDate,
filter.ToDate,
filter.IsRetailEvent,
filter.IsCorporateEvent,
filter.IsPublicEvent,
filter.IsPrivateEvent
});
model.PagingModel = new PagingModel(pageNumber, _pageSize, totalRecords, urlFunc);
return(View(model));
}
public NoShowCustomerListModel Create(IEnumerable <EventCustomer> eventCustomers, IEnumerable <Appointment> appointments, IEnumerable <Order> orders, EventVolumeListModel eventListModel,
IEnumerable <Customer> customers, IEnumerable <OrderedPair <long, string> > packages, IEnumerable <OrderedPair <long, string> > tests, IEnumerable <OrderedPair <long, string> > idNamePairs,
IEnumerable <OrganizationRoleUser> agents, IEnumerable <Role> roles, IEnumerable <PcpAppointment> pcpAppointments)
{
var model = new NoShowCustomerListModel();
var noShowCustomerModels = new List <NoShowCustomerModel>();
eventCustomers.ToList().ForEach(ec =>
{
var eventModel =
eventListModel.Collection.Where(
e => e.EventCode == ec.EventId).FirstOrDefault();
var order = orders.Where(o => o.EventId == ec.EventId && o.CustomerId == ec.CustomerId).FirstOrDefault();
var customer =
customers.Where(c => c.CustomerId == ec.CustomerId).FirstOrDefault();
var package =
packages.Where(p => p.FirstValue == order.Id).FirstOrDefault();
var test = tests.Where(p => p.FirstValue == order.Id).ToList();
var productPurchased = string.Empty;
if (package != null && !test.IsNullOrEmpty())
{
productPurchased =
package.SecondValue + " + " + string.Join(" + ", test.Select(t => t.SecondValue).ToArray());
}
else if (!test.IsNullOrEmpty())
{
productPurchased = string.Join(" + ", test.Select(t => t.SecondValue).ToArray());
}
else if (package != null)
{
productPurchased =
package.SecondValue;
}
var scheduledBy = ec.DataRecorderMetaData.DataRecorderCreator.Id == ec.CustomerId ? "Self" : idNamePairs.Where(p => p.FirstValue == ec.DataRecorderMetaData.DataRecorderCreator.Id).First().SecondValue;
var registeredBy = (ec.DataRecorderMetaData == null || ec.DataRecorderMetaData.DataRecorderCreator == null ? null : agents.Where(a => a.Id == ec.DataRecorderMetaData.DataRecorderCreator.Id).FirstOrDefault());
var agentRole = string.Empty;
var pcpAppointment = pcpAppointments.SingleOrDefault(m => m.EventCustomerId == ec.Id);
if (registeredBy != null)
{
agentRole = registeredBy.RoleId == (long)Roles.Customer ? "Internet" : roles.Where(r => r.Id == registeredBy.RoleId).FirstOrDefault().DisplayName;
}
var noShowCustomerModel = new NoShowCustomerModel()
{
Address = customer.Address,
CustomerCode = customer.CustomerId.ToString(),
AmountPaid = order.TotalAmountPaid,
AppointmentTime = ec.AppointmentId.HasValue ? (DateTime?)appointments.Where(a => a.Id == ec.AppointmentId.Value).FirstOrDefault().StartTime : null,
CustomerId = ec.CustomerId,
CustomerName = customer.NameAsString,
DateofBirth = customer.DateOfBirth,
Email = customer.Email != null ? customer.Email.ToString() : string.Empty,
EventId = eventModel.EventCode,
EventDate = eventModel.EventDate,
Pod = eventModel.Pod,
Gender = customer.Gender.ToString(),
Host = eventModel.Location,
HostAddress = eventModel.Address,
Package = productPurchased,
PhoneBusiness = customer.OfficePhoneNumber != null ? customer.OfficePhoneNumber.ToString() : string.Empty,
PhoneCell = customer.MobilePhoneNumber != null ? customer.MobilePhoneNumber.ToString() : string.Empty,
PhoneHome = customer.HomePhoneNumber != null ? customer.HomePhoneNumber.ToString() : string.Empty,
TotalAmount = order.DiscountedTotal,
AdSource = ec.MarketingSource,
PhoneOfficeExtension = customer.PhoneOfficeExtension,
BookingAgent = scheduledBy,
RegistrationMode = agentRole,
RegistrationDate = ec.DataRecorderMetaData != null ? (DateTime?)ec.DataRecorderMetaData.DateCreated : null,
PCPAppointmentDate = pcpAppointment != null ? pcpAppointment.AppointmentOn : (DateTime?)null,
PCPAppointmentTime = pcpAppointment != null ? pcpAppointment.AppointmentOn.ToShortTimeString() : string.Empty
};
noShowCustomerModels.Add(noShowCustomerModel);
});
model.Collection = noShowCustomerModels;
return(model);
}
