private void NewPartToolStripMenuItem_Click(object sender, EventArgs e) { NewPart np = new NewPart(this); np.FormClosed += new FormClosedEventHandler(VendorSetupClosed); np.Show(); }
private void Part_combo_SelectedIndexChanged(object sender, EventArgs e) { if (part_combo.SelectedIndex == 1) { NewPart np = new NewPart(ms); np.FormClosed += new FormClosedEventHandler(PartSetupClosed); np.Show(); } else { try { using (SqlConnection conn = new SqlConnection(conn_string)) { q = "SELECT PartID, PartDescription, UnitPrice " + "FROM Parts " + "WHERE PartNumber = '" + part_combo.Text + "'"; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = q; DataTable td = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(q, conn); conn.Open(); da.Fill(td); conn.Close(); desc_txb.Text = td.Rows[0].ItemArray[1].ToString(); price_txb.Text = td.Rows[0].ItemArray[2].ToString(); } int qty = Convert.ToInt16(qty_txb.Text); decimal price = Convert.ToDecimal(price_txb.Text); decimal total = qty * price; total_txb.Text = total.ToString(); } catch { } } }
private void AddToOrder_btn_Click(object sender, EventArgs e) { Get_PartID(part_combo.Text); switch (partID) { case 0: if (MessageBox.Show("Part does not exist! \nDo you want to Add " + part_combo.Text + " to the Parts table?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { string partnumber = part_combo.Text; string partdescription = desc_txb.Text; decimal unitprice = Convert.ToDecimal(price_txb.Text); NewPart np = new NewPart(ms); using (SqlConnection conn = new SqlConnection(conn_string)) { q = "SELECT PartID, PartDescription, UnitPrice " + "FROM Parts " + "WHERE PartID = '" + np.Save_Part_With_Return(partnumber, partdescription, unitprice) + "'"; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = q; DataTable td = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(q, conn); conn.Open(); da.Fill(td); conn.Close(); desc_txb.Text = td.Rows[0].ItemArray[1].ToString(); price_txb.Text = td.Rows[0].ItemArray[2].ToString(); } int qty = Convert.ToInt16(qty_txb.Text); decimal price = Convert.ToDecimal(price_txb.Text); decimal total = qty * price; total_txb.Text = total.ToString(); Fill_Part_ComboBox(); } break; default: newOrderDetails_dataGridView.Rows.Add(new String[] { qty_txb.Text, unit_combo.Text, part_combo.SelectedValue.ToString(), part_combo.Text, desc_txb.Text, price_txb.Text, per_combo.Text, DBNull.Value.ToString(), "False", total_txb.Text, }); newOrderDetails_dataGridView.Sort(part, ListSortDirection.Ascending); qty_txb.Clear(); unit_combo.SelectedIndex = 0; part_combo.SelectedIndex = 0; desc_txb.Clear(); price_txb.Clear(); per_combo.SelectedIndex = 0; total_txb.Clear(); partID = 0; break; } }
private void AddToOrder_btn_Click(object sender, EventArgs e) { Get_PartID(part_comboBox.Text); switch (partid) { case 0: if (MessageBox.Show("Part does not exist! \nDo you want to Add " + part_comboBox.Text + " to the Parts table?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { string partnumber = part_comboBox.Text; string partdescription = partDesc_textbox.Text; decimal unitprice = 0; NewPart np = new NewPart(ms); using (SqlConnection conn = new SqlConnection(conn_string)) { string q = "SELECT PartID, PartDescription, UnitPrice " + "FROM Parts " + "WHERE PartID = '" + np.Save_Part_With_Return(partnumber, partdescription, unitprice) + "'"; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = q; DataTable td = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(q, conn); conn.Open(); da.Fill(td); conn.Close(); partDesc_textbox.Text = td.Rows[0].ItemArray[1].ToString(); } int qty = Convert.ToInt16(qty_textBox.Text); decimal price = Convert.ToDecimal(0); Part_comboBox_Fill(); } else { dataGridView1.Rows.Add(new String[] { DBNull.Value.ToString(), DBNull.Value.ToString(), DBNull.Value.ToString(), DBNull.Value.ToString(), textBox2.Text, }); } break; default: if (stock_radioButton.Checked == true) { stock = true; } else if (ordered_radioButton.Checked == true) { stock = false; } dataGridView1.Rows.Add(new String[] { part_comboBox.SelectedValue.ToString(), qty_textBox.Text, partDesc_textbox.Text, stock.ToString(), textBox2.Text, }); dataGridView1.Sort(part, ListSortDirection.Ascending); qty_textBox.Clear(); partDesc_textbox.Clear(); textBox2.Clear(); break; } }