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)); }