private void btn_search_Click(object sender, EventArgs e)
{
try
{
Database.ERPSOFT.t_ExportFGoods t_ExportFGoods = new Database.ERPSOFT.t_ExportFGoods();
dtExportSummary = t_ExportFGoods.GetDataTableExportSummary(dtpk_from.Value, dtpk_to.Value, (bool)rd_exportDate.Checked);
dtgv_ExportSummary.DataSource = dtExportSummary;
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Can't get data import summary", ex.Message);
}
}
private void txt_packingNo_TextChanged(object sender, EventArgs e)
{
if (txt_packingNo.Text.Length == 13)
{
dtgv_BOMCustoms.Columns.Clear();
dtgv_BOMCustoms.Controls.Clear();
Database.ERPSOFT.t_ExportFGoods t_ExportFGoods = new Database.ERPSOFT.t_ExportFGoods();
dtExport = t_ExportFGoods.GetDataTableExportFinishedGoods(txt_packingNo.Text);
if (dtExport.Rows.Count > 0)
{
lb_client.Text = "Client : " + dtExport.Rows[0]["Client"].ToString().Trim();
lb_Invoice.Text = "Invoice: " + dtExport.Rows[0]["Invoice"].ToString().Trim();
txt_buyerSelect.Text = dtExport.Rows[0]["TL202"].ToString().Trim();
txt_ShipmentType.Text = dtExport.Rows[0]["TL203"].ToString().Trim();
lb_dateExportWarehouse.Text = "Warehouse Export Date : " + dtExport.Rows[0]["dateExport"].ToString().Trim();
}
var ListProduct = (from r in dtExport.AsEnumerable()
select r["Product"]).Distinct().ToList();
listSummary = new List <SummaryDelivery>();
for (int i = 0; i < ListProduct.Count; i++)
{
SummaryDelivery summary = new SummaryDelivery();
summary.Product = (string)ListProduct[i];
decimal TotalQty = 0;
TotalQty = dtExport.AsEnumerable().Where(d => d.Field <string>("Product") == summary.Product)
.Sum(d => d.Field <decimal>("Quantity"));
summary.TotalQuantity = TotalQty;
summary.PriceUnit = dtExport.AsEnumerable().Where(d => d.Field <string>("Product") == summary.Product)
.Select(d => d.Field <decimal>("PriceUnit")).ToList()[0];
summary.price = summary.TotalQuantity * summary.PriceUnit;
summary.Unit = dtExport.AsEnumerable().Where(d => d.Field <string>("Product") == summary.Product)
.Select(d => d.Field <string>("Unit")).ToList()[0];
summary.Currency = dtExport.AsEnumerable().Where(d => d.Field <string>("Product") == summary.Product)
.Select(d => d.Field <string>("Currency")).ToList()[0];
listSummary.Add(summary);
}
dtgv_deliveryInfo.DataSource = listSummary;
dtgv_BOMCustoms.DataSource = listSummary;
DataGridViewButtonColumn dataGridViewButton = new DataGridViewButtonColumn();
dataGridViewButton.HeaderText = "BOM Customs Declar";
dataGridViewButton.Name = "BOM";
dataGridViewButton.Width = 100;
dtgv_BOMCustoms.Columns.Add(dataGridViewButton);
}
}
public bool UploadERPFinishedGoods(DataTable dtExport, out string DeliveryNo)
{
DeliveryNo = "";
var isStockAvaiable = IsCheckStockAvaiable(dtExport);
if (isStockAvaiable == false)
{
return(false);
}
ConvertdatatableForExport convertdatatableForExport = new ConvertdatatableForExport();
DataTable dtCOPTH = convertdatatableForExport.ConverttoDtCOPTH(dtExport);
DataTable dtCOPTG = convertdatatableForExport.ConvertdtCOPTG(dtCOPTH, dtExport);
if (dtCOPTH.Rows.Count == 0)
{
MessageBox.Show("Convert to COPTH fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
if (dtCOPTG.Rows.Count == 0)
{
MessageBox.Show("Convert to COPTG fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.COPTH cOPTH = new Database.COPTH();
var insertCOPTH = cOPTH.InsertData(dtCOPTH);
if (insertCOPTH == false)
{
MessageBox.Show("Insert COPTH fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.COPTG cOPTG = new Database.COPTG();
var insertCOPTG = cOPTG.InsertData(dtCOPTG);
if (insertCOPTG == false)
{
MessageBox.Show("Insert COPTG fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
UpdateWarehouseForExportFGs updateWarehouseForExportFGs = new UpdateWarehouseForExportFGs();
var update = updateWarehouseForExportFGs.UpdateWarehouse(dtCOPTH, dtExport);
if (update == false)
{
MessageBox.Show("Update warehouse stock fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
Database.COP.COPTD cOPTD = new Database.COP.COPTD();
var updateCOPTD = cOPTD.UpdateCOPTDDelivery(dtCOPTH);
if (updateCOPTD == false)
{
MessageBox.Show("Update COPTD fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
DeliveryNo = dtCOPTG.Rows[0]["TG001"].ToString().Trim() + "-" + dtCOPTG.Rows[0]["TG002"].ToString().Trim();
Database.ERPSOFT.t_ExportFGoods t_ExportFGoods = new Database.ERPSOFT.t_ExportFGoods();
var UpdateERPExport = t_ExportFGoods.UpdateExportWarehouse(dtExport, DeliveryNo);
if (UpdateERPExport == false)
{
MessageBox.Show("Update Out Stock QR fail ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
return(true);
}
