public ActionResult ExportAdvanceSearchAllFieldsToExcel()
{
var lead = _db.Leads.AsQueryable();
var langId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]);
//cases = AdvanceSearchCasesData(filters, cases);
var list = lead.ToList().Select(x =>
new LeadViewModel()
{
Id = x.Id,
Name = x.Name,
Address = x.Address,
Email=x.Email,
Phone_Number=x.Phone_Number,
Notes=x.Notes,
Created_Date=x.Created_Date,
CampaignId=x.CampaignId,
AssigneeId=x.AssigneeId,
AssigneeName= LanguageFallbackHelper.GetUserProfile((x.UserProfile?.Id ?? 0), langId)?.FullName,
CampaignName = LanguageFallbackHelper.GetCampaigns(x.Campaign.Id, langId).Name
});
var result = ReportHelper.WriteCsvToMemory(list);
var memoryStream = new MemoryStream(result);
return new FileStreamResult(memoryStream, "text/csv") { FileDownloadName = $"FullLeadReport-{DateTime.Now}.csv" };
}
// GET: Home/LeadInfo/5
public ActionResult LeadInfo(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
var formData = _db.Leads.Where(t => t.Id == id).FirstOrDefault();
var currentLanguageId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]);
ViewBag.message= TempData["message"];
ViewBag.SMSmessage = TempData["SMSmessage"];
var leadVm = new LeadViewModel()
{
Name = formData.Name,
Email = formData.Email,
Address = formData.Address,
Status = (LeadStatusEnum)formData.Status,
Phone_Number = formData.Phone_Number,
Notes = formData.Notes,
Created_Date = formData.Created_Date,
AssigneeId=formData.AssigneeId,
AssigneeName = LanguageFallbackHelper.GetUserProfile((formData.UserProfile?.Id??0), currentLanguageId)?.FullName,
CampaignId = formData.CampaignId,
CampaignName = LanguageFallbackHelper.GetCampaigns(formData.Campaign.Id, currentLanguageId).Name
};
ViewBag.Lead_ID = id;
return View(leadVm);
}
public ActionResult Index(int? campaignNo)
{
var companyId = SessionHelper.GetCompanyId();
var CampaignList = _db.Campaigns.Where(r => r.CompanyId == companyId).Select(r=>r.Id).ToList();
int NewLeads;
int QualifiedLeads;
int WonLeads;
int LostLeads;
var currentLanguageId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]);
var LeadList = _db.Leads.Where(r=> CampaignList.Contains(r.CampaignId.Value)).ToList();
if (campaignNo != null)
{
LeadList = _db.Leads.Where(x => x.CampaignId == campaignNo).ToList();
}
var LeadList_result = LeadList.Select(r =>
new LeadViewModel
{
Id = r.Id,
Status = (LeadStatusEnum)r.Status,
Email = r.Email,
Name = r.Name,
Address=r.Address,
Phone_Number = r.Phone_Number,
Notes=r.Notes,
Created_Date=r.Created_Date,
AssigneeId = r.AssigneeId,
AssigneeName = LanguageFallbackHelper.GetUserProfile((r.UserProfile?.Id ?? 0), currentLanguageId)?.FullName,
CampaignId = r.CampaignId,
CampaignName=LanguageFallbackHelper.GetCampaigns(r.Campaign.Id,currentLanguageId).Name
}
).ToList();
if (campaignNo != null)
{
NewLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.New && r.CampaignId == campaignNo);
QualifiedLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Qualified && r.CampaignId == campaignNo);
WonLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Won && r.CampaignId == campaignNo);
LostLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Lost && r.CampaignId == campaignNo);
}
else
{
NewLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.New);
QualifiedLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Qualified);
WonLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Won);
LostLeads = LeadList_result.Count(r => r.Status == LeadStatusEnum.Lost);
}
ViewData["NewLeads"] = NewLeads;
ViewData["QualifiedLeads"] = QualifiedLeads;
ViewData["WonLeads"] = WonLeads;
ViewData["LostLeads"] = LostLeads;
var list = new List<SelectListItem>
{
new SelectListItem{ Text=App_GlobalResources.General.Home.Name, Value = "Name", Selected = true},
new SelectListItem{ Text=App_GlobalResources.General.Home.Email, Value = "Email" },
new SelectListItem{ Text=App_GlobalResources.General.Home.Mobile, Value = "Mobile"}
};
ViewData["SearchFieldsList"] = list;
var pageSize = int.Parse(SettingHelper.GetOrCreate(Constants.SystemSettings.ControlPanelPageSize, "20").Value);
return View(LeadList_result);
// return View(LeadList_result.OrderByDescending(r => r.Id).ToList().ToPagedList(1,pageSize));
}
