public static List <LeadActivityByBranch> LeadByBranch(LeadActivityByBranchFilter filter)
{
using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext())
{
var query = db.VwGetLeadsByActivities.Select(x => new LeadActivityByBranch
{
BranchName = x.BranchName,
NumberOfActivities = (int)x.NumberOfActivities,
CoreBranchId = x.CoreBranchId,
DateCreated = x.DateCreated,
LeadID = x.LeadId,
LeadStatusId = x.LeadStatusId,
StatusName = x.StatusName
}).ToList().AsQueryable();
var mine = query;
if (filter.CoreBranchId > 0)
{
mine = mine.Where(x => x.CoreBranchId == filter.CoreBranchId);
}
if (filter.LeadStatusId > 0)
{
mine = mine.Where(x => x.LeadStatusId == filter.LeadStatusId);
}
filter.TotalResults = mine.Count();
return(mine.ToList());
}
}
public ActionResult LeadByABranch()
{
LeadActivityByBranchFilter model = new LeadActivityByBranchFilter()
{
ShowReport = false
};
return(View(model));
}
public ActionResult LeadByABranch(LeadActivityByBranchFilter model)
{
model.ShowReport = true;
model.Results = LeadReportCore.LeadByBranch(model);
return(View(model));
}
