private void btnComplete_Click(object sender, EventArgs e) { if (this.ValidateChildren(ValidationConstraints.Enabled)) { Allocation a = new Allocation(cmbDepartmentResponsible.Text, Convert.ToInt32(txtDoorID.Text)); //UPDATE REPAINT INFORMATION SqlConnection myConnection = new SqlConnection(SqlStatements.ConnectionString); myConnection.Open(); var sb = string.Format("UPDATE dbo.repaints set painter_name = @responsibleStaff, [department] = @responsibleDept, repaint_checker_note = @reason, sanding_exposure_points = @sandingExposurePoints, sanding_time= @sandingTime,sanded_by_id = @sandedById, repaint_by= @repaint_by,paint_kg_used = @paint_kg_used, repaint_complete = @complete, date_painted = @date_painted WHERE id=@repaint_id"); SqlCommand command = new SqlCommand(sb, myConnection); command.Parameters.AddWithValue("@repaint_id", this.txtRepaintID.Text); command.Parameters.AddWithValue("@paint_kg_used", this.txtKgs.Text); command.Parameters.AddWithValue("@date_painted", DateTime.Now); command.Parameters.AddWithValue("@repaint_by", this.cmbRepaintBy.SelectedValue); command.Parameters.AddWithValue("@complete", -1); command.Parameters.AddWithValue("@reason", this.txtReason.Text); command.Parameters.AddWithValue("@responsibleStaff", a._allocatedTo); command.Parameters.AddWithValue("@responsibleDept", a._departmentOut); if (rdoYes.Checked == true) { command.Parameters.AddWithValue("@sandingTime", this.txtMins.Text); command.Parameters.AddWithValue("@sandedById", this.cmbSandBy.SelectedValue); command.Parameters.AddWithValue("@sandingExposurePoints", (Convert.ToDouble(this.txtMins.Text) / 60) * Convert.ToDouble(this.cmbTool.SelectedValue)); } else { command.Parameters.AddWithValue("@sandingTime", DBNull.Value); command.Parameters.AddWithValue("@sandedById", DBNull.Value); command.Parameters.AddWithValue("@sandingExposurePoints", DBNull.Value); } command.ExecuteNonQuery(); //UPDATE STOCK SqlStatements sql = new SqlStatements(); sql.UpdatePaintStock(int.Parse(txtPaintID.Text), int.Parse(txtKgs.Text)); MessageBox.Show("Repaint Completed Successfully.", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("All fields must be filled in before completing the repaint!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { //this.ValidateChildren(); if (this.ValidateChildren(ValidationConstraints.Enabled)) { String ConnectionString = SqlStatements.ConnectionString; //MessageBox.Show(this.cmbEmployee.SelectedValue.ToString()); int door_id = Int32.Parse(this.txtDoorId.Text.ToString()); int paint_id = get_paint_id(Int32.Parse(this.txtDoorId.Text.ToString())); SqlConnection myConnection = new SqlConnection(ConnectionString); myConnection.Open(); //INSERTS NEW RECORDS INTO DBO DOOR PART COMPLETION LOG var sb = string.Format("INSERT into dbo.repaints(sanding_exposure_points,paint_id, paint_kg_used, painter_name, department, door_id, repaint_checker_note,repaint_by, repaint_time,logged_by_id,repaint_complete,date_logged,repaint_from_dept,sanding_time,sanded_by_id) VALUES " + "(@sandingExposurePoints,@paint_id,@paint_kg_used,@painter_name,@department,@door_id,@reason,@repaint_by,@repaint_time,@logged_by,@complete,@date_logged,@repaint_from_dept,@sandingTime,@sandedById)"); SqlCommand command = new SqlCommand(sb, myConnection); command.Parameters.AddWithValue("@paint_id", paint_id); command.Parameters.AddWithValue("@paint_kg_used", this.txtKgs.Text); //command.Parameters.AddWithValue("@date_painted", DateTime.Now); command.Parameters.AddWithValue("@painter_name", this.cmbEmployee.SelectedValue); command.Parameters.AddWithValue("@department", this.cmbDepartment.SelectedValue); command.Parameters.AddWithValue("@door_id", door_id); command.Parameters.AddWithValue("@reason", this.txtReason.Text); command.Parameters.AddWithValue("@repaint_by", this.cmbRepaintBy.SelectedValue); command.Parameters.AddWithValue("@repaint_time", 0); command.Parameters.AddWithValue("@logged_by", this.cmbLoggedBy.SelectedValue); command.Parameters.AddWithValue("@complete", 0); command.Parameters.AddWithValue("@date_logged", DateTime.Now); if (rdoYes.Checked == true) { command.Parameters.AddWithValue("@sandingTime", this.txtMins.Text); command.Parameters.AddWithValue("@sandedById", this.cmbSandBy.SelectedValue); command.Parameters.AddWithValue("@sandingExposurePoints", (Convert.ToDouble(this.txtMins.Text) / 60) * Convert.ToDouble(this.cmbTool.SelectedValue)); } else { command.Parameters.AddWithValue("@sandingTime", DBNull.Value); command.Parameters.AddWithValue("@sandedById", DBNull.Value); command.Parameters.AddWithValue("@sandingExposurePoints", DBNull.Value); } command.Parameters.AddWithValue("@repaint_from_dept", string.Format("Painting")); command.ExecuteNonQuery(); SqlStatements sql = new SqlStatements(); sql.UpdatePaintStock(int.Parse(paint_id.ToString()), int.Parse(txtKgs.Text)); this.Close(); } else { MessageBox.Show("There are invalid entries on the form. Please fill out all input areas", "Errors", MessageBoxButtons.OK, MessageBoxIcon.Error); } }