public DataRow getDetailToko(int pos)
{
try
{
selected = pos;
// 0 = id transos
// 1 = status R / D / A
// 2 = id seller
DataRow dr = Htomhelper.Table.Rows[pos];
Dtom = new Trans_OSModel();
Dtom.initAdapter($"select s.NAMA_TOKO as \"toko\", s.EMAIL as \"email\", s.ALAMAT as \"alamat\", s.NO_TELP as \"notelp\", s.NAMA_SELLER as \"nama\", s.CREATED_AT as \"createdat\" from SELLER s where s.ID = {dr[2].ToString()}");
return(Dtom.Table.Rows[0]);
}
catch (Exception ex)
{
return(null);
}
}
void reloadHtom()
{
Htom.initAdapter("select s.NAMA_TOKO as \"Nama Toko\", s.NAMA_SELLER as \"Pemilik\", case h.STATUS when 'R' then 'Request' when 'D' then 'Declined' when 'A' then 'Accepted' end as \"Status\", h.TANGGAL_TRANSAKSI as \"Tanggal Request\" from SELLER s, TRANS_OS h where h.ID_SELLER = s.ID order by h.TANGGAL_TRANSAKSI desc, h.STATUS desc");
Htomhelper.initAdapter("select h.ID, h.STATUS, h.ID_SELLER from SELLER s, TRANS_OS h where h.ID_SELLER = s.ID order by h.TANGGAL_TRANSAKSI desc, h.STATUS desc");
}