public IEnumerable <PledgeGift> FetchPledgeData(ExcelWorksheet ws)
{
FetchHeaderColumns(ws);
const string sheet = "Pledges";
CheckColumn("IndividualId", sheet);
CheckColumn("PledgeAmount", sheet);
CheckColumn("PledgeDate", sheet);
CheckColumn("FundId", sheet);
CheckColumn("FundName", sheet);
CheckColumn("FundDescription", sheet);
var r = 2;
while (r <= ws.Dimension.End.Row)
{
var row = new PledgeGift
{
IndividualId = ws.Cells[r, Names["IndividualId"]].Value,
Amount = GetDecimal(ws.Cells[r, Names["PledgeAmount"]].Value),
Date = GetDate(ws.Cells[r, Names["PledgeDate"]].Value) ?? DateTime.MinValue,
FundId = GetInt(ws.Cells[r, Names["FundId"]].Value) ?? 0,
FundName = GetString(ws.Cells[r, Names["FundName"]].Value),
FundDescription = GetString(ws.Cells[r, Names["FundDescription"]].Value)
};
r++;
yield return(row);
}
}
public IEnumerable <PledgeGift> FetchContributionData(ExcelWorksheet ws)
{
FetchHeaderColumns(ws);
const string sheet = "Gift Data";
CheckColumn("IndividualId", sheet);
CheckColumn("Amount", sheet);
CheckColumn("Date", sheet);
CheckColumn("FundId", sheet);
CheckColumn("FundName", sheet);
CheckColumn("FundDescription", sheet);
var r = 2;
while (r <= ws.Dimension.End.Row)
{
var row = new PledgeGift()
{
IndividualId = ws.Cells[r, Names["IndividualId"]].Value,
Amount = GetDecimal(ws.Cells[r, Names["Amount"]].Value),
Date = GetDate(ws.Cells[r, Names["Date"]].Value) ?? DateTime.MinValue,
FundId = GetInt(ws.Cells[r, Names["FundId"]].Value) ?? 0,
FundDescription = GetString(ws.Cells[r, Names["FundDescription"]].Value),
FundName = GetString(ws.Cells[r, Names["FundName"]].Value),
};
if (Names.ContainsKey("CheckNo"))
{
row.CheckNo = GetString(ws.Cells[r, Names["CheckNo"]].Value);
}
r++;
yield return(row);
}
}