public static PenjualanDetail FindOneByIdBarangAndIdPenjualan(int id_barang, int id_penjualan)
{
Database.OpenConnection();
string select = String.Concat("SELECT * FROM ", nama_tabel, " WHERE id_barang = @id_barang " +
"AND id_penjualan = @id_penjualan");
Sql.MySqlDataAdapter da = new Sql.MySqlDataAdapter();
da.SelectCommand = new Sql.MySqlCommand(select, Database.conn);
da.SelectCommand.Parameters.AddWithValue("@id_barang", id_barang);
da.SelectCommand.Parameters.AddWithValue("@id_penjualan", id_penjualan);
Sql.MySqlCommandBuilder cb = new Sql.MySqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds);
Database.CloseConnection();
PenjualanDetail penjualanDetail = new PenjualanDetail();
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
penjualanDetail.setId(Convert.ToInt32(dr["id"]));
penjualanDetail.setBarang(Barang.FindOneById(Convert.ToInt32(dr["id_barang"])));
penjualanDetail.setPenjualan(Penjualan.FindOneById(Convert.ToInt32(dr["id_penjualan"])));
penjualanDetail.setKuantitas(Convert.ToInt32(dr["kuantitas"]));
penjualanDetail.setHargaBarang(Convert.ToDecimal(dr["harga_barang"]));
penjualanDetail.setCreatedAt(Convert.ToDateTime(dr["created_at"]));
penjualanDetail.setUpdatedAt(Convert.ToDateTime(dr["updated_at"]));
return(penjualanDetail);
}
return(null);
}
public PenjualanDetail setBarang(Barang barang)
{
this.barang = barang;
return(this);
}
public PembelianDetail setBarang(Barang barang)
{
this.barang = barang;
return(this);
}
