Guest User

Untitled

a guest
Jun 23rd, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.29 KB | None | 0 0
  1. [HttpPost]public ActionResult Prospects(Guid[] selectedProperties, DateTime? startDate, DateTime? endDate,string name, string notes, string mobile){IQueryable<ProspectProperty> query = _db.ProspectProperty.Where(p => p.Property.Agents.Any(a => a.User.UserID == UserID));if (selectedProperties != null && selectedProperties.Any())query = query.Where(LinqHelpers.BuildOrExpression<ProspectProperty, Guid>(p => p.Property.PropertyID, selectedProperties));if (startDate.HasValue)query = query.Where(p => p.InspectedOn >= startDate);if (endDate.HasValue)query = query.Where(p => p.InspectedOn <= endDate);if (!string.IsNullOrEmpty(name))query = query.Where(p => p.Prospect.ProspectName.Contains(name));if (!string.IsNullOrEmpty(notes))query = query.Where(p => p.Prospect.NoteText.Contains(notes));if (!string.IsNullOrEmpty(mobile))query = query.Where(p => p.Prospect.Mobile.Contains(mobile));IEnumerable<ProspectReportItem> results = query.Select(pp => new ProspectReportItem{Name = pp.Prospect.ProspectName,Mobile = pp.Prospect.Mobile,Email = pp.Prospect.EmailAddress,PropertyName = pp.Property.DisplayName,OpenTime = pp.PropertyOpen.ScheduleText,Notes = pp.Prospect.NoteText});if (!Request.IsAjaxRequest())return File(Encoding.Default.GetBytes(results.AsCsv(true, null)), "text/csv", "TouchBaseExport.csv");return View(results);}
Add Comment
Please, Sign In to add comment