public ActionResult ShowPrint(int id) { Context.Dokumen dbitem = RepoDokumen.FindByPK(id); DokumenIndex model = new DokumenIndex(dbitem); ViewBag.TanggalPulang = dbitem.SalesOrder.SalesOrderOncall.TanggalMuat.Value.AddDays(RepoSalesOrder.FindRute(dbitem.SalesOrder.SalesOrderOncall.IdDaftarHargaItem.Value).WaktuKerja); return(View("Print", model)); }
public FileContentResult Export() { //bikin file baru ExcelPackage pck = new ExcelPackage(); //sumber data List <Context.Dokumen> dbitems = RepoDokumen.FindAll().Where(d => d.IsComplete != true).ToList(); //bikin worksheet worksheet ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Sheet 1"); //bikin header cell[baris,kolom] , nama kolom sesuaikan dengan template ws.Cells[1, 1].Value = "Status"; ws.Cells[1, 2].Value = "SO No"; ws.Cells[1, 3].Value = "Vehicle No"; ws.Cells[1, 4].Value = "Customer"; ws.Cells[1, 5].Value = "Rute"; ws.Cells[1, 6].Value = "Nama Driver"; ws.Cells[1, 7].Value = "Tanggal Muat"; ws.Cells[1, 8].Value = "Delay"; ws.Cells[1, 9].Value = "Lengkap?"; ws.Cells[1, 10].Value = "Last Update"; // Inserts Data int idx = 0; for (int i = 0; i < dbitems.Count(); i++) { DokumenIndex item = new DokumenIndex(dbitems[i]); ws.Cells[i + 2, 1].Value = item.Status; ws.Cells[i + 2, 2].Value = item.NoSo; ws.Cells[i + 2, 3].Value = item.VehicleNo; ws.Cells[i + 2, 4].Value = item.Customer; ws.Cells[i + 2, 5].Value = item.Rute; ws.Cells[i + 2, 6].Value = item.NamaDriver; ws.Cells[i + 2, 7].Value = item.TanggalMuat.ToString(); ws.Cells[i + 2, 8].Value = item.Delay; ws.Cells[i + 2, 9].Value = item.Lengkap; ws.Cells[i + 2, 10].Value = item.LastUpdate.ToString(); } var fsr = new FileContentResult(pck.GetAsByteArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); fsr.FileDownloadName = "Surat Jalan.xls"; return(fsr); }