public static void loadItem()
{
int idx = idxItem;
if (idx >= 0)
{
Detail_Trans_Item dti = list_dtrans[idx];
ViewComponent.tbKurirItem.Text = dti.namaKurir;
ViewComponent.tbNamaItem.Text = dti.namaItem;
ViewComponent.tbJumlahItem.Text = dti.jumlah;
ViewComponent.tbStatusItem.Text = dti.status;
if (dti.status == "WAITING FOR CONFIRMATION")
{
ViewComponent.tbSudahUlas.Visibility = Visibility.Hidden;
ViewComponent.btnTerimaBarang.Visibility = Visibility.Hidden;
ViewComponent.btnBeriUlasan.Visibility = Visibility.Hidden;
ViewComponent.ratingUlasan.Visibility = Visibility.Hidden;
ViewComponent.rtbUlasan.Visibility = Visibility.Hidden;
}
else if (dti.status == "SHIPPING")
{
ViewComponent.tbSudahUlas.Visibility = Visibility.Hidden;
ViewComponent.btnTerimaBarang.Visibility = Visibility.Visible;
ViewComponent.btnBeriUlasan.Visibility = Visibility.Hidden;
ViewComponent.ratingUlasan.Visibility = Visibility.Hidden;
ViewComponent.rtbUlasan.Visibility = Visibility.Hidden;
}
else if (dti.status == "FINISHED")
{
UlasanModel um = new UlasanModel();
if (um.Table.Select($"ID_D_TRANS_ITEM = '{dti.id}' AND ID_CUSTOMER = '{Session.User["ID"]}'").Length > 0)
{
//Kalau sudah diulas
ViewComponent.tbSudahUlas.Visibility = Visibility.Visible;
ViewComponent.btnTerimaBarang.Visibility = Visibility.Hidden;
ViewComponent.btnBeriUlasan.Visibility = Visibility.Hidden;
ViewComponent.ratingUlasan.Visibility = Visibility.Hidden;
ViewComponent.rtbUlasan.Visibility = Visibility.Hidden;
}
else
{
ViewComponent.tbSudahUlas.Visibility = Visibility.Hidden;
ViewComponent.btnTerimaBarang.Visibility = Visibility.Hidden;
ViewComponent.btnBeriUlasan.Visibility = Visibility.Visible;
ViewComponent.ratingUlasan.Visibility = Visibility.Visible;
ViewComponent.rtbUlasan.Visibility = Visibility.Visible;
}
}
else if (dti.status == "CANCELED")
{
ViewComponent.tbSudahUlas.Visibility = Visibility.Hidden;
ViewComponent.btnTerimaBarang.Visibility = Visibility.Hidden;
ViewComponent.btnBeriUlasan.Visibility = Visibility.Hidden;
ViewComponent.ratingUlasan.Visibility = Visibility.Hidden;
ViewComponent.rtbUlasan.Visibility = Visibility.Hidden;
}
}
}
public static void terimaBarang()
{
if (idxItem >= 0)
{
int idx = idxItem;
Detail_Trans_Item dti = list_dtrans[idx];
//Check kalau DTRANS HARUS SUDAH SELESAI
if (dti.status == "SHIPPING")
{
D_Trans_ItemModel dtim = new D_Trans_ItemModel();
DataRow row = dtim.Table.Select($"ID = '{dti.id}'").FirstOrDefault();
row["STATUS"] = "D";
dtim.update();
//Check if status D_Trans sudah D semua ato blm
// Kalau D semua nanti penjual dpt duit
bool valid = true;
foreach (DataRow item in dtim.Table.Select($"ID_H_TRANS_ITEM = '{row["ID_H_TRANS_ITEM"]}'"))
{
if (item["STATUS"].ToString() != "D")
{
valid = false;
}
}
if (valid)
{
foreach (DataRow rowDTI in dtim.Table.Select($"ID_H_TRANS_ITEM = '{row["ID_H_TRANS_ITEM"]}'"))
{
ItemModel im = new ItemModel();
DataRow item = im.Table.Select($"ID = '{rowDTI["ID_ITEM"]}'").FirstOrDefault();
SellerModel sm = new SellerModel();
DataRow seller = sm.Table.Select($"ID = '{item["ID_SELLER"]}'").FirstOrDefault();;
int saldo = Convert.ToInt32(row["JUMLAH"]) * Convert.ToInt32(item["HARGA"]);
saldo += Convert.ToInt32(seller["SALDO"]);
seller["SALDO"] = saldo;
sm.update();
}
}
loadD_Trans();
loadItem();
}
else
{
// Selain Shipping
MessageBox.Show("ERROR");
}
}
}
public static void beriUlasan()
{
int idx = idxItem;
if (idx >= 0)
{
Detail_Trans_Item dti = list_dtrans[idx];
//Check kalau DTRANS HARUS SUDAH SELESAI
if (dti.status == "FINISHED")
{
UlasanModel um = new UlasanModel();
if (um.Table.Select($"ID_D_TRANS_ITEM = '{dti.id}' AND ID_CUSTOMER = '{Session.User["ID"]}'").Length > 0)
{
MessageBox.Show("Barang sudah di ulas!");
}
else
{
new DB("ULASAN").insert(
"ID", 0,
"ID_CUSTOMER", Session.User["ID"].ToString(),
"MESSAGE", Utility.StringFromRichTextBox(ViewComponent.rtbUlasan),
"RATING", ViewComponent.ratingUlasan.Value,
"ID_D_TRANS_ITEM", dti.id
).execute();
Utility.setRichTextBoxString(ViewComponent.rtbUlasan, "");
//reset input ulasan
resetItem();
MessageBox.Show("Berhasil Memberi Ulasan!");
loadD_Trans();
loadItem();
}
}
else
{
// Selain selesai
MessageBox.Show("ERROR");
}
}
}
public static void loadD_Trans()
{
if (idxH_Trans >= 0)
{
int idx = idxH_Trans;
//Init Labels
H_Trans_ItemModel hti = new H_Trans_ItemModel();
DataRow row = hti.Table.Select($"ID ='{list_htrans[idx].ID}'").FirstOrDefault();
if (row["STATUS"].ToString() == "P")
{
ViewComponent.btnCetakInvoice.Visibility = Visibility.Visible;
}
else
{
ViewComponent.btnCetakInvoice.Visibility = Visibility.Hidden;
}
ViewComponent.tbKodeTrans.Text = row["KODE"].ToString();
string idPromo = row["ID_PROMO"].ToString() == "" ? "none" : row["ID_PROMO"].ToString();
if (idPromo != "none")
{
DataRow promo = new DB("PROMO").select().where ("ID", idPromo).getFirst();
ViewComponent.tbKodePromo.Text = promo["KODE"].ToString();
ViewComponent.tbDiskon.Text = Utility.formatNumber(Convert.ToInt32(row["DISKON"]));
}
else
{
ViewComponent.tbKodePromo.Text = "-";
ViewComponent.tbDiskon.Text = Utility.formatNumber(0);
}
ViewComponent.tbStatusTrans.Text = list_htrans[idx].STATUS;
ViewComponent.tbSubtotal.Text = Utility.formatNumber(Convert.ToInt32(row["SUBTOTAL"]));
ViewComponent.tbOngkosKirim.Text = Utility.formatNumber(Convert.ToInt32(row["ONGKOS_KIRIM"]));
ViewComponent.tbGrandtotal.Text = Utility.formatMoney(Convert.ToInt32(row["GRANDTOTAL"]));
// Init Table D Trans
list_dtrans = new List <Detail_Trans_Item>();
D_Trans_ItemModel dti = new D_Trans_ItemModel();
foreach (DataRow rowDTI in dti.Table.Select($"ID_H_TRANS_ITEM = '{row["ID"]}'"))
{
string namaItem = "", namaKurir = "";
namaItem = new DB("ITEM")
.select()
.where ("ID", rowDTI["ID_ITEM"].ToString())
.getFirst()
["NAMA"].ToString();
namaKurir = new DB("KURIR")
.select()
.where ("ID", rowDTI["ID_KURIR"].ToString())
.getFirst()
["NAMA"].ToString();
Detail_Trans_Item dt = new Detail_Trans_Item(
id: rowDTI["ID"].ToString(),
namaItem: namaItem,
jumlah: rowDTI["JUMLAH"].ToString(),
namaKurir: namaKurir,
status: rowDTI["STATUS"].ToString()
);
list_dtrans.Add(dt);
}
ViewComponent.grid_D_Trans.ItemsSource = null;
ViewComponent.grid_D_Trans.ItemsSource = list_dtrans;
ViewComponent.grid_D_Trans.Columns[0].Header = "ID";
ViewComponent.grid_D_Trans.Columns[1].Header = "Nama Item";
ViewComponent.grid_D_Trans.Columns[2].Header = "Jumlah";
ViewComponent.grid_D_Trans.Columns[3].Header = "Kurir";
ViewComponent.grid_D_Trans.Columns[4].Header = "Status";
ViewComponent.grid_D_Trans.Columns[0].Visibility = Visibility.Hidden;
}
}
