private void Lpbarang_Click(object sender, RoutedEventArgs e) { var context = new Datas.Contexts.BarangContext(); HelperPrint.PrintPreviewWithFormAction("Print Preview", new ReportDataSource { Name = "DataSet1", Value = context.Source }, "MainApp.Reports.Layouts.LaporanBarang.rdlc", null); }
public TransaksiPembelianContext() { Source = new ObservableCollection <Pembelian>(); using (var db = new OcphDbContext()) { var datas = from pembelian in db.Pembelians.Select() join supplier in db.Suppliers.Select() on pembelian.SupplierId equals supplier.SupplierId join user in db.Users.Select() on pembelian.UserId equals user.UserId select new PembelianDto { PembelianId = pembelian.PembelianId, NomorFaktur = pembelian.NomorFaktur, Tanggal = pembelian.Tanggal, JatuhTempo = pembelian.JatuhTempo, Pembayaran = pembelian.Pembayaran, Pelunasan = pembelian.Pelunasan, SupplierId = pembelian.SupplierId, UserId = pembelian.UserId, Supplier = supplier, User = user }; foreach (var item in datas) { var model = Mapper.Map <Pembelian>(item); var details = (from detail in db.DetailPembelian.Where(x => x.PembelianId == item.PembelianId) join barang in db.Barangs.Select() on detail.BarangId equals barang.BarangId select new ItemPembelian { KodeBarang = barang.KodeBarang, DetailPembelianId = detail.DetailPembelianId, PembelianId = detail.PembelianId, HargaBeli = barang.HargaBeli, HargaJual = barang.HargaJual, Jumlah = detail.Jumlah, Merk = barang.Merk, Satuan = barang.Satuan, NamaBarang = barang.NamaBarang, BarangId = barang.BarangId }); model.Details = new ObservableCollection <ItemPembelian>(details); Source.Add(model); } } barangContext = new BarangContext(); supplierContext = new SupplierContext(); }