private void getMailingAddressesButton_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
excelApp.Visible = true;
_Workbook workbook = (_Workbook)(excelApp.Workbooks.Add(Type.Missing));
_Worksheet worksheet = (_Worksheet)workbook.ActiveSheet;
TicketRepository ticketRepo = new TicketRepository();
List<TicketResource> listOfTickets = ticketRepo.GetDistinctMailingAddressBetweenDates(StartingDatePicker.Value, EndingDatePicker.Value);
//change the getDistintMailing to not accept "" as a unique address. then we can remove this row checking
int row = 1;
for (int i = 0; i < listOfTickets.Count; i++)
{
TicketResource ticket = listOfTickets[i];
if (ticket.Address == "")
{
continue;
}
worksheet.Cells[row, "A"] = ticket.LastName;
worksheet.Cells[row, "B"] = ticket.FirstName;
worksheet.Cells[row, "C"] = ticket.Address;
worksheet.Cells[row, "D"] = ticket.City;
worksheet.Cells[row, "E"] = ticket.State;
worksheet.Cells[row, "F"] = ticket.Zip;
row++;
}
worksheet.Columns["A:F"].AutoFit();
}
