Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class AgtLeadStatsListVM
- {
- public string LoanAgent { get; set; }
- public DateTime LeadDate { get; set; }
- public int LeadDailyCt { get; set; }
- public int LeadWeeklyCt { get; set; }
- public int LeadMTDCt { get; set; }
- public int LeadYTDCt { get; set; }
- public IEnumerable<MWFUser> AgentList { get; set; }
- public virtual WebLead Lead { get; set; }
- }
- var model = new AgtLeadStatsListVM();
- {
- // Get Selected Agent's Information
- var AgentList = from l in db.MWFUsers
- where (l.UserTitle == "Banker"
- select l;
- foreach (var agent in AgentList)
- {
- // Daily Lead Count
- var LeadDailyCt = db.WebLeads.Count(x => (x.LoanAgent == agent.UserEmail)
- && (x.LeadDate >= todayDate && x.LeadDate <= todayEndDay));
- // Weekly Lead Count
- var LeadWeeklyCt = db.WebLeads.Count(x => (x.LoanAgent == agent.UserEmail)
- && x.LeadDate >= firstOfWeek
- && x.LeadDate <= todayEndDay);
- // Monthly Lead Count
- var LeadMTDCount = db.WebLeads.Count(x => (x.LoanAgent == agent.UserEmail)
- && x.LeadDate >= firstOfMonth
- && x.LeadDate <= todayEndDay);
- // YTD Lead Count
- var LeadYTDCount = db.WebLeads.Count(x => (x.LoanAgent == agent.UserEmail)
- && x.LeadDate >= firstOfMonth
- && x.LeadDate <= todayEndDay);
- }
- }
- @model LoanModule.ViewModels.AgtLeadStatsListVM
- <div>
- @foreach (var item in Model.AgentList)
- {
- <p>@Model.LoanAgent</p>
- <p>@Model.LeadDailyCt</p>
- <p>@Model.LeadWeeklyCt</p>
- <p>@Model.LeadMTDCt</p>
- <p>@Model.LeadYTDCt</p>
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement