private void Product_OptionPanel_ButtonClick(object sender, DevExpress.XtraBars.Docking2010.ButtonEventArgs e)
{
switch (e.Button.Properties.Caption)
{
case "New":
MessageBox.Show("Fitur Belum Tersedia");
break;
case "Export":
Dialog.ShowSaveFileDialog("Export Database", "Excel 97-2003 Workbook|*.xls", delegate(bool ok, string path)
{
if (ok)
{
string query = "SELECT tbl_designs.contract as CONTRACT, tbl_designs.design_id as KODE_DESAIN, tbl_designs.design_name as DESAIN, tbl_designs.product_code KELOMPOK_PRODUK, tbl_families.family_code as KELOMPOK_DESAIN FROM `tbl_designs` inner join tbl_products on tbl_products.product_code=tbl_designs.product_code inner join tbl_families on tbl_families.family_code=tbl_designs.family_code";
db.DoGetDataAsync(query, delegate(DataSet dt)
{
XlsData data = new XlsData(dt);
data.ToFile(path);
});
}
});
break;
case "Import":
Dialog.ShowOpenFileDialog("Import Database", "Excel 97-2003 Workbook|*.xls", delegate(bool ok, string path)
{
if (ok)
{
XlsData data = new XlsData(path);
DataSet dataSet = data.ToDataSet();
//Rows[Baris][Kolom]
/*
* Worker.StartWorker(delegate {
* //Store to colors table
* try
* {
* for (int bar = 0; bar < dataSet.Tables[0].Rows.Count; bar++)
* {
*
* if (!db.DoCommand("update tbl_colors SET colors_id = '" + dataSet.Tables[0].Rows[bar][6].ToString() + "', accounting_group = '" + dataSet.Tables[0].Rows[bar][1].ToString() + "', colors_name = '" + dataSet.Tables[0].Rows[bar][7].ToString() + "', design_id = '" + dataSet.Tables[0].Rows[bar][4].ToString().Split('-')[1] + "', grade = '" + dataSet.Tables[0].Rows[bar][8].ToString() + "', price = 0, url_color_img = '-' " +
* "where colors_id='" + dataSet.Tables[0].Rows[bar][6].ToString() + "'"))
* {
* db.DoCommand("insert into tbl_colors (colors_id, accounting_group, colors_name, design_id, grade, price, url_color_img) values ('" + dataSet.Tables[0].Rows[bar][6].ToString() + "','" + dataSet.Tables[0].Rows[bar][1].ToString() + "','" + dataSet.Tables[0].Rows[bar][7].ToString() + "','" + dataSet.Tables[0].Rows[bar][4].ToString().Split('-')[1] + "','" + dataSet.Tables[0].Rows[bar][8].ToString() + "',0,'-')");
* }
*
* }
* }
* catch (Exception ex)
* {
* Console.WriteLine("STORE COLORS EXCEPTION: " + ex.ToString());
* }
* }, refresh_product);
* Worker.StartWorker(delegate {
* try
* {
* for (int bar = 0; bar < dataSet.Tables[0].Rows.Count; bar++)
* {
*
* if (!db.DoCommand("update tbl_designs SET design_id = '" + dataSet.Tables[0].Rows[bar][4].ToString().Split('-')[1] + "', design_name = '" + dataSet.Tables[0].Rows[bar][5].ToString() + "', product_code = '" + dataSet.Tables[0].Rows[bar][2].ToString() + "', categories_id = '" + "OFS" + "', contract = '" + dataSet.Tables[0].Rows[bar][0].ToString() + "', family_code = '" + dataSet.Tables[0].Rows[bar][3].ToString() + "', url_design_img = '-' " +
* "where design_id='" + dataSet.Tables[0].Rows[bar][4].ToString().Split('-')[1] + "'"))
* {
* db.DoCommand("insert into tbl_designs (design_id, design_name, product_code, categories_id, contract, family_code, url_design_img) values ('" + dataSet.Tables[0].Rows[bar][4].ToString().Split('-')[1] + "','" + dataSet.Tables[0].Rows[bar][5].ToString() + "','" + dataSet.Tables[0].Rows[bar][2].ToString() + "','" + "OFS" + "','" + dataSet.Tables[0].Rows[bar][0].ToString() + "','" + dataSet.Tables[0].Rows[bar][3].ToString() + "','-')");
*
* }
* }
* }
* catch (Exception ex)
* {
* Console.WriteLine("STORE DESIGNS EXCEPTION: " + ex.ToString());
* }
*
* }, refresh_product);
* //refresh_product();
*/
}
});
break;
}
}
/// <summary>
/// Event yangd dipanggil ketika <see cref="CircleButton"/> terclick di Area <see cref="Product_NavFrame"/>
/// </summary>
/// <param name="obj"></param>
/// <param name="e"></param>
private void Event_OnProductNavButtonClicked(object obj, EventArgs e)
{
var btn = (CircleButton)obj;
switch (btn.tag)
{
case "FilterFilter":
Form_ProductFilter form_filter = new Form_ProductFilter();
form_filter.ShowDialog();
string query_filter = " AND";
if (form_filter.filterContract != "")
{
query_filter += " contract='" + form_filter.filterContract + "' AND";
}
if (form_filter.filterProduct != "")
{
query_filter += " product_code_desc='" + form_filter.filterProduct + "' AND";
}
if (form_filter.filterDesign != "")
{
query_filter += " description='" + form_filter.filterDesign + "' AND";
}
if (form_filter.filterFamily != "")
{
query_filter += " fam_product_desc='" + form_filter.filterFamily + "' AND";
}
query_filter = query_filter.Substring(0, query_filter.Length - 3);
if (form_filter.status_filter)
{
FormUtility.LoadDatabaseToGrid(queryProduct + query_filter, Product_Grid, null);
}
break;
case "FilterCancel":
FormUtility.LoadDatabaseToGrid(queryProduct, Product_Grid, null);
break;
case "PrevPage":
break;
case "NextPage":
break;
case "Import":
Dialog.ShowOpenFileDialog("Import Database", "Excel 97-2003 Workbook|*.xls", delegate(bool ok, string path)
{
if (ok)
{
XlsData data = new XlsData(path);
DataSet ds = data.ToDataSet();
bool status_import = false;
Random rand = new Random(9999);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string query_import = "insert into tbl_barangs (contract, design_id, part_no, description, accounting_group, acc_gr_desc, product_code, product_code_desc, fam_product, fam_product_desc, prime_com, prime_com_desc, second_com, second_com_desc, unit, grade, color_code, color_desc, url_design_img, url_color_img, price_inc, price_exc) values('" + ds.Tables[0].Rows[i][0].ToString() + "','" + "des" + rand.Next(9999).ToString() + "','" + ds.Tables[0].Rows[i][1].ToString() + "','" + ds.Tables[0].Rows[i][2].ToString() + "','" + ds.Tables[0].Rows[i][3].ToString() + "','" + ds.Tables[0].Rows[i][4].ToString() + "','" + ds.Tables[0].Rows[i][5].ToString() + "','" + ds.Tables[0].Rows[i][6].ToString() + "','" + ds.Tables[0].Rows[i][7].ToString() + "','" + ds.Tables[0].Rows[i][8].ToString() + "','" + ds.Tables[0].Rows[i][9].ToString() + "','" + ds.Tables[0].Rows[i][10].ToString() + "','" + ds.Tables[0].Rows[i][11].ToString() + "','" + ds.Tables[0].Rows[i][12].ToString() + "','" + ds.Tables[0].Rows[i][13].ToString() + "','" + ds.Tables[0].Rows[i][1].ToString().Split('-')[ds.Tables[0].Rows[i][1].ToString().Split('-').Length - 1] + "','" + ds.Tables[0].Rows[i][14].ToString() + "','" + ds.Tables[0].Rows[i][15].ToString() + "','" + "-" + "','" + "-" + "','" + ds.Tables[0].Rows[i][16].ToString() + "','" + ds.Tables[0].Rows[i][17].ToString() + "')";
DataSet ds_check = DBSql.DoGetData("select count(*) from tbl_barangs where part_no='" + ds.Tables[0].Rows[i][1].ToString() + "' and contract='" + ds.Tables[0].Rows[i][0].ToString() + "'");
if (int.Parse(ds_check.Tables[0].Rows[0][0].ToString()) == 0)
{
DataSet ds_check_part2 = DBSql.DoGetData("select design_id from tbl_barangs where description='" + ds.Tables[0].Rows[i][2].ToString() + "' and contract='" + ds.Tables[0].Rows[i][0].ToString() + "' limit 1");
if (ds_check_part2.Tables[0].Rows.Count > 0)
{
query_import = "insert into tbl_barangs (contract, design_id, part_no, description, accounting_group, acc_gr_desc, product_code, product_code_desc, fam_product, fam_product_desc, prime_com, prime_com_desc, second_com, second_com_desc, unit, grade, color_code, color_desc, url_design_img, url_color_img, price_inc, price_exc) values('" + ds.Tables[0].Rows[i][0].ToString() + "','" + ds_check_part2.Tables[0].Rows[0][0].ToString() + "','" + ds.Tables[0].Rows[i][1].ToString() + "','" + ds.Tables[0].Rows[i][2].ToString() + "','" + ds.Tables[0].Rows[i][3].ToString() + "','" + ds.Tables[0].Rows[i][4].ToString() + "','" + ds.Tables[0].Rows[i][5].ToString() + "','" + ds.Tables[0].Rows[i][6].ToString() + "','" + ds.Tables[0].Rows[i][7].ToString() + "','" + ds.Tables[0].Rows[i][8].ToString() + "','" + ds.Tables[0].Rows[i][9].ToString() + "','" + ds.Tables[0].Rows[i][10].ToString() + "','" + ds.Tables[0].Rows[i][11].ToString() + "','" + ds.Tables[0].Rows[i][12].ToString() + "','" + ds.Tables[0].Rows[i][13].ToString() + "','" + ds.Tables[0].Rows[i][1].ToString().Split('-')[ds.Tables[0].Rows[i][1].ToString().Split('-').Length - 1] + "','" + ds.Tables[0].Rows[i][14].ToString() + "','" + ds.Tables[0].Rows[i][15].ToString() + "','" + "-" + "','" + "-" + "','" + ds.Tables[0].Rows[i][16].ToString() + "','" + ds.Tables[0].Rows[i][17].ToString() + "')";
DBSql.DoCommand(query_import);
}
else
{
DBSql.DoCommand(query_import);
}
status_import = true;
}
}
Toast.ShowToast("Data Barang " + (status_import ? "Berhasil" : "Tidak") + " Diimport", "Import Data Barang", ToastIndicator.Ok);
}
});
break;
case "Export":
Dialog.ShowSaveFileDialog("Export Database", "Excel 97-2003 Workbook|*.xls", delegate(bool ok, string path)
{
if (ok)
{
DataSet ds = DBSql.DoGetData("select contract as CONTRACT, part_no as PART_NO, description as DESCRIPTION, accounting_group as ACCOUNTING_GROUP, acc_gr_desc as ACC_GROUP_DESC, product_code as PRODUCT_CODE, product_code_desc as PRODUCT_CODE_DESC, fam_product as FAM_PRODUCT_CODE, fam_product_desc as FAM_PRODUCT_DESC, prime_com as PRIME_COMMODITY, prime_com_desc as PRIME_COM_DESC, second_com as SECOND_COMMODIY, second_com_desc as SECOND_COM_DESC, unit as UNIT_MEAS, grade as GRADE, color_code as COLOR_CODE, color_desc as COLOR_DESC, price_inc as PRICE_INC, price_exc as PRICE_EXC FROM tbl_barangs where grade='A'");
XlsData data = new XlsData(ds);
data.ToFile(path);
Toast.ShowToast("Data Barang Berhasil Diexport", "Export Data Barang", ToastIndicator.Ok);
}
});
break;
}
}
