private void radioButton3_CheckedChanged(object sender, EventArgs e) { label4.Show(); numericUpDown2.Show(); radioButton1.Show(); radioButton2.Show(); checkBox1.Text = "Application kit"; label1.Text = "Color"; label2.Text = "Amount used (sheet)"; numericUpDown1.Value = VINYL_DEFAULT_QUANTITY; numericUpDown1.Increment = VINYL_INCREMENT; StickerNameCombo.Hide(); ColorComboBox.Show(); isVinylOrder = true; }
private void button1_Click(object sender, EventArgs e) { //NicsInventory1DataSet.ColorsDataTable Colors; //Add to order tables string ColorName = ColorComboBox.Text; int firstSpace = ColorName.IndexOf(" "); ColorName = ColorName.Substring(0, firstSpace); //int ColorID = Convert.ToInt32(comboBox5.SelectedValue); //MessageBox.Show(boxmessage); SqlConnection conn = new SqlConnection(connstr); using (conn) { conn.Open(); /*using (var cmd = new SqlCommand("SELECT ID FROM Products WHERE VinylType = @VinylType AND ColorID = @ColorID", conn)) * { * cmd.Parameters.AddWithValue("@VinylType", VinylTypeID); * cmd.Parameters.AddWithValue("@ColorID", ColorID); * * int result = Convert.ToInt32(cmd.ExecuteScalar()); * * if (result != 0) * { * prodID = result; * MessageBox.Show("Product ID found"); * } * else * { * MessageBox.Show("No Product found."); * } * }*/ string costTextBox = textBox1.Text; decimal orderPrice; if (!decimal.TryParse(costTextBox, out orderPrice)) { MessageBox.Show("Order not created. Please enter a valid price as #.## or ##"); textBox1.Text = "0.00"; return; } SqlCommand cmdNewOrder = new SqlCommand("spAddOrder", conn); cmdNewOrder.CommandType = CommandType.StoredProcedure; cmdNewOrder.Parameters.Add(new SqlParameter("@pDate", SqlDbType.DateTime)); cmdNewOrder.Parameters["@pDate"].Value = dateTimePicker1.Value; cmdNewOrder.Parameters.Add(new SqlParameter("@pPrice", SqlDbType.Decimal)); cmdNewOrder.Parameters["@pPrice"].Value = orderPrice; cmdNewOrder.Parameters.Add(new SqlParameter("@pID", SqlDbType.Int)); cmdNewOrder.Parameters["@pID"].Direction = ParameterDirection.Output; try { cmdNewOrder.ExecuteNonQuery(); this.OrderID = (int)cmdNewOrder.Parameters["@pID"].Value; string boxmessage = "This returned order #" + OrderID; MessageBox.Show(boxmessage); } catch { //NC-14 A simple catch. MessageBox.Show("Order ID was not returned. Order could not be created."); } if (isVinylOrder) { int prodID = Convert.ToInt32(ColorComboBox.SelectedValue); DataClasses1DataContext context = new DataClasses1DataContext(); //TO DO -- Add product and quantities to a List object and iterate through VinylOrderItem vinylOrderItem = new VinylOrderItem(); vinylOrderItem.ProductID = prodID; vinylOrderItem.OrderID = OrderID; vinylOrderItem.Quantity = numericUpDown1.Value; context.VinylOrderItems.InsertOnSubmit(vinylOrderItem); SecondaryOrderItem TransferTape = new SecondaryOrderItem(); TransferTape.SecondaryID = GetSecondaryItemID(TransferTapeType); TransferTape.OrderID = OrderID; TransferTape.Quantity = numericUpDown2.Value; context.SecondaryOrderItems.InsertOnSubmit(TransferTape); try { context.SubmitChanges(); } catch (Exception ex) { Console.Write(ex.Message); } bool result = Product.Outgoing(prodID, (double)numericUpDown1.Value); if (!result) { MessageBox.Show("There was a problem decreasing vinyl inventory. Tell your wife she did something wrong"); } } else { DataClasses1DataContext context = new DataClasses1DataContext(); StickerOrderItem stickerOrderItem = new StickerOrderItem(); stickerOrderItem.OrderID = OrderID; stickerOrderItem.Quantity = (int)numericUpDown1.Value; stickerOrderItem.StickerID = stickerID; try { context.SubmitChanges(); } catch (Exception ex) { Console.Write(ex.Message); } bool result = Sticker.Outgoing(stickerID, (int)numericUpDown1.Value); if (!result) { MessageBox.Show("There was a problem decreasing sticker inventory. Tell your wife she did something wrong"); } if (Sticker.CheckNotify(stickerID)) { MessageBox.Show("You're getting low on " + Sticker.GetName(stickerID)); } } } //Decrement stock textBox3.Clear(); ScrapLengthTB.Clear(); ScrapWidthTB.Clear(); textBox6.Clear(); textBox1.Text = "0.00"; checkBox1.Checked = false; checkBox5.Checked = false; numericUpDown1.Value = VINYL_DEFAULT_QUANTITY; numericUpDown2.Value = TRANSFER_TAPE_DEFAULT_QUANTITY; ColorComboBox.Show(); StickerNameCombo.Hide(); }