static void Main(string[] args)
{
// buat objek item beli (3 objek)
var item1 = new ItemBeli
{
BarangID = "BB-7421",
Jumlah = 5,
HargaBeli = 54,
HargaJual = 60
};
var item2 = new ItemBeli
{
BarangID = "BB-8107",
Jumlah = 7,
HargaBeli = 101,
HargaJual = 110
};
var item3 = new ItemBeli
{
BarangID = "BK-M18B-44",
Jumlah = 10,
HargaBeli = 540,
HargaJual = 693
};
// buat objek beli
var beli = new Beli
{
Nota = "N001",
SupplierID = 3,
Tanggal = DateTime.Today,
Keterangan = "Transaksi beli menggunakan Entity Framework"
};
// tambahkan item beli ke objek beli
beli.ItemBelis.Add(item1);
beli.ItemBelis.Add(item2);
beli.ItemBelis.Add(item3);
var result = AddPembelianUsingEF(beli);
Console.WriteLine("\nStatus transaksi : {0}", result == 1 ? "Sukses" : "Gagal");
Console.ReadKey();
}
private static IList<ItemBeli> GetDetailPembelian(string nota, SqlConnection conn)
{
var daftarItemBeli = new List<ItemBeli>();
var sql = @"SELECT Barang.BarangID, Barang.NamaBarang, ItemBeli.Jumlah, ItemBeli.HargaBeli, ItemBeli.HargaJual
FROM Barang INNER JOIN ItemBeli ON Barang.BarangID = ItemBeli.BarangID
WHERE ItemBeli.Nota = @1";
using (var cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@1", nota);
using (var dtr = cmd.ExecuteReader())
{
while (dtr.Read())
{
// mapping record ke objek barang
var barang = new Barang
{
BarangID = dtr["BarangID"] is DBNull ? string.Empty : (string)dtr["BarangID"],
NamaBarang = dtr["NamaBarang"] is DBNull ? string.Empty : (string)dtr["NamaBarang"]
};
// mapping record ke objek item beli
var itemBeli = new ItemBeli
{
Barang = barang, // hubungkan barang dg item beli
Jumlah = dtr["Jumlah"] is DBNull ? 0 : (int)dtr["Jumlah"],
HargaBeli = dtr["HargaBeli"] is DBNull ? 0 : (int)dtr["HargaBeli"],
HargaJual = dtr["HargaJual"] is DBNull ? 0 : (int)dtr["HargaJual"]
};
daftarItemBeli.Add(itemBeli);
}
}
}
return daftarItemBeli;
}