public void replyUlasan()
{
int selectedIndex = ViewComponent.datagridUlasan.SelectedIndex;
if (selectedIndex == -1)
{
return;
}
string reply = ViewComponent.textboxBalasUlasan.Text;
if (reply == "")
{
return;
}
UlasanModel model = new UlasanModel();
model.init();
model.addWhere("ID", ulasanModel.Table.Rows[selectedIndex][0].ToString());
foreach (DataRow row in model.get())
{
model.updateRow(row, "REPLY", reply);
model.updateRow(row, "ID_SELLER", seller["ID"]);
}
reset();
}
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;
}
}
}
private void fillDgvUlasan()
{
string statement = $"SELECT " +
$"U.ID as \"ID\", " +
$"h.KODE as \"KODE TRANSAKSI\", " +
$"c.NAMA as \"NAMA CUSTOMER\", " +
$"u.RATING as \"RATING\" " +
$"FROM ULASAN u, CUSTOMER c, D_TRANS_ITEM d, H_TRANS_ITEM h, ITEM i " +
$"WHERE u.ID_CUSTOMER = c.ID " +
$"and u.ID_D_TRANS_ITEM = d.ID " +
$"and d.ID_H_TRANS_ITEM = h.ID " +
$"and d.ID_ITEM = i.ID " +
$"and i.ID_SELLER = '{seller["ID"]}'";
ulasanModel = new UlasanModel();
ulasanModel.initAdapter(statement);
ViewComponent.datagridUlasan.ItemsSource = "";
ViewComponent.datagridUlasan.ItemsSource = ulasanModel.Table.DefaultView;
ViewComponent.datagridUlasan.Columns[0].Visibility = Visibility.Hidden;
}
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");
}
}
}
