Notes

public List<LeadViewModel> FindSalesLeads(Func<LeadViewModel, bool> specification, int page, int pageCount)
{
using var context = new CRMContext();



var salesDepartmentId = context.Departments.FirstOrDefault(d => d.Name == "Sales")?.Id;
var creditDepartmentId = context.Departments.FirstOrDefault(d => d.Name == "Credit")?.Id;

var salesLeadsQuery =
from lead in context.Leads
join salesStage in context.SalesStages on lead.SalesStageId equals salesStage.Id into salesStages
from salesStage in salesStages.DefaultIfEmpty()
join creditStage in context.CreditStages on lead.CreditStageId equals creditStage.Id into creditStages
from creditStage in creditStages.DefaultIfEmpty()
join source in context.Sources on lead.SourceId equals source.Id into sources
from source in sources.DefaultIfEmpty()
join userSale in context.Users on lead.AssignedSalesId equals userSale.Id into users
from userSale in users.DefaultIfEmpty()
join dep in context.Departments on lead.DepartmentId equals dep.Id into departaments
from dep in departaments.DefaultIfEmpty()
where lead.DepartmentId == salesDepartmentId || lead.DepartmentId == creditDepartmentId
orderby lead.CreatedAt descending
select new LeadViewModel
{
// Include the properties you need
Id = lead.Id,
FirstName = lead.FirstName,
LastName = lead.LastName,
FatherName = lead.FatherName,
Source = lead.Source.Name,
LastUpdatedAt = lead.LastUpdatedAt,
CreatedAt = lead.CreatedAt,
IsReadBySales = lead.IsReadBySales,
AssignedUserFullName = $"{lead.AssignedSales.FirstName} {lead.AssignedSales.LastName}",
Stage = lead.Department.Name.ToLower() == "credit" && (lead.IsReadByCreditor == true && lead.CreditStage != null)
? lead.CreditStage.Name : lead.SalesStage.Name,
SalesStageId = lead.SalesStageId,
SalesStageName = lead.SalesStage.Name,
LeadPhones = context.LeadPhones
.Where(lp => lp.LeadId == lead.Id)
.Select(lp => new LeadPhoneViewModel
{
// Include the properties you need for LeadPhoneViewModel
Phone = lp.PhoneNumber,
// Other properties...
})
.ToList(),
DepartamentName = lead.Department.Name,
AssignedSalesId = lead.AssignedSalesId

};

var salesLeads = salesLeadsQuery.Where(specification).Skip(page*pageCount).Take(pageCount).ToList();
return salesLeads;
}




List<LeadViewModel> FindSalesLeads(Func<LeadViewModel, bool> specification , int page , int pageCount);