private void btnLooseItems_Click(object sender, EventArgs e) { double n; bool isNumeric = Double.TryParse(txtDoorIDSearch.Text, out n); if (isNumeric == true) { frmLooseItems frmLI = new frmLooseItems(Convert.ToDouble(txtDoorIDSearch.Text)); frmLI.Show(); } else { MessageBox.Show("Please enter a numerical value before searching", "Data type incorrect", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnComplete_Click(object sender, EventArgs e) { UpdateDepartments ud = new UpdateDepartments(_doorID, _dept); double n; bool isNumeric = Double.TryParse(txtPercentage.Text, out n); if (cmbStaffID.SelectedIndex > -1) { if (isNumeric == true) { if (n <= 100) { if (ud._SectionCompleteAmount < (n / 100)) { //try //{ double percentageToInsert = (n / 100) - ud._SectionCompleteAmount; double valueTimeToInsert = percentageToInsert * ud._SectionTime; double valueToUpdateDoor = percentageToInsert * ud._SectionTimeSingular; SqlConnection conn = new SqlConnection(SqlStatements.ConnectionString); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "INSERT INTO dbo.door_part_completion_log(door_id, part_complete_date,time_for_part,part,part_status,staff_id,op,part_percent_complete)" + "values (@doorID,@completeDate,@timeForPart,@part,'Complete',@staffID,@op,@partPercentComplete)"; cmd.Parameters.AddWithValue("@doorID", _doorID); cmd.Parameters.AddWithValue("@completeDate", DateTime.Now); cmd.Parameters.AddWithValue("@timeForPart", valueTimeToInsert); cmd.Parameters.AddWithValue("@part", "Part " + _dept); cmd.Parameters.AddWithValue("@staffID", cmbStaffID.SelectedValue); cmd.Parameters.AddWithValue("@op", _dept); cmd.Parameters.AddWithValue("@partPercentComplete", percentageToInsert); cmd.ExecuteNonQuery(); conn.Close(); ud.updateDoor(valueToUpdateDoor, n); ud.calibrate(); MessageBox.Show("Section successfully Updated", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); if (n == 100 && _dept == "SL_Pack") { frmLooseItems frmLI = new frmLooseItems(_doorID); frmLI.ShowDialog(); } this.Close(); //} //catch //{ //MessageBox.Show("Ann error has occured. Please contact IT.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); //} } else { MessageBox.Show("The value you have entered is less or equal to the current progress on the job (" + ud._SectionCompleteAmount * 100 + "%)", "Value lower than current progress", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Value must be less than or equal to 100!", "Value too high!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Only whole number percentages 1-100 can be used. No decimals allowed!", "Whole numbers", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Please select a staff member before attempting to continue", "Select staff member", MessageBoxButtons.OK, MessageBoxIcon.Error); } }