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);
}
