private void Event_OnOrderGridViewRowCellStyle(object sender, RowCellStyleEventArgs e)
{
var status = Order_GridView.GetRowCellValue(e.RowHandle, Order_GridView.Columns[9]).ToString();
var noted = Order_GridView.GetRowCellValue(e.RowHandle, Order_GridView.Columns[10]).ToString();
Color selectedColor = default(Color);
switch (status)
{
case "Success":
//selectedColor = Color.Green;
break;
case "Waiting":
selectedColor = Color.PaleGoldenrod;
break;
case "Canceled":
selectedColor = Color.PaleVioletRed;
break;
case "Declined":
selectedColor = Color.FromArgb(255, 150, 150);
break;
}
if (status == "Waiting")
{
if (noted != ".")
{
selectedColor = Color.LimeGreen;
}
}
if (!selectedColor.IsEmpty)
{
RGBAPix pix = selectedColor.ToRGBA();
HSLAPix hsl = pix;
if (Order_GridView.IsRowSelected(e.RowHandle))
{
hsl.l -= 0.10f;
}
else
{
if (e.RowHandle % 2 != 0)
{
hsl.l -= 0.05f;
}
}
pix = hsl;
e.Appearance.BackColor = (pix).ToWinColor();
}
}
private void Event_OnOrderGridDoubleClicked(GridHitInfo info)
{
//Example
/*
* for (int i = 0; i < Order_GridView.Columns.Count; i++) {
* var value = Order_GridView.GetRowCellValue(info.RowHandle, Order_GridView.Columns[i]);
* }
*/
Form_OrderAction order_action = new Form_OrderAction();
order_action.Text = "" + Order_GridView.GetRowCellValue(info.RowHandle, "ORDER_NO");
Console.WriteLine(order_action.Text);
ShowForm(order_action);
FormUtility.LoadDatabaseToGrid(queryOrder, Order_Grid, null);
}
/// <summary>
/// Event yang dipanggil ketika Berpindah "Scene"
/// </summary>
/// <param name="i"></param>
private void Event_OnNavSelectedPageChanged(int i)
{
//Stop All Worker
Worker.DisposeAllWorker();
//UnLoad All Grid
Order_Grid.DataSource = null;
Order_GridView.PopulateColumns();
Product_Grid.DataSource = null;
Product_GridView.PopulateColumns();
switch (i)
{
case 0: //Dashboard Page
DataTable dt = null;
//Load Statistic
dt = DBSql.DoGetData("select count(*) from tbl_customers").Tables[0];
Dashboard_PanelInfo1_Num.Text = dt.Rows[0][0].ToString();
dt = DBSql.DoGetData("select count(*) from checkouts").Tables[0];
Dashboard_PanelInfo2_Num.Text = dt.Rows[0][0].ToString();
dt = DBSql.DoGetData("select count(*) from checkouts where checkout_status not like 'Success'").Tables[0];
Dashboard_PanelInfo3_Num.Text = dt.Rows[0][0].ToString();
dt = DBSql.DoGetData("select count(*) from checkouts where checkout_status='Success'").Tables[0];
Dashboard_PanelInfo4_Num.Text = dt.Rows[0][0].ToString();
break;
case 1: //Order Page
OrderGridUpdate();
break;
case 2: //Product Page
ProductGridUpdate();
break;
case 3: //Customer Page
if (App.userInfo.userType != UserType.SuperAdmin)
{
_context.Show_Overlay(this);
MessageBox.Show("Akses ditolak, Hanya Super Admin yang Diperbolehkan", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Stop);
_context.Hide_Overlay();
Header_Button_Dashboard.Checked = true;
return;
}
CustomerUpdateGrid();
break;
case 4: //Sales Page
if (App.userInfo.userType != UserType.SuperAdmin)
{
_context.Show_Overlay(this);
MessageBox.Show("Akses ditolak, Hanya Super Admin yang Diperbolehkan", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Stop);
_context.Hide_Overlay();
Header_Button_Dashboard.Checked = true;
return;
}
SalesUpdateGrid();
break;
}
}
/// <summary>
/// Event yang dipanggil ketika <see cref="CircleButton"/> terclick di Area <see cref="Order_NavFrmae"/>
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Event_OnOrderNavButtonClicked(object sender, EventArgs e)
{
var btn = (CircleButton)sender;
switch (btn.tag)
{
case "Approve":
for (int i = 0; i < Order_GridView.GetSelectedRows().Length; i++)
{
string order_no = Order_GridView.GetRowCellValue(Order_GridView.GetSelectedRows()[i], "ORDER_NO").ToString();
DBSql.DoCommand("update checkouts set checkout_status='Success' where checkout_status='Waiting' and order_no='" + order_no + "'");
}
FormUtility.LoadDatabaseToGrid(queryOrder, Order_Grid, null);
Toast.ShowToast(Order_GridView.GetSelectedRows().Length + " Order Approved", "Order", ToastIndicator.Ok);
break;
case "Decline":
for (int i = 0; i < Order_GridView.GetSelectedRows().Length; i++)
{
string order_no = Order_GridView.GetRowCellValue(Order_GridView.GetSelectedRows()[i], "ORDER_NO").ToString();
DBSql.DoCommand("update checkouts set checkout_status='Declined' where checkout_status='Waiting' and order_no='" + order_no + "'");
}
FormUtility.LoadDatabaseToGrid(queryOrder, Order_Grid, null);
Toast.ShowToast(Order_GridView.GetSelectedRows().Length + " Order Declined", "Order", ToastIndicator.Ok);
break;
case "Cancel":
for (int i = 0; i < Order_GridView.GetSelectedRows().Length; i++)
{
string order_no = Order_GridView.GetRowCellValue(Order_GridView.GetSelectedRows()[i], "ORDER_NO").ToString();
DBSql.DoCommand("update checkouts set checkout_status='Canceled' where checkout_status='Waiting' and order_no='" + order_no + "'");
}
FormUtility.LoadDatabaseToGrid(queryOrder, Order_Grid, null);
Toast.ShowToast(Order_GridView.GetSelectedRows().Length + " Order Canceled", "Order", ToastIndicator.Ok);
break;
case "Print":
break;
case "Export":
Dialog.ShowSaveFileDialog("Export Database", "Excel 97-2003 Workbook|*.xls", delegate(bool ok, string path) {
if (ok)
{
DataSet ds = DBSql.DoGetData("select checkouts.order_no as ORDER_NO, checkouts.order_date as TANGGAL, tbl_customers.segment as BIDANG_USAHA, checkouts.customer_name as CUSTOMER, tbl_customers.region_name as WILAYAH, tbl_orders.product_name as PRODUCT_DESC, tbl_orders.family_name as FAMILY_DESC, tbl_orders.part_no as PART_NO, tbl_orders.design_name as DESAIN, tbl_orders.colors_name as WARNA, checkouts.currency as KURS, tbl_orders.price_unit as HARGA_SATUAN, tbl_orders.qty as QTY, tbl_orders.total_price as HARGA_TOTAL, tbl_users.fullname as SALESMAN, checkouts.notes as NOTE, checkouts.checkout_status as STATUS from checkouts inner join tbl_orders on tbl_orders.order_no=checkouts.order_no inner join tbl_customers on tbl_customers.customer_id=checkouts.customer_id inner join tbl_users on tbl_users.user_id=checkouts.sales_id");
if (ds != null)
{
XlsData data = new XlsData(ds);
data.ToFile(path);
}
Toast.ShowToast("Data Berhasil Diexport", "Export Data Order", ToastIndicator.Ok);
}
});
break;
case "Filter_Filter":
//m_orderFilterToggle.state = !m_orderFilterToggle.state;
Form_FilterOrder order_filter = new Form_FilterOrder();
order_filter.ShowDialog();
string query_filter = " where";
if (order_filter.filterRegion != "")
{
query_filter += " region='" + order_filter.filterRegion + "' AND";
}
if (order_filter.filterBidUsaha != "")
{
query_filter += " segment='" + order_filter.filterBidUsaha + "' AND";
}
if (order_filter.filterSalesman != "")
{
query_filter += " tbl_users.fullname='" + order_filter.filterSalesman + "' AND";
}
query_filter = query_filter.Substring(0, query_filter.Length - 3);
if (order_filter.status_filter_order)
{
FormUtility.LoadDatabaseToGrid(queryOrder + query_filter, Order_Grid, null);
}
break;
case "Filter_Cancel":
FormUtility.LoadDatabaseToGrid(queryOrder, Order_Grid, null);
break;
case "NextPage":
break;
case "PrevPage":
break;
case "Negosiasi":
//This is event
Form_Nego form_nego = new Form_Nego();
ShowForm(form_nego);
break;
}
}
