Advertisement
Guest User

Untitled

a guest
Sep 18th, 2015
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. public class AgtLeadStatsListVM
  2. {
  3. public string LoanAgent { get; set; }
  4. public DateTime LeadDate { get; set; }
  5. public int LeadDailyCt { get; set; }
  6. public int LeadWeeklyCt { get; set; }
  7. public int LeadMTDCt { get; set; }
  8. public int LeadYTDCt { get; set; }
  9. public IEnumerable<MWFUser> AgentList { get; set; }
  10. public virtual WebLead Lead { get; set; }
  11. }
  12.  
  13. var model = new AgtLeadStatsListVM();
  14. {
  15. // Get Selected Agent's Information
  16. var AgentList = from l in db.MWFUsers
  17. where (l.UserTitle == "Banker"
  18. select l;
  19.  
  20. foreach (var agent in AgentList)
  21. {
  22.  
  23. // Daily Lead Count
  24. var LeadDailyCt = db.WebLeads.Count(x => (x.LoanAgent == agent.UserEmail)
  25. && (x.LeadDate >= todayDate && x.LeadDate <= todayEndDay));
  26.  
  27. // Weekly Lead Count
  28. var LeadWeeklyCt = db.WebLeads.Count(x => (x.LoanAgent == agent.UserEmail)
  29. && x.LeadDate >= firstOfWeek
  30. && x.LeadDate <= todayEndDay);
  31.  
  32. // Monthly Lead Count
  33. var LeadMTDCount = db.WebLeads.Count(x => (x.LoanAgent == agent.UserEmail)
  34. && x.LeadDate >= firstOfMonth
  35. && x.LeadDate <= todayEndDay);
  36.  
  37. // YTD Lead Count
  38. var LeadYTDCount = db.WebLeads.Count(x => (x.LoanAgent == agent.UserEmail)
  39. && x.LeadDate >= firstOfMonth
  40. && x.LeadDate <= todayEndDay);
  41. }
  42. }
  43.  
  44. @model LoanModule.ViewModels.AgtLeadStatsListVM
  45.  
  46. <div>
  47. @foreach (var item in Model.AgentList)
  48. {
  49. <p>@Model.LoanAgent</p>
  50. <p>@Model.LeadDailyCt</p>
  51. <p>@Model.LeadWeeklyCt</p>
  52. <p>@Model.LeadMTDCt</p>
  53. <p>@Model.LeadYTDCt</p>
  54. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement