public bool Simpan(Penjualan penjualan)
{
bool result = false;
int rowAffected = 0;
SqlTransaction trans = null;
try
{
trans = _conn.BeginTransaction();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = _conn;
cmd.Transaction = trans;
cmd.CommandText = @"Insert Into PenjualanHeader Values (@Nomor, @Tanggal, @KodeCustomer, @Total)";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Nomor", penjualan.Nomor);
cmd.Parameters.AddWithValue("@Tanggal", penjualan.Tanggal);
cmd.Parameters.AddWithValue("@Total", penjualan.Total);
rowAffected += cmd.ExecuteNonQuery();
foreach (BonFaktur itemDetail in penjualan.DataDetail)
{
cmd.CommandText = @"Insert Into PenjualanDetail Values (@Nomor, @NoUrut, @KodeBarang, @Quantity, @Harga)";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Nomor", itemDetail.NoFaktur);
cmd.Parameters.AddWithValue("@KodeBarang", itemDetail.DataBarang.Kode);
cmd.Parameters.AddWithValue("@Qty", itemDetail.Qty);
cmd.Parameters.AddWithValue("@HargaSatuan", itemDetail.HargaSatuan);
cmd.Parameters.AddWithValue("@HargaTotal", itemDetail.HargaTotal);
rowAffected += cmd.ExecuteNonQuery();
}
}
trans.Commit();
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
}
throw ex;
}
finally
{
if (trans != null)
{
trans.Dispose();
}
}
return(result);
}
public bool InsertItem(Penjualan penjualan)
{
bool result = false;
try
{
listData.Add(penjualan);
result = true;
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
