private void btnFilterApply_Click(object sender, EventArgs e)
{
if (dateEditOnly)
{
selectedDate = dtpDate.Value;
if (dateClear)
{
selectedDate = DateTimePicker.MinimumDateTime;
}
}
else
{
frmInOutEdit frm = new frmInOutEdit(dt_Delivered, dtpDate.Value.Date);
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog();//Item Edit
if (frmInOutEdit.TrfSuccess)
{
transferred = true;
}
}
Close();
}
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;
}
}
private void btnAutoInOut_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Confirm to process In/Out action?", "Message",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
DataTable dt = NewDeliverTable();
//DataRow dt_row;
DataTable dt_deliver = (DataTable)dgvDeliver.DataSource;
foreach (DataRow row in dt_deliver.Rows)
{
string matCode = row[headerMatCode].ToString();
bool itemChecked = row[headerCheck] == DBNull.Value ? false : Convert.ToBoolean(row[headerCheck].ToString());
if (!string.IsNullOrEmpty(matCode) && itemChecked)
{
dt.ImportRow(row);
}
}
MatTrfDate = dtpTrfDate.Text;
frmInOutEdit frm = new frmInOutEdit(dt);
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog();//Item Edit
DataTable dt_MatPlan = dalMatPlan.Select();
if (frmInOutEdit.TrfSuccess)
{
foreach (DataRow row in dt.Rows)
{
string from = row[headerFrom].ToString();
float preparingQty = float.TryParse(row[headerQty].ToString(), out float i) ? Convert.ToSingle(row[headerQty].ToString()) : 0;
string to = row[headerTo].ToString();
string matCode = row[headerMatCode].ToString();
foreach (DataRow mat in dt_MatPlan.Rows)
{
bool active = Convert.ToBoolean(mat[dalMatPlan.Active]);
if (active)
{
float checkingQty = float.TryParse(mat[dalMatPlan.Prepare].ToString(), out float j) ? Convert.ToSingle(mat[dalMatPlan.Prepare].ToString()) : 0;
bool match = true;
if (matCode != mat[dalMatPlan.MatCode].ToString())
{
match = false;
}
else if (from != mat[dalMatPlan.MatFrom].ToString())
{
match = false;
}
else if (to != mat[dalMac.MacLocation].ToString())
{
match = false;
}
else if (preparingQty != checkingQty)
{
match = false;
}
if (match)
{
//get plan id
int PlanID = int.TryParse(mat[dalMatPlan.PlanID].ToString(), out int k) ? Convert.ToInt32(mat[dalMatPlan.PlanID]) : 0;
float Transferred = float.TryParse(mat[dalMatPlan.Transferred].ToString(), out float l) ? Convert.ToSingle(mat[dalMatPlan.Transferred].ToString()) : 0;
uMatPlan.mat_code = matCode;
uMatPlan.plan_id = PlanID;
uMatPlan.mat_transferred = preparingQty + Transferred;
uMatPlan.mat_preparing = 0;
uMatPlan.mat_from = "";
uMatPlan.updated_date = DateTime.Now;
uMatPlan.updated_by = MainDashboard.USER_ID;
if (!dalMatPlan.MatPrepareUpdate(uMatPlan))
{
MessageBox.Show("Failed to update material preparing data.");
}
}
}
}
}
itemChecking = false;
btnItemCheck.Text = "ITEM CHECK";
btnAutoInOut.Visible = false;
dgvDeliver.Columns[headerCheck].Visible = false;
cbCheckAll.Checked = false;
cbCheckAll.Visible = false;
dtpTrfDate.Visible = false;
LoadDeliverData();
}
}
}
