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(); } } }