public ActionResult Excel(Guid id, string format, bool?titles, bool?useMailFlags)
{
var ctl = new MailingController {
UseTitles = titles ?? false, UseMailFlags = useMailFlags ?? false
};
switch (format)
{
case "Individual":
case "GroupAddress":
return(ExportPeople.FetchExcelList(id, maxExcelRows, useMailFlags ?? false).ToExcel());
case "Library":
return(ExportPeople.FetchExcelLibraryList(id));
case "AllFamily":
return(ExportPeople.FetchExcelListFamily(id));
case "Family":
return(ctl.FetchExcelFamily(id, maxExcelRows));
case "ParentsOf":
return(ctl.FetchExcelParents(id, maxExcelRows));
case "CouplesEither":
return(ctl.FetchExcelCouplesEither(id, maxExcelRows));
case "CouplesBoth":
return(ctl.FetchExcelCouplesBoth(id, maxExcelRows));
case "Involvement":
return(new ExcelResult(ExportInvolvements.InvolvementList(id), "Involvements.xls"));
case "Children":
return(ExportInvolvements.ChildrenList(id, maxExcelRows));
case "Church":
return(ExportInvolvements.ChurchList(id, maxExcelRows));
case "Attend":
return(ExportInvolvements.AttendList(id, maxExcelRows));
case "Promotion":
return(ExportInvolvements.PromoList(id, maxExcelRows));
case "IndividualPicture":
return(ExcelExportModel.Result(id));
case "FamilyMembers":
return(ExportPeople.FetchExcelListFamilyMembers(id));
case "OrgMembers":
return(OrgsMembersExcelModel.Export(Util2.CurrentOrgId ?? 0));
case "Groups":
return(ExportInvolvements.OrgMemberListGroups());
}
return(Content("no format"));
}
public void InvolvementList_Should_Have_FamilyId()
{
var requestManager = FakeRequestManager.Create();
var db = requestManager.CurrentDatabase;
var controller = new CmsWeb.Areas.OnlineReg.Controllers.OnlineRegController(requestManager);
var routeDataValues = new Dictionary <string, string> {
{ "controller", "OnlineReg" }
};
controller.ControllerContext = ControllerTestUtils.FakeControllerContext(controller, routeDataValues);
var m = OrganizationModel.Create(db, requestManager.CurrentUser);
var FakeOrg = FakeOrganizationUtils.MakeFakeOrganization(requestManager);
var model = FakeOrganizationUtils.GetFakeOnlineRegModel(FakeOrg.org.OrganizationId);
m.OrgId = FakeOrg.org.OrganizationId;
var resultSubmitQuestions = controller.SubmitQuestions(0, model);
var resultCompleteRegistration = controller.CompleteRegistration(model);
var TestInvolvementList = ExportInvolvements.InvolvementList(m.QueryId);
var pkg = typeof(EpplusResult).GetField("pkg", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(TestInvolvementList);
using (ExcelPackage package = (ExcelPackage)pkg)
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
object[,] cellValues = (object[, ])worksheet.Cells.Value;
List <string> ReportColumns = cellValues.Cast <object>().ToList().ConvertAll(x => Convert.ToString(x));
var FamilyId = worksheet.Cells[1, 2].Value.ToString().Trim();
ReportColumns.ShouldContain("FamilyId");
FamilyId.ShouldBe("FamilyId");
}
FakeOrganizationUtils.DeleteOrg(FakeOrg.org.OrganizationId);
}
protected void Page_Load(object sender, EventArgs e)
{
var labelNameFormat = Request.QueryString["format"];
int?qid = Request.QueryString["id"].ToInt2();
var r = Response;
r.Clear();
var useweb = Request.QueryString["web"];
string header =
@"<html xmlns:x=""urn:schemas-microsoft-com:office:excel"">
<head>
<meta http-equiv=Content-Type content=""text/html; charset=utf-8"">
<style>
<!--table
br {mso-data-placement:same-cell;}
tr {vertical-align:top;}
td.Text {mso-number-format:\@}
-->
</style>
</head>
<body>";
r.Charset = "";
if (!qid.HasValue && labelNameFormat != "Groups")
{
r.Write("no queryid");
r.Flush();
r.End();
}
if (useweb != "true")
{
r.ContentType = "application/vnd.ms-excel";
r.AddHeader("Content-Disposition", "attachment;filename=CMSPeople.xls");
}
r.Write(header);
var ctl = new MailingController();
var useTitles = Request.QueryString["titles"];
ctl.UseTitles = useTitles == "true";
var dg = new DataGrid();
dg.EnableViewState = false;
switch (labelNameFormat)
{
case "Individual":
dg.DataSource = ExportPeople.FetchExcelList(qid.Value, maxExcelRows);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "IndividualPicture":
GridView1.EnableViewState = false;
GridView1.AllowPaging = false;
GridView1.DataSource = ExportPeople.FetchExcelListPics(qid.Value, maxExcelRows);
GridView1.DataBind();
GridView1.RenderControl(new HtmlTextWriter(r.Output));
break;
case "Library":
dg.DataSource = ExportPeople.FetchExcelLibraryList(qid.Value);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "Family":
dg.DataSource = ctl.FetchExcelFamily(qid.Value, maxExcelRows);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "FamilyMembers":
FamilyMembers.EnableViewState = false;
FamilyMembers.AllowPaging = false;
FamilyMembers.DataSource = ExportPeople.FetchExcelListFamilyMembers(qid.Value);
FamilyMembers.DataBind();
FamilyMembers.RenderControl(new HtmlTextWriter(r.Output));
break;
case "AllFamily":
dg.DataSource = ExportPeople.FetchExcelListFamily(qid.Value);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "ParentsOf":
dg.DataSource = ctl.FetchExcelParents(qid.Value, maxExcelRows);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "CouplesEither":
dg.DataSource = ctl.FetchExcelCouplesEither(qid.Value, maxExcelRows);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "CouplesBoth":
dg.DataSource = ctl.FetchExcelCouplesBoth(qid.Value, maxExcelRows);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "Involvement":
dg.DataSource = ExportInvolvements.InvolvementList(qid.Value);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "Children":
dg.DataSource = ExportInvolvements.ChildrenList(qid.Value, maxExcelRows);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "Church":
dg.DataSource = ExportInvolvements.ChurchList(qid.Value, maxExcelRows);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "Attend":
dg.DataSource = ExportInvolvements.AttendList(qid.Value, maxExcelRows);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "Organization":
dg.DataSource = ExportInvolvements.OrgMemberList(qid.Value);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "Groups":
dg.DataSource = ExportInvolvements.OrgMemberListGroups();
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
case "Promotion":
dg.DataSource = ExportInvolvements.PromoList(qid.Value, maxExcelRows);
dg.DataBind();
dg.RenderControl(new HtmlTextWriter(r.Output));
break;
}
r.Write("</body></HTML>");
r.Flush();
r.End();
}
