public int AddPartRequest(PartRequest request)
{
{
String now = DateTime.Now.ToString();
OleDbCommand cmd = new OleDbCommand();
if (request.mContactId < 1)
{
cmd.CommandText = "INSERT INTO " + REQUESTTABLE + " ([Requestor], [RequestedOn], [PartNumber], [Instructions], [PO], [SerialNumber], " +
"[Quantity], [Hot], [CR Ready], [Cage], [Bulk], [Description]) " +
"VALUES (@requestor, @requestedOn, @part, @instructions, @po, @serial, @qty, @hot, @cr, @cage, @bulk, @desc)";
}
else
{
cmd.CommandText = "INSERT INTO " + REQUESTTABLE + " ([Contact], [Requestor], [RequestedOn], [PartNumber], [Instructions], [PO], [SerialNumber], " +
"[Quantity], [Hot], [CR Ready], [Cage], [Bulk], [Description]) " +
"VALUES (@contact, @requestor, @requestedOn, @part, @instructions, @po, @serial, @qty, @hot, @cr, @cage, @bulk, @desc)";
cmd.Parameters.AddWithValue("@contact", request.mContactId);
}
cmd.Parameters.AddWithValue("@requestor", request.mRequestor);
cmd.Parameters.AddWithValue("@requestedOn", now);
cmd.Parameters.AddWithValue("@part", request.mPart);
cmd.Parameters.AddWithValue("@instructions", request.mInstructions);
cmd.Parameters.AddWithValue("@po", request.mPO);
cmd.Parameters.AddWithValue("@serial", request.mSerial);
cmd.Parameters.AddWithValue("@qty", request.mQty);
cmd.Parameters.AddWithValue("@hot", request.mHot);
cmd.Parameters.AddWithValue("@cr", request.mCleanroomReady);
cmd.Parameters.AddWithValue("@cage", request.mCage);
cmd.Parameters.AddWithValue("@bulk", request.mBulk);
cmd.Parameters.AddWithValue("@desc", request.mDescription);
return(requestDB.AddReturnID(cmd));
}
}
private void AddPart(PartRequest req)
{
mProgress = new ProgressBarForm();
bGWorkerAddPart = new BackgroundWorker();
bGWorkerAddPart.DoWork += new DoWorkEventHandler(bGWorkerAddPart_DoWork);
bGWorkerAddPart.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bGWorkerAddPart_RunWorkerCompleted);
bGWorkerAddPart.RunWorkerAsync(req);
mProgress.ShowDialog();
}
private void btnPartCleanRequest_Click(object sender, EventArgs e)
{
errorProviderPartRequestForm.Clear();
mPartRequest = new PartRequest();
bool submittable = true;
// Requestor Empty
if (textBoxRequestor.Text.Trim() == "" || textBoxRequestor.Text == null)
{
errorProviderPartRequestForm.SetError(textBoxRequestor, "Enter Your Name");
textBoxRequestor.Text = "";
submittable = false;
}
// Requestor Not empty
else
{
mPartRequest.mRequestor = textBoxRequestor.Text.Trim().ToString();
}
// Standard
if (rBtnStandard.Checked)
{
//No Part Selected
if (comboBoxPart.SelectedIndex == -1)
{
errorProviderPartRequestForm.SetError(comboBoxPart, "Enter Part Number");
submittable = false;
}
//Part Selected
else
{
int index = comboBoxPart.FindString(comboBoxPart.Text);
if (index < 0)
{
errorProviderPartRequestForm.SetError(comboBoxPart, "Part Number Not Found");
submittable = false;
}
else
{
mPartRequest.mPart = comboBoxPart.SelectedValue.ToString();
foreach (DataRow row in mPartTable.Rows)
{
if (mPartRequest.mPart == row["Part"].ToString())
{
if (!(row["Description"].ToString() == "" | row["Description"].Equals(null)))
{
mPartRequest.mDescription = row["Description"].ToString();
}
else
{
mPartRequest.mDescription = "";
}
}
}
}
}
}
//Non Standard
else
{
if (!(textBoxDescription.Text.Trim() == "" || textBoxDescription.Text == null))
{
mPartRequest.mPart = "Non - Standard";
mPartRequest.mDescription = textBoxDescription.Text.Trim();
}
else
{
errorProviderPartRequestForm.SetError(textBoxDescription, "Enter Description for Non Standard Part");
submittable = false;
}
}
if (!(textBoxInstructions.Text.Trim() == "" || textBoxInstructions.Text.ToString() == null))
{
mPartRequest.mInstructions = textBoxInstructions.Text.Trim().ToString();
}
else
{
if (rBtnNonStandard.Checked)
{
errorProviderPartRequestForm.SetError(textBoxInstructions, "Instructions required for Non-Standard Part");
submittable = false;
}
else
{
mPartRequest.mInstructions = "";
}
}
if (comboBoxContact.SelectedIndex == 0)
{
mPartRequest.mContactId = 1;
}
else
{
mPartRequest.mContactId = int.Parse(comboBoxContact.SelectedValue.ToString());
}
if (!(textBoxPO.Text.ToString() == "" || textBoxPO.Text.ToString() == null))
{
mPartRequest.mPO = textBoxPO.Text.Trim().ToString();
}
else
{
mPartRequest.mPO = "";
}
if (!(textBoxSerialNumber.Text.Trim().ToString() == "" || textBoxSerialNumber.Text.Trim().ToString() == null))
{
mPartRequest.mSerial = textBoxSerialNumber.Text.Trim().ToString();
}
else
{
mPartRequest.mSerial = "";
}
mPartRequest.mQty = (int)numericUpDownQty.Value;
if (checkBoxHot.Checked)
{
mPartRequest.mHot = true;
}
else
{
mPartRequest.mHot = false;
}
if (radioButtonCRYes.Checked == true || radioButtonCRNo.Checked == true)
{
if (radioButtonCRYes.Checked == true)
{
mPartRequest.mCleanroomReady = true;
if (radioButtonCage.Checked == true || radioButtonBulk.Checked == true)
{
if (radioButtonCage.Checked == true)
{
mPartRequest.mCage = true;
}
else
{
mPartRequest.mBulk = true;
}
}
else
{
errorProviderPartRequestForm.SetError(gBoxStockLocation, "Cage or Bulk");
submittable = false;
}
}
else
{
mPartRequest.mCleanroomReady = false;
}
}
else
{
errorProviderPartRequestForm.SetError(radioButtonCRNo, "Cleanroom Ready, Yes or No");
submittable = false;
}
if (submittable)
{
AddPart(mPartRequest);
}
}