public void SaveAsExcel()
{
var api = new APIContributionSearchModel(DbUtil.Db)
{
model =
{
StartDate = Dt1,
EndDate = Dt2,
IncludeUnclosedBundles = IncUnclosedBundles,
TaxNonTax = TaxDedNonTax,
CampusId = CampusId,
Status = ContributionStatusCode.Recorded,
Online = Online,
FilterByActiveTag = FilterByActiveTag,
}
};
var x = api.FetchContributions();
var list = x.Select(xx => new ContributionIdItem {
ContributionId = xx.ContributionId
}).ToList();
var dt = ExcelExportModel.ToDataTable(list);
dt.SaveAs("D:\\cids.xlsx");
}
public static EpplusResult InvolvementList(Guid queryid)
{
//var db = Db;
var nocheckrole = DbUtil.Db.Setting("AllowLimitToRoleForInvolvementExport", "false").ToBool();
var q = DbUtil.Db.PeopleQuery(queryid);
var q2 = from p in q
orderby p.LastName, p.FirstName
let spouse = DbUtil.Db.People.SingleOrDefault(w => p.SpouseId == w.PeopleId)
let om = p.OrganizationMembers.SingleOrDefault(m => m.OrganizationId == p.BibleFellowshipClassId)
select new InvolvementInfo
{
PeopleId = p.PeopleId,
Addr = p.PrimaryAddress,
Addr2 = p.PrimaryAddress2,
City = p.PrimaryCity,
State = p.PrimaryState,
Zip = p.PrimaryZip,
FamilyId = p.FamilyId,
Name = p.Name,
HomePhone = p.HomePhone,
WorkPhone = p.WorkPhone,
CellPhone = p.CellPhone,
Email = p.EmailAddress,
DivName = om.Organization.Division.Name,
OrgName = om.Organization.OrganizationName,
Teacher = p.BFClass.LeaderName,
MemberType = om.MemberType.Description,
AttendPct = om.AttendPct,
AgeDb = p.Age,
Spouse = spouse != null ? spouse.FirstName : "",
activities = (from m in p.OrganizationMembers
where nocheckrole || (m.Organization.LimitToRole ?? "") == ""
select new ActivityInfo
{
Name = m.Organization.OrganizationName,
Pct = m.AttendPct,
Leader = m.Organization.LeaderName
}).ToList(),
JoinInfo = p.JoinType.Description + " , " + p.JoinDate.ToString().Substring(0, 11),
Notes = "",
OfficeUseOnly = "",
LastName = p.LastName,
FirstName = p.PreferredName,
Campus = p.Campu.Description,
CampusDate = DbUtil.Db.LastChanged(p.PeopleId, "CampusId").FormatDate()
};
var list = q2.ToList();
return(ExcelExportModel.ToDataTable(list).ToExcel("Involvements.xlsx"));
}
