private void btnRemove_Click(object sender, EventArgs e) { if (cmdOp.SelectedIndex > -1) { Operations op = new Operations(); SqlStatements sqlUpdate = new SqlStatements(); //NEEDS TO CHECK CELL VALUE Boolean checkGrid = GridCheck(cmdOp.Text); if (checkGrid == true) { MessageBox.Show("This operation has not been completed so cannot be removed.", "Cannot Remove", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { int finishType = Int32.Parse(this.txtFinishID.Text); string short_op = ""; //DELETE FROM COMPLETION LOG sqlUpdate.DeletePartCompletion(Int32.Parse(txtSearch.Text), cmdOp.Text.ToString()); //ADD BACK TO DOOR switch (cmdOp.SelectedItem) { case "Up": short_op = "up"; break; case "Wash/Wipe": short_op = "ww"; break; case "Etch": short_op = "etch"; break; case "Sand": short_op = "sand"; break; case "Powder Prime": short_op = "pp"; break; case "Powder Coat": short_op = "pc"; break; case "Oven": short_op = "oven"; break; case "Wet Prep": short_op = "wp"; break; case "Wet Paint": short_op = "wet"; break; case "Oven 2": short_op = "oven1"; break; default: MessageBox.Show("No operation has been selected!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } sqlUpdate.AddToDoor(Int32.Parse(txtSearch.Text), op.CalcTimeRemaining(Int32.Parse(txtSearch.Text), cmdOp.Text.ToString(), finishType) / int.Parse(txtQuantitySame.Text), short_op); //Remove from daily goals sqlUpdate.DeductDailyGoals(op.CalcTimeRemaining(Int32.Parse(txtSearch.Text), cmdOp.Text.ToString(), finishType)); //btnSearch_Click(sender, e); //REFRESH THE MAIN DATAGRID RefreshMainGrid(); } } else { MessageBox.Show("You must select an operation to continue!", "No operation", MessageBoxButtons.OK, MessageBoxIcon.Error); } }