public FileResult AllReferralsForaClientFile(AllReferralsForaClientVM input)
{
if (ModelState.IsValid)
{
input = reportManager.AllReferralsForaClientFileSearch(input);
var file = ImportExportHelper.exportToCsv(input.allReferralsForaClient, true);
// alert, if the only object is the info about Date period
if (input.allReferralsForaClient.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);
}
//All Referrals For a Given Date Feature Finish---------------------------------------------------------
//All Referrals for a client for a given time period ---------------------------------------------------
public ActionResult AllReferralsForaClient(AllReferralsForaClientVM AllReferralsForaClientDateModel)
{
return(PartialView("_AllReferralsForaClient", AllReferralsForaClientDateModel));
}
public AllReferralsForaClientVM AllReferralsForaClientFileSearch(AllReferralsForaClientVM input)
{
var fromDate3 = input.fDate3.AddDays(-1);
var toDate3 = input.tDate3.AddDays(1);
var organizationName = ReportManager.getOrgNameForClient(input.clientId1);
var clientContactInfo = ReportManager.getClientContactInfo(input.clientId1);
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.clientId == input.clientId1) &&
(e.referralDate > fromDate3) &&
(e.referralDate < toDate3)).ToList();
input.allReferralsForaClient = query.ToList <object>();
if (input.allReferralsForaClient.Count() != 0)
{
var items = new List <object> {
new { PERIOD = fromDate3.ToShortDateString() + " thru " + toDate3.ToShortDateString() }
};
items.Add(new { Client = "Count of Referrals: " + (input.allReferralsForaClient.Count()) });
items.Add(new { Client = "Client's Organization Name: " + (organizationName != null ? organizationName.ToString() : "N/A") });
items.Add(new { Client = "Client's Name: " + ((clientContactInfo != null) && (clientContactInfo.name != null) ? clientContactInfo.name : "N/A") });
items.Add(new { Client = "Client's Email: " + ((clientContactInfo != null) && (clientContactInfo.email != null) ? clientContactInfo.email : "N/A") });
items.Add(new { Client = "Client's Phone Number: " + ((clientContactInfo != null) && (clientContactInfo.workPhone != null) ? clientContactInfo.workPhone : "N/A") });
items.Add(
new
{
h1 = "Category Name",
h2 = "Company Name",
h3 = "Referral Date",
h4 = "Quote",
h5 = "Commission",
h6 = "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"),
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.allReferralsForaClient = items;
}
return(input);
}
}
