Beispiel #1
0
        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();
        }