public IQueryable <CampaignStatusHelper> GetLeadsSalesStatusStats(int campaignId)
{
var entites = _db.Leads.Where(x => x.RelatedCampaignId == campaignId).GroupBy(x => x.LeadStatus);
var model = new List <CampaignStatusHelper>();
foreach (var entity in entites)
{
string status;
switch (entity.Key)
{
case Lead.LeadStatusEnum.Start:
status = "Kreirano";
break;
case Lead.LeadStatusEnum.Incontact:
status = "U kontaktu";
break;
case Lead.LeadStatusEnum.Rejected:
status = "Odbijeno";
break;
case Lead.LeadStatusEnum.Quotesent:
status = "Poslana ponuda";
break;
case Lead.LeadStatusEnum.Accepted:
status = "Prihvaćena ponuda";
break;
case Lead.LeadStatusEnum.Meeting:
status = "Dogovoren sastanak";
break;
case Lead.LeadStatusEnum.Processdifficulties:
status = "Procesne poteškoće";
break;
default:
status = "Status leada";
break;
}
var temp = new CampaignStatusHelper
{
StatusName = status,
SumOfEntities = entity.Count()
};
model.Add(temp);
}
return(model.AsQueryable());
}
public IQueryable <CampaignStatusHelper> GetOpportunitiesSalesStatusStats(int campaignId)
{
var entites = _db.Opportunities.Where(x => x.RelatedCampaignId == campaignId).GroupBy(x => x.OpportunityStatus);
var model = new List <CampaignStatusHelper>();
foreach (var entity in entites)
{
string status = GetOpportunityStatusString(entity.Key);
var temp = new CampaignStatusHelper
{
StatusName = status,
SumOfEntities = entity.Count()
};
model.Add(temp);
}
return(model.AsQueryable());
}
public IQueryable <CampaignStatusHelper> GetEducationStatusStats(int campaignId)
{
var entites = _db.Educations.Where(x => x.RelatedCampaignId == campaignId).GroupBy(x => x.EducationEntityStatus);
var model = new List <CampaignStatusHelper>();
foreach (var entity in entites)
{
string status;
switch (entity.Key)
{
case Education.EducationEntityStatusEnum.Created:
status = "Kreirano";
break;
case Education.EducationEntityStatusEnum.InContact:
status = "U kontaktu";
break;
case Education.EducationEntityStatusEnum.InvitationSent:
status = "Poslan poziv";
break;
case Education.EducationEntityStatusEnum.Accepted:
status = "Prihvaćeno";
break;
case Education.EducationEntityStatusEnum.Rejected:
status = "Odbijeno";
break;
default:
status = "Status edukacije";
break;
}
var temp = new CampaignStatusHelper
{
StatusName = status,
SumOfEntities = entity.Count()
};
model.Add(temp);
}
return(model.AsQueryable());
}
public IQueryable <CampaignStatusHelper> GetEmailBasesEntityStats(int campaignId)
{
var entites = _db.AcquireEmails.Where(x => x.Campaign.CampaignId == campaignId).GroupBy(x => x.AcquireEmailEntityStatus);
var model = new List <CampaignStatusHelper>();
foreach (var entity in entites)
{
string status;
switch (entity.Key)
{
case AcquireEmail.AcquireEmailEntityStatusEnum.Created:
status = "Kreirano";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.AcquiredInformation:
status = "Prikupljena povratna informacija";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.NoAnswer:
status = "Nema odgovora / Ne javlja se";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.ClosedOrganization:
status = "Zatvorena tvrtka";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.OldPartner:
status = "Ne poslujus s korisnikom";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.PartnerWillContactUser:
status = "Partner će se javiti korisniku samostalno";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.WrittenConfirmationRequired:
status = "Potrebno poslati pisanu suglasnost";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.WrongTelephoneNumber:
status = "Neispravan kontakt broj";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.PoslovnaHrvatska:
status = "Kontakt u bazi";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.NoTelehoneNumber:
status = "Ne postoji ispravan kontakt broj";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.Bankruptcy:
status = "Subjekt u stečaju / likvidaciji";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.NoFinancialAccount:
status = "Subjekt nema žiro račun";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.ToBeClosed:
status = "Najava brisanja subjekta";
break;
case AcquireEmail.AcquireEmailEntityStatusEnum.Post:
status = "Žele primati račune poštom";
break;
default:
status = "Status unosa";
break;
}
var temp = new CampaignStatusHelper()
{
StatusName = status,
SumOfEntities = entity.Count()
};
model.Add(temp);
}
return(model.AsQueryable());
}
