private void GetCustomOrdersButton_Click(object sender, EventArgs e) { //refactor this once API is up TicketRepository repo = new TicketRepository(); List<TicketResource> tickets = repo.GetActiveTicketsBetweenDates(CustomOrderDatePickerStart.Value, CustomOrderDatePickerEnd.Value); List<TicketResource> orders = new List<TicketResource>(); foreach (TicketResource ticket in tickets) { if (ticket.OrderId.Trim() != "") { orders.Add(ticket); } } if (orders.Count > 0) { orders = orders.OrderBy(x => x.DateReady).ToList(); 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; for (int i = 0; i < orders.Count; i++) { TicketResource order = orders[i]; int row = i + 1; worksheet.Cells[row, "A"] = order.TicketId; worksheet.Cells[row, "B"] = order.FirstName; worksheet.Cells[row, "C"] = order.LastName; worksheet.Cells[row, "D"] = order.DateReady.ToString(); worksheet.Cells[row, "E"] = order.Telephone; worksheet.Cells[row, "F"] = "$" + order.TotalPrice; } worksheet.Columns["A:F"].AutoFit(); } else { MessageBox.Show("There are no orders due between those dates."); } }
private void GetTicketsForDateButton_Click(object sender, EventArgs e) { TicketRepository repo = new TicketRepository(); List<TicketResource> tickets = repo.GetActiveTicketsBetweenDates(TicketsForDatePicker.Value, TicketsForDatePicker.Value); if (tickets.Count > 0) { 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; for (int i = 0; i < tickets.Count; i++) { TicketResource ticket = tickets[i]; int row = i + 1; worksheet.Cells[row, "A"] = ticket.TicketId; worksheet.Cells[row, "B"] = ticket.FirstName; worksheet.Cells[row, "C"] = ticket.LastName; worksheet.Cells[row, "D"] = ticket.TailorName; worksheet.Cells[row, "E"] = ticket.Telephone; worksheet.Cells[row, "F"] = "$" + ticket.TotalPrice; } worksheet.Columns["A:F"].AutoFit(); } else { MessageBox.Show("There are no tickets due on that date."); } }