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