public static Penjualan FindOneByKode(string kode)
{
Database.OpenConnection();
string select = String.Concat("SELECT * FROM ", nama_tabel, " WHERE kode = @kode");
Sql.MySqlDataAdapter da = new Sql.MySqlDataAdapter();
da.SelectCommand = new Sql.MySqlCommand(select, Database.conn);
da.SelectCommand.Parameters.AddWithValue("@kode", kode);
Sql.MySqlCommandBuilder cb = new Sql.MySqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds);
Database.CloseConnection();
Penjualan penjualan = new Penjualan();
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
penjualan.setId(Convert.ToInt32(dr["id"]));
penjualan.setKode(dr["kode"].ToString());
penjualan.setCustomer(Customer.FindOneById(Convert.ToInt16(dr["id_customer"])));
penjualan.setCreatedAt(Convert.ToDateTime(dr["created_at"]));
penjualan.setUpdatedAt(Convert.ToDateTime(dr["updated_at"]));
return(penjualan);
}
return(null);
}
public static PenjualanDetail FindOneById(int id)
{
Database.OpenConnection();
string select = String.Concat("SELECT * FROM ", nama_tabel, " WHERE id = @id");
Sql.MySqlDataAdapter da = new Sql.MySqlDataAdapter();
da.SelectCommand = new Sql.MySqlCommand(select, Database.conn);
da.SelectCommand.Parameters.AddWithValue("@id", id);
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 setPenjualan(Penjualan penjualan)
{
this.penjualan = penjualan;
return(this);
}