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