//Category Referral Feature Finsih----------------------------------------------------- //New Functionality: All Referrals for a given time period----------------------------- public AllReferralsByDateVM AllReferralsByDateFileSearch(AllReferralsByDateVM input) { var fromDate2 = input.fDate2.AddDays(-1); var toDate2 = input.tDate2.AddDays(1); using (var db = new MainDb()) { var query = db.referrals .Include(i => i.companyCategoryType) .Include(p => p.company) .Include(q => q.client) .Include(w => w.client.contactInfo) .Where(e => (e.referralDate > fromDate2) && (e.referralDate < toDate2)).ToList(); input.allReferrals = query.ToList <object>(); if (input.allReferrals.Count() != 0) { var items = new List <object> { new { PERIOD = fromDate2.ToShortDateString() + " thru " + toDate2.ToShortDateString() } }; items.Add(new { Client = "Count of Referrals: " + (input.allReferrals.Count()) }); items.Add( new { h1 = "Category Name", h2 = "Company Name", h3 = "Client Name", h4 = "Referral Date", h5 = "Quote", h6 = "Commission", h7 = "Service description" }); var item2 = query.Select(i => new { Category = (i.companyCategoryType.name != null ? i.companyCategoryType.name : "N/A"), CompanyName = (i.company.name != null ? i.company.name : "N/A"), ClientName = ((i.client.contactInfo != null) && (i.client.contactInfo.name != null) ? i.client.contactInfo.name : "N/A"), ReferralDate = (i.created != null ? i.created.ToShortDateString() : "N/A"), Quote = (i.quote != null ? i.quote : 0), Commission = (i.commissionAmount != null ? i.commissionAmount : 0), Servicedescription = (i.description != null ? i.description : "N/A") }).ToList <object>(); foreach (var i in item2) { items.Add(i); } input.allReferrals = items; } return(input); } }
public FileResult AllReferralsByDateFile(AllReferralsByDateVM input) { if (ModelState.IsValid) { input = reportManager.AllReferralsByDateFileSearch(input); var file = ImportExportHelper.exportToCsv(input.allReferrals, true); // alert, if the only object is the info about Date period if (input.allReferrals.Count() != 0) { return(File(file.FullName, "Application/octet-stream", file.Name)); } else { this.Response.Write("<script> alert('No Data found based on the criteria!'); window.history.back(); </script>"); } } else { this.Response.Write("<script> alert('Plese input valid dates!'); window.history.back(); </script>"); } return(null); }
// Category Referral By Date Feature Finish ------------------------------------ // All Referrals For a Given Date Feature ------------------------------------ public ActionResult AllReferralsByDate(AllReferralsByDateVM allReferralsByDateModel) { return(PartialView("_AllReferralsByDate", allReferralsByDateModel)); }