private void CompleteDO(int rowIndex)
{
DataTable dt_Item = (DataTable)dgvItemList.DataSource;
DataGridView dgv = dgvDOList;
string doCode = dgv.Rows[rowIndex].Cells[header_DONo].Value.ToString();
string customerShortName = dgv.Rows[rowIndex].Cells[header_Customer].Value.ToString();
string customerCode = dgv.Rows[rowIndex].Cells[header_CustomerCode].Value.ToString();
DataTable dt = NewCompleteTable();
DataRow dt_Row;
foreach (DataRow row in dt_Item.Rows)
{
string doTableCode = row[header_DOTblCode].ToString();
string itemCode = row[header_ItemCode].ToString();
string PcsQty = row[header_DeliveryPCS].ToString();
string BagQty = row[header_DeliveryBAG].ToString();
if (!string.IsNullOrEmpty(itemCode))
{
dt_Row = dt.NewRow();
dt_Row[header_DOTblCode] = doTableCode;
dt_Row[header_DONo] = doCode;
dt_Row[header_Customer] = customerShortName;
dt_Row[header_CustomerCode] = customerCode;
dt_Row[header_ItemCode] = itemCode;
dt_Row[header_DeliveryPCS] = PcsQty;
dt_Row[header_DeliveryBAG] = BagQty;
dt.Rows.Add(dt_Row);
}
}
frmDeliveryDate frm = new frmDeliveryDate(dt)
{
StartPosition = FormStartPosition.CenterScreen
};
frm.ShowDialog();//Item Edit
if (frmInOutEdit.TrfSuccess)
{
MessageBox.Show("transfer success");
LoadDOList();
}
}
private void EditDeliveryDate()
{
frmDeliveryDate frm = new frmDeliveryDate(text_SelectDeliveryDate)
{
StartPosition = FormStartPosition.CenterScreen
};
frm.ShowDialog();//Item Edit
if (frmDeliveryDate.selectedDate != DateTime.MaxValue)
{
//DateTime selectedDate = DateTime.Now;
DateTime selectedDate = frmDeliveryDate.selectedDate;
DataGridView dgv = dgvMainList;
DataTable dt = (DataTable)dgv.DataSource;
uSpp.Updated_Date = DateTime.Now;
uSpp.Updated_By = MainDashboard.USER_ID;
for (int i = 0; i < dt.Rows.Count; i++)
{
bool rowSelected = dgv.Rows[i].Selected;
if (rowSelected)
{
if (selectedDate == DateTimePicker.MinimumDateTime || selectedDate == null)
{
dgv.Rows[i].Cells[header_DeliveryDate].Value = "";
uSpp.Delivery_date = null;
}
else
{
dgv.Rows[i].Cells[header_DeliveryDate].Value = selectedDate.Date;
uSpp.Delivery_date = selectedDate.Date;
}
//update
int planningNo = int.TryParse(dt.Rows[i][header_PlanningNo].ToString(), out planningNo) ? planningNo : -1;
int poCode = int.TryParse(dt.Rows[i][header_POCode].ToString(), out poCode) ? poCode : -1;
uSpp.Planning_no = planningNo;
uSpp.PO_code = poCode;
if (!dalSPP.DeliveryTripDateUpdate(uSpp))
{
MessageBox.Show("Failed to update delivery data!");
break;
}
}
}
}
}
private void btnDelivered_Click(object sender, EventArgs e)
{
if (btnDelivered.Text == "CONFIRM")
{
//get data
DataTable dt = GetSelectedData();
//check if data exist
if (dt.Rows.Count > 0)
{
frmDeliveryDate frm = new frmDeliveryDate();
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog();
if (frmDeliveryDate.selectedDate != DateTimePicker.MinimumDateTime && frmDeliveryDate.selectedDate != DateTime.MaxValue)
{
foreach (DataRow row in dt.Rows)
{
row[header_DeliveredDate] = frmDeliveryDate.selectedDate.Date;
}
//process to In/Out
frmInOutEdit frm2 = new frmInOutEdit(dt, 0);
frm2.StartPosition = FormStartPosition.CenterScreen;
frm2.ShowDialog();
}
else
{
MessageBox.Show("Date invalid!");
}
}
}
else
{
btnDelivered.BackColor = Color.FromArgb(0, 184, 148);
btnDelivered.Text = "CONFIRM";
cbSelectAll.Visible = true;
cbSelectAll.Checked = true;
btnCancel.Visible = true;
btnAdd.Visible = false;
Loaded = false;
dgvItemList.ClearSelection();
dgvDeliveryList.DataSource = null;
ColumnSelectAction();
Loaded = true;
}
}
