public override void ExecuteResult(ControllerContext context)
{
var Response = context.HttpContext.Response;
var list1 = ReportList().ToList();
if (!list1.Any())
{
Response.Write("no data found");
return;
}
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "filename=OrgLeaders.pdf");
doc = new Document(PageSize.LETTER, 36, 36, 36, 36);
var w = PdfWriter.GetInstance(doc, Response.OutputStream);
w.PageEvent = pageEvents;
doc.Open();
dc = w.DirectContent;
foreach (var o in list1)
{
var t = StartPageSet(o);
var color = BaseColor.BLACK;
foreach (var m in RollsheetModel.FetchOrgMembers(o.OrgId, null)
.Where(om => om.MemberTypeId != MemberTypeCode.Member))
{
if (color == BaseColor.WHITE)
{
color = new GrayColor(240);
}
else
{
color = BaseColor.WHITE;
}
AddRow(t,
m.PeopleId,
m.Name,
m.Email,
m.HomePhone,
m.CellPhone,
m.WorkPhone,
m.MemberType,
color);
}
doc.Add(t);
}
pageEvents.EndPageSet();
doc.Close();
}
public override void ExecuteResult(ControllerContext context)
{
var Response = context.HttpContext.Response;
var list1 = ReportList().ToList();
if (!list1.Any())
{
Response.Write("no data found");
return;
}
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "filename=foo.pdf");
doc = new Document(PageSize.LETTER, 36, 36, 36, 36);
var w = PdfWriter.GetInstance(doc, Response.OutputStream);
w.PageEvent = pageEvents;
doc.Open();
dc = w.DirectContent;
var haddata = false;
foreach (var o in list1)
{
var t = StartPageSet(o);
var color = BaseColor.BLACK;
foreach (var m in RollsheetModel.FetchOrgMembers(o.OrgId, null))
{
if (color == BaseColor.WHITE)
{
color = new GrayColor(240);
}
else
{
color = BaseColor.WHITE;
}
AddRow(t, m, color);
haddata = true;
}
doc.Add(t);
}
if (!haddata)
{
doc.Add(new Phrase("\nno data"));
}
pageEvents.EndPageSet();
doc.Close();
}
public override void ExecuteResult(ControllerContext context)
{
var Response = context.HttpContext.Response;
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=foo.pdf");
doc = new Document(PageSize.LETTER, 36, 36, 64, 64);
var w = PdfWriter.GetInstance(doc, Response.OutputStream);
w.PageEvent = pageEvents;
doc.Open();
dc = w.DirectContent;
if (qid != null)
{
var o = ReportList().First();
StartPageSet(o);
var q = DbUtil.Db.PeopleQuery(qid.Value);
var q2 = from p in q
let rr = p.GetRecReg()
join m in RollsheetModel.FetchOrgMembers(o.OrgId, null) on p.PeopleId equals m.PeopleId into j
from m in j.DefaultIfEmpty()
orderby p.Name2
select new
{
p.Name,
MembertypeCode = (m == null ? "V" : m.MemberTypeCode),
p.PeopleId,
rr.MedicalDescription
};
foreach (var i in q2)
{
AddRow(i.MembertypeCode, i.Name, i.MedicalDescription, i.PeopleId, font);
}
if (t.Rows.Count > 1)
{
doc.Add(t);
}
else
{
doc.Add(new Phrase("no data"));
}
}
else
{
foreach (var o in ReportList())
{
var q = from m in RollsheetModel.FetchOrgMembers(o.OrgId, null)
orderby m.Name2
select new
{
m.Name,
m.MemberType,
m.PeopleId,
m.MedicalDescription
};
if (!q.Any())
{
continue;
}
StartPageSet(o);
foreach (var i in q)
{
AddRow(i.MemberType, i.Name, i.MedicalDescription, i.PeopleId, font);
}
if (t.Rows.Count > 1)
{
doc.Add(t);
}
else
{
doc.Add(new Phrase("no data"));
}
}
}
if (!pagesetstarted)
{
w.PageEvent = null;
doc.Add(new Phrase("no data"));
}
pageEvents.EndPageSet();
doc.Close();
}
public override void ExecuteResult(ControllerContext context)
{
var Response = context.HttpContext.Response;
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "filename=RosterList.pdf");
doc = new Document(PageSize.LETTER, 36, 36, 36, 36);
var w = PdfWriter.GetInstance(doc, Response.OutputStream);
w.PageEvent = pageEvents;
doc.Open();
dc = w.DirectContent;
if (qid != null)
{
var color = BaseColor.BLACK;
var o = ReportList().First();
var t = StartPageSet(o);
var q = DbUtil.Db.PeopleQuery(qid.Value);
var q2 = from p in q
let rr = p.RecRegs.FirstOrDefault()
join m in RollsheetModel.FetchOrgMembers(o.OrgId, null) on p.PeopleId equals m.PeopleId into j
from m in j.DefaultIfEmpty()
orderby p.Name2
select new MemberInfo
{
ActiveOther = rr.ActiveInAnotherChurch ?? false,
ThisChurch = rr.Member ?? false,
Address = p.PrimaryAddress,
Address2 = p.PrimaryAddress2,
CityStateZip = p.CityStateZip5,
CellPhone = p.CellPhone,
HomePhone = p.HomePhone,
MemberStatus = p.MemberStatus.Description,
MemberType = m.MemberType,
FamMemberThis = p.Family.People.Any(f => f.PositionInFamilyId == 10 && f.MemberStatusId == MemberStatusCode.Member),
Name = p.Name,
Medical = rr.MedicalDescription,
PeopleId = p.PeopleId,
Parents = DbUtil.Db.ParentNamesAndCells(p.PeopleId),
Age = p.Age
};
foreach (var m in q2)
{
if (color.Equals(BaseColor.WHITE))
{
color = new GrayColor(240);
}
else
{
color = BaseColor.WHITE;
}
AddRow(t, m, color);
}
if (t.Rows.Count > 1)
{
doc.Add(t);
}
else
{
doc.Add(new Phrase("no data"));
}
}
else
{
foreach (var o in ReportList())
{
var t = StartPageSet(o);
var color = BaseColor.BLACK;
var q = from om in DbUtil.Db.OrganizationMembers
where om.OrganizationId == o.OrgId
where (om.Pending ?? false) == false
where om.MemberTypeId != MemberTypeCode.InActive
let rr = om.Person.RecRegs.FirstOrDefault()
orderby om.Person.Name2
select new MemberInfo
{
ActiveOther = rr.ActiveInAnotherChurch ?? false,
ThisChurch = rr.Member ?? false,
Address = om.Person.PrimaryAddress,
Address2 = om.Person.PrimaryAddress2,
CityStateZip = om.Person.CityStateZip5,
CellPhone = om.Person.CellPhone,
HomePhone = om.Person.HomePhone,
MemberStatus = om.Person.MemberStatus.Description,
MemberType = om.MemberType.Description,
FamMemberThis = om.Person.Family.People.Any(f => f.PositionInFamilyId == 10 && f.MemberStatusId == MemberStatusCode.Member),
Name = om.Person.Name,
Medical = rr.MedicalDescription,
PeopleId = om.PeopleId,
Parents = DbUtil.Db.ParentNamesAndCells(om.PeopleId),
Age = om.Person.Age
};
foreach (var m in q)
{
if (color == BaseColor.WHITE)
{
color = new GrayColor(240);
}
else
{
color = BaseColor.WHITE;
}
AddRow(t, m, color);
}
doc.Add(t);
}
}
pageEvents.EndPageSet();
doc.Close();
}