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